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
20
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] => 61 ) [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-05-09T06:09:48.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] => Under Contract ) [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] => Under Contract ) [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] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean Laderas #01 Single Family Home 22-1060ResaleLaderasUnder Contract ) [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] => ) )Laderas #01 Single Family Home $5,650,000 | 5,357 A/C SQFT 5 Beds 5 Full Baths 2 Half Baths
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #30 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [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] => 73 ) [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-05-09T06:09:56.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] => ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [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] => Under Contract ) [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] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #30 Single Family Home ResaleClub VillasUnder Contract ) [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] => ) )Club Villa #30 Single Family Home $3,000,000 | 3,528 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Under ContractUnder Contract
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] => 406 ) [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-05-09T06:09:38.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] => Under Contract ) [ffd_sort_by] => Array ( [0] => B ) [_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] => Under Contract ) [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 VillasUnder Contract ) [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] => Under Contract ) )Club Villa #24 Club Villas Single Family Home $2,950,000 | 7,141 A/C SQFT 6 Beds 6 Full Baths 2 Half Baths
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #22 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-151 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWjnqQAD ) [ffd_totalarea_pb] => Array ( [0] => 3502.95 ) [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] => 3 ) [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-01-12T16:43:55.000+0000 ) [ffd_days_on_market] => Array ( [0] => 118 ) [ffd_description_pb] => Array ( [0] => Through the gates of the private 2,000-acre Querencia community find Club Villa 22. Overlooking the 16th fairway of the award-winning Tom Fazio Championship course, the residence offers panoramic views that capture the natural beauty of the Baja landscape and the crystalline waters of the Sea of Cortez. Upon entering the open-air courtyard experience the soothing sound of a cascading fountain and the lush, manicured garden. Villa 22 offers four bedrooms and 3.5 baths and a seamless indoor/outdoor living space ideal for entertaining. Outside, the expansive terrace features a pool and jacuzzi, along with a fire pit and outdoor kitchen. At Villa 22, experience exceptional design detail throughout, including updated smooth-textured walls, energy-efficient A/C system, and overall efficiency in terms of annual costs. ) [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:56.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] => 2295000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70247 ) [ffd_community_lot_number] => Array ( [0] => 22 ) [wpcf-lotsize] => Array ( [0] => 11077.68 ) [wpcf-lot-size-sqm] => Array ( [0] => 1029.15 ) [wpcf-mls] => Array ( [0] => 22-151 ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [wpcf-acarea] => Array ( [0] => 3503 ) [wpcf-property-type] => Array ( [0] => home ) [ffd_listing_agent_1] => Array ( [0] => 005f100000I1eqJAAR ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWjnqQAD ) [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] => Club Villa #22 ) [wpcf-squarefeet] => Array ( [0] => 4517 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 2295000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #22 Single Family Home 22-151ResaleClub VillasUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => 2008 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9251 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-22/ ) [ffd_media] => Array ( [0] => a:18:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/nun4qx2fh/4.jpg";i:1;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/ip8zztk9a/1%20copia.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/l0lwrvn9b/3.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/m17dy0g9v/10.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/sm2rdpfi1/11.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/b77nemizl/12.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/1d72meknf/13.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/f9l8s921x/14.jpg";i:8;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/lxlhkphpk/15.jpg";i:9;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/di4eaoq1p/16.jpg";i:10;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/ntnj4d33i/17.jpg";i:11;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/4la9zgq86/18.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/0xns8r95f/2.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/yjrrev1g9/5.jpg";i:14;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/wosda9rrt/6.jpg";i:15;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/gjrabg1dq/7.jpg";i:16;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/re0252ma8/8.jpg";i:17;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/5h4j9av1l/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003zncT/nun4qx2fh/4.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWjnqQAD ) [wpcf-agent-1] => Array ( [0] => 005f100000I1eqJ ) [ffd_record_is_deleted] => Array ( [0] => ) )Club Villa #22 Single Family Home $2,295,000 | 3,503 A/C SQFT 4 Beds 3 Full Baths 1 Half Baths
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Club Villa #11 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 20-1182 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000IkO60QAF ) [ffd_totalarea_pb] => Array ( [0] => 4048 ) [ffd_address_pb] => Array ( [0] => Villa 11 Querencia ) [ffd_mgmt_approved_for_website_publishing] => Array ( [0] => 1 ) [ffd_city_pb] => Array ( [0] => San Jose del Cabo ) [ffd_createddate] => Array ( [0] => 2020-02-20T19:14:26.000+0000 ) [ffd_days_on_market] => Array ( [0] => 760 ) [ffd_description_pb] => Array ( [0] => Club Villa 11 is a private respite. Upon entering the lush and meticulously landscaped courtyard you are enveloped in relaxed opulence. Inside, the expansive living space is designed in an open concept; ideal for entertaining friends and family. The custom finishes and interior design are thoughtfully inspired to highlight the stunning view of the Sea of Cortez on display throughout the two-story home. Outside, the extensive natural stone terrace features an infinity-edge pool with jacuzzi and outdoor dining with BBQ. Just steps from the Querencia Clubhouse and Tom Fazio golf, Club Villa 11 is your entre into a community overflowing with activities, camaraderie and amenities. Welcome home. ) [ffd_lastmodifieddate] => Array ( [0] => 2022-05-09T06:09:38.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 2200000 ) [ffd_community_lot_number] => Array ( [0] => 11 ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000IkO60QAF ) [ffd_name] => Array ( [0] => Club Villa #11 ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7895 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/club-villa-11/ ) [ffd_media] => Array ( [0] => a:18:{i:0;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg";i:1;s:117:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wxb321s1z/Club%20Villa%20487-187.jpg";i:2;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/f3gxik8o8/Club%20Villa%2011%20Querencia%20223.jpg";i:3;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5ekiv5zwo/Club%20Villa%2011%20Querencia%20217.jpg";i:4;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/ct991ewl6/Club%20Villa%2011%20Querencia%20116.jpg";i:5;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k89ut4cp5/Club%20Villa%2011%20Querencia%2051.jpg";i:6;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/k18fttq1k/Club%20Villa%2011%20Querencia%2088.jpg";i:7;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/0kzhuy3z1/Club%20Villa%2011%20Querencia%20228.jpg";i:8;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/1q3hga2bf/Club%20Villa%2011%20Querencia%2032.jpg";i:9;s:120:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/noxqrvlgm/club%20villa%2011squid-78.jpg";i:10;s:116:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/jd78f091k/Club%20Villa%20185%20.jpg";i:11;s:130:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/9h68jskl1/Club%20Villa%2011%20Querencia%20100.jpg";i:12;s:113:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/r7saew8gg/Club%20Villa%20204.jpg";i:13;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/hno51rvco/Club%20Villa%2011%20Querencia%2070.jpg";i:14;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/5rhiysjbi/Club%20Villa%2011%20Querencia%2097.jpg";i:15;s:134:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/7a2yvtzu1/Club%20Villa%2011%20Querencia%20122%202.jpg";i:16;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/wtp85a5oq/Club%20Villa%2011%20Querencia%2042.jpg";i:17;s:129:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/vxzekgcii/Club%20Villa%2011%20Querencia%2016.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000003pJYi/19lxj0leh/Club%20Villa%2011%20Querencia%20107.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_sort_by] => Array ( [0] => B ) [_edit_lock] => Array ( [0] => 1635289820:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1901 ) [_edit_last] => Array ( [0] => 5 ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [_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] => a093Z00000IkO60QAF ) [wpcf-property-type] => Array ( [0] => home ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Under Contract ) [wpcf-lotsize] => Array ( [0] => 8230.41 ) [wpcf-lot-size-sqm] => Array ( [0] => 764.63 ) [wpcf-price] => Array ( [0] => 2200000 ) [wpcf-mls] => Array ( [0] => 20-1182 ) [wpcf-squarefeet] => Array ( [0] => 6209.59 ) [wpcf-acarea] => Array ( [0] => 4048 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.02788 ) [wpcf-longitude] => Array ( [0] => -109.74612 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-keywords] => Array ( [0] => Ocean Club Villa #11 Single Family Home 20-1182ResaleClub VillasUnder Contract ) [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] => Under Contract ) )Club Villa #11 Club Villas Single Family Home $2,200,000 | 4,048 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
Under ContractUnder Contract
Array ( [ffd_listing_title] => Array ( [0] => Cabaña #06 Lower ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-415 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000JWoTmQAL ) [ffd_totalarea_pb] => Array ( [0] => 2800 ) [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] => 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_createddate] => Array ( [0] => 2022-01-27T16:54:48.000+0000 ) [ffd_days_on_market] => Array ( [0] => 105 ) [ffd_description_pb] => Array ( [0] => This spacious ground-level mountain view cabaña not only overlooks the Las Cabañas pool and community area, but also features a private entrance, as well. Inside, the 3 bedroom residence features an airy, open floor plan and updated appliances. The exceptionally landscaped green space and expansive terrace allow for seamless indoor and outdoor living. ) [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:56.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03163 ) [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] => 1695000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.74773 ) [ffd_community_lot_number] => Array ( [0] => 6.1 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => 22-415 ) [ffd_website_status_2] => Array ( [0] => Under Contract ) [wpcf-acarea] => Array ( [0] => 2800 ) [wpcf-property-type] => Array ( [0] => condo ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000JWoTmQAL ) [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] => Cabaña #06 Lower ) [wpcf-squarefeet] => Array ( [0] => 4149.25 ) [wpcf-view] => Array ( [0] => Mountain ) [wpcf-price] => Array ( [0] => 1695000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Mountain Cabaña #06 Lower Condominium 22-415ResaleLas CabanasUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 234 ) [pba__WebsiteId__c] => Array ( [0] => 9297 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/cabana-06-lower/ ) [ffd_media] => Array ( [0] => a:12:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/t6yuhtjod/2.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/bzlcy59nu/3.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/gvmw0c1o4/11.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/zd6tcr60z/1.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/xcez6ekhq/6.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/hsnnhwzln/10.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/lkebt309l/12.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/wzbetm8f6/4.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/hl9y8ajn6/5.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/i02sq52pe/7.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/bjlq5cp4i/8.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/1kzggsbdt/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000041lv1/t6yuhtjod/2.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000JWoTmQAL ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [ffd_record_is_deleted] => Array ( [0] => ) [_edit_lock] => Array ( [0] => 1645713776:10 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1888 ) )Cabaña #06 Lower Las Cabañas Condominium $1,695,000 | 2,800 A/C SQFT 3 Beds 3 Full Baths 1 Half Baths
Under ContractUnder Contract
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] => 139 ) [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] => ) )Las Colinas #37 (Casa Amanecer) Single Family Home | 5,466 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Cañada #09 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 16-1596 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000It8yoQAB ) [ffd_totalarea_pb] => Array ( [0] => 4260.3 ) [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_createddate] => Array ( [0] => 2021-04-23T18:07:01.000+0000 ) [ffd_days_on_market] => Array ( [0] => 384 ) [ffd_description_pb] => Array ( [0] => Experience sweeping vistas of the Sea of Cortez, Punta Gorda and San Jose, high atop Querencia's canyon ridge from Cañada 9. Step inside the stone courtyard and experience a coastal contemporary design in this serene custom villa. Cañada 9 offers 5 bedrooms within the light-filled, open floor plan and a gourmet kitchen with Viking and Sub-Zero appliances. Ideal for entertaining, Cañada 9's sprawling outdoor living space includes both covered and uncovered terraces, an infinity-edge pool and jacuzzi, pavilion and outdoor kitchen. Cañada 9 is just a short golf cart ride away from Querencia sprawling Club village, home to the 18-hole Tom Fazio golf course, 7 restaurants, pools and amenities for all ages. ) [ffd_lastmodifieddate] => Array ( [0] => 2022-05-09T06:09:38.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 2525000 ) [ffd_community_lot_number] => Array ( [0] => 9 ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_id] => Array ( [0] => a093Z00000It8yoQAB ) [ffd_name] => Array ( [0] => Cañada #09 ) [ffd_website_status_2] => Array ( [0] => Sold ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7911 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/canada-09/ ) [ffd_media] => Array ( [0] => a:19:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/ca9ewz9bh/1.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/imu0unvnm/10.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/s9w3lruok/11.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/fk0lf3lj7/12.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/mvys0o9w3/13.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/okbib8zwh/14.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/4vq4wes0i/15.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/b0xpr3ncs/17.jpg";i:8;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/d9cdiaqr8/18.jpg";i:9;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/3ngecyi1o/19.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vusk0tye0/2.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vfzijfnpo/3.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/oeewprrgs/4.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/71pfwetex/5.jpg";i:14;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/vbbuwwkvv/16.jpg";i:15;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/a4vpboycu/6.jpg";i:16;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/3598mv3di/7.jpg";i:17;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/18hcorxdm/8.jpg";i:18;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/tshdu7hdm/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mL8R/ca9ewz9bh/1.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [_edit_lock] => Array ( [0] => 1635289670:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1892 ) [_edit_last] => Array ( [0] => 5 ) [_yoast_wpseo_content_score] => Array ( [0] => 30 ) [_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] => a093Z00000It8yoQAB ) [wpcf-property-type] => Array ( [0] => home ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Sold ) [wpcf-lotsize] => Array ( [0] => 14224.49 ) [wpcf-lot-size-sqm] => Array ( [0] => 1321.5 ) [wpcf-price] => Array ( [0] => 2525000 ) [wpcf-mls] => Array ( [0] => 16-1596 ) [wpcf-squarefeet] => Array ( [0] => 4716.68 ) [wpcf-acarea] => Array ( [0] => 4260 ) [wpcf-bedrooms] => Array ( [0] => 5 ) [wpcf-bathrooms] => Array ( [0] => 5 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.03353 ) [wpcf-longitude] => Array ( [0] => -109.73999 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-keywords] => Array ( [0] => Ocean Cañada #09 Single Family Home 16-1596ResaleCañadasSold ) [wpcf-listing-type] => Array ( [0] => Resale ) [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_yearbuilt_pb] => Array ( [0] => ) )Cañada #09 Cañadas Single Family Home | 4,260 A/C SQFT 5 Beds 5 Full Baths 1 Half Baths
SoldSold
Array ( [ffd_listing_title] => Array ( [0] => Cañada #08 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 21-1037 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000Isvq9QAB ) [ffd_totalarea_pb] => Array ( [0] => 4006.44 ) [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] => 2021-03-16T17:20:28.000+0000 ) [ffd_days_on_market] => Array ( [0] => 419 ) [ffd_description_pb] => Array ( [0] => Rich with detail, this spectacular 4 bedroom turnkey ready single-family home is perched along a ridge line overlooking a beautiful canyon with expansive views to the Sea of Cortez as the primary vistas yet also offering panoramic secondary vistas of the Querencia Fazio Golf Course and Club Village. This home features indoor & outdoor fireplaces. The Master Suite Bath offers indoor/outdoor showers & French Doors which open to an open-air relaxation garden accented with a cascading water feature that can be enjoyed from the free standing soaker tub. With the open floor plan concept of the great room & kitchen this creates a perfect environment for hosting family and guest. The Cañada neighborhood has proven to be one of the most sought after addresses in Querencia. ) [ffd_lastmodifieddate] => Array ( [0] => 2022-05-09T06:09:48.000+0000 ) [ffd_listingprice_pb] => Array ( [0] => 2500000 ) [ffd_community_lot_number] => Array ( [0] => 8 ) [ffd_listing_agent_1] => Array ( [0] => 0053Z00000KX9ZYQA1 ) [ffd_listing_agent_2] => Array ( [0] => 0053Z00000Kt8H2QAJ ) [ffd_id] => Array ( [0] => a093Z00000Isvq9QAB ) [ffd_name] => Array ( [0] => Cañada #08 ) [ffd_website_status_2] => Array ( [0] => Sold ) [ffd_yearbuilt_pb] => Array ( [0] => 2015 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 7935 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/canada-08/ ) [ffd_media] => Array ( [0] => a:14:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jn1xp62fk/1.jpg";i:1;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/434p3v3st/10.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/2b7nyqgvf/11.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/8b0bt1smy/12.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jyd6kchq5/13.jpg";i:5;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/3mqu0jmss/14.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/9g5ns9vwz/2.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/67bcz5j9q/3.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/q4h9mqn93/4.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/5yl2hg7rd/5.jpg";i:10;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/2xlldpq0a/6.jpg";i:11;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/5epp48gbw/7.jpg";i:12;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/6p91p5cvq/8.jpg";i:13;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/grv86olky/9.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000000mSsq/jn1xp62fk/1.jpg ) [ffd_record_is_deleted] => Array ( [0] => ) [ffd_sort_by] => Array ( [0] => C ) [ffd_website_status] => Array ( [0] => Sold ) [_edit_lock] => Array ( [0] => 1635289379:5 ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1892 ) [_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] => a093Z00000Isvq9QAB ) [wpcf-property-type] => Array ( [0] => home ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-ribbon] => Array ( [0] => Sold ) [wpcf-lotsize] => Array ( [0] => 14270.84 ) [wpcf-lot-size-sqm] => Array ( [0] => 1325.8 ) [wpcf-mls] => Array ( [0] => 21-1037 ) [wpcf-squarefeet] => Array ( [0] => 5863.88 ) [wpcf-acarea] => Array ( [0] => 4006 ) [wpcf-bedrooms] => Array ( [0] => 4 ) [wpcf-bathrooms] => Array ( [0] => 4 ) [wpcf-half-bathrooms] => Array ( [0] => 1 ) [wpcf-latitude] => Array ( [0] => 23.033318 ) [wpcf-longitude] => Array ( [0] => -109.739545 ) [wpcf-agent-1] => Array ( [0] => 0053Z00000KX9ZY ) [wpcf-agent-2] => Array ( [0] => 0053Z00000Kt8H2 ) [wpcf-keywords] => Array ( [0] => Ocean Cañada #08 Single Family Home 21-1037ResaleCañadasSold ) [wpcf-listing-type] => Array ( [0] => Resale ) [_yoast_wpseo_content_score] => Array ( [0] => 30 ) [wpcf-price] => Array ( [0] => 2500000 ) [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] => ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) )Cañada #08 Cañadas Single Family Home | 4,006 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
SoldSold