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: 66d4beb7d1e38014ed26a43e3133d6aa41a382815d68cc56beaddb2aba0a9bf0" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4902 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1038100159" +"ListingId": "ML81931045" +"PropertyType": "Manufactured In Park" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-14T12:48:40Z" +"RFModificationTimestamp": "2025-06-14T14:01:09.180772+00:00" +"ListPrice": 65000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 600.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94063" +"UnparsedAddress": "1903 Bayshore Road, Redwood City, California 94063" +"Coordinates": array:2 [ 0 => -122.20586646 1 => 37.48843535 ] +"Latitude": 37.48843535 +"Longitude": -122.20586646 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eva Ortega" +"ListOfficeName": "Caminos Real Estate" +"ListAgentMlsId": "ML5077667" +"ListOfficeMlsId": "ML28369" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Great mobile home for starter couples 1 bethroom and 1 bathroom in a all age community nice side kitchen near 101 and Tech Companies" +"Appliances": "Refrigerator" +"BathroomsFull": 1 +"CLIP": 1084807864 +"CarportSpaces": "1.0" +"CarportYN": true +"CloseDate": "2024-09-15" +"ContractStatusChangeDate": "2023-06-11" +"Cooling": "Central Air,Wall/Window Unit(s)" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-04-15T17:46:25.005160+00:00" +"DaysOnMarket": 4 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Woodside & Marsh" +"ElementarySchool": "Hoover" +"Flooring": "Laminate" +"GarageSpaces": "1.0" +"GarageYN": true +"HeatingYN": true +"HighSchool": "San Mateo" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-309-0801" +"ListAgentEmail": "evamortega10@gmail.com" +"ListAgentFirstName": "Eva" +"ListAgentKey": "21010384" +"ListAgentKeyNumeric": "21010384" +"ListAgentLastName": "Ortega" +"ListAgentOfficePhone": "831-905-8755" +"ListAgentStateLicense": "01310183" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "831-603-3258" +"ListOfficeKey": "4765077" +"ListOfficeKeyNumeric": "4765077" +"ListOfficePhone": "831-905-8755" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2023-06-07" +"ListingKeyNumeric": 1038100159 +"LivingAreaSource": "Other" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MiddleOrJuniorSchool": "John F. Kennedy" +"MlsStatus": "Active Under Contract" +"Model": "00" +"OccupantType": "Owner" +"OffMarketDate": "2025-06-14" +"OnMarketDate": "2023-06-07" +"OnMarketTimestamp": "2023-06-07T23:19:20Z" +"OriginalEntryTimestamp": "2023-06-07T15:50:38Z" +"OriginalListPrice": 65000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "371543420" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "054121010" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-05T10:49:29Z" +"PhotosCount": 1 +"PurchaseContractDate": "2023-06-11" +"Roof": "Metal" +"Sewer": "Public Sewer" +"ShowingContactPhone": "14086036446" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1038100159" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:30Z" +"StoriesTotal": "1" +"StreetName": "Bayshore" +"StreetNumber": "1903" +"StreetNumberNumeric": "1903" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06081-N-054121010-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1038100159",\n "ConcessionInPrice": "",\n "ConcessionInPriceType": ""\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1038100159')" +"CurrentPrice": 65000.0 +"provider_name": "CRMLS" +"RecordSignature": -274122668 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:054121010" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368560199" +"OriginatingSystemListAgentMemberKey": "368824725" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117364514" +"ListingId": "ML82010983" +"PropertyType": "Residential Income" +"PropertySubType": "Duplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T05:26:44Z" +"RFModificationTimestamp": "2025-06-14T08:27:24.417524+00:00" +"ListPrice": 1625000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5450.0 +"LivingArea": 2160.0 +"BuildingAreaTotal": 2160.0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "1648 Oak Avenue, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.23619648 1 => 37.46781865 ] +"Latitude": 37.46781865 +"Longitude": -122.23619648 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bob Lahl" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML5083153" +"ListOfficeMlsId": "ML39596" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Live in one and rent out the other! Great Redwood City Duplex perfect for it's next owners. Two 2 bedroom 1 bath units with living room and dining and galley kitchen. Each unit has it's own private yard and it's own 1 car garage. Perfect for the investor or those just starting out." +"AccessibilityFeatures": "Other" +"Appliances": "Electric Oven" +"CLIP": 2899227316 +"CapRate": -0.1 +"CoListAgentAOR": "MLSListings" +"CoListAgentDirectPhone": "650-454-0112" +"CoListAgentEmail": "maryficklin@gmail.com" +"CoListAgentFirstName": "Mary" +"CoListAgentFullName": "Mary Ficklin" +"CoListAgentKey": "20896337" +"CoListAgentKeyNumeric": "20896337" +"CoListAgentLastName": "Ficklin" +"CoListAgentMlsId": "ML5083079" +"CoListAgentOfficePhone": "(650) 375-1111" +"CoListAgentStateLicense": "00522273" +"CoListAgentURL": "http://www.maryficklin.com" +"CoListOfficeAOR": "MLSListings" +"CoListOfficeFax": "650-931-2099" +"CoListOfficeKey": "4763042" +"CoListOfficeKeyNumeric": "4763042" +"CoListOfficeMlsId": "ML39596" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "(650) 375-1111" +"CoListOfficeURL": "http://www.compass.com" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-13T22:29:50.429621+00:00" +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Flooring": "Carpet" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-740-5804" +"ListAgentEmail": "bob@boblahl.com" +"ListAgentFax": "415-358-8338" +"ListAgentFirstName": "Bob" +"ListAgentKey": "21014197" +"ListAgentKeyNumeric": "21014197" +"ListAgentLastName": "Lahl" +"ListAgentOfficePhone": "(650) 375-1111" +"ListAgentStateLicense": "01053037" +"ListAgentURL": "http://www.boblahl.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-931-2099" +"ListOfficeKey": "4763042" +"ListOfficeKeyNumeric": "4763042" +"ListOfficePhone": "(650) 375-1111" +"ListOfficeURL": "http://www.compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-13" +"ListingKeyNumeric": 1117364514 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.1251 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5450.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-13" +"OnMarketTimestamp": "2025-06-13T07:06:19Z" +"OriginalEntryTimestamp": "2025-06-13T06:51:39Z" +"OriginalListPrice": 1625000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374583199" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "058216370" +"PhotosChangeTimestamp": "2025-06-13T21:21:47Z" +"PhotosCount": 47 +"PropertySubTypeAdditional": "Duplex" +"Roof": "Composition" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117364514" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T06:51:39Z" +"StoriesTotal": "1" +"StreetName": "Oak" +"StreetNumber": "1648" +"StreetNumberNumeric": "1648" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "1574.0" +"UniversalPropertyId": "US-06081-N-058216370-R-N" +"Utilities": "Natural Gas Available" +"VirtualTourURLBranded": "https://youtu.be/WIqk O9g_tis" +"VirtualTourURLUnbranded": "https://tours.robertbarbuttiphotography.com/2334421?idx=1" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R20000" +"CustomFields": """ {\n "RoomKitchenFeatures": "Formica Counters,Tile Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1117364514"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117364514')" +"CurrentPrice": 1625000.0 +"provider_name": "CRMLS" +"RecordSignature": 1918968317 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:058216370" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368557221" +"OriginatingSystemCoListOfficeKey": "368557221" +"OriginatingSystemListAgentMemberKey": "368829367" +"OriginatingSystemCoListAgentMemberKey": "368710916" +"Media": array:47 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] 37 => array:57 [ …57] 38 => array:57 [ …57] 39 => array:57 [ …57] 40 => array:57 [ …57] 41 => array:57 [ …57] 42 => array:57 [ …57] 43 => array:57 [ …57] 44 => array:57 [ …57] 45 => array:57 [ …57] 46 => array:57 [ …57] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115007706" +"ListingId": "ML82009922" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T05:13:51Z" +"RFModificationTimestamp": "2025-06-14T08:39:44.752129+00:00" +"ListPrice": 2250000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7443.0 +"LivingArea": 1520.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "435 Buena Vista Avenue, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.2212948 1 => 37.4538422 ] +"Latitude": 37.4538422 +"Longitude": -122.2212948 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Janie Barman" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML480962" +"ListOfficeMlsId": "ML37689" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Unbeatable LOCATION ... Here it is! This lovely updated home is smack dab in the ideal location bordering Atherton, close to many convenient amenities and commute routes. Quintessential CHARM ... Timeless charm and character abound with a floorplan that flows seamlessly in and out and all around Abundant SPACE ... Inside and out there are multiple locations to gather or focus on the task at hand. Oversized 2 car garage, interior laundry room, separate office/studio space and rooms full of light. WELCOME to Buena Vista the perfect street to make your new home. Refinished hardwood floors, fresh paint in and out, new lighting and some new appliances make this home a rock star." +"Appliances": "Dishwasher,Electric Oven,Gas Cooktop,Microwave,Refrigerator" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 6181691805 +"CoListAgentAOR": "MLSListings" +"CoListAgentDirectPhone": "650-380-8440" +"CoListAgentEmail": "john.barman@compass.com" +"CoListAgentFirstName": "John" +"CoListAgentFullName": "John Barman" +"CoListAgentKey": "20993227" +"CoListAgentKeyNumeric": "20993227" +"CoListAgentLastName": "Barman" +"CoListAgentMlsId": "ML480960" +"CoListAgentOfficePhone": "(650) 323-1111" +"CoListAgentStateLicense": "01281597" +"CoListAgentURL": "http://www.babblingbrook.com" +"CoListOfficeAOR": "MLSListings" +"CoListOfficeFax": "650-323-1143" +"CoListOfficeKey": "4763954" +"CoListOfficeKeyNumeric": "4763954" +"CoListOfficeMlsId": "ML37689" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "(650) 323-1111" +"CoListOfficeURL": "http://www.compass.com" +"CommonWalls": "No Common Walls" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-06" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-06T16:12:52.454135+00:00" +"DaysOnMarket": 8 +"DaysOnMarketReplication": 7 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Selby" +"Fencing": "Wood" +"FireplaceFeatures": "Family Room,Living Room" +"FireplaceYN": true +"Flooring": "Stone, Tile, Wood" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Workshop" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-759-1182" +"ListAgentEmail": "janie.barman@compass.com" +"ListAgentFirstName": "Janie" +"ListAgentKey": "20993229" +"ListAgentKeyNumeric": "20993229" +"ListAgentLastName": "Barman" +"ListAgentOfficePhone": "(650) 323-1111" +"ListAgentStateLicense": "01270223" +"ListAgentURL": "http://www.babblingbrook.com" +"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-06-06" +"ListingKeyNumeric": 1115007706 +"ListingService": "Full Service" +"LivingAreaSource": "Other" +"LotFeatures": "Level" +"LotSizeAcres": 0.1709 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7443.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T01:35:08Z" +"OriginalEntryTimestamp": "2025-06-05T17:00:00Z" +"OriginalListPrice": 2250000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374541747" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "069331040" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-13T03:20:43Z" +"PhotosCount": 28 +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Art Studio,Bonus Room,Office,Workshop" +"Sewer": "Public Sewer" +"ShowingContactPhone": "650-759-1182" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115007706" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-05T08:58:57Z" +"StoriesTotal": "1" +"StreetName": "Buena Vista" +"StreetNumber": "435" +"StreetNumberNumeric": "435" +"StreetSuffix": "Avenue" +"UniversalPropertyId": "US-06081-N-069331040-R-N" +"VirtualTourURLBranded": "https://www.tourfactory.com/3205772" +"VirtualTourURLUnbranded": "https://www.tourfactory.com/idxr3205772" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R10006" +"CustomFields": """ {\n "RoomType": "Art Studio,Bonus Room,Office,Workshop",\n "EatingArea": "Dining Ell",\n "AdminUpdateYN": "0",\n "ListingKey": "1115007706"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115007706')" +"CurrentPrice": 2250000.0 +"provider_name": "CRMLS" +"RecordSignature": 1177485777 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:069331040" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558344" +"OriginatingSystemCoListOfficeKey": "368558344" +"OriginatingSystemListAgentMemberKey": "368806226" +"OriginatingSystemCoListAgentMemberKey": "368806224" +"Media": array:28 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113006036" +"ListingId": "ML82006176" +"PropertyType": "Residential Lease" +"PropertySubType": "Apartment" +"StandardStatus": "Closed" +"ModificationTimestamp": "2025-06-14T05:13:02Z" +"RFModificationTimestamp": "2025-06-14T08:38:43.617700+00:00" +"ListPrice": 2100.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 1.0 +"LivingArea": 15717.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94063" +"UnparsedAddress": null +"Coordinates": null +"Latitude": null +"Longitude": null +"YearBuilt": 1964 +"InternetAddressDisplayYN": false +"FeedTypes": "IDX" +"ListAgentFullName": "Terry Michaud" +"ListOfficeName": "Heritage Realty" +"ListAgentMlsId": "ML161743" +"ListOfficeMlsId": "ML35869" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "SPACIOUS UNIT, WALK TO DOWNTOWN, EASY ACCESS TO HWY 101, VERY CLEAN, SUNNY AND BRIGHT, SECURITY BUILDING AND GARAGE. DON'T MISS!!" +"AccessibilityFeatures": "None" +"Appliances": "Refrigerator" +"AvailabilityDate": "2025-05-09" +"BathroomsFull": 1 +"BuyerAgentAOR": "MLSListings" +"BuyerAgentDirectPhone": "650-290-1479" +"BuyerAgentEmail": "joycediaz43@gmail.com" +"BuyerAgentFirstName": "Joyce" +"BuyerAgentFullName": "Joyce Diaz-torres" +"BuyerAgentKey": "23363379" +"BuyerAgentKeyNumeric": "23363379" +"BuyerAgentLastName": "Diaz-torres" +"BuyerAgentMlsId": "ML5100209" +"BuyerAgentStateLicense": "02234968" +"BuyerOfficeAOR": "MLSListings" +"BuyerOfficeKey": "4764969" +"BuyerOfficeKeyNumeric": "4764969" +"BuyerOfficeMlsId": "ML35869" +"BuyerOfficeName": "Heritage Realty" +"BuyerOfficePhone": "650-349-9300" +"CLIP": 1039982239 +"CloseDate": "2025-06-13" +"ClosePrice": 2100.0 +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-14T08:38:26.046135+00:00" +"DaysOnMarket": 35 +"DaysOnMarketReplication": 35 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": " Cross Street: MARSHALL ST." +"ElementarySchool": "Hoover" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Wall Furnace" +"HeatingYN": true +"HighSchool": "Sequoia" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "None" +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-349-9300" +"ListAgentEmail": "terry@hr1107.com" +"ListAgentFirstName": "Terry" +"ListAgentKey": "20889650" +"ListAgentKeyNumeric": "20889650" +"ListAgentLastName": "Michaud" +"ListAgentOfficePhone": "650-349-9300" +"ListAgentStateLicense": "00365928" +"ListAgentURL": "http://www.heritagerealtysanmateo.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-349-8483" +"ListOfficeKey": "4764969" +"ListOfficeKeyNumeric": "4764969" +"ListOfficePhone": "650-349-9300" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-05-09" +"ListingKeyNumeric": 1113006036 +"ListingService": "Full Service" +"LivingAreaSource": "Other" +"LotSizeSource": "Other" +"LotSizeSquareFeet": 1.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Closed" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-13" +"OffMarketTimestamp": "2025-06-13T11:19:27Z" +"OnMarketDate": "2025-05-09" +"OnMarketTimestamp": "2025-05-09T01:19:23Z" +"OriginalEntryTimestamp": "2025-05-09T01:01:15Z" +"OriginalListPrice": 2100.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374382093" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "053205290" +"ParkingFeatures": "Covered" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-14T05:14:03Z" +"PhotosCount": 6 +"PropertySubTypeAdditional": "Apartment" +"PurchaseContractDate": "2025-06-13" +"RentIncludes": "Sewer,Trash Collection,Water" +"SaleOrLeaseIndicator": "Lease" +"SecurityDeposit": 1100.0 +"ShowingContactPhone": "650-290-1479" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1113006036" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"StoriesTotal": "2" +"UniversalPropertyId": "US-06081-N-053205290-R-N" +"YearBuiltSource": "Other" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1113006036"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1113006036')" +"CurrentPrice": 2100.0 +"provider_name": "CRMLS" +"short_address": "Redwood City, California 94063, USA" +"RecordSignature": 501865930 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:053205290" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368559832" +"OriginatingSystemBuyerOfficeKey": "368559832" +"OriginatingSystemListAgentMemberKey": "368705854" +"OriginatingSystemBuyerAgentMemberKey": "372498922" +"Media": array:6 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114745654" +"ListingId": "ML82009076" +"PropertyType": "Residential" +"PropertySubType": "Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T05:13:02Z" +"RFModificationTimestamp": "2025-06-14T08:46:33.331102+00:00" +"ListPrice": 1150000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1300.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94065" +"UnparsedAddress": "530 Shorebird Circle 7104, Redwood City, California 94065" +"Coordinates": array:2 [ 0 => -122.25365074 1 => 37.53259872 ] +"Latitude": 37.53259872 +"Longitude": -122.25365074 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Maryann Ernst" +"ListOfficeName": "KW Advisors" +"ListAgentMlsId": "ML5084509" +"ListOfficeMlsId": "ML86691" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover this charming townhome style condo, nestled in canals of Redwood Shores, offering 1,300 sq ft of comfortable living space right on the lagoon. This private residence features two spacious bedrooms and two full bathrooms, with an additional half bath conveniently located on the ground floor. The kitchen is a chef's delight, boasting granite countertops, an oven range, and ample cabinetry. The kitchen has it's own private patio for relaxing morning coffee or a leisurely lunch in the sun. The living room is adjacent to the generously sized dining room and leads into the private deck on the lagoon. Upstairs a substantial primary suite with vaulted ceilings and it's own private balcony create a peaceful retreat. This home features ample storage, spacious common areas and multiple outdoor spaces! A rare find! For convenience, laundry facilities are located inside the home on the upper floor with a washer and dryer included. Additional amenities include a community pool for leisure, a spa and a club house, not forgetting to mention an assigned enclosed garage space right outside the unit and a separate storage unit. Located within the highly desirable Belmont-Redwood Shores Elementary School District, this home offers a perfect blend of comfort and convenience." +"Appliances": "Dishwasher,Electric Cooktop,Disposal,Microwave,Refrigerator,Self Cleaning Oven" +"AssociationAmenities": "Clubhouse,Pool,Spa/Hot Tub,Trash,Water" +"AssociationFee": "659.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "SHOREBIRD" +"AssociationYN": true +"BathroomsFull": 2 +"BuildingName": "SHOREBIRD" +"CLIP": 5821537932 +"CommunityFeatures": "Pool" +"ContractStatusChangeDate": "2025-05-30" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-31T04:58:27.596951+00:00" +"DaysOnMarket": 15 +"DaysOnMarketReplication": 14 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "Southeast" +"Directions": " Cross Street: Marine Parkway/Sandpiper" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "415-361-9921" +"ListAgentEmail": "maryann@maryannernst.com" +"ListAgentFirstName": "Maryann" +"ListAgentKey": "21015056" +"ListAgentKeyNumeric": "21015056" +"ListAgentLastName": "Ernst" +"ListAgentOfficePhone": "(650) 627-3700" +"ListAgentStateLicense": "01758548" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-627-3701" +"ListOfficeKey": "4763725" +"ListOfficeKeyNumeric": "4763725" +"ListOfficePhone": "(650) 627-3700" +"ListOfficeURL": "http://www.kw.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-30" +"ListingKeyNumeric": 1114745654 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "192" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-30" +"OnMarketTimestamp": "2025-05-30T13:50:22Z" +"OriginalEntryTimestamp": "2025-05-29T17:00:00Z" +"OriginalListPrice": 1150000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374506313" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "111620060" +"ParkingFeatures": "Guest" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-05-31T04:03:42Z" +"PhotosCount": 40 +"PoolFeatures": "Community, Association" +"Possession": "Close Of Escrow" +"PropertySubTypeAdditional": "Townhouse" +"Roof": "Other" +"Sewer": "Public Sewer" +"ShowingContactPhone": "415-361-9921" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114745654" +"SpaFeatures": "Community" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-30T06:14:22Z" +"StoriesTotal": "2" +"StreetName": "Shorebird" +"StreetNumber": "530" +"StreetNumberNumeric": "530" +"StreetSuffix": "Circle" +"UnitNumber": "7104" +"UniversalPropertyId": "US-06081-N-111620060-R-N" +"View": "Water" +"ViewYN": true +"VirtualTourURLBranded": "https://listings.sogoldmarketing.com/videos/019721db-0acc-7243-b014-54125bc362d5" +"VirtualTourURLUnbranded": "https://listings.sogoldmarketing.com/videos/019721db-a3c9-71f3-8b88-7df6ec2a9c08" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "PD0000" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "RoomKitchenFeatures": "Granite Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1114745654"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114745654')" +"CurrentPrice": 1150000.0 +"provider_name": "CRMLS" +"RecordSignature": -749928639 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:111620060" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558241" +"OriginatingSystemListAgentMemberKey": "368830417" +"Media": array:40 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] 37 => array:57 [ …57] 38 => array:57 [ …57] 39 => array:57 [ …57] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114780635" +"ListingId": "ML82009283" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T05:13:02Z" +"RFModificationTimestamp": "2025-06-14T14:54:09.620799+00:00" +"ListPrice": 2998000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6718.0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "18 Melvin Henry Court, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.2281627 1 => 37.44917755 ] +"Latitude": 37.44917755 +"Longitude": -122.2281627 +"YearBuilt": 1990 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Hossein Jalali" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "ML5065459" +"ListOfficeMlsId": "ML38329" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome home to 18 Melvin Henry Ct! Nestled at the end of a peaceful cul-de-sac, this beautifully renovated home features modern finishes and large windows that flood the interior with natural light. Step inside to explore a stunning design with high ceilings, a formal dining room, and a spacious family room with a cozy fireplace and bar area. The kitchen has been fully remodeled and includes all-new appliances, new countertops, a new sink, and a charming breakfast nook with views of the expansive backyard. The oversized living room boasts soaring ceilings and a second fireplace, creating a perfect space for relaxation and entertaining. This home offers four generously sized bedrooms, each with walk-in closets. All bathrooms have been upgraded with brand-new tubs, showers, countertops, and high-end fixtures and finishes. Additional features include brand-new European white oak flooring throughout, fresh professional paint, recessed lighting, new fixtures, and a three-car garage. Conveniently located near Highway 280 and shopping centers, this home is the perfect blend of comfort and convenience." +"Appliances": "Dishwasher,Gas Cooktop,Disposal,Microwave,Refrigerator,Vented Exhaust Fan" +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 2810699946 +"CloseDate": "2025-07-08" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-02T05:35:46.218467+00:00" +"DaysOnMarket": 12 +"DaysOnMarketReplication": 12 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": " Cross Street: Cerrito Ave" +"FireplaceFeatures": "Gas Starter,Wood Burning" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "3.0" +"GarageYN": true +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Breakfast Area,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-740-2233" +"ListAgentEmail": "hdjalali@cbnorcal.com" +"ListAgentFirstName": "Hossein" +"ListAgentKey": "20890855" +"ListAgentKeyNumeric": "20890855" +"ListAgentLastName": "Jalali" +"ListAgentOfficePhone": "(650) 324-4456" +"ListAgentStateLicense": "01215831" +"ListAgentURL": "http://www.hjalali.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-323-7128" +"ListOfficeKey": "4763959" +"ListOfficeKeyNumeric": "4763959" +"ListOfficePhone": "(650) 324-4456" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-01" +"ListingKeyNumeric": 1114780635 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.1542 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6718.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Pending" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-13" +"OffMarketTimestamp": "2025-06-13T11:49:38Z" +"OnMarketDate": "2025-06-01" +"OnMarketTimestamp": "2025-06-01T15:18:51Z" +"OriginalEntryTimestamp": "2025-06-01T15:02:02Z" +"OriginalListPrice": 2998000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374510347" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "069293590" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-14T05:14:03Z" +"PhotosCount": 35 +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-13" +"Roof": "Composition" +"RoomType": "Other, Retreat" +"Sewer": "Public Sewer" +"ShowingContactPhone": "650-740-2233" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114780635" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"StreetName": "Melvin Henry" +"StreetNumber": "18" +"StreetNumberNumeric": "18" +"StreetSuffix": "Court" +"UniversalPropertyId": "US-06081-N-069293590-R-N" +"VirtualTourURLBranded": "https://tourfactorybayarea.tf.media/18-Melvin-Henry-Ct" +"VirtualTourURLUnbranded": "https://tourfactorybayarea.tf.media/x2242511" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R10000" +"CustomFields": """ {\n "RoomType": "Retreat,Walk-In Closet",\n "EatingArea": "Breakfast Nook",\n "RoomKitchenFeatures": "Quartz Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1114780635"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114780635')" +"CurrentPrice": 2998000.0 +"provider_name": "CRMLS" +"RecordSignature": 176633226 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:069293590" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368558349" +"OriginatingSystemListAgentMemberKey": "368706848" +"Media": array:35 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114609082" +"ListingId": "ML82008592" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T05:13:02Z" +"RFModificationTimestamp": "2025-06-14T08:46:57.380202+00:00" +"ListPrice": 1180000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 4500.0 +"LivingArea": 1157.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94063" +"UnparsedAddress": "710 5th, Redwood City, California 94063" +"Coordinates": array:2 [ 0 => -122.20025997 1 => 37.47837132 ] +"Latitude": 37.47837132 +"Longitude": -122.20025997 +"YearBuilt": 1939 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Julie Phan Boc" +"ListOfficeName": "Christie's International Real Estate Sereno" +"ListAgentMlsId": "ML5091668" +"ListOfficeMlsId": "ML5033630" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "A beautifully remodeled home in Redwood City is ready for new owners! This home underwent a major renovation in 2015, featuring upgrades such as new electrical panels, dual-pane windows, recessed LED lighting, new copper wiring and drain plumbing, retrofitted framing, and a tankless water heater. The gourmet kitchen boasts quartz countertops, stainless steel appliances, soft-close cabinets, all complemented by elegant hardwood floors. The primary bedroom includes a private en-suite bath, while the second bathroom is conveniently located in the hallway near the second bedroom. Step outside to a private backyard with a covered patio, ideal for relaxing or entertaining. Additionally, a spacious 273SQFT detached studio cottage, filled with natural light, offers the perfect space for an office or workout studio. The large front lot provides parking for up to four vehicles, including a covered carport. Located in an unbeatable area, this home is just minutes from shopping, with easy access to Highway 101, Facebook, Stanford University, downtown Redwood City, and Menlo Park, making commuting a breeze." +"Appliances": "Dishwasher,Disposal,Microwave,Refrigerator,Range Hood" +"BathroomsFull": 2 +"CLIP": 2495370254 +"CarportSpaces": "2.0" +"CarportYN": true +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-28" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-28T16:11:42.949394+00:00" +"DaysOnMarket": 17 +"DaysOnMarketReplication": 16 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Fair Oaks" +"Flooring": "Tile, Wood" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-309-3328" +"ListAgentEmail": "julie@sybariterealty.com" +"ListAgentFirstName": "Julie Phan" +"ListAgentKey": "21385839" +"ListAgentKeyNumeric": "21385839" +"ListAgentLastName": "Boc" +"ListAgentOfficePhone": "(650) 844-7373" +"ListAgentStateLicense": "01887476" +"ListAgentURL": "http://www.julieboc.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeKey": "4763715" +"ListOfficeKeyNumeric": "4763715" +"ListOfficePhone": "(650) 844-7373" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-28" +"ListingKeyNumeric": 1114609082 +"ListingService": "Full Service" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1033 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 4500.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-28" +"OnMarketTimestamp": "2025-05-28T01:49:02Z" +"OriginalEntryTimestamp": "2025-05-28T01:33:31Z" +"OriginalListPrice": 1180000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374480302" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "060015340" +"ParkingFeatures": "Carport" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-01T20:19:40Z" +"PhotosCount": 37 +"Possession": "Close Of Escrow" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114609082" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-28T01:33:31Z" +"StoriesTotal": "1" +"StreetName": "5th Ave" +"StreetNumber": "710" +"StreetNumberNumeric": "710" +"UniversalPropertyId": "US-06081-N-060015340-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R10006" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1114609082"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114609082')" +"CurrentPrice": 1180000.0 +"provider_name": "CRMLS" +"RecordSignature": -932058198 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:060015340" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558231" +"OriginatingSystemListAgentMemberKey": "369966920" +"Media": array:37 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111663593" +"ListingId": "ML81996325" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T05:01:31Z" +"RFModificationTimestamp": "2025-06-14T08:58:50.804816+00:00" +"ListPrice": 1730000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 5700.0 +"LivingArea": 1440.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "938 Fulton Street, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.23182882 1 => 37.47604931 ] +"Latitude": 37.47604931 +"Longitude": -122.23182882 +"YearBuilt": 1906 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jenny Wan-Mernyk" +"ListOfficeName": "Alliance Bay Realty" +"ListAgentMlsId": "ML5102995" +"ListOfficeMlsId": "ML38731" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Perfectly located within walking distance to downtown, this Craftsman-style home blends classic charm with modern comforts. The front door, adorned with a leaded glass panel, leads you into an open living room with windows that fill the space with light. The living area and three bedrooms feature hardwood floors. The primary bedroom has a large window and a walk-in closet. The en-suite bathroom showcases designer floor tiles, a luxurious shower, and a granite countertop. The second bedroom is conveniently adjacent to the hall bathroom, which boasts a relaxing jetted bathtub. The third bedroom, with its picturesque bay windows, offers a cozy retreat, it does not include a built-in closet. The heart of the home is the open kitchen with a dining area. This space is designed for both functionality and style, featuring an island, modern appliances, ample counter space, and elegant cabinetry. The kitchen flows seamlessly into the dining area, making it perfect for entertaining guests or enjoying family meals. A sliding glass door opens to the deck and the spacious backyard, which features lush lawn and mature fruit trees (pear, nectarine, plum), providing a serene outdoor oasis. . Bonus 583 sq. ft. ADU 1 br/1 ba, kitchen and sitting room." +"Appliances": "Dishwasher, Disposal, Refrigerator" +"BathroomsFull": 2 +"CLIP": 6106574910 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-11" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-04-11T21:31:36.473025+00:00" +"DaysOnMarket": 64 +"DaysOnMarketReplication": 63 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Roosevelt" +"Flooring": "Tile, Wood" +"FoundationDetails": "Concrete Perimeter" +"Heating": "Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Gas Dryer Hookup" +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-278-1249" +"ListAgentEmail": "agentjenny8@gmail.com" +"ListAgentFirstName": "Jenny" +"ListAgentKey": "24819795" +"ListAgentKeyNumeric": "24819795" +"ListAgentLastName": "Wan-Mernyk" +"ListAgentOfficePhone": "510-742-6600" +"ListAgentStateLicense": "01875494" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "510-742-9100" +"ListOfficeKey": "4763968" +"ListOfficeKeyNumeric": "4763968" +"ListOfficePhone": "510-742-6600" +"ListOfficeURL": "http://www.alliancebayrealty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-11" +"ListingKeyNumeric": 1111663593 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeAcres": 0.1309 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5700.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-04-11" +"OnMarketTimestamp": "2025-04-11T04:26:48Z" +"OriginalEntryTimestamp": "2025-04-10T17:00:00Z" +"OriginalListPrice": 1850000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374231812" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "053078070" +"ParkingFeatures": "Uncovered" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-30T16:04:41Z" +"PhotosCount": 41 +"PreviousListPrice": 1785000.0 +"PriceChangeTimestamp": "2025-05-30T01:49:50Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Other, Retreat" +"ShowingContactPhone": "650-278-1249" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111663593" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-04T00:10:08Z" +"StoriesTotal": "1" +"StreetName": "Fulton" +"StreetNumber": "938" +"StreetNumberNumeric": "938" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06081-N-053078070-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R1" +"CustomFields": """ {\n "RoomType": "Retreat,Walk-In Closet",\n "RoomBathroomFeatures": "Granite Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1111663593"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111663593')" +"CurrentPrice": 1730000.0 +"provider_name": "CRMLS" +"RecordSignature": -1262496170 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:053078070" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558358" +"OriginatingSystemListAgentMemberKey": "373284532" +"Media": array:41 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] 37 => array:57 [ …57] 38 => array:57 [ …57] 39 => array:57 [ …57] 40 => array:57 [ …57] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1108406786" +"ListingId": "41088677" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T02:30:55Z" +"RFModificationTimestamp": "2025-06-14T12:50:34.632919+00:00" +"ListPrice": 849000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1570.0 +"LivingArea": 1555.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "601 Leahy 104, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.21610204 1 => 37.47043147 ] +"Latitude": 37.47043147 +"Longitude": -122.21610204 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jacob Adams" +"ListOfficeName": "DUDUM REAL ESTATE GROUP" +"ListAgentMlsId": "BMLS-R02090183" +"ListOfficeMlsId": "BMLS-OBBDUDM" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Spacious & Stylish Condo in Prime Redwood City Location Welcome to 601 Leahy St #104, a beautifully updated 3-bedroom, 2-bathroom condo offering modern comfort and convenience. This inviting home features newly updated floors and sleek countertops, creating a fresh and contemporary living space. The open-concept layout seamlessly connects the bright living and dining areas, perfect for entertaining or relaxing. The well-appointed kitchen boasts refreshed countertops, ample storage, and a functional design. The primary suite offers a peaceful retreat with generous closet space and an en-suite bathroom. Two additional bedrooms provide versatility for guests, a home office, or a growing family. Enjoy the benefits of a well-maintained community, including pool and secure parking located just minutes from downtown Redwood City, Caltrain, parks, and top dining and shopping options." +"AccessibilityFeatures": "Accessible Elevator Installed" +"Appliances": "Dryer" +"AssociationAmenities": "Maintenance Grounds,Insurance,Pool" +"AssociationFee": "770.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "CALL LISTING AGENT" +"AssociationPhone": "256 607-4196" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 6585367394 +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-03-07" +"Cooling": "None" +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-23T20:43:44.133190+00:00" +"CumulativeDaysOnMarket": 98 +"DaysOnMarket": 99 +"DaysOnMarketReplication": 98 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "El Camino to Carlos to Leahy Cross Street: Carlos Ave." +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Laminate, Tile" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Floor Furnace" +"HeatingYN": true +"InteriorFeatures": "Breakfast Bar" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "Oakland" +"ListAgentDirectPhone": "925-255-5013" +"ListAgentEmail": "jake@dudum.com" +"ListAgentFax": "925-937-4001" +"ListAgentFirstName": "Jacob" +"ListAgentKey": "17295185" +"ListAgentKeyNumeric": "17295185" +"ListAgentLastName": "Adams" +"ListAgentOfficePhone": "925-937-4000" +"ListAgentStateLicense": "02090183" +"ListOfficeAOR": "Oakland" +"ListOfficeEmail": "julie@dudum.com" +"ListOfficeFax": "925-937-4001" +"ListOfficeKey": "3243503" +"ListOfficeKeyNumeric": "3243503" +"ListOfficePhone": "925-937-4000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-07" +"ListingKeyNumeric": 1108406786 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "Zero Lot Line" +"LotSizeAcres": 0.036 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 1570.0 +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 24 +"OccupantType": "Vacant" +"OnMarketDate": "2025-03-07" +"OnMarketTimestamp": "2025-03-07T10:14:23Z" +"OriginalEntryTimestamp": "2025-03-07T18:00:10Z" +"OriginalListPrice": 899000.0 +"OriginatingSystemID": "BMLS" +"OriginatingSystemKey": "374049894" +"OriginatingSystemSubName": "CRMLS_BMLS" +"ParcelNumber": "110970040" +"ParkingFeatures": "Underground, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T06:47:46Z" +"PhotosCount": 43 +"PoolFeatures": "In Ground,Association" +"Possession": "Close Of Escrow" +"PreviousListPrice": 889000.0 +"PriceChangeTimestamp": "2025-06-10T17:00:00Z" +"PropertySubTypeAdditional": "Condominium" +"Sewer": "Public Sewer" +"ShowingContactName": "Jake Adams" +"ShowingContactPhone": "925 255.5013" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108406786" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-10T17:00:00Z" +"Stories": "1" +"StreetName": "Leahy" +"StreetNumber": "601" +"StreetNumberNumeric": "601" +"SubdivisionName": "REDWOOD CITY" +"UnitNumber": "104" +"UniversalPropertyId": "US-06081-N-110970040-R-N" +"CustomFields": """ {\n "EatingArea": "Breakfast Counter / Bar",\n "RoomKitchenFeatures": "Stone Counters",\n "RoomBathroomFeatures": "Shower in Tub,Tile Counters,Bathtub",\n "AdminUpdateYN": "0",\n "ListingKey": "1108406786"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108406786')" +"CurrentPrice": 849000.0 +"provider_name": "CRMLS" +"RecordSignature": 1295032339 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:110970040" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "362714478" +"OriginatingSystemListAgentMemberKey": "362655382" +"Media": array:43 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] 37 => array:57 [ …57] 38 => array:57 [ …57] 39 => array:57 [ …57] 40 => array:57 [ …57] 41 => array:57 [ …57] 42 => array:57 [ …57] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114176827" +"ListingId": "ML82007174" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T00:37:20Z" +"RFModificationTimestamp": "2025-06-14T16:46:05.215787+00:00" +"ListPrice": 2375000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 5094.0 +"LivingArea": 2230.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "1105 Valota Road, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.23793175 1 => 37.46897 ] +"Latitude": 37.46897 +"Longitude": -122.23793175 +"YearBuilt": 1942 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Louis Melo" +"ListOfficeName": "Atlantis Properties" +"ListAgentMlsId": "ML157031" +"ListOfficeMlsId": "ML38286" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this beautifully renovated 2,230 sq ft home, perfectly positioned on a 5,094 sq ft corner lot in the vibrant heart of Redwood City. Offering 5 spacious bedrooms and 3 full bathrooms, this home provides the ideal layout for families or anyone in need of extra space and flexibility. Inside, you'll find modern touches throughout including brand new appliances, updated LVP flooring, and fresh interior and exterior paint that bring a bright, contemporary feel to every room. A standout feature is the fully remodeled 2-bedroom, 1-bath retreat above the garage, offering a secluded space perfect for guests, extended family, or rental income potential. Enjoy the unbeatable location, just a short walk to Red Morton Community Park and Roosevelt Shopping Center, museums, and major commuter routes. This move-in-ready home combines style, space, and convenience in one of Redwood Citys most desirable neighborhoods. Dont miss out on this exceptional opportunity!" +"Appliances": "Dishwasher, Disposal, Microwave, Refrigerator" +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 6729212920 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-15" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-16T06:18:56.105136+00:00" +"DaysOnMarket": 30 +"DaysOnMarketReplication": 29 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Roosevelt Ave" +"Fencing": "Wood" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-354-8910" +"ListAgentEmail": "louis@atlantisproperties.net" +"ListAgentFax": "408-354-2626" +"ListAgentFirstName": "Louis" +"ListAgentKey": "20926019" +"ListAgentKeyNumeric": "20926019" +"ListAgentLastName": "Melo" +"ListAgentOfficePhone": "408-354-8910" +"ListAgentStateLicense": "00923161" +"ListAgentURL": "http://www.atlantisproperties.net" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "408-354-2626" +"ListOfficeKey": "4764902" +"ListOfficeKeyNumeric": "4764902" +"ListOfficePhone": "408-354-8910" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-15" +"ListingKeyNumeric": 1114176827 +"LivingAreaSource": "Assessor" +"LotFeatures": "Corners Marked" +"LotSizeAcres": 0.1169 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5094.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-15" +"OnMarketTimestamp": "2025-05-15T11:19:20Z" +"OriginalEntryTimestamp": "2025-05-15T10:43:09Z" +"OriginalListPrice": 2448000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374422075" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "058216010" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-14T00:37:45Z" +"PhotosCount": 37 +"PreviousListPrice": 2448000.0 +"PriceChangeTimestamp": "2025-05-30T04:51:28Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114176827" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-15T10:43:09Z" +"StoriesTotal": "1" +"StreetName": "Valota" +"StreetNumber": "1105" +"StreetNumberNumeric": "1105" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06081-N-058216010-R-N" +"VirtualTourURLBranded": "https://login.mavenxvisuals.com/vd/190212581" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R20000" +"CustomFields": """ {\n "RoomKitchenFeatures": "Quartz Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1114176827"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114176827')" +"CurrentPrice": 2375000.0 +"provider_name": "CRMLS" +"RecordSignature": 286397125 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:058216010" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368559845" +"OriginatingSystemListAgentMemberKey": "368741684" +"Media": array:37 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] ] } ] +success: true +page_size: 10 +page_count: 145 +count: 1444 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5414 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5413 +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 [ 0 => -117.312781 1 => 34.110461 ] +"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 [ 0 => array:58 [ …58] 1 => array:58 [ …58] 2 => array:58 [ …58] 3 => array:58 [ …58] 4 => array:58 [ …58] 5 => array:58 [ …58] 6 => array:58 [ …58] 7 => array:58 [ …58] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5585 +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 [ 0 => -121.98683642 1 => 37.55788739 ] +"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 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5590 +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 [ 0 => -117.859593 1 => 33.589326 ] +"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 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] 37 => array:57 [ …57] 38 => array:57 [ …57] 39 => array:57 [ …57] 40 => array:57 [ …57] 41 => array:57 [ …57] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5588 +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 [ 0 => -117.655413 1 => 33.625063 ] +"Latitude": 33.625063 +"Longitude": -117.655413 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Baroth" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "PWBARRAC" +"ListOfficeMlsId": "PB1364" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 23266 Via Ronda in sought after Barcelona neighborhood offering 4 bedrooms, 3 baths, a spacious entertainers backyard featuring a custom heated pool and spa, a fully insulated patio cover complete with lighting, ceiling fans and custom curtain brackets for additional shade & comfort also boast beautiful easy care tropical fauna, mature lemon and orange trees, and a versatile large playhouse/ office/ hobby room wired with electric, lighting & internet. The perfect setting for summer BBQ’s, family birthdays, holidays or romantic evening dinners. The main level open floor plan has fireplace in cathedral ceiling living room, formal dining room with bright, natural light flowing thru kitchen window box and back door facing lush back yard patio and pool. Finishing the downstairs is a large bedroom with French doors opening to backyard, currently being used as entertainment room and a full bathroom. Retreat to the upstairs primary bedroom full en suite bath with jetted tub, walk in closet completed with vanity, custom shelving and drawers. Another full bath and 2 bedrooms, one loft style that could double as home office and LVP flooring throughout complete the upstairs. Energy-efficient solar panels provide cost-saving benefits, making this home as practical as it is beautiful. Completing this home is Central HVAC system, large 2 car attached garage with washer and dryer hookups, beautiful artificial turf for low maintenance front yard, And Full Access to Lake Mission Viejo Membership and all it has to offer. Talk about location, Award winning Capistrano schools, nearby Aurora Park with fields, playground, volleyball & basketball court, beautiful wooded area for the evening strolls, fine restaurants, shopping and golf course all nearby!" +"Appliances": "Dishwasher,Gas Oven,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Controlled Access,Picnic Area,Playground" +"AssociationFee": "179.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Mission Viejo Lake Membership" +"AssociationPhone": "949-770-1313" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "rachel@rachelbaroth.com" +"BathroomsFull": 3 +"CLIP": 8991206809 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gutter(s)" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-13T03:02:02.144261+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit 5 freeway at Alicia Parkway, follow Alicia Parkway to Right on Via Aura to Right on Via Ronda" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Capistrano Valley" +"HighSchoolDistrict": "Capistrano Unified" +"Inclusions": "Refrigerator" +"InteriorFeatures": "Cathedral Ceiling(s),Separate/Formal Dining Room,Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "rachel@rachelbaroth.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "17072220" +"ListAgentKeyNumeric": "17072220" +"ListAgentLastName": "Baroth" +"ListAgentOfficePhone": "562-989-4608" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01396461" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-989-4803" +"ListOfficeKey": "3284761" +"ListOfficeKeyNumeric": "3284761" +"ListOfficePhone": "562-989-4608" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Open" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1117318108 +"ListingService": "Entry Only" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1791 +"LotSizeDimensions": "130 x 60" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T16:53:41Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T16:53:41Z" +"OriginalEntryTimestamp": "2025-06-12T16:53:41Z" +"OriginalListPrice": 1295000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374576329" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "80826104" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-15T06:51:40Z" +"PhotosCount": 19 +"PoolFeatures": "Gas Heat,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2229" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Anthony" +"ShowingContactPhone": "949-334-7305" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117318108" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T16:53:41Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Via Ronda" +"StreetNumber": "23266" +"StreetNumberNumeric": "23266" +"StructureType": "House" +"TaxLot": "38" +"UniversalPropertyId": "US-06059-N-80826104-R-N" +"View": "Mountain(s), Peek-A-Boo" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Main Floor Bedroom",\n "EatingArea": "Dining Room",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1117318108",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117318108')" +"CurrentPrice": 1295000.0 +"provider_name": "CRMLS" +"RecordSignature": -1772171666 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:80826104" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "43354" +"OriginatingSystemListAgentMemberKey": "9227702" +"Media": array:19 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] …11 ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5583 +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] } ] +success: true +page_size: 5 +page_count: 135387 +count: 676932 +after_key: "" } ] ]