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 ) INNER JOIN wp_tota44soje_postmeta AS mt2 ON ( wp_tota44soje_posts.ID = mt2.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 ( mt2.meta_key = 'wpcf-listing-type' AND mt2.meta_value = 'resale' ) )) 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
26
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] => Club Villa #17 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-4578 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKj7lQAD ) [ffd_totalarea_pb] => Array ( [0] => 4124.4 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 5 ) [wpcf-bedrooms] => Array ( [0] => 5 ) [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] => Club Villas ) [ffd_createddate] => Array ( [0] => 2022-12-07T21:30:13.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => Villa 17 is a one-story home nestled above the 16th fairway of the famed Querencia Golf Course designed by Tom Fazio and features beautiful panoramic vistas of the Sea of Cortez. The luxurious finishes and furnishings drew inspiration from the homes rich surroundings, from the earthy tones of the desert, to the azure blues of the ocean. Indoor living spaces transition seamlessly to the outside terrazas, pool, private lawn and summer kitchen. When the sliding doors are open, it's as if there's nothing to separate you from the beauty outside. A golf membership is included in the purchase of the home, buyer to pay the transfer fee. Conveniently located near the Querencia Club Village, one can easily enjoy the world-class amenities including access to the Querencia Beach Club with a swimmable cove, miles of hiking & mountain biking trails, state-of-the art fitness and wellness center, Kids * Teen Clubs, restaurants, pools, Spa & more! ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => yes ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2023-02-01T19:11:29.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06359 ) [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] => 3950000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70247 ) [ffd_community_lot_number] => Array ( [0] => 17 ) [wpcf-lotsize] => Array ( [0] => 11077.68 ) [wpcf-lot-size-sqm] => Array ( [0] => 1029.15 ) [wpcf-mls] => Array ( [0] => 22-4578 ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 4124 ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKj7lQAD ) [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] => Club Villa #17 ) [wpcf-squarefeet] => Array ( [0] => 5926.16 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3950000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #17 Homesite 22-4578ResaleClub VillasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2015 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9555 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-17/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:146:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/v3h2uoi4q/Villa-17-Querencia-RomanaLilic-LA76-Photography-199.JPG";i:1;s:152:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/tc4j51p37/6.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-012.JPG";i:2;s:146:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/00a0obrob/Villa-17-Querencia-RomanaLilic-LA76-Photography-203.JPG";i:3;s:146:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/yqs0cv8qa/Villa-17-Querencia-RomanaLilic-LA76-Photography-194.JPG";i:4;s:150:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/rl5qzesds/18.-Villa-17-Querencia-RomanaLilic-LA76-Photography-095.JPG";i:5;s:153:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/t5fxvhl7g/12.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-120.JPG";i:6;s:153:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/4s0pt20uy/10.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-115.JPG";i:7;s:152:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/7i74bgfn5/2.-%20Villa-17-Querencia-RomanaLilic-LA76-Photography-155.JPG";i:8;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/26tcpszvv/CLUB%20VILLA%2017_FLOOR%20PLAN.pdf";i:9;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/p1agthdpj02ul17311pgs1ng6r5j2/VILLA%2017.pdf";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DXeV/v3h2uoi4q/Villa-17-Querencia-RomanaLilic-LA76-Photography-199.JPG ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKj7lQAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )Club Villa #17 Club Villas Homesite $3,950,000 | 4,124 A/C SQFT 5 Beds 5 Full Baths 1 Half Baths Lot Size 11077.68 sq ft 1029.15 sq m
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #03 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKin6QAD ) [ffd_totalarea_pb] => Array ( [0] => 4249.58 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Km.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] => Club Villas ) [ffd_createddate] => Array ( [0] => 2022-12-06T20:45:02.000+0000 ) [ffd_days_on_market] => Array ( [0] => ) [ffd_description_pb] => Array ( [0] => Inside the luxurious, gated, and highly amenitized community of Querencia. This impeccable, two-story custom residence is situated on the private, award-winning Tom Fazio course overlooking the 18th fairway. This residence features a collection of four bedrooms and an office. Inside, the expansive gourmet kitchen and pristine formal dining and living rooms open seamlessly to the terrace, fusing the outdoor and indoor living spaces. Enjoy ample alfresco entertaining space that includes an outdoor kitchen, dining area and firepit. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-12-07T20:47:48.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02987 ) [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] => 3400000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.74735 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 8342.66 ) [wpcf-lot-size-sqm] => Array ( [0] => 775.06 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => ) [wpcf-acarea] => Array ( [0] => 4250 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKin6QAD ) [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] => Club Villa #03 ) [wpcf-squarefeet] => Array ( [0] => 6249.52 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3400000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #03 Single Family Home ResaleClub VillasActive ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9552 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-03/ ) [ffd_media] => Array ( [0] => a:5:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/h3d57r9e4/1.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/jk624pqvz/2.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/yt1beifzb/3.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/affdtcwvd/6.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/x5nggmn6e/8.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000002XQEQ/h3d57r9e4/1.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKin6QAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) )Club Villa #03 Club Villas Single Family Home $3,400,000 | 4,250 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Array ( [ffd_listing_title] => Array ( [0] => El Campo #07 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-3378 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KUmpxQAD ) [ffd_totalarea_pb] => Array ( [0] => 4550.66 ) [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] => 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 Campo ) [ffd_createddate] => Array ( [0] => 2022-08-30T16:05:11.000+0000 ) [ffd_days_on_market] => Array ( [0] => 72 ) [ffd_description_pb] => Array ( [0] => Move in this November, El Campo 7 is the last remaining available home within the enclave of 11 homesites overlooking the 7th hole on the award-winning Tom Fazio course. Experience elevated living at the apex of Querencia. El Campo 7 features a sprawling floorplan overlooking the trifecta of Baja beauty: sea, golf, and mountain views. Enter through a serene courtyard into the spacious open floorplan. El Campo 7 will feature the finest of finishes throughout, alongside luxury appliances and custom craftsmanship. Inside, a 4-bedroom, 4.5-bathroom floorplan with extended common areas. Outside, the 1,300+ sq. ft of covered terrace overlooks an infinity-edge pool, with a spa alongside an outdoor kitchen and covered fire pit/pavilion. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-11-10T17:22:44.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] => 5500000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70915 ) [ffd_community_lot_number] => Array ( [0] => 7 ) [wpcf-lotsize] => Array ( [0] => 19587 ) [wpcf-lot-size-sqm] => Array ( [0] => 1819.69 ) [wpcf-mls] => Array ( [0] => 22-3378 ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [wpcf-acarea] => Array ( [0] => 5388 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_id] => Array ( [0] => a093Z00000KUmpxQAD ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Under Contract ) [ffd_name] => Array ( [0] => El Campo #07 ) [wpcf-squarefeet] => Array ( [0] => 6783.53 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 5500000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean El Campo #07 Single Family Home 22-3378ResaleEl CampoUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9517 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/el-campo-07-2/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:106:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/atzcgkuqk/1-3%20copia.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/y9u399we4/2.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/jdqfpi9uy/5.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/nb0334eoi/4.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/4o4tovepu/3.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/yhdirn9l5/7.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/fc1xeiuw2/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/5lf0d18hu/3.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/5gh1pcnpr/2.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/giwdgzz8c/4.jpg";i:10;s:107:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/a57cxehbl/1-3%20copia3.jpg";i:11;s:110:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/i0uzdhu1z/1-3%20copia%202.jpg";i:12;s:109:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/pjhgjguh6/1-3%20copia%20.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0C3Z00000IfyYu/atzcgkuqk/1-3%20copia.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KUmpxQAD ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 8668 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1664989849:11 ) )El Campo #07 El Campo Single Family Home $5,500,000 | 5,388 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #55 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KKaKnQAL ) [ffd_totalarea_pb] => Array ( [0] => ) [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] => ) [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] => Las Colinas ) [ffd_createddate] => Array ( [0] => 2022-10-31T21:45:35.000+0000 ) [ffd_days_on_market] => Array ( [0] => 72 ) [ffd_description_pb] => Array ( [0] => These incredible Querencia homesites are situated on hilltops overlooking the crystal blue Sea of Cortez with sweeping vistas spanning the San José del Cabo coast all the way to Punta Gorda. As some of the most magnificent real estate properties in all of Los Cabos, the homesites at Las Colinas provide the ideal canvas for the region’s most influential architects and artisans to create absolute masterpieces. An inspiring environment matched only by the magic of Querencia, build your custom home today. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2023-01-11T17:23:51.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.06362 ) [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] => 925000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 47770 ) [wpcf-lot-size-sqm] => Array ( [0] => 4437.98 ) [wpcf-mls] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [wpcf-acarea] => Array ( [0] => ) [wpcf-property-type] => Array ( [0] => lot ) [ffd_listing_agent_1] => Array ( [0] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KKaKnQAL ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Under Contract ) [ffd_name] => Array ( [0] => Las Colinas #55 ) [wpcf-squarefeet] => Array ( [0] => 47774.54 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 925000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #55 Homesite ResaleLas ColinasUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9548 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-55/ ) [ffd_media] => Array ( [0] => a:9:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/15mx9t4rc/2.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/5usvxmsk1/3.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/urgfz4ggm/5.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/6q55vxzsh/10.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/6bf5mz7ff/4.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/uf7k4w1xx/6.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/3n655nwsa/7.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/qfxnro5rd/8.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/4qjfsb9hj/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001QdQr/15mx9t4rc/2.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KKaKnQAL ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [ffd_record_is_deleted] => Array ( [0] => ) )Las Colinas #55 Las Colinas Homesite $925,000 Lot Size 47770 sq ft 4437.98 sq m
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Laderas #01 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-1060 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWzVPQA1 ) [ffd_totalarea_pb] => Array ( [0] => 5790 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => 1 Calle de Las Laderas ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [wpcf-bathrooms] => Array ( [0] => 5 ) [wpcf-bedrooms] => Array ( [0] => 5 ) [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-03-09T17:22:07.000+0000 ) [ffd_days_on_market] => Array ( [0] => 106 ) [ffd_description_pb] => Array ( [0] => Laderas 1 is a sprawling, single-level home centrally located midway from the Clubhouse and the Beach Club within the Laderas neighborhood within Querencia. The residence offers five bedrooms and five full and two half baths amidst an open floorplan that flows seamlessly. Inside, experience custom carpentry throughout, along with expansive storage space in each of the bedrooms. The fifth bedroom is also flex space with private entrance, bath and closet, ideal for a live-in nanny, or easily transitioned to a fitness room, bonus room or wine celler. Outside enjoy a generous terrace, complete with pool and jacuzzi and outdoor bath. Laderas 1 is within walking distance to Querencia more than 12 miles of hiking and biking trails, including the Querencia suspension bridge. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 2 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-06-23T15:23:14.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.02522 ) [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] => 5650000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.73097 ) [ffd_community_lot_number] => Array ( [0] => 1 ) [wpcf-lotsize] => Array ( [0] => 16953.16 ) [wpcf-lot-size-sqm] => Array ( [0] => 1575 ) [wpcf-mls] => Array ( [0] => 22-1060 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 5357 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWzVPQA1 ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Sold ) [ffd_name] => Array ( [0] => Laderas #01 ) [wpcf-squarefeet] => Array ( [0] => 9433 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 5650000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Laderas #01 Single Family Home 22-1060ResaleLaderasSold ) [ffd_yearbuilt_pb] => Array ( [0] => 2016 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9334 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/laderas-01/ ) [ffd_media] => Array ( [0] => a:16:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/5myob3rr4/10.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/cfe6i4sgi/16.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/3jurdx186/2.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/ikp3yblv3/3.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/i7xfrux5h/22.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/x4g7i8v1p/5.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/aboim8jxa/6.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/a401locha/19.jpg";i:8;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/6gbilarnn/21.jpg";i:9;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/89b8u12iw/25.jpg";i:10;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/ikwy7xguj/31.jpg";i:11;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/pczrcu9iy/32.jpg";i:12;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/ew1wdnko1/17.jpg";i:13;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/4rqy7cb3z/14.jpg";i:14;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/tvwo3dw6b/15.jpg";i:15;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/iiobxpjgj/23.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000005eXbZ/5myob3rr4/10.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWzVPQA1 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Laderas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 5338 ) )Laderas #01 Laderas Single Family Home | 5,357 A/C SQFT 5 Beds 5 Full Baths 2 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #37 (Casa Amanecer) ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 21-4315 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWg6YQAT ) [ffd_totalarea_pb] => Array ( [0] => 5465.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] => 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] => 2021-12-21T20:58:36.000+0000 ) [ffd_days_on_market] => Array ( [0] => 177 ) [ffd_description_pb] => Array ( [0] => An amazing opportunity to own a panoramic ocean view and energy-efficient residence within the masterplanned community of Querencia. The main and lower levels have a frameless glass railing, serving up vistas of endless ocean views from all the bedrooms and even the kitchen, living room and dining room. This elegant, turn-key 4-bedroom, 4.5-bathroom home offers tremendous value. It was built with myriad of elegant details, an open-concept floorplan integrating a large living room, spacious dining room and a chef's kitchen with pristine granite countertops. The upper-level patio offers relaxing and lounging areas with a swimming pool and hot tub and the lower-level terrace has an entertaining area with pool table, TV and a comfortable seating area. The house also includes a state-of-the-art media room with a large screen TV. The garage is conveniently located on the main level with convenient access to the house. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-05-09T06:09:48.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.07356 ) [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] => 3285000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.71538 ) [ffd_community_lot_number] => Array ( [0] => 37 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 21-4315 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 5466 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWg6YQAT ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Sold ) [ffd_name] => Array ( [0] => Las Colinas #37 (Casa Amanecer) ) [wpcf-squarefeet] => Array ( [0] => 9765.24 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3285000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #37 (Casa Amanecer) Single Family Home 21-4315ResaleLas ColinasSold ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23450 ) [pba__WebsiteId__c] => Array ( [0] => 9249 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-37-casa-amanecer/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/w7yuwg63y/10.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/4i1k5n5uc/1%20copia.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ray2bup6k/2.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/gg2a5j7ut/3.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/yk8o70aj3/4.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ymvq3f795/5.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/dbyemyl4i/6.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/8kwonmjqh/7.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/494fitigu/8.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/ay6e9mh83/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000IalS/w7yuwg63y/10.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWg6YQAT ) [wpcf-agent-1] => Array ( [0] => 0053Z00000Kt8H2 ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Las Colinas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) )Las Colinas #37 (Casa Amanecer) Las Colinas Single Family Home | 5,466 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #30 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-1277 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWwUrQAL ) [ffd_totalarea_pb] => Array ( [0] => 3527.98 ) [wpcf-property-features] => Array ( [0] => ) [ffd_address_pb] => Array ( [0] => Querencia ) [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_createddate] => Array ( [0] => 2022-02-25T18:53:57.000+0000 ) [ffd_days_on_market] => Array ( [0] => 138 ) [ffd_description_pb] => Array ( [0] => Upon entering the serene courtyard of Querencia's Club Villa 30, you'll immediately sense the connection of home to lifestyle. A thoughtful floor plan, seamlessly integrating the indoors with outdoor living, combined with tasteful décor, provide all that is needed to live life to the fullest. Family and friends will enjoy top-of-the line furnishings and finishes, which highlight every room and allow one to relax and enjoy all that Querencia has to offer. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [ffd_lastmodifieddate] => Array ( [0] => 2022-07-13T15:21:51.000+0000 ) [wpcf-latitude] => Array ( [0] => -34.73853 ) [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] => 3000000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -56.4424 ) [ffd_community_lot_number] => Array ( [0] => 30 ) [wpcf-lotsize] => Array ( [0] => 12223.5 ) [wpcf-lot-size-sqm] => Array ( [0] => 1135.6 ) [wpcf-mls] => Array ( [0] => 22-1277 ) [ffd_website_status_2] => Array ( [0] => Sold ) [wpcf-acarea] => Array ( [0] => 3528 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000LsPqqQAF ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWwUrQAL ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Sold ) [ffd_name] => Array ( [0] => Club Villa #30 ) [wpcf-squarefeet] => Array ( [0] => 4349.16 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 3000000 ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #30 Single Family Home 22-1277ResaleClub VillasSold ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9321 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-30/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c18be2nv1pj71ib91p9qhqd2qk3/Querencia-Club-Villa-30-LA76-Photography-40.jpg";i:1;s:115:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c1lbqo8q10ntmojurcqss1f5la/2.JPG";i:2;s:157:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tql0o8181fihulv9c711t22/Querencia-Club-Villa-30-LA76-Photography-02.jpg";i:3;s:157:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33ts36h1u41p6015ec5p8qig4/Querencia-Club-Villa-30-LA76-Photography-06.jpg";i:4;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tt9mu1v59l3m17vofpg15tc6/Querencia-Club-Villa-30-LA76-Photography-10.jpg";i:5;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tuc6s15rieu5i8d1v3h12108/Querencia-Club-Villa-30-LA76-Photography-16.jpg";i:6;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33tvegn1bfql7k5qs12651sr5a/Querencia-Club-Villa-30-LA76-Photography-17.jpg";i:7;s:159:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33u0nfe1g4e1v06132m9vj1eijc/Querencia-Club-Villa-30-LA76-Photography-18.jpg";i:8;s:156:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33u27vapn91k5lsnjt5um0se/Querencia-Club-Villa-30-LA76-Photography-44.jpg";i:9;s:158:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33u810b1ci71pvskj711jk29tg/Querencia-Club-Villa-30-LA76-Photography-11.jpg";i:10;s:156:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33ubbukkj9lmk1l71bpmtnqi/Querencia-Club-Villa-30-LA76-Photography-08.jpg";i:11;s:156:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c33ug80jko217l38rgcjkq24k/Querencia-Club-Villa-30-LA76-Photography-45.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000004DaZo/p1c18be2nv1pj71ib91p9qhqd2qk3/Querencia-Club-Villa-30-LA76-Photography-40.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWwUrQAL ) [wpcf-agent-1] => Array ( [0] => 0053Z00000LsPqq ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_community] => Array ( [0] => Club Villas ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) )Club Villa #30 Club Villas Single Family Home | 3,528 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #24 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 20-578 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000IkCqOQAV ) [ffd_totalarea_pb] => Array ( [0] => 7140.98 ) [ffd_address_pb] => Array ( [0] => Km. 27.5 Transpeninsular Hwy. ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_createddate] => Array ( [0] => 2020-02-07T17:41:35.000+0000 ) [ffd_days_on_market] => Array ( [0] => 444 ) [ffd_description_pb] => Array ( [0] => Understated opulence abounds upon arrival within the traditional Mexican hacienda-style courtyard, complete with firepit, at Club Villa 24. This impeccable, three-story custom residence is situated on Hole 16 on the private, award-winning Tom Fazio course. Unlike any other villa within Querencia, the residence features a collection of six bedrooms, 4 full and two half baths, along with a finished basement that includes a family room, library, media room, bar and wine cellar. Inside, the expansive gourmet kitchen and pristine formal dining and living rooms open seamlessly to the terrace, fusing the outdoor and indoor living spaces. Enjoy ample alfresco entertaining space that includes an outdoor kitchen, dining area and firepit. ) [ffd_lastmodifieddate] => Array ( [0] => 2022-06-15T17:50:22.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 2950000 ) [ffd_community_lot_number] => Array ( [0] => 24 ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000IkCqOQAV ) [ffd_name] => Array ( [0] => Club Villa #24 ) [ffd_yearbuilt_pb] => Array ( [0] => 2010 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7901 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-24/ ) [ffd_media] => Array ( [0] => a:20:{i:0;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg";i:1;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/uu1pbgdwy/DJI_0318.jpg";i:2;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/5jinhs2po/_DSC8049.jpg";i:3;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/sjn5nbl2d/DJI_0056.jpg";i:4;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/4nja12sy9/_DSC9002.jpg";i:5;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/14kygbdle/_DSC9053.jpg";i:6;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/6odiy8q0z/_DSC8307.jpg";i:7;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/q8waudq3r/_DSC8274.jpg";i:8;s:108:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/ih4yeeagd/_DSC8945-Edit.jpg";i:9;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/pe8juiz5v/_DSC9505.jpg";i:10;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/0fncb18qz/_DSC9103.jpg";i:11;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/t9yudw8zz/_DSC9228.jpg";i:12;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/juxru70g7/_DSC8166.jpg";i:13;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/x8cs948pq/_DSC9686.jpg";i:14;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/h7ctajb3w/_DSC8207.jpg";i:15;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/e1r8d8ttn/DJI_0369.jpg";i:16;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/2pb5qv14l/_DSC8432.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/i30jdx4et/Laderas_1.mp4.00_00_40_02.Still004.jpg";i:18;s:103:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/g48hjynb2/DJI_0363.JPG";i:19;s:125:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/p1agthmd6cdjci1q10n3141a14912/VILLA%2024.pdf";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zvdn/popeusa53/DJI_0036.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_website_status_2] => Array ( [0] => Sold ) [ffd_sort_by] => Array ( [0] => C ) [_edit_lock] => Array ( [0] => 1635289534:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [_edit_last] => Array ( [0] => 5 ) [_ffd_website_status_2] => Array ( [0] => field_608827aae073c ) [featured] => Array ( [0] => ) [_featured] => Array ( [0] => field_615b2b0a187e6 ) [_yoast_wpseo_primary_category] => Array ( [0] => ) [wpcf-tripple-icon] => Array ( [0] => default ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000IkCqOQAV ) [wpcf-property-type] => Array ( [0] => home ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Sold ) [wpcf-lotsize] => Array ( [0] => 11077.68 ) [wpcf-lot-size-sqm] => Array ( [0] => 1029.15 ) [wpcf-price] => Array ( [0] => 2950000 ) [wpcf-mls] => Array ( [0] => 20-578 ) [wpcf-squarefeet] => Array ( [0] => 8831.9 ) [wpcf-acarea] => Array ( [0] => 7141 ) [wpcf-bedrooms] => Array ( [0] => 6 ) [wpcf-bathrooms] => Array ( [0] => 6 ) [wpcf-half-bathrooms] => Array ( [0] => 2 ) [wpcf-latitude] => Array ( [0] => 23.02599 ) [wpcf-longitude] => Array ( [0] => -109.74673 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #24 Single Family Home 20-578ResaleClub VillasSold ) [wpcf-listing-type] => Array ( [0] => Resale ) [_yoast_wpseo_content_score] => Array ( [0] => 30 ) [wpcf-property-features] => Array ( [0] => ) [ffd_actual_close_date] => Array ( [0] => ) [ffd_colistingagentmlsid] => Array ( [0] => ) [ffd_colistingagentname] => Array ( [0] => ) [ffd_colistingofficemlsid] => Array ( [0] => ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [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_listing_agent_2] => Array ( [0] => ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [ffd_website_status] => Array ( [0] => Sold ) [ffd_community] => Array ( [0] => Club Villas ) )Club Villa #24 Club Villas Single Family Home | 7,141 A/C SQFT 6 Beds 6 Full Baths 2 Half Baths
SoldSold
"*" indicates required fields