An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 3-28-2024 19:00:02

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.5.5-10.6.16-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 1301493  Threads: 100  Questions: 159539386  Slow queries: 12  Opens: 381756  Open tables: 3681  Queries per second avg: 122.581
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3566181
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Villa-Los-Amigos
        )

    [todayMysql] => 20240328
    [today] => 3/28/2024
    [today0] => 03/28/2024
    [todayDB] => 20240328190002
    [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.16-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 1301493  Threads: 100  Questions: 159539386  Slow queries: 12  Opens: 381756  Open tables: 3681  Queries per second avg: 122.581
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3566182
            [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] =>

Google Map Link Click Here!

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!

Click Here for You Tube Video


[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_USER_AGENT] => claudebot [HTTP_X_HTTPS] => 1 [REDIRECT_UNIQUE_ID] => ZgW-McI7FUWP1wDSS4OcyQAAyR8 [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_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] => 3654065-749-3 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => ZgW-McI7FUWP1wDSS4OcyQAAyR8 [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 [HTTP2] => on [H2PUSH] => off [H2_PUSH] => off [H2_PUSHED] => [H2_PUSHED_ON] => [H2_STREAM_ID] => 3 [H2_STREAM_TAG] => 3654065-749-3 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 54.210.126.232 [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] => 35656 [REDIRECT_URL] => /san-jose/Villa-Los-Amigos [REDIRECT_QUERY_STRING] => slug=Villa-Los-Amigos [SERVER_PROTOCOL] => HTTP/2.0 [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] => 1711652402.04 [REQUEST_TIME] => 1711652402 ) [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 )

Villa Los Amigos - 4

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.

Rates

$750 - $1250 / night

7th night free!

Click Here for You Tube Video


*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes

Amenities

  • Air Conditioning
  • Ceiling Fans
  • Gas BBQ
  • Outdoor Stereo
  • Satellite TV
  • Spa
  • Stereo
  • Swimming Pool (Outdoor)

Sleeping Accomodations!

5 bedrooms.

  • King Suite
  • Queen Suite
  • Queen Suite
  • King Suite
  • Guest Apartment

Additional Information

Maximum # of guests: 12

Interior square footage: 4200
Exterior square footage: 1000
Total square footage: 5200