1612 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: 309faa0fabeaa328474de56691479d4a37ed029340285f5bcdfa9a6b4fa0abe4" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4914 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551923698" +"ListingId": "MC21221092" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:52Z" +"RFModificationTimestamp": "2024-10-15T16:23:42.031166+00:00" +"ListPrice": 649000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 7205.0 +"LivingArea": 3576.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "1253 Lurs Court, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.340001 +"Longitude": -120.493385 +"YearBuilt": 2006 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Randy Hayer" +"ListOfficeName": "Realty Executives Of Merced" +"ListAgentMlsId": "MCHAYERA" +"ListOfficeMlsId": "MC188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Beautiful two-story home on a large corner lot, located in the desirable North Merced area. Upon entering you will notice a lovely tile entrance, high ceilings, plantation shutters throughout, and an open floor plan. The formal dining room is spacious and open to the formal living room with plenty of natural lighting throughout. The kitchen is large with a giant breakfast bar, granite countertops, built-in microwave and oven, built-in gas cooktop, stainless steel appliances, large eating area, and beautiful cabinetry, open to the family room. The family room is perfect for entertaining with plenty of open space, surround sounds, a built-in entertainment center, and a gas fireplace with a mantle. The master suite is oversized with two walk-in closets, and a huge master bath with a jetted tub, walk-in shower, his and hers sinks, and a vanity area. Upstairs you will find the laundry room with plenty of cabinets and a sink, and downstairs is a one-bedroom and one bath. The backyard is large with a built-in pool fully fenced, a nice sitting area, and concrete all around the home. A must-see! Schedule your showing today!" +"Appliances": "Dishwasher,Electric Oven,Gas Cooktop,Disposal,Microwave,Water Softener" +"AttachedGarageYN": true +"BathroomsFull": 4 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-385-8500" +"BuyerAgentEmail": "myagentrandy@gmail.com" +"BuyerAgentFirstName": "Randy" +"BuyerAgentFullName": "Randy Hayer" +"BuyerAgentKey": "17194488" +"BuyerAgentKeyNumeric": "17194488" +"BuyerAgentLastName": "Hayer" +"BuyerAgentMlsId": "MCHAYERA" +"BuyerAgentStateLicense": "01251542" +"BuyerBrokerageCompensation": "2.500" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "mercedexecutives@gmail.com" +"BuyerOfficeKey": "3278012" +"BuyerOfficeKeyNumeric": "3278012" +"BuyerOfficeMlsId": "MC188" +"BuyerOfficeName": "Realty Executives Of Merced" +"BuyerOfficePhone": "209-385-8500" +"BuyerOfficeURL": "http://www.realtyexecutives.com" +"CLIP": 8564212427 +"CloseDate": "2022-03-01" +"ClosePrice": 625000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Street Lights,Sidewalks" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2022-03-01" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T16:23:41.909990+00:00" +"CumulativeDaysOnMarket": 70 +"DaysOnMarket": 70 +"DaysOnMarketReplication": 70 +"DaysOnMarketReplicationDate": "2022-03-02" +"Directions": "Take W Yosemite Ave to El Redondo Dr 5 min (1.8 mi) Continue on El Redondo Dr. Take Lehigh Dr to Lurs Ct" +"ElevationUnits": "Feet" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central, Fireplace(s)" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Crown Molding,Separate/Formal Dining Room,Eat-in Kitchen,Granite Counters,High Ceilings,Open Floorplan,Pantry,Recessed Lighting,Wired for Sound,Bedroom on Main Level,Loft" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-8500" +"ListAgentEmail": "myagentrandy@gmail.com" +"ListAgentFax": "209-385-8516" +"ListAgentFirstName": "Randy" +"ListAgentKey": "17194488" +"ListAgentKeyNumeric": "17194488" +"ListAgentLastName": "Hayer" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "01251542" +"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": "2021-10-05" +"ListingKeyNumeric": 551923698 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Corner Lot,Front Yard,Rectangular Lot" +"LotSizeAcres": 0.1654 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7205.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2022-03-02T09:38:45Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2022-01-03" +"OffMarketTimestamp": "2021-12-15T11:59:29Z" +"OnMarketDate": "2021-10-05" +"OnMarketTimestamp": "2021-10-05T14:00:20Z" +"OriginalEntryTimestamp": "2021-10-05T14:00:20Z" +"OriginalListPrice": 685000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367372250" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "206186020000" +"ParkingFeatures": "Driveway,Garage Faces Front,Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete,Front Porch,Open,Patio" +"PhotosChangeTimestamp": "2022-10-22T02:53:52Z" +"PhotosCount": 75 +"PoolFeatures": "Fenced, Gunite, Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "9544" +"PreviousListPrice": 685000.0 +"PriceChangeTimestamp": "2021-11-19T15:46:01Z" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2022-01-03" +"RoadSurfaceType": "Paved" +"Roof": "Spanish Tile" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Loft,Living Room,Primary Bathroom,Primary Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551923698" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2022-03-02T09:38:45Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Lurs" +"StreetNumber": "1253" +"StreetNumberNumeric": "1253" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "168" +"UniversalPropertyId": "US-06047-N-206186020000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,Plantation Shutters" +"YearBuiltSource": "Public Records" +"Zoning": "P-D" +"CustomFields": """ {\n "RoomType": "Family Room,Kitchen,Laundry,Living Room,Loft,Main Floor Bedroom,Primary Bathroom,Primary Bedroom",\n "EatingArea": "Breakfast Counter / Bar,Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island,Kitchen Open to Family Room",\n "RoomBathroomFeatures": "Shower in Tub,Double sinks in bath(s),Double Sinks in Primary Bath,Granite Counters,Jetted Tub,Vanity area,Walk-in shower",\n "ListingKey": "551923698",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"Media": array:75 [ …75] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551923698')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551931436" +"ListingId": "MC21221403" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:52Z" +"RFModificationTimestamp": "2024-10-15T15:49:06.028289+00:00" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 12293.0 +"LivingArea": 1848.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "2951 Redwood Drive, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.313784 +"Longitude": -120.446527 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kay Flanagan" +"ListOfficeName": "Roberta Flanagan Realtor, Inc" +"ListAgentMlsId": "MCFLANKA" +"ListOfficeMlsId": "MC34" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Lovely home on a very quiet street. Home backs up to an Almond orchard, almost like being in the country! Nice Open floor plan, whole house fan, remodeled kitchen, formal dining room and a small step down to formal living room. Family room and kitchen are so nice for a family gathering or party. Fireplace in living room to enjoy on a cool day. Large Patio which is full covered. Has Spa but "As Is." Plus the LOT is 12,293 sq. ft. = 28% of an ac. \r\r\n Wow Right? This home is so nicely set up, good floor plan for family inside and a great back yard to enjoy. Very Private. Home has 3 nice size bedrooms, 2 full baths, 1,848 sq. ft. Master bedroom has nice large walk in closet, in the Family room there are solar tubs for nice natural lighting. Indoor laundry room. Large attached 2 car garage, plus extra cement for parking and RV parking with gate to back yard. Come and see your future home, just needs a new family. """ +"ActivationDate": "2021-10-09" +"Appliances": "Dishwasher,Electric Oven,Disposal" +"ArchitecturalStyle": "Ranch" +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-668-0501" +"BuyerAgentEmail": "jojeda@josetherealtor.net" +"BuyerAgentFirstName": "Jose" +"BuyerAgentFullName": "Jose Ojeda" +"BuyerAgentKey": "17000919" +"BuyerAgentKeyNumeric": "17000919" +"BuyerAgentLastName": "Ojeda" +"BuyerAgentMlsId": "mcojedjo" +"BuyerAgentStateLicense": "02040431" +"BuyerBrokerageCompensation": "2.500" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "admin@homesatatlantic.com" +"BuyerOfficeKey": "3278064" +"BuyerOfficeKeyNumeric": "3278064" +"BuyerOfficeMlsId": "MC763" +"BuyerOfficeName": "Atlantic Realty" +"BuyerOfficePhone": "209-668-0501" +"CLIP": 8057738189 +"CloseDate": "2021-11-16" +"ClosePrice": 405000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Sidewalks" +"ContractStatusChangeDate": "2021-11-16" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T15:49:05.923299+00:00" +"CumulativeDaysOnMarket": 14 +"DaysOnMarket": 14 +"DaysOnMarketReplication": 14 +"DaysOnMarketReplicationDate": "2021-11-17" +"DirectionFaces": "Southeast" +"Directions": "McKee to Cedar Crest turn west, Redwood is 2nd street. Before Bedford Dr," +"DocumentsChangeTimestamp": "2021-10-07T16:16:39Z" +"DocumentsCount": 1 +"Electric": "220 Volts in Kitchen,220 Volts in Laundry" +"ElevationUnits": "Feet" +"Fencing": "Wood" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Carpet, Laminate" +"FoundationDetails": "Raised" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Separate/Formal Dining Room,Open Floorplan,Tile Counters,Walk-In Closet(s)" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-723-4337" +"ListAgentEmail": "Kay Flanagan@realtorrf.com" +"ListAgentFax": "209-723-6125" +"ListAgentFirstName": "Kay" +"ListAgentKey": "17082341" +"ListAgentKeyNumeric": "17082341" +"ListAgentLastName": "Flanagan" +"ListAgentOfficePhone": "209-723-4337" +"ListAgentStateLicense": "00418994" +"ListAgentURL": "www.Kay Flanagan.com" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "kayflanagan@realtorrf.com" +"ListOfficeFax": "209-723-6125" +"ListOfficeKey": "3278046" +"ListOfficeKeyNumeric": "3278046" +"ListOfficePhone": "209-723-4337" +"ListOfficeURL": "http://www.mercedcounty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-05" +"ListingKeyNumeric": 551931436 +"ListingService": "Full Service" +"ListingTerms": "Cash to New Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Cul-De-Sac,Front Yard,Lawn,Landscaped,Sprinkler System" +"LotSizeAcres": 0.2822 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 12293.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2021-11-17T14:29:58Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2021-11-16" +"OffMarketTimestamp": "2021-11-17T14:29:58Z" +"OnMarketDate": "2021-10-09" +"OnMarketTimestamp": "2021-10-09T00:31:09Z" +"OriginalEntryTimestamp": "2021-10-05T17:18:44Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367373630" +"OriginatingSystemSubName": "CRMLS_CRM" +"OtherStructures": "Shed(s)" +"ParcelNumber": "008144007000" +"ParkingFeatures": "Garage Faces Front,RV Access/Parking" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete, Covered" +"PhotosChangeTimestamp": "2022-10-21T22:49:45Z" +"PhotosCount": 66 +"PoolFeatures": "None" +"PostalCodePlus4": "2739" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-23" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Entry/Foyer,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Other,Dining Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Private Sewer,Septic Type Unknown" +"ShowingContactName": "Jovan" +"ShowingContactPhone": "209-819-1772" +"ShowingContactType": "Agent, Occupant" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551931436" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2021-10-09" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-11-17T14:29:58Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Redwood" +"StreetNumber": "2951" +"StreetNumberNumeric": "2951" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "36" +"UniversalPropertyId": "US-06047-N-008144007000-R-N" +"Utilities": "Natural Gas Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Entry,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Walk-In Closet",\n "EatingArea": "Area,Breakfast Counter / Bar,Dining Room,Separated",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Shower,Shower in Tub",\n "ListingKey": "551931436",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:66 [ …66] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551931436')" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551909889" +"ListingId": "MC21220253" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:52Z" +"RFModificationTimestamp": "2024-10-15T16:54:36.953559+00:00" +"ListPrice": 355000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 9148.0 +"LivingArea": 1636.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "3141 Gary Avenue, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.31916 +"Longitude": -120.462789 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Andy Krotik" +"ListOfficeName": "American Realty" +"ListAgentMlsId": "MCKROTAN" +"ListOfficeMlsId": "mc938" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Convenient Merced location for this 3 bedroom, 2 bath home with 1636 square feet of living space! Updated windows, New Carpet in bedrooms, Newer HVAC (2019) Tile entry, and tile baths. 9 ceiling fans, indoor laundry, newer appliances in kitchen, some crown molding, covered patio, extra concrete on side of the house, 3 storage sheds, all situated on oversized 9148 square foot lot." +"Appliances": "Dishwasher,Electric Cooktop,Disposal" +"ArchitecturalStyle": "Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-725-2100" +"BuyerAgentEmail": "life123xy@gmail.com" +"BuyerAgentFirstName": "Xay" +"BuyerAgentFullName": "Xay Yang" +"BuyerAgentKey": "17036225" +"BuyerAgentKeyNumeric": "17036225" +"BuyerAgentLastName": "Yang" +"BuyerAgentMlsId": "mcyangxa" +"BuyerAgentStateLicense": "02065274" +"BuyerBrokerageCompensation": "2.500" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "FHA" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "greg@londonproperties.com" +"BuyerOfficeKey": "3278096" +"BuyerOfficeKeyNumeric": "3278096" +"BuyerOfficeMlsId": "mc524" +"BuyerOfficeName": "London Properties Ltd - Merced" +"BuyerOfficePhone": "209-725-2100" +"CLIP": 1043088459 +"CloseDate": "2021-11-02" +"ClosePrice": 365000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Urban" +"Contingency": "Standard" +"ContractStatusChangeDate": "2021-11-02" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T16:54:36.797955+00:00" +"CumulativeDaysOnMarket": 3 +"DaysOnMarket": 3 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2021-11-02" +"Directions": "W Olive Ave, Turn left onto Gary Ave." +"ElevationUnits": "Feet" +"Fencing": "Wood" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Ceiling Fan(s),Eat-in Kitchen,All Bedrooms Down" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-777-5070" +"ListAgentEmail": "andygetsitsold@gmail.com" +"ListAgentFax": "888-279-0375" +"ListAgentFirstName": "Andy" +"ListAgentKey": "17056259" +"ListAgentKeyNumeric": "17056259" +"ListAgentLastName": "Krotik" +"ListAgentOfficePhone": "209-676-2875" +"ListAgentStateLicense": "01040802" +"ListAgentURL": "www.mercedcountyland.com" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "brian.raymond360@gmail.com" +"ListOfficeFax": "888-279-0375" +"ListOfficeKey": "3277207" +"ListOfficeKeyNumeric": "3277207" +"ListOfficePhone": "209-676-2875" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-05" +"ListingKeyNumeric": 551909889 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA, Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Lawn,Yard" +"LotSizeAcres": 0.21 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 9148.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2021-11-02T12:05:10Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2021-10-08" +"OffMarketTimestamp": "2021-10-08T16:07:02Z" +"OnMarketDate": "2021-10-05" +"OnMarketTimestamp": "2021-10-05T10:37:07Z" +"OriginalEntryTimestamp": "2021-10-05T10:37:07Z" +"OriginalListPrice": 355000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367370974" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "006132019000" +"ParkingFeatures": "Driveway,Garage Faces Front" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Covered,See Remarks" +"PhotosChangeTimestamp": "2022-10-21T21:23:59Z" +"PhotosCount": 49 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "1501" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-09" +"Roof": "Composition" +"RoomType": "Bedroom,Kitchen,Living Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "None" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551909889" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-11-02T12:05:10Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Gary" +"StreetNumber": "3141" +"StreetNumberNumeric": "3141" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "9" +"UniversalPropertyId": "US-06047-N-006132019000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Kitchen,Living Room",\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Shower in Tub",\n "ListingKey": "551909889",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:49 [ …49] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551909889')" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551974377" +"ListingId": "MC21221377" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:52Z" +"RFModificationTimestamp": "2024-10-15T12:50:26.910169+00:00" +"ListPrice": 330000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6778.0 +"LivingArea": 1485.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "2837 Marina Court, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.329233 +"Longitude": -120.542658 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dianna Cowden" +"ListOfficeName": "Keller Williams Property Team" +"ListAgentMlsId": "mccowddi" +"ListOfficeMlsId": "mc1275" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Come and view this great home on a nice corner lot, located in Merced, but a hop, skip, and a jump from Atwater! This home is perfect for the first-time buyers as well as forever home buyers, and anything in between. The home offers an open concept feel with warm mahogany laminate flooring upon entrance, a grand kitchen with ample solid oak cabinetry, plenty of counterspace, and lovely coral/black granite countertops. The master bedroom has a spacious walk-in closet, a master bath with double sinks, 2 more bedrooms and one more bath. 2837 Marina Ct. is conveinetly located near great schools, freeway access and many additional community amenities." +"AccessibilityFeatures": "None" +"ActivationDate": "2021-10-11" +"Appliances": "Dishwasher,Disposal,Gas Oven,Gas Range" +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "MRMLS" +"BuyerAgentEmail": "noemail@email.com" +"BuyerAgentFirstName": "Lindsey" +"BuyerAgentFullName": "Lindsey Hawly" +"BuyerAgentKey": "17113600" +"BuyerAgentKeyNumeric": "17113600" +"BuyerAgentLastName": "Hawly" +"BuyerAgentMlsId": "nonmember" +"BuyerAgentStateLicense": "01733951" +"BuyerBrokerageCompensation": "2.500" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "MRMLS" +"BuyerOfficeEmail": "NONE@CRMLS.ORG" +"BuyerOfficeKey": "3287957" +"BuyerOfficeKeyNumeric": "3287957" +"BuyerOfficeMlsId": "NONMEMBERMRML" +"BuyerOfficeName": "J. Peters Realtors" +"BuyerOfficePhone": "909-859-2040" +"BuyerOfficeURL": "https://go.crmls.org/" +"CLIP": 3724508779 +"CloseDate": "2021-11-19" +"ClosePrice": 325000.0 +"CommonInterest": "None" +"CommonWalls": "2+ Common Walls" +"CommunityFeatures": "Curbs, Suburban, Sidewalks" +"ConstructionMaterials": "Frame,Stucco,Wood Siding" +"ContractStatusChangeDate": "2021-11-19" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T12:50:26.817587+00:00" +"CumulativeDaysOnMarket": 6 +"DaysOnMarket": 6 +"DaysOnMarketReplication": 6 +"DaysOnMarketReplicationDate": "2021-11-19" +"Directions": "North on Santa Fe - Left on Franklin - Right on Bea - Slight Right on the corner of Bea and Marina Ct." +"Electric": "220 Volts in Laundry" +"ElevationUnits": "Feet" +"FireplaceFeatures": "Gas,Living Room" +"FireplaceYN": true +"Flooring": "Laminate" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Forced Air,Natural Gas" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Granite Counters,Pantry,All Bedrooms Down" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-500-4663" +"ListAgentEmail": "dcowdenreagent@gmail.com" +"ListAgentFirstName": "Dianna" +"ListAgentKey": "17166820" +"ListAgentKeyNumeric": "17166820" +"ListAgentLastName": "Cowden" +"ListAgentOfficePhone": "209-500-4663" +"ListAgentStateLicense": "01973917" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "mjawad@kw.com" +"ListOfficeKey": "3778305" +"ListOfficeKeyNumeric": "3778305" +"ListOfficePhone": "209-500-4663" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-06" +"ListingKeyNumeric": 551974377 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to Existing Loan,Conventional,FHA,Submit,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Sprinklers In Rear,Sprinklers In Front" +"LotSizeAcres": 0.1556 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6778.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2021-11-19T15:36:24Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2021-10-17" +"OffMarketTimestamp": "2021-10-17T17:00:32Z" +"OnMarketDate": "2021-10-11" +"OnMarketTimestamp": "2021-10-11T00:30:21Z" +"OriginalEntryTimestamp": "2021-10-06T17:01:12Z" +"OriginalListPrice": 325000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367380013" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "005391009000" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2022-10-22T02:11:03Z" +"PhotosCount": 27 +"PoolFeatures": "None" +"PostalCodePlus4": "9393" +"PreviousListPrice": 325000.0 +"PriceChangeTimestamp": "2021-11-19T15:36:24Z" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-17" +"RoadFrontageType": "City Street" +"Roof": "Asphalt, Shingle" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom" +"SecurityFeatures": "Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Jennifer ( Pira) Lane" +"ShowingContactPhone": "2092614488" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551974377" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2021-10-11" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-11-19T15:15:28Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Marina" +"StreetNumber": "2837" +"StreetNumberNumeric": "2837" +"StreetSuffix": "Court" +"StructureType": "House" +"UniversalPropertyId": "US-06047-N-005391009000-R-N" +"Utilities": "Cable Connected,Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom",\n "RoomBathroomFeatures": "Bathtub,Shower in Tub,Double Sinks in Primary Bath,Exhaust fan(s),Granite Counters",\n "ListingKey": "551974377",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:27 [ …27] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551974377')" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551955924" +"ListingId": "MC21222024" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:52Z" +"RFModificationTimestamp": "2024-10-15T14:46:13.942460+00:00" +"ListPrice": 229000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1324.0 +"LivingArea": 1293.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "1814 Merced Avenue, Merced, California 95341" +"Coordinates": array:2 [ …2] +"Latitude": 37.289843 +"Longitude": -120.455318 +"YearBuilt": 1988 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Katelyn Bennett" +"ListOfficeName": "Tinetti Realty Group" +"ListAgentMlsId": "mcbennka" +"ListOfficeMlsId": "mc76" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Check out this Affordable and Adorable single story Condo located in the Orchard Village Gated Community. This 3Bedroom 2Bathroom is Move In Ready and perfect for any First Time Home Buyer, Investor, or Commuter looking for Quick Freeway Access. The Spacious Livingroom comes complete with a cozy Fireplace and Wood Vinyl Plank flooring that continues on into the hallway and all bedrooms. The Dining and Kitchen area are tiled, and feature a Gas Stove, Pantry, and access to the fenced backyard area. The Owner Suite has walk in closet, attached bathroom with additional cabinetry for storage and stand up shower. End unit close to Gated Pool and Hot Tub Area with lots of parking options. Community HOA Fee covers the roof, water, sewer, garage, building exterior maintenance, grounds + pool maintenance. Located close to schools, shopping, restaurants, and Hwy 99." +"ActivationDate": "2021-10-06" +"AssociationAmenities": "Controlled Access,Maintenance Grounds,Pool,Trash" +"AssociationFee": "275.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Orchard Village" +"AssociationPhone": "209-380-4571" +"AssociationYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-358-0222" +"BuyerAgentEmail": "shernandez@londonproperties.com" +"BuyerAgentFirstName": "Saul" +"BuyerAgentFullName": "Saul Hernandez" +"BuyerAgentKey": "17184493" +"BuyerAgentKeyNumeric": "17184493" +"BuyerAgentLastName": "Hernandez" +"BuyerAgentMlsId": "Mchernsa" +"BuyerAgentStateLicense": "01256344" +"BuyerBrokerageCompensation": "2.250" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "greg@londonproperties.com" +"BuyerOfficeKey": "3279110" +"BuyerOfficeKeyNumeric": "3279110" +"BuyerOfficeMlsId": "mc1060" +"BuyerOfficeName": "London Properties Ltd, Atwater" +"BuyerOfficePhone": "209-358-0222" +"CLIP": 7305838885 +"CloseDate": "2022-01-04" +"ClosePrice": 229000.0 +"CommonInterest": "Condominium" +"CommonWalls": "1 Common Wall" +"CommunityFeatures": "Sidewalks, Gated, Pool" +"ContractStatusChangeDate": "2022-01-04" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T14:46:13.845160+00:00" +"CumulativeDaysOnMarket": 26 +"DaysOnMarket": 26 +"DaysOnMarketReplication": 26 +"DaysOnMarketReplicationDate": "2022-01-04" +"Directions": "As you enter the complex, turn right. Property is a corner unit." +"ElevationUnits": "Feet" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced City" +"InteriorFeatures": "Ceiling Fan(s),High Ceilings" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Closet" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-384-3885" +"ListAgentEmail": "katelyn@mercedrealestate.com" +"ListAgentFax": "209-384-3889" +"ListAgentFirstName": "Katelyn" +"ListAgentKey": "17155746" +"ListAgentKeyNumeric": "17155746" +"ListAgentLastName": "Bennett" +"ListAgentOfficePhone": "209-384-3885" +"ListAgentStateLicense": "01921724" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "Nancy@Merced Real Estate.com" +"ListOfficeFax": "209-384-3889" +"ListOfficeKey": "3278063" +"ListOfficeKeyNumeric": "3278063" +"ListOfficePhone": "209-384-3885" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-05" +"ListingKeyNumeric": 551955924 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.0304 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 1324.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2022-01-04T08:37:20Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsInCommunity": 40 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2021-11-11" +"OffMarketTimestamp": "2021-11-11T07:56:49Z" +"OnMarketDate": "2021-10-06" +"OnMarketTimestamp": "2021-11-08T09:49:05Z" +"OriginalEntryTimestamp": "2021-10-06T11:05:38Z" +"OriginalListPrice": 229000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367376064" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "035170031000" +"PhotosChangeTimestamp": "2022-10-21T07:27:41Z" +"PhotosCount": 21 +"PoolFeatures": "Community, Association" +"PostalCodePlus4": "5371" +"PriceChangeTimestamp": "2021-10-06T11:05:38Z" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Condominium" +"PurchaseContractDate": "2021-11-11" +"RoomType": "Living Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Security Gate,Gated Community,Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "None" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551955924" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2021-10-06" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2022-01-04T08:37:20Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Merced" +"StreetNumber": "1814" +"StreetNumberNumeric": "1814" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "40B" +"UniversalPropertyId": "US-06047-N-035170031000-R-N" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-2" +"CustomFields": """ {\n "RoomType": "Living Room",\n "ListingKey": "551955924",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:21 [ …21] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551955924')" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551864501" +"ListingId": "MC21219562" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:28Z" +"RFModificationTimestamp": "2024-10-15T19:20:16.224918+00:00" +"ListPrice": 190000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 8276.0 +"LivingArea": 1019.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95341" +"UnparsedAddress": "1675 Union Avenue, Merced, California 95341" +"Coordinates": array:2 [ …2] +"Latitude": 37.293268 +"Longitude": -120.462703 +"YearBuilt": 1946 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jennifer Tripp" +"ListOfficeName": "BHGRE Everything Real Estate" +"ListAgentMlsId": "mctripje" +"ListOfficeMlsId": "mc294" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Here is a perfect opportunity to purchase an affordable house and make it your own. Welcoming all investors too." +"BathroomsFull": 1 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-777-9768" +"BuyerAgentEmail": "jennifertripp.realestate@gmail.com" +"BuyerAgentFirstName": "Jennifer" +"BuyerAgentFullName": "Jennifer Tripp" +"BuyerAgentKey": "17275086" +"BuyerAgentKeyNumeric": "17275086" +"BuyerAgentLastName": "Tripp" +"BuyerAgentMlsId": "mctripje" +"BuyerAgentStateLicense": "02068362" +"BuyerBrokerageCompensation": "2.500" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Cash" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "info@everythingbhgre.com" +"BuyerOfficeKey": "3278043" +"BuyerOfficeKeyNumeric": "3278043" +"BuyerOfficeMlsId": "mc294" +"BuyerOfficeName": "BHGRE Everything Real Estate" +"BuyerOfficePhone": "209-383-7653" +"BuyerOfficeURL": "http://www.everythingbhgre.com" +"CLIP": 9216081354 +"CloseDate": "2021-10-27" +"ClosePrice": 180000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights" +"CompensationComments": "Register Your Buyers" +"ContractStatusChangeDate": "2021-10-27" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T19:20:16.129248+00:00" +"DaysOnMarketReplicationDate": "2021-10-28" +"Directions": "From Yosemite Parkway turn south on Union. House is on the right." +"ElevationUnits": "Feet" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "All Bedrooms Down" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-777-9768" +"ListAgentEmail": "jennifertripp.realestate@gmail.com" +"ListAgentFirstName": "Jennifer" +"ListAgentKey": "17275086" +"ListAgentKeyNumeric": "17275086" +"ListAgentLastName": "Tripp" +"ListAgentOfficePhone": "209-383-7653" +"ListAgentStateLicense": "02068362" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "info@everythingbhgre.com" +"ListOfficeFax": "209-722-5406" +"ListOfficeKey": "3278043" +"ListOfficeKeyNumeric": "3278043" +"ListOfficePhone": "209-383-7653" +"ListOfficeURL": "http://www.everythingbhgre.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-04" +"ListingKeyNumeric": 551864501 +"ListingService": "Full Service" +"ListingTerms": "Cash" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.19 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8276.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2021-10-27T17:43:02Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2021-10-04" +"OffMarketTimestamp": "2021-10-04T12:49:56Z" +"OnMarketDate": "2021-10-04" +"OnMarketTimestamp": "2021-10-04T11:46:03Z" +"OriginalEntryTimestamp": "2021-10-04T11:46:03Z" +"OriginalListPrice": 190000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367366338" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "035064012000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2021-12-08T03:33:52Z" +"PhotosCount": 1 +"PoolFeatures": "None" +"PostalCodePlus4": "5159" +"PropertyCondition": "Fixer" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-04" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551864501" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-10-27T17:43:02Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Union" +"StreetNumber": "1675" +"StreetNumberNumeric": "1675" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "6" +"UniversalPropertyId": "US-06047-N-035064012000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Private" +"YearBuiltSource": "Appraiser" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "ListingKey": "551864501",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:1 [ …1] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551864501')" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551877760" +"ListingId": "MC21220557" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:28Z" +"RFModificationTimestamp": "2024-10-15T18:30:55.189568+00:00" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6909.0 +"LivingArea": 1752.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "1111 E Donna Drive, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.328712 +"Longitude": -120.457681 +"YearBuilt": 1989 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Josh Anastasio" +"ListOfficeName": "London Properties Ltd - Merced" +"ListAgentMlsId": "mcanasjo" +"ListOfficeMlsId": "mc524" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Location! Location! Location! In North Merced, just minutes away from UC Merced and just walking distance from plenty of commercial real estate, lies this gorgeous 3 bed/2 bath w/ a pool and OWNED SOLAR! The solar panels were installed back in 2015 when the roof and HVAC system were replaced. They produce approx 12 MWh annually. The property features a desert style front yard. The living room is enhanced with high ceilings, crown molding and a lovely marble & granite fireplace. There is a very delightful view of the backyard through the french doors and windows while sitting at the breakfast bar or from the dining room. The kitchen is equipped with granite counter tops and the electric range, refrigerator and dishwasher are included. The master bedroom has beautiful decorative tile and a nice personal touch w/ a partially enclosed creative space right outside on the patio. A very cozy backyard supplied w/ a pool and an island bar w/ granite counter tops and a sink underneath a pergola completes this property! This is truly a MUST SEE! Don't miss out!" +"Appliances": "Dishwasher,Disposal,Gas Water Heater,Microwave,Refrigerator,Self Cleaning Oven,Vented Exhaust Fan,Water To Refrigerator,Dryer,Washer" +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-722-5400" +"BuyerAgentEmail": "stephaniemercedyosemiterealty@gmail.com" +"BuyerAgentFirstName": "Stephanie" +"BuyerAgentFullName": "Stephanie Jaurique" +"BuyerAgentKey": "17273825" +"BuyerAgentKeyNumeric": "17273825" +"BuyerAgentLastName": "Jaurique" +"BuyerAgentMlsId": "mcjaurst" +"BuyerAgentStateLicense": "01929251" +"BuyerBrokerageCompensation": "3.000" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "info@everythingbhgre.com" +"BuyerOfficeKey": "3278043" +"BuyerOfficeKeyNumeric": "3278043" +"BuyerOfficeMlsId": "mc294" +"BuyerOfficeName": "BHGRE Everything Real Estate" +"BuyerOfficePhone": "209-383-7653" +"BuyerOfficeURL": "http://www.everythingbhgre.com" +"CLIP": 8340145302 +"CloseDate": "2022-01-14" +"ClosePrice": 430000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Gutter(s),Storm Drain(s),Street Lights,Sidewalks,Park" +"ConstructionMaterials": "Drywall,HardiPlank Type,Concrete" +"ContractStatusChangeDate": "2022-01-14" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T18:30:55.078188+00:00" +"CumulativeDaysOnMarket": 65 +"DaysOnMarket": 65 +"DaysOnMarketReplication": 65 +"DaysOnMarketReplicationDate": "2022-01-19" +"Directions": "N on G Street, R on Donna" +"DocumentsChangeTimestamp": "2021-10-05T15:57:24Z" +"DocumentsCount": 2 +"Electric": "220 Volts in Kitchen,Photovoltaics Seller Owned" +"ElevationUnits": "Feet" +"Fencing": "Wood" +"FireplaceFeatures": "Living Room,Wood Burning" +"FireplaceYN": true +"Flooring": "Laminate, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Crown Molding,Separate/Formal Dining Room,Granite Counters,High Ceilings,Open Floorplan,Pantry,Pull Down Attic Stairs,All Bedrooms Down,Bedroom on Main Level,Main Level Primary" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup,Inside,Laundry Closet" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-725-2100" +"ListAgentEmail": "josha@londonproperties.com" +"ListAgentFirstName": "Josh" +"ListAgentKey": "18480037" +"ListAgentKeyNumeric": "18480037" +"ListAgentLastName": "Anastasio" +"ListAgentOfficePhone": "209-725-2100" +"ListAgentStateLicense": "02107840" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "greg@londonproperties.com" +"ListOfficeFax": "209-722-8181" +"ListOfficeKey": "3278096" +"ListOfficeKeyNumeric": "3278096" +"ListOfficePhone": "209-725-2100" +"ListingAgreement": "Seller Reserved" +"ListingContractDate": "2021-10-04" +"ListingKeyNumeric": 551877760 +"ListingService": "Full Service" +"ListingTerms": "Cash, Submit" +"LivingAreaSource": "Public Records" +"LotFeatures": "Desert Front,Drip Irrigation/Bubblers,Near Park,Rectangular Lot" +"LotSizeAcres": 0.1586 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 6909.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2022-01-19T08:44:39Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Tenant" +"OffMarketDate": "2021-12-08" +"OffMarketTimestamp": "2021-12-09T10:23:07Z" +"OnMarketDate": "2021-10-04" +"OnMarketTimestamp": "2021-10-04T15:37:46Z" +"OriginalEntryTimestamp": "2021-10-04T15:37:46Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367368036" +"OriginatingSystemSubName": "CRMLS_CRM" +"OtherStructures": "Gazebo" +"ParcelNumber": "006366001000" +"ParkingFeatures": "Converted Garage,Driveway,Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete,Covered,Front Porch" +"PhotosChangeTimestamp": "2023-11-27T00:30:15Z" +"PhotosCount": 41 +"PoolFeatures": "Gunite, Pebble, Private, Tile" +"PoolPrivateYN": true +"Possession": "Negotiable" +"PostalCodePlus4": "0679" +"PriceChangeTimestamp": "2021-10-04T15:37:46Z" +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-12-08" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Converted Bedroom,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Dining Room" +"SecurityFeatures": "Security System,Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Josh" +"ShowingContactPhone": "(209) 201-7057" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551877760" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2022-01-19T08:44:39Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "Donna" +"StreetNumber": "1111" +"StreetNumberNumeric": "1111" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "84" +"UniversalPropertyId": "US-06047-N-006366001000-R-N" +"Utilities": "Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Water Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Blinds,Double Pane Windows" +"YearBuiltSource": "Public Records" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Converted Bedroom,Kitchen,Laundry,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom",\n "EatingArea": "Breakfast Counter / Bar,Dining Room",\n "RoomKitchenFeatures": "Granite Counters",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub",\n "ListingKey": "551877760",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:41 [ …41] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551877760')" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551873902" +"ListingId": "MC21166813" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:28Z" +"RFModificationTimestamp": "2024-10-15T18:46:48.372824+00:00" +"ListPrice": 275000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 11326.0 +"LivingArea": 1285.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95348" +"UnparsedAddress": "3301 Bismark Drive, Merced, California 95348" +"Coordinates": array:2 [ …2] +"Latitude": 37.323089 +"Longitude": -120.498559 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Veronica Escobar" +"ListOfficeName": "Realty Executives Of Merced" +"ListAgentMlsId": "MCESCOVE" +"ListOfficeMlsId": "MC188" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Great property in an established neighborhood, the home offers 3 bedrooms, 2 baths, and 1,285 sq. ft. of living space. The floor plan consists of a spacious family room, a large dining room with a cozy brick fireplace that is open to the kitchen, good size bedrooms, and tiled flooring throughout. The backyard is oversized with plenty of space to entertain and enough room for a pool. Located near restaurants, shopping, a park, and grocery stores. Schedule your showing today!" +"Appliances": "Electric Oven,Microwave" +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "Merced County" +"BuyerAgentDirectPhone": "209-385-8500" +"BuyerAgentEmail": "allenbrooks@realtyexecutives.com" +"BuyerAgentFirstName": "Allen" +"BuyerAgentFullName": "Allen Brooks" +"BuyerAgentKey": "17313105" +"BuyerAgentKeyNumeric": "17313105" +"BuyerAgentLastName": "Brooks" +"BuyerAgentMlsId": "mcbrooal" +"BuyerAgentStateLicense": "01954892" +"BuyerBrokerageCompensation": "2.000" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Cash" +"BuyerOfficeAOR": "Merced County" +"BuyerOfficeEmail": "mercedexecutives@gmail.com" +"BuyerOfficeKey": "3278012" +"BuyerOfficeKeyNumeric": "3278012" +"BuyerOfficeMlsId": "MC188" +"BuyerOfficeName": "Realty Executives Of Merced" +"BuyerOfficePhone": "209-385-8500" +"BuyerOfficeURL": "http://www.realtyexecutives.com" +"CLIP": 8953503338 +"CloseDate": "2021-12-27" +"ClosePrice": 285000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Sidewalks" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2021-12-27" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T18:46:48.269675+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2021-12-27" +"Directions": "Head west on El Portal Dr toward G St 0.3 mi Turn right onto Campus Dr 259 ft Turn left onto Buena Vista Dr 0.3 mi Turn left onto M St/Veterans Blvd 0.3 mi Turn right onto Loughborough Dr 1.1 mi Turn right onto Bismarck Dr" +"ElevationUnits": "Feet" +"FireplaceFeatures": "Dining Room" +"FireplaceYN": true +"Flooring": "Laminate, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Ceiling Fan(s),Tile Counters" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-385-8500" +"ListAgentEmail": "therandyhayerteam@gmail.com" +"ListAgentFax": "209-385-8505" +"ListAgentFirstName": "Veronica" +"ListAgentKey": "17024522" +"ListAgentKeyNumeric": "17024522" +"ListAgentLastName": "Escobar" +"ListAgentOfficePhone": "209-385-8500" +"ListAgentStateLicense": "N/A" +"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": "2021-10-04" +"ListingKeyNumeric": 551873902 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Yard" +"LotSizeAcres": 0.26 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 11326.0 +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2021-12-27T11:29:54Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Tenant" +"OffMarketDate": "2021-10-12" +"OffMarketTimestamp": "2021-10-13T11:47:23Z" +"OnMarketDate": "2021-10-04" +"OnMarketTimestamp": "2021-10-04T14:14:16Z" +"OriginalEntryTimestamp": "2021-10-04T14:14:16Z" +"OriginalListPrice": 275000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367367453" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "058052011000" +"ParkingFeatures": "Garage Faces Front,Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "None" +"PhotosChangeTimestamp": "2022-10-20T02:22:10Z" +"PhotosCount": 16 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "1102" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-12" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Family Room,Kitchen" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551873902" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-12-27T11:29:54Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Bismark" +"StreetNumber": "3301" +"StreetNumberNumeric": "3301" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "97" +"UniversalPropertyId": "US-06047-N-058052011000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Public Records" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Family Room,Kitchen",\n "EatingArea": "Area,In Family Room",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Shower in Tub,Walk-in shower",\n "ListingKey": "551873902",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:16 [ …16] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551873902')" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "551867627" +"ListingId": "MC21220305" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:28Z" +"RFModificationTimestamp": "2024-10-15T19:08:14.237061+00:00" +"ListPrice": 265000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 5227.0 +"LivingArea": 901.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "259 E 19th Street, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.299567 +"Longitude": -120.470303 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Armando Diaz" +"ListOfficeName": "Soldavi Inc." +"ListAgentMlsId": "MCDIAZAR" +"ListOfficeMlsId": "mc972" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Flexible living infuses with enchanting character in this lovely 2 bedroom, 1 bath home of 90a sq. ft. which resides on over a 5,227 sq. ft. lot . This home also grants easy commuting access to Hwy 99, as well as Downtown Merced and is within close proximity to shopping and great schools. Make an appt. today to view for yourself and submit your offer before it's sold!!" +"Appliances": "Gas Range,Microwave" +"ArchitecturalStyle": "Bungalow" +"BathroomsFull": 1 +"BuyerAgentAOR": "Fresno" +"BuyerAgentEmail": "lindaparks@realtyconcepts.com" +"BuyerAgentFirstName": "Linda" +"BuyerAgentFullName": "Linda Parks" +"BuyerAgentKey": "18130983" +"BuyerAgentKeyNumeric": "18130983" +"BuyerAgentLastName": "Parks" +"BuyerAgentMlsId": "fr23190" +"BuyerAgentStateLicense": "02052142" +"BuyerBrokerageCompensation": "2.500" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "Fresno" +"BuyerOfficeEmail": "dvanputten@guarantee.com" +"BuyerOfficeKey": "3248288" +"BuyerOfficeKeyNumeric": "3248288" +"BuyerOfficeMlsId": "fr51003" +"BuyerOfficeName": "Guarantee Real Estate" +"BuyerOfficePhone": "5596506030" +"CLIP": 8036833669 +"CloseDate": "2021-11-10" +"ClosePrice": 285000.0 +"CoListAgentAOR": "Merced County" +"CoListAgentDirectPhone": "209-383-3000" +"CoListAgentEmail": "sandradoke209@gmail.com" +"CoListAgentFax": "888-241-3220" +"CoListAgentFirstName": "Sandra" +"CoListAgentFullName": "Sandra Doke" +"CoListAgentKey": "17122930" +"CoListAgentKeyNumeric": "17122930" +"CoListAgentLastName": "Doke" +"CoListAgentMlsId": "mcdokesa" +"CoListAgentOfficePhone": "209-383-3000" +"CoListAgentStateLicense": "01906746" +"CoListOfficeAOR": "Merced County" +"CoListOfficeEmail": "info@soldavi.com" +"CoListOfficeFax": "888-241-3220" +"CoListOfficeKey": "3279367" +"CoListOfficeKeyNumeric": "3279367" +"CoListOfficeMlsId": "mc972" +"CoListOfficeName": "Soldavi Inc." +"CoListOfficePhone": "209-383-3000" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Sidewalks" +"ConstructionMaterials": "Cement Siding,Frame,Stucco" +"ContractStatusChangeDate": "2021-11-10" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T19:08:14.147383+00:00" +"CumulativeDaysOnMarket": 7 +"DaysOnMarket": 7 +"DaysOnMarketReplication": 7 +"DaysOnMarketReplicationDate": "2021-11-12" +"Directions": "South on G Street, left on E. 20th Street, right on E Street, left on E. 19th Street" +"DoorFeatures": "Panel Doors" +"Electric": "220 Volts in Laundry" +"ElevationUnits": "Feet" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "Chain Link,Wood" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Vinyl" +"FoundationDetails": "Raised" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central,Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Ceiling Fan(s),Granite Counters,Recessed Lighting,All Bedrooms Down" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-777-9955" +"ListAgentEmail": "a.diaz@soldavi.com" +"ListAgentFax": "888-241-3220" +"ListAgentFirstName": "Armando" +"ListAgentKey": "17103808" +"ListAgentKeyNumeric": "17103808" +"ListAgentLastName": "Diaz" +"ListAgentOfficePhone": "209-383-3000" +"ListAgentStateLicense": "01496803" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "info@soldavi.com" +"ListOfficeFax": "888-241-3220" +"ListOfficeKey": "3279367" +"ListOfficeKeyNumeric": "3279367" +"ListOfficePhone": "209-383-3000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-01" +"ListingKeyNumeric": 551867627 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA, Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Sprinklers In Rear,Sprinklers In Front,Lawn,Landscaped" +"LotSizeAcres": 0.12 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5227.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2021-11-12T09:10:13Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2021-10-11" +"OffMarketTimestamp": "2021-10-12T09:20:31Z" +"OnMarketDate": "2021-10-04" +"OnMarketTimestamp": "2021-10-04T12:17:32Z" +"OriginalEntryTimestamp": "2021-10-04T12:17:32Z" +"OriginalListPrice": 265000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367366568" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "034141008000" +"ParkingFeatures": "Concrete,Door-Single,Driveway,Garage Faces Front,Garage" +"ParkingTotal": "1.0" +"PatioAndPorchFeatures": "Front Porch" +"PhotosChangeTimestamp": "2022-10-22T01:09:27Z" +"PhotosCount": 31 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "5008" +"PriceChangeTimestamp": "2021-10-04T12:17:32Z" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-11" +"Roof": "Composition,Ridge Vents,Shingle" +"RoomType": "Bedroom,Kitchen,Living Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Unknown" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "551867627" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-11-12T09:10:13Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "19th" +"StreetNumber": "259" +"StreetNumberNumeric": "259" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "10" +"UniversalPropertyId": "US-06047-N-034141008000-R-N" +"Utilities": "Sewer Connected" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Kitchen,Living Room",\n "EatingArea": "Area",\n "RoomBathroomFeatures": "Shower in Tub",\n "ListingKey": "551867627",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:31 [ …31] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('551867627')" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "550923562" +"ListingId": "MC21219874" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2022-03-22T15:05:28Z" +"RFModificationTimestamp": "2024-10-15T20:18:09.899334+00:00" +"ListPrice": 289000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 8276.0 +"LivingArea": 878.0 +"BuildingAreaTotal": 0 +"City": "Merced" +"PostalCode": "95340" +"UnparsedAddress": "1099 Barney Street, Merced, California 95340" +"Coordinates": array:2 [ …2] +"Latitude": 37.300316 +"Longitude": -120.458558 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa Hughes" +"ListOfficeName": "S.A. Jones Land Company" +"ListAgentMlsId": "mchughli" +"ListOfficeMlsId": "MC53" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "THE PERFECT LITTLE HOME...that's what you'll find upon entering this perfectly remodeled home on huge lot. This 3 bedroom home has been redone top-to-bottom with new roof and hvac system, new instant water heater and new exterior paint, windows, new flooring and cabinetry throughout. The kitchen offers granite counter tops and GE Appiances. New landscaping with sprinklers. The detached garage has new metal roll-up door and big work shop area. This beauty is ready for a new family." +"Appliances": "Dishwasher,Gas Range,Microwave" +"BathroomsFull": 1 +"BuyerAgentAOR": "MRMLS" +"BuyerAgentEmail": "noemail@email.com" +"BuyerAgentFirstName": "General" +"BuyerAgentFullName": "General NONMEMBER" +"BuyerAgentKey": "17113600" +"BuyerAgentKeyNumeric": "17113600" +"BuyerAgentLastName": "NONMEMBER" +"BuyerAgentMlsId": "Nonmember" +"BuyerAgentStateLicense": "02014055" +"BuyerBrokerageCompensation": "3.000" +"BuyerBrokerageCompensationType": "%" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "MRMLS" +"BuyerOfficeEmail": "NONE@CRMLS.ORG" +"BuyerOfficeKey": "3287957" +"BuyerOfficeKeyNumeric": "3287957" +"BuyerOfficeMlsId": "NONMEMBERMRML" +"BuyerOfficeName": "NONMEMBER MRML" +"BuyerOfficePhone": "909-859-2040" +"BuyerOfficeURL": "https://go.crmls.org/" +"CLIP": 4066494345 +"CarportYN": true +"CloseDate": "2021-11-12" +"ClosePrice": 291000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights" +"ContractStatusChangeDate": "2021-11-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Merced" +"CreationDate": "2024-10-15T20:18:09.785929+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2021-11-12" +"Directions": "please use gps" +"ElevationUnits": "Feet" +"Fencing": "Wood" +"FireplaceFeatures": "None" +"Flooring": "Carpet, Laminate" +"FoundationDetails": "Raised" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Merced Union" +"InteriorFeatures": "Ceiling Fan(s)" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside, Stacked" +"Levels": "One" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "559-665-1306" +"ListAgentEmail": "lisa_hughes7@yahoo.com" +"ListAgentFax": "559-665-1304" +"ListAgentFirstName": "Lisa" +"ListAgentKey": "17027465" +"ListAgentKeyNumeric": "17027465" +"ListAgentLastName": "Hughes" +"ListAgentOfficePhone": "559-665-1306" +"ListAgentStateLicense": "01107156" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "sajonesland@gmail.com" +"ListOfficeFax": "559-665-1304" +"ListOfficeKey": "3278097" +"ListOfficeKeyNumeric": "3278097" +"ListOfficePhone": "559-665-1306" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2021-10-03" +"ListingKeyNumeric": 550923562 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Front Yard,Landscaped" +"LotSizeAcres": 0.19 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8276.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2021-11-12T11:59:57Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2021-10-05" +"OffMarketTimestamp": "2021-10-07T17:43:48Z" +"OnMarketDate": "2021-10-03" +"OnMarketTimestamp": "2021-10-03T17:32:35Z" +"OriginalEntryTimestamp": "2021-10-03T17:32:35Z" +"OriginalListPrice": 289000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "367364470" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "034041018000" +"ParkingFeatures": "Carport,Garage Faces Front" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2022-10-20T09:27:24Z" +"PhotosCount": 24 +"PoolFeatures": "None" +"PostalCodePlus4": "4045" +"PriceChangeTimestamp": "2021-10-03T17:32:35Z" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2021-10-05" +"Roof": "Composition,See Remarks" +"RoomType": "Kitchen,Living Room" +"Sewer": "Public Sewer" +"ShowingContactType": "None" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "550923562" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2021-11-12T11:59:57Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Barney" +"StreetNumber": "1099" +"StreetNumberNumeric": "1099" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "4" +"UniversalPropertyId": "US-06047-N-034041018000-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1-6" +"CustomFields": """ {\n "RoomType": "Kitchen,Living Room",\n "EatingArea": "Area",\n "RoomKitchenFeatures": "Granite Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Shower in Tub,Granite Counters,Remodeled",\n "ListingKey": "550923562",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"Media": array:24 [ …24] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('550923562')" } ] +success: true +page_size: 10 +page_count: 162 +count: 1612 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5444 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5443 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112308116" +"ListingId": "25531679" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:19.378602+00:00" +"ListPrice": 414500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5320.0 +"LivingArea": 726.0 +"BuildingAreaTotal": 726.0 +"City": "San Bernardino" +"PostalCode": "92411" +"UnparsedAddress": "1256 W 6th Street, San Bernardino, California 92411" +"Coordinates": array:2 [ …2] +"Latitude": 34.110461 +"Longitude": -117.312781 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eran Fattal" +"ListOfficeName": "Dynasty Real Estate" +"ListAgentMlsId": "CLW-C103971" +"ListOfficeMlsId": "CLW-X78890" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "REMODELED FHA APPROVED HOME: 3 BEDS PLUS 1.5 BATH. (PUBLIC RECORDS SHOW 2 PLUS 1) NEW DUAL PANE WINDOWS. REPLACED CENTRAL AIR AND HEAT. NEW CUSTOM PORCELAIN TILE FLOORING IN KITCHEN, LIVING ROOM, BATHROOMS, AND LAUNDRY ROOM. NEW GRAY RUSTIC STYLE LAMINATE FLOORING IN BEDROOMS. THE KITCHEN IS BRAND NEW. NEW CUSTOM KITCHEN CABINETS, NEW QUARTZ STONE COUNTERS, NEW GARBAGE DISPOSAL, NEW PULL-OUT FAUCET. NEW BATHTUB, NEW TILED UP SHOWERS WALLS WITH ELEGANT MOSAIC DESIGN, NEW VANITIES. NEW TOILETS. ALL NEW PLUMBING FIXTURES. NEW LIGHT FIXTURES. NEW PAINT INSIDE AND OUT. NEW GARAGE DOOR. FHA/VA/DOWN PAYMENT ASSISTANCE/OK" +"Appliances": "Disposal" +"ArchitecturalStyle": "See Remarks" +"BathroomsFull": 1 +"BuyerFinancing": "Conventional, FHA, VA" +"CLIP": 8804738686 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-29T19:32:38.644803+00:00" +"DaysOnMarket": 46 +"DaysOnMarketReplication": 46 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "PLEASE REFER TO GOOGLE MAPS" +"FireplaceFeatures": "None" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Out of Area Board" +"ListAgentDirectPhone": "747-343-1266" +"ListAgentEmail": "eranfattal@icloud.com" +"ListAgentFax": "909-373-2515" +"ListAgentFirstName": "Eran" +"ListAgentKey": "17056852" +"ListAgentKeyNumeric": "17056852" +"ListAgentLastName": "Fattal" +"ListAgentOfficePhone": "909-373-2505" +"ListAgentStateLicense": "01304180" +"ListOfficeAOR": "Out of Area Board" +"ListOfficeFax": "909-373-2515" +"ListOfficeKey": "3237841" +"ListOfficeKeyNumeric": "3237841" +"ListOfficePhone": "909-373-2505" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112308116 +"ListingService": "Entry Only" +"LotSizeAcres": 0.1221 +"LotSizeDimensions": "38x140" +"LotSizeSquareFeet": 5320.0 +"MLSAreaMajor": "274 - San Bernardino" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T04:31:51Z" +"OriginalEntryTimestamp": "2025-04-29T11:17:09Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374319567" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "0138052070000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-29T20:25:39Z" +"PhotosCount": 8 +"PoolFeatures": "None" +"PostalCodePlus4": "2705" +"PreviousListPrice": 425000.0 +"PriceChangeTimestamp": "2025-06-14T16:51:35Z" +"PropertySubTypeAdditional": "Single Family Residence" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112308116" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-29T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "6th" +"StreetNumber": "1256" +"StreetNumberNumeric": "1256" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06071-N-0138052070000-R-N" +"View": "None" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112308116"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112308116')" +"CurrentPrice": 414500.0 +"provider_name": "CRMLS" +"RecordSignature": -791365164 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0138052070000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "113814" +"OriginatingSystemListAgentMemberKey": "442704" +"Media": array:8 [ …8] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5630 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112991539" +"ListingId": "ML82006135" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:32.027614+00:00" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 4.25 +"LivingArea": 950.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "38500 Paseo Padre Pkwy 102, Fremont, California 94536" +"Coordinates": array:2 [ …2] +"Latitude": 37.55788739 +"Longitude": -121.98683642 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nisha Singh" +"ListOfficeName": "eXp Realty of California Inc" +"ListAgentMlsId": "ML5101215" +"ListOfficeMlsId": "ML5009355" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover modern living in heart of Fremont in the highly desirable Parkmont neighborhood! This spacious condo has an ideal floor plan that includes a large living room, sizable bedrooms, kitchen and a formal dining area. Parkmont Gardens community includes ideal amenities including a lush greenbelt and a swimming pool! This home is in an excellent commuter location, walking distance from BART and nearby Centerville Train Station, 880 freeway, 680 freeway and Niles Canyon. Around the corner from multiple shopping centers, Whole Foods, Centerville Community Park, Alameda Creek Trail, great schools and beloved local eateries! This home is a must see!" +"Appliances": "Gas Cooktop,Refrigerator" +"AssociationAmenities": "Trash" +"AssociationFee": "550.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Parkmont Gardens HOA" +"AssociationPhone": "925-495-4545" +"AssociationYN": true +"BathroomsFull": 1 +"CLIP": 8478246755 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-09T04:14:15.565194+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: paseo padre" +"Flooring": "Carpet" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Wall Furnace" +"HeatingYN": true +"HighSchoolDistrict": "Alameda City Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentEmail": "nishasingh@gmail.com" +"ListAgentFirstName": "Nisha" +"ListAgentKey": "24251205" +"ListAgentKeyNumeric": "24251205" +"ListAgentLastName": "Singh" +"ListAgentOfficePhone": "(888) 584-942..." +"ListAgentStateLicense": "01937867" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "925-262-1171" +"ListOfficeKey": "4763658" +"ListOfficeKeyNumeric": "4763658" +"ListOfficePhone": "(888) 584-942..." +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112991539 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0001 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4.25 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T13:48:49Z" +"OriginalEntryTimestamp": "2025-05-08T13:21:18Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374380809" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "501153439" +"ParkingFeatures": "Covered,Off Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T18:36:45Z" +"PhotosCount": 7 +"PoolFeatures": "In Ground" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Other" +"Sewer": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112991539" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-08T13:21:18Z" +"StreetName": "Paseo Padre Pkwy" +"StreetNumber": "38500" +"StreetNumberNumeric": "38500" +"UnitNumber": "102" +"UniversalPropertyId": "US-06001-N-501153439-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "Residential" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1112991539"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112991539')" +"CurrentPrice": 499000.0 +"provider_name": "CRMLS" +"RecordSignature": -1685891191 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:501153439" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558053" +"OriginatingSystemListAgentMemberKey": "372906814" +"Media": array:7 [ …7] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5626 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115044718" +"ListingId": "OC25127680" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:47.363769+00:00" +"ListPrice": 5700000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13503.6 +"LivingArea": 2047.0 +"BuildingAreaTotal": 0 +"City": "Corona Del Mar" +"PostalCode": "92625" +"UnparsedAddress": "4621 Hampden Rd, Corona Del Mar, California 92625" +"Coordinates": array:2 [ …2] +"Latitude": 33.589326 +"Longitude": -117.859593 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lynn Paris" +"ListOfficeName": "Pinnacle Real Estate Group" +"ListAgentMlsId": "OCPARILYN" +"ListOfficeMlsId": "OC06746" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Elegant Coastal Living | Beautifully Remodeled Home in the Coveted Cameo Shores Community! As a resident of Cameo Shores, you enjoy exclusive access to the stunning private beaches, unlocked by your key to two separate entrances. These beaches are not only breathtaking, featuring incredible rock formations, but also offer a sense of privacy that's hard to find elsewhere. Additionally, residents can take advantage of scenic beach trails that meander through the picturesque Pelican Hill Golf Course, providing a perfect blend of nature and recreation. The unique pathways in the community connect you seamlessly to Third Beach in Corona del Mar and Crystal Cove State Beach, allowing for easy enjoyment of walking and surfing. Ultimately, you also have the opportunity to explore the beautiful Crystal Cove State Park, as well as the charming Village of Corona Del Mar, thereby enhancing your coastal living experience.\r\r\n This stunning property is situated on a rare 0.31-acre lot with great appreciation potential, Nestled in a private corner, this home features a tranquil backyard, front yard, and side yard that ensure ample natural light and privacy. Floor-to-ceiling windows beautifully integrate the natural landscape of the yard with the open-concept layout. The spacious design includes a large kitchen, a generous master suite, two additional bedrooms, a home office, and an outdoor dining terrace, all thoughtfully arranged. The garage and front yard provide convenient parking options. The entire home has undergone extensive renovation and upgrading.\r\r\n .A significant highlight is the rare 0.31-acre lot, which offers the potential for an ADU expansion or the construction of a new luxury home up to 8,000 square feet, complete with architect-designed plans included. This property presents tremendous potential for appreciation.\r\r\n Community Amenities: The private park and playground in Cameo Shores provide a safe space for families, allowing children and pets to play freely.\r\r\n Excellent School District: Rated 10/10, offering outstanding educational resources.Low Property HOA: Only $1,050 per year. For more details please don't hesitate to contact Lynn Paris at 949-351-1343. """ +"AssociationAmenities": "Dog Park,Golf Course,Jogging Path,Management,Barbecue,Picnic Area,Playground,Guard,Security,Trail(s)" +"AssociationFee": "1050.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Powerstone Property Management" +"AssociationPhone": "9493724022" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-351-1343" +"BathroomsFull": 3 +"CLIP": 6289835863 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Dog Park" +"Contingency": "N" +"ContractStatusChangeDate": "2024-06-01" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-07T06:26:21.386886+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "N/A" +"DocumentsChangeTimestamp": "2025-06-08T09:24:52Z" +"DocumentsCount": 1 +"ElementarySchool": "Harbor View" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Newport Harbor" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "lynnlinparis@gmail.com" +"ListAgentFirstName": "Lynn" +"ListAgentKey": "21318104" +"ListAgentKeyNumeric": "21318104" +"ListAgentLastName": "Paris" +"ListAgentOfficePhone": "626-888-9808" +"ListAgentStateLicense": "02193706" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "usnationalrealty@gmail.com" +"ListOfficeFax": "626-986-5345" +"ListOfficeKey": "3275512" +"ListOfficeKeyNumeric": "3275512" +"ListOfficePhone": "626-888-9808" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-01" +"ListingKeyNumeric": 1115044718 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,1031 Exchange" +"LivingAreaSource": "Public Records" +"LotFeatures": "Sprinklers In Front,Sprinklers On Side,Value In Land" +"LotSizeAcres": 0.31 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 13503.6 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-06T23:02:41Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Corona Del Mar" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "3" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T23:02:41Z" +"OriginalEntryTimestamp": "2025-06-06T23:02:41Z" +"OriginalListPrice": 5700000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374548978" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "47505411" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-08T16:33:40Z" +"PhotosCount": 42 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office" +"Sewer": "Public Sewer" +"ShowingContactName": "Lynn Paris" +"ShowingContactPhone": "9493511343" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115044718" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T23:02:41Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Hampden Rd" +"StreetNumber": "4621" +"StreetNumberNumeric": "4621" +"StructureType": "House" +"TaxLot": "n" +"UniversalPropertyId": "US-06059-N-47505411-R-N" +"View": "Park/Greenbelt,Golf Course,Ocean,Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://www.wellcomemat.com/video/5979bb66942c1m6fu/CDM/CA/92625/Hampden-Rd/OC25127680/" +"VirtualTourURLUnbranded": "https://www.wellcomemat.com/mls/5979bb66942c1m6fu" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office",\n "AdminUpdateYN": "0",\n "ListingKey": "1115044718",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115044718')" +"CurrentPrice": 5700000.0 +"provider_name": "CRMLS" +"RecordSignature": 2080925851 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:47505411" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "143572682" +"OriginatingSystemListAgentMemberKey": "369525581" +"Media": array:42 [ …42] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5632 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113888520" +"ListingId": "ML82006272" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:54.002631+00:00" +"ListPrice": 2725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 8370.0 +"LivingArea": 2380.0 +"BuildingAreaTotal": 0 +"City": "Menlo Park" +"PostalCode": "94025" +"UnparsedAddress": "3523 Oak Drive, Menlo Park, California 94025" +"Coordinates": array:2 [ …2] +"Latitude": 37.47309796 +"Longitude": -122.19842405 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Emely Weissman" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML154192" +"ListOfficeMlsId": "ML37689" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This lovely home is set fairly far back, in a picture postcard kind of way, on its 8,370 square foot lot. The neighborhood is a favorite: green, parklike, picturesque, peaceful, great for taking a walk or joining neighbors for the neighborhood's weekly happy hour get together. The wonderful kitchen has handsome cabinetry, spacious granite counters, gas cooking, stainless steel appliances, and a built-in wine refrigerator. There are both a breakfast area and a separate dining room, both family room and living room, and a first floor bedroom that is great as an office. All bathrooms are updated or remodeled; the principal bathroom with oversized tub and shower is particularly luxurious. Hardwood floors throughout main floor, three carpeted bedrooms up and one bedroom on main floor, three skylights. Deck has an excellent built in hot tub, and there is a substantial backyard. This is a terrific place to call home." +"Appliances": "Dishwasher, Disposal, Refrigerator" +"ArchitecturalStyle": "Mediterranean, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3251173763 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-14" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-15T02:38:52.962690+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Middlefield Road, then turn onto San Benito or Placitas to left on Oak Drive, to 3523. Cross Street: Placitas" +"FireplaceFeatures": "Family Room,Wood Burning" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Menlo-Atherton" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-814-0374" +"ListAgentEmail": "emely.weissman@compass.com" +"ListAgentFax": "650-323-1143" +"ListAgentFirstName": "Emely" +"ListAgentKey": "20889480" +"ListAgentKeyNumeric": "20889480" +"ListAgentLastName": "Weissman" +"ListAgentOfficePhone": "(650) 323-1111" +"ListAgentStateLicense": "01119038" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-323-1143" +"ListOfficeKey": "4763954" +"ListOfficeKeyNumeric": "4763954" +"ListOfficePhone": "(650) 323-1111" +"ListOfficeURL": "http://www.compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-14" +"ListingKeyNumeric": 1113888520 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeAcres": 0.1921 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8370.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-14" +"OnMarketTimestamp": "2025-05-14T12:18:53Z" +"OriginalEntryTimestamp": "2025-05-13T17:00:00Z" +"OriginalListPrice": 2825000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374412483" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "060153290" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Deck" +"PhotosChangeTimestamp": "2025-06-15T07:03:19Z" +"PhotosCount": 24 +"PoolFeatures": "Above Ground" +"PreviousListPrice": 2825000.0 +"PriceChangeTimestamp": "2025-06-14T16:49:32Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Entry/Foyer, Laundry" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1113888520" +"SpaFeatures": "Above Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:00Z" +"StoriesTotal": "2" +"StreetName": "Oak" +"StreetNumber": "3523" +"StreetNumberNumeric": "3523" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06081-N-060153290-R-N" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R10010" +"CustomFields": """ {\n "RoomType": "Formal Entry,Laundry",\n "AdminUpdateYN": "0",\n "ListingKey": "1113888520",\n "RoomKitchenFeatures": "Granite Counters"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1113888520')" +"CurrentPrice": 2725000.0 +"provider_name": "CRMLS" +"RecordSignature": 2051684006 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:060153290" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "368558344" +"OriginatingSystemListAgentMemberKey": "368705589" +"Media": array:24 [ …24] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5631 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117318108" +"ListingId": "PW25130551" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:31.621904+00:00" +"ListPrice": 1295000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7800.0 +"LivingArea": 1463.0 +"BuildingAreaTotal": 0 +"City": "Mission Viejo" +"PostalCode": "92691" +"UnparsedAddress": "23266 Via Ronda, Mission Viejo, California 92691" +"Coordinates": array:2 [ …2] +"Latitude": 33.625063 +"Longitude": -117.655413 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Baroth" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "PWBARRAC" +"ListOfficeMlsId": "PB1364" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 23266 Via Ronda in sought after Barcelona neighborhood offering 4 bedrooms, 3 baths, a spacious entertainers backyard featuring a custom heated pool and spa, a fully insulated patio cover complete with lighting, ceiling fans and custom curtain brackets for additional shade & comfort also boast beautiful easy care tropical fauna, mature lemon and orange trees, and a versatile large playhouse/ office/ hobby room wired with electric, lighting & internet. The perfect setting for summer BBQ’s, family birthdays, holidays or romantic evening dinners. The main level open floor plan has fireplace in cathedral ceiling living room, formal dining room with bright, natural light flowing thru kitchen window box and back door facing lush back yard patio and pool. Finishing the downstairs is a large bedroom with French doors opening to backyard, currently being used as entertainment room and a full bathroom. Retreat to the upstairs primary bedroom full en suite bath with jetted tub, walk in closet completed with vanity, custom shelving and drawers. Another full bath and 2 bedrooms, one loft style that could double as home office and LVP flooring throughout complete the upstairs. Energy-efficient solar panels provide cost-saving benefits, making this home as practical as it is beautiful. Completing this home is Central HVAC system, large 2 car attached garage with washer and dryer hookups, beautiful artificial turf for low maintenance front yard, And Full Access to Lake Mission Viejo Membership and all it has to offer. Talk about location, Award winning Capistrano schools, nearby Aurora Park with fields, playground, volleyball & basketball court, beautiful wooded area for the evening strolls, fine restaurants, shopping and golf course all nearby!" +"Appliances": "Dishwasher,Gas Oven,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Controlled Access,Picnic Area,Playground" +"AssociationFee": "179.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Mission Viejo Lake Membership" +"AssociationPhone": "949-770-1313" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "rachel@rachelbaroth.com" +"BathroomsFull": 3 +"CLIP": 8991206809 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gutter(s)" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-13T03:02:02.144261+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit 5 freeway at Alicia Parkway, follow Alicia Parkway to Right on Via Aura to Right on Via Ronda" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Capistrano Valley" +"HighSchoolDistrict": "Capistrano Unified" +"Inclusions": "Refrigerator" +"InteriorFeatures": "Cathedral Ceiling(s),Separate/Formal Dining Room,Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "rachel@rachelbaroth.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "17072220" +"ListAgentKeyNumeric": "17072220" +"ListAgentLastName": "Baroth" +"ListAgentOfficePhone": "562-989-4608" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01396461" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-989-4803" +"ListOfficeKey": "3284761" +"ListOfficeKeyNumeric": "3284761" +"ListOfficePhone": "562-989-4608" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Open" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1117318108 +"ListingService": "Entry Only" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1791 +"LotSizeDimensions": "130 x 60" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T16:53:41Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T16:53:41Z" +"OriginalEntryTimestamp": "2025-06-12T16:53:41Z" +"OriginalListPrice": 1295000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374576329" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "80826104" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-15T06:51:40Z" +"PhotosCount": 19 +"PoolFeatures": "Gas Heat,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2229" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Anthony" +"ShowingContactPhone": "949-334-7305" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117318108" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" …26 } ] +success: true +page_size: 5 +page_count: 135388 +count: 676939 +after_key: "" } ] ]
