An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 5-8-2024 03:49:53
Array ( [_GET] => Array ( [slug] => Villa-Cielito ) [_POST] => Array ( ) [_COOKIE] => Array ( ) [_FILES] => Array ( ) [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] => p3plcpnl1131.prod.phx3.secureserver.net via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.5-10.6.17-MariaDB-cll-lve [server_version] => 50505 [stat] => Uptime: 695675 Threads: 8 Questions: 1435480 Slow queries: 0 Opens: 8094 Open tables: 59 Queries per second avg: 2.063 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 374984 [warning_count] => 0 ) [_REQUEST] => Array ( [slug] => Villa-Cielito ) [todayMysql] => 20240508 [today] => 5/8/2024 [today0] => 05/08/2024 [todayDB] => 20240508034953 [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] => p3plcpnl1131.prod.phx3.secureserver.net via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.5-10.6.17-MariaDB-cll-lve [server_version] => 50505 [stat] => Uptime: 695675 Threads: 8 Questions: 1435480 Slow queries: 0 Opens: 8094 Open tables: 59 Queries per second avg: 2.063 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 374985 [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 [_SERVER] => Array ( [LSPHP_ENABLE_USER_INI] => on [PATH] => /usr/local/bin:/usr/bin:/bin [TEMP] => /tmp [TMP] => /tmp [TMPDIR] => /tmp [PWD] => / [HTTP_ACCEPT] => */* [CONTENT_LENGTH] => 0 [HTTP_HOST] => www.loscabosvacation.com [HTTP_REFERER] => http://www.loscabosvacation.com/san-jose/Villa-Cielito [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] => Zjr2YS5GSS8H7asY_tMnngAAJko [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] => 3 [REDIRECT_H2_STREAM_TAG] => 401121-161-3 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => Zjr2YS5GSS8H7asY_tMnngAAJko [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] => 3 [H2_STREAM_TAG] => 401121-161-3 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 18.119.107.96 [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] => 20004 [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] => 1715140193.39 [REQUEST_TIME] => 1715140193 ) [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