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 21:42:26

Array
(
    [_GET] => Array
        (
            [slug] => Alegranza-4-Bedroom-Penthouse
        )

    [_POST] => Array
        (
        )

    [_COOKIE] => Array
        (
        )

    [_FILES] => Array
        (
        )

    [_REQUEST] => Array
        (
            [slug] => Alegranza-4-Bedroom-Penthouse
        )

    [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: 1311237  Threads: 100  Questions: 160877060  Slow queries: 12  Opens: 381865  Open tables: 3785  Queries per second avg: 122.691
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3600419
            [warning_count] => 0
        )

    [todayMysql] => 20240328
    [today] => 3/28/2024
    [today0] => 03/28/2024
    [todayDB] => 20240328214226
    [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: 1311237  Threads: 100  Questions: 160877060  Slow queries: 12  Opens: 381865  Open tables: 3785  Queries per second avg: 122.691
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3600420
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

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

This amazing brand new 3.190 sq. ft double floor Penthouse is part of Alegranza Residential Resort, one of the most exclusive communities on the serene residential golf course of San Jose del Cabo.

Located within walking distance to the beach, downtown San Jose (where you will find best shopping and restaurants in the area), supermarket and the Marina at Puerto Los Cabos, the resort dominates the whole bay from Palmilla to Punta Gorda with unobstructed views from every room (the best views in the whole town).

The unit includes three king size beds (one on each room), one queen bed, and a huge terrace that will enable you to enjoy unforgettable ocean views with different sceneries: the estuary, the desert and the marina, Palmilla and Punta Gorda

The 1.050 sq. ft rooftop terrace (upper floor) holds a comfortable lounge area perfect for private parties, social meetings or resting times, a Gas BBQ, outside shower and more than an unforgettable Jacuzzi. The area is completely private and has been awarded as the fanciest terrace in Los Cabos by the most recognized magazines in Mexican architecture

The Resort has 3 heated saline water lap pools, 2 Jacuzzis, a fully equipped gym with TV's, A.C and sound system, putting green, fire pits, a restaurant with room service delivery, wireless internet, 24 hours security and concierge service, BBQ areas, purified water and beach club access

Among other features, the residence has 10 ft ceilings, granite countertops, alder wood carpentry and double pane window providing complete noise and temperature isolation.

Developed in partnership with Enrique Iglesias (the singer), Alegranza is known by its high end finishes, friendly service, best location possible, huge terraces and great amenities.

You will not like to miss these opportunity special prices we offer and stay on this dream resort!

[special_note] =>

Please Click Here for YouTube Video!

[short_desc] =>

Alegranza Residential Resort is an exclusive community located on the serene residential golf course of San José del Cabo, within walking distance to the beach and the historic downtown, where the best shopping and dining of Los Cabos can be found. 

.

[meta_title] => Alegranza 4 Bedroom Penthouse San Jose del Cabo Los Cabos Mexico [meta_keys] => Alegranza 4 Bedroom Penthouse San Jose del Cabo Los Cabos Mexico [meta_desc] => Alegranza 4 Bedroom Penthouse San Jose del Cabo Los Cabos Mexico [show_avail] => 0 [link] => [calendar] => 0 [no_beds] => 4 [rating] => 4 [sleeps] => 0 [sqft_inside] => 2500 [sqft_outside] => 700 [low_rate] => 550 [high_rate] => 750 [rate_note] =>

Google Map Link!

[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-4-Bedroom-Penthouse [HTTP_USER_AGENT] => claudebot [HTTP_X_HTTPS] => 1 [REDIRECT_UNIQUE_ID] => ZgXkQgkZ6PU8aAFUfDH-4wAAbxg [REDIRECT_SCRIPT_URL] => /san-jose/Alegranza-4-Bedroom-Penthouse [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Alegranza-4-Bedroom-Penthouse [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] => 1791409-335-3 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => ZgXkQgkZ6PU8aAFUfDH-4wAAbxg [SCRIPT_URL] => /san-jose/Alegranza-4-Bedroom-Penthouse [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Alegranza-4-Bedroom-Penthouse [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] => 1791409-335-3 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 54.165.248.212 [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] => 36552 [REDIRECT_URL] => /san-jose/Alegranza-4-Bedroom-Penthouse [REDIRECT_QUERY_STRING] => slug=Alegranza-4-Bedroom-Penthouse [SERVER_PROTOCOL] => HTTP/2.0 [REQUEST_METHOD] => GET [QUERY_STRING] => slug=Alegranza-4-Bedroom-Penthouse [REQUEST_URI] => /san-jose/Alegranza-4-Bedroom-Penthouse [SCRIPT_NAME] => /san-jose/detail.php [PHP_SELF] => /san-jose/detail.php [REQUEST_TIME_FLOAT] => 1711662146.14 [REQUEST_TIME] => 1711662146 ) [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] => 20 [type] => 0 ) [qryB_total] => 20 )

Alegranza 4 Bedroom Penthouse - 4

This amazing brand new 3.190 sq. ft double floor Penthouse is part of Alegranza Residential Resort, one of the most exclusive communities on the serene residential golf course of San Jose del Cabo.

Located within walking distance to the beach, downtown San Jose (where you will find best shopping and restaurants in the area), supermarket and the Marina at Puerto Los Cabos, the resort dominates the whole bay from Palmilla to Punta Gorda with unobstructed views from every room (the best views in the whole town).

The unit includes three king size beds (one on each room), one queen bed, and a huge terrace that will enable you to enjoy unforgettable ocean views with different sceneries: the estuary, the desert and the marina, Palmilla and Punta Gorda

The 1.050 sq. ft rooftop terrace (upper floor) holds a comfortable lounge area perfect for private parties, social meetings or resting times, a Gas BBQ, outside shower and more than an unforgettable Jacuzzi. The area is completely private and has been awarded as the fanciest terrace in Los Cabos by the most recognized magazines in Mexican architecture

The Resort has 3 heated saline water lap pools, 2 Jacuzzis, a fully equipped gym with TV's, A.C and sound system, putting green, fire pits, a restaurant with room service delivery, wireless internet, 24 hours security and concierge service, BBQ areas, purified water and beach club access

Among other features, the residence has 10 ft ceilings, granite countertops, alder wood carpentry and double pane window providing complete noise and temperature isolation.

Developed in partnership with Enrique Iglesias (the singer), Alegranza is known by its high end finishes, friendly service, best location possible, huge terraces and great amenities.

You will not like to miss these opportunity special prices we offer and stay on this dream resort!

Rates

$550 - $750 / night

Google Map Link!

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

Amenities

  • 2 Levels
  • Air Conditioning
  • CD Player
  • Ceiling Fans
  • DVD Player
  • Elevator
  • Exercise Equiptment
  • Fire Pit
  • Fitness Center
  • Gas BBQ
  • Gourmet Kitchen
  • Granite/Marble Countertops
  • Gym
  • Internet
  • IPod Docking Station
  • Jacuzzi (indoor)
  • Jacuzzi (outdoor)
  • Marble Floors
  • Ocean View
  • Outdoor Shower
  • Satellite TV
  • Sauna
  • Shade Structure
  • Stereo
  • Swimming Pool (Outdoor)
  • Tennis Court
  • Washer and Dryer

Sleeping Accomodations!

4 bedrooms.

  • King Suite
  • King Suite
  • King Suite
  • Queen Suite

Additional Information

Interior square footage: 2500
Exterior square footage: 700
Total square footage: 3200