An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 10-30-2025 23:17:53
Array
(
[_GET] => Array
(
[slug] => Casa-Mi-Corazon-es-Del-Mar
)
[_POST] => Array
(
)
[_COOKIE] => Array
(
)
[_FILES] => Array
(
)
[_SERVER] => Array
(
[LSPHP_ENABLE_USER_INI] => on
[PATH] => /usr/local/bin:/usr/bin:/bin
[TEMP] => /tmp
[TMP] => /tmp
[TMPDIR] => /tmp
[PWD] => /
[HTTP_ACCEPT] => */*
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[CONTENT_LENGTH] => 0
[HTTP_HOST] => www.loscabosvacation.com
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_X_HTTPS] => 1
[REDIRECT_UNIQUE_ID] => aQPyIZ8dUqDs_McNIP3KxAAAiQg
[REDIRECT_SCRIPT_URL] => /san-jose/Casa-Mi-Corazon-es-Del-Mar
[REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-Mi-Corazon-es-Del-Mar
[REDIRECT_USER_ID] => 7984084
[REDIRECT_HTTPS] => on
[REDIRECT_SSL_TLS_SNI] => www.loscabosvacation.com
[REDIRECT_HTTP2] => on
[REDIRECT_H2PUSH] => off
[REDIRECT_H2_PUSH] => off
[REDIRECT_H2_PUSHED] =>
[REDIRECT_H2_PUSHED_ON] =>
[REDIRECT_H2_STREAM_ID] => 1
[REDIRECT_H2_STREAM_TAG] => 2962293-141-1
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => aQPyIZ8dUqDs_McNIP3KxAAAiQg
[SCRIPT_URL] => /san-jose/Casa-Mi-Corazon-es-Del-Mar
[SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-Mi-Corazon-es-Del-Mar
[USER_ID] => 7984084
[HTTPS] => on
[SSL_TLS_SNI] => www.loscabosvacation.com
[HTTP2] => on
[H2PUSH] => off
[H2_PUSH] => off
[H2_PUSHED] =>
[H2_PUSHED_ON] =>
[H2_STREAM_ID] => 1
[H2_STREAM_TAG] => 2962293-141-1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.loscabosvacation.com
[SERVER_ADDR] => 50.63.7.156
[SERVER_PORT] => 443
[REMOTE_ADDR] => 216.73.216.31
[DOCUMENT_ROOT] => /home/ald70w428ld7/public_html
[REQUEST_SCHEME] => https
[CONTEXT_PREFIX] =>
[CONTEXT_DOCUMENT_ROOT] => /home/ald70w428ld7/public_html
[SERVER_ADMIN] => webmaster@loscabosvacation.com
[SCRIPT_FILENAME] => /home/ald70w428ld7/public_html/san-jose/detail.php
[REMOTE_PORT] => 38349
[REDIRECT_URL] => /san-jose/Casa-Mi-Corazon-es-Del-Mar
[REDIRECT_QUERY_STRING] => slug=Casa-Mi-Corazon-es-Del-Mar
[SERVER_PROTOCOL] => HTTP/2.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => slug=Casa-Mi-Corazon-es-Del-Mar
[REQUEST_URI] => /san-jose/Casa-Mi-Corazon-es-Del-Mar
[SCRIPT_NAME] => /san-jose/detail.php
[PHP_SELF] => /san-jose/detail.php
[REQUEST_TIME_FLOAT] => 1761866273.29
[REQUEST_TIME] => 1761866273
)
[contact_email] => tgranzo@earthlink.net
[debug] => 1
[db] => mysqli Object
(
[affected_rows] => 0
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.6.23-MariaDB-cll-lve
[server_version] => 50505
[stat] => Uptime: 828730 Threads: 92 Questions: 215574604 Slow queries: 377 Opens: 2895721 Open tables: 5000 Queries per second avg: 260.126
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 4343027
[warning_count] => 0
)
[_REQUEST] => Array
(
[slug] => Casa-Mi-Corazon-es-Del-Mar
)
[todayMysql] => 20251030
[today] => 10/30/2025
[today0] => 10/30/2025
[todayDB] => 20251030231753
[sdbc] => mysqli Object
(
[affected_rows] => 0
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 1
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.6.23-MariaDB-cll-lve
[server_version] => 50505
[stat] => Uptime: 828730 Threads: 92 Questions: 215574605 Slow queries: 377 Opens: 2895721 Open tables: 5000 Queries per second avg: 260.126
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 4343028
[warning_count] => 0
)
[_SESSION] => Array
(
)
[slug] => Yoga
[pid] => 21
[thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=21
[showSlides] => 1
[qry] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] => Array
(
[0] => 2
[1] => 4
[2] => 4
[3] => 0
)
[num_rows] => 15
[type] => 0
)
[qry_total] => 15
[rs] => Array
(
[id] => 30
[name] => Yoga
[slug] => Yoga
[page_name] =>
)
[property_name] => Casa Mi Corazon es Del Mar
[description] => This beautiful 6 bedroom 6 ½ bath villa with pool and spa is located right on the beach in the Palmilla Norte subdivision of the Palmilla Development.
There are 4 master suite bedrooms with adjoining bathrooms with king size beds and 2 master suites with 2 doubles in each.
Large pool area with ping pong table, BBQ and Punta Palmilla to Punta Gorda Spectacular Sea of Cortez Sunrise Views.
[special_note] =>
[short_desc] => This beautiful 6 bedroom 6 ½ bath villa with pool and spa is located right on the beach in the Palmilla Norte subdivision of the Palmilla Development. There are 4 master suite bedrooms with adjoining bathrooms with king size beds and 2 master suites with 2 doubles in each.
[meta_title] => Los Cabos Palmilla Villas Corizon es del Mar
[meta_keys] => palmilla los cabos villa san jose del cabo beach front 6 bedrooms
[meta_desc] => Los Cabos Palmilla Villa 6 bedrooms beachfront
[show_avail] => 0
[link] =>
[calendar] => 0
[no_beds] => 6
[rating] => 4
[sleeps] => 12
[sqft_inside] => 5000
[sqft_outside] => 2500
[low_rate] => 3000
[high_rate] => 4000
[rate_note] =>
[max_guests] =>
[pageName] => detail.php
[myPath] => https://www.loscabosvacation.com/
[feat_count] => 16
[browser] => NA
[i] => 15
[cid] => 30
[slides] =>
[slidePath] => https://www.loscabosvacation.com/properties/slides/large/
[thumbPath] => https://www.loscabosvacation.com/properties/slides/thumbs/
[thumbs] =>
[qryS] => mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] =>
[num_rows] => 19
[type] => 0
)
[qryB_total] => 19
)

This beautiful 6 bedroom 6 ½ bath villa with pool and spa is located right on the beach in the Palmilla Norte subdivision of the Palmilla Development.
There are 4 master suite bedrooms with adjoining bathrooms with king size beds and 2 master suites with 2 doubles in each.
Large pool area with ping pong table, BBQ and Punta Palmilla to Punta Gorda Spectacular Sea of Cortez Sunrise Views.
$3000 - $4000 / night
*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes
6 bedrooms.
Maximum # of guests: 12
Interior square footage: 5000
Exterior square footage: 2500
Total square footage: 7500