Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 9d86b18555f1e62c3eff9c871f87c9973a615414f5cfaa21ad397d8a1772d122" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4914 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117386560" +"ListingId": "MC25133656" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:06:26Z" +"RFModificationTimestamp": "2025-06-14T23:06:19.694040+00:00" +"ListPrice": 445000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 2380.0 +"LivingArea": 1737.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "345 Sullivan Drive, Merced, California 95348" +"Coordinates": array:2 [ 0 => -120.472816 1 => 37.345301 ] +"Latitude": 37.345301 +"Longitude": -120.472816 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Filiberto Villanueva" +"ListOfficeName": "Realty Executives Of Northern California" +"ListAgentMlsId": "MCVILLFI" +"ListOfficeMlsId": "mc188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Imagine life in this beautifully updated 4-bedroom, 2.5-bath home, designed for both comfort and elegance. Every detail has been carefully considered. Step inside and be greeted by a seamless flow of upgraded light fixtures that illuminate every corner, creating a contemporary ambiance throughout. The heart of this home is its open-concept kitchen, a chef's dream with gleaming granite countertops and top-of-the-line stainless steel appliances and a dedicated coffee bar perfect for your morning routine. Unwind in the spacious living room, anchored by a sleek, built-in modern fireplace. or effortlessly transition to your private outdoor space – a newly laid stamped concrete patio, perfect for enjoying your favorite beverage. The impressive two-car garage, featuring sleek epoxy floors, adds to the home's exceptional appeal. With its thoughtful upgrades and move-in ready status, 345 Sullivan Dr offers an incredible opportunity to start living your best life. Don't miss out – schedule your visit today”" +"Appliances": "Dishwasher,Gas Cooktop,Gas Oven,Microwave" +"ArchitecturalStyle": "Contemporary" +"AttachedGarageYN": true +"AttributionContact": "209-261-5181" +"BathroomsFull": 2 +"CLIP": 8632284390 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs" +"ConstructionMaterials": "Stucco" +"Contingency": "Contingent sale" +"ContractStatusChangeDate": "2025-06-14" +"Cooling": "Central Air,ENERGY STAR Qualified Equipment" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-14T19:42:47.980109+00:00" +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "N. on G St, left on Cardella Rd, left on Bancroft Dr, Right on Shafer Ave, left on Korbel Ave to Sullivan Dr" +"Electric": "220 Volts" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "South" +"Fencing": "Wood" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Eat-in Kitchen,Granite Counters,High Ceilings,Open Floorplan,Pantry,All Bedrooms Up,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Closet" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-8500" +"ListAgentEmail": "felixvillanueva@realtyexecutives.com" +"ListAgentFax": "209-385-8505" +"ListAgentFirstName": "Filiberto" +"ListAgentKey": "17048559" +"ListAgentKeyNumeric": "17048559" +"ListAgentLastName": "Villanueva" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "01418106" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "mercedexecutives@gmail.com" +"ListOfficeFax": "209-385-8505" +"ListOfficeKey": "3278012" +"ListOfficeKeyNumeric": "3278012" +"ListOfficePhone": "209-385-8500" +"ListOfficeURL": "http://www.realtyexecutives.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-14" +"ListingKeyNumeric": 1117386560 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Sprinklers In Front,Irregular Lot,Landscaped" +"LotSizeAcres": 0.0546 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 2380.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-06-14T08:27:55Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-14" +"OnMarketTimestamp": "2025-06-14T08:27:55Z" +"OriginalEntryTimestamp": "2025-06-14T08:27:55Z" +"OriginalListPrice": 445000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374586535" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "230120018000" +"ParkingTotal": "1.0" +"PatioAndPorchFeatures": "None" +"PhotosChangeTimestamp": "2025-06-14T22:06:43Z" +"PhotosCount": 1 +"PoolFeatures": "None" +"PostalCodePlus4": "8550" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Other" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117386560" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-14T08:27:55Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Sullivan" +"StreetNumber": "345" +"StreetNumberNumeric": "345" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "62" +"UniversalPropertyId": "US-06047-N-230120018000-R-N" +"Utilities": "Sewer Connected" +"View": "City Lights" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,ENERGY STAR Qualified Windows" +"YearBuiltSource": "Assessor" +"Zoning": "P-D" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Family Room,Kitchen,Laundry,Walk-In Closet",\n "EatingArea": "Breakfast Counter / Bar,In Kitchen",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub,Double sinks in bath(s),Exhaust fan(s),Granite Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1117386560"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117386560')" +"CurrentPrice": 445000.0 +"provider_name": "CRMLS" +"RecordSignature": 738142465 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:230120018000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "108753" +"OriginatingSystemListAgentMemberKey": "435403" +"Media": array:1 [ 0 => array:57 [ …57] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1108983817" +"ListingId": "MC25061058" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:06:26Z" +"RFModificationTimestamp": "2025-06-14T23:06:43.803740+00:00" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 5158.0 +"LivingArea": 1435.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "1450 La Sierra Street, Merced, California 95348" +"Coordinates": array:2 [ 0 => -120.500373 1 => 37.335734 ] +"Latitude": 37.335734 +"Longitude": -120.500373 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Stephanie Jaurique" +"ListOfficeName": "BHGRE Everything Real Estate" +"ListAgentMlsId": "mcjaurst" +"ListOfficeMlsId": "mc294" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Turnkey home is ready for you! The adorable home is in North Merced is in a quiet neighborhood. Close to UC Merced, Merced College, Cattrax Bus Line, shopping, restaurants and more! The 3BR x 2 Bath home is in wonderful condition, been freshly painted on the interior with new carpeting as well. This home has a beautiful kitchen with a granite Island that opens up to the great room and view of the beautifully landscaped backyard and patio area.\r\r\n This home would be great for an investment property or a home to love and enjoy. Call to schedule your showing today!\r\r\n Escrow is pre-opened with Trans County Title Merced """ +"Appliances": "Dishwasher,Gas Range,Microwave,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AttachedGarageYN": true +"AttributionContact": "209-769-8399" +"BathroomsFull": 2 +"CLIP": 4549356641 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Gutter(s),Park,Street Lights" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-03-20" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-04-15T16:38:10.523079+00:00" +"CumulativeDaysOnMarket": 86 +"DaysOnMarket": 86 +"DaysOnMarketReplication": 86 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Hwy 59, R on Yosemite Ave., Left on St. Augustine, Left on La Sierra" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front Door" +"Fencing": "Average Condition" +"FireplaceFeatures": "None" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Eat-in Kitchen,Granite Counters,All Bedrooms Down,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-722-5400" +"ListAgentEmail": "stephaniemercedyosemiterealty@gmail.com" +"ListAgentFax": "209-722-5406" +"ListAgentFirstName": "Stephanie" +"ListAgentKey": "17273825" +"ListAgentKeyNumeric": "17273825" +"ListAgentLastName": "Jaurique" +"ListAgentOfficePhone": "209-383-7653" +"ListAgentStateLicense": "01929251" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "info@everythingbhgre.com" +"ListOfficeFax": "209-722-5406" +"ListOfficeKey": "3278043" +"ListOfficeKeyNumeric": "3278043" +"ListOfficePhone": "209-383-7653" +"ListOfficeURL": "http://www.everythingbhgre.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-20" +"ListingKeyNumeric": 1108983817 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Sprinklers In Front" +"LotSizeAcres": 0.1184 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5158.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-05-23T15:42:24Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Merced City" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-03-20" +"OnMarketTimestamp": "2025-03-20T09:03:09Z" +"OriginalEntryTimestamp": "2025-03-20T09:03:09Z" +"OriginalListPrice": 424900.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374108506" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "206165006000" +"ParkingFeatures": "Garage Faces Front" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete" +"PhotosChangeTimestamp": "2025-03-20T16:32:40Z" +"PhotosCount": 30 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "9100" +"PreviousListPrice": 408900.0 +"PriceChangeTimestamp": "2025-05-23T15:42:24Z" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Entry/Foyer,Great Room,Other" +"Sewer": "Public Sewer" +"ShowingContactName": "Stephanie Jaurique" +"ShowingContactPhone": "209-769-8399" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108983817" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-20T09:03:09Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "La Sierra" +"StreetNumber": "1450" +"StreetNumberNumeric": "1450" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "238" +"UniversalPropertyId": "US-06047-N-206165006000-R-N" +"Utilities": "Electricity Connected,Natural Gas Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "P-D" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Entry,Great Room,Walk-In Closet",\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Kitchen Island,Kitchen Open to Family Room,Stone Counters",\n "RoomBathroomFeatures": "Shower in Tub,Separate tub and shower,Soaking Tub",\n "AdminUpdateYN": "0",\n "ListingKey": "1108983817",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108983817')" +"CurrentPrice": 399000.0 +"provider_name": "CRMLS" +"RecordSignature": 510662873 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:206165006000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "108991" +"OriginatingSystemListAgentMemberKey": "554876" +"Media": array:30 [ 0 => array:58 [ …58] 1 => array:58 [ …58] 2 => array:58 [ …58] 3 => array:58 [ …58] 4 => array:58 [ …58] 5 => array:58 [ …58] 6 => array:58 [ …58] 7 => array:58 [ …58] 8 => array:58 [ …58] 9 => array:58 [ …58] 10 => array:58 [ …58] 11 => array:58 [ …58] 12 => array:58 [ …58] 13 => array:58 [ …58] 14 => array:58 [ …58] 15 => array:58 [ …58] 16 => array:58 [ …58] 17 => array:58 [ …58] 18 => array:58 [ …58] 19 => array:58 [ …58] 20 => array:58 [ …58] 21 => array:58 [ …58] 22 => array:58 [ …58] 23 => array:58 [ …58] 24 => array:58 [ …58] 25 => array:58 [ …58] 26 => array:58 [ …58] 27 => array:58 [ …58] 28 => array:58 [ …58] 29 => array:58 [ …58] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114957366" +"ListingId": "MC25125862" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:48:54Z" +"RFModificationTimestamp": "2025-06-14T23:10:55.035150+00:00" +"ListPrice": 379000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 4838.0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "921 W 19th Street, Merced, California 95340" +"Coordinates": array:2 [ 0 => -120.488622 1 => 37.306127 ] +"Latitude": 37.306127 +"Longitude": -120.488622 +"YearBuilt": 1923 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "William Lovos" +"ListOfficeName": "London Properties Ltd, Atwater" +"ListAgentMlsId": "MCLOVOWI" +"ListOfficeMlsId": "MC1060" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Fully Renovated Home in the Heart of Merced. Welcome to this beautifully updated 3-bed 2 bath gem in the heart of Merced! With 1,000 sqft of thoughtfully designed living space, this home blends modern upgrades with classic charm. Fresh interior and exterior paint job, brand new flooring, and a modern electric fireplace that adds warmth and style to the living area. Fully remodeled kitchen features new cabinets, sleek countertops, and a new electric oven range. Completely renovated bathrooms, new plumbing, a new AC unit, and a new roof ensure peace of mind and long-term comfort. Enjoy added privacy with new fencing, and take advantage of the detached 2-car garage that offers plenty of storage space or can be potentially converted into an ADU. Conveniently located within walking distance to downtown Merced, close to elementary and high schools, and just minutes from Highway 99, this home is ideal for commuters, families, or anyone seeking comfort and convenience in a vibrant neighborhood. Don’t miss this move-in-ready opportunity!" +"Appliances": "Electric Range,Water Heater" +"AttributionContact": "209-358-0222" +"BathroomsFull": 2 +"CLIP": 1048061334 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Park, Suburban, Sidewalks" +"ContractStatusChangeDate": "2025-06-04" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-05T18:02:28.271859+00:00" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 9 +"DaysOnMarketReplication": 9 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Go on HWY 99. Exit on R St go east. turn right on 19th st" +"DocumentsChangeTimestamp": "2025-06-12T05:44:11Z" +"DocumentsCount": 1 +"Electric": "Standard" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front Door" +"Fencing": "Wood" +"FireplaceFeatures": "Electric" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Ceiling Fan(s),Open Floorplan,Quartz Counters,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Outside" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-358-0222" +"ListAgentEmail": "williamelovos@gmail.com" +"ListAgentFirstName": "William" +"ListAgentKey": "22519991" +"ListAgentKeyNumeric": "22519991" +"ListAgentLastName": "Lovos" +"ListAgentOfficePhone": "209-358-0222" +"ListAgentStateLicense": "02112505" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "greg@londonproperties.com" +"ListOfficeFax": "209-812-4390" +"ListOfficeKey": "3279110" +"ListOfficeKeyNumeric": "3279110" +"ListOfficePhone": "209-358-0222" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-04" +"ListingKeyNumeric": 1114957366 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, Submit" +"LivingAreaSource": "Estimated" +"LotFeatures": "0-1 Unit/Acre,Sprinklers In Front,Rectangular Lot" +"LotSizeAcres": 0.1111 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 4838.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-05T10:16:27Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-05" +"OnMarketTimestamp": "2025-06-05T10:16:27Z" +"OriginalEntryTimestamp": "2025-06-05T10:16:27Z" +"OriginalListPrice": 379000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374533403" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "031041013000" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "None" +"PhotosChangeTimestamp": "2025-06-12T12:52:45Z" +"PhotosCount": 16 +"PoolFeatures": "None" +"PostalCodePlus4": "4506" +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom,Kitchen,Living Room,Primary Bathroom,Primary Bedroom" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114957366" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-05T10:16:27Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "19th" +"StreetNumber": "921" +"StreetNumberNumeric": "921" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxBlock": "128" +"TaxLot": "14" +"UniversalPropertyId": "US-06047-N-031041013000-R-N" +"View": "None" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Public Records" +"Zoning": "R-2" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Kitchen,Living Room,Primary Bathroom,Primary Bedroom",\n "EatingArea": "In Living Room",\n "RoomKitchenFeatures": "Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Bathtub,Remodeled",\n "AdminUpdateYN": "0",\n "ListingKey": "1114957366",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114957366')" +"CurrentPrice": 379000.0 +"provider_name": "CRMLS" +"RecordSignature": 1990452953 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:031041013000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "11057845" +"OriginatingSystemListAgentMemberKey": "371866271" +"Media": array:16 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115000319" +"ListingId": "MC25126609" +"PropertyType": "Residential" +"PropertySubType": "Duplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:48:54Z" +"RFModificationTimestamp": "2025-06-14T23:10:54.955652+00:00" +"ListPrice": 332500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7694.0 +"LivingArea": 1008.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "2993 N Parsons Avenue, Merced, California 95340" +"Coordinates": array:2 [ 0 => -120.451504 1 => 37.315486 ] +"Latitude": 37.315486 +"Longitude": -120.451504 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Scott Messing" +"ListOfficeName": "Century 21 Select Real Estate" +"ListAgentMlsId": "MCmesssc" +"ListOfficeMlsId": "mc40" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "North Merced home on a corner lot with a large backyard. Home features 3 bedrooms, 2 bathrooms, updated electrical panel, central air and heating and the kitchen opens to the family room. Kitchen cabinets were recently painted, a new faucet was installed, and subway style backsplash was added. Updated laminated flooring in the kitchen and both bathrooms. The main suite bath has a newer vanity and toilet. The hall bath has an updated shower over tub with tile that runs all the way to the ceiling. This home has a 25-panel solar system for a lower electrical cost. Enjoy time in the large back yard by the firepit, on your front porch, or on the additional patio area located off the kitchen area. The garage includes extra storage shelves. Great location close to Bear Creek, and UC Merced." +"Appliances": "Built-In Range,Electric Oven" +"AttachedGarageYN": true +"AttributionContact": "209-769-4028" +"BathroomsFull": 2 +"CLIP": 2657879330 +"CoListAgentAOR": "Merced County" +"CoListAgentDirectPhone": "209-725-9100" +"CoListAgentEmail": "stacytennesen@gmail.com" +"CoListAgentFirstName": "Stacy" +"CoListAgentFullName": "Stacy Tennesen" +"CoListAgentKey": "21962709" +"CoListAgentKeyNumeric": "21962709" +"CoListAgentLastName": "Tennesen" +"CoListAgentMlsId": "MCTENNSTA" +"CoListAgentOfficePhone": "209-383-2171" +"CoListAgentStateLicense": "02064027" +"CoListOfficeAOR": "Merced County" +"CoListOfficeEmail": "pbyrd@selectgroupre.com" +"CoListOfficeFax": "209-725-0423" +"CoListOfficeKey": "3278049" +"CoListOfficeKeyNumeric": "3278049" +"CoListOfficeMlsId": "mc40" +"CoListOfficeName": "Century 21 Select Real Estate" +"CoListOfficePhone": "209-383-2171" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Sidewalks" +"ContractStatusChangeDate": "2025-06-06" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-06T14:12:27.550612+00:00" +"CumulativeDaysOnMarket": 8 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From Olive Avenue, S on Parsons to property" +"Electric": "Electricity - On Property" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Laminate" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,In Garage" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-383-2171" +"ListAgentEmail": "scott@scottmessing.com" +"ListAgentFirstName": "Scott" +"ListAgentKey": "17244191" +"ListAgentKeyNumeric": "17244191" +"ListAgentLastName": "Messing" +"ListAgentOfficePhone": "209-383-2171" +"ListAgentStateLicense": "01883959" +"ListAgentURL": "http://www.CValley Homes.com" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "pbyrd@selectgroupre.com" +"ListOfficeFax": "209-725-0423" +"ListOfficeKey": "3278049" +"ListOfficeKeyNumeric": "3278049" +"ListOfficePhone": "209-383-2171" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1115000319 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Corner Lot,Front Yard,Lawn" +"LotSizeAcres": 0.1766 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7694.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-06T06:49:20Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T06:49:20Z" +"OriginalEntryTimestamp": "2025-06-06T06:49:20Z" +"OriginalListPrice": 332500.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374541352" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "007122007000" +"ParkingTotal": "1.0" +"PatioAndPorchFeatures": "Concrete" +"PhotosChangeTimestamp": "2025-06-13T15:56:46Z" +"PhotosCount": 26 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "2669" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Family Room,Primary Bathroom,Primary Bedroom" +"Sewer": "Public Sewer" +"ShowingContactName": "Scott Messing" +"ShowingContactPhone": "2097694028" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115000319" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T06:49:20Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "Parsons" +"StreetNumber": "2993" +"StreetNumberNumeric": "2993" +"StreetSuffix": "Avenue" +"StructureType": "Duplex" +"TaxLot": "14" +"UniversalPropertyId": "US-06047-N-007122007000-R-N" +"Utilities": "Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Family Room,Primary Bathroom,Primary Bedroom",\n "EatingArea": "Area",\n "RoomKitchenFeatures": "Laminate Counters",\n "RoomBathroomFeatures": "Shower,Shower in Tub",\n "AdminUpdateYN": "0",\n "ListingKey": "1115000319",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115000319')" +"CurrentPrice": 332500.0 +"provider_name": "CRMLS" +"RecordSignature": -511617300 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:007122007000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "109140" +"OriginatingSystemCoListOfficeKey": "109140" +"OriginatingSystemListAgentMemberKey": "438076" +"OriginatingSystemCoListAgentMemberKey": "370787121" +"Media": array:26 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117196608" +"ListingId": "FR25130538" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:48:54Z" +"RFModificationTimestamp": "2025-06-14T23:11:21.770442+00:00" +"ListPrice": 500000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 9214.0 +"LivingArea": 2166.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "17 Medieval Street, Merced, California 95341" +"Coordinates": array:2 [ 0 => -120.428836 1 => 37.288023 ] +"Latitude": 37.288023 +"Longitude": -120.428836 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ethan Kolb" +"ListOfficeName": "Real Broker" +"ListAgentMlsId": "FR82678" +"ListOfficeMlsId": "FR83303" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this move-in ready home featuring a beautifully landscaped backyard on a generous 9,200+ sqft lot—perfect for entertaining or adding a future pool! Enjoy energy efficiency with fully paid solar panels and the convenience of a paid water softener. A large, permitted enclosed patio offers a second kitchen and living space, ideal for extended family or gatherings. The downstairs office can easily serve as a 5th bedroom. Additional highlights include RV parking, included appliances, shed, and gazebo. Located just minutes from highway access, great shopping, and highly rated local schools (elementary, middle, and high), this home combines space, comfort, and convenience—don't miss out!" +"Appliances": "Dishwasher,Gas Oven,Gas Range,Microwave,Refrigerator,Water Softener,Tankless Water Heater,Dryer,Washer" +"ArchitecturalStyle": "Colonial" +"AttachedGarageYN": true +"AttributionContact": "559-203-7137" +"BathroomsFull": 2 +"CLIP": 8732258400 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Sidewalks" +"ContractStatusChangeDate": "2025-06-06" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-12T23:07:00.633371+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head southeast on W Childs Ave, then turn left onto Medeival St; 17 Medeival St will be on your left in Merced, CA 95341." +"Electric": "220 Volts in Laundry" +"ElementarySchool": "Pioneer" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "Average Condition" +"FireplaceFeatures": "None" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Golden Valley" +"HighSchoolDistrict": "Weaver Union" +"InteriorFeatures": "Ceiling Fan(s),Separate/Formal Dining Room,Open Floorplan,Pantry,Recessed Lighting,All Bedrooms Up,Entrance Foyer,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Inside,Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Fresno" +"ListAgentDirectPhone": "559-203-7137" +"ListAgentEmail": "ethan@c2realty.com" +"ListAgentFirstName": "Ethan" +"ListAgentKey": "22524230" +"ListAgentKeyNumeric": "22524230" +"ListAgentLastName": "Kolb" +"ListAgentOfficePhone": "619-248-6434" +"ListAgentStateLicense": "02217589" +"ListOfficeAOR": "Fresno" +"ListOfficeKey": "4239787" +"ListOfficeKeyNumeric": "4239787" +"ListOfficePhone": "619-248-6434" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1117196608 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Rectangular Lot,Sprinkler System" +"LotSizeAcres": 0.2115 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 9214.0 +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-06-12T13:50:57Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Other" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T13:50:57Z" +"OriginalEntryTimestamp": "2025-06-12T13:50:57Z" +"OriginalListPrice": 500000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374574670" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "061561021000" +"ParkingFeatures": "Garage Faces Front,Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Enclosed" +"PhotosChangeTimestamp": "2025-06-12T22:20:43Z" +"PhotosCount": 58 +"PoolFeatures": "None" +"PostalCodePlus4": "8017" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bonus Room,Bedroom,Family Room,Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office,Other,Dining Room" +"SecurityFeatures": "Security System" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117196608" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T13:50:57Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Medieval" +"StreetNumber": "17" +"StreetNumberNumeric": "17" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "1" +"UniversalPropertyId": "US-06047-N-061561021000-R-N" +"Utilities": "Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "None" +"WaterSource": "Public" +"WindowFeatures": "Blinds, Drapes" +"YearBuiltSource": "Public Records" +"Zoning": "R-2" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Bonus Room,Family Room,Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Primary Suite,Office,Walk-In Closet",\n "EatingArea": "Family Kitchen,Dining Room",\n "RoomKitchenFeatures": "Quartz Counters,Walk-In Pantry",\n "RoomBathroomFeatures": "Bathtub,Low Flow Toilet(s),Shower,Closet in bathroom,Double sinks in bath(s),Double Sinks in Primary Bath,Linen Closet/Storage,Privacy toilet door,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1117196608",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117196608')" +"CurrentPrice": 500000.0 +"provider_name": "CRMLS" +"RecordSignature": 2024644519 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:061561021000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "365518085" +"OriginatingSystemListAgentMemberKey": "371879500" +"Media": array:58 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] …21 ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114395327" +"ListingId": "MC25113612" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:33:44Z" +"RFModificationTimestamp": "2025-06-14T23:12:44.043501+00:00" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7405.0 +"LivingArea": 1721.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "1948 K Street, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.303631 +"Longitude": -120.4799 +"YearBuilt": 1900 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tami Davidson" +"ListOfficeName": "Realty Executives Of Northern California" +"ListAgentMlsId": "MCDAVITA" +"ListOfficeMlsId": "mc188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Stately Craftsman 3/2 Home with Old World Charm ! This home has so many remarkable details you've just got to see for yourself. This home has over 1700 sf of living space on a large corner lot. As you enter the parlor of this grand home your greeted with library or office. A large living room / family room with a fireplace, original hardwood floors and grand windows. The bedrooms are good size 2 have walk in closets and 1 has an armoire and a full bathroom. The laundry washer and dryer hook-ups and wash tub are in a closeted area. The large remodeled kitchen boasts high ceilings, floor to ceiling built-in cupboard and new tile. There is a gated detached 1 car garage with 2 additional parking inside the gate as well as 2 parking spaces outside the gate. The property has many fruit trees such as oranges, lemons, figs, apricots and a cherry tree. With 4 different fenced yards you could consider a pool or garden as well a room for pets. An extra high covered patio with a garden workshop provide plenty of shade for outdoor projects or lounging. The home has a new electrical panel box, new attic fans, newer hot water tank, full house water softener system, newer insulation and new paint. Shown by appointment !" +"Appliances": "Dishwasher,Gas Oven,Tankless Water Heater" +"ArchitecturalStyle": "Bungalow, Craftsman" +"AttributionContact": "209-564-7290" +"BathroomsFull": 2 +"CLIP": 4498478727 +"CarportSpaces": "2.0" +"CarportYN": true +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Sidewalks" +"Contingency": "Contingent on seller finding a replacement property. Seller has already found a replacement property." +"ContractStatusChangeDate": "2025-05-22" +"Cooling": "Central Air,Attic Fan" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-22T13:20:10.565730+00:00" +"CumulativeDaysOnMarket": 23 +"DaysOnMarket": 23 +"DaysOnMarketReplication": 23 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "G Street to to 20th and K Street" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Good Condition" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Wood" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Built-in Features,High Ceilings,Open Floorplan,Storage,Tile Counters,All Bedrooms Down,Attic,Jack and Jill Bath,Workshop" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Closet" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-8500" +"ListAgentEmail": "209diva@gmail.com" +"ListAgentFirstName": "Tami" +"ListAgentKey": "17186116" +"ListAgentKeyNumeric": "17186116" +"ListAgentLastName": "Davidson" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "01480848" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "mercedexecutives@gmail.com" +"ListOfficeFax": "209-385-8505" +"ListOfficeKey": "3278012" +"ListOfficeKeyNumeric": "3278012" +"ListOfficePhone": "209-385-8500" +"ListOfficeURL": "http://www.realtyexecutives.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-22" +"ListingKeyNumeric": 1114395327 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Corner Lot" +"LotSizeAcres": 0.17 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7405.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-05-22T00:22:04Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-22" +"OnMarketTimestamp": "2025-05-22T00:22:04Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-05-22T00:22:04Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374453552" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "031071015000" +"ParkingFeatures": "Driveway Level,Door-Single,Garage,Gated" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-05-23T19:27:42Z" +"PhotosCount": 22 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Attic,Bathroom,Bonus Room,Bedroom,Living Room,Workshop" +"Sewer": "Public Sewer" +"ShowingContactName": "Tami Davidson" +"ShowingContactPhone": "2095647290" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114395327" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-22T00:22:04Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "K" +"StreetNumber": "1948" +"StreetNumberNumeric": "1948" +"StreetSuffix": "Street" +"StructureType": "House" +"UniversalPropertyId": "US-06047-N-031071015000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Attic,Bonus Room,Jack \u0026 Jill,Living Room,Workshop",\n "RoomKitchenFeatures": "Remodeled Kitchen",\n "RoomBathroomFeatures": "Bathtub,Shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1114395327",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114395327')" +"CurrentPrice": 425000.0 +"provider_name": "CRMLS" +"RecordSignature": 1465850637 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:031071015000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "108753" +"OriginatingSystemListAgentMemberKey": "433682" +"Media": array:22 [ …22] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1107813290" +"ListingId": "MC25042671" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:33:44Z" +"RFModificationTimestamp": "2025-06-14T23:12:39.369927+00:00" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7110.0 +"LivingArea": 1937.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "3940 Temple Court, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.337904 +"Longitude": -120.480142 +"YearBuilt": 1981 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Conchita Swiggart" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "MCSWIGCO" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ MOTIVATED SELLER!!!\r\r\n SPACIOUS MANSIONETTE HOME IN QUIET NORTH MERCED CUL-DE-SAC.\r\r\n Located near Mercy Hospital, Merced College, shopping and UC Merced. This beautiful home offers comfort and space in a peaceful setting. With 1937 sq. ft., this well-maintained residence features three generous bedrooms and two large bathrooms.\r\r\n Inside, you will find a formal living room with a cozy fireplace and built ins. Formal dining room is perfect for entertaining. The light and bright kitchen includes charming breakfast nook and loads of natural light. The spacious laundry room features a sink and additional space for a desk or workstation. \r\r\n The primary bedroom boasts a built-in vanity, large walk-in closet, and plenty of room for a sitting area. \r\r\n This home also offers a large two car garage, and spacious rear yard with covered patio ideal for relaxation or outdoor gatherings. \r\r\n This is a great opportunity to own a well-appointed home in a desirable Merced location. """ +"Appliances": "Double Oven,Dishwasher,Electric Cooktop,Electric Oven,Disposal,Range Hood" +"ArchitecturalStyle": "Ranch" +"AttachedGarageYN": true +"AttributionContact": "209-489-7138" +"BathroomsFull": 2 +"CLIP": 2413941804 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Street Lights,Sidewalks" +"ConstructionMaterials": "Frame" +"ContractStatusChangeDate": "2025-02-26" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-03-08T09:05:05.797887+00:00" +"CumulativeDaysOnMarket": 108 +"DaysOnMarket": 108 +"DaysOnMarketReplication": 108 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "North on M Street left on University Right on Temple court" +"DoorFeatures": "Double Door Entry,Sliding Doors" +"Electric": "220 Volts in Kitchen,220 Volts in Laundry" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"Fencing": "Wood" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Ceiling Fan(s),Separate/Formal Dining Room,Eat-in Kitchen,Recessed Lighting,Storage,Tile Counters,All Bedrooms Down,Bedroom on Main Level,Main Level Primary,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "ecat_1997@yahoo.com" +"ListAgentFirstName": "Conchita" +"ListAgentKey": "17191160" +"ListAgentKeyNumeric": "17191160" +"ListAgentLastName": "Swiggart" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "01221716" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "greg@londonproperties.com" +"ListOfficeFax": "209-722-8181" +"ListOfficeKey": "3278096" +"ListOfficeKeyNumeric": "3278096" +"ListOfficePhone": "209-725-2100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-02-26" +"ListingKeyNumeric": 1107813290 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1632 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7110.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-13T08:42:29Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-02-26" +"OnMarketTimestamp": "2025-02-26T13:51:41Z" +"OriginalEntryTimestamp": "2025-02-26T13:51:41Z" +"OriginalListPrice": 475000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373996072" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "230191012000" +"ParkingFeatures": "Driveway,Garage,On Street" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete, Covered" +"PhotosChangeTimestamp": "2025-02-27T00:59:42Z" +"PhotosCount": 24 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "2117" +"PreviousListPrice": 440000.0 +"PriceChangeTimestamp": "2025-06-13T08:42:29Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Bedroom,Entry/Foyer,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Dining Room" +"SecurityFeatures": "Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Conchita Swiggart" +"ShowingContactPhone": "2094897138" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1107813290" +"SpaFeatures": "None" +"SpecialListingConditions": "Trust" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-02-26T13:51:41Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Temple" +"StreetNumber": "3940" +"StreetNumberNumeric": "3940" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "59" +"UniversalPropertyId": "US-06047-N-230191012000-R-N" +"Utilities": "Cable Available,Electricity Connected,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Entry,Family Room,Formal Entry,Kitchen,Laundry,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom,Primary Suite",\n "EatingArea": "Area,Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Shower,Shower in Tub,Double sinks in bath(s),Double Sinks in Primary Bath,Linen Closet/Storage,Main Floor Full Bath,Tile Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1107813290",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1107813290')" +"CurrentPrice": 425000.0 +"provider_name": "CRMLS" +"RecordSignature": 492075874 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:230191012000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "435306" +"Media": array:24 [ …24] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114244348" +"ListingId": "MC25109079" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:33:44Z" +"RFModificationTimestamp": "2025-06-14T23:12:42.477995+00:00" +"ListPrice": 495000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 6870.0 +"LivingArea": 2241.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "3529 Paseo Verde Avenue, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.330137 +"Longitude": -120.487919 +"YearBuilt": 2004 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Teri Kleinen" +"ListOfficeName": "BHGRE Everything Real Estate" +"ListAgentMlsId": "mckleite" +"ListOfficeMlsId": "mc294" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Spacious 5-Bedroom Home – Ideal for Families or Investors!\r\r\n \r\r\n Welcome to 3529 Paseo Verde Drive, a generously sized home offering 5 bedrooms and 3 full bathrooms, perfectly suited for a large family or a savvy investor. One bedroom and a full bath are conveniently located on the main floor, ideal for guests, multigenerational living, or added rental flexibility.\r\r\n \r\r\n The home boasts a large primary suite, providing a private retreat with ample space and comfort. The expansive backyard offers endless potential—whether for entertaining, gardening, or creating your dream outdoor oasis.\r\r\n \r\r\n Currently rented to 5 UC students, this property presents an excellent investment opportunity with steady income potential. Located close to shopping, dining, the UC CatTracks bus stop, and a wide range of other amenities, it's a prime location for both residents and tenants alike.\r\r\n \r\r\n Don't miss this versatile and well-located property—schedule your showing today! """ +"Appliances": "Dishwasher" +"AttachedGarageYN": true +"AttributionContact": "209-261-4509" +"BathroomsFull": 3 +"CLIP": 1007635709 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Suburban" +"Contingency": "Possession subject to tenants rights. Tenants have a lease through 7/31/2025" +"ContractStatusChangeDate": "2025-05-17" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-17T17:46:45.217593+00:00" +"CumulativeDaysOnMarket": 28 +"DaysOnMarket": 28 +"DaysOnMarketReplication": 28 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From R Street turn West onto Buena Vista Drive then right onto Paseo Verde" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"Flooring": "Carpet" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Cathedral Ceiling(s),Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-722-5400" +"ListAgentEmail": "teri_kleinen@yahoo.com" +"ListAgentFax": "209-722-5406" +"ListAgentFirstName": "Teri" +"ListAgentKey": "17275125" +"ListAgentKeyNumeric": "17275125" +"ListAgentLastName": "Kleinen" +"ListAgentOfficePhone": "209-383-7653" +"ListAgentStateLicense": "01961434" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "info@everythingbhgre.com" +"ListOfficeFax": "209-722-5406" +"ListOfficeKey": "3278043" +"ListOfficeKeyNumeric": "3278043" +"ListOfficePhone": "209-383-7653" +"ListOfficeURL": "http://www.everythingbhgre.com" +"ListingAgreement": "Exclusive Right With Exception" +"ListingContractDate": "2025-05-17" +"ListingKeyNumeric": 1114244348 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1577 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6870.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-05-17T10:04:26Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Tenant" +"OnMarketDate": "2025-05-17" +"OnMarketTimestamp": "2025-05-17T10:04:26Z" +"OriginalEntryTimestamp": "2025-05-17T10:04:26Z" +"OriginalListPrice": 495000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374432273" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "058290015000" +"ParkingFeatures": "Garage Faces Front" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-17T17:28:42Z" +"PhotosCount": 34 +"PoolFeatures": "None" +"Possession": "See Remarks" +"PostalCodePlus4": "1880" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Laundry,Living Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Teri Kleinen" +"ShowingContactPhone": "2092614509" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114244348" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-17T10:04:26Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Paseo Verde" +"StreetNumber": "3529" +"StreetNumberNumeric": "3529" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "78" +"UniversalPropertyId": "US-06047-N-058290015000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"Zoning": "RP-D" +"CustomFields": """ {\n "RoomType": "Laundry,Living Room,Main Floor Bedroom",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1114244348",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114244348')" +"CurrentPrice": 495000.0 +"provider_name": "CRMLS" +"RecordSignature": 623189815 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:058290015000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "108991" +"OriginatingSystemListAgentMemberKey": "8039645" +"Media": array:34 [ …34] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111896782" +"ListingId": "MC25084577" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T21:09:30Z" +"RFModificationTimestamp": "2025-06-15T00:41:17.721206+00:00" +"ListPrice": 469900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7990.0 +"LivingArea": 1898.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "1251 Paseo Redondo Drive, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.326228 +"Longitude": -120.492581 +"YearBuilt": 1989 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sandra Hayes" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "mchayesa" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Tucked away in Fahren’s Park - one of Merced’s most peaceful and desirable neighborhoods - this 3-bedroom, 2-bathroom home offers the perfect blend of comfort and charm. With 1,898 sq ft of living space on a generous 7,990 sq ft lot, there’s room to relax, entertain, and truly feel at home. Head into your private backyard, where sunny Central Valley days are best spent by the sparkling saltwater pool. Conveniently located just minutes from UC Merced, shopping, dining, disc golf, and the local dog park - you’ll have everything you need nearby, all while enjoying the calm of a quiet, established neighborhood. Don’t miss this opportunity to make it yours - schedule your showing today!" +"Appliances": "Dishwasher,Electric Range,Gas Cooktop,Microwave" +"AssociationAmenities": "Other" +"AssociationFee": "412.0" +"AssociationFeeFrequency": "Annually" +"AssociationName": "Los Verdes Estates" +"AssociationPhone": "2093211202" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "209-756-1493" +"BathroomsFull": 2 +"CLIP": 1491052062 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Dog Park,Golf,Suburban,Park" +"ContractStatusChangeDate": "2025-05-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-04-18T01:19:12.363638+00:00" +"CumulativeDaysOnMarket": 25 +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "R Street to Buena Vista, West on Buena Vista, South on Los Verdes Drive, West on Paseo Redondo" +"DocumentsChangeTimestamp": "2025-04-18T14:24:49Z" +"DocumentsCount": 1 +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Street" +"FireplaceFeatures": "Family Room,Gas,Primary Bedroom" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central, Fireplace(s), Propane" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "shayes@londonproperties.com" +"ListAgentFirstName": "Sandra" +"ListAgentKey": "17335685" +"ListAgentKeyNumeric": "17335685" +"ListAgentLastName": "Hayes" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "02121344" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "greg@londonproperties.com" +"ListOfficeFax": "209-722-8181" +"ListOfficeKey": "3278096" +"ListOfficeKeyNumeric": "3278096" +"ListOfficePhone": "209-725-2100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-08" +"ListingKeyNumeric": 1111896782 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,Submit,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Front Yard,Sprinklers In Front,Lawn,Near Park" +"LotSizeAcres": 0.1834 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7990.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-05-14T12:16:02Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-05-12" +"OffMarketTimestamp": "2025-05-14T12:16:02Z" +"OnMarketDate": "2025-04-17" +"OnMarketTimestamp": "2025-04-17T16:16:37Z" +"OriginalEntryTimestamp": "2025-04-17T16:16:37Z" +"OriginalListPrice": 479900.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374260861" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "058210007000" +"ParkingFeatures": "Garage Faces Front,Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-18T21:42:42Z" +"PhotosCount": 49 +"PoolFeatures": "In Ground,Private" +"PoolPrivateYN": true +"PostalCodePlus4": "1828" +"PreviousListPrice": 479900.0 +"PriceChangeTimestamp": "2025-05-01T14:16:27Z" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-05-12" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry" +"Sewer": "Public Sewer" +"ShowingContactName": "Sandra Hayes" +"ShowingContactPhone": "209-756-1493" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111896782" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-14T12:16:02Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Paseo Redondo" +"StreetNumber": "1251" +"StreetNumberNumeric": "1251" +"StreetSuffix": "Drive" +"StructureType": "House" +"UniversalPropertyId": "US-06047-N-058210007000-R-N" +"View": "Park/Greenbelt, Neighborhood, Pool" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry",\n "AdminUpdateYN": "0",\n "ListingKey": "1111896782",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111896782')" +"CurrentPrice": 469900.0 +"provider_name": "CRMLS" +"RecordSignature": 480494008 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:058210007000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "364649772" +"Media": array:49 [ …49] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112369018" +"ListingId": "MC25094778" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T20:29:55Z" +"RFModificationTimestamp": "2025-06-14T20:55:43.441489+00:00" +"ListPrice": 415000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6000.0 +"LivingArea": 1556.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "661 San Diego Court, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.330658 +"Longitude": -120.480094 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Julio Trevino" +"ListOfficeName": "Century 21 Select Real Estate" +"ListAgentMlsId": "mctrevju" +"ListOfficeMlsId": "mc40" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Step into contemporary comfort and timeless design with this beautifully renovated 1,556 sq. ft. home, ideally located near local amenities and main roads. While being walking distance from the college and minutes from uptown restaurants, shopping at the mall, grocery stores, and the dog park, this residence offers both convenience and charm.\r\r\n Inside, you'll be welcomed by a bright, open floor plan with a modern concept that flows seamlessly throughout the home. The spacious kitchen is a true showstopper, featuring luxurious quartz countertops, a large quartz island perfect for entertaining, a double oven, and sleek cabinetry. Crown molding adds a touch of sophistication, while every door and window has been upgraded—including energy-efficient double-pane windows for added comfort and cost savings.\r\r\n All bathrooms have been elegantly updated with quartz finishes, and the entire home is outfitted with durable, stylish porcelain tile flooring. From top to bottom, every detail reflects quality craftsmanship and modern appeal.\r\r\n With easy access to main roads like M and Yosemite, this beautiful home is perfect for anyone looking for upscale living in a highly desirable neighborhood. """ +"AccessibilityFeatures": "Parking" +"Appliances": "Double Oven,Refrigerator,Dryer,Washer" +"AttachedGarageYN": true +"AttributionContact": "209-349-1900" +"BathroomsFull": 2 +"CLIP": 2210313856 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Street Lights" +"Contingency": "This Sale is contingent upon finding a replacement property. Solar to be assumed by buyer. Escrow pre-opened with Tristan Blase at WFG Title Company." +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-04-30T23:41:10.708971+00:00" +"CumulativeDaysOnMarket": 45 +"DaysOnMarket": 45 +"DaysOnMarketReplication": 45 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "head down M street toward north Merced. Turn Left onto Donna Dr. Take the first right onto Guadalupe Ave and finally turn right onto San Diego Ct." +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "See Remarks" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"Inclusions": "Refrigerator, washer, and drier" +"InteriorFeatures": "Ceiling Fan(s),Crown Molding,Quartz Counters" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-383-2171" +"ListAgentEmail": "julio.trevino@c21selectgroup.com" +"ListAgentFirstName": "Julio" +"ListAgentKey": "19182940" +"ListAgentKeyNumeric": "19182940" +"ListAgentLastName": "Trevino" +"ListAgentOfficePhone": "209-383-2171" +"ListAgentStateLicense": "02086144" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "pbyrd@selectgroupre.com" +"ListOfficeFax": "209-725-0423" +"ListOfficeKey": "3278049" +"ListOfficeKeyNumeric": "3278049" +"ListOfficePhone": "209-383-2171" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112369018 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, Contract, FHA, Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Sprinklers In Front" +"LotSizeAcres": 0.1377 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6000.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-07T08:54:26Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-04-30" +"OnMarketTimestamp": "2025-04-30T15:48:11Z" +"OriginalEntryTimestamp": "2025-04-30T15:48:11Z" +"OriginalListPrice": 450000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374330073" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "236032016000" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-30T23:24:40Z" +"PhotosCount": 16 +"PoolFeatures": "None" +"PostalCodePlus4": "2223" +"PreviousListPrice": 435000.0 +"PriceChangeTimestamp": "2025-06-07T08:54:26Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Kitchen,Living Room,Primary Bathroom,Primary Bedroom" +"Sewer": "Public Sewer" +"ShowingContactName": "Julio Trevino" +"ShowingContactPhone": "(209) 349-1900" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112369018" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-30T15:48:11Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "San Diego" +"StreetNumber": "661" +"StreetNumberNumeric": "661" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "21" +"UniversalPropertyId": "US-06047-N-236032016000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Kitchen,Living Room,Primary Bathroom,Primary Bedroom",\n "RoomKitchenFeatures": "Kitchen Island,Kitchen Open to Family Room,Quartz Counters",\n "RoomBathroomFeatures": "Quartz Counters,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1112369018",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112369018')" +"CurrentPrice": 415000.0 +"provider_name": "CRMLS" +"RecordSignature": -705202280 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:236032016000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "109140" +"OriginatingSystemListAgentMemberKey": "365849180" +"Media": array:16 [ …16] } ] +success: true +page_size: 10 +page_count: 162 +count: 1612 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5444 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5443 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115044718" +"ListingId": "OC25127680" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:47.363769+00:00" +"ListPrice": 5700000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13503.6 +"LivingArea": 2047.0 +"BuildingAreaTotal": 0 +"City": "Corona Del Mar" +"PostalCode": "92625" +"UnparsedAddress": "4621 Hampden Rd, Corona Del Mar, California 92625" +"Coordinates": array:2 [ …2] +"Latitude": 33.589326 +"Longitude": -117.859593 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lynn Paris" +"ListOfficeName": "Pinnacle Real Estate Group" +"ListAgentMlsId": "OCPARILYN" +"ListOfficeMlsId": "OC06746" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Elegant Coastal Living | Beautifully Remodeled Home in the Coveted Cameo Shores Community! As a resident of Cameo Shores, you enjoy exclusive access to the stunning private beaches, unlocked by your key to two separate entrances. These beaches are not only breathtaking, featuring incredible rock formations, but also offer a sense of privacy that's hard to find elsewhere. Additionally, residents can take advantage of scenic beach trails that meander through the picturesque Pelican Hill Golf Course, providing a perfect blend of nature and recreation. The unique pathways in the community connect you seamlessly to Third Beach in Corona del Mar and Crystal Cove State Beach, allowing for easy enjoyment of walking and surfing. Ultimately, you also have the opportunity to explore the beautiful Crystal Cove State Park, as well as the charming Village of Corona Del Mar, thereby enhancing your coastal living experience.\r\r\n This stunning property is situated on a rare 0.31-acre lot with great appreciation potential, Nestled in a private corner, this home features a tranquil backyard, front yard, and side yard that ensure ample natural light and privacy. Floor-to-ceiling windows beautifully integrate the natural landscape of the yard with the open-concept layout. The spacious design includes a large kitchen, a generous master suite, two additional bedrooms, a home office, and an outdoor dining terrace, all thoughtfully arranged. The garage and front yard provide convenient parking options. The entire home has undergone extensive renovation and upgrading.\r\r\n .A significant highlight is the rare 0.31-acre lot, which offers the potential for an ADU expansion or the construction of a new luxury home up to 8,000 square feet, complete with architect-designed plans included. This property presents tremendous potential for appreciation.\r\r\n Community Amenities: The private park and playground in Cameo Shores provide a safe space for families, allowing children and pets to play freely.\r\r\n Excellent School District: Rated 10/10, offering outstanding educational resources.Low Property HOA: Only $1,050 per year. For more details please don't hesitate to contact Lynn Paris at 949-351-1343. """ +"AssociationAmenities": "Dog Park,Golf Course,Jogging Path,Management,Barbecue,Picnic Area,Playground,Guard,Security,Trail(s)" +"AssociationFee": "1050.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Powerstone Property Management" +"AssociationPhone": "9493724022" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-351-1343" +"BathroomsFull": 3 +"CLIP": 6289835863 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Dog Park" +"Contingency": "N" +"ContractStatusChangeDate": "2024-06-01" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-07T06:26:21.386886+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "N/A" +"DocumentsChangeTimestamp": "2025-06-08T09:24:52Z" +"DocumentsCount": 1 +"ElementarySchool": "Harbor View" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Newport Harbor" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "lynnlinparis@gmail.com" +"ListAgentFirstName": "Lynn" +"ListAgentKey": "21318104" +"ListAgentKeyNumeric": "21318104" +"ListAgentLastName": "Paris" +"ListAgentOfficePhone": "626-888-9808" +"ListAgentStateLicense": "02193706" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "usnationalrealty@gmail.com" +"ListOfficeFax": "626-986-5345" +"ListOfficeKey": "3275512" +"ListOfficeKeyNumeric": "3275512" +"ListOfficePhone": "626-888-9808" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-01" +"ListingKeyNumeric": 1115044718 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,1031 Exchange" +"LivingAreaSource": "Public Records" +"LotFeatures": "Sprinklers In Front,Sprinklers On Side,Value In Land" +"LotSizeAcres": 0.31 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 13503.6 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-06T23:02:41Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Corona Del Mar" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "3" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T23:02:41Z" +"OriginalEntryTimestamp": "2025-06-06T23:02:41Z" +"OriginalListPrice": 5700000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374548978" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "47505411" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-08T16:33:40Z" +"PhotosCount": 42 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office" +"Sewer": "Public Sewer" +"ShowingContactName": "Lynn Paris" +"ShowingContactPhone": "9493511343" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115044718" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T23:02:41Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Hampden Rd" +"StreetNumber": "4621" +"StreetNumberNumeric": "4621" +"StructureType": "House" +"TaxLot": "n" +"UniversalPropertyId": "US-06059-N-47505411-R-N" +"View": "Park/Greenbelt,Golf Course,Ocean,Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://www.wellcomemat.com/video/5979bb66942c1m6fu/CDM/CA/92625/Hampden-Rd/OC25127680/" +"VirtualTourURLUnbranded": "https://www.wellcomemat.com/mls/5979bb66942c1m6fu" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office",\n "AdminUpdateYN": "0",\n "ListingKey": "1115044718",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115044718')" +"CurrentPrice": 5700000.0 +"provider_name": "CRMLS" +"RecordSignature": 2080925851 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:47505411" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "143572682" +"OriginatingSystemListAgentMemberKey": "369525581" +"Media": array:42 [ …42] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5627 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112308116" +"ListingId": "25531679" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:19.378602+00:00" +"ListPrice": 414500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5320.0 +"LivingArea": 726.0 +"BuildingAreaTotal": 726.0 +"City": "San Bernardino" +"PostalCode": "92411" +"UnparsedAddress": "1256 W 6th Street, San Bernardino, California 92411" +"Coordinates": array:2 [ …2] +"Latitude": 34.110461 +"Longitude": -117.312781 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eran Fattal" +"ListOfficeName": "Dynasty Real Estate" +"ListAgentMlsId": "CLW-C103971" +"ListOfficeMlsId": "CLW-X78890" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "REMODELED FHA APPROVED HOME: 3 BEDS PLUS 1.5 BATH. (PUBLIC RECORDS SHOW 2 PLUS 1) NEW DUAL PANE WINDOWS. REPLACED CENTRAL AIR AND HEAT. NEW CUSTOM PORCELAIN TILE FLOORING IN KITCHEN, LIVING ROOM, BATHROOMS, AND LAUNDRY ROOM. NEW GRAY RUSTIC STYLE LAMINATE FLOORING IN BEDROOMS. THE KITCHEN IS BRAND NEW. NEW CUSTOM KITCHEN CABINETS, NEW QUARTZ STONE COUNTERS, NEW GARBAGE DISPOSAL, NEW PULL-OUT FAUCET. NEW BATHTUB, NEW TILED UP SHOWERS WALLS WITH ELEGANT MOSAIC DESIGN, NEW VANITIES. NEW TOILETS. ALL NEW PLUMBING FIXTURES. NEW LIGHT FIXTURES. NEW PAINT INSIDE AND OUT. NEW GARAGE DOOR. FHA/VA/DOWN PAYMENT ASSISTANCE/OK" +"Appliances": "Disposal" +"ArchitecturalStyle": "See Remarks" +"BathroomsFull": 1 +"BuyerFinancing": "Conventional, FHA, VA" +"CLIP": 8804738686 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-29T19:32:38.644803+00:00" +"DaysOnMarket": 46 +"DaysOnMarketReplication": 46 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "PLEASE REFER TO GOOGLE MAPS" +"FireplaceFeatures": "None" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Out of Area Board" +"ListAgentDirectPhone": "747-343-1266" +"ListAgentEmail": "eranfattal@icloud.com" +"ListAgentFax": "909-373-2515" +"ListAgentFirstName": "Eran" +"ListAgentKey": "17056852" +"ListAgentKeyNumeric": "17056852" +"ListAgentLastName": "Fattal" +"ListAgentOfficePhone": "909-373-2505" +"ListAgentStateLicense": "01304180" +"ListOfficeAOR": "Out of Area Board" +"ListOfficeFax": "909-373-2515" +"ListOfficeKey": "3237841" +"ListOfficeKeyNumeric": "3237841" +"ListOfficePhone": "909-373-2505" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112308116 +"ListingService": "Entry Only" +"LotSizeAcres": 0.1221 +"LotSizeDimensions": "38x140" +"LotSizeSquareFeet": 5320.0 +"MLSAreaMajor": "274 - San Bernardino" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T04:31:51Z" +"OriginalEntryTimestamp": "2025-04-29T11:17:09Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374319567" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "0138052070000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-29T20:25:39Z" +"PhotosCount": 8 +"PoolFeatures": "None" +"PostalCodePlus4": "2705" +"PreviousListPrice": 425000.0 +"PriceChangeTimestamp": "2025-06-14T16:51:35Z" +"PropertySubTypeAdditional": "Single Family Residence" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112308116" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-29T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "6th" +"StreetNumber": "1256" +"StreetNumberNumeric": "1256" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06071-N-0138052070000-R-N" +"View": "None" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112308116"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112308116')" +"CurrentPrice": 414500.0 +"provider_name": "CRMLS" +"RecordSignature": -791365164 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0138052070000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "113814" +"OriginatingSystemListAgentMemberKey": "442704" +"Media": array:8 [ …8] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5626 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112991539" +"ListingId": "ML82006135" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:32.027614+00:00" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 4.25 +"LivingArea": 950.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "38500 Paseo Padre Pkwy 102, Fremont, California 94536" +"Coordinates": array:2 [ …2] +"Latitude": 37.55788739 +"Longitude": -121.98683642 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nisha Singh" +"ListOfficeName": "eXp Realty of California Inc" +"ListAgentMlsId": "ML5101215" +"ListOfficeMlsId": "ML5009355" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover modern living in heart of Fremont in the highly desirable Parkmont neighborhood! This spacious condo has an ideal floor plan that includes a large living room, sizable bedrooms, kitchen and a formal dining area. Parkmont Gardens community includes ideal amenities including a lush greenbelt and a swimming pool! This home is in an excellent commuter location, walking distance from BART and nearby Centerville Train Station, 880 freeway, 680 freeway and Niles Canyon. Around the corner from multiple shopping centers, Whole Foods, Centerville Community Park, Alameda Creek Trail, great schools and beloved local eateries! This home is a must see!" +"Appliances": "Gas Cooktop,Refrigerator" +"AssociationAmenities": "Trash" +"AssociationFee": "550.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Parkmont Gardens HOA" +"AssociationPhone": "925-495-4545" +"AssociationYN": true +"BathroomsFull": 1 +"CLIP": 8478246755 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-09T04:14:15.565194+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: paseo padre" +"Flooring": "Carpet" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Wall Furnace" +"HeatingYN": true +"HighSchoolDistrict": "Alameda City Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentEmail": "nishasingh@gmail.com" +"ListAgentFirstName": "Nisha" +"ListAgentKey": "24251205" +"ListAgentKeyNumeric": "24251205" +"ListAgentLastName": "Singh" +"ListAgentOfficePhone": "(888) 584-942..." +"ListAgentStateLicense": "01937867" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "925-262-1171" +"ListOfficeKey": "4763658" +"ListOfficeKeyNumeric": "4763658" +"ListOfficePhone": "(888) 584-942..." +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112991539 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0001 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4.25 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T13:48:49Z" +"OriginalEntryTimestamp": "2025-05-08T13:21:18Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374380809" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "501153439" +"ParkingFeatures": "Covered,Off Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T18:36:45Z" +"PhotosCount": 7 +"PoolFeatures": "In Ground" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Other" +"Sewer": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112991539" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-08T13:21:18Z" +"StreetName": "Paseo Padre Pkwy" +"StreetNumber": "38500" +"StreetNumberNumeric": "38500" +"UnitNumber": "102" +"UniversalPropertyId": "US-06001-N-501153439-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "Residential" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1112991539"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112991539')" +"CurrentPrice": 499000.0 +"provider_name": "CRMLS" +"RecordSignature": -1685891191 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:501153439" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558053" +"OriginatingSystemListAgentMemberKey": "372906814" +"Media": array:7 [ …7] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5628 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113888520" +"ListingId": "ML82006272" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:54.002631+00:00" +"ListPrice": 2725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 8370.0 +"LivingArea": 2380.0 +"BuildingAreaTotal": 0 +"City": "Menlo Park" +"PostalCode": "94025" +"UnparsedAddress": "3523 Oak Drive, Menlo Park, California 94025" +"Coordinates": array:2 [ …2] +"Latitude": 37.47309796 +"Longitude": -122.19842405 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Emely Weissman" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML154192" +"ListOfficeMlsId": "ML37689" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This lovely home is set fairly far back, in a picture postcard kind of way, on its 8,370 square foot lot. The neighborhood is a favorite: green, parklike, picturesque, peaceful, great for taking a walk or joining neighbors for the neighborhood's weekly happy hour get together. The wonderful kitchen has handsome cabinetry, spacious granite counters, gas cooking, stainless steel appliances, and a built-in wine refrigerator. There are both a breakfast area and a separate dining room, both family room and living room, and a first floor bedroom that is great as an office. All bathrooms are updated or remodeled; the principal bathroom with oversized tub and shower is particularly luxurious. Hardwood floors throughout main floor, three carpeted bedrooms up and one bedroom on main floor, three skylights. Deck has an excellent built in hot tub, and there is a substantial backyard. This is a terrific place to call home." +"Appliances": "Dishwasher, Disposal, Refrigerator" +"ArchitecturalStyle": "Mediterranean, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3251173763 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-14" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-15T02:38:52.962690+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Middlefield Road, then turn onto San Benito or Placitas to left on Oak Drive, to 3523. Cross Street: Placitas" +"FireplaceFeatures": "Family Room,Wood Burning" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Menlo-Atherton" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-814-0374" +"ListAgentEmail": "emely.weissman@compass.com" +"ListAgentFax": "650-323-1143" +"ListAgentFirstName": "Emely" +"ListAgentKey": "20889480" +"ListAgentKeyNumeric": "20889480" +"ListAgentLastName": "Weissman" +"ListAgentOfficePhone": "(650) 323-1111" +"ListAgentStateLicense": "01119038" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-323-1143" +"ListOfficeKey": "4763954" +"ListOfficeKeyNumeric": "4763954" +"ListOfficePhone": "(650) 323-1111" +"ListOfficeURL": "http://www.compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-14" +"ListingKeyNumeric": 1113888520 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeAcres": 0.1921 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8370.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-14" +"OnMarketTimestamp": "2025-05-14T12:18:53Z" +"OriginalEntryTimestamp": "2025-05-13T17:00:00Z" +"OriginalListPrice": 2825000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374412483" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "060153290" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Deck" +"PhotosChangeTimestamp": "2025-06-15T07:03:19Z" +"PhotosCount": 24 +"PoolFeatures": "Above Ground" +"PreviousListPrice": 2825000.0 +"PriceChangeTimestamp": "2025-06-14T16:49:32Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Entry/Foyer, Laundry" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1113888520" +"SpaFeatures": "Above Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:00Z" +"StoriesTotal": "2" +"StreetName": "Oak" +"StreetNumber": "3523" +"StreetNumberNumeric": "3523" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06081-N-060153290-R-N" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R10010" +"CustomFields": """ {\n "RoomType": "Formal Entry,Laundry",\n "AdminUpdateYN": "0",\n "ListingKey": "1113888520",\n "RoomKitchenFeatures": "Granite Counters"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1113888520')" +"CurrentPrice": 2725000.0 +"provider_name": "CRMLS" +"RecordSignature": 2051684006 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:060153290" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "368558344" +"OriginatingSystemListAgentMemberKey": "368705589" +"Media": array:24 [ …24] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4225 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117318108" +"ListingId": "PW25130551" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:31.621904+00:00" +"ListPrice": 1295000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7800.0 +"LivingArea": 1463.0 +"BuildingAreaTotal": 0 +"City": "Mission Viejo" +"PostalCode": "92691" +"UnparsedAddress": "23266 Via Ronda, Mission Viejo, California 92691" +"Coordinates": array:2 [ …2] +"Latitude": 33.625063 +"Longitude": -117.655413 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Baroth" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "PWBARRAC" +"ListOfficeMlsId": "PB1364" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 23266 Via Ronda in sought after Barcelona neighborhood offering 4 bedrooms, 3 baths, a spacious entertainers backyard featuring a custom heated pool and spa, a fully insulated patio cover complete with lighting, ceiling fans and custom curtain brackets for additional shade & comfort also boast beautiful easy care tropical fauna, mature lemon and orange trees, and a versatile large playhouse/ office/ hobby room wired with electric, lighting & internet. The perfect setting for summer BBQ’s, family birthdays, holidays or romantic evening dinners. The main level open floor plan has fireplace in cathedral ceiling living room, formal dining room with bright, natural light flowing thru kitchen window box and back door facing lush back yard patio and pool. Finishing the downstairs is a large bedroom with French doors opening to backyard, currently being used as entertainment room and a full bathroom. Retreat to the upstairs primary bedroom full en suite bath with jetted tub, walk in closet completed with vanity, custom shelving and drawers. Another full bath and 2 bedrooms, one loft style that could double as home office and LVP flooring throughout complete the upstairs. Energy-efficient solar panels provide cost-saving benefits, making this home as practical as it is beautiful. Completing this home is Central HVAC system, large 2 car attached garage with washer and dryer hookups, beautiful artificial turf for low maintenance front yard, And Full Access to Lake Mission Viejo Membership and all it has to offer. Talk about location, Award winning Capistrano schools, nearby Aurora Park with fields, playground, volleyball & basketball court, beautiful wooded area for the evening strolls, fine restaurants, shopping and golf course all nearby!" +"Appliances": "Dishwasher,Gas Oven,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Controlled Access,Picnic Area,Playground" +"AssociationFee": "179.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Mission Viejo Lake Membership" +"AssociationPhone": "949-770-1313" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "rachel@rachelbaroth.com" +"BathroomsFull": 3 +"CLIP": 8991206809 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gutter(s)" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-13T03:02:02.144261+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit 5 freeway at Alicia Parkway, follow Alicia Parkway to Right on Via Aura to Right on Via Ronda" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Capistrano Valley" +"HighSchoolDistrict": "Capistrano Unified" +"Inclusions": "Refrigerator" +"InteriorFeatures": "Cathedral Ceiling(s),Separate/Formal Dining Room,Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "rachel@rachelbaroth.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "17072220" +"ListAgentKeyNumeric": "17072220" +"ListAgentLastName": "Baroth" +"ListAgentOfficePhone": "562-989-4608" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01396461" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-989-4803" +"ListOfficeKey": "3284761" +"ListOfficeKeyNumeric": "3284761" +"ListOfficePhone": "562-989-4608" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Open" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1117318108 +"ListingService": "Entry Only" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1791 +"LotSizeDimensions": "130 x 60" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T16:53:41Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T16:53:41Z" +"OriginalEntryTimestamp": "2025-06-12T16:53:41Z" +"OriginalListPrice": 1295000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374576329" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "80826104" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-15T06:51:40Z" +"PhotosCount": 19 +"PoolFeatures": "Gas Heat,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2229" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Anthony" +"ShowingContactPhone": "949-334-7305" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117318108" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T16:53:41Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Via Ronda" +"StreetNumber": "23266" +"StreetNumberNumeric": "23266" +"StructureType": "House" +"TaxLot": "38" +"UniversalPropertyId": "US-06059-N-80826104-R-N" +"View": "Mountain(s), Peek-A-Boo" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Main Floor Bedroom",\n "EatingArea": "Dining Room",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1117318108",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117318108')" +"CurrentPrice": 1295000.0 +"provider_name": "CRMLS" +"RecordSignature": -1772171666 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:80826104" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "43354" +"OriginatingSystemListAgentMemberKey": "9227702" +"Media": array:19 [ …19] } ] +success: true +page_size: 5 +page_count: 135388 +count: 676939 +after_key: "" } ] ]
