An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 9-19-2025 07:51:53
Array ( [_GET] => Array ( [slug] => Villa-Cielito ) [_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] => aM0LmeJGzn4kOAoYXCIUTQABAh4 [REDIRECT_SCRIPT_URL] => /san-jose/Villa-Cielito [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Villa-Cielito [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] => 5 [REDIRECT_H2_STREAM_TAG] => 3133753-34-5 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => aM0LmeJGzn4kOAoYXCIUTQABAh4 [SCRIPT_URL] => /san-jose/Villa-Cielito [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Villa-Cielito [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] => 5 [H2_STREAM_TAG] => 3133753-34-5 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 216.73.216.145 [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] => 24513 [REDIRECT_URL] => /san-jose/Villa-Cielito [REDIRECT_QUERY_STRING] => slug=Villa-Cielito [SERVER_PROTOCOL] => HTTP/2.0 [REQUEST_METHOD] => GET [QUERY_STRING] => slug=Villa-Cielito [REQUEST_URI] => /san-jose/Villa-Cielito [SCRIPT_NAME] => /san-jose/detail.php [PHP_SELF] => /san-jose/detail.php [REQUEST_TIME_FLOAT] => 1758268313.77 [REQUEST_TIME] => 1758268313 ) [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.22-MariaDB-cll-lve [server_version] => 50505 [stat] => Uptime: 1969823 Threads: 101 Questions: 975798412 Slow queries: 700 Opens: 6695958 Open tables: 5000 Queries per second avg: 495.373 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 13942632 [warning_count] => 0 ) [_REQUEST] => Array ( [slug] => Villa-Cielito ) [todayMysql] => 20250919 [today] => 9/19/2025 [today0] => 09/19/2025 [todayDB] => 20250919075153 [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.22-MariaDB-cll-lve [server_version] => 50505 [stat] => Uptime: 1969823 Threads: 101 Questions: 975798413 Slow queries: 700 Opens: 6695958 Open tables: 5000 Queries per second avg: 495.373 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 13942633 [warning_count] => 0 ) [_SESSION] => Array ( ) [slug] => Yoga [pid] => 73 [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=73 [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] => Villa Cielito [description] =>Villa Cielito is an 7 bedroom beach front villa located right on the beach in Chileno Bay.
This awesome property was built back in the 1970's and has the old time feel of the way Los Cabos used to be with views of the famous Hotel Cabo San Lucas[special_note] =>
Please Click Here For Google Map!
[short_desc] =>Villa Cielito is an 7 bedroom beach front villa located right on the beach in Chileno Bay.
This awesome property was built back in the 1970's and has the old time feel of the way Los Cabos used to be with views of the famous Hotel Cabo San Lucas
[meta_title] => Villa Cielito Chileno Bay Beach Front Los Cabos Villa 8 Bedrooms [meta_keys] => Villa Cielito Chileno Bay Beach Front los Cabos Villa 8 Bedrooms [meta_desc] => Villa Cielito Chileno Bay Beach Front Los Cabos Villa 8 Bedrooms [show_avail] => 1 [link] => [calendar] => 1 [no_beds] => 7 [rating] => 4 [sleeps] => 16 [sqft_inside] => 10000 [sqft_outside] => 5000 [low_rate] => 3400 [high_rate] => 3400 [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] => 61 [type] => 0 ) [qryB_total] => 61 )
Villa Cielito is an 7 bedroom beach front villa located right on the beach in Chileno Bay.
This awesome property was built back in the 1970's and has the old time feel of the way Los Cabos used to be with views of the famous Hotel Cabo San Lucas
$3400 - $3400 / night
Please Click Here For You Tube Video!
*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes
7 bedrooms.
Maximum # of guests: 16
Interior square footage: 10000
Exterior square footage: 5000
Total square footage: 15000