An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 4-19-2024 03:11:07
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: 654519 Threads: 9 Questions: 1360909 Slow queries: 1 Opens: 587 Open tables: 108 Queries per second avg: 2.079 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 416729 [warning_count] => 0 ) [_REQUEST] => Array ( [slug] => Alegranza-3-Bedroom-condo ) [todayMysql] => 20240419 [today] => 4/19/2024 [today0] => 04/19/2024 [todayDB] => 20240419031107 [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: 654519 Threads: 9 Questions: 1360909 Slow queries: 1 Opens: 587 Open tables: 108 Queries per second avg: 2.079 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 416730 [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] => [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.
[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_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] => ZiHgy4KpcVHlYmybz7o1BQAAxhY [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] => 967417-518-3 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => ZiHgy4KpcVHlYmybz7o1BQAAxhY [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] => 967417-518-3 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 3.22.181.209 [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] => 27584 [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] => 1713496267.35 [REQUEST_TIME] => 1713496267 ) [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 Residential Resort, reigning supremely over San Jose Bay, offers you the finest views of the Sea of Cortez, golf fairways, desert, and estuary.
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
$250 - $350 / night
*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes
3 bedrooms.
Maximum # of guests: 6
Interior square footage: 2140