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
22
Array ( [ffd_listing_title] => Array ( [0] => Las Colinas #63 ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => 22-3147 ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KImJlQAL ) [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-08-05T20:49:56.000+0000 ) [ffd_days_on_market] => Array ( [0] => 1 ) [ffd_description_pb] => Array ( [0] => Las Colinas homesites are situated on the hilltops overlooking the crystal blue Sea of Cortez with sweeping views spanning the San Jose del Cabo coast to Punta Gorda within the masterplanned community of Querencia. Hoesite 63 offers the ideal canvas for you to create your masterpiece and build your dream home. Experience the magic of Querencia, along with the opportunity to join one of the most vibrant communities in all of Mexico. Just listed, inquire today. ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2022-08-06T16:18:32.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] => 2200000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.70242 ) [ffd_community_lot_number] => Array ( [0] => ) [wpcf-lotsize] => Array ( [0] => 44810 ) [wpcf-lot-size-sqm] => Array ( [0] => 4162.99 ) [wpcf-mls] => Array ( [0] => 22-3147 ) [ffd_website_status_2] => Array ( [0] => ) [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] => a093Z00000KImJlQAL ) [wpcf-resale] => Array ( [0] => ) [ffd_solddate] => Array ( [0] => ) [ffd_soldprice] => Array ( [0] => ) [ffd_state_pb] => Array ( [0] => ) [wpcf-ribbon] => Array ( [0] => Active ) [ffd_name] => Array ( [0] => Las Colinas #63 ) [wpcf-squarefeet] => Array ( [0] => ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 2200000 ) [ffd_sort_by] => Array ( [0] => A ) [ffd_website_status] => Array ( [0] => ) [wpcf-keywords] => Array ( [0] => Ocean Las Colinas #63 Homesite 22-3147ResaleLas ColinasActive ) [ffd_yearbuilt_pb] => Array ( [0] => ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9514 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/las-colinas-63/ ) [ffd_media] => Array ( [0] => a:10:{i:0;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/ya704xvtj/1.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/vokkmezqe/2.jpg";i:2;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/5o4o87vb6/3.jpg";i:3;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/jdza3vpsl/4.jpg";i:4;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/9vr2e66hw/5.jpg";i:5;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/vpj68wfut/6.jpg";i:6;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/e056ob792/7.jpg";i:7;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/dx27sh3j6/8.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/yug9uzpeb/9.jpg";i:9;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/skfsyzqne/10.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj0000001Qc8n/ya704xvtj/1.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KImJlQAL ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1896 ) [ffd_record_is_deleted] => Array ( [0] => ) )Las Colinas #63 Las Colinas Homesite $2,200,000 Lot Size 44810 sq ft 4162.99 sq m
Array ( [ffd_listing_title] => Array ( [0] => Cabaña #01 Upper ) [ffd_unique_id] => Array ( [0] => ) [ffd_mls_id] => Array ( [0] => ) [ffd_salesforce_id] => Array ( [0] => a093Z00000KateOQAR ) [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_community] => Array ( [0] => Las Cabanas ) [ffd_createddate] => Array ( [0] => 2022-07-12T18:00:03.000+0000 ) [ffd_days_on_market] => Array ( [0] => 2 ) [ffd_description_pb] => Array ( [0] => This second floor luxury condominium with vaulted high ceilings, sliding pocket doors, and a private corner location enjoys a breathtaking views of the mountains, ocean, golf, and the evening lights of San José del Cabo. Located next to Querencia´s Club Village, this three 3 bedroom and 3 bath villa combines luxury living with world class lifestyle ) [wpcf-highlights] => Array ( [0] => ) [ffd_displayaddress] => Array ( [0] => ) [featured] => Array ( [0] => no ) [wpcf-half-bathrooms] => Array ( [0] => ) [ffd_lastmodifieddate] => Array ( [0] => 2022-07-14T16:59:02.000+0000 ) [wpcf-latitude] => Array ( [0] => 23.03189 ) [ffd_listofficemlsid] => Array ( [0] => ) [ffd_listofficename] => Array ( [0] => ) [ffd_listing_agent_email] => Array ( [0] => ) [ffd_listing_agent_firstname] => Array ( [0] => ) [ffd_listing_agent_lastname] => Array ( [0] => ) [ffd_listingagentmlsid] => Array ( [0] => ) [ffd_listingagentname] => Array ( [0] => ) [ffd_listingprice_pb] => Array ( [0] => 1900000 ) [wpcf-listing-type] => Array ( [0] => Resale ) [wpcf-longitude] => Array ( [0] => -109.74691 ) [ffd_community_lot_number] => Array ( [0] => 1 ) [wpcf-lotsize] => Array ( [0] => ) [wpcf-lot-size-sqm] => Array ( [0] => 0 ) [wpcf-mls] => Array ( [0] => ) [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] => ) [ffd_listing_agent_2] => Array ( [0] => ) [ffd_id] => Array ( [0] => a093Z00000KateOQAR ) [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 #01 Upper ) [wpcf-squarefeet] => Array ( [0] => 3673.42 ) [wpcf-view] => Array ( [0] => Ocean ) [wpcf-price] => Array ( [0] => 1900000 ) [ffd_sort_by] => Array ( [0] => B ) [ffd_website_status] => Array ( [0] => Under Contract ) [wpcf-keywords] => Array ( [0] => Ocean Cabaña #01 Upper Condominium ResaleLas CabanasUnder Contract ) [ffd_yearbuilt_pb] => Array ( [0] => 2007 ) [ffd_postalcode_pb] => Array ( [0] => 23400 ) [pba__WebsiteId__c] => Array ( [0] => 9502 ) [pba__Listing_Website__c] => Array ( [0] => https://qcabo.com/properties/cabana-01-upper/ ) [ffd_media] => Array ( [0] => a:13:{i:0;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/b3yv8xtf4/17.jpg";i:1;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/q8ddo9zap/6.jpg";i:2;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/fyxxbzn7u/10.jpg";i:3;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/ya8ggfr3c/20.jpg";i:4;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/o5sy40bha/16.jpg";i:5;s:104:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/y238uajfo/1%20copia.jpg";i:6;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/7fufoog6n/13.jpg";i:7;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/wjl29ord9/14.jpg";i:8;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/bysd3jmzm/5.jpg";i:9;s:96:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/n0r4g6xvt/4.jpg";i:10;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/l5u29ojy9/11.jpg";i:11;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/gka1iflr9/12.jpg";i:12;s:97:"https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/25v3ee3ep/19.jpg";} ) [ffd_featured_image] => Array ( [0] => https://s3.amazonaws.com/propertybase-clients/00Dj0000000HEozEAG/a0Cj00000040Wby/b3yv8xtf4/17.jpg ) [wpcf-propertybase-id] => Array ( [0] => a093Z00000KateOQAR ) [_wpcf_belongs_neighborhoods_id] => Array ( [0] => 1888 ) [ffd_record_is_deleted] => Array ( [0] => ) )Cabaña #01 Upper Las Cabañas Condominium $1,900,000 | 2,800 A/C SQFT 3 Beds 3 Full 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] => 143 ) [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 ) [ffd_community] => Array ( [0] => Las Cabanas ) )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] => 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
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] => 422 ) [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] => ) [ffd_community] => Array ( [0] => Cañadas ) )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] => 457 ) [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] => ) [ffd_community] => Array ( [0] => Cañadas ) )Cañada #08 Cañadas Single Family Home | 4,006 A/C SQFT 4 Beds 4 Full Baths 1 Half Baths
SoldSold
"*" indicates required fields