An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 5-16-2024 22:08:53

Array
(
    [_GET] => Array
        (
            [pid] => 3
        )

    [_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: 1452815  Threads: 6  Questions: 2928886  Slow queries: 0  Opens: 15815  Open tables: 1004  Queries per second avg: 2.016
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 774665
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [pid] => 3
        )

    [todayMysql] => 20240516
    [today] => 5/16/2024
    [today0] => 05/16/2024
    [todayDB] => 20240516220853
    [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: 1452815  Threads: 6  Questions: 2928886  Slow queries: 0  Opens: 15815  Open tables: 1004  Queries per second avg: 2.016
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 774666
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

    [slug] => Yoga
    [pid] => 3
    [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=3
    [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 Castillo Escondido
    [description] => 

This beautiful 6000 sq. ft, 4 bedroom, 4 1/2 bath villa sits right on the beach in la Laguna just 5 miles up the coast from San Jose del Cabo.

Beautiful pool area with spa and palapa covered lounge area lets you enjoy your sunset margaritas in style. Four ocean view master suites with California King size beds and adjoining private bathrooms make this location perfect for 4 couples or 2 families.

[special_note] =>

Please Click Here for You Tube Video Link!

Google Map Link Click Here!

[short_desc] =>

This beautiful 6000 sq. ft, 4 bedroom, 4 1/2 bath villa sits right on the beach in la Laguna just 5 miles up the coast from San Jose del Cabo.

[meta_title] => Villa Castillo Escondido - Los Cabos Villas Mexico Vacation Rental 5 Bedrooms [meta_keys] => los cabos villas beach front san jose del cabo vacation rental [meta_desc] => Villa Castillo Escondido - Los Cabos Villas Mexico Vacation Rental 4 Bedrooms [show_avail] => 0 [link] => https://www.homeawayconnect.com/calendar.aspx?propertyid=414018&culturename=en-US&mode=1 [calendar] => 0 [no_beds] => 4 [rating] => 5 [sleeps] => 10 [sqft_inside] => 6000 [sqft_outside] => 0 [low_rate] => 1000 [high_rate] => 1600 [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] => */* [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 [UNIQUE_ID] => ZkaD9RAiIYgeFOjobNCAAgADDBI [SCRIPT_URL] => /san-jose/detail.php [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/detail.php [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] => 3667622-369-1 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 3.137.199.182 [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] => 48013 [SERVER_PROTOCOL] => HTTP/2.0 [REQUEST_METHOD] => GET [QUERY_STRING] => pid=3 [REQUEST_URI] => /san-jose/detail.php?pid=3 [SCRIPT_NAME] => /san-jose/detail.php [PHP_SELF] => /san-jose/detail.php [REQUEST_TIME_FLOAT] => 1715897333.79 [REQUEST_TIME] => 1715897333 ) [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] => 30 [type] => 0 ) [qryB_total] => 30 )

Villa Castillo Escondido - 5

This beautiful 6000 sq. ft, 4 bedroom, 4 1/2 bath villa sits right on the beach in la Laguna just 5 miles up the coast from San Jose del Cabo.

Beautiful pool area with spa and palapa covered lounge area lets you enjoy your sunset margaritas in style. Four ocean view master suites with California King size beds and adjoining private bathrooms make this location perfect for 4 couples or 2 families.

Rates

$1000 - $1600 / night

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

Amenities

  • 3 Levels
  • Air Conditioning
  • Beachfront Location
  • DVD Player
  • Fire Pit
  • Fireplace (Gas)
  • Gas BBQ
  • Gourmet Kitchen
  • Granite/Marble Countertops
  • Granite/Marble Countertops
  • Jacuzzi (outdoor)
  • Outdoor Bar
  • Satellite TV
  • Shade Structure
  • Spa
  • Swimming Pool (Outdoor)
  • View
  • Wireless Internet

Sleeping Accomodations!

4 bedrooms.

  • California King
  • California King
  • California King
  • California King

Additional Information

Maximum # of guests: 10

Interior square footage: 6000