array(190) {
["ffd_listing_title"]=>
array(1) {
[0]=>
string(34) "Casa Miguel Ret Mistral lote 7 M19"
}
["ffd_unique_id"]=>
array(1) {
[0]=>
NULL
}
["ffd_mls_id"]=>
array(1) {
[0]=>
string(7) "22-1491"
}
["ffd_salesforce_id"]=>
array(1) {
[0]=>
string(18) "a0E3n00000TNmLHEA1"
}
["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(3) "180"
}
["ac_sqft__c"]=>
array(1) {
[0]=>
string(6) "1936.8"
}
["Absolute_Longitude__c"]=>
array(1) {
[0]=>
string(10) "109.710386"
}
["pba__Acres_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__address_pb__c"]=>
array(1) {
[0]=>
string(22) "Ret Mistral lote 7 M19"
}
["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(34) "Fence / Wall,Garden,Second Kitchen"
}
["amenities_fireplaces__c"]=>
array(1) {
[0]=>
string(0) ""
}
["appliances__c"]=>
array(1) {
[0]=>
string(27) "Clothes Washer,Refrigerator"
}
["appliances_dryer__c"]=>
array(1) {
[0]=>
string(0) ""
}
["appliances_oven__c"]=>
array(1) {
[0]=>
string(0) ""
}
["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(9) "SJD-North"
}
["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) "2"
}
["pba__Beachfront__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__bedrooms_pb__c"]=>
array(1) {
[0]=>
string(1) "3"
}
["begin_date__c"]=>
array(1) {
[0]=>
string(10) "2022-04-10"
}
["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) "1997"
}
["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(171) "https://cabodreamhomes.com/property/Casa-Miguel-Ret-Mistral-lote-7-M19"
}
["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 del Cabo"
}
["pba__ColistingAgent_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["colistingmemberemail__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoListingMemberName__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoListingMemberPhone__c"]=>
array(1) {
[0]=>
string(0) ""
}
["CoListingOfficeName__c"]=>
array(1) {
[0]=>
string(0) ""
}
["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(0) ""
}
["community__c"]=>
array(1) {
[0]=>
string(16) "SJD North-W of 1"
}
["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(0) ""
}
["const_construction_type__c"]=>
array(1) {
[0]=>
string(23) "Concrete / Cinder Block"
}
["pba__constructiontype__c"]=>
array(1) {
[0]=>
string(9) "Completed"
}
["construction_flooring_type__c"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "2022-04-10T20:15:40.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) "758"
}
["pba__DaysOnMarket_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["dom__c"]=>
array(1) {
[0]=>
string(0) ""
}
["decks_patios_m2__c"]=>
array(1) {
[0]=>
string(2) "35"
}
["decks_patios_sqft__c"]=>
array(1) {
[0]=>
string(5) "376.6"
}
["ffd_description_pb"]=>
array(1) {
[0]=>
string(608) "San Jose del CaboExcellent buying opportunity. House located in Colonia El Rosarito, in a return. Very quiet area close to local shops, 5 minutes from downtown, La Comer, quick access to transpeninsular.Land: 400m290m2 main house with: 2 spacious bedrooms with closets and A/C, 1 bathroom, kitchen with new cabinets (3 years), living room, dining room, large terrace (35m2), large garden with fruit trees (space to build a pool) , laundry/Washing area90m2 apartment, totally independent (ideal for long-term or vacation rentals) with:Kitchen, dining room, living room, bathroom, 1 bedroom with closet and a/c"
}
["ffd_description_seo_richtext"]=>
array(1) {
[0]=>
string(0) ""
}
["devices__c"]=>
array(1) {
[0]=>
string(12) "Ceiling Fans"
}
["devices_air_conditioning__c"]=>
array(1) {
[0]=>
string(11) "Mini Splits"
}
["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(128) "HWY 1 toward the Centro de Convenciones, turn left onto P Barlovento then turn right on Mistral, house on left side, corner lot."
}
["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(0) ""
}
["hoa_info_dues_amount__c"]=>
array(1) {
[0]=>
string(0) ""
}
["hoa_info_dues_period__c"]=>
array(1) {
[0]=>
string(0) ""
}
["hoa_info_hoa_name__c"]=>
array(1) {
[0]=>
string(0) ""
}
["hoa_info_phone_contact__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__halfbathrooms_pb__c"]=>
array(1) {
[0]=>
string(1) "0"
}
["pba__HeatingType_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["Helper_Price_Change__c"]=>
array(1) {
[0]=>
string(6) "250000"
}
["ffd_lastmodifieddate"]=>
array(1) {
[0]=>
string(28) "2025-08-06T01:15:12.000+0000"
}
["pba__latitude_pb__c"]=>
array(1) {
[0]=>
string(9) "23.068221"
}
["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(22) "caboesther@hotmail.com"
}
["pba__listing_agent_firstname__c"]=>
array(1) {
[0]=>
string(6) "Esther"
}
["pba__listing_agent_lastname__c"]=>
array(1) {
[0]=>
string(8) "Espinoza"
}
["ffd_listingagentmlsid"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__listingtype__c"]=>
array(1) {
[0]=>
string(4) "Sale"
}
["listingofficename__c"]=>
array(1) {
[0]=>
string(23) "Cabo Blanco Real Estate"
}
["ffd_virtual_tour_live"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__longitude_pb__c"]=>
array(1) {
[0]=>
string(11) "-109.710386"
}
["lot_m2__c"]=>
array(1) {
[0]=>
string(3) "400"
}
["pba__lotsize_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["mls_id__c"]=>
array(1) {
[0]=>
string(7) "22-1491"
}
["pba__listingprice_pb__c"]=>
array(1) {
[0]=>
string(6) "305000"
}
["price_mxn__c"]=>
array(1) {
[0]=>
string(10) "5820610.69"
}
["view__c"]=>
array(1) {
[0]=>
string(9) "Territory"
}
["pba__propertytype__c"]=>
array(1) {
[0]=>
string(5) "House"
}
["ListingId"]=>
array(1) {
[0]=>
string(18) "a0E3n00000TNmLHEA1"
}
["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(9) "Territory"
}
["seller_financing_offered__c"]=>
array(1) {
[0]=>
string(2) "No"
}
["sellingmemberemail__c"]=>
array(1) {
[0]=>
string(31) "gabriela@mijangosrealestate.com"
}
["sewage__c"]=>
array(1) {
[0]=>
string(4) "Muni"
}
["ffd_solddate"]=>
array(1) {
[0]=>
string(0) ""
}
["sale_price__c"]=>
array(1) {
[0]=>
string(9) "259893.68"
}
["ffd_soldprice"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__state_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["pba__status__c"]=>
array(1) {
[0]=>
string(6) "Closed"
}
["status_change_date__c"]=>
array(1) {
[0]=>
string(10) "2024-05-07"
}
["pba__street_pb__c"]=>
array(1) {
[0]=>
string(22) "Ret Mistral lote 7 M19"
}
["style__c"]=>
array(1) {
[0]=>
string(9) "Two Story"
}
["subcommunity__c"]=>
array(1) {
[0]=>
string(0) ""
}
["subdivision__c"]=>
array(1) {
[0]=>
string(11) "El Rosarito"
}
["taxes__c"]=>
array(1) {
[0]=>
string(0) ""
}
["title__c"]=>
array(1) {
[0]=>
string(34) "Casa Miguel Ret Mistral lote 7 M19"
}
["title_fideicomiso__c"]=>
array(1) {
[0]=>
string(0) ""
}
["topography__c"]=>
array(1) {
[0]=>
string(0) ""
}
["total_m2__c"]=>
array(1) {
[0]=>
string(3) "215"
}
["pba__totalarea_pb__c"]=>
array(1) {
[0]=>
string(6) "2313.4"
}
["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(11) "Common Well"
}
["water_dist_to_muni_water__c"]=>
array(1) {
[0]=>
string(0) ""
}
["water_water_tank_liters__c"]=>
array(1) {
[0]=>
string(4) "1300"
}
["pba__yearbuilt_pb__c"]=>
array(1) {
[0]=>
string(4) "1997"
}
["pba__postalcode_pb__c"]=>
array(1) {
[0]=>
string(0) ""
}
["zone__c"]=>
array(1) {
[0]=>
string(17) "San Jose del Cabo"
}
["ffd_media"]=>
array(1) {
[0]=>
string(1486) "a:14:{i:0;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-1.jpg";i:1;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-2.jpg";i:2;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-3.jpg";i:3;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-4.jpg";i:4;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-5.jpg";i:5;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-6.jpg";i:6;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-7.jpg";i:7;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-8.jpg";i:8;s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-9.jpg";i:9;s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-10.jpg";i:10;s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-11.jpg";i:11;s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-12.jpg";i:12;s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-13.jpg";i:13;s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-14.jpg";}"
}
["ffd_media_tags"]=>
array(1) {
[0]=>
string(2760) "a:14:{i:0;a:4:{s:3:"url";s:93:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-10.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:10;a:4:{s:3:"url";s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-11.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:11;a:4:{s:3:"url";s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-12.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:12;a:4:{s:3:"url";s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-13.jpg";s:4:"type";s:10:"image/jpeg";s:4:"tags";s:0:"";s:8:"category";s:6:"Images";}i:13;a:4:{s:3:"url";s:94:"https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-14.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/20220409005453270170000000-1.jpg"
}
["_et_dynamic_cached_shortcodes"]=>
array(1) {
[0]=>
string(6) "a:0:{}"
}
}
array(76) {
["ffd_listing_title"]=>
string(34) "Casa Miguel Ret Mistral lote 7 M19"
["ffd_mls_id"]=>
string(7) "22-1491"
["ffd_salesforce_id"]=>
string(18) "a0E3n00000TNmLHEA1"
["ac_m2__c"]=>
string(3) "180"
["ac_sqft__c"]=>
string(6) "1936.8"
["Absolute_Longitude__c"]=>
string(10) "109.710386"
["pba__address_pb__c"]=>
string(22) "Ret Mistral lote 7 M19"
["amenities__c"]=>
string(34) "Fence / Wall,Garden,Second Kitchen"
["appliances__c"]=>
string(38) "Clothes Washer,Refrigerator,Range: Gas"
["appliances_range__c"]=>
string(3) "Gas"
["pba__area_pb__c"]=>
string(9) "SJD-North"
["pba__fullbathrooms_pb__c"]=>
string(1) "2"
["pba__bedrooms_pb__c"]=>
string(1) "3"
["begin_date__c"]=>
string(10) "2022-04-10"
["broker_comm__c"]=>
string(2) "6%"
["year_build_text__c"]=>
string(4) "1997"
["CDH_Website_Link__c"]=>
string(171) "https://cabodreamhomes.com/property/Casa-Miguel-Ret-Mistral-lote-7-M19"
["pba__city_pb__c"]=>
string(17) "San Jose del Cabo"
["community__c"]=>
string(16) "SJD North-W of 1"
["const_construction_type__c"]=>
string(23) "Concrete / Cinder Block"
["pba__constructiontype__c"]=>
string(9) "Completed"
["ffd_createdbyid"]=>
string(18) "00539000005g5DpAAI"
["createddate"]=>
string(28) "2022-04-10T20:15:40.000+0000"
["CurrencyIsoCode"]=>
string(3) "USD"
["days_on_market__c"]=>
string(3) "758"
["decks_patios_m2__c"]=>
string(2) "35"
["decks_patios_sqft__c"]=>
string(5) "376.6"
["ffd_description_pb"]=>
string(608) "San Jose del CaboExcellent buying opportunity. House located in Colonia El Rosarito, in a return. Very quiet area close to local shops, 5 minutes from downtown, La Comer, quick access to transpeninsular.Land: 400m290m2 main house with: 2 spacious bedrooms with closets and A/C, 1 bathroom, kitchen with new cabinets (3 years), living room, dining room, large terrace (35m2), large garden with fruit trees (space to build a pool) , laundry/Washing area90m2 apartment, totally independent (ideal for long-term or vacation rentals) with:Kitchen, dining room, living room, bathroom, 1 bedroom with closet and a/c"
["devices__c"]=>
string(61) "Ceiling Fans,Air Conditioning: Mini Splits,Water Heater: Tank"
["devices_air_conditioning__c"]=>
string(11) "Mini Splits"
["devices_water_heater__c"]=>
string(4) "Tank"
["directions__c"]=>
string(128) "HWY 1 toward the Centro de Convenciones, turn left onto P Barlovento then turn right on Mistral, house on left side, corner lot."
["electricity__c"]=>
string(3) "CFE"
["External_Listing__c"]=>
string(1) "1"
["financing__c"]=>
string(13) "Cash/Efectivo"
["furnished__c"]=>
string(11) "Unfurnished"
["Helper_Price_Change__c"]=>
string(6) "250000"
["ffd_lastmodifieddate"]=>
string(28) "2025-08-06T01:15:12.000+0000"
["pba__latitude_pb__c"]=>
string(9) "23.068221"
["pba__listing_agent_email__c"]=>
string(22) "caboesther@hotmail.com"
["pba__listing_agent_firstname__c"]=>
string(6) "Esther"
["pba__listing_agent_lastname__c"]=>
string(8) "Espinoza"
["pba__listingtype__c"]=>
string(4) "Sale"
["listingofficename__c"]=>
string(23) "Cabo Blanco Real Estate"
["pba__longitude_pb__c"]=>
string(11) "-109.710386"
["lot_m2__c"]=>
string(3) "400"
["mls_id__c"]=>
string(7) "22-1491"
["pba__listingprice_pb__c"]=>
string(6) "305000"
["price_mxn__c"]=>
string(10) "5820610.69"
["view__c"]=>
string(9) "Territory"
["pba__propertytype__c"]=>
string(5) "House"
["ListingId"]=>
string(18) "a0E3n00000TNmLHEA1"
["road_type__c"]=>
string(5) "Paved"
["secondary_view__c"]=>
string(9) "Territory"
["seller_financing_offered__c"]=>
string(2) "No"
["sellingmemberemail__c"]=>
string(31) "gabriela@mijangosrealestate.com"
["sewage__c"]=>
string(4) "Muni"
["sale_price__c"]=>
string(9) "259893.68"
["pba__status__c"]=>
string(6) "Closed"
["status_change_date__c"]=>
string(10) "2024-05-07"
["pba__street_pb__c"]=>
string(22) "Ret Mistral lote 7 M19"
["style__c"]=>
string(9) "Two Story"
["subdivision__c"]=>
string(11) "El Rosarito"
["title__c"]=>
string(34) "Casa Miguel Ret Mistral lote 7 M19"
["total_m2__c"]=>
string(3) "215"
["pba__totalarea_pb__c"]=>
string(6) "2313.4"
["water__c"]=>
string(11) "Common Well"
["water_water_tank_liters__c"]=>
string(4) "1300"
["pba__yearbuilt_pb__c"]=>
string(4) "1997"
["zone__c"]=>
string(17) "San Jose del Cabo"
["ffd_media"]=>
array(14) {
[0]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-1.jpg"
[1]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-2.jpg"
[2]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-3.jpg"
[3]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-4.jpg"
[4]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-5.jpg"
[5]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-6.jpg"
[6]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-7.jpg"
[7]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-8.jpg"
[8]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-9.jpg"
[9]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-10.jpg"
[10]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-11.jpg"
[11]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-12.jpg"
[12]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-13.jpg"
[13]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-14.jpg"
}
["ffd_media_tags"]=>
array(14) {
[0]=>
array(4) {
["url"]=>
string(93) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-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/20220409005453270170000000-10.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[10]=>
array(4) {
["url"]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-11.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[11]=>
array(4) {
["url"]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-12.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[12]=>
array(4) {
["url"]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-13.jpg"
["type"]=>
string(10) "image/jpeg"
["tags"]=>
string(0) ""
["category"]=>
string(6) "Images"
}
[13]=>
array(4) {
["url"]=>
string(94) "https://s3-us-west-2.amazonaws.com/propbmedia/DreamHomesCabo/20220409005453270170000000-14.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/20220409005453270170000000-1.jpg"
["_et_dynamic_cached_shortcodes"]=>
array(0) {
}
["unit_details__c"]=>
string(0) ""
["connectivity__c"]=>
string(0) ""
}
San Jose del CaboExcellent buying opportunity. House located in Colonia El Rosarito, in a return. Very quiet area close to local shops, 5 minutes from downtown, La Comer, quick access to transpeninsular.Land: 400m290m2 main house with: 2 spacious bedrooms with closets and A/C, 1 bathroom, kitchen with new cabinets (3 years), living room, dining room, large terrace (35m2), large garden with fruit trees (space to build a pool) , laundry/Washing area90m2 apartment, totally independent (ideal for long-term or vacation rentals) with:Kitchen, dining room, living room, bathroom, 1 bedroom with closet and a/c
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
Our Team
Career
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