An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 9-19-2025 07:45:16

Array
(
    [_GET] => Array
        (
            [slug] => El-Zalate-Beach-Front-Condos
        )

    [_POST] => Array
        (
        )

    [_COOKIE] => Array
        (
            [PHPSESSID] => 3u8m6vspj4c2bsicf4mt37suk7
        )

    [_FILES] => Array
        (
        )

    [_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_COOKIE] => PHPSESSID=3u8m6vspj4c2bsicf4mt37suk7
            [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] => aM0KDDgcjQBocrBDD2WtqgAA0RU
            [REDIRECT_SCRIPT_URL] => /san-jose/El-Zalate-Beach-Front-Condos
            [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/El-Zalate-Beach-Front-Condos
            [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] => 5
            [REDIRECT_H2_STREAM_TAG] => 3114340-157-5
            [REDIRECT_STATUS] => 200
            [UNIQUE_ID] => aM0KDDgcjQBocrBDD2WtqgAA0RU
            [SCRIPT_URL] => /san-jose/El-Zalate-Beach-Front-Condos
            [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/El-Zalate-Beach-Front-Condos
            [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] => 5
            [H2_STREAM_TAG] => 3114340-157-5
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [SERVER_NAME] => www.loscabosvacation.com
            [SERVER_ADDR] => 50.63.7.156
            [SERVER_PORT] => 443
            [REMOTE_ADDR] => 216.73.216.145
            [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] => 22636
            [REDIRECT_URL] => /san-jose/El-Zalate-Beach-Front-Condos
            [REDIRECT_QUERY_STRING] => slug=El-Zalate-Beach-Front-Condos
            [SERVER_PROTOCOL] => HTTP/2.0
            [REQUEST_METHOD] => GET
            [QUERY_STRING] => slug=El-Zalate-Beach-Front-Condos
            [REQUEST_URI] => /san-jose/El-Zalate-Beach-Front-Condos
            [SCRIPT_NAME] => /san-jose/detail.php
            [PHP_SELF] => /san-jose/detail.php
            [REQUEST_TIME_FLOAT] => 1758267916.6
            [REQUEST_TIME] => 1758267916
        )

    [_REQUEST] => Array
        (
            [slug] => El-Zalate-Beach-Front-Condos
        )

    [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] => Localhost via UNIX socket
            [info] => 
            [insert_id] => 0
            [server_info] => 5.5.5-10.6.22-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 1969426  Threads: 101  Questions: 975504298  Slow queries: 700  Opens: 6695934  Open tables: 5000  Queries per second avg: 495.324
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 13938505
            [warning_count] => 0
        )

    [todayMysql] => 20250919
    [today] => 9/19/2025
    [today0] => 09/19/2025
    [todayDB] => 20250919074516
    [sdbc] => mysqli Object
        (
            [affected_rows] => 1
            [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] => Localhost via UNIX socket
            [info] => 
            [insert_id] => 0
            [server_info] => 5.5.5-10.6.22-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 1969426  Threads: 101  Questions: 975504298  Slow queries: 700  Opens: 6695934  Open tables: 5000  Queries per second avg: 495.324
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 13938506
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

    [slug] => Yoga
    [pid] => 58
    [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=58
    [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] => El Zalate Beach Front Condos
    [description] => 

El Zalate Beach Front Condos We have a 3rd Floor 2 bedroom/ 2 bath with spectacular Sea of Cortez views to Punta Palmilla.

King in master and 2 queens in guest bed room. Large deck area with ocean views over large pool/spa area to Punta Palmilla.

Full kiitchen with stove, micro wave, refridgerater, dishwaser.

[special_note] =>

Click Here for YouTube Video

Pool area Video

Click Here For Google Map!

[short_desc] =>

El Zalate Beach Front Condos

[meta_title] => El Zalate Bech Front Condos San Jose del Cabo [meta_keys] => El Zalate Bech Front Condos San Jose del Cabo [meta_desc] => El Zalate Bech Front Condos San Jose del Cabo [show_avail] => 0 [link] => [calendar] => 0 [no_beds] => 2 [rating] => 4 [sleeps] => 0 [sqft_inside] => 1500 [sqft_outside] => 400 [low_rate] => 250 [high_rate] => 300 [rate_note] => [max_guests] => [pageName] => detail.php [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] => 14 [type] => 0 ) [qryB_total] => 14 )

El Zalate Beach Front Condos - 4

El Zalate Beach Front Condos We have a 3rd Floor 2 bedroom/ 2 bath with spectacular Sea of Cortez views to Punta Palmilla.

King in master and 2 queens in guest bed room. Large deck area with ocean views over large pool/spa area to Punta Palmilla.

Full kiitchen with stove, micro wave, refridgerater, dishwaser.

Rates

$250 - $300 / night

*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
  • Elevator
  • Granite/Marble Countertops
  • Jacuzzi (outdoor)
  • Ocean Front
  • Ocean View
  • Satellite TV
  • Shade Structure
  • Swimming Pool (Outdoor)
  • Washer and Dryer
  • Wireless Internet

Sleeping Accomodations!

2 bedrooms.

  • King Suite
  • 2 Queens Suite

Additional Information

Interior square footage: 1500
Exterior square footage: 400
Total square footage: 1900