Discover Our Properties
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) INNER JOIN wp_tota44soje_postmeta AS mt1 ON ( wp_tota44soje_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_tota44soje_postmeta.meta_key = 'wpcf-price' AND ( ( mt1.meta_key = 'wpcf-ribbon' AND mt1.meta_value IN ('Active','Under Contract','Sold') ) )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY FIELD(mt1.meta_value, 'Active', 'Under Contract', 'Sold'), CAST(wp_tota44soje_postmeta.meta_value AS SIGNED) DESC LIMIT 0, 9
124

Array ( [ffd_listing_title] => Array ( [0] => Ocean Residences B-302 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-4782 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKnePQAT ) [ffd_totalarea_pb] => Array ( [0] => 2681 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 3 ) [wpcf-bedrooms] => Array ( [0] => 3 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Ocean Residences ) [ffd_createddate] => Array ( [0] => 2022-12-23T23:00:25.000+0000 ) [ffd_days_on_market] => Array ( [0] => 14 ) [ffd_description_pb] => Array ( [0] => The Ocean Residences at Querencia bring you closer than ever before to the Sea of Cortez. With breathtaking unobstructed sea views, B-302 is the first resale opportunity within the completely sold-out project. The third-floor condominium features an airy, open floorplan and floor-to-ceiling glass doors that flow to the spacious terrace overlooking the Querencia Beach Club. This 3-bedroom residence features an additional office space and is artfully planned to invite the seascape in. Fully furnished by Giotto Mendini. This unit is under construction and is projected to be completed by July 2023.Ocean Residences B-302 Condominium $5,400,000 | 2,681 A/C SQFT 3 Beds 3 Full Baths 1 Half Baths
To learn more about the Beach Club & Ocean Residences:
Ocean Residences & Beach Club Brochure
) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-02T17:12:07.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0769 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 5400000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70915 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-4782 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 2681 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKnePQAT ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Ocean Residences B-302 ) [wpcf-squarefeet] => Array ( [0] => 3237 ) [wpcf-view] => Array ( [0] => Oceanfront ) [wpcf-price] => Array ( [0] => 5400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Oceanfront Ocean Residences B-302 Condominium 22-4782ResaleOcean ResidencesActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9556 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/ocean-residences-b-302/ ) [ffd_media] => Array ( [0] => a:11:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/6k3v19ckn/11.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/gkgexk6vp/1.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/ygury4wz5/12.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/pt0lxo4vn/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/z6hji5v2f/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/4sgsdwkdk/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/3ucv6yxss/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/1x9bvnqu6/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/ii568kby7/7.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/qu3fenj1x/8.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/44ex6024q/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IeZGe/6k3v19ckn/11.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKnePQAT ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_wp_old_slug] => Array ( [0] => ocean-residences-b-302-2 ) [_edit_lock] => Array ( [0] => 1672933288:18 ) [_edit_last] => Array ( [0] => 10 ) [_wpcf-propertybase-id] => Array ( [0] => field_6241d7e8a5172 ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_wpcf-property-type] => Array ( [0] => field_6241d82da5173 ) [_wpcf-view] => Array ( [0] => field_6241d8dca5174 ) [_wpcf-resale] => Array ( [0] => field_6241dab0a5175 ) [wpcf-neighborhood-subset] => Array ( [0] => ) [_wpcf-neighborhood-subset] => Array ( [0] => field_6241daefa5176 ) [_wpcf-ribbon] => Array ( [0] => field_6241db32a5177 ) [wpcf-lotnumber] => Array ( [0] => ) [_wpcf-lotnumber] => Array ( [0] => field_6241dbaea5178 ) [_wpcf-lotsize] => Array ( [0] => field_6241dbe2a5179 ) [_wpcf-lot-size-sqm] => Array ( [0] => field_6241dbffa517a ) [_wpcf-price] => Array ( [0] => field_6241dc18a517b ) [wpcf-start-price] => Array ( [0] => ) [_wpcf-start-price] => Array ( [0] => field_6241dc2ea517c ) [wpcf-end-price] => Array ( [0] => ) [_wpcf-end-price] => Array ( [0] => field_6241dc3ea517d ) [_wpcf-mls] => Array ( [0] => field_6241dc64a517e ) [wpcf-spec-sheet-file] => Array ( [0] => ) [_wpcf-spec-sheet-file] => Array ( [0] => field_6241dc7da517f ) [wpcf-video] => Array ( [0] => ) [_wpcf-video] => Array ( [0] => field_6241dcd3a5180 ) [_wpcf-squarefeet] => Array ( [0] => field_6241dd3527de8 ) [_wpcf-acarea] => Array ( [0] => field_6241dd8327de9 ) [_wpcf-bedrooms] => Array ( [0] => field_6241dde8b5fa0 ) [_wpcf-bathrooms] => Array ( [0] => field_6241de2bb5fa1 ) [_wpcf-half-bathrooms] => Array ( [0] => field_6241de60b5fa2 ) [wpcf-basement] => Array ( [0] => ) [_wpcf-basement] => Array ( [0] => field_6241de7fb5fa3 ) [wpcf-garage] => Array ( [0] => ) [_wpcf-garage] => Array ( [0] => field_6241dec1b5fa4 ) [wpcf-isfurnished] => Array ( [0] => ) [_wpcf-isfurnished] => Array ( [0] => field_6241df25b5fa5 ) [wpcf-otherroom] => Array ( [0] => ) [_wpcf-otherroom] => Array ( [0] => field_6241df6db5fa6 ) [wpcf-features] => Array ( [0] => ) [_wpcf-features] => Array ( [0] => field_6241dfacb5fa7 ) [wpcf-notes] => Array ( [0] => ) [_wpcf-notes] => Array ( [0] => field_6241dfd3b5fa8 ) [_wpcf-latitude] => Array ( [0] => field_6241e02bb5fa9 ) [_wpcf-longitude] => Array ( [0] => field_6241e04cb5faa ) [_wpcf-agent-1] => Array ( [0] => field_6241e06fb5fab ) [wpcf-agent-2] => Array ( [0] => ) [_wpcf-agent-2] => Array ( [0] => field_6241e080b5fac ) [_wpcf-keywords] => Array ( [0] => field_6241e099b5fad ) [_wpcf-highlights] => Array ( [0] => field_6241e0beb5fae ) [_wpcf-property-features] => Array ( [0] => field_6241e0e0b5faf ) [wpcf-floorplan] => Array ( [0] => ) [_wpcf-floorplan] => Array ( [0] => field_6241e0f7b5fb0 ) [wpcf-siteplan] => Array ( [0] => ) [_wpcf-siteplan] => Array ( [0] => field_6241e112b5fb1 ) [wpcf-brochure] => Array ( [0] => ) [_wpcf-brochure] => Array ( [0] => field_6241e12fb5fb2 ) [wpcf-close-date] => Array ( [0] => ) [_wpcf-close-date] => Array ( [0] => field_6241e145b5fb3 ) [_wpcf-listing-type] => Array ( [0] => field_6241e176b5fb4 ) [_ffd_community] => Array ( [0] => field_62ab426441a36 ) [wpcf-feature-subtitle] => Array ( [0] => ) [_wpcf-feature-subtitle] => Array ( [0] => field_6241e7194766a ) [wpcf-introduction] => Array ( [0] => ) [_wpcf-introduction] => Array ( [0] => field_6241e73e4766b ) [wpcf-tripple-icon] => Array ( [0] => default ) [_wpcf-tripple-icon] => Array ( [0] => field_6241e7634766c ) [_yoast_wpseo_content_score] => Array ( [0] => 90 ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas PH-C ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-296 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0JQAT ) [ffd_totalarea_pb] => Array ( [0] => 5623.86 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:58:17.000+0000 ) [ffd_days_on_market] => Array ( [0] => 380 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia penthosue residences with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda PH-C is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, providing easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and more.Verandas PH-C Verandas Condominium $4,500,000 | 5,624 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-30T17:16:20.000+0000 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 4500000 ) [ffd_community_lot_number] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0JQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas PH-C ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9261 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-ph-c/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/b9376n4v7/5.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/sxfmq8ilq/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/yq7o2851o/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/96zq5yhif/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/pn8rrz8u7/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/n0yfdhzmx/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/u7ejpvg08/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/ccp9lhahe/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/o4nvds1zz/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/oiffj9iyi/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueF/b9376n4v7/5.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1642799546:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0JQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 4500000 ) [wpcf-mls] => Array ( [0] => 22-296 ) [wpcf-squarefeet] => Array ( [0] => 7412.81 ) [wpcf-acarea] => Array ( [0] => 5624 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas PH-C Condominium 22-296DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas PH-E ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2469 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3zQAH ) [ffd_totalarea_pb] => Array ( [0] => 5623.86 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-04-26T21:06:07.000+0000 ) [ffd_days_on_market] => Array ( [0] => 311 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda PH-E is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas PH-E Verandas Condominium $4,100,000 | 5,624 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-03-03T21:11:12.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 4100000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2469 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 5624 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3zQAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas PH-E ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 4100000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas PH-E Condominium 22-2469DeveloperVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9449 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-ph-e/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/tmxa89ioy/8.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/5i6eqea5x/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/egi41rib4/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/rg9d446h4/3.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/3q0nlpjqt/4.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/9slmj1o46/5.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/aa16i6ssf/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/zascxuc76/7.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/ngv7oene5/9%20%281%29.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/pmw3b4q55/Clubhouse-3.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/dexmyag23/2.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/6uc391ml4/golf-2.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/dbxzilpoh/Golf-4.jpg";i:13;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/4f8ruxs7c/Pickleball.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/e09h4esi3/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02c/tmxa89ioy/8.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3zQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1655392280:11 ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas A-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1050 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KL6i5QAD ) [ffd_totalarea_pb] => Array ( [0] => 3092 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2023-03-07T17:02:46.000+0000 ) [ffd_days_on_market] => Array ( [0] => 7 ) [ffd_description_pb] => Array ( [0] => This beautiful collection of multi-family condominium residences are located just steps away from Querencia´s world-class Clubhouse Village, making our amenities truly an extension of your home. Verandas A 202 features a 4-bedroom distinctive floorplan which offers substantial and luxuriously finished indoor and outdoor living spaces. Move in ready and fully furnished, located just steps away from the Clubhouse ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-03-15T22:59:07.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03086 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3500000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75023 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 23-1050 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3092 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KL6i5QAD ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas A-202 ) [wpcf-squarefeet] => Array ( [0] => 4243 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3500000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Verandas A-202 Condominium 23-1050ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2013 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9576 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-a-202/ ) [ffd_media] => Array ( [0] => a:16:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/ohwmmivxd/A-TEMPLATE%20WEBSITE13.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/5h8dk25o6/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/m86u830lb/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/599kz8mrr/A-TEMPLATE%20WEBSITE5.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/fljqebdr0/A-TEMPLATE%20WEBSITE6.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/vxr35o3d9/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/lt3cerzfz/A-TEMPLATE%20WEBSITE8.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/3aw19s7td/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/iimagvsyz/A-TEMPLATE%20WEBSITE15.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/o5ohm4cp2/A-TEMPLATE%20WEBSITE11.jpg";i:10;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/0mbxwa2te/A-TEMPLATE%20WEBSITE.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/cgzhgm0ae/A-TEMPLATE%20WEBSITE10.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/kn59r5vz3/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/fh1eayc0j/A-TEMPLATE%20WEBSITE14.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/3ii0wg4t7/A-TEMPLATE%20WEBSITE16.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/f18ytw5ru/A-TEMPLATE%20WEBSITE2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/ohwmmivxd/A-TEMPLATE%20WEBSITE13.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KL6i5QAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )Verandas A-202 Verandas Condominium $3,500,000 | 3,092 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths

