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: 9da359ce465c1b5969942ca2a73d32549fab65edd698fe98ac9d19423014bffa" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4882 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117314733" +"ListingId": "MC25132146" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T22:55:24Z" +"RFModificationTimestamp": "2025-06-12T23:52:14.510497+00:00" +"ListPrice": 150000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 9615.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "997 Gazelle Court, Merced, California 95340" +"Coordinates": array:2 [ 0 => -120.46023 1 => 37.330147 ] +"Latitude": 37.330147 +"Longitude": -120.46023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tino Garza" +"ListOfficeName": "Realty Executives Of Northern California" +"ListAgentMlsId": "MCGARZTI" +"ListOfficeMlsId": "mc188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Perfect corner lot for your opportunity to build the home of your dreams. The lot is over 9,000 square feet with all utilities available and ready. The lot is close to 1) UC Merced: 2) Lake Yosemite: 3) Merced Golf and Country Club. Property is NOT IN A FLOOD ZONE and has street lights, curb and gutters." +"AttributionContact": "209-261-4694" +"CLIP": 7987434466 +"CommonInterest": "None" +"CommunityFeatures": "Curbs,Gutter(s),Street Lights" +"ContractStatusChangeDate": "2025-06-12" +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-12T23:44:34.626582+00:00" +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Yosemite to Paulson to Gazelle Ct." +"DistanceToWaterComments": "Available" +"ElevationUnits": "Feet" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-8500" +"ListAgentEmail": "tinog66@hotmail.com" +"ListAgentFax": "209-385-8505" +"ListAgentFirstName": "Tino" +"ListAgentKey": "17158116" +"ListAgentKeyNumeric": "17158116" +"ListAgentLastName": "Garza" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "01419859" +"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-12" +"ListingKeyNumeric": 1117314733 +"ListingService": "Full Service" +"ListingTerms": "Cash" +"LotFeatures": "Corner Lot" +"LotSizeAcres": 0.2207 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 9615.0 +"MajorChangeTimestamp": "2025-06-12T12:27:16Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T12:27:16Z" +"OriginalEntryTimestamp": "2025-06-12T12:27:16Z" +"OriginalListPrice": 150000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374575372" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "006504021000" +"PhotosChangeTimestamp": "2025-06-12T22:57:45Z" +"PhotosCount": 4 +"PostalCodePlus4": "0773" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117314733" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T12:27:16Z" +"StreetName": "Gazelle" +"StreetNumber": "997" +"StreetNumberNumeric": "997" +"StreetSuffix": "Court" +"TaxLot": "1" +"UniversalPropertyId": "US-06047-N-006504021000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"Zoning": "R-1-6" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1117314733"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117314733')" +"CurrentPrice": 150000.0 +"provider_name": "CRMLS" +"short_address": "Merced, California 95340, US" +"RecordSignature": 88434257 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:006504021000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "108753" +"OriginatingSystemListAgentMemberKey": "435384" +"Media": array:4 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1100752543" +"ListingId": "MC24201859" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-12T21:58:31Z" +"RFModificationTimestamp": "2025-06-13T02:17:16.949867+00:00" +"ListPrice": 541581.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 5589.0 +"LivingArea": 2207.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "840 Jovan Court, Merced, California 95348" +"Coordinates": array:2 [ 0 => -120.484427 1 => 37.357149 ] +"Latitude": 37.357149 +"Longitude": -120.484427 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Montana Gardner" +"ListOfficeName": "Advanced Market Realty, Inc" +"ListAgentMlsId": "MCGARDMO" +"ListOfficeMlsId": "mc1010" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Spacious Living: With 4 bedrooms, 3 bathrooms and a Loft. 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. """ +"Appliances": "Dishwasher,Electric Oven,Electric Range,Electric Water Heater,Disposal,Microwave" +"AttachedGarageYN": true +"AttributionContact": "209-585-9612" +"BackOnMarketDate": "2025-03-03" +"BathroomsFull": 3 +"CLIP": 1148257698 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Storm Drain(s),Street Lights,Sidewalks" +"ConstructionMaterials": "Stone Veneer,Stucco" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-12-26T21:26:48.845375+00:00" +"CumulativeDaysOnMarket": 168 +"DaysOnMarket": 168 +"DaysOnMarketReplication": 168 +"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" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "New Condition" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Eat-in Kitchen,Bedroom on Main Level,Loft,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-826-6200" +"ListAgentEmail": "montana@stonefieldhome.com" +"ListAgentFirstName": "Montana" +"ListAgentKey": "22897474" +"ListAgentKeyNumeric": "22897474" +"ListAgentLastName": "Gardner" +"ListAgentOfficePhone": "209-826-6200" +"ListAgentStateLicense": "02206341" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "Dmitri@ranchwood.com" +"ListOfficeFax": "209-826-6900" +"ListOfficeKey": "3280358" +"ListOfficeKeyNumeric": "3280358" +"ListOfficePhone": "209-826-6200" +"ListingAgreement": "Seller Reserved" +"ListingContractDate": "2024-09-01" +"ListingKeyNumeric": 1100752543 +"ListingService": "Entry Only" +"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,Fannie Mae,Freddie Mac,Government Loan,VA Loan" +"LivingAreaSource": "Owner" +"LotFeatures": "Cul-De-Sac,Drip Irrigation/Bubblers,Sprinklers In Front" +"LotSizeAcres": 0.1283 +"LotSizeSource": "Owner" +"LotSizeSquareFeet": 5589.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T14:35:19Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NewConstructionYN": true +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-12" +"OffMarketTimestamp": "2025-06-12T14:35:19Z" +"OnMarketDate": "2024-12-26" +"OnMarketTimestamp": "2025-03-03T10:38:52Z" +"OriginalEntryTimestamp": "2024-12-26T12:12:18Z" +"OriginalListPrice": 587239.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373734636" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "224340005000" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "None" +"PhotosChangeTimestamp": "2025-05-26T00:52:39Z" +"PhotosCount": 22 +"PoolFeatures": "None" +"PreviousListPrice": 561581.0 +"PriceChangeTimestamp": "2025-05-29T10:43:20Z" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-12" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Spanish Tile" +"RoomType": "Bedroom,Kitchen,Laundry,Loft,Living Room,Primary Bathroom,Primary Bedroom,Other" +"SecurityFeatures": "Carbon Monoxide Detector(s),Fire Sprinkler System,Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1100752543" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T14:35:19Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Jovan" +"StreetNumber": "840" +"StreetNumberNumeric": "840" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "64" +"UniversalPropertyId": "US-06047-N-224340005000-R-N" +"Utilities": "Electricity Connected,Natural Gas Not Available,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Shutters" +"YearBuiltSource": "Owner" +"CustomFields": """ {\n "RoomType": "Kitchen,Laundry,Living Room,Loft,Main Floor Bedroom,Primary Bathroom,Primary Bedroom,Walk-In Closet",\n "EatingArea": "In Kitchen,In Living Room",\n "RoomKitchenFeatures": "Granite Counters",\n "RoomBathroomFeatures": "Bathtub,Shower in Tub,Exhaust fan(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1100752543",\n "DPResourceYN": "1",\n "SellerConsiderConcessionYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1100752543')" +"CurrentPrice": 541581.0 +"provider_name": "CRMLS" +"RecordSignature": -1560974180 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:224340005000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "132426" +"OriginatingSystemListAgentMemberKey": "372276736" +"Media": array:22 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114689512" +"ListingId": "MC25119213" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T21:22:44Z" +"RFModificationTimestamp": "2025-06-12T21:41:22.292250+00:00" +"ListPrice": 525000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 6127.0 +"LivingArea": 2100.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "1833 La Quinta Court, Merced, California 95340" +"Coordinates": array:2 [ 0 => -120.449687 1 => 37.327986 ] +"Latitude": 37.327986 +"Longitude": -120.449687 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mary Camper" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "MCcampma" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this stunning 4-bedroom, 2.5-bath home in the desirable Silverado neighborhood! With 2,100 sq ft of living space, this 2-story beauty offers both comfort and style. The freshly painted exterior and large front porch create a warm, inviting curb appeal. Step inside to soaring ceilings and large windows that fill the spacious living room with natural light. The chef’s kitchen features quartz countertops, a large kitchen island, and an abundance of natural light—perfect for entertaining. The primary bedroom is a relaxing retreat, complete with an en-suite bath, walk-in closet, and plenty of sunlight. A convenient half bath is located on the ground floor, and the home includes a smart home thermostat for modern living. Enjoy year-round comfort with central heating and cooling powered by an owned solar system. Experience serene outdoor living under the backyard pergola surrounded by mature landscaping. Close proximity to Bob Carpenter Park, top schools, shopping, and restaurants. Don't miss this opportunity!" +"Appliances": "Dishwasher,Disposal,Gas Range,Gas Water Heater,Microwave,Vented Exhaust Fan,Water To Refrigerator" +"AttachedGarageYN": true +"AttributionContact": "209-761-2813" +"BathroomsFull": 2 +"CLIP": 3154015306 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Gutter(s),Street Lights,Sidewalks" +"ConstructionMaterials": "Stucco,Wood Siding" +"Contingency": "Sale in contingent on the sellers finding a replacement property." +"ContractStatusChangeDate": "2025-05-28" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-30T02:13:34.959631+00:00" +"CumulativeDaysOnMarket": 14 +"DaysOnMarket": 17 +"DaysOnMarketReplication": 14 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "South" +"Directions": "East on Olive Ave, left at Parsons, right at Silverado, right at St. Andrews Dr, left at La Quinta Ct" +"DocumentsChangeTimestamp": "2025-05-29T17:29:42Z" +"DocumentsCount": 1 +"DoorFeatures": "Sliding Doors" +"Electric": "Electricity - On Property,220 Volts in Laundry,Photovoltaics Seller Owned" +"ElementarySchool": "Merced City" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "front door" +"ExteriorFeatures": "Lighting,Rain Gutters" +"Fencing": "Average Condition,Wood" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Laminate, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Crown Molding,Eat-in Kitchen,High Ceilings,Quartz Counters,Recessed Lighting,Storage,Tile Counters,All Bedrooms Up,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-761-2813" +"ListAgentEmail": "marywithlondon@gmail.com" +"ListAgentFax": "209-722-8181" +"ListAgentFirstName": "Mary" +"ListAgentKey": "17103939" +"ListAgentKeyNumeric": "17103939" +"ListAgentLastName": "Camper" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "01870330" +"ListAgentURL": "www.marycamper.com" +"ListAgentVoiceMail": "209-761-2813" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "greg@londonproperties.com" +"ListOfficeFax": "209-722-8181" +"ListOfficeKey": "3278096" +"ListOfficeKeyNumeric": "3278096" +"ListOfficePhone": "209-725-2100" +"ListingAgreement": "Seller Reserved" +"ListingContractDate": "2025-05-28" +"ListingKeyNumeric": 1114689512 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Cul-De-Sac,Front Yard,Sprinklers In Front,Lawn,Landscaped,Sprinkler System,Street Level,Walkstreet" +"LotSizeAcres": 0.1407 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6127.0 +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-05-29T17:20:21Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Merced City" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-29" +"OnMarketTimestamp": "2025-05-29T17:20:21Z" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2025-05-29T17:20:21Z" +"OriginalListPrice": 525000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374496414" +"OriginatingSystemSubName": "CRMLS_CRM" +"OtherStructures": "Gazebo, Shed(s)" +"ParcelNumber": "008360036000" +"ParkingFeatures": "Concrete,Driveway Level,Door-Single,Driveway,Garage Faces Front,Garage,Garage Door Opener" +"ParkingTotal": "5.0" +"PatioAndPorchFeatures": "Concrete,Front Porch,Patio" +"PhotosChangeTimestamp": "2025-05-30T00:37:42Z" +"PhotosCount": 55 +"PoolFeatures": "None" +"Possession": "Negotiable" +"PostalCodePlus4": "0757" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Tile" +"RoomType": "Bedroom,Entry/Foyer,Kitchen,Laundry,Living Room,Primary Bedroom,Other" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114689512" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-29T17:20:21Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "La Quinta" +"StreetNumber": "1833" +"StreetNumberNumeric": "1833" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "228" +"UniversalPropertyId": "US-06047-N-008360036000-R-N" +"Utilities": "Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Blinds,Double Pane Windows,Screens" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Entry,Kitchen,Laundry,Living Room,Primary Suite,Walk-In Closet",\n "EatingArea": "Area,Breakfast Counter / Bar,In Kitchen",\n "RoomKitchenFeatures": "Kitchen Island,Quartz Counters",\n "RoomBathroomFeatures": "Shower in Tub,Closet in bathroom,Double Sinks in Primary Bath,Exhaust fan(s),Privacy toilet door,Separate tub and shower,Tile Counters",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1114689512",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114689512')" +"CurrentPrice": 525000.0 +"provider_name": "CRMLS" +"RecordSignature": -95399782 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:008360036000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "435889" +"Media": array:55 [ 0 => array:57 [ …57] …54 ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1107257292" +"ListingId": "IV25035678" +"PropertyType": "Residential Income" +"PropertySubType": "Duplex" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-12T20:27:16Z" +"RFModificationTimestamp": "2025-06-13T07:20:43.897139+00:00" +"ListPrice": 435000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 6500.0 +"LivingArea": 0 +"BuildingAreaTotal": 1800.0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "610 W 7th Street, Merced, California 95341" +"Coordinates": array:2 [ …2] +"Latitude": 37.29155 +"Longitude": -120.49125 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "VIDAL AGUIRRE" +"ListOfficeName": "FUSION ONE REALTY" +"ListAgentMlsId": "IVAGUIVID" +"ListOfficeMlsId": "IVFUSI" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Duplex in good location. Close to hospital, shopping and easy commute access." +"AttributionContact": "909-636-4166" +"BuildingAreaUnits": "Square Feet" +"CLIP": 8438798401 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights" +"ContractStatusChangeDate": "2025-02-18" +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-02-18T04:15:13.781583+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-12" +"Directions": "South on M Street turn right on 7th street" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"GrossIncome": 36600.0 +"GrossScheduledIncome": 36600.0 +"InsuranceExpense": 2680.0 +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup" +"Levels": "One" +"ListAgentAOR": "Inland Valleys" +"ListAgentDirectPhone": "909-636-4166" +"ListAgentEmail": "HDNew Homes@gmail.com" +"ListAgentFirstName": "VIDAL" +"ListAgentKey": "16969199" +"ListAgentKeyNumeric": "16969199" +"ListAgentLastName": "AGUIRRE" +"ListAgentOfficePhone": "626-332-1906" +"ListAgentStateLicense": "01348180" +"ListOfficeAOR": "Inland Valleys" +"ListOfficeEmail": "olivas101@gmail.com" +"ListOfficeFax": "888-774-3677" +"ListOfficeKey": "3278027" +"ListOfficeKeyNumeric": "3278027" +"ListOfficePhone": "626-332-1906" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-02-17" +"ListingKeyNumeric": 1107257292 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,Submit" +"LotFeatures": "Street Level" +"LotSizeAcres": 0.1492 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6500.0 +"MajorChangeTimestamp": "2025-03-11T20:02:16Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NetOperatingIncome": 31760.0 +"NumberOfBuildings": 2 +"NumberOfSeparateElectricMeters": 2 +"NumberOfSeparateGasMeters": 2 +"NumberOfSeparateWaterMeters": 1 +"NumberOfUnitsTotal": "2" +"OffMarketDate": "2025-02-18" +"OffMarketTimestamp": "2025-03-11T20:02:16Z" +"OnMarketDate": "2025-02-17" +"OnMarketTimestamp": "2025-02-17T19:45:17Z" +"OperatingExpense": "4840.0" +"OriginalEntryTimestamp": "2025-02-17T19:45:17Z" +"OriginalListPrice": 435000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373952064" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "032211007000" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-02-18T04:11:40Z" +"PhotosCount": 1 +"PoolFeatures": "None" +"PostalCodePlus4": "6622" +"PropertySubTypeAdditional": "Duplex" +"PurchaseContractDate": "2025-02-18" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1107257292" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-11T20:02:16Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "7th" +"StreetNumber": "610" +"StreetNumberNumeric": "610" +"StreetSuffix": "Street" +"TaxBlock": "373" +"TaxLot": "2" +"TrashExpense": 720.0 +"UniversalPropertyId": "US-06047-N-032211007000-R-N" +"WaterSewerExpense": 1440.0 +"YearBuiltSource": "Assessor" +"Zoning": "R-3-1.5" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "AdminUpdateYN": "0",\n "ListingKey": "1107257292",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1107257292')" +"CurrentPrice": 435000.0 +"provider_name": "CRMLS" +"RecordSignature": 2023471252 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:032211007000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "133625" +"OriginatingSystemListAgentMemberKey": "362174580" +"Media": array:1 [ …1] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112310637" +"ListingId": "MC25094052" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-12T20:27:16Z" +"RFModificationTimestamp": "2025-06-13T07:21:44.958839+00:00" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 11261.0 +"LivingArea": 2129.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "2165 Trenton Court, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.306167 +"Longitude": -120.44582 +"YearBuilt": 1987 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Julie Kaley" +"ListOfficeName": "Merced Homes Realty" +"ListAgentMlsId": "MCKALEJU" +"ListOfficeMlsId": "mc231m" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "HUD Home! Amazing opportunity on this HUD Home! Fantastic location in back of cul-de-sac. Unique brick home with tons of outdoor living space! Spacious floor plan with over 2100sqft, 3 large bedrooms and 2 full bathrooms! Large great room with fireplace, formal dining room and large eat in area off the kitchen. All three bedrooms are over-sized. Kitchen is located at the back of the home. Nice covered wrap around porch in front of home, HUGE covered patio areas in backyard for maximum outdoor enjoyment. Attached 2 car garage, attached shed. HUGE lot! Nicely landscaped front and back. All HUD Homes are sold in as is condition. Come take a look today to see if this home is right for you! This home will not last!" +"AccessibilityFeatures": "Grab Bars" +"Appliances": "Dishwasher,Electric Cooktop,Electric Oven,Microwave" +"AttachedGarageYN": true +"AttributionContact": "209-499-6999" +"BathroomsFull": 2 +"CLIP": 8166577138 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Sidewalks" +"ConstructionMaterials": "Brick" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-04-29T19:52:07.212480+00:00" +"CumulativeDaysOnMarket": 44 +"DaysOnMarket": 44 +"DaysOnMarketReplication": 44 +"DaysOnMarketReplicationDate": "2025-06-12" +"Directions": "From McKee Rd onto Gettysburg. Turn left on Lexington Ave onto Trenton Ct." +"DocumentsChangeTimestamp": "2025-04-29T12:18:28Z" +"DocumentsCount": 3 +"Electric": "220 Volts in Garage" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Main" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Separate/Formal Dining Room,Tile Counters,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-1200" +"ListAgentEmail": "juliekaley@yahoo.com" +"ListAgentFax": "866-481-8317" +"ListAgentFirstName": "Julie" +"ListAgentKey": "17093405" +"ListAgentKeyNumeric": "17093405" +"ListAgentLastName": "Kaley" +"ListAgentOfficePhone": "209-385-1200" +"ListAgentStateLicense": "01412616" +"ListOfficeAOR": "Merced County" +"ListOfficeFax": "209-385-1252" +"ListOfficeKey": "3278143" +"ListOfficeKeyNumeric": "3278143" +"ListOfficePhone": "209-385-1200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112310637 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA 203(b),FHA,Submit" +"LivingAreaSource": "Appraiser" +"LotFeatures": "Landscaped" +"LotSizeAcres": 0.2585 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 11261.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-12T13:01:06Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-12" +"OffMarketTimestamp": "2025-06-12T13:01:06Z" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T11:57:07Z" +"OriginalEntryTimestamp": "2025-04-29T11:57:07Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374319994" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "033261016000" +"ParkingFeatures": "Assigned,Garage Faces Front" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Covered, Patio" +"PhotosChangeTimestamp": "2025-04-29T19:35:42Z" +"PhotosCount": 37 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "3377" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-12" +"Roof": "Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent,See Remarks" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112310637" +"SpaFeatures": "Above Ground" +"SpaYN": true +"SpecialListingConditions": "HUD Owned" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T13:01:06Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Trenton" +"StreetNumber": "2165" +"StreetNumberNumeric": "2165" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "82" +"UniversalPropertyId": "US-06047-N-033261016000-R-N" +"View": "Neighborhood" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.zillow.com/view-3d-home/fece6692-51ef-4762-9fbd-b289d0207222/?utm_source=captureapp" +"VirtualTourURLUnbranded2": "https://www.zillow.com/view-3d-home/fece6692-51ef-4762-9fbd-b289d0207222/?utm_source=captureapp" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "EatingArea": "Dining Room,Separated",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Formica Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1112310637",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112310637')" +"CurrentPrice": 425000.0 +"provider_name": "CRMLS" +"RecordSignature": -260950717 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:033261016000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "109984" +"OriginatingSystemListAgentMemberKey": "435423" +"Media": array:37 [ …37] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115037876" +"ListingId": "MC25127489" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-12T20:13:10Z" +"RFModificationTimestamp": "2025-06-13T07:55:58.773611+00:00" +"ListPrice": 350000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 8464.0 +"LivingArea": 1822.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "3427 Lago Court, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.327568 +"Longitude": -120.492756 +"YearBuilt": 1991 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Melinda Price" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "MCPRICME" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This is a great floor plan with 4 bedrooms, living room, family room, eat in kitchen and formal dining area. Home has deferred maintenance but this is your chance to buy a home in a great neighborhood, on a large lot...and with a 3 car garage! Upgrade to your own taste and have some real sweat equity. Close to Merced Community College, schools, shopping, walking path, dog park and more. Walking distance to the mall, restaurants and two gyms. This is priced to sell....AS IS." +"Appliances": "Dishwasher,Electric Oven,Electric Range,Gas Water Heater,Microwave" +"ArchitecturalStyle": "Contemporary" +"AttachedGarageYN": true +"AttributionContact": "209-617-2851" +"BathroomsFull": 2 +"CLIP": 5199458950 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Gutter(s),Street Lights,Sidewalks" +"ConstructionMaterials": "Drywall, Stucco" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-06-07T03:12:51.788761+00:00" +"CumulativeDaysOnMarket": 6 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 10 +"DaysOnMarketReplication": 6 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "East" +"Directions": "From R Street, east on Buena Vista, Right on Lago Court" +"DocumentsChangeTimestamp": "2025-06-09T07:34:45Z" +"DocumentsCount": 2 +"Electric": "220 Volts in Kitchen" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"FoundationDetails": "Slab" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Separate/Formal Dining Room,Eat-in Kitchen,Tile Counters,All Bedrooms Down,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "mprice@londonproperties.com" +"ListAgentFirstName": "Melinda" +"ListAgentKey": "17190475" +"ListAgentKeyNumeric": "17190475" +"ListAgentLastName": "Price" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "01116263" +"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-06" +"ListingKeyNumeric": 1115037876 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LivingAreaSource": "Public Records" +"LotFeatures": "Cul-De-Sac" +"LotSizeAcres": 0.1943 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 8464.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 4 +"MajorChangeTimestamp": "2025-06-12T12:05:42Z" +"MajorChangeType": "Active Under Contract" +"MlsStatus": "Active Under Contract" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T16:04:11Z" +"OriginalEntryTimestamp": "2025-06-06T16:04:11Z" +"OriginalListPrice": 350000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374546988" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "058320003000" +"ParkingTotal": "3.0" +"PatioAndPorchFeatures": "Concrete" +"PhotosChangeTimestamp": "2025-06-09T14:43:41Z" +"PhotosCount": 1 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PropertyCondition": "Fixer" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-12" +"Roof": "Composition" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115037876" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T12:05:42Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Lago" +"StreetNumber": "3427" +"StreetNumberNumeric": "3427" +"StreetSuffix": "Court" +"StructureType": "House" +"UniversalPropertyId": "US-06047-N-058320003000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Kitchen,Laundry,Living Room,Primary Suite,Separate Family Room",\n "EatingArea": "Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Kitchen Island,Tile Counters",\n "RoomBathroomFeatures": "Shower,Shower in Tub,Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1115037876",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115037876')" +"CurrentPrice": 350000.0 +"provider_name": "CRMLS" +"RecordSignature": 904052191 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:058320003000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "434127" +"Media": array:1 [ …1] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114612169" +"ListingId": "MC25117611" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T19:25:03Z" +"RFModificationTimestamp": "2025-06-13T09:56:38.324421+00:00" +"ListPrice": 510000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6000.0 +"LivingArea": 2943.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "1216 Avignon Drive, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.340965 +"Longitude": -120.491374 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Xay Yang" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "mcyangxa" +"ListOfficeMlsId": "MC524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to Your Dream Home! Step into this exceptional 2-story residence that seamlessly blends spacious living with a flexible floorplan—perfect for growing families or multigenerational households. Boasting 4 bedrooms, 3 full bathrooms, and nearly 3,000 square feet of thoughtfully designed space, this home truly has something for everyone. From the curb, you'll appreciate the generous street parking and 3-car garage. Inside, soaring vaulted ceilings and a bright, open layout create an inviting atmosphere. The home features a versatile living/dining room combo and a separate kitchen/family room—ideal for entertaining, relaxing, or creating your dream media room, play space, or hobby area. The spacious kitchen offers abundant cabinetry and a large island—perfect for meal prep, hosting, or casual dining. Convenience continues with a full bedroom and bathroom on the main floor, along with an indoor laundry room for added ease. Upstairs, a spacious loft adds even more flexibility. Use it as a second living area, home office, or easily convert it into a 5th bedroom to suit your needs. Recent updates include fresh interior paint and beautiful Waterproof Luxury Vinyl Plank flooring throughout. Step outside to a low-maintenance, cemented backyard featuring a storage shed—ready to be transformed into your personalized outdoor oasis. Ideally located near Merced College, UC Merced, Mercy Hospital, shopping centers, and gas station, this home offers the perfect balance of comfort, convenience, and value. Schedule your private showing today and experience the perfect place to call home!" +"Appliances": "Gas Cooktop" +"AttachedGarageYN": true +"AttributionContact": "209-777-2779" +"BathroomsFull": 3 +"CLIP": 3074786851 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Sidewalks" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-05-27" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-28T17:21:31.492144+00:00" +"CumulativeDaysOnMarket": 15 +"DaysOnMarket": 19 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From downtown Merced, W 16th Street towards Atwater, R on CA-hwy59, R on W. Yosemite Ave, L on El Redondo Dr, Pass through 2 roundabouts, staying on El Redondo Dr, R on Avignon Drive." +"DocumentsChangeTimestamp": "2025-06-10T19:19:17Z" +"DocumentsCount": 1 +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "street" +"Exclusions": "Refrigerator, washer/dryer, and backyard unfinished gazebo." +"Fencing": "Wood" +"FireplaceFeatures": "Gas" +"FireplaceYN": true +"Flooring": "Laminate" +"FoundationDetails": "Slab" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "High Ceilings,Open Floorplan" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "life123xy@gmail.com" +"ListAgentFax": "209-722-8181" +"ListAgentFirstName": "Xay" +"ListAgentKey": "17036225" +"ListAgentKeyNumeric": "17036225" +"ListAgentLastName": "Yang" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "02065274" +"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-05-27" +"ListingKeyNumeric": 1114612169 +"ListingService": "Full Service" +"ListingTerms": "Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Sprinklers In Front" +"LotSizeAcres": 0.1377 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6000.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T11:57:18Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-28" +"OnMarketTimestamp": "2025-05-28T09:36:10Z" +"OriginalEntryTimestamp": "2025-05-28T09:36:10Z" +"OriginalListPrice": 525000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374480823" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "206187003000" +"ParkingFeatures": "Garage,On Street" +"ParkingTotal": "3.0" +"PatioAndPorchFeatures": "None" +"PhotosChangeTimestamp": "2025-05-28T16:55:42Z" +"PhotosCount": 22 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "9546" +"PreviousListPrice": 525000.0 +"PriceChangeTimestamp": "2025-06-12T11:57:18Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Tile" +"RoomType": "Family Room,Living Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Xay Yang" +"ShowingContactPhone": "209-777-2779" +"ShowingContactType": "Agent,See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114612169" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-28T09:36:10Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Avignon" +"StreetNumber": "1216" +"StreetNumberNumeric": "1216" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "107" +"UniversalPropertyId": "US-06047-N-206187003000-R-N" +"Utilities": "Natural Gas Connected,Sewer Connected,Water Connected" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "P-D" +"CustomFields": """ {\n "RoomType": "Family Room,Living Room",\n "RoomBathroomFeatures": "Double sinks in bath(s),Double Sinks in Primary Bath",\n "AdminUpdateYN": "0",\n "ListingKey": "1114612169",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114612169')" +"CurrentPrice": 510000.0 +"provider_name": "CRMLS" +"RecordSignature": -1087407441 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:206187003000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "109320" +"OriginatingSystemListAgentMemberKey": "343340620" +"Media": array:22 [ …22] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1104913481" +"ListingId": "SR25028849" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T18:27:02Z" +"RFModificationTimestamp": "2025-06-12T20:49:11.229302+00:00" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6725.0 +"LivingArea": 1176.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "3514 Oakhurst Avenue, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.32771 +"Longitude": -120.467181 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jose Nunez" +"ListOfficeName": "Cal-Prime Realty" +"ListAgentMlsId": "F176000149" +"ListOfficeMlsId": "F4006001" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This gorgeous 3 bedroom, 2 bathroom home is ready for you! to move into. This fully remodeled Wainwright Home has a spacious, open floor plan. The entire home has been freshly painted, giving it a bright sleek look. Outside, the large, low-maintenance yard is ideal for relaxation or entertaining. Located in a beautiful quiet neighborhood in the rapidly growing city of Merced with close proximity to an School like Merced High School, Peterson elementary, Merced College and UC Merced. You also have close proximity to shopping Centers and Mercy Hospital. You don't want miss it, come and take a look at this gem." +"AttachedGarageYN": true +"AttributionContact": "661-209-1102" +"BackOnMarketDate": "2025-03-10" +"BathroomsFull": 2 +"CLIP": 7442365612 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Sidewalks" +"ContractStatusChangeDate": "2025-02-07" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-02-07T23:03:55.320119+00:00" +"CumulativeDaysOnMarket": 105 +"DaysOnMarket": 109 +"DaysOnMarketReplication": 105 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head North on G Street, make a right on El Portal make a left on Oakhurst Ave" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "West" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Southland" +"ListAgentEmail": "jnunez@calprime.net" +"ListAgentFax": "888-808-5482" +"ListAgentFirstName": "Jose" +"ListAgentKey": "17162963" +"ListAgentKeyNumeric": "17162963" +"ListAgentLastName": "Nunez" +"ListAgentOfficePhone": "213-330-4205" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01800615" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Southland" +"ListOfficeEmail": "jnunez@calprime.net" +"ListOfficeFax": "888-808-5482" +"ListOfficeKey": "3266843" +"ListOfficeKeyNumeric": "3266843" +"ListOfficePhone": "213-330-4205" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-02-07" +"ListingKeyNumeric": 1104913481 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,Fannie Mae,USDA Loan,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1544 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6725.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-03-10T22:43:32Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-02-18" +"OffMarketTimestamp": "2025-02-19T17:03:28Z" +"OnMarketDate": "2025-02-07" +"OnMarketTimestamp": "2025-03-10T22:43:32Z" +"OriginalEntryTimestamp": "2025-02-07T14:30:53Z" +"OriginalListPrice": 399000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373912678" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "006321028000" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-12T18:27:59Z" +"PhotosCount": 14 +"PoolFeatures": "None" +"PostalCodePlus4": "0657" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Family Room,Kitchen,Living Room" +"Sewer": "Public Sewer" +"ShowingContactType": "Other,See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1104913481" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-10T22:43:32Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Oakhurst" +"StreetNumber": "3514" +"StreetNumberNumeric": "3514" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "87" +"UniversalPropertyId": "US-06047-N-006321028000-R-N" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Family Room,Kitchen,Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1104913481",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1104913481')" +"CurrentPrice": 399000.0 +"provider_name": "CRMLS" +"RecordSignature": -1052366651 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:006321028000" +"CountrySubdivision": "06047" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "28291" +"OriginatingSystemListAgentMemberKey": "266798" +"Media": array:14 [ …14] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114163503" +"ListingId": "MC25102744" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T15:33:23Z" +"RFModificationTimestamp": "2025-06-12T16:18:37.266996+00:00" +"ListPrice": 350000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6489.0 +"LivingArea": 1752.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "3557 M Street, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.331625 +"Longitude": -120.478699 +"YearBuilt": 1972 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Phillip May" +"ListOfficeName": "Keller Williams Property Team" +"ListAgentMlsId": "MCMAYPH" +"ListOfficeMlsId": "mc1275" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Charming 3-Bed, 2-Bath Home in the Heart of Merced! ??\r\r\n \r\r\n Welcome to 3557 M St., a 3-bedroom, 2-bath residence offering 1,752 square feet of comfortable living space in a prime Merced location. This inviting home features classic charm and a spacious layout, making it perfect for families, first-time buyers, or investors.\r\r\n \r\r\n Step inside to discover a well-appointed kitchen and a cozy living area ideal for gatherings or quiet nights in. The primary suite offers a private retreat with its own en-suite bathroom, while two additional bedrooms provide flexibility for guests, a home office, or hobbies.\r\r\n \r\r\n Outside, enjoy a private backyard—perfect for entertaining, gardening, or relaxing. Ideally located near schools, parks, shopping, and within close walking distance to Merced College, this home offers both convenience and comfort in one of Merced’s established neighborhoods.\r\r\n \r\r\n ?? Don’t miss your chance to own this move-in ready gem—schedule your showing today! """ +"Appliances": "Dishwasher" +"AttachedGarageYN": true +"AttributionContact": "209-617-5660" +"BathroomsFull": 2 +"CLIP": 1081002884 +"CoListAgentAOR": "Merced County" +"CoListAgentDirectPhone": "209-761-6255" +"CoListAgentEmail": "cmaghoney@gmail.com" +"CoListAgentFirstName": "Carol" +"CoListAgentFullName": "Carol Maghoney" +"CoListAgentKey": "17071582" +"CoListAgentKeyNumeric": "17071582" +"CoListAgentLastName": "Maghoney" +"CoListAgentMlsId": "mcmaghca" +"CoListAgentOfficePhone": "209-500-4663" +"CoListAgentStateLicense": "01920108" +"CoListOfficeAOR": "Merced County" +"CoListOfficeEmail": "mjawad@kw.com" +"CoListOfficeKey": "3778305" +"CoListOfficeKeyNumeric": "3778305" +"CoListOfficeMlsId": "mc1275" +"CoListOfficeName": "Keller Williams Property Team" +"CoListOfficePhone": "209-500-4663" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Suburban,Sidewalks" +"ContractStatusChangeDate": "2025-05-15" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2025-05-15T22:35:10.285258+00:00" +"CumulativeDaysOnMarket": 28 +"DaysOnMarket": 32 +"DaysOnMarketReplication": 28 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "left at the 1st cross street onto W 18th St; right onto M St/Veterans Blvd; left to stay on M St/Veterans Blvd" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Carpet" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Ceiling Fan(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-617-5660" +"ListAgentEmail": "phillipmmay@gmail.com" +"ListAgentFax": "209-431-2222" +"ListAgentFirstName": "Phillip" +"ListAgentKey": "17115507" +"ListAgentKeyNumeric": "17115507" +"ListAgentLastName": "May" +"ListAgentOfficePhone": "209-500-4663" +"ListAgentStateLicense": "01393951" +"ListAgentURL": "phillipmay.com" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "mjawad@kw.com" +"ListOfficeKey": "3778305" +"ListOfficeKeyNumeric": "3778305" +"ListOfficePhone": "209-500-4663" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-15" +"ListingKeyNumeric": 1114163503 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,Submit,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Lawn" +"LotSizeAcres": 0.149 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6489.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-12T08:05:20Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-15" +"OnMarketTimestamp": "2025-05-15T13:06:23Z" +"OriginalEntryTimestamp": "2025-05-15T13:06:23Z" +"OriginalListPrice": 375000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374418268" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "236032028000" +"ParkingFeatures": "Driveway,Garage Faces Front,Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-15T20:34:42Z" +"PhotosCount": 38 +"PoolFeatures": "None" +"PostalCodePlus4": "2823" +"PreviousListPrice": 375000.0 +"PriceChangeTimestamp": "2025-06-12T08:05:20Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Kitchen,Laundry,Primary Bathroom,Primary Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114163503" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-15T13:06:23Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "M" +"StreetNumber": "3557" +"StreetNumberNumeric": "3557" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "44" +"UniversalPropertyId": "US-06047-N-236032028000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Kitchen,Laundry,Primary Bathroom,Primary Bedroom",\n "EatingArea": "Area",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Bathtub,Shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1114163503",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114163503')" +"CurrentPrice": 350000.0 +"provider_name": "CRMLS" +"RecordSignature": 980292084 +"UniversalParcelId": "urn:reso:upi:2.0:US:06047:236032028000" +"CountrySubdivision": "06047" +"OriginatingSystemListOfficeKey": "364634256" +"OriginatingSystemCoListOfficeKey": "364634256" +"OriginatingSystemListAgentMemberKey": "435290" +"OriginatingSystemCoListAgentMemberKey": "523906" +"Media": array:38 [ …38] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +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] } ] +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 {#5100 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5099 +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 {#5517 +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 {#5516 +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 {#5521 +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 {#5520 +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" +"PhotosCount": 18 +"PoolFeatures": "None" +"PostalCodePlus4": "2538" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Kitchen,Laundry,Living Room" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117339596" +"SpecialListingConditions": "Trust" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T08:28:00Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Michelle" +"StreetNumber": "3564" +"StreetNumberNumeric": "3564" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "83" +"UniversalPropertyId": "US-06037-N-7524004052-R-N" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "TORR-LO" +"CustomFields": """ {\n "RoomType": "Kitchen,Laundry,Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1117339596",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117339596')" +"CurrentPrice": 1350000.0 +"provider_name": "CRMLS" +"RecordSignature": 2051527427 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:7524004052" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "14772" +"OriginatingSystemListAgentMemberKey": "572305" +"Media": array:18 [ …18] } ] +success: true +page_size: 5 +page_count: 135485 +count: 677424 +after_key: "" } ] ]
