An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 9-30-2023 08:59:51
Array ( [_GET] => Array ( [slug] => Villa-Los-Amigos ) [_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.6.51-cll-lve [server_version] => 50651 [stat] => Uptime: 205576 Threads: 5 Questions: 63523174 Slow queries: 10 Opens: 136577 Flush tables: 10 Open tables: 2297 Queries per second avg: 309.000 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 448082 [warning_count] => 0 ) [_REQUEST] => Array ( [slug] => Villa-Los-Amigos ) [todayMysql] => 20230930 [today] => 9/30/2023 [today0] => 09/30/2023 [todayDB] => 20230930085951 [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.6.51-cll-lve [server_version] => 50651 [stat] => Uptime: 205576 Threads: 4 Questions: 63523176 Slow queries: 10 Opens: 136577 Flush tables: 10 Open tables: 2297 Queries per second avg: 309.000 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 448083 [warning_count] => 0 ) [_SESSION] => Array ( ) [slug] => Yoga [pid] => 19 [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=19 [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 Los Amigos [description] =>This Beautiful 5 bedroom 5 1/2 bath 4200 sq. ft. villa with pool and spa is located just a short walk from the beach in the Palmilla Norte development close to the famous Palmilla Hotel.
There are 4 master suites, 2 have a king in each and 2 have 2 queens in each with guest apartment haveing a queen size bed. White water views, spectacular sunrises over the Sea of Cortez are just two of the many assets to this lovely location.
[special_note] =>Click Here For 360 Virtual Tiour
[short_desc] =>This Beautiful 5 bedroom 5 1/2 bath 4200 sq. ft. villa with pool and spa is located just a short walk from the beach in the Palmilla Norte development close to the famous Palmilla Hotel. Beautiful Sunrise white water views over the Sea of Cortez are just part of this beautiful location.
[meta_title] => Villa Los Amigos Palmilla Villa Los Cabos Mexico 5 Bedrooms [meta_keys] => los cabos villa palmilla hotel san jose del cabo [meta_desc] => Los Cabos Palmilla Villa Mexico Vacation Rental 5 Bedrooms [show_avail] => 1 [link] => http://www.homeawayconnect.com/calendar.aspx?propertyid=83239&culturename=en-US&mode=1 [calendar] => 1 [no_beds] => 5 [rating] => 4 [sleeps] => 12 [sqft_inside] => 4200 [sqft_outside] => 1000 [low_rate] => 750 [high_rate] => 1250 [rate_note] =>7th night free!
[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] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_ENCODING] => br,gzip [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_CONNECTION] => Keep-Alive [CONTENT_LENGTH] => 0 [HTTP_HOST] => www.loscabosvacation.com [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/) [HTTP_X_HTTPS] => 1 [REDIRECT_UNIQUE_ID] => ZRfjhyCbZD6eMBeyrGcL4AAAATA [REDIRECT_SCRIPT_URL] => /san-jose/Villa-Los-Amigos [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Villa-Los-Amigos [REDIRECT_USER_ID] => 7984084 [REDIRECT_HTTPS] => on [REDIRECT_SSL_TLS_SNI] => www.loscabosvacation.com [REDIRECT_STATUS] => 200 [UNIQUE_ID] => ZRfjhyCbZD6eMBeyrGcL4AAAATA [SCRIPT_URL] => /san-jose/Villa-Los-Amigos [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Villa-Los-Amigos [USER_ID] => 7984084 [HTTPS] => on [SSL_TLS_SNI] => www.loscabosvacation.com [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 44.197.111.121 [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] => 37426 [REDIRECT_URL] => /san-jose/Villa-Los-Amigos [REDIRECT_QUERY_STRING] => slug=Villa-Los-Amigos [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => slug=Villa-Los-Amigos [REQUEST_URI] => /san-jose/Villa-Los-Amigos [SCRIPT_NAME] => /san-jose/detail.php [PHP_SELF] => /san-jose/detail.php [REQUEST_TIME_FLOAT] => 1696064391.7 [REQUEST_TIME] => 1696064391 ) [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] => 23 [type] => 0 ) [qryB_total] => 23 )
This Beautiful 5 bedroom 5 1/2 bath 4200 sq. ft. villa with pool and spa is located just a short walk from the beach in the Palmilla Norte development close to the famous Palmilla Hotel.
There are 4 master suites, 2 have a king in each and 2 have 2 queens in each with guest apartment haveing a queen size bed. White water views, spectacular sunrises over the Sea of Cortez are just two of the many assets to this lovely location.
$750 - $1250 / night
7th night free!
*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes
5 bedrooms.
Maximum # of guests: 12
Interior square footage: 4200
Exterior square footage: 1000
Total square footage: 5200