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

Array
(
    [_GET] => Array
        (
            [slug] => Alegranza-3-Bedroom-condo
        )

    [_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: 1364570  Threads: 100  Questions: 167814945  Slow queries: 12  Opens: 385307  Open tables: 3317  Queries per second avg: 122.980
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3776093
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Alegranza-3-Bedroom-condo
        )

    [todayMysql] => 20240329
    [today] => 3/29/2024
    [today0] => 03/29/2024
    [todayDB] => 20240329123119
    [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: 1364570  Threads: 100  Questions: 167814946  Slow queries: 12  Opens: 385307  Open tables: 3317  Queries per second avg: 122.980
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3776094
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

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

This awesome 2,140 sq. ft, new, San Jose del Cabo condo rental is within the Alegranza Residential Resort, an exclusive community on the San Jose residential golf course.
Alegranza Residential Resort, reigning supremely over San Jose Bay, offers you the finest views of the Sea of Cortez, golf fairways, desert, and estuary.

The resort is noted for its luxury finishes and fine furniture, warm service, high-end amenities, fully equipped kitchen and best possible location: walking distance of the beach, downtown San Jose del Cabo where you will find excellent shopping and restaurants, a new marina, and eleven Top 10 golf courses.


Pamper yourself with the amazing amenities while staying at this San Jose del Cabo condo rental: heated lap pools, saunas, Jacuzzis, a stellar gym with top-of-the-line equipment, restaurant with room service, lighted tennis court, beach club access, putting green, 24-hour concierge and security, barbecue places, Palapa bars, wireless internet & purified water 2 California king beds, 1 full queen bed, GE appliances

[special_note] =>

Google Map Link!

[short_desc] =>

This awesome 2,140 sq. ft, new, San Jose del Cabo condo rental is within the Alegranza Residential Resort, an exclusive community on the San Jose residential golf course.
Alegranza Residential Resort, reigning supremely over San Jose Bay, offers you the finest views of the Sea of Cortez, golf fairways, desert, and estuary.

[meta_title] => Alegranza 3 Bedroom Condo San Jose del Cabo Los Cabos Mexico [meta_keys] => Alegranza 3 Bedroom Condo San Jose del Cabo Los Cabos Mexico [meta_desc] => Alegranza 3 Bedroom Condo San Jose del Cabo Los Cabos Mexico [show_avail] => 0 [link] => [calendar] => 0 [no_beds] => 3 [rating] => 4 [sleeps] => 6 [sqft_inside] => 2140 [sqft_outside] => 0 [low_rate] => 250 [high_rate] => 350 [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] => */* [CONTENT_LENGTH] => 0 [HTTP_HOST] => www.loscabosvacation.com [HTTP_REFERER] => http://www.loscabosvacation.com/san-jose/Alegranza-3-Bedroom-condo [HTTP_USER_AGENT] => claudebot [HTTP_X_HTTPS] => 1 [REDIRECT_UNIQUE_ID] => Zga0l4zuXr5mcGavN28C_wABECs [REDIRECT_SCRIPT_URL] => /san-jose/Alegranza-3-Bedroom-condo [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Alegranza-3-Bedroom-condo [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] => 3025796-18-3 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => Zga0l4zuXr5mcGavN28C_wABECs [SCRIPT_URL] => /san-jose/Alegranza-3-Bedroom-condo [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Alegranza-3-Bedroom-condo [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] => 3025796-18-3 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 3.236.147.122 [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] => 55236 [REDIRECT_URL] => /san-jose/Alegranza-3-Bedroom-condo [REDIRECT_QUERY_STRING] => slug=Alegranza-3-Bedroom-condo [SERVER_PROTOCOL] => HTTP/2.0 [REQUEST_METHOD] => GET [QUERY_STRING] => slug=Alegranza-3-Bedroom-condo [REQUEST_URI] => /san-jose/Alegranza-3-Bedroom-condo [SCRIPT_NAME] => /san-jose/detail.php [PHP_SELF] => /san-jose/detail.php [REQUEST_TIME_FLOAT] => 1711715479.64 [REQUEST_TIME] => 1711715479 ) [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] => 25 [type] => 0 ) [qryB_total] => 25 )

Alegranza 3 Bedroom condo - 4

This awesome 2,140 sq. ft, new, San Jose del Cabo condo rental is within the Alegranza Residential Resort, an exclusive community on the San Jose residential golf course.
Alegranza Residential Resort, reigning supremely over San Jose Bay, offers you the finest views of the Sea of Cortez, golf fairways, desert, and estuary.

The resort is noted for its luxury finishes and fine furniture, warm service, high-end amenities, fully equipped kitchen and best possible location: walking distance of the beach, downtown San Jose del Cabo where you will find excellent shopping and restaurants, a new marina, and eleven Top 10 golf courses.


Pamper yourself with the amazing amenities while staying at this San Jose del Cabo condo rental: heated lap pools, saunas, Jacuzzis, a stellar gym with top-of-the-line equipment, restaurant with room service, lighted tennis court, beach club access, putting green, 24-hour concierge and security, barbecue places, Palapa bars, wireless internet & purified water 2 California king beds, 1 full queen bed, GE appliances

Rates

$250 - $350 / night

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

Amenities

  • 1 Level
  • Air Conditioning
  • CD Player
  • Ceiling Fans
  • DVD Player
  • Elevator
  • Exercise Equiptment
  • Fire Pit
  • Gas BBQ
  • Gourmet Kitchen
  • Granite/Marble Countertops
  • Gym
  • Internet
  • Jacuzzi (indoor)
  • Jacuzzi (outdoor)
  • Marble Floors
  • Ocean View
  • Outdoor Bar
  • Satellite TV
  • Stereo
  • Swimming Pool (Outdoor)
  • Tennis Court
  • Washer and Dryer

Sleeping Accomodations!

3 bedrooms.

  • King Suite
  • King Suite
  • Queen

Additional Information

Maximum # of guests: 6

Interior square footage: 2140