1609 Properties
Sort by:
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: 62427d577443c37c0add958113b68dcbd9cfcfc17e2006daacaec14037159fe3" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4858 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117017324" +"ListingId": "MC25131341" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T14:09:49Z" +"RFModificationTimestamp": "2025-06-12T16:35:49.870494+00:00" +"ListPrice": 385122.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 5592.0 +"LivingArea": 1213.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "782 Brent Court, Merced, California 95341" +"Coordinates": array:2 [ …2] +"Latitude": 37.28018 +"Longitude": -120.496452 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elena Hernandez" +"ListOfficeName": "Advanced Market Realty, Inc" +"ListAgentMlsId": "MCHERNEL" +"ListOfficeMlsId": "mc1010" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ The Fasano floor plan features 3 bedrooms, 2 baths, 2 car garage, a New construction home with Solar panels installed.\r\r\n This community is close to schools, downtown Merced, HWY 59 and free way access. """ +"Appliances": "Dishwasher,Microwave,Tankless Water Heater" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 1006241986 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking, Curbs, Sidewalks" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-12T01:26:35.222017+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 5 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "South M street, Off of Gerard Ave, right on Marcus st, right on Callie, left on Brent Court" +"Electric": "220 Volts in Laundry" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "front" +"Fencing": "None" +"FireplaceFeatures": "None" +"Flooring": "Carpet" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Inside" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentEmail": "Elena@stonefieldhome.com" +"ListAgentFirstName": "Elena" +"ListAgentKey": "22760246" +"ListAgentKeyNumeric": "22760246" +"ListAgentLastName": "Hernandez" +"ListAgentOfficePhone": "209-826-7200" +"ListAgentStateLicense": "02103953" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "Dmitri@ranchwood.com" +"ListOfficeFax": "209-826-6900" +"ListOfficeKey": "3280358" +"ListOfficeKeyNumeric": "3280358" +"ListOfficePhone": "209-826-7200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-11" +"ListingKeyNumeric": 1117017324 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,VA Loan" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1284 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5592.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-11T15:40:04Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NewConstructionYN": true +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-11" +"OnMarketTimestamp": "2025-06-11T15:40:04Z" +"OriginalEntryTimestamp": "2025-06-11T15:40:04Z" +"OriginalListPrice": 385122.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374568870" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "222090030000" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-12T01:04:50Z" +"PhotosCount": 4 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactName": "Elena Hernandez" +"ShowingContactPhone": "209-761-5527" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117017324" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T15:40:04Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Brent" +"StreetNumber": "782" +"StreetNumberNumeric": "782" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "127" +"UniversalPropertyId": "US-06047-N-222090030000-R-N" +"View": "Neighborhood, Orchard" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Builder" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "RoomBathroomFeatures": "Low Flow Shower,Shower in Tub",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1117017324",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117017324')" +"CurrentPrice": 385122.0 +"provider_name": "CRMLS" +"RecordSignature": 104434782 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:222090030000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "132426" +"OriginatingSystemListAgentMemberKey": "372219815" +"Media": array:4 [ …4] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117012057" +"ListingId": "MC25130743" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T14:09:49Z" +"RFModificationTimestamp": "2025-06-12T16:35:50.129840+00:00" +"ListPrice": 475000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7676.0 +"LivingArea": 1788.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "3332 Shamrock Place, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.324245 +"Longitude": -120.454943 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Scott Oliver" +"ListOfficeName": "Concierge Real Estate Services" +"ListAgentMlsId": "MCOLIVSC" +"ListOfficeMlsId": "mc1198" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Charming North Merced Home in Wainwright Park Village. Welcome to this beautifully maintained 3-bedroom, 2-bathroom home nestled in the desirable Wainwright Park Village subdivision of North Merced. Perfectly positioned on a corner lot in a quiet, secluded area just off Brookdale Drive and near Rahilly Park, this property offers both privacy and convenience. Over the past eight years, the home has seen numerous thoughtful upgrades including a newer composition roof, modern appliances, hot water heater, and fresh interior and exterior paint. Step inside to discover a warm and inviting floor plan featuring a formal living room, cozy family room with a fireplace, and a remodeled kitchen that opens to a spacious dining area—ideal for entertaining or quiet family meals. French doors lead to a low-maintenance backyard complete with a gazebo and storage shed, offering the perfect spot for outdoor relaxation. The remodeled bathrooms and updated fixtures add a modern touch, while rich interior colors, beamed ceilings, and sculptured details provide character throughout the home. Additional highlights include a smart thermostat and garage door opener, an upgraded water softener and filtration system, interior laundry, and a thoughtfully designed walk-in pantry. Currently operating as a successful Airbnb, this home presents a great opportunity for both investors and owner-occupants. Don’t miss your chance to experience this charming North Merced gem—contact me today to schedule your private showing!" +"AccessibilityFeatures": "None" +"Appliances": "Dishwasher,Free-Standing Range,Disposal,Gas Oven,Gas Range,Gas Water Heater,Microwave,Refrigerator,Range Hood,Self Cleaning Oven,Water Softener,Vented Exhaust Fan,Water To Refrigerator,Water Purifier,Dryer,Washer" +"ArchitecturalStyle": "Ranch" +"AttachedGarageYN": true +"AttributionContact": "209-777-2635" +"BathroomsFull": 2 +"BuilderName": "Wainwright" +"CLIP": 5592780587 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Gutter(s),Storm Drain(s),Street Lights,Suburban,Sidewalks,Park" +"ConstructionMaterials": "Frame,Vertical Siding,Wood Siding" +"Contingency": "Any offers using an out of the area Lender or Mortgage Broker, must have a pre-approval from Cindy Vierra at Leader 1 Financial (209) 201-2463 or email cindyvierra@leader1.com." +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-11T23:18:52.359059+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 5 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "West" +"Directions": "East on Olive Ave, left on Parsons Ave, Left on Brookdale Drive, right on Shamrock Ave, left on Shamrock Place." +"Disclosures": "Covenants/Restrictions Disclosure,Easement(s),Flood Insurance Required,Flood Plain Disclosure,Incorporated,Rent Control" +"DoorFeatures": "French Doors,Panel Doors" +"Electric": "Electricity - On Property,220 Volts in Kitchen,220 Volts in Laundry,Standard" +"ElementarySchool": "Merced City" +"Elevation": 171 +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Lighting,Rain Gutters" +"Fencing": "Good Condition,Wood" +"FireplaceFeatures": "Decorative,Family Room,Raised Hearth,Wood Burning" +"FireplaceYN": true +"Flooring": "Carpet, Laminate, Tile, Wood" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Forced Air,Fireplace(s),Natural Gas,Wood" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Beamed Ceilings,Built-in Features,Ceiling Fan(s),Separate/Formal Dining Room,Open Floorplan,Pantry,Recessed Lighting,Storage,Dressing Area,Galley Kitchen,Walk-In Pantry" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Gas Dryer Hookup,Inside,Laundry Closet" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-354-4255" +"ListAgentEmail": "scott.reowarrior@gmail.com" +"ListAgentFirstName": "Scott" +"ListAgentKey": "17134484" +"ListAgentKeyNumeric": "17134484" +"ListAgentLastName": "Oliver" +"ListAgentOfficePhone": "310-200-2152" +"ListAgentStateLicense": "01335699" +"ListAgentURL": "www.conciergehomes.net" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "kori@conciergehomes.com" +"ListOfficeKey": "3282105" +"ListOfficeKeyNumeric": "3282105" +"ListOfficePhone": "310-200-2152" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-11" +"ListingKeyNumeric": 1117012057 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Corner Lot,Front Yard,Sprinklers In Rear,Sprinklers In Front,Lawn,Landscaped,Level,Near Park,Near Public Transit,Rectangular Lot,Sprinklers Timer,Sprinklers On Side,Sprinkler System,Sloped Up,Trees,Yard" +"LotSizeAcres": 0.1762 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7676.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-11T14:47:16Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merced City" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-11" +"OnMarketTimestamp": "2025-06-11T14:47:16Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-06-11T14:47:16Z" +"OriginalListPrice": 475000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374567418" +"OriginatingSystemSubName": "CRMLS_CRM" +"OtherStructures": "Gazebo, Shed(s)" +"ParcelNumber": "006150030000" +"ParkingFeatures": "Concrete,Direct Access,Door-Single,Driveway,Driveway Up Slope From Street,Garage,Garage Door Opener,Garage Faces Side" +"ParkingTotal": "4.0" +"PatioAndPorchFeatures": "Rear Porch,Concrete,Covered,Front Porch,Open,Patio,Porch" +"PhotosChangeTimestamp": "2025-06-11T22:10:40Z" +"PhotosCount": 35 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "1682" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RentControlYN": true +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition, Shingle" +"RoomType": "Center Hall,Entry/Foyer,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Pantry,Dining Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Scott" +"ShowingContactPhone": "209-777-2635" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117012057" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T14:47:16Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Shamrock" +"StreetNumber": "3332" +"StreetNumberNumeric": "3332" +"StreetSuffix": "Place" +"StructureType": "House" +"TaxLot": "25" +"UniversalPropertyId": "US-06047-N-006150030000-R-N" +"Utilities": "Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Underground Utilities,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"VirtualTourURLBranded": "https://youtu.be/c8OY-Lq Rx Rs" +"VirtualTourURLUnbranded": "https://youtu.be/3n WDSend Mrs" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,Screens" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Center Hall,Dressing Area,Entry,Family Room,Formal Entry,Galley Kitchen,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Separate Family Room,Walk-In Pantry",\n "EatingArea": "Dining Room,Separated",\n "RoomKitchenFeatures": "Kitchen Open to Family Room,Remodeled Kitchen,Utility sink,Walk-In Pantry",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub,Exhaust fan(s),Linen Closet/Storage,Privacy toilet door,Remodeled,Upgraded,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1117012057",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117012057')" +"CurrentPrice": 475000.0 +"provider_name": "CRMLS" +"RecordSignature": -566090178 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:006150030000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "360078360" +"OriginatingSystemListAgentMemberKey": "435138" +"Media": array:35 [ …35] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1116697744" +"ListingId": "MC25129796" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T14:00:26Z" +"RFModificationTimestamp": "2025-06-12T16:38:35.495068+00:00" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 12261.0 +"LivingArea": 1602.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "3032 Bedford Drive, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.316933 +"Longitude": -120.446963 +"YearBuilt": 1972 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jeff Lawry" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "MCLAWRJE" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "OH MY! Be prepared to be blessed! The owners have done everything that someone would want to do. This home is picture perfect with the perfect floor plan. As you approach you will be greeted by sharp curb appeal and a wonderful front porch perfect for your morning coffee. It keeps getting better as you enter the home. You will love the attention to detail from the lighting to the rest of the finishes. They are currently using one of the 4 bedrooms as a sitting room/den. They recently remodeled it to take full advantage of the space. The kitchen is very large and includes a moveable island, coffee bar, custom finishes as well as a ton of storage and a large dining area. The home is bright and shiny throughout. The owners have touched just about every sqft of this home. As I shared, it keeps getting better... The home sits on over a quarter acre and has a beautifully resurfaced pool and newer pool equipment. And, there is still plenty of room for so much more. This is a "have to" see! As you know, backyards like this are very rare in the city. Don't wait, start enjoying the pool now! Summer is here!" +"Appliances": "Dishwasher,Electric Range,Microwave" +"AttachedGarageYN": true +"AttributionContact": "209-261-8969" +"BathroomsFull": 2 +"CLIP": 9247512785 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Suburban, Sidewalks" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-11T15:28:49.522093+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 5 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "West" +"Directions": "From Mckee to Alexander, right at Bedford" +"DocumentsChangeTimestamp": "2025-06-11T07:45:52Z" +"DocumentsCount": 1 +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "front" +"FireplaceFeatures": "Electric,Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Ceiling Fan(s),Eat-in Kitchen,Open Floorplan,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "jeff@jefflawry.com" +"ListAgentFax": "209-722-8181" +"ListAgentFirstName": "Jeff" +"ListAgentKey": "17099765" +"ListAgentKeyNumeric": "17099765" +"ListAgentLastName": "Lawry" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "01310152" +"ListAgentURL": "www.Jeff Lawry.com" +"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-06-11" +"ListingKeyNumeric": 1116697744 +"ListingService": "Full Service" +"ListingTerms": "Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.2815 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 12261.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 4 +"MajorChangeTimestamp": "2025-06-11T07:33:37Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-11" +"OnMarketTimestamp": "2025-06-11T07:33:37Z" +"OriginalEntryTimestamp": "2025-06-11T07:33:37Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374563640" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "008220044000" +"ParkingFeatures": "Garage Faces Front" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Rear Porch,Covered,Front Porch" +"PhotosChangeTimestamp": "2025-06-11T14:54:44Z" +"PhotosCount": 50 +"PoolFeatures": "Gunite,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Negotiable" +"PostalCodePlus4": "2728" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom, Other" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1116697744" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T07:33:37Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Bedford" +"StreetNumber": "3032" +"StreetNumberNumeric": "3032" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "9" +"UniversalPropertyId": "US-06047-N-008220044000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,See Remarks",\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Kitchen Island",\n "RoomBathroomFeatures": "Remodeled",\n "AdminUpdateYN": "0",\n "ListingKey": "1116697744",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1116697744')" +"CurrentPrice": 425000.0 +"provider_name": "CRMLS" +"RecordSignature": -1017173224 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:008220044000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "435028" +"Media": array:50 [ …50] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117007497" +"ListingId": "MC25129518" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T13:54:07Z" +"RFModificationTimestamp": "2025-06-12T16:39:14.790851+00:00" +"ListPrice": 365000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 6430.0 +"LivingArea": 1287.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "402 La Mesa Street, Merced, California 95341" +"Coordinates": array:2 [ …2] +"Latitude": 37.282451 +"Longitude": -120.477684 +"YearBuilt": 1999 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Martin Villanueva" +"ListOfficeName": "Realty Executives Of Northern California" +"ListAgentMlsId": "MCVILLAN" +"ListOfficeMlsId": "mc188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Welcome to this beautiful updated 5-bedroom home, thoughtfully designed for comfort, function, and style. Step inside and discover the newer interior paint, elegant tile flooring throughout, and updated dual-pane windows that will make your home more efficient. The modern kitchen is a true highlight, featuring sleek granite countertops, a decorative tile backsplash, and the perfect color blend of cabinetry for a rich, contemporary look. Ceiling fans throughout the home to help keep your home cool. The bathroom includes a stylish new vanity with a matching mirror. \r\r\n The exterior boasts a beautiful landscaped front yard with palm trees and a brand new front yard fence with stylish side gates for added privacy and curb appeal. The large backyard patio porch is perfect for hosting family reunions or summer BBQs, with the added plus of a wide driveway for ample parking. Plus, enjoy the water softener system-great for your skin, appliances and peace of mind. \r\r\n This move-in-ready gem is waiting for its next proud owner, schedule your tour today! """ +"AccessibilityFeatures": "None" +"Appliances": "Disposal,Gas Oven,Gas Range" +"ArchitecturalStyle": "Traditional" +"AttachedGarageYN": true +"AttributionContact": "209-617-9184" +"BathroomsFull": 1 +"CLIP": 3920238023 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Storm Drain(s),Street Lights,Sidewalks" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-11T22:10:34.583532+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 5 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "West on "G" St., Left on Carmen Way, Right on La Mesa" +"DocumentsChangeTimestamp": "2025-06-12T05:50:38Z" +"DocumentsCount": 1 +"Electric": "220 Volts in Garage" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front Door" +"Fencing": "Wood" +"FireplaceFeatures": "None" +"Flooring": "Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Merced Union" +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Ceiling Fan(s),Eat-in Kitchen,Granite Counters,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-8500" +"ListAgentEmail": "mvillanueva209@gmail.com" +"ListAgentFax": "209-385-8505" +"ListAgentFirstName": "Martin" +"ListAgentKey": "17169029" +"ListAgentKeyNumeric": "17169029" +"ListAgentLastName": "Villanueva" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "01724831" +"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-11" +"ListingKeyNumeric": 1117007497 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA, Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Corner Lot,Sprinklers In Front" +"LotSizeAcres": 0.1476 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6430.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-11T12:52:09Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Tenant" +"OnMarketDate": "2025-06-11" +"OnMarketTimestamp": "2025-06-11T12:52:09Z" +"OriginalEntryTimestamp": "2025-06-11T12:52:09Z" +"OriginalListPrice": 365000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374566470" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "259210024000" +"ParkingFeatures": "Driveway" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Covered, Patio" +"PhotosChangeTimestamp": "2025-06-12T12:57:43Z" +"PhotosCount": 7 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "6973" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Bedroom" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117007497" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T12:52:09Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "La Mesa" +"StreetNumber": "402" +"StreetNumberNumeric": "402" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "62" +"UniversalPropertyId": "US-06047-N-259210024000-R-N" +"Utilities": "Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Public Records" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Granite Counters",\n "RoomBathroomFeatures": "Shower in Tub",\n "AdminUpdateYN": "0",\n "ListingKey": "1117007497",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117007497')" +"CurrentPrice": 365000.0 +"provider_name": "CRMLS" +"RecordSignature": 1734606783 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:259210024000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "108753" +"OriginatingSystemListAgentMemberKey": "434177" +"Media": array:7 [ …7] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115075222" +"ListingId": "MC25120851" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T13:42:35Z" +"RFModificationTimestamp": "2025-06-13T14:15:40.682675+00:00" +"ListPrice": 1200000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 43650.0 +"LivingArea": 3740.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "1901 E Sorrento Court, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.345401 +"Longitude": -120.448318 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Francisco Cuevas" +"ListOfficeName": "Next Home Central Valley" +"ListAgentMlsId": "MCCUEVFR" +"ListOfficeMlsId": "mc1319" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Stunning Custom Home on One Acre in North Merced Welcome to this beautifully designed custom home, built in 2022 and nestled on a quiet cul-de-sac in highly sought-after North Merced. Set on a full acre of beautifully landscaped grounds with a desert feel, this spacious 5-bedroom, 3-bathroom home gives the perfect blend of luxury, functionality, and comfort. Step inside to a a grand 12-foot entry that sets the tone for the rest of the open- concept home featuring 10-foot ceilings throughout. The heart of the home is the impressive chef's kitchen, complete with a large island that seats 10, sleek quartz countertops, a full suite of KitchenAid appliances, a butler's pantry, and an oversized walk-in pantry. Abundant cabinetry and thoughtful storage solutions are found throughout the home. The spacious layout includes a 16' x 21' 5th bedroom with a large walk-in closet, currently used as a media room, providing flexibility for entertainment, work, or guests. The luxurious primary suite is a true retreat, featuring dual vanities, a soaking tub, an expansive shower with dual shower heads, and a custom walk-in closet." +"Appliances": "Electric Oven,Ice Maker,Microwave,Refrigerator,Tankless Water Heater" +"AttachedGarageYN": true +"AttributionContact": "209-678-6638" +"BathroomsFull": 3 +"CLIP": 5161644407 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Storm Drain(s),Street Lights,Sidewalks" +"ContractStatusChangeDate": "2025-05-26" +"Cooling": "Central Air,Dual" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-09T01:16:18.746165+00:00" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head down Sorrento Court" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "None" +"FireplaceFeatures": "Electric,Living Room,Outside" +"FireplaceYN": true +"Flooring": "Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central,Heat Pump" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Chair Rail,Open Floorplan,Pantry,Quartz Counters,Stone Counters,Bedroom on Main Level,Walk-In Pantry,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Electric Dryer Hookup,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentEmail": "fcuevasre@gmail.com" +"ListAgentFirstName": "Francisco" +"ListAgentKey": "20523454" +"ListAgentKeyNumeric": "20523454" +"ListAgentLastName": "Cuevas" +"ListAgentOfficePhone": "209-620-8007" +"ListAgentStateLicense": "02064774" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "fcuevasre@gmail.com" +"ListOfficeKey": "4514048" +"ListOfficeKeyNumeric": "4514048" +"ListOfficePhone": "209-620-8007" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-26" +"ListingKeyNumeric": 1115075222 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, Submit" +"LivingAreaSource": "Owner" +"LotFeatures": "0-1 Unit/Acre,Corner Lot,Cul-De-Sac" +"LotSizeAcres": 1.0021 +"LotSizeSource": "Owner" +"LotSizeSquareFeet": 43650.0 +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 5 +"MajorChangeTimestamp": "2025-06-08T16:32:47Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-08" +"OnMarketTimestamp": "2025-06-08T16:32:47Z" +"OriginalEntryTimestamp": "2025-06-08T16:32:47Z" +"OriginalListPrice": 1200000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374552001" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "060870008000" +"ParkingTotal": "3.0" +"PatioAndPorchFeatures": "Open, Patio" +"PhotosChangeTimestamp": "2025-06-09T01:12:42Z" +"PhotosCount": 44 +"PoolFeatures": "None" +"PostalCodePlus4": "9310" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bonus Room,Bedroom,Family Room,Great Room,Kitchen,Laundry,Living Room,Media Room,Office,Other,Pantry" +"SecurityFeatures": "Carbon Monoxide Detector(s),Fire Detection System,Fire Sprinkler System,Smoke Detector(s)" +"Sewer": "Septic Type Unknown" +"ShowingContactName": "Chad" +"ShowingContactPhone": "(209) 230-6695" +"ShowingContactType": "Agent, Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115075222" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-08T16:32:47Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "Sorrento" +"StreetNumber": "1901" +"StreetNumberNumeric": "1901" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "5" +"UniversalPropertyId": "US-06047-N-060870008000-R-N" +"Utilities": "Propane,See Remarks" +"View": "Meadow" +"ViewYN": true +"WaterSource": "Private" +"WindowFeatures": "Custom Covering(s)" +"YearBuiltSource": "Owner" +"Zoning": "A-R" +"CustomFields": """ {\n "RoomType": "Bonus Room,Family Room,Great Room,Home Theatre,Kitchen,Laundry,Living Room,Main Floor Bedroom,Office,See Remarks,Walk-In Closet,Walk-In Pantry",\n "RoomKitchenFeatures": "Kitchen Island,Self-closing cabinet doors,Self-closing drawers",\n "RoomBathroomFeatures": "Bathtub,Bidet,Shower,Double sinks in bath(s),Double Sinks in Primary Bath,Dual shower heads (or Multiple),Exhaust fan(s),Jetted Tub,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1115075222",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115075222')" +"CurrentPrice": 1200000.0 +"provider_name": "CRMLS" +"RecordSignature": -2021372064 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:060870008000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "368090741" +"OriginatingSystemListAgentMemberKey": "368090873" +"Media": array:44 [ …44] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114758224" +"ListingId": "MC25121783" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-12T07:10:46Z" +"RFModificationTimestamp": "2025-06-13T14:49:06.940797+00:00" +"ListPrice": 430848.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 4625.0 +"LivingArea": 1435.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "4717 Irma Drive, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.3567 +"Longitude": -120.483296 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Montana Gardner" +"ListOfficeName": "Advanced Market Realty, Inc" +"ListAgentMlsId": "MCGARDMO" +"ListOfficeMlsId": "mc1010" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Spacious Living: With 3 bedrooms and 2 bathrooms. There's ample room for your family to spread out and enjoy. \r\r\n Gourmet Kitchen: Cook up culinary delights in the modern kitchen equipped with plenty of counter space. \r\r\n Two-Car Garage: Keep your vehicles safe and sound in the attached 2-car garage.\r\r\n New Construction: Enjoy the benefits of a brand-new home with all the lates features and finishes.\r\r\n Proximity to UC Merced: Perfect for faculty, staff, or students, this home is conveniently located near UC Merced, making your daily commute a breeze.\r\r\n Leased Solar.\r\r\n Under construction. Estimate completion in August. """ +"Appliances": "Dishwasher,Electric Range,Disposal,Microwave,Water Heater" +"AttachedGarageYN": true +"AttributionContact": "209-585-9612" +"BathroomsFull": 2 +"CLIP": 1143197499 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Storm Drain(s),Street Lights,Suburban,Sidewalks" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-31T20:07:25.918391+00:00" +"CumulativeDaysOnMarket": 11 +"DaysOnMarket": 11 +"DaysOnMarketReplication": 11 +"DaysOnMarketReplicationDate": "2025-06-12" +"Directions": "Sales Office: 4604 Irma Drive Merced, CA 95348. North on M Street, Left of Arrow Wood Drive, Right on Freemark Ave, Left on Irma Drive." +"Disclosures": "Covenants/Restrictions Disclosure,Home Warranty" +"Electric": "220 Volts in Laundry" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "New Condition" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Laminate, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Eat-in Kitchen" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-826-6200" +"ListAgentEmail": "montana@stonefieldhome.com" +"ListAgentFirstName": "Montana" +"ListAgentKey": "22897474" +"ListAgentKeyNumeric": "22897474" +"ListAgentLastName": "Gardner" +"ListAgentOfficePhone": "209-826-7200" +"ListAgentStateLicense": "02206341" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "Dmitri@ranchwood.com" +"ListOfficeFax": "209-826-6900" +"ListOfficeKey": "3280358" +"ListOfficeKeyNumeric": "3280358" +"ListOfficePhone": "209-826-7200" +"ListingAgreement": "Seller Reserved" +"ListingContractDate": "2025-05-31" +"ListingKeyNumeric": 1114758224 +"ListingService": "Entry Only" +"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,Fannie Mae,Freddie Mac,Government Loan,VA Loan" +"LivingAreaSource": "Owner" +"LotFeatures": "Sprinklers In Front,Sprinklers Timer,Sprinkler System" +"LotSizeAcres": 0.1062 +"LotSizeSource": "Owner" +"LotSizeSquareFeet": 4625.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-11T18:03:38Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NewConstructionYN": true +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-11" +"OffMarketTimestamp": "2025-06-11T18:03:38Z" +"OnMarketDate": "2025-05-31" +"OnMarketTimestamp": "2025-05-31T12:40:55Z" +"OriginalEntryTimestamp": "2025-05-31T12:40:55Z" +"OriginalListPrice": 430848.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374507911" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "224340020000" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "None" +"PhotosChangeTimestamp": "2025-05-31T20:04:41Z" +"PhotosCount": 2 +"PoolFeatures": "None" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-11" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom" +"SecurityFeatures": "Carbon Monoxide Detector(s),Fire Detection System,Fire Sprinkler System,Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114758224" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T18:03:38Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Irma" +"StreetNumber": "4717" +"StreetNumberNumeric": "4717" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "79" +"UniversalPropertyId": "US-06047-N-224340020000-R-N" +"Utilities": "Electricity Connected,Natural Gas Not Available,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Insulated Windows,Screens" +"YearBuiltSource": "Owner" +"CustomFields": """ {\n "RoomType": "Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom",\n "EatingArea": "In Kitchen,In Living Room",\n "RoomKitchenFeatures": "Granite Counters",\n "RoomBathroomFeatures": "Shower in Tub,Exhaust fan(s),Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1114758224",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114758224')" +"CurrentPrice": 430848.0 +"provider_name": "CRMLS" +"RecordSignature": 1434045599 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:224340020000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "132426" +"OriginatingSystemListAgentMemberKey": "372276736" +"Media": array:2 [ …2] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112245600" +"ListingId": "MC25092702" +"PropertyType": "Residential Income" +"PropertySubType": "Mixed Use" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T07:00:32Z" +"RFModificationTimestamp": "2025-06-12T08:17:56.593155+00:00" +"ListPrice": 800000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 7500.0 +"LivingArea": 0 +"BuildingAreaTotal": 4000.0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "1250 I Street, Merced, California 95341" +"Coordinates": array:2 [ …2] +"Latitude": 37.295117 +"Longitude": -120.481274 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Peter Huff" +"ListOfficeName": "Huff Real Estate" +"ListAgentMlsId": "MCHUFFPE" +"ListOfficeMlsId": "mc987" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Well maintained 5 unit apartment complex with leased laundry onsite. Fully occupied, currently units rent for $1300 a month. The exterior stucco and exterior paint and all Central air units, water heaters and appliances have been replaced within the last 5 years. All units have been remodeled in the last 5 years. This is a good opportunity for any investor." +"AttributionContact": "209-261-0592" +"BuildingAreaUnits": "Square Feet" +"CLIP": 1006528080 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Suburban" +"ContractStatusChangeDate": "2025-04-27" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-04-28T03:05:53.196815+00:00" +"CumulativeDaysOnMarket": 45 +"DaysOnMarket": 49 +"DaysOnMarketReplication": 45 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "I st." +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "None" +"GrossScheduledIncome": 78000.0 +"Heating": "Central" +"HeatingYN": true +"InsuranceExpense": 5900.0 +"InteriorFeatures": "All Bedrooms Up" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-261-0592" +"ListAgentEmail": "huffrealestate@gmail.com" +"ListAgentFax": "209-723-3322" +"ListAgentFirstName": "Peter" +"ListAgentKey": "17151438" +"ListAgentKeyNumeric": "17151438" +"ListAgentLastName": "Huff" +"ListAgentOfficePhone": "209-261-0592" +"ListAgentStateLicense": "01454712" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "huffrealestate@gmail.com" +"ListOfficeKey": "3280121" +"ListOfficeKeyNumeric": "3280121" +"ListOfficePhone": "209-261-0592" +"ListOfficeURL": "huffrealtors.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-27" +"ListingKeyNumeric": 1112245600 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA" +"LotFeatures": "Corner Lot" +"LotSizeAcres": 0.1722 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7500.0 +"MajorChangeTimestamp": "2025-04-27T19:38:15Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NetOperatingIncome": 58758.0 +"NumberOfBuildings": 1 +"NumberOfSeparateElectricMeters": 5 +"NumberOfSeparateGasMeters": 5 +"NumberOfSeparateWaterMeters": 1 +"NumberOfUnitsTotal": "5" +"OnMarketDate": "2025-04-27" +"OnMarketTimestamp": "2025-04-27T19:38:15Z" +"OpenParkingSpaces": "6.0" +"OperatingExpense": "19242.0" +"OriginalEntryTimestamp": "2025-04-27T19:38:15Z" +"OriginalListPrice": 800000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374312704" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "031341001000" +"ParkingFeatures": "Concrete,On Street,Uncovered" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-04-28T02:56:38Z" +"PhotosCount": 11 +"PoolFeatures": "None" +"PostalCodePlus4": "6125" +"ProfessionalManagementExpense": 6240.0 +"PropertySubTypeAdditional": "Mixed Use" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112245600" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-27T19:38:15Z" +"StoriesTotal": "2" +"StreetName": "I" +"StreetNumber": "1250" +"StreetNumberNumeric": "1250" +"StreetSuffix": "Street" +"TaxBlock": "248" +"TaxLot": "15" +"TrashExpense": 2000.0 +"UniversalPropertyId": "US-06047-N-031341001000-R-N" +"WaterSewerExpense": 3040.0 +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"Zoning": "R-4" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112245600"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112245600')" +"CurrentPrice": 800000.0 +"provider_name": "CRMLS" +"RecordSignature": -2001281529 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:031341001000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "128182" +"OriginatingSystemListAgentMemberKey": "435623" +"Media": array:11 [ …11] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1090178223" +"ListingId": "MC24214935" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2025-06-12T06:48:11Z" +"RFModificationTimestamp": "2025-06-12T07:53:39.251513+00:00" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 2100.0 +"LivingArea": 1890.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "282 Montage Drive, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.361352 +"Longitude": -120.470685 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Stephanie Stine" +"ListOfficeName": "Choice Valley Real Estate" +"ListAgentMlsId": "MCSTINST" +"ListOfficeMlsId": "mc1371" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Gated Community Located just 2 miles to UC Merced and right next to El Capitan High School! \r\r\n The perfect home for families, students or traveling nurses\r\r\n \r\r\n **Mountain Top II**\r\r\n This stunning home features:\r\r\n - 5 Bedrooms (2 Master Suites) \r\r\n - 4 Full Bathrooms\r\r\n - Large kitchen with a Breakfast Island\r\r\n - Main floor bedroom and full bath\r\r\n \r\r\n \r\r\n Upstairs:\r\r\n - Huge master bedroom suite\r\r\n - Second Master Bedroom\r\r\n - 2 additional bedrooms with walk-in closets\r\r\n - Linen closet and laundry room\r\r\n \r\r\n \r\r\n Energy Efficiency:\r\r\n - Dual AC unit\r\r\n \r\r\n \r\r\n Storage:\r\r\n - Two-car tandem garage\r\r\n - Wrap-around hall closet\r\r\n \r\r\n \r\r\n Community Perks:\r\r\n - Gated community\r\r\n - Basketball court\r\r\n - Playground \r\r\n - Landscape and exterior pest control maintained by the HOA for low maintenance living\r\r\n \r\r\n \r\r\n Additional Information:\r\r\n - Price includes leased solar\r\r\n \r\r\n \r\r\n **Visit Us:**\r\r\n - On site Sales office located at 154 Montage Drive """ +"Appliances": "Dishwasher,ENERGY STAR Qualified Appliances,ENERGY STAR Qualified Water Heater,Free-Standing Range,Disposal,High Efficiency Water Heater,Microwave,Water Heater" +"ArchitecturalStyle": "Craftsman" +"AssociationAmenities": "Controlled Access,Sport Court,Maintenance Grounds,Management,Maintenance Front Yard,Playground" +"AssociationFee": "155.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Paseo Community Association" +"AssociationPhone": "209-308-9000" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "661-972-0785" +"BackOnMarketDate": "2024-12-20" +"BathroomsFull": 4 +"BuilderModel": "Mountain TopII" +"BuilderName": "Choice Valley Homes" +"BuyerAgentAOR": "MRMLS" +"BuyerAgentEmail": "noemail@email.com" +"BuyerAgentFirstName": "MARILYN" +"BuyerAgentFullName": "MARILYN SULL" +"BuyerAgentKey": "17113600" +"BuyerAgentKeyNumeric": "17113600" +"BuyerAgentLastName": "SULL" +"BuyerAgentMlsId": "NONMEMBER" +"BuyerAgentStateLicense": "01899037" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "MRMLS" +"BuyerOfficeEmail": "NONE@CRMLS.ORG" +"BuyerOfficeKey": "3287957" +"BuyerOfficeKeyNumeric": "3287957" +"BuyerOfficeMlsId": "NONMEMBERMRML" +"BuyerOfficeName": "NONMEMBER MRML" +"BuyerOfficePhone": "909-859-2040" +"BuyerOfficeURL": "https://go.crmls.org/" +"CLIP": 2512540180 +"CloseDate": "2025-06-11" +"ClosePrice": 524500.0 +"CommonInterest": "Planned Development" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Park,Storm Drain(s),Street Lights,Sidewalks,Gated" +"ConstructionMaterials": "Stucco,Wood Siding" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air,Dual,ENERGY STAR Qualified Equipment" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-17T14:54:00.823441+00:00" +"CumulativeDaysOnMarket": 158 +"DaysOnMarket": 158 +"DaysOnMarketReplication": 158 +"DaysOnMarketReplicationDate": "2025-06-12" +"Directions": "From North G Street turn left on to Bellevue Rd, turn right on Barclay, turn right into subdivision in from of El Capital High School" +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure,Home Warranty" +"DoorFeatures": "Panel Doors" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "Excellent Condition,Wood" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"GreenEnergyEfficient": "Construction,Doors,HVAC,Insulation,Roof,Thermostat,Windows,Appliances,Water Heater" +"GreenEnergyGeneration": "Solar" +"Heating": "Central,ENERGY STAR Qualified Equipment,High Efficiency" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Granite Counters,High Ceilings,Stone Counters,Recessed Lighting,Bedroom on Main Level,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Inside,Laundry Closet,Upper Level" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentEmail": "stine_stephanie@yahoo.com" +"ListAgentFirstName": "Stephanie" +"ListAgentKey": "22369945" +"ListAgentKeyNumeric": "22369945" +"ListAgentLastName": "Stine" +"ListAgentOfficePhone": "661-877-7045" +"ListAgentStateLicense": "02189834" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "choicevalleyre@gmail.com" +"ListOfficeKey": "5243687" +"ListOfficeKeyNumeric": "5243687" +"ListOfficePhone": "661-877-7045" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-04-01" +"ListingKeyNumeric": 1090178223 +"ListingService": "Full Service" +"ListingTerms": "Contract" +"LotDimensionsSource": "Builder" +"LotFeatures": "Front Yard,Sprinklers In Front,Landscaped,Paved" +"LotSizeAcres": 0.0482 +"LotSizeSource": "Builder" +"LotSizeSquareFeet": 2100.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-11T18:42:22Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NewConstructionYN": true +"NumberOfUnitsInCommunity": 142 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-05-01" +"OffMarketTimestamp": "2025-05-31T11:36:41Z" +"OnMarketDate": "2024-10-16" +"OnMarketTimestamp": "2024-12-20T09:47:15Z" +"OriginalEntryTimestamp": "2024-10-16T14:25:18Z" +"OriginalListPrice": 509000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373496009" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "170044004" +"ParkingFeatures": "Garage,Garage Faces Rear,On Street" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete" +"PhotosChangeTimestamp": "2024-12-05T10:58:23Z" +"PhotosCount": 15 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 509000.0 +"PriceChangeTimestamp": "2025-06-04T10:55:52Z" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-05-01" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Bedroom,Kitchen,Laundry,Living Room,Other" +"SecurityFeatures": "Fire Sprinkler System,Gated Community,Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1090178223" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T18:42:22Z" +"Stories": "1" +"StoriesTotal": "2" +"StreetName": "Montage" +"StreetNumber": "282" +"StreetNumberNumeric": "282" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "31" +"UniversalPropertyId": "US-06047-N-170044004-R-N" +"Utilities": "Cable Available,Electricity Connected,Phone Available,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,ENERGY STAR Qualified Windows" +"YearBuiltSource": "Builder" +"Zoning": "RP-D" +"CustomFields": """ {\n "RoomType": "Kitchen,Laundry,Living Room,Main Floor Bedroom,Walk-In Closet",\n "EatingArea": "Breakfast Counter / Bar",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island",\n "RoomBathroomFeatures": "Shower in Tub,Double sinks in bath(s),Double Sinks in Primary Bath,Exhaust fan(s),Privacy toilet door,Stone Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1090178223",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1090178223')" +"CurrentPrice": 524500.0 +"provider_name": "CRMLS" +"RecordSignature": 897253124 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:170044004" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "372036369" +"OriginatingSystemBuyerOfficeKey": "364178833" +"OriginatingSystemListAgentMemberKey": "371677646" +"OriginatingSystemBuyerAgentMemberKey": "397825" +"Media": array:15 [ …15] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1090237604" +"ListingId": "MC24215977" +"PropertyType": "Residential Income" +"PropertySubType": "Apartment" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-12T06:48:11Z" +"RFModificationTimestamp": "2025-06-12T07:52:42.404605+00:00" +"ListPrice": 635000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 7500.0 +"LivingArea": 0 +"BuildingAreaTotal": 4522.0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "244 W 19th Street, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.301844 +"Longitude": -120.478831 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Seth Medefind" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "mcmedese" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Check out this investment opportunity in downtown Merced! Live in one unit and rent out the other three or rent out all four! Three of the four units are 2 bedroom and 2.5 bath. These units have the living room, kitchen and half bath located downstairs and two bedrooms and two full bathrooms upstairs. The one additional unit is a single story 2 bedrooms and 1 bath. Each unit has its own parking spot, central air condition as well as central heating and a fireplace! Units will come equipped with an oven and dishwasher. The high occupancy rate and high return on investment makes this property a great addition for investors. Located near the revitalized and growing downtown Merced, this property is sure to see its value continue to appreciate. Don’t miss out on adding this fourplex to your portfolio!" +"Appliances": "Dishwasher,Gas Oven" +"AttributionContact": "209-676-0889" +"BackOnMarketDate": "2025-06-11" +"BuildingAreaUnits": "Square Feet" +"CLIP": 9258814557 +"CommonInterest": "Community Apartment" +"CommonWalls": "2+ Common Walls" +"CommunityFeatures": "Urban" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-03T20:43:20.616109+00:00" +"CumulativeDaysOnMarket": 125 +"DaysOnMarket": 129 +"DaysOnMarketReplication": 125 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From G Street turn West on 19th Street. Property is on the left." +"DocumentsChangeTimestamp": "2024-10-17T16:17:31Z" +"DocumentsCount": 1 +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Rain Gutters" +"FireplaceFeatures": "Wood Burning" +"FireplaceYN": true +"GrossIncome": 31560.0 +"GrossScheduledIncome": 69000.0 +"Heating": "Central" +"HeatingYN": true +"InsuranceExpense": 3600.0 +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "None" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "smedefind@londonproperties.com" +"ListAgentFirstName": "Seth" +"ListAgentKey": "18823914" +"ListAgentKeyNumeric": "18823914" +"ListAgentLastName": "Medefind" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "02141768" +"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": "2024-10-17" +"ListingKeyNumeric": 1090237604 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,1031 Exchange,Submit" +"LotFeatures": "Rectangular Lot" +"LotSizeAcres": 0.1722 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 7500.0 +"MajorChangeTimestamp": "2025-06-11T19:26:55Z" +"MajorChangeType": "Active Under Contract" +"MlsStatus": "Active Under Contract" +"NetOperatingIncome": 57474.0 +"NewTaxesExpense": 2526.0 +"NumberOfBuildings": 1 +"NumberOfSeparateElectricMeters": 4 +"NumberOfSeparateGasMeters": 4 +"NumberOfSeparateWaterMeters": 1 +"NumberOfUnitsTotal": "4" +"OffMarketDate": "2025-05-08" +"OffMarketTimestamp": "2025-05-15T10:45:30Z" +"OnMarketDate": "2024-10-17" +"OnMarketTimestamp": "2025-06-11T19:26:55Z" +"OpenParkingSpaces": "4.0" +"OperatingExpense": "11526.0" +"OriginalEntryTimestamp": "2024-10-17T16:02:38Z" +"OriginalListPrice": 625000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373504603" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "031074003000" +"ParkingFeatures": "Asphalt" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-10-17T23:21:36Z" +"PhotosCount": 3 +"PoolFeatures": "None" +"PostalCodePlus4": "4953" +"PreviousListPrice": 625000.0 +"PriceChangeTimestamp": "2025-05-03T13:09:26Z" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Apartment" +"PurchaseContractDate": "2025-05-08" +"RoadFrontageType": "Alley,City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1090237604" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T19:26:55Z" +"StoriesTotal": "2" +"StreetDirPrefix": "W" +"StreetName": "19th" +"StreetNumber": "244" +"StreetNumberNumeric": "244" +"StreetSuffix": "Street" +"TaxBlock": "148" +"TaxLot": "6" +"TotalActualRent": 2630.0 +"UniversalPropertyId": "US-06047-N-031074003000-R-N" +"Utilities": "Natural Gas Available,Sewer Connected,Water Connected" +"View": "Courtyard" +"ViewYN": true +"WaterSewerExpense": 5400.0 +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"Zoning": "R-4" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1090237604"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1090237604')" +"CurrentPrice": 635000.0 +"provider_name": "CRMLS" +"RecordSignature": -728451007 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:031074003000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "365551320" +"Media": array:3 [ …3] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114813400" +"ListingId": "MC25123014" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-12T00:51:58Z" +"RFModificationTimestamp": "2025-06-12T21:36:50.129750+00:00" +"ListPrice": 349000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 8341.0 +"LivingArea": 1708.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "592 Kathryn Court, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.327897 +"Longitude": -120.477993 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Richard Peraino" +"ListOfficeName": "Realty Executives Of Northern California" +"ListAgentMlsId": "MCPERARI" +"ListOfficeMlsId": "mc188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Charming Fixer-Upper with Pool – 3 Bed, 2 Bath\r\r\n Opportunity awaits with this diamond in the rough! This spacious 3-bedroom, 2-bathroom home offers plenty of potential for the right buyer to make it their own. Situated in a quiet neighborhood, the property features a large backyard with a sparkling pool, perfect for entertaining or enjoying sunny days.\r\r\n Inside, you’ll find generous living spaces with lots of natural light, awaiting your personal touch. The kitchen and bathrooms are ready for a modern update, while the living room, family room and bedrooms have ample space for you to create your ideal home. With some TLC and creativity, this house could easily be transformed into your dream oasis.\r\r\n The backyard pool area is a standout feature, offering a private retreat where you can relax and unwind. Whether you're planning a full renovation or just a few updates, this fixer-upper is a great investment with room to grow.\r\r\n Bring your vision and make this home shine again! """ +"Appliances": "Dishwasher,Electric Range,Vented Exhaust Fan" +"ArchitecturalStyle": "Traditional" +"AttachedGarageYN": true +"AttributionContact": "209-489-1299" +"BathroomsFull": 2 +"CLIP": 7342170774 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Curbs,Dog Park,Golf,Lake,Park,Street Lights,Sidewalks,Water Sports" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-08" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-03T10:28:11.602436+00:00" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"DaysOnMarketReplication": 6 +"DaysOnMarketReplicationDate": "2025-06-12" +"Directions": "North on M Street Right on Buena Vista Left on Wathen Left on Kathryn Ct" +"Electric": "220 Volts in Garage" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Wood" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Laminate" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Separate/Formal Dining Room,Tile Counters,All Bedrooms Down,Bedroom on Main Level,Entrance Foyer,Main Level Primary" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-205-1337" +"ListAgentEmail": "richpsoldit@gmail.com" +"ListAgentFax": "209-385-8505" +"ListAgentFirstName": "Richard" +"ListAgentKey": "21976320" +"ListAgentKeyNumeric": "21976320" +"ListAgentLastName": "Peraino" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "02190549" +"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-27" +"ListingKeyNumeric": 1114813400 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Back Yard,Cul-De-Sac,Front Yard,Garden,Lawn,Landscaped" +"LotSizeAcres": 0.1915 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8341.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-11T15:44:18Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-06-08" +"OffMarketTimestamp": "2025-06-11T15:44:18Z" +"OnMarketDate": "2025-06-02" +"OnMarketTimestamp": "2025-06-02T14:43:24Z" +"OriginalEntryTimestamp": "2025-06-02T14:43:24Z" +"OriginalListPrice": 349000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374513640" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "236120001000" +"ParkingFeatures": "Concrete,Door-Multi,Direct Access,Driveway,Driveway Up Slope From Street,Garage Faces Front,Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Covered" +"PhotosChangeTimestamp": "2025-06-02T22:22:40Z" +"PhotosCount": 1 +"PoolFeatures": "Gunite,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "2820" +"PropertyCondition": "Fixer,Repairs Cosmetic" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-08" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"RoomType": "Bedroom,Family Room,Foyer,Kitchen,Living Room,Primary Bathroom,Primary Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Richard Peraino" +"ShowingContactPhone": "2094891299" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114813400" +"SpaFeatures": "Gunite,In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T15:44:18Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Kathryn" +"StreetNumber": "592" +"StreetNumberNumeric": "592" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "21" +"UniversalPropertyId": "US-06047-N-236120001000-R-N" +"Utilities": "Natural Gas Available,Natural Gas Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Public Records" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Foyer,Kitchen,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom",\n "EatingArea": "Dining Room",\n "RoomKitchenFeatures": "Kitchen Open to Family Room,Tile Counters",\n "RoomBathroomFeatures": "Shower,Shower in Tub",\n "AdminUpdateYN": "0",\n "ListingKey": "1114813400",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114813400')" +"CurrentPrice": 349000.0 +"provider_name": "CRMLS" +"RecordSignature": 1028629410 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:236120001000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "108753" +"OriginatingSystemListAgentMemberKey": "370807713" +"Media": array:1 [ …1] } ] +success: true +page_size: 10 +page_count: 161 +count: 1609 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5054 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5033 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115112343" +"ListingId": "CV25129183" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T20:39:02Z" +"RFModificationTimestamp": "2025-06-16T20:49:27.957349+00:00" +"ListPrice": 1075000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 11138.0 +"LivingArea": 2097.0 +"BuildingAreaTotal": 0 +"City": "Phillips Ranch" +"PostalCode": "91766" +"UnparsedAddress": "40 Country Wood Drive, Phillips Ranch, California 91766" +"Coordinates": array:2 [ …2] +"Latitude": 34.030923 +"Longitude": -117.77515 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Crystal Ellis" +"ListOfficeName": "Suarez Realty Group" +"ListAgentMlsId": "CV37136" +"ListOfficeMlsId": "52135" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Stunning Single-Family Home in Highly Desirable Philips Ranch!!! Welcome to this absolutely gorgeous single-family home located in the sought-after community of Philips Ranch. Nestled in a peaceful neighborhood, this charming residence offers excellent curb appeal and ample street parking. A captivating double-door entry leads you into a bright and spacious interior featuring soaring vaulted ceilings and an elegant iron staircase railing. The high ceilings continue through the formal living and dining areas, enhancing the home’s open and airy ambiance. The open-concept kitchen seamlessly connects to the inviting family room, complete with a cozy fireplace—perfect for both everyday living and entertaining. This well-designed home offers 4 generously sized bedrooms and 2.5 bathrooms, providing comfort and flexibility for any lifestyle. Situated on an expansive 11,135 sq. ft. lot, the property features a large backyard filled with mature fruit trees and includes additional detached studio units (nearly completed ADU), offering potential for extended family living or rental income. The oversized two-car garage includes a convenient laundry area. Residents enjoy access to award-winning schools shared with North Diamond Bar, including Ranch Hills Elementary, Lorbeer Middle School, and Diamond Ranch High School. The home is also conveniently located near shopping centers, parks, walking trails, greenbelts, and offers quick freeway access." +"ActivationDate": "2025-06-16" +"AttachedGarageYN": true +"AttributionContact": "626-327-4873" +"BathroomsFull": 3 +"CLIP": 6289893404 +"CoListAgentAOR": "West San Gabriel Valley" +"CoListAgentEmail": "sandrah6177@yahoo.com" +"CoListAgentFirstName": "YIN" +"CoListAgentFullName": "YIN HUANG" +"CoListAgentKey": "22016527" +"CoListAgentKeyNumeric": "22016527" +"CoListAgentLastName": "HUANG" +"CoListAgentMlsId": "WS84435" +"CoListAgentOfficePhone": "626-888-9808" +"CoListAgentStateLicense": "01294072" +"CoListOfficeAOR": "West San Gabriel Valley" +"CoListOfficeEmail": "Homes By Brian@gmail.com" +"CoListOfficeFax": "626-986-5345" +"CoListOfficeKey": "3287766" +"CoListOfficeKeyNumeric": "3287766" +"CoListOfficeMlsId": "20652" +"CoListOfficeName": "Pinnacle Real Estate Group" +"CoListOfficePhone": "626-888-9808" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Park, Sidewalks" +"ContractStatusChangeDate": "2025-06-05" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-06-16T20:49:08.621753+00:00" +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "North of Village Loop Road" +"ElementarySchool": "Ranch Hills" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Ground Level w/ Step" +"Fencing": "Block,Wrought Iron" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Diamond Ranch" +"HighSchoolDistrict": "Pomona Unified" +"InteriorFeatures": "All Bedrooms Up" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Electric Dryer Hookup,Gas Dryer Hookup" +"Levels": "Two" +"ListAgentAOR": "Citrus Valley" +"ListAgentEmail": "c.ellis@ellisattorneys.com" +"ListAgentFirstName": "Crystal" +"ListAgentKey": "17304395" +"ListAgentKeyNumeric": "17304395" +"ListAgentLastName": "Ellis" +"ListAgentOfficePhone": "909-224-4758" +"ListAgentStateLicense": "01979565" +"ListOfficeAOR": "Citrus Valley" +"ListOfficeEmail": "javier@suarezrealtygroup.com" +"ListOfficeKey": "3282751" +"ListOfficeKeyNumeric": "3282751" +"ListOfficePhone": "909-224-4758" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-05" +"ListingKeyNumeric": 1115112343 +"ListingService": "Full Service" +"ListingTerms": "Cash" +"LivingAreaSource": "Assessor" +"LotFeatures": "Landscaped,Paved,Sprinklers On Side,Sprinkler System,Trees,Yard" +"LotSizeAcres": 0.2557 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 11138.0 +"MLSAreaMajor": "687 - Pomona" +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-06-16T13:17:06Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Lorbeer" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-16" +"OnMarketTimestamp": "2025-06-16T13:17:06Z" +"OriginalEntryTimestamp": "2025-06-09T16:10:01Z" +"OriginalListPrice": 1075000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374555499" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "8711010023" +"ParkingFeatures": "Direct Access,Driveway,Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-16T20:39:40Z" +"PhotosCount": 52 +"PoolFeatures": "None" +"PostalCodePlus4": "4818" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactName": "Crystal Ellis" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115112343" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-06-16" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-16T13:17:06Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Country Wood" +"StreetNumber": "40" +"StreetNumberNumeric": "40" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "31" +"UniversalPropertyId": "US-06037-N-8711010023-R-N" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "POPRD*" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up",\n "AdminUpdateYN": "0",\n "ListingKey": "1115112343"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115112343')" +"CurrentPrice": 1075000.0 +"provider_name": "CRMLS" +"short_address": "Phillips Ranch, California 91766, US" +"RecordSignature": -512750588 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:8711010023" +"CountrySubdivision": "06037" +"PreviousStandardStatus": "Coming Soon" +"OriginatingSystemListOfficeKey": "361600409" +"OriginatingSystemCoListOfficeKey": "92843" +"OriginatingSystemListAgentMemberKey": "9963798" +"OriginatingSystemCoListAgentMemberKey": "370943901" +"Media": array:52 [ …52] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5425 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114227324" +"ListingId": "SR25107300" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-16T20:39:02Z" +"RFModificationTimestamp": "2025-06-16T20:49:54.516753+00:00" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 59474.0 +"LivingArea": 1190.0 +"BuildingAreaTotal": 0 +"City": "Culver City" +"PostalCode": "90230" +"UnparsedAddress": "5674 Windsor Way 109, Culver City, California 90230" +"Coordinates": array:2 [ …2] +"Latitude": 33.98488 +"Longitude": -118.383023 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nery Lucio-Cabrera" +"ListOfficeName": "Luxury Collective" +"ListAgentMlsId": "SR207071036" +"ListOfficeMlsId": "SR0261900" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Updated 2 bed, 2 bath condo in the heart of Culver City. This ground-floor unit features a modern kitchen with updated cabinetry, countertops, and appliances, plus fully renovated bathrooms for a clean, contemporary look. Enjoy a private backyard patio — perfect for relaxing or entertaining. Spacious bedrooms, including a primary suite with en-suite bath and ample closet space. Gated community with secure parking and well-maintained amenities. Located just minutes from Westfield Culver City, local shops, dining, parks, and top Culver City schools. Turnkey comfort in a prime location." +"Appliances": "Dishwasher,Electric Oven,Electric Range" +"AssociationAmenities": "Controlled Access,Other,Pool" +"AssociationFee": "425.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "French Quarter" +"AssociationPhone": "(310) 559-4700" +"AssociationYN": true +"AttributionContact": "323-682-2806" +"BackOnMarketDate": "2025-05-19" +"BathroomsFull": 2 +"CLIP": 2335613608 +"CoListAgentAOR": "Southland" +"CoListAgentDirectPhone": "818-577-5257" +"CoListAgentEmail": "steve@stevejulian.com" +"CoListAgentFirstName": "Steve" +"CoListAgentFullName": "Steve Julian" +"CoListAgentKey": "17250288" +"CoListAgentKeyNumeric": "17250288" +"CoListAgentLastName": "Julian" +"CoListAgentMlsId": "SR163044254" +"CoListAgentOfficePhone": "424-395-4841" +"CoListAgentStateLicense": "01909119" +"CoListAgentURL": "www.stevejulian.com" +"CoListOfficeAOR": "Southland" +"CoListOfficeEmail": "sandro@luxurycollectivere.com" +"CoListOfficeKey": "5580943" +"CoListOfficeKeyNumeric": "5580943" +"CoListOfficeMlsId": "SR0261900" +"CoListOfficeName": "Luxury Collective" +"CoListOfficePhone": "424-395-4841" +"CommonInterest": "Condominium" +"CommonWalls": "1 Common Wall" +"CommunityFeatures": "Urban, Pool" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-05-19T19:52:38.711761+00:00" +"CumulativeDaysOnMarket": 25 +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-16" +"Directions": "Fox Hills between Canterbury and Buckingham" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front Foor" +"FireplaceFeatures": "None" +"Flooring": "Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "None" +"HighSchoolDistrict": "Culver City Unified" +"InteriorFeatures": "Breakfast Area,Open Floorplan" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Common Area" +"Levels": "Three Or More" +"ListAgentAOR": "Southland" +"ListAgentEmail": "info@nerylucio.com" +"ListAgentFirstName": "Nery" +"ListAgentKey": "21762194" +"ListAgentKeyNumeric": "21762194" +"ListAgentLastName": "Lucio-Cabrera" +"ListAgentOfficePhone": "424-395-4841" +"ListAgentStateLicense": "02195967" +"ListOfficeAOR": "Southland" +"ListOfficeEmail": "sandro@luxurycollectivere.com" +"ListOfficeKey": "5580943" +"ListOfficeKeyNumeric": "5580943" +"ListOfficePhone": "424-395-4841" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1114227324 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Public Records" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 1.3653 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 59474.0 +"MLSAreaMajor": "C28 - Culver City" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-06-16T13:17:40Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsInCommunity": 82 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-13" +"OffMarketTimestamp": "2025-06-16T13:17:40Z" +"OnMarketDate": "2025-05-16" +"OnMarketTimestamp": "2025-05-19T11:07:18Z" +"OriginalEntryTimestamp": "2025-05-16T15:27:23Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374429342" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "4134009029" +"ParkingFeatures": "Assigned" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Patio" +"PhotosChangeTimestamp": "2025-05-18T18:33:40Z" +"PhotosCount": 30 +"PoolFeatures": "Community, Association" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Condominium" +"PurchaseContractDate": "2025-06-13" +"RoomType": "Living Room" +"SecurityFeatures": "Security Gate" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114227324" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-16T13:17:40Z" +"StoriesTotal": "1" +"StreetName": "Windsor" +"StreetNumber": "5674" +"StreetNumberNumeric": "5674" +"StreetSuffix": "Way" +"StructureType": "House" +"TaxLot": "3437" +"UnitNumber": "109" +"UniversalPropertyId": "US-06037-N-4134009029-R-N" +"View": "None" +"VirtualTourURLBranded": "https://www.zillow.com/view-imx/6e8c1a7b-0309-4a93-ae5d-4c89dce47640?set Attribution=mls&wl=true&initial View Type=pano&utm_source=dashboard" +"VirtualTourURLUnbranded": "https://www.zillow.com/view-imx/6e8c1a7b-0309-4a93-ae5d-4c89dce47640?set Attribution=mls&wl=true&initial View Type=pano&utm_source=dashboard" +"VirtualTourURLUnbranded2": "https://www.zillow.com/view-imx/6e8c1a7b-0309-4a93-ae5d-4c89dce47640?set Attribution=mls&wl=true&initial View Type=pano&utm_source=dashboard" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "Living Room",\n "EatingArea": "Breakfast Nook",\n "RoomBathroomFeatures": "Bathtub,Shower,Double Sinks in Primary Bath",\n "AdminUpdateYN": "0",\n "ListingKey": "1114227324",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114227324')" +"CurrentPrice": 599900.0 +"provider_name": "CRMLS" +"RecordSignature": 118397565 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:4134009029" +"CountrySubdivision": "06037" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "373127082" +"OriginatingSystemCoListOfficeKey": "373127082" +"OriginatingSystemListAgentMemberKey": "370592972" +"OriginatingSystemCoListAgentMemberKey": "567505" +"Media": array:30 [ …30] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5428 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1110369284" +"ListingId": "P1-21554" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T20:39:02Z" +"RFModificationTimestamp": "2025-06-16T20:49:51.275039+00:00" +"ListPrice": 3575000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 6.0 +"LotSizeArea": 13525.0 +"LivingArea": 4046.0 +"BuildingAreaTotal": 0 +"City": "Pasadena" +"PostalCode": "91105" +"UnparsedAddress": "190 San Miguel Road, Pasadena, California 91105" +"Coordinates": array:2 [ …2] +"Latitude": 34.138882 +"Longitude": -118.173428 +"YearBuilt": 1937 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Heather Sanderson" +"ListOfficeName": "The Agency" +"ListAgentMlsId": "p18649" +"ListOfficeMlsId": "PF11287" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "TIMELESS ELEGANCE AT 190 SAN MIGUEL ROAD, SAN RAFAEL FLATSNestled in the highly sought-after San Rafael Flats, 190 San Miguel Road is a stunning Cape Cod-style residence that radiates timeless elegance and tranquility. Elevated above the street, the residence not only has privacy but is surrounded by meticulously manicured gardens and offers breathtaking treetop views, creating an even more peaceful retreat.Inside, sunlight pours through expansive windows, highlighting the home's sophisticated details--rich hardwood floors, custom built-ins, and intricate moldings that showcase its classic architectural charm. The interior space features an elegant living room, a formal dining room, and a bright sunroom, a quaint breakfast nook ideal for both relaxation and entertaining. A downstairs bedroom or optional office adds versatility to accommodate your lifestyle.The main residence includes five bedrooms and four bathrooms. Additionally the home includes an inspirationally designed guest house. The guest house is a fully permitted ADU with a separate address and is equipped with a top of the line kitchen and bathroom that you won't want to depart from. This added bonus provides ample living space while effortlessly combining charm, functionality, and tranquility. Nestled in a tree-lined neighborhood rich in history, it is surrounded by the architectural elegance of Pasadena's grand estates, offering a timeless and sophisticated setting.A rare opportunity to own a truly exceptional home in one of Pasadena's most prestigious enclaves!" +"Appliances": "Barbecue,Double Oven,Dishwasher,Gas Range,Water Heater" +"ArchitecturalStyle": "Cape Cod,Cottage,Ranch,Traditional" +"Basement": "Unfinished" +"BasementYN": true +"BathroomsFull": 2 +"BathroomsThreeQuarter": 2 +"CLIP": 7307412016 +"CoListAgentAOR": "Pasadena-Foothills" +"CoListAgentDirectPhone": "(626) 833-9856" +"CoListAgentEmail": "spencer.sanderson@theagencyre.com" +"CoListAgentFirstName": "Spencer" +"CoListAgentFullName": "Spencer Sanderson" +"CoListAgentKey": "22014051" +"CoListAgentKeyNumeric": "22014051" +"CoListAgentLastName": "Sanderson" +"CoListAgentMlsId": "p24969" +"CoListAgentOfficePhone": "(626) 803-2000" +"CoListAgentStateLicense": "02137092" +"CoListOfficeAOR": "Pasadena-Foothills" +"CoListOfficeEmail": "broker.ca@theagencyre.com" +"CoListOfficeFax": "(424) 230-3740" +"CoListOfficeKey": "3262361" +"CoListOfficeKeyNumeric": "3262361" +"CoListOfficeMlsId": "PF11287" +"CoListOfficeName": "The Agency" +"CoListOfficePhone": "(626) 803-2000" +"CoListOfficeURL": "http://https://www.theagencyre.com/" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Park, Suburban, Sidewalks, Urban" +"ContractStatusChangeDate": "2025-02-26" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-04-03T00:04:38.983445+00:00" +"CumulativeDaysOnMarket": 75 +"DaysOnMarket": 75 +"DaysOnMarketReplication": 75 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "West" +"Directions": "South of Colorado Blvd, North of Nithsdale" +"DocumentsChangeTimestamp": "2025-04-02T14:38:35Z" +"DoorFeatures": "French Doors" +"Electric": "220 Volts" +"Exclusions": "- Living room: tapestry and hardware, chandelier above piano- Sun room: chandelier- Dining room: chandelier, drapes and hardware- Breakfast nook: chandelier, wallpaper panels- Maid's quarters: wallpaper panel, chandelier, drapery, bathroom mirror- Powder room: mirror- Entry: wallpaper panel- Upstairs landing: chandelier, wallpaper panel- Guest bathroom: chandelier, mirror, sconces- Guest bedroom (SE): drapery, horse sconces- Guest bedroom (NE): crown chandelier- Primary bedroom: sconces, chandelier- Primary bathroom: window treatment- Living room: tapestry and hardware, chandelier above piano- Sun room: chandelier- Dining room: chandelier, drapes and hardware- Breakfast nook: chandelier, wallpaper panels- Maid's quarters: wallpaper panel, chandelier, drapery, bathroom mirror- Powder room: mirror- Entry: wallpaper panel- Upstairs landing: chandelier, wallpaper panel- Guest bathroom: chandelier, mirror, sconces- Guest bedroom (SE): drapery, horse sconces" +"Fencing": "Wood" +"FireplaceFeatures": "Gas,Primary Bedroom" +"FireplaceYN": true +"Flooring": "Wood" +"FoundationDetails": "Raised" +"Heating": "Central" +"HeatingYN": true +"InteriorFeatures": "Breakfast Area,Separate/Formal Dining Room,Bedroom on Main Level,Dressing Area" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "Multi/Split" +"ListAgentAOR": "Pasadena-Foothills" +"ListAgentDirectPhone": "(818) 415-7868" +"ListAgentEmail": "heather.sanderson@theagencyre.com" +"ListAgentFirstName": "Heather" +"ListAgentKey": "17288008" +"ListAgentKeyNumeric": "17288008" +"ListAgentLastName": "Sanderson" +"ListAgentOfficePhone": "(626) 803-2000" +"ListAgentStateLicense": "01881548" +"ListAgentURL": "http://www.heathersanderson.com" +"ListOfficeAOR": "Pasadena-Foothills" +"ListOfficeEmail": "broker.ca@theagencyre.com" +"ListOfficeFax": "(424) 230-3740" +"ListOfficeKey": "3262361" +"ListOfficeKeyNumeric": "3262361" +"ListOfficePhone": "(626) 803-2000" +"ListOfficeURL": "http://https://www.theagencyre.com/" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-02-26" +"ListingKeyNumeric": 1110369284 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LivingAreaSource": "Measured" +"LotFeatures": "Garden" +"LotSizeAcres": 0.3105 +"LotSizeSquareFeet": 13525.0 +"MLSAreaMajor": "647 - Pasadena (SW)" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 2 +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-04-01" +"OnMarketTimestamp": "2025-04-02T08:13:50Z" +"OriginalEntryTimestamp": "2025-04-02T14:38:30Z" +"OriginalListPrice": 3825000.0 +"OriginatingSystemID": "CRF" +"OriginatingSystemKey": "374176952" +"OriginatingSystemSubName": "CRMLS_CRF" +"ParcelNumber": "5715008031" +"ParkName": "San Rafael Park" +"ParkingFeatures": "Driveway" +"PatioAndPorchFeatures": "Brick,Covered,Front Porch,Patio,Porch" +"PhotosChangeTimestamp": "2025-04-03T01:11:41Z" +"PhotosCount": 74 +"PoolFeatures": "None" +"PostalCodePlus4": "1454" +"PreviousListPrice": 3825000.0 +"PriceChangeTimestamp": "2025-06-13T14:27:25Z" +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom,Entry/Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Sunroom,Dining Room" +"SecurityFeatures": "Security System,Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Heather Sanderson" +"ShowingContactPhone": "818-415-7868" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1110369284" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-01T17:00:00Z" +"StoriesTotal": "2" +"StreetName": "San Miguel" +"StreetNumber": "190" +"StreetNumberNumeric": "190" +"StreetSuffix": "Road" +"StructureType": "House" +"TaxLot": "19" +"UniversalPropertyId": "US-06037-N-5715008031-R-N" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "Dressing Area,Primary Bathroom,Main Floor Bedroom,Laundry,Kitchen,Sun,Primary Bedroom,Living Room,Entry",\n "EatingArea": "Breakfast Nook,Dining Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1110369284"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1110369284')" +"CurrentPrice": 3575000.0 +"provider_name": "CRMLS" +"RecordSignature": -460226156 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:5715008031" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "359502153" +"OriginatingSystemCoListOfficeKey": "359502153" +"OriginatingSystemListAgentMemberKey": "132251629" +"OriginatingSystemCoListAgentMemberKey": "370932739" +"Media": array:74 [ …74] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5427 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114415620" +"ListingId": "41098522" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T20:39:02Z" +"RFModificationTimestamp": "2025-06-16T20:49:54.126459+00:00" +"ListPrice": 1695000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 25900.0 +"LivingArea": 2536.0 +"BuildingAreaTotal": 0 +"City": "Orinda" +"PostalCode": "94563" +"UnparsedAddress": "589 Tahos Road, Orinda, California 94563" +"Coordinates": array:2 [ …2] +"Latitude": 37.88382057 +"Longitude": -122.16502704 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "David Gunderman" +"ListOfficeName": "KW Advisors East Bay" +"ListAgentMlsId": "CCBE-149520297" +"ListOfficeMlsId": "CCBE-SAEK01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Natural beauty, privacy and serenity abound in this elegant 4BD/2.5BA Mid-century in Orinda. Set on over ½ of an acre, this 2536 SQFT home was designed by Richard Danskin, a renowned Orinda architect. Timeless architectural details integrate nature with the home including vaulted and beamed redwood ceilings, skylights, and walls of windows that showcase the peaceful surroundings. In the great room, sliding doors open onto the expansive wrap-around deck, providing seamless indoor/outdoor living that overlooks an oak grove. With an abundance of natural light from the windows adjoining the kitchen and dining room, enjoy hillside views as the backdrop to your daily life. The adjacent den is a place to relax with family and friends in front of a fireplace. The upper floor features two bedrooms - one with an ensuite bath and the other is flexible as a guest room, office, or playroom. The floor is complete with a powder room and plenty of storage. Downstairs find two more large sunny bedrooms, a full bath, a balcony, laundry, and more storage. The two-car garage and nearby BART make for an easy commute, and down the road, enjoy top K-12 schools, beautiful Lafayette reservoir with its trails and boating, plus shopping, dining, and amenities in downtown Orinda and Lafayette." +"Appliances": "Gas Water Heater,Dryer,Washer" +"ArchitecturalStyle": "Modern, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 1008208799 +"CoListAgentAOR": "Oakland" +"CoListAgentDirectPhone": "808-224-8654" +"CoListAgentEmail": "eastbayericw@gmail.com" +"CoListAgentFirstName": "Eric" +"CoListAgentFullName": "Eric Wong" +"CoListAgentLastName": "Wong" +"CoListAgentMlsId": "CCBE-R02106847" +"CoListAgentOfficePhone": "510-775-1079" +"CoListAgentStateLicense": "02106847" +"CoListOfficeAOR": "Oakland" +"CoListOfficeMlsId": "CCBE-OBOKWOAK" +"CoListOfficeName": "KW Advisors East Bay" +"CoListOfficePhone": "510-775-1079" +"ConstructionMaterials": "Wood Siding" +"ContractStatusChangeDate": "2025-05-22" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Contra Costa" +"CreationDate": "2025-05-22T18:03:57.830822+00:00" +"CumulativeDaysOnMarket": 25 +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "St Stephens to Tahos Cross Street: Oak Ridge Ln." +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile, Vinyl, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "Acalanes" +"InteriorFeatures": "Breakfast Bar,Eat-in Kitchen" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentAOR": "Bay East" +"ListAgentDirectPhone": "510-205-4369" +"ListAgentEmail": "David@thegundermangroup.com" +"ListAgentFirstName": "David" +"ListAgentKey": "21739551" +"ListAgentKeyNumeric": "21739551" +"ListAgentLastName": "Gunderman" +"ListAgentOfficePhone": "510-775-1079" +"ListAgentStateLicense": "01313613" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "eddiemoranrealtor@gmail.com" +"ListOfficeFax": "510-474-1638" +"ListOfficeKey": "5109508" +"ListOfficeKeyNumeric": "5109508" +"ListOfficePhone": "510-775-1079" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-22" +"ListingKeyNumeric": 1114415620 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "Back Yard,Sloped Down,Yard" +"LotSizeAcres": 0.5946 +"LotSizeSource": "Measured" +"LotSizeSquareFeet": 25900.0 +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-22" +"OnMarketTimestamp": "2025-05-22T03:28:49Z" +"OriginalEntryTimestamp": "2025-05-22T10:15:41Z" +"OriginalListPrice": 1695000.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374455204" +"OriginatingSystemSubName": "CRMLS_CCBE" +"OtherStructures": "Storage" +"ParcelNumber": "2684900075" +"ParkingFeatures": "Garage,Off Street" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Deck, Patio" +"PhotosChangeTimestamp": "2025-06-12T06:04:42Z" +"PhotosCount": 60 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 1695000.0 +"PriceChangeTimestamp": "2025-05-21T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"RoomType": "Bonus Room,Den,Family Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Eric Wong" +"ShowingContactPhone": "808.224.8654" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114415620" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-28T17:00:00Z" +"Stories": "2" +"StreetName": "TAHOS ROAD" +"StreetNumber": "589" +"StreetNumberNumeric": "589" +"SubdivisionName": "GLORIETTA" +"UniversalPropertyId": "US-06013-N-2684900075-R-N" +"View": "Hills, Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://thegundermangroup.com/property/589-tahos-road-orinda/" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=v LE4ik TKZQE" +"CustomFields": """ {\n "RoomType": "Bonus Room,Den,Family Room",\n "EatingArea": "Breakfast Counter / Bar,In Kitchen",\n "RoomKitchenFeatures": "Stone Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Shower in Tub,Tile Counters,Upgraded",\n "AdminUpdateYN": "0",\n "ListingKey": "1114415620"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114415620')" +"CurrentPrice": 1695000.0 +"provider_name": "CRMLS" +"RecordSignature": -1450189878 +"UniversalParcelId": "urn:reso:upi:2.0:US:06013:2684900075" +"CountrySubdivision": "06013" +"OriginatingSystemListOfficeKey": "370205646" +"OriginatingSystemListAgentMemberKey": "370234616" +"Media": array:60 [ …60] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5429 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117339596" +"ListingId": "SB25131939" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T20:39:02Z" +"RFModificationTimestamp": "2025-06-16T20:49:50.850675+00:00" +"ListPrice": 1350000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7212.0 +"LivingArea": 2108.0 +"BuildingAreaTotal": 0 +"City": "Torrance" +"PostalCode": "90503" +"UnparsedAddress": "3564 Michelle Drive, Torrance, California 90503" +"Coordinates": array:2 [ …2] +"Latitude": 33.846913 +"Longitude": -118.349298 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tiffany McGuinness" +"ListOfficeName": "Estate Properties" +"ListAgentMlsId": "sbmcgutif" +"ListOfficeMlsId": "S4164" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Opportunity knocks in one of Torrance’s most sought-after neighborhoods! On the market for the first time in 39 years, this 4-bedroom, 2-bathroom gem is full of potential and ready for your personal touch. Tucked away in a charming pocket of Torrance known for its quiet, cul-de-sac-lined streets, this home sits on an expansive 7,200+ sq ft lot and offers a flexible layout with plenty of space to reimagine. The inviting living room features a cozy gas fireplace and sliding glass doors that open to a private outdoor retreat. Enjoy gatherings in your dedicated dining area, which flows into the functional kitchen, complete with a charming breakfast bar and an adjacent seating area or bonus family room. The versatile floor plan includes two bedrooms and one full bathroom on the main level—ideal for guests, a home office, or multigenerational living. Upstairs, you'll find two more sunlit bedrooms and a spacious bathroom with a dual vanity. The generously-sized backyard offers a blank canvas framed by mature privacy hedges—ready to be transformed into the entertainer’s paradise you’ve been dreaming of. You’ll love the convenience of a two-car garage with direct access, a laundry room with a utility sink, and ample guest parking. All of this in a prime location: zoned for award-winning West Torrance schools, just a short walk to the highly regarded Delthorne Park, one mile from Del Amo Fashion Center, and close to top-tier dining, shopping, and entertainment. Don’t miss this incredible opportunity to create your forever home in the heart of Torrance!" +"AttachedGarageYN": true +"AttributionContact": "3105257653" +"BathroomsFull": 2 +"CLIP": 3937763521 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Sidewalks" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-06-13T21:08:30.849271+00:00" +"CumulativeDaysOnMarket": 3 +"DaysOnMarket": 3 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head east on Del Amo Blvd, turn right onto Madison St, turn right onto Michelle Dr" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Street, Front door" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Torrance Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "Two" +"ListAgentAOR": "South Bay" +"ListAgentEmail": "tiffany@leveluprealtyllc.com" +"ListAgentFirstName": "Tiffany" +"ListAgentKey": "17001504" +"ListAgentKeyNumeric": "17001504" +"ListAgentLastName": "Mc Guinness" +"ListAgentOfficePhone": "310-378-9889" +"ListAgentStateLicense": "01947654" +"ListAgentURL": "www.livingsouthbayla.com" +"ListOfficeAOR": "South Bay" +"ListOfficeFax": "310-378-2745" +"ListOfficeKey": "3198390" +"ListOfficeKeyNumeric": "3198390" +"ListOfficePhone": "310-378-9889" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-13" +"ListingKeyNumeric": 1117339596 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard" +"LotSizeAcres": 0.1656 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7212.0 +"MLSAreaMajor": "126 - Central Torrance" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-06-13T08:28:00Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-13" +"OnMarketTimestamp": "2025-06-13T08:28:00Z" +"OriginalEntryTimestamp": "2025-06-13T08:28:00Z" +"OriginalListPrice": 1350000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374579161" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "7524004052" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-16T20:39:40Z" …37 } ] +success: true +page_size: 5 +page_count: 135485 +count: 677424 +after_key: "" } ] ]