Array ( [ffd_listing_title] => Array ( [0] => Verandas E-102 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2471 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3fQAH ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-04-26T20:50:17.000+0000 ) [ffd_days_on_market] => Array ( [0] => 279 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda E-102 is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas E-102 Verandas Condominium $3,500,000 | 3,869 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-30T17:24:51.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3500000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2471 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3fQAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas E-102 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3500000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas E-102 Condominium 22-2471DeveloperVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9447 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-e-102/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/b268mqx6t/7.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/qfb2604yc/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/2msc3kdwh/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/nguv3ey7r/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/jdhk1xr3r/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/itd599m7q/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/xgx91pth3/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/od114sin4/6.jpg";i:8;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/wh3gpe7nh/9%20%281%29.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/8jax5fokw/Clubhouse-3.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/7ix9u7m7c/golf-2.jpg";i:11;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/d41v2zonx/Pickleball.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/hyampzkfp/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02W/b268mqx6t/7.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3fQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas E-201 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2470 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3kQAH ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-04-26T20:54:17.000+0000 ) [ffd_days_on_market] => Array ( [0] => 279 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda E-201 is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas E-201 Verandas Condominium $3,350,000 | 3,869 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-30T17:25:58.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3350000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2470 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3kQAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas E-201 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3350000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas E-201 Condominium 22-2470DeveloperVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9452 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-e-201/ ) [ffd_media] => Array ( [0] => a:15:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/oii8z85oy/6.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/rjkbgqfdz/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/fzq9wrect/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/3y9qs569r/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/0trohfv61/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/mmfommcqh/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/z3kev3x19/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/pux8j5k7n/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/odiltz2oy/8.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/e16ty0x1x/9%20%281%29.jpg";i:10;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/3aiq1qfwl/Clubhouse-3.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/ua47ldbs0/golf-2.jpg";i:12;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/3tommlt4c/Golf-4.jpg";i:13;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/7jjwxk1w0/Pickleball.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/nj0979ufb/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02b/oii8z85oy/6.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3kQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas C-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-461 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0AQAT ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:57:37.000+0000 ) [ffd_days_on_market] => Array ( [0] => 381 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda C-202 is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, providing easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and more.Verandas C-202 Verandas Condominium $3,350,000 | 3,869 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-31T22:12:49.000+0000 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3350000 ) [ffd_community_lot_number] => Array ( [0] => 202 ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0AQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas C-202 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9259 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-c-202/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/yw8qirjsn/9.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/pful4qagx/2.jpg";i:3;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jmnuy4coe/1%20copia.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/tmi5cmj4a/10.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/of9db6mww/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/jj53vq2qv/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/0dwryo0nh/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/xywa8kmlk/7.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/52eulsyiw/8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueO/9ibo2yvtp/3.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1648488732:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0AQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 3350000 ) [wpcf-mls] => Array ( [0] => 23-461 ) [wpcf-squarefeet] => Array ( [0] => 5511.06 ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas C-202 Condominium 23-461DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas C-201 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-462 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWl0EQAT ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-01-15T18:56:51.000+0000 ) [ffd_days_on_market] => Array ( [0] => 381 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez and San Jose del Cabo, Veranda C-201 is a spacious 4 bedroom, 4.5 bath with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The residence is located just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, providing easy access to Querencia’s amenities, including restaurants, pools, fitness center, Men's and Women's Spas, pickleball and tennis court, Kids & Teens Clubs and more.Verandas C-201 Verandas Condominium $3,350,000 | 3,869 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-31T22:23:20.000+0000 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3350000 ) [ffd_community_lot_number] => Array ( [0] => 201 ) [ffd_website_status_2] => Array ( [0] => ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWl0EQAT ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_name] => Array ( [0] => Verandas C-201 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9257 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-c-201/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/34cgo1mbz/1%20copia.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/vsq3m3kyy/10.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/2aze57j6j/2.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/4hwg9xpcm/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/sn4w6ze49/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/zohjejsgr/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/hzc8hql7e/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/8tx88msli/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/gay72oun9/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000J0ueJ/uydn6yfz3/7.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1642793137:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [_edit_last] => Array ( [0] => 10 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_wpcf-ribbon] => Array ( [0] => field_61a62a2ab65ac ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWl0EQAT ) [wpcf-property-type] => Array ( [0] => condo ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Active ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-price] => Array ( [0] => 3350000 ) [wpcf-mls] => Array ( [0] => 23-462 ) [wpcf-squarefeet] => Array ( [0] => 5491.26 ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03112 ) [wpcf-longitude] => Array ( [0] => -109.75026 ) [wpcf-keywords] => Array ( [0] => Ocean Verandas C-201 Condominium 23-462DeveloperVerandasActive ) [wpcf-listing-type] => Array ( [0] => Developer ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [wpcf-property-features] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) )

Array ( [ffd_listing_title] => Array ( [0] => Verandas E-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-2472 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKD3uQAH ) [ffd_totalarea_pb] => Array ( [0] => 3868.54 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => Los Cabos ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_createddate] => Array ( [0] => 2022-04-26T20:58:58.000+0000 ) [ffd_days_on_market] => Array ( [0] => 279 ) [ffd_description_pb] => Array ( [0] => An exceptional Querencia private residence with elevated canyon and magnificent views of Punta Gorda, the Sea of Cortez, and San Jose del Cabo, Veranda E-202 is a spacious 4 bedroom, 4.5 bath residence with an open floorplan within the Verandas enclave. Inside find a gourmet kitchen and a substantial living space that flows directly onto the oversized terrace. The Verandas community features a community pool and social area and is just steps away from the community’s world-class Clubhouse and award-winning 18-hole golf course, dog park, pickleball courts, hiking and biking trails and other Club amenities, including restaurants, pools, fitness center, Men's and Women's Spas, Kids & Teens Clubs and more.Verandas E-202 Verandas Condominium $3,350,000 | 3,869 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
The photos shown are of an existing Verandas unit. Please note that this listing is not yet built and will vary. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-30T17:26:48.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.0636 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3350000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-2472 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3869 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKD3uQAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas E-202 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 3350000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Verandas E-202 Condominium 22-2472DeveloperVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9448 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-e-202/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/4vcknu41h/9%20%281%29.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/knslfz8s9/2.jpg";i:2;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/b7ku78vl2/1%20copia.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/e6fq4fdd2/10.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/dbh9ddt3r/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/o8d58hsdh/4.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/t03tuib1z/5.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/umhjvtnfy/6.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/9t31dll1k/7.jpg";i:9;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/x9mzcssgd/Clubhouse-3.jpg";i:10;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/9cl55nrtz/golf-2.jpg";i:11;s:101:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/e5c9vjoj0/Golf-4.jpg";i:12;s:105:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/0v2vuts6h/Pickleball.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/b17ruuf7f/trails-2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000JH02g/4vcknu41h/9%20%281%29.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKD3uQAH ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) )
SELECT SQL_CALC_FOUND_ROWS wp_tota44soje_posts.ID FROM wp_tota44soje_posts INNER JOIN wp_tota44soje_postmeta ON ( wp_tota44soje_posts.ID = wp_tota44soje_postmeta.post_id ) WHERE 1=1 AND ( ( wp_tota44soje_postmeta.meta_key = 'featured' AND wp_tota44soje_postmeta.meta_value = 'yes' )) AND wp_tota44soje_posts.post_type = 'properties' AND ((wp_tota44soje_posts.post_status = 'publish')) GROUP BY wp_tota44soje_posts.ID ORDER BY wp_tota44soje_posts.post_date DESC LIMIT 0, 3
Featured properties
8

Array ( [ffd_listing_title] => Array ( [0] => El Valle 1 Upper ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JYGq7QAH ) [ffd_totalarea_pb] => Array ( [0] => 3050 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => ) [wpcf-bedrooms] => Array ( [0] => ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => El Valle ) [ffd_createddate] => Array ( [0] => 2023-03-30T18:47:15.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => El Valle is the latest neighborhood designed within the master planned Querencia community. A smaller, more intimate enclave set against the backdrop of the vibrant desert mountains, the 12 residences offer a mix of views of the turquoise San Jose bay, Querencia lake and the award-winning Tom Fazio golf course. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-03-30T18:54:50.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.05381 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 35 ) [wpcf-lotsize] => Array ( [0] => 22948.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 2132 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3050 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000JYGq7QAH ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => El Valle 1 Upper ) [wpcf-squarefeet] => Array ( [0] => 3588 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => El Valle 1 Upper Condominium DeveloperEl ValleActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9581 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-valle-1-upper/ ) [ffd_media] => Array ( [0] => a:21:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/9m3ahc928/1.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/92vvj189g/10.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/01nrqr13l/11.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/lbyn4ca5k/12.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/jhdg8o0ku/13.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/x83ortazs/2.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/ow4px46yk/3.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gwyukoymc/4.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/p73w1hfqp/5.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/00tu64sdm/6.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/4wtve2vct/7.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/3sfggspxa/8.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tvm21dmqk/9.jpg";i:13;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hk2as5pqo/A-TEMPLATE%20WEBSITE.jpg";i:14;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/tq1hxt5r6/A-TEMPLATE%20WEBSITE2.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/uifiwgcnt/A-TEMPLATE%20WEBSITE3.jpg";i:16;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/hojxk6ut1/A-TEMPLATE%20WEBSITE4.jpg";i:17;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/zgnw06tqo/A-TEMPLATE%20WEBSITE5.jpg";i:18;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/5d98tiql5/A-TEMPLATE%20WEBSITE6.jpg";i:19;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/je4iqh7s6/A-TEMPLATE%20WEBSITE7.jpg";i:20;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/gotztox5o/A-TEMPLATE%20WEBSITE8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000KCUDG/9m3ahc928/1.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JYGq7QAH ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [wpcf-agent-2] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) )El Valle 1 Upper Condominium 3,050 A/C SQFT
Array ( [ffd_listing_title] => Array ( [0] => Las Casitas #07 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1285 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKjnPQAT ) [ffd_totalarea_pb] => Array ( [0] => 2052 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Carretera Transpeninsular Km. 27.5 ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 2 ) [wpcf-bedrooms] => Array ( [0] => 2 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Casitas ) [ffd_createddate] => Array ( [0] => 2022-12-09T16:30:39.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => The Casitas Phase II are an intimate collection of seven spacious single-family residences offering stunning mountain, arroyo and sea views. Inspired by coastal living, the thoughtfully planned enclave offers a 2-bedroom, 2.5-bath floorplan* and are ideal for those seeking a vibrant community just steps from our Clubhouse and expanding amenities park, the Canyon Club. Unwind and enjoy breathtaking views today and for generations to come from your casita, complete with the finest of finishes inside and out. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-03-30T18:38:21.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.05381 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1900000 ) [wpcf-listing-type] => Array ( [0] => Developer ) [wpcf-longitude] => Array ( [0] => -109.70348 ) [ffd_community_lot_number] => Array ( [0] => 1 ) [wpcf-lotsize] => Array ( [0] => 3209 ) [wpcf-lot-size-sqm] => Array ( [0] => 298.13 ) [wpcf-mls] => Array ( [0] => 23-1285 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 2052 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKjnPQAT ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Las Casitas #07 ) [wpcf-squarefeet] => Array ( [0] => 2467 ) [wpcf-view] => Array ( [0] => ) [wpcf-price] => Array ( [0] => 1900000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Las Casitas #07 Single Family Home 23-1285DeveloperLas CasitasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23406 ) [pba__WebsiteId__c] => Array ( [0] => 9580 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-casitas-07/ ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKjnPQAT ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 9289 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) )Las Casitas #07 Las Casitas Single Family Home $1,900,000 | 2,052 A/C SQFT 2 Beds 2 Full Baths 1 Half Baths

Array ( [ffd_listing_title] => Array ( [0] => Verandas A-202 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 23-1050 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KL6i5QAD ) [ffd_totalarea_pb] => Array ( [0] => 3092 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [ffd_community] => Array ( [0] => Verandas ) [ffd_createddate] => Array ( [0] => 2023-03-07T17:02:46.000+0000 ) [ffd_days_on_market] => Array ( [0] => 7 ) [ffd_description_pb] => Array ( [0] => This beautiful collection of multi-family condominium residences are located just steps away from Querencia´s world-class Clubhouse Village, making our amenities truly an extension of your home. Verandas A 202 features a 4-bedroom distinctive floorplan which offers substantial and luxuriously finished indoor and outdoor living spaces. Move in ready and fully furnished, located just steps away from the Clubhouse ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-03-15T22:59:07.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03086 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 3500000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.75023 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 23-1050 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 3092 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KL6i5QAD ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Verandas A-202 ) [wpcf-squarefeet] => Array ( [0] => 4243 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3500000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Verandas A-202 Condominium 23-1050ResaleVerandasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2013 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9576 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/verandas-a-202/ ) [ffd_media] => Array ( [0] => a:16:{i:0;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/ohwmmivxd/A-TEMPLATE%20WEBSITE13.jpg";i:1;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/5h8dk25o6/A-TEMPLATE%20WEBSITE3.jpg";i:2;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/m86u830lb/A-TEMPLATE%20WEBSITE4.jpg";i:3;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/599kz8mrr/A-TEMPLATE%20WEBSITE5.jpg";i:4;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/fljqebdr0/A-TEMPLATE%20WEBSITE6.jpg";i:5;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/vxr35o3d9/A-TEMPLATE%20WEBSITE7.jpg";i:6;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/lt3cerzfz/A-TEMPLATE%20WEBSITE8.jpg";i:7;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/3aw19s7td/A-TEMPLATE%20WEBSITE9.jpg";i:8;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/iimagvsyz/A-TEMPLATE%20WEBSITE15.jpg";i:9;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/o5ohm4cp2/A-TEMPLATE%20WEBSITE11.jpg";i:10;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/0mbxwa2te/A-TEMPLATE%20WEBSITE.jpg";i:11;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/cgzhgm0ae/A-TEMPLATE%20WEBSITE10.jpg";i:12;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/kn59r5vz3/A-TEMPLATE%20WEBSITE12.jpg";i:13;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/fh1eayc0j/A-TEMPLATE%20WEBSITE14.jpg";i:14;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/3ii0wg4t7/A-TEMPLATE%20WEBSITE16.jpg";i:15;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/f18ytw5ru/A-TEMPLATE%20WEBSITE2.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mFUt/ohwmmivxd/A-TEMPLATE%20WEBSITE13.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KL6i5QAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1899 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )Verandas A-202 Verandas Condominium $3,500,000 | 3,092 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths