Select Page
array(193) {
["ffd_listing_title"]=>
array(1) {
[0]=>
string(19) "Querencia Colinas 2"
}
["ffd_unique_id"]=>
array(1) {
[0]=>
NULL
}
["ffd_mls_id"]=>
array(1) {
[0]=>
string(7) "25-1484"
}
["ffd_salesforce_id"]=>
array(1) {
[0]=>
string(18) "a0ENv000009Dc2HMAS"
}
["units_in_develop__c"]=>
array(1) {
[0]=>
string(0) ""
}
["x360_virtual_tour_2__c"]=>
array(1) {
[0]=>
string(0) ""
}
["x360_virtual_tour_3__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ac_m2__c"]=>
array(1) {
[0]=>
string(6) "660.28"
}
["ac_sqft__c"]=>
array(1) {
[0]=>
string(7) "7104.61"
}
["Absolute_Longitude__c"]=>
array(1) {
[0]=>
string(10) "109.724437"
}
["pba__Acres_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__address_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_address2_pb"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__AdultCommunity__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_allowedforautopublish"]=>
array(1) {
[0]=>
string(0) ""
}
["amenities__c"]=>
array(1) {
[0]=>
string(94) "Bar,BBQ Area,Deck,Fire Pit,Hot Tub/Jacuzzi,Pool,Pool Heater,Sitting Area,Terrace,Water Feature"
}
["amenities_fireplaces__c"]=>
array(1) {
[0]=>
string(1) "1"
}
["appliances__c"]=>
array(1) {
[0]=>
string(111) "Clothes Washer,Cook Top,Dishwasher,Disposal,Freezer,Ice Maker,Microwave,Refrigerator,Warming Drawer,Wine Fridge"
}
["appliances_dryer__c"]=>
array(1) {
[0]=>
string(3) "Gas"
}
["appliances_oven__c"]=>
array(1) {
[0]=>
string(3) "Gas"
}
["appliances_range__c"]=>
array(1) {
[0]=>
string(3) "Gas"
}
["pba__ApplicationFee_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__area_pb__c"]=>
array(1) {
[0]=>
string(15) "SJD Corr-Inland"
}
["pba__BackAgentMls__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__BankOwned__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__basement_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__fullbathrooms_pb__c"]=>
array(1) {
[0]=>
string(1) "7"
}
["pba__Beachfront__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__bedrooms_pb__c"]=>
array(1) {
[0]=>
string(1) "6"
}
["begin_date__c"]=>
array(1) {
[0]=>
string(10) "2025-03-12"
}
["x360_virtual_tour_1__c"]=>
array(1) {
[0]=>
string(0) ""
}
["branded_video_1__c"]=>
array(1) {
[0]=>
string(0) ""
}
["branded_virtual_tour__c"]=>
array(1) {
[0]=>
string(0) ""
}
["broker_comm__c"]=>
array(1) {
[0]=>
string(2) "6%"
}
["pba__broker_s_listing_id__c"]=>
array(1) {
[0]=>
string(0) ""
}
["year_build_text__c"]=>
array(1) {
[0]=>
string(4) "2025"
}
["pba__buildingstyle__c"]=>
array(1) {
[0]=>
string(0) ""
}
["building_master_property__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__BuyerAgentCommission_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CDH_Website_Link__c"]=>
array(1) {
[0]=>
string(141) "https://cabodreamhomes.com/property/Querencia-Colinas-2"
}
["cancel_date__c"]=>
array(1) {
[0]=>
string(0) ""
}
["carport__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__city_pb__c"]=>
array(1) {
[0]=>
string(17) "San Jose Corridor"
}
["pba__ColistingAgent_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["colistingmemberemail__c"]=>
array(1) {
[0]=>
string(19) "rubenv@delmarre.com"
}
["CoListingMemberName__c"]=>
array(1) {
[0]=>
string(12) "Ruben Vargas"
}
["CoListingMemberPhone__c"]=>
array(1) {
[0]=>
string(14) "(624) 129-9572"
}
["CoListingOfficeName__c"]=>
array(1) {
[0]=>
string(19) "Del Mar Real Estate"
}
["cosellingmemberemail__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoSellingMemberName__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoSellingMemberPhone__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoSellingOfficeName__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoSellingOfficePhone__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ColistingAgentEmail_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ColistingAgentMlsId__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ColistingAgentName__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ColistingOfficeMlsId__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ColistingOfficeName_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["common_amenities__c"]=>
array(1) {
[0]=>
string(121) "Beach Club,Gated,Golf,Guarded,Gym,Handball/Paddleball,Kiddy Park,Pool,Putting/Pitching,Restaurants/Bars,Spa,Tennis Court"
}
["community__c"]=>
array(1) {
[0]=>
string(16) "Querencia-Inland"
}
["community_web_text__c"]=>
array(1) {
[0]=>
string(0) ""
}
["community_web_url__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CompletionDate__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CompletionDate_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CompletionStatus_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity_alarm__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity_dist_to_phone_svc__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity_internet__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity_phone_lines__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity_tv__c"]=>
array(1) {
[0]=>
string(0) ""
}
["connectivity_telephone__c"]=>
array(1) {
[0]=>
string(6) "1 line"
}
["const_construction_type__c"]=>
array(1) {
[0]=>
string(23) "Insulated Foam Concrete"
}
["pba__constructiontype__c"]=>
array(1) {
[0]=>
string(16) "Pre-Construction"
}
["construction_flooring_type__c"]=>
array(1) {
[0]=>
string(10) "Travertine"
}
["contingent__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ContingentDate__c"]=>
array(1) {
[0]=>
string(0) ""
}
["contingent_date_rmrk__c"]=>
array(1) {
[0]=>
string(0) ""
}
["contingent_remarks__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ContractDate__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CosellingAgentMlsId__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CosellingAgentName__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CosellingOfficeMlsId__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CosellingOfficeName_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__Country_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__CountryCode_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__County_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_createdbyid"]=>
array(1) {
[0]=>
string(18) "00539000005g5DpAAI"
}
["createddate"]=>
array(1) {
[0]=>
string(28) "2025-03-15T17:15:44.000+0000"
}
["CurrencyIsoCode"]=>
array(1) {
[0]=>
string(3) "USD"
}
["pba__DaysOffMarket_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["days_on_market__c"]=>
array(1) {
[0]=>
string(3) "381"
}
["pba__DaysOnMarket_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["dom__c"]=>
array(1) {
[0]=>
string(0) ""
}
["decks_patios_m2__c"]=>
array(1) {
[0]=>
string(5) "347.9"
}
["decks_patios_sqft__c"]=>
array(1) {
[0]=>
string(6) "3743.4"
}
["ffd_description_pb"]=>
array(1) {
[0]=>
string(781) "This stunning 6-bedroom, 7 1/2-bathroom custom-built villa, in the prestigious gated community of Querencia, offers unparalleled ocean views of San Jose Bay and the Sea of Cortez. Spanning 7,107 sq. ft. on a 41,000 sq. ft. lot, this modern home blends luxury and coastal elegance.Enter a private gated driveway and over a tranquil water courtyard to enjoy breathtaking ocean views. The open floor plan flows seamlessly to a spacious veranda and poolside terrace, perfect for indoor-outdoor living.A cozy rooftop lookout point, provides a serene escape to enjoy sunrises and starlit skies. Within walking distance to Querencia's Beach Club and a quick golf cart drive to the Clubhouse, this villa is ideally located. Currently in pre-construction, completion is expected by Q3 2025."
}
["ffd_description_seo_richtext"]=>
array(1) {
[0]=>
string(0) ""
}
["devices__c"]=>
array(1) {
[0]=>
string(18) "Water Purification"
}
["devices_air_conditioning__c"]=>
array(1) {
[0]=>
string(7) "Central"
}
["devices_water_heater__c"]=>
array(1) {
[0]=>
string(4) "Tank"
}
["devices_water_heater_size__c"]=>
array(1) {
[0]=>
string(0) ""
}
["devices_water_heater_type__c"]=>
array(1) {
[0]=>
string(0) ""
}
["directions__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_displayaddress"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__dock_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["document_count__c"]=>
array(1) {
[0]=>
string(1) "0"
}
["electricity__c"]=>
array(1) {
[0]=>
string(3) "CFE"
}
["electricity_distance_to_cfe__c"]=>
array(1) {
[0]=>
string(0) ""
}
["end_date__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_externallisting_pb"]=>
array(1) {
[0]=>
string(0) ""
}
["External_Listing__c"]=>
array(1) {
[0]=>
string(1) "1"
}
["financing__c"]=>
array(1) {
[0]=>
string(13) "Cash/Efectivo"
}
["flooring__c"]=>
array(1) {
[0]=>
string(0) ""
}
["flooring_tipo_pisos__c"]=>
array(1) {
[0]=>
string(0) ""
}
["flooring_other__c"]=>
array(1) {
[0]=>
string(0) ""
}
["furnished__c"]=>
array(1) {
[0]=>
string(11) "Unfurnished"
}
["garage_stalls__c"]=>
array(1) {
[0]=>
string(4) "3.00"
}
["hoa_info_dues_amount__c"]=>
array(1) {
[0]=>
string(4) "9000"
}
["hoa_info_dues_period__c"]=>
array(1) {
[0]=>
string(0) ""
}
["hoa_info_hoa_name__c"]=>
array(1) {
[0]=>
string(3) "YES"
}
["hoa_info_phone_contact__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__halfbathrooms_pb__c"]=>
array(1) {
[0]=>
string(1) "1"
}
["pba__HeatingType_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["Helper_Price_Change__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_lastmodifieddate"]=>
array(1) {
[0]=>
string(28) "2026-03-28T00:15:46.000+0000"
}
["pba__latitude_pb__c"]=>
array(1) {
[0]=>
string(9) "23.023965"
}
["legal__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_listofficemlsid"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_listofficename"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__ListingPricePerSqFt_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["listingtooriginallistpriceratio_pb"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_listed_date"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__listing_agent_email__c"]=>
array(1) {
[0]=>
string(20) "michael@delmarre.com"
}
["pba__listing_agent_firstname__c"]=>
array(1) {
[0]=>
string(7) "Michael"
}
["pba__listing_agent_lastname__c"]=>
array(1) {
[0]=>
string(13) "Wayne Baldwin"
}
["ffd_listingagentmlsid"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__listingtype__c"]=>
array(1) {
[0]=>
string(4) "Sale"
}
["listingofficename__c"]=>
array(1) {
[0]=>
string(19) "Del Mar Real Estate"
}
["ffd_virtual_tour_live"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__longitude_pb__c"]=>
array(1) {
[0]=>
string(11) "-109.724437"
}
["lot_m2__c"]=>
array(1) {
[0]=>
string(7) "3831.79"
}
["pba__lotsize_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["mls_id__c"]=>
array(1) {
[0]=>
string(7) "25-1484"
}
["pba__listingprice_pb__c"]=>
array(1) {
[0]=>
string(7) "8950000"
}
["price_mxn__c"]=>
array(1) {
[0]=>
string(12) "170801526.72"
}
["view__c"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["pba__propertytype__c"]=>
array(1) {
[0]=>
string(5) "House"
}
["ListingId"]=>
array(1) {
[0]=>
string(18) "a0ENv000009Dc2HMAS"
}
["road_type__c"]=>
array(1) {
[0]=>
string(5) "Paved"
}
["road_type_highway_front_meters__c"]=>
array(1) {
[0]=>
string(0) ""
}
["road_type_street_front_meters__c"]=>
array(1) {
[0]=>
string(0) ""
}
["sale_date__c"]=>
array(1) {
[0]=>
string(0) ""
}
["secondary_view__c"]=>
array(1) {
[0]=>
string(4) "City"
}
["seller_financing_offered__c"]=>
array(1) {
[0]=>
string(2) "No"
}
["sellingmemberemail__c"]=>
array(1) {
[0]=>
string(18) "craig@delmarre.com"
}
["sewage__c"]=>
array(1) {
[0]=>
string(4) "Muni"
}
["ffd_solddate"]=>
array(1) {
[0]=>
string(0) ""
}
["sale_price__c"]=>
array(1) {
[0]=>
string(0) ""
}
["ffd_soldprice"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__state_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__status__c"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["status_change_date__c"]=>
array(1) {
[0]=>
string(10) "2025-04-28"
}
["pba__street_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["style__c"]=>
array(1) {
[0]=>
string(9) "One Story"
}
["subcommunity__c"]=>
array(1) {
[0]=>
string(0) ""
}
["subdivision__c"]=>
array(1) {
[0]=>
string(22) "Section 1- Las Colinas"
}
["taxes__c"]=>
array(1) {
[0]=>
string(0) ""
}
["title__c"]=>
array(1) {
[0]=>
string(19) "Querencia Colinas 2"
}
["title_fideicomiso__c"]=>
array(1) {
[0]=>
string(5) "Mifel"
}
["topography__c"]=>
array(1) {
[0]=>
string(0) ""
}
["total_m2__c"]=>
array(1) {
[0]=>
string(7) "1308.88"
}
["pba__totalarea_pb__c"]=>
array(1) {
[0]=>
string(8) "14083.55"
}
["pba__listing_website__c"]=>
array(1) {
[0]=>
string(0) ""
}
["unit_details__c"]=>
array(1) {
[0]=>
string(0) ""
}
["unit_details_fireplaces__c"]=>
array(1) {
[0]=>
string(0) ""
}
["unit_details_pet_friendly__c"]=>
array(1) {
[0]=>
string(0) ""
}
["unit_specifics__c"]=>
array(1) {
[0]=>
string(0) ""
}
["video_2__c"]=>
array(1) {
[0]=>
string(0) ""
}
["video_3__c"]=>
array(1) {
[0]=>
string(0) ""
}
["water__c"]=>
array(1) {
[0]=>
string(4) "Muni"
}
["water_dist_to_muni_water__c"]=>
array(1) {
[0]=>
string(0) ""
}
["water_water_tank_liters__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__yearbuilt_pb__c"]=>
array(1) {
[0]=>
string(4) "2025"
}
["pba__postalcode_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["zone__c"]=>
array(1) {
[0]=>
string(17) "San Jose Corridor"
}
["ffd_media"]=>
array(1) {
[0]=>
string(1058) "a:10:{i:0;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-1.jpg";i:1;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-2.jpg";i:2;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-3.jpg";i:3;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-4.jpg";i:4;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-5.jpg";i:5;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-6.jpg";i:6;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-7.jpg";i:7;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-8.jpg";i:8;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-9.jpg";i:9;s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-10.jpg";}"
}
["ffd_media_tags"]=>
array(1) {
[0]=>
string(1968) "a:10:{i:0;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-1.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:1;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-2.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:2;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-3.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:3;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-4.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:4;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-5.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:5;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-6.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:6;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-7.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:7;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-8.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:8;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-9.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:9;a:4:{s:3:"url";s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-10.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}}"
}
["ffd_featured_image"]=>
array(1) {
[0]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-1.jpg"
}
["_yoast_indexnow_last_ping"]=>
array(1) {
[0]=>
string(10) "1774658678"
}
["_et_dynamic_cached_shortcodes"]=>
array(1) {
[0]=>
string(227) "a:8:{i:0;s:13:"et_pb_section";i:1;s:9:"et_pb_row";i:2;s:12:"et_pb_column";i:3;s:13:"et_pb_divider";i:4;s:11:"et_pb_image";i:5;s:10:"et_pb_text";i:6;s:25:"et_pb_social_media_follow";i:7;s:33:"et_pb_social_media_follow_network";}"
}
["_et_dynamic_cached_attributes"]=>
array(1) {
[0]=>
string(1559) "a:33:{s:17:"use_custom_gutter";s:2:"on";s:12:"gutter_width";s:1:"1";s:14:"social_network";a:3:{i:0;s:8:"facebook";i:1;s:9:"instagram";i:2;s:7:"youtube";}s:10:"make_equal";s:2:"on";s:16:"module_alignment";s:6:"center";s:13:"custom_margin";s:10:"5px||15px|";s:20:"custom_margin_tablet";s:10:"5px||10px|";s:19:"custom_margin_phone";s:12:"5px||5px|0px";s:25:"custom_margin_last_edited";s:8:"on|phone";s:14:"custom_padding";s:17:"2%||||false|false";s:16:"border_width_all";s:4:"15px";s:16:"border_color_all";s:7:"#f5f5f5";s:31:"transform_styles__hover_enabled";s:8:"on|hover";s:22:"transform_scale__hover";s:9:"105%|105%";s:30:"transform_scale__hover_enabled";s:8:"on|hover";s:34:"transform_translate__hover_enabled";s:10:"on|desktop";s:31:"transform_rotate__hover_enabled";s:10:"on|desktop";s:29:"transform_skew__hover_enabled";s:10:"on|desktop";s:31:"transform_origin__hover_enabled";s:10:"on|desktop";s:12:"module_class";s:4:"text";s:9:"text_font";s:15:"Lato|300|||||||";s:14:"text_font_size";s:4:"18px";s:16:"text_line_height";s:5:"1.2em";s:26:"custom_padding_last_edited";s:8:"on|phone";s:21:"custom_padding_tablet";s:17:"6%||||false|false";s:20:"custom_padding_phone";s:17:"9%||||false|false";s:31:"background_enable_pattern_style";s:2:"on";s:24:"background_pattern_style";s:9:"honeycomb";s:23:"background_pattern_size";s:6:"custom";s:24:"background_pattern_width";s:4:"18px";s:32:"background_pattern_repeat_origin";s:6:"center";s:28:"background_pattern_transform";s:29:"flip_vertical|flip_horizontal";s:24:"background_pattern_color";s:15:"rgba(0,0,0,0.1)";}"
}
["_et_builder_module_features_cache"]=>
array(1) {
[0]=>
string(6381) "a:2:{i:0;s:55:"{"gph":2,"divi":"4.27.6","wp":"6.8.8","tb":[],"wpe":[]}";i:1;a:22:{s:46:"et_pb_section_c5fa583eeffc103cf80fe974734a250a";a:6:{s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:46:"et_pb_section_a8e7d18dd27d5923d2a95e1cfb4d7401";a:6:{s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:42:"et_pb_row_c8d2dd984634736a117f3653b6aa8ad3";a:5:{s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:45:"et_pb_column_66742f63fcabcf796b2c4d1dd16b9b90";a:5:{s:4:"cuma";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:46:"et_pb_divider_87728219aa16eaf8ab7c7ee646dee876";a:4:{s:4:"glde";a:4:{s:13:"divider_style";s:5:"solid";s:16:"divider_position";s:3:"top";s:14:"divider_weight";s:1:"1";s:6:"height";s:1:"1";}s:4:"mawi";b:1;s:4:"bosh";b:1;s:4:"anim";b:1;}s:44:"et_pb_image_68cf4f86aa4b27aba3cc291075927f5b";a:6:{s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:46:"et_pb_divider_34150a967651f231c96f2d5cc290c4ff";a:4:{s:4:"glde";a:4:{s:13:"divider_style";s:5:"solid";s:16:"divider_position";s:3:"top";s:14:"divider_weight";s:1:"1";s:6:"height";s:1:"1";}s:4:"mawi";b:1;s:4:"bosh";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_7e996766ba9c2f99cf2a0131209f29b3";a:7:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:4:"anim";b:1;}s:45:"et_pb_column_f9f5341f9a064ef86b185eb6b900e820";a:5:{s:4:"cuma";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_a43ca93c11e3364731be406956598c4c";a:10:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_f9a64516340f727be2b80bce599cf612";a:10:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_66bbf0a29c2cdb8d287044283d51911a";a:10:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_89dce25c75d11a28052851a1f0fd7923";a:10:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:45:"et_pb_column_006e45f86e67532d10ee206208591dbf";a:5:{s:4:"cuma";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_7b7f84cbdb97736e63d85d1806df3d33";a:10:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:66:"et_pb_social_media_follow_network_5bf468d6289e849c03baa3f5735ab71b";a:5:{s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:4:"anim";b:1;}s:66:"et_pb_social_media_follow_network_9843e24189022f9d6a3b30fc7c90c5c0";a:4:{s:4:"tesh";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:4:"anim";b:1;}s:66:"et_pb_social_media_follow_network_c07af1096cc9c6ceca3f62e76467c5fe";a:4:{s:4:"tesh";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:4:"anim";b:1;}s:58:"et_pb_social_media_follow_318d27e9e05d5dbfca33fbd5cda68ae6";a:6:{s:4:"tesh";b:1;s:3:"bor";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:4:"anim";b:1;}s:42:"et_pb_row_f9bdd222e264f3e0ff14c2cf67fb4303";a:5:{s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:45:"et_pb_column_b9262a059b4c683929ef4766e0abdc4c";a:5:{s:4:"cuma";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}s:43:"et_pb_text_d6b44022831afa3fcb38ca949181650b";a:9:{s:4:"glde";a:10:{s:14:"text_font_size";s:2:"14";s:19:"text_letter_spacing";s:3:"0px";s:16:"text_line_height";s:5:"1.7em";s:16:"header_font_size";s:4:"30px";s:21:"header_letter_spacing";s:3:"0px";s:18:"header_line_height";s:3:"1em";s:15:"background_size";s:5:"cover";s:19:"background_position";s:6:"center";s:17:"background_repeat";s:9:"no-repeat";s:16:"background_blend";s:6:"normal";}s:4:"foop";b:1;s:4:"tesh";b:1;s:4:"cuma";b:1;s:4:"mawi";b:1;s:4:"bosh";b:1;s:3:"pos";b:1;s:5:"mapac";b:1;s:4:"anim";b:1;}}}"
}
}
array(88) {
["ffd_listing_title"]=>
string(19) "Querencia Colinas 2"
["ffd_mls_id"]=>
string(7) "25-1484"
["ffd_salesforce_id"]=>
string(18) "a0ENv000009Dc2HMAS"
["ac_m2__c"]=>
string(6) "660.28"
["ac_sqft__c"]=>
string(7) "7104.61"
["Absolute_Longitude__c"]=>
string(10) "109.724437"
["amenities__c"]=>
string(94) "Bar,BBQ Area,Deck,Fire Pit,Hot Tub/Jacuzzi,Pool,Pool Heater,Sitting Area,Terrace,Water Feature"
["amenities_fireplaces__c"]=>
string(1) "1"
["appliances__c"]=>
string(143) "Clothes Washer,Cook Top,Dishwasher,Disposal,Freezer,Ice Maker,Microwave,Refrigerator,Warming Drawer,Wine Fridge,Dryer: Gas,Oven: Gas,Range: Gas"
["appliances_dryer__c"]=>
string(3) "Gas"
["appliances_oven__c"]=>
string(3) "Gas"
["appliances_range__c"]=>
string(3) "Gas"
["pba__area_pb__c"]=>
string(15) "SJD Corr-Inland"
["pba__fullbathrooms_pb__c"]=>
string(1) "7"
["pba__bedrooms_pb__c"]=>
string(1) "6"
["begin_date__c"]=>
string(10) "2025-03-12"
["broker_comm__c"]=>
string(2) "6%"
["year_build_text__c"]=>
string(4) "2025"
["CDH_Website_Link__c"]=>
string(141) "https://cabodreamhomes.com/property/Querencia-Colinas-2"
["pba__city_pb__c"]=>
string(17) "San Jose Corridor"
["colistingmemberemail__c"]=>
string(19) "rubenv@delmarre.com"
["CoListingMemberName__c"]=>
string(12) "Ruben Vargas"
["CoListingMemberPhone__c"]=>
string(14) "(624) 129-9572"
["CoListingOfficeName__c"]=>
string(19) "Del Mar Real Estate"
["common_amenities__c"]=>
string(121) "Beach Club,Gated,Golf,Guarded,Gym,Handball/Paddleball,Kiddy Park,Pool,Putting/Pitching,Restaurants/Bars,Spa,Tennis Court"
["community__c"]=>
string(16) "Querencia-Inland"
["connectivity_telephone__c"]=>
string(6) "1 line"
["const_construction_type__c"]=>
string(23) "Insulated Foam Concrete"
["pba__constructiontype__c"]=>
string(16) "Pre-Construction"
["construction_flooring_type__c"]=>
string(10) "Travertine"
["ffd_createdbyid"]=>
string(18) "00539000005g5DpAAI"
["createddate"]=>
string(28) "2025-03-15T17:15:44.000+0000"
["CurrencyIsoCode"]=>
string(3) "USD"
["days_on_market__c"]=>
string(3) "381"
["decks_patios_m2__c"]=>
string(5) "347.9"
["decks_patios_sqft__c"]=>
string(6) "3743.4"
["ffd_description_pb"]=>
string(781) "This stunning 6-bedroom, 7 1/2-bathroom custom-built villa, in the prestigious gated community of Querencia, offers unparalleled ocean views of San Jose Bay and the Sea of Cortez. Spanning 7,107 sq. ft. on a 41,000 sq. ft. lot, this modern home blends luxury and coastal elegance.Enter a private gated driveway and over a tranquil water courtyard to enjoy breathtaking ocean views. The open floor plan flows seamlessly to a spacious veranda and poolside terrace, perfect for indoor-outdoor living.A cozy rooftop lookout point, provides a serene escape to enjoy sunrises and starlit skies. Within walking distance to Querencia's Beach Club and a quick golf cart drive to the Clubhouse, this villa is ideally located. Currently in pre-construction, completion is expected by Q3 2025."
["devices__c"]=>
string(63) "Water Purification,Air Conditioning: Central,Water Heater: Tank"
["devices_air_conditioning__c"]=>
string(7) "Central"
["devices_water_heater__c"]=>
string(4) "Tank"
["electricity__c"]=>
string(3) "CFE"
["External_Listing__c"]=>
string(1) "1"
["financing__c"]=>
string(13) "Cash/Efectivo"
["furnished__c"]=>
string(11) "Unfurnished"
["garage_stalls__c"]=>
string(4) "3.00"
["hoa_info_dues_amount__c"]=>
string(4) "9000"
["hoa_info_hoa_name__c"]=>
string(3) "YES"
["pba__halfbathrooms_pb__c"]=>
string(1) "1"
["ffd_lastmodifieddate"]=>
string(28) "2026-03-28T00:15:46.000+0000"
["pba__latitude_pb__c"]=>
string(9) "23.023965"
["pba__listing_agent_email__c"]=>
string(20) "michael@delmarre.com"
["pba__listing_agent_firstname__c"]=>
string(7) "Michael"
["pba__listing_agent_lastname__c"]=>
string(13) "Wayne Baldwin"
["pba__listingtype__c"]=>
string(4) "Sale"
["listingofficename__c"]=>
string(19) "Del Mar Real Estate"
["pba__longitude_pb__c"]=>
string(11) "-109.724437"
["lot_m2__c"]=>
string(7) "3831.79"
["mls_id__c"]=>
string(7) "25-1484"
["pba__listingprice_pb__c"]=>
string(7) "8950000"
["price_mxn__c"]=>
string(12) "170801526.72"
["view__c"]=>
string(5) "Ocean"
["pba__propertytype__c"]=>
string(5) "House"
["ListingId"]=>
string(18) "a0ENv000009Dc2HMAS"
["road_type__c"]=>
string(5) "Paved"
["secondary_view__c"]=>
string(4) "City"
["seller_financing_offered__c"]=>
string(2) "No"
["sellingmemberemail__c"]=>
string(18) "craig@delmarre.com"
["sewage__c"]=>
string(4) "Muni"
["pba__status__c"]=>
string(7) "Pending"
["status_change_date__c"]=>
string(10) "2025-04-28"
["style__c"]=>
string(9) "One Story"
["subdivision__c"]=>
string(22) "Section 1- Las Colinas"
["title__c"]=>
string(25) "Querencia Colinas 2,Mifel"
["title_fideicomiso__c"]=>
string(5) "Mifel"
["total_m2__c"]=>
string(7) "1308.88"
["pba__totalarea_pb__c"]=>
string(8) "14083.55"
["water__c"]=>
string(4) "Muni"
["pba__yearbuilt_pb__c"]=>
string(4) "2025"
["zone__c"]=>
string(17) "San Jose Corridor"
["ffd_media"]=>
array(10) {
[0]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-1.jpg"
[1]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-2.jpg"
[2]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-3.jpg"
[3]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-4.jpg"
[4]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-5.jpg"
[5]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-6.jpg"
[6]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-7.jpg"
[7]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-8.jpg"
[8]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-9.jpg"
[9]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-10.jpg"
}
["ffd_media_tags"]=>
array(10) {
[0]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-1.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[1]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-2.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[2]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-3.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[3]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-4.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[4]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-5.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[5]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-6.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[6]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-7.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[7]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-8.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[8]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-9.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[9]=>
array(4) {
["url"]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-10.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
}
["ffd_featured_image"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20250313231326702565000000-1.jpg"
["_yoast_indexnow_last_ping"]=>
string(10) "1774658678"
["_et_dynamic_cached_shortcodes"]=>
array(8) {
[0]=>
string(13) "et_pb_section"
[1]=>
string(9) "et_pb_row"
[2]=>
string(12) "et_pb_column"
[3]=>
string(13) "et_pb_divider"
[4]=>
string(11) "et_pb_image"
[5]=>
string(10) "et_pb_text"
[6]=>
string(25) "et_pb_social_media_follow"
[7]=>
string(33) "et_pb_social_media_follow_network"
}
["_et_dynamic_cached_attributes"]=>
array(33) {
["use_custom_gutter"]=>
string(2) "on"
["gutter_width"]=>
string(1) "1"
["social_network"]=>
array(3) {
[0]=>
string(8) "facebook"
[1]=>
string(9) "instagram"
[2]=>
string(7) "youtube"
}
["make_equal"]=>
string(2) "on"
["module_alignment"]=>
string(6) "center"
["custom_margin"]=>
string(10) "5px||15px|"
["custom_margin_tablet"]=>
string(10) "5px||10px|"
["custom_margin_phone"]=>
string(12) "5px||5px|0px"
["custom_margin_last_edited"]=>
string(8) "on|phone"
["custom_padding"]=>
string(17) "2%||||false|false"
["border_width_all"]=>
string(4) "15px"
["border_color_all"]=>
string(7) "#f5f5f5"
["transform_styles__hover_enabled"]=>
string(8) "on|hover"
["transform_scale__hover"]=>
string(9) "105%|105%"
["transform_scale__hover_enabled"]=>
string(8) "on|hover"
["transform_translate__hover_enabled"]=>
string(10) "on|desktop"
["transform_rotate__hover_enabled"]=>
string(10) "on|desktop"
["transform_skew__hover_enabled"]=>
string(10) "on|desktop"
["transform_origin__hover_enabled"]=>
string(10) "on|desktop"
["module_class"]=>
string(4) "text"
["text_font"]=>
string(15) "Lato|300|||||||"
["text_font_size"]=>
string(4) "18px"
["text_line_height"]=>
string(5) "1.2em"
["custom_padding_last_edited"]=>
string(8) "on|phone"
["custom_padding_tablet"]=>
string(17) "6%||||false|false"
["custom_padding_phone"]=>
string(17) "9%||||false|false"
["background_enable_pattern_style"]=>
string(2) "on"
["background_pattern_style"]=>
string(9) "honeycomb"
["background_pattern_size"]=>
string(6) "custom"
["background_pattern_width"]=>
string(4) "18px"
["background_pattern_repeat_origin"]=>
string(6) "center"
["background_pattern_transform"]=>
string(29) "flip_vertical|flip_horizontal"
["background_pattern_color"]=>
string(15) "rgba(0,0,0,0.1)"
}
["_et_builder_module_features_cache"]=>
array(2) {
[0]=>
string(55) "{"gph":2,"divi":"4.27.6","wp":"6.8.8","tb":[],"wpe":[]}"
[1]=>
array(22) {
["et_pb_section_c5fa583eeffc103cf80fe974734a250a"]=>
array(6) {
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_section_a8e7d18dd27d5923d2a95e1cfb4d7401"]=>
array(6) {
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_row_c8d2dd984634736a117f3653b6aa8ad3"]=>
array(5) {
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_column_66742f63fcabcf796b2c4d1dd16b9b90"]=>
array(5) {
["cuma"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_divider_87728219aa16eaf8ab7c7ee646dee876"]=>
array(4) {
["glde"]=>
array(4) {
["divider_style"]=>
string(5) "solid"
["divider_position"]=>
string(3) "top"
["divider_weight"]=>
string(1) "1"
["height"]=>
string(1) "1"
}
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_image_68cf4f86aa4b27aba3cc291075927f5b"]=>
array(6) {
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_divider_34150a967651f231c96f2d5cc290c4ff"]=>
array(4) {
["glde"]=>
array(4) {
["divider_style"]=>
string(5) "solid"
["divider_position"]=>
string(3) "top"
["divider_weight"]=>
string(1) "1"
["height"]=>
string(1) "1"
}
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_7e996766ba9c2f99cf2a0131209f29b3"]=>
array(7) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_column_f9f5341f9a064ef86b185eb6b900e820"]=>
array(5) {
["cuma"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_a43ca93c11e3364731be406956598c4c"]=>
array(10) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_f9a64516340f727be2b80bce599cf612"]=>
array(10) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_66bbf0a29c2cdb8d287044283d51911a"]=>
array(10) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_89dce25c75d11a28052851a1f0fd7923"]=>
array(10) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_column_006e45f86e67532d10ee206208591dbf"]=>
array(5) {
["cuma"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_7b7f84cbdb97736e63d85d1806df3d33"]=>
array(10) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_social_media_follow_network_5bf468d6289e849c03baa3f5735ab71b"]=>
array(5) {
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_social_media_follow_network_9843e24189022f9d6a3b30fc7c90c5c0"]=>
array(4) {
["tesh"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_social_media_follow_network_c07af1096cc9c6ceca3f62e76467c5fe"]=>
array(4) {
["tesh"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_social_media_follow_318d27e9e05d5dbfca33fbd5cda68ae6"]=>
array(6) {
["tesh"]=>
bool(true)
["bor"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_row_f9bdd222e264f3e0ff14c2cf67fb4303"]=>
array(5) {
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_column_b9262a059b4c683929ef4766e0abdc4c"]=>
array(5) {
["cuma"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
["et_pb_text_d6b44022831afa3fcb38ca949181650b"]=>
array(9) {
["glde"]=>
array(10) {
["text_font_size"]=>
string(2) "14"
["text_letter_spacing"]=>
string(3) "0px"
["text_line_height"]=>
string(5) "1.7em"
["header_font_size"]=>
string(4) "30px"
["header_letter_spacing"]=>
string(3) "0px"
["header_line_height"]=>
string(3) "1em"
["background_size"]=>
string(5) "cover"
["background_position"]=>
string(6) "center"
["background_repeat"]=>
string(9) "no-repeat"
["background_blend"]=>
string(6) "normal"
}
["foop"]=>
bool(true)
["tesh"]=>
bool(true)
["cuma"]=>
bool(true)
["mawi"]=>
bool(true)
["bosh"]=>
bool(true)
["pos"]=>
bool(true)
["mapac"]=>
bool(true)
["anim"]=>
bool(true)
}
}
}
["unit_details__c"]=>
string(0) ""
["connectivity__c"]=>
string(17) "Telephone: 1 line"
}
Querencia Colinas 2
San Jose Corridor
$8,950,000 USD
$170,801,527 MXN
PENDING
- 6
- 7
- 1
- 14,084 SqFt
description
This stunning 6-bedroom, 7 1/2-bathroom custom-built villa, in the prestigious gated community of Querencia, offers unparalleled ocean views of San Jose Bay and the Sea of Cortez. Spanning 7,107 sq. ft. on a 41,000 sq. ft. lot, this modern home blends luxury and coastal elegance.Enter a private gated driveway and over a tranquil water courtyard to enjoy breathtaking ocean views. The open floor plan flows seamlessly to a spacious veranda and poolside terrace, perfect for indoor-outdoor living.A cozy rooftop lookout point, provides a serene escape to enjoy sunrises and starlit skies. Within walking distance to Querencia’s Beach Club and a quick golf cart drive to the Clubhouse, this villa is ideally located. Currently in pre-construction, completion is expected by Q3 2025.
key details
Price $8,950,000 USD - $170,801,527 MXN
Seller Financing No
Total Bedrooms 6
Full Baths 7
Half Baths 1
City San Jose Corridor
Area SJD Corr-Inland
Community Querencia-Inland
Subdivision Section 1- Las Colinas
Status Pending
Primary View Ocean
Secondary View City
Total SqFt 14,084
AC SqFt 7,105
Decks & Patio SqFt 3,743
Year Built 2025
Funiture Unfurnished
Type House
Style One Story
Construction Pre-Construction
Bar
BBQ Area
Deck
Fire Pit
Hot Tub/Jacuzzi
Pool
Pool Heater
Sitting Area
Terrace
Water Feature
Road Type Paved
Construction Type Insulated Foam Concrete
Flooring Types Travertine
appliances
Clothes Washer
Cook Top
Dishwasher
Disposal
Freezer
Ice Maker
Microwave
Refrigerator
Warming Drawer
Wine Fridge
Dryer: Gas
Oven: Gas
Range: Gas
devices
Water Purification
Air Conditioning: Central
Water Heater: Tank
connectivity
Telephone: 1 line
water
Muni
electricity
CFE
sewage
Muni
common amenities
Beach Club
Gated
Golf
Guarded
Gym
Handball/Paddleball
Kiddy Park
Pool
Putting/Pitching
Restaurants/Bars
Spa
Tennis Court
HOA Dues Amount 9000
Title Querencia Colinas 2,Mifel
Latitude 23.023965
Longitude -109.724437
SCHEDULE SHOWING
Open House
Add to Calendar
America/Mazatlan
Open House
Cabo Dream Homes
Querencia Colinas 2San Jose Corridor
Cabo Dream Homes
info@cabodreamhomes.com
false
n/a
n/a
- n/a
Blvd. Mar de Cortez esq. Pez Gallo, La Playita, 23403, San José del Cabo, B.C.S. México
(624) 142.6333
1.800.403.6597
agent@cabodreamhomes.com
ABOUT US
Our Team
Career
NOM 247
For the full compliance version, visit page
privacy.cabodreamhomes.com/nom247
All listing information is from sources deemed reliable. However, no representation is made as to the accuracy or completeness thereof and should be independently verified.
*The offered price is in DOLLARS (US Currency), and in accordance with article 8 of the monetary law, the final price for recordation purposes will be converted into PESOS resulting from the official exchange rate on the date payment is due. In accordance with NOM 247, prices shown in DOLLARS can be converted into PESOS by accessing the following link and performing the corresponding arithmetic multiplication per the current exchange rate. https://www.banxico.org.mx/tipcamb/main.do?page=tip&idioma=en
*El precio de oferta es en DÓLARES (moneda de los EUA) y de conformidad con el artículo 8 de la ley monetaria en vigor, el precio oficial a registrar en la escritura será el de PESOS que resulte del tipo de cambio oficial en la fecha que el pago sea obligatorio. De conformidad con la NOM 247, los precios en DÓLARES se pueden consultar en PESOS mediante la multiplicación aritmética del precio mostrado en DÓLARES por el tipo de cambio en vigor para solventar operaciones en dólares moneda de Los EUA. https://www.banxico.org.mx/tipcamb/main.do?page=tip&idioma=sp