An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 4-26-2024 08:05:03

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.16-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 1276955  Threads: 6  Questions: 2585706  Slow queries: 1  Opens: 623  Open tables: 116  Queries per second avg: 2.024
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 796688
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Villa-Cielito
        )

    [todayMysql] => 20240426
    [today] => 4/26/2024
    [today0] => 04/26/2024
    [todayDB] => 20240426080503
    [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: 1276955  Threads: 6  Questions: 2585706  Slow queries: 1  Opens: 623  Open tables: 116  Queries per second avg: 2.024
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 796689
            [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] =>

Please 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] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) [HTTP_X_HTTPS] => 1 [REDIRECT_UNIQUE_ID] => ZitgL1fNoQfn31xTziqVxgACJyg [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] => 1 [REDIRECT_H2_STREAM_TAG] => 1099205-3064-1 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => ZitgL1fNoQfn31xTziqVxgACJyg [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] => 1 [H2_STREAM_TAG] => 1099205-3064-1 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 18.224.59.231 [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] => 34444 [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] => 1714118703.95 [REQUEST_TIME] => 1714118703 ) [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 - 4

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

 

Rates

$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

Amenities

  • 1 Level
  • Air Conditioning
  • Beachfront Location
  • CD Player
  • Ceiling Fans
  • DVD Player
  • Gas BBQ
  • Gourmet Kitchen
  • Granite/Marble Countertops
  • Internet
  • Jacuzzi (outdoor)
  • Ocean Front
  • Stereo
  • Swimming Pool (Outdoor)
  • Washer and Dryer

Sleeping Accomodations!

7 bedrooms.

  • King Suite
  • King Suite
  • King Suite
  • King Suite
  • King Suite
  • King Suite
  • King Suite
  • Apartment with king size bed and kitchen

Additional Information

Maximum # of guests: 16

Interior square footage: 10000
Exterior square footage: 5000
Total square footage: 15000