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] => [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 )
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!
$550 - $750 / night
*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes
4 bedrooms.
Interior square footage: 2500
Exterior square footage: 700
Total square footage: 3200