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: cb0ebc957f1a57351daa3df680917545053f6606db96b3f7a93ce9f08e1137bf" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4932 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111570661" +"ListingId": "ML82001846" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T00:37:20Z" +"RFModificationTimestamp": "2025-06-14T17:35:25.809850+00:00" +"ListPrice": 4495000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 10455.0 +"LivingArea": 2700.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94062" +"UnparsedAddress": "964 Blandford Boulevard, Redwood City, California 94062" +"Coordinates": array:2 [ 0 => -122.25244429 1 => 37.48379458 ] +"Latitude": 37.48379458 +"Longitude": -122.25244429 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brian Ayer" +"ListOfficeName": "Golden Gate Sotheby's International Realty" +"ListAgentMlsId": "ML479981" +"ListOfficeMlsId": "ML81663" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Beautifully updated Spanish Revival home seamlessly blending modern luxury with exceptional craftsmanship and designer finishes. Located on one of the most coveted streets in the prestigious Edgewood Park neighborhood, the home offers the perfect balance of quiet elegance and refinement. The main house features all en-suite bedrooms, while a detached ADU with a fully updated bathroom and kitchenette offers a private retreat for guests or a stunning home office. The sophisticated dining room, with its vaulted ceilings, infuses the space with light and airiness, creating an ideal setting for dinner parties or family gatherings. Just off the dining room, a private patio is the perfect setting before or after dinner to enjoy peaceful moments while meeting neighbors or listening to the sounds of nature. The nearly quarter acre property has an oversized garage with over-height ceilings, and a utility basement, providing ample space for any family. An electric automobile gate, along with backyard perimeter fencing, provides a secure space for children, or dogs. Set in the heart of Silicon Valley, it is just minutes from commute routes, Stanford University, and some of the world's leading technology companies. Rarely does a home of this caliber and prime location become available." +"Appliances": "Dishwasher,Gas Cooktop,Disposal,Microwave,Refrigerator,Range Hood,Vented Exhaust Fan,Warming Drawer,Dryer,Washer" +"ArchitecturalStyle": "Spanish" +"BathroomsFull": 4 +"CLIP": 6720981264 +"CloseDate": "2025-06-20" +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-25" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-04-10T13:40:43.291270+00:00" +"DaysOnMarket": 15 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": " Cross Street: Turnsworth Ave" +"Fencing": "Wood" +"FireplaceFeatures": "Family Room,Outside" +"FireplaceYN": true +"Flooring": "Tile, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Fireplace(s)" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Utility Room,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-242-2473" +"ListAgentEmail": "brian@brianayer.com" +"ListAgentFirstName": "Brian" +"ListAgentKey": "20890330" +"ListAgentKeyNumeric": "20890330" +"ListAgentLastName": "Ayer" +"ListAgentOfficePhone": "650-847-1141" +"ListAgentStateLicense": "01870281" +"ListAgentURL": "http://www.brianayer.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-847-1282" +"ListOfficeKey": "4763867" +"ListOfficeKeyNumeric": "4763867" +"ListOfficePhone": "650-847-1141" +"ListOfficeURL": "https://www.sothebysrealty.com/goldengatesir/eng" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-10" +"ListingKeyNumeric": 1111570661 +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.24 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 10455.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Pending" +"OccupantType": "Owner" +"OffMarketDate": "2025-04-25" +"OffMarketTimestamp": "2025-04-26T07:50:19Z" +"OnMarketDate": "2025-04-10" +"OnMarketTimestamp": "2025-04-09T18:50:33Z" +"OriginalEntryTimestamp": "2025-04-09T18:22:24Z" +"OriginalListPrice": 4495000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374220636" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "052031160" +"ParkingFeatures": "Gated" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-26T22:14:40Z" +"PhotosCount": 37 +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-04-25" +"Roof": "Other, Tile" +"RoomType": "Den,Laundry,Other,Utility Room" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111570661" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-25T17:00:00Z" +"StoriesTotal": "1" +"StreetName": "Blandford" +"StreetNumber": "964" +"StreetNumberNumeric": "964" +"StreetSuffix": "Boulevard" +"UniversalPropertyId": "US-06081-N-052031160-R-N" +"VirtualTourURLBranded": "https://www.964blandford.com" +"VirtualTourURLUnbranded": "https://www.964blandford.com/mls/181312196" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R10010" +"CustomFields": """ {\n "RoomType": "Walk-In Closet,Den,Laundry,Utility Room",\n "RoomKitchenFeatures": "Quartz Counters,Kitchen Island",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1111570661"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111570661')" +"CurrentPrice": 4495000.0 +"provider_name": "CRMLS" +"RecordSignature": -173977358 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:052031160" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368558463" +"OriginatingSystemListAgentMemberKey": "368706421" +"Media": array:37 [ 0 => array:58 [ …58] 1 => array:58 [ …58] 2 => array:58 [ …58] 3 => array:58 [ …58] 4 => array:58 [ …58] 5 => array:58 [ …58] 6 => array:58 [ …58] 7 => array:58 [ …58] 8 => array:58 [ …58] 9 => array:58 [ …58] 10 => array:58 [ …58] 11 => array:58 [ …58] 12 => array:58 [ …58] 13 => array:58 [ …58] 14 => array:58 [ …58] 15 => array:58 [ …58] 16 => array:58 [ …58] 17 => array:58 [ …58] 18 => array:58 [ …58] 19 => array:58 [ …58] 20 => array:58 [ …58] 21 => array:58 [ …58] 22 => array:58 [ …58] 23 => array:58 [ …58] 24 => array:58 [ …58] 25 => array:58 [ …58] 26 => array:58 [ …58] 27 => array:58 [ …58] 28 => array:58 [ …58] 29 => array:58 [ …58] 30 => array:58 [ …58] 31 => array:58 [ …58] 32 => array:58 [ …58] 33 => array:58 [ …58] 34 => array:58 [ …58] 35 => array:58 [ …58] 36 => array:58 [ …58] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114158360" +"ListingId": "ML82007052" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T00:36:09Z" +"RFModificationTimestamp": "2025-06-14T17:36:59.758554+00:00" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1413.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94065" +"UnparsedAddress": "526 Shorebird Circle 16101, Redwood City, California 94065" +"Coordinates": array:2 [ 0 => -122.25477021 1 => 37.5322713 ] +"Latitude": 37.5322713 +"Longitude": -122.25477021 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joanne Jordan" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "ML5084730" +"ListOfficeMlsId": "ML39593" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This rare ground-floor corner unit offers stunning water views from every window, with a large primary suite featuring sliding glass doors to a spacious patio where you can relax to the sound of a tranquil water feature. The updated kitchen boasts quartz counters, while both bathrooms have newer vanities, adding modern comfort. The living room includes a cozy fireplace and access to the patio, and convenient amenities such as an in-unit washer/dryer hook-up, assigned parking with nearby gate access, and a storage unit in the garage enhance functionality. Residents can also enjoy community features like a pool and walking trails, making this a truly desirable waterfront residence." +"Appliances": "Dishwasher, Disposal, Microwave, Refrigerator" +"ArchitecturalStyle": "Mediterranean" +"AssociationFee": "659.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Redwood Shores Homeowners Association" +"AssociationYN": true +"BathroomsFull": 2 +"BuildingName": "Shorebird Circle" +"CLIP": 2477253050 +"CloseDate": "2025-06-26" +"CoListAgentAOR": "MLSListings" +"CoListAgentDirectPhone": "650-504-2693" +"CoListAgentEmail": "chris.molnar@cbnorcal.com" +"CoListAgentFirstName": "Chris" +"CoListAgentFullName": "Chris Molnar" +"CoListAgentKey": "21015076" +"CoListAgentKeyNumeric": "21015076" +"CoListAgentLastName": "Molnar" +"CoListAgentMlsId": "ML5084549" +"CoListAgentOfficePhone": "(650) 558-4200" +"CoListAgentStateLicense": "01384174" +"CoListAgentURL": "http://www.Chris Molnar Home.com" +"CoListOfficeAOR": "MLSListings" +"CoListOfficeFax": "650-347-4067" +"CoListOfficeKey": "4762530" +"CoListOfficeKeyNumeric": "4762530" +"CoListOfficeMlsId": "ML39593" +"CoListOfficeName": "Coldwell Banker Realty" +"CoListOfficePhone": "(650) 558-4200" +"CommonInterest": "Condominium" +"CommunityFeatures": "Pool" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-15T20:14:48.754481+00:00" +"DaysOnMarket": 28 +"DaysOnMarketReplication": 28 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "Marine Parkway, right on Island Drive, right on Shorebird Circle. Drive towards end of Shorebird and building is 526 located by inner lagoon. Cross Street: Island Drive" +"FireplaceFeatures": "Living Room,Wood Burning" +"FireplaceYN": true +"Flooring": "Carpet, Laminate" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Breakfast Bar" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-400-3503" +"ListAgentEmail": "jjordan@cbnorcal.com" +"ListAgentFax": "650-343-3892" +"ListAgentFirstName": "Joanne" +"ListAgentKey": "21015184" +"ListAgentKeyNumeric": "21015184" +"ListAgentLastName": "Jordan" +"ListAgentOfficePhone": "(650) 558-4200" +"ListAgentStateLicense": "00876824" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-347-4067" +"ListOfficeKey": "4762530" +"ListOfficeKeyNumeric": "4762530" +"ListOfficePhone": "(650) 558-4200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-15" +"ListingKeyNumeric": 1114158360 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Pending" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-13" +"OffMarketTimestamp": "2025-06-13T10:21:16Z" +"OnMarketDate": "2025-05-15" +"OnMarketTimestamp": "2025-05-15T05:22:43Z" +"OriginalEntryTimestamp": "2025-05-15T04:56:24Z" +"OriginalListPrice": 1100000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374417409" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "111620330" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-14T00:36:45Z" +"PhotosCount": 21 +"PoolFeatures": "Community" +"PropertySubTypeAdditional": "Condominium" +"PurchaseContractDate": "2025-06-12" +"Roof": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114158360" +"SpaFeatures": "Community" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"StreetName": "Shorebird" +"StreetNumber": "526" +"StreetNumberNumeric": "526" +"StreetSuffix": "Circle" +"UnitNumber": "16101" +"UniversalPropertyId": "US-06081-N-111620330-R-N" +"View": "Park/Greenbelt, Water" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "PD0000" +"CustomFields": """ {\n "EatingArea": "Breakfast Counter / Bar",\n "RoomKitchenFeatures": "Quartz Counters",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1114158360"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114158360')" +"CurrentPrice": 1100000.0 +"provider_name": "CRMLS" +"RecordSignature": -1027902030 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:111620330" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368549155" +"OriginatingSystemCoListOfficeKey": "368549155" +"OriginatingSystemListAgentMemberKey": "368830544" +"OriginatingSystemCoListAgentMemberKey": "368830436" +"Media": array:21 [ 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112582767" +"ListingId": "ML82005464" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T00:04:40Z" +"RFModificationTimestamp": "2025-06-14T17:48:00.656799+00:00" +"ListPrice": 935000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1360.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "1294 Woodside Road, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.22806022 1 => 37.45884772 ] +"Latitude": 37.45884772 +"Longitude": -122.22806022 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Robert Pedro" +"ListOfficeName": "Signature Realty & Mortgage" +"ListAgentMlsId": "ML153040" +"ListOfficeMlsId": "ML37462" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Beautiful first floor luxury condominium located in the back of the community for extra privacy and serenity. Buyers value includes: 2 Bedrooms, 2 bathrooms, formal entry, large living room with fireplace, dining area with sliding doors to the front patio area, eat-in kitchen with double over, electric cooktop, and plenty of cabinet space, Laundry room area, primary bedroom suite with walk-in closet, double sink and updated shower area, sliding doors to the large backyard which is perfect for relaxation and enjoyment. The backyard includes a patio, deck and beautiful tree for extra privacy and serenity. The beautiful wood floors and plantation shutters add to the elegance of this beautiful condo. The park-like common area grounds include majestic redwood trees, lush landscaping and pool area for additional enjoyment. This condo is conveniently located near Parks, schools, hwy 101 & 280, The town of Woodside and Downtown Redwood City, Woodside plaza shops, restaurants and other services. Also located nearby several employment center such as Sand Hill Road, Box Inc., Google Seaport Blvd. campus, Stanford Medical Redwood City, Meta/Facebook and many others..." +"Appliances": "Double Oven,Dishwasher,Electric Cooktop,Disposal,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Clubhouse,Management,Pool,Spa/Hot Tub,Trash" +"AssociationFee": "885.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Common Interest Management Services" +"AssociationPhone": "650-286-0292" +"AssociationYN": true +"BathroomsFull": 2 +"BuildingName": "Woodside Road Condominium" +"CLIP": 2328548371 +"CarportSpaces": "1.0" +"CarportYN": true +"CloseDate": "2025-06-23" +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-23" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-05T15:22:43.667574+00:00" +"DaysOnMarket": 18 +"DaysOnMarketReplication": 18 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "You pull into the second driveway then park. There is a walkway towards the rear of the community. Take the walkway and the condo will be on your left on the first floor. Thank you. Cross Street: Virginia Avenue" +"ElementarySchool": "Other" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile, Wood" +"HeatingYN": true +"HighSchool": "Woodside" +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Breakfast Area,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "415-722-5510" +"ListAgentEmail": "robert@robertpedro.com" +"ListAgentFax": "(800) 387-6169" +"ListAgentFirstName": "Robert" +"ListAgentKey": "20889438" +"ListAgentKeyNumeric": "20889438" +"ListAgentLastName": "Pedro" +"ListAgentOfficePhone": "650-368-8600" +"ListAgentStateLicense": "01179093" +"ListAgentURL": "http://www.Robert Pedro.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "800-387-6169" +"ListOfficeKey": "4762519" +"ListOfficeKeyNumeric": "4762519" +"ListOfficePhone": "650-368-8600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-05" +"ListingKeyNumeric": 1112582767 +"ListingService": "Full Service" +"ListingTerms": "Cal Vet Loan" +"LivingAreaSource": "Assessor" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MiddleOrJuniorSchool": "John F. Kennedy" +"MlsStatus": "Pending" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-12" +"OffMarketTimestamp": "2025-06-13T09:49:46Z" +"OnMarketDate": "2025-05-05" +"OnMarketTimestamp": "2025-05-05T01:05:39Z" +"OriginalEntryTimestamp": "2025-05-05T00:44:50Z" +"OriginalListPrice": 1050000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374355229" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "110850170" +"ParkingFeatures": "Carport, Guest" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-14T00:04:47Z" +"PhotosCount": 41 +"PoolFeatures": "Association" +"PreviousListPrice": 1050000.0 +"PriceChangeTimestamp": "2025-05-20T01:35:37Z" +"PropertySubTypeAdditional": "Condominium" +"PurchaseContractDate": "2025-05-23" +"Roof": "Composition" +"RoomType": "Den, Entry/Foyer, Laundry, Office, Other, Retreat" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112582767" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"StoriesTotal": "1" +"StreetName": "Woodside" +"StreetNumber": "1294" +"StreetNumberNumeric": "1294" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06081-N-110850170-R-N" +"View": "Park/Greenbelt" +"ViewYN": true +"VirtualTourURLBranded": "https://my.matterport.com/show/?m=t11ZE5r75QZ&" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=t11ZE5r75QZ&brand=0&mls=1&" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "RM00R3" +"CustomFields": """ {\n "RoomType": "Retreat,Walk-In Closet,Den,Formal Entry,Laundry,Office",\n "EatingArea": "Breakfast Nook,Dining Ell",\n "RoomKitchenFeatures": "Stone Counters",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1112582767"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112582767')" +"CurrentPrice": 935000.0 +"provider_name": "CRMLS" +"RecordSignature": 502943807 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:110850170" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "368549144" +"OriginatingSystemListAgentMemberKey": "368705547" +"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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112977347" +"ListingId": "ML82006039" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T23:51:38Z" +"RFModificationTimestamp": "2025-06-14T17:31:52.129597+00:00" +"ListPrice": 5395000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 1 +"BedroomsTotal": 6.0 +"LotSizeArea": 34175.0 +"LivingArea": 6751.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94062" +"UnparsedAddress": "1353 Edgewood Road, Redwood City, California 94062" +"Coordinates": array:2 [ 0 => -122.25813207 1 => 37.47985404 ] +"Latitude": 37.47985404 +"Longitude": -122.25813207 +"YearBuilt": 1920 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John Shroyer" +"ListOfficeName": "Golden Gate Sotheby's International Realty" +"ListAgentMlsId": "ML305433" +"ListOfficeMlsId": "ML80979" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Tucked away off the street behind a private gated driveway, this exquisite 3 bedroom, 3.5 bath main residence offers over 4,500 sq ft of luxurious living space, including a versatile 1,082 sq ft finished lower level. Situated on an expansive 34,187 sq ft lot, the property is a true oasis with resort-style amenities and timeless architectural details including handcrafted wrought iron fixtures, custom woodwork, and natural stone accents. The main level boasts a chefs kitchen with a spacious center island, walk-in pantry, and top-of-the-line appliances, seamlessly connecting to the informal dining area with fireplace and the welcoming living room. A formal dining room with bay window, an additional seating area, and entry level half bath enhance the homes versatility. French doors open to the backyard featuring a sparkling pool, lounging patio, mature landscaping, and curated hardscape. The upstairs primary suite retreat offers soaring beam ceilings, a private balcony, and a spa-like bath. Two additional en-suite bedrooms and a thoughtfully designed laundry room complete the upper level. Detached three-car garage along with a 3 bedroom, 3 bath, 2,240 sqft ADU. Located moments away from the downtown San Carlos and Redwood City, parks, hiking, shopping and streamlined commute routes." +"Appliances": "Dishwasher, Refrigerator" +"BasementYN": true +"BathroomsFull": 6 +"CLIP": 8488896558 +"CarportSpaces": "1.0" +"CarportYN": true +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-08" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-08T22:35:09.234951+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 36 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Don Court" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Wood" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Attic,Utility Room" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-787-2121" +"ListAgentEmail": "john@johnshroyer.com" +"ListAgentFirstName": "John" +"ListAgentKey": "20890152" +"ListAgentKeyNumeric": "20890152" +"ListAgentLastName": "Shroyer" +"ListAgentOfficePhone": "(650) 597-1800" +"ListAgentStateLicense": "00613370" +"ListAgentURL": "http://www.johnshroyer.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "(650) 597-1200" +"ListOfficeKey": "4763863" +"ListOfficeKeyNumeric": "4763863" +"ListOfficePhone": "(650) 597-1800" +"ListOfficeURL": "http://www.goldengatesir.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112977347 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.7846 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 34175.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T07:20:49Z" +"OriginalEntryTimestamp": "2025-05-08T07:01:26Z" +"OriginalListPrice": 5395000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374377788" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "058040640" +"ParkingFeatures": "Covered, Carport" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-05-17T02:18:41Z" +"PhotosCount": 97 +"PoolFeatures": "In Ground,Pool Cover" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Attic,Basement,Entry/Foyer,Utility Room" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112977347" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-08T07:01:26Z" +"StoriesTotal": "3" +"StreetName": "Edgewood" +"StreetNumber": "1353" +"StreetNumberNumeric": "1353" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06081-N-058040640-R-N" +"VirtualTourURLBranded": "https://www.1353Edgewood.com" +"VirtualTourURLUnbranded": "https://www.1353Edgewood.com/mls/188038051" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R10015" +"CustomFields": """ {\n "RoomType": "Attic,Utility Room,Formal Entry,Basement",\n "AdminUpdateYN": "0",\n "ListingKey": "1112977347"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112977347')" +"CurrentPrice": 5395000.0 +"provider_name": "CRMLS" +"RecordSignature": 1834230482 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:058040640" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558459" +"OriginatingSystemListAgentMemberKey": "368706110" +"Media": array:97 [ 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] 47 => array:57 [ …57] 48 => array:57 [ …57] 49 => array:57 [ …57] 50 => array:57 [ …57] 51 => array:57 [ …57] 52 => array:57 [ …57] 53 => array:57 [ …57] 54 => array:57 [ …57] 55 => array:57 [ …57] 56 => array:57 [ …57] 57 => array:57 [ …57] 58 => array:57 [ …57] 59 => array:57 [ …57] 60 => array:57 [ …57] 61 => array:57 [ …57] 62 => array:57 [ …57] 63 => array:57 [ …57] 64 => array:57 [ …57] 65 => array:57 [ …57] 66 => array:57 [ …57] 67 => array:57 [ …57] 68 => array:57 [ …57] 69 => array:57 [ …57] 70 => array:57 [ …57] 71 => array:57 [ …57] 72 => array:57 [ …57] 73 => array:57 [ …57] 74 => array:57 [ …57] 75 => array:57 [ …57] 76 => array:57 [ …57] 77 => array:57 [ …57] 78 => array:57 [ …57] 79 => array:57 [ …57] 80 => array:57 [ …57] 81 => array:57 [ …57] 82 => array:57 [ …57] 83 => array:57 [ …57] 84 => array:57 [ …57] 85 => array:57 [ …57] 86 => array:57 [ …57] 87 => array:57 [ …57] 88 => array:57 [ …57] 89 => array:57 [ …57] 90 => array:57 [ …57] 91 => array:57 [ …57] 92 => array:57 [ …57] 93 => array:57 [ …57] 94 => array:57 [ …57] 95 => array:57 [ …57] 96 => array:57 [ …57] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115098110" +"ListingId": "ML82010276" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T23:51:38Z" +"RFModificationTimestamp": "2025-06-14T17:35:26.212591+00:00" +"ListPrice": 3695000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 25145.0 +"LivingArea": 4000.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94062" +"UnparsedAddress": "1690 Cordilleras Road, Redwood City, California 94062" +"Coordinates": array:2 [ 0 => -122.26139945 1 => 37.4749981 ] +"Latitude": 37.4749981 +"Longitude": -122.26139945 +"YearBuilt": 1920 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John Shroyer" +"ListOfficeName": "Golden Gate Sotheby's International Realty" +"ListAgentMlsId": "ML305433" +"ListOfficeMlsId": "ML80979" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Nestled on a spectacular 25,145 sqft creek-side lot, this distinguished estate blends the grandeur of Old World architecture with the sophistication of modern upgrades. A true legacy property, it offers 5 spacious bedrooms, 5 beautifully appointed bathrooms, and a thoughtfully updated interior rich with historic character and luxurious touches. From the formal entry, step into an inviting living room featuring soaring vaulted, wood-beamed ceilings, and ambient iron chandeliers paired with a stately brick fireplace. The formal dining room, also graced with a fireplace, stunning paneled walls, coffered ceiling, and vintage inspired chandelier provides the perfect backdrop for refined entertaining. The remodeled kitchen is a culinary delight, with granite countertops that opens to a casual dining area bathed in natural light. Multiple living spaces accommodate every lifestyle, including a library, den/study, family room, entry parlor, and versatile utility/ laundry room. A private au pair or guest quarters adds flexibility for extended stays or multigenerational living. Throughout the home, gleaming hardwood floors, imported inlayed ceilings, and rich wood-paneled walls echo the craftsmanship of a bygone era, while modern systems and tasteful upgrades ensure effortless daily living." +"Appliances": "Dishwasher, Microwave, Refrigerator" +"AttachedGarageYN": true +"BathroomsFull": 5 +"CLIP": 1042729609 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-06-09" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-09T21:13:35.214470+00:00" +"DaysOnMarket": 5 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Canyon Road" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-787-2121" +"ListAgentEmail": "john@johnshroyer.com" +"ListAgentFirstName": "John" +"ListAgentKey": "20890152" +"ListAgentKeyNumeric": "20890152" +"ListAgentLastName": "Shroyer" +"ListAgentOfficePhone": "(650) 597-1800" +"ListAgentStateLicense": "00613370" +"ListAgentURL": "http://www.johnshroyer.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "(650) 597-1200" +"ListOfficeKey": "4763863" +"ListOfficeKeyNumeric": "4763863" +"ListOfficePhone": "(650) 597-1800" +"ListOfficeURL": "http://www.goldengatesir.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-09" +"ListingKeyNumeric": 1115098110 +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.5772 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 25145.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-09" +"OnMarketTimestamp": "2025-06-09T04:35:10Z" +"OriginalEntryTimestamp": "2025-06-09T04:12:36Z" +"OriginalListPrice": 3695000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374553616" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "058011020" +"ParkingFeatures": "Off Street" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-13T23:22:44Z" +"PhotosCount": 67 +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Other" +"RoomType": "Entry/Foyer" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115098110" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-09T04:12:36Z" +"StoriesTotal": "1" +"StreetName": "Cordilleras" +"StreetNumber": "1690" +"StreetNumberNumeric": "1690" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06081-N-058011020-R-N" +"VirtualTourURLBranded": "https://www.1690cordilleras.com" +"VirtualTourURLUnbranded": "https://www.1690cordilleras.com" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R10010" +"CustomFields": """ {\n "RoomType": "Formal Entry",\n "AdminUpdateYN": "0",\n "ListingKey": "1115098110"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115098110')" +"CurrentPrice": 3695000.0 +"provider_name": "CRMLS" +"RecordSignature": -154009873 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:058011020" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558459" +"OriginatingSystemListAgentMemberKey": "368706110" +"Media": array:67 [ 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] 47 => array:57 [ …57] 48 => array:57 [ …57] 49 => array:57 [ …57] 50 => array:57 [ …57] 51 => array:57 [ …57] 52 => array:57 [ …57] 53 => array:57 [ …57] 54 => array:57 [ …57] 55 => array:57 [ …57] 56 => array:57 [ …57] 57 => array:57 [ …57] 58 => array:57 [ …57] 59 => array:57 [ …57] 60 => array:57 [ …57] 61 => array:57 [ …57] 62 => array:57 [ …57] 63 => array:57 [ …57] 64 => array:57 [ …57] 65 => array:57 [ …57] 66 => array:57 [ …57] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112149750" +"ListingId": "ML82000615" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T23:36:59Z" +"RFModificationTimestamp": "2025-06-14T17:40:12.926864+00:00" +"ListPrice": 5145000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 19166.0 +"LivingArea": 3650.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94062" +"UnparsedAddress": "629 Lombardy Way, Redwood City, California 94062" +"Coordinates": array:2 [ 0 => -122.27118899 1 => 37.46171919 ] +"Latitude": 37.46171919 +"Longitude": -122.27118899 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Laura Bertolacci" +"ListOfficeName": "Christie's International Real Estate Sereno" +"ListAgentMlsId": "ML5062170" +"ListOfficeMlsId": "ML5009052" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "a "10" Gated estate with Panoramic Bay Views~Experience luxury & modern convenience with Over-the-top finishes~on nearly a half-acre parcel. Newly renovated by Collected Interiors with stunning design details! It features 5 spacious beds, incl 4 en-suite, 4.5 spa like baths & a 3-car garage. A custom build by Ravella Construction highly regarded for amazing quality & detail. Hardwood floors, Anderson sliding & French doors, soaring 20' ceilings & custom window coverings enhance the bright, inviting ambiance. Gourmet kitchen boasts a large island, Viking 6 burner range, quartzites countertops, custom marble backsplash & walk-in pantry. The open floor plan flows seamlessly into expansive living room with gas fireplace & custom lighting. The formal dining room has built-in cabinetry & moldings, plus French sliding doors. The primary suite with bay views features a brand-new spa-like bath with herringbone marble floors, soaking tub & dual-head shower. The professionally landscaped backyard is a private oasis with a pool, raised spa, outdoor kitchen & pergola-covered dining area. Located in prestigious Emerald Hills, convenient to top-rated Roy Cloud School, Emerald Lake Golf & Country Club, Edgewood Park hiking trails, Sand Hill Corridor, Stanford, SF & Silicon Valley. A must see." +"Appliances": "Dishwasher, Refrigerator" +"ArchitecturalStyle": "Craftsman, Modern" +"AttachedGarageYN": true +"BathroomsFull": 4 +"CLIP": 7647288303 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-24" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-04-24T22:34:40.185016+00:00" +"DaysOnMarket": 51 +"DaysOnMarketReplication": 50 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Temescal Way" +"ElementarySchool": "Other" +"FireplaceFeatures": "Family Room,Living Room" +"FireplaceYN": true +"Flooring": "Stone, Wood" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Woodside" +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Breakfast Area,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-575-3822" +"ListAgentEmail": "laura@laurabertolacci.com" +"ListAgentFax": "650-486-1536" +"ListAgentFirstName": "Laura" +"ListAgentKey": "20867140" +"ListAgentKeyNumeric": "20867140" +"ListAgentLastName": "Bertolacci" +"ListAgentOfficePhone": "(650) 486-1555" +"ListAgentStateLicense": "00868180" +"ListAgentURL": "http://www.Laura Bertolacci.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-486-1536" +"ListOfficeKey": "4764117" +"ListOfficeKeyNumeric": "4764117" +"ListOfficePhone": "(650) 486-1555" +"ListOfficeURL": "www.dwellagents.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-24" +"ListingKeyNumeric": 1112149750 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Secluded" +"LotSizeAcres": 0.44 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 19166.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-04-24" +"OnMarketTimestamp": "2025-04-24T06:09:15Z" +"OriginalEntryTimestamp": "2025-04-23T17:00:00Z" +"OriginalListPrice": 5145000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374297089" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "068082200" +"ParkingFeatures": "Gated" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-13T23:37:44Z" +"PhotosCount": 45 +"Possession": "Close Of Escrow" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Den, Entry/Foyer, Laundry, Other, Retreat" +"ShowingContactPhone": "650-575-3822" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112149750" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-02T04:04:19Z" +"StoriesTotal": "2" +"StreetName": "Lombardy" +"StreetNumber": "629" +"StreetNumberNumeric": "629" +"StreetSuffix": "Way" +"UniversalPropertyId": "US-06081-N-068082200-R-N" +"View": "Bay, Mountain(s), Water" +"ViewYN": true +"VirtualTourURLBranded": "http://www.629lombardy.com" +"VirtualTourURLUnbranded": "http://www.629lombardy.com/mls/179821891" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R1" +"CustomFields": """ {\n "RoomType": "Retreat,Walk-In Closet,Den,Formal Entry,Laundry",\n "EatingArea": "Breakfast Nook",\n "RoomKitchenFeatures": "Quartz Counters,Kitchen Island",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1112149750"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112149750')" +"CurrentPrice": 5145000.0 +"provider_name": "CRMLS" +"RecordSignature": -794586701 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:068082200" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558684" +"OriginatingSystemListAgentMemberKey": "368671907" +"Media": array:45 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1116610730" +"ListingId": "ML82010475" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T23:36:59Z" +"RFModificationTimestamp": "2025-06-14T17:40:35.109125+00:00" +"ListPrice": 1900000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6000.0 +"LivingArea": 1842.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "739 Quartz Street, Redwood City, California 94061" +"Coordinates": array:2 [ 0 => -122.2408282 1 => 37.47070221 ] +"Latitude": 37.47070221 +"Longitude": -122.2408282 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Suzanne Yost" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML5099224" +"ListOfficeMlsId": "ML5009477" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this charming 3-bedroom, 2-bathroom home located in the heart of Redwood City. With a spacious 1842 sq ft of living space, this property offers comfort and convenience. The kitchen is a highlight, equipped with modern amenities including a dishwasher, garbage disposal, refrigerator, and a skylight that provides natural light. Enjoy meals in the cozy breakfast nook or host gatherings in the formal dining room. The home features quality flooring throughout and a welcoming fireplace. Additional amenities include central AC for cooling and forced air heating. Laundry is made easy with a washer and dryer included. The property is conveniently located close to Red Morton Park and Community Center. With a lot size of 6000 sq ft, this home offers ample outdoor space with lovely rose bushes. The single garage space adds convenience to this delightful residence. Don't miss the opportunity to make this lovely house your new home in Redwood City!" +"Appliances": "Dishwasher, Disposal, Refrigerator, Dryer, Washer" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 7508389569 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-11T13:50:37.525847+00:00" +"DaysOnMarket": 4 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Madison" +"FireplaceFeatures": "Living Room,Wood Burning" +"FireplaceYN": true +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Breakfast Area" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "831-818-0413" +"ListAgentEmail": "suzanneyost.realtor@gmail.com" +"ListAgentFax": "408-358-1199" +"ListAgentFirstName": "Suzanne" +"ListAgentKey": "22768482" +"ListAgentKeyNumeric": "22768482" +"ListAgentLastName": "Yost" +"ListAgentOfficePhone": "(408) 358-1111" +"ListAgentStateLicense": "00758189" +"ListOfficeAOR": "MLSListings" +"ListOfficeKey": "4763269" +"ListOfficeKeyNumeric": "4763269" +"ListOfficePhone": "(408) 358-1111" +"ListOfficeURL": "http://compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1116610730 +"ListingService": "Full Service" +"LivingAreaSource": "Other" +"LotFeatures": "Level" +"LotSizeAcres": 0.1377 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6000.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-10" +"OnMarketTimestamp": "2025-06-10T09:49:48Z" +"OriginalEntryTimestamp": "2025-06-10T09:34:02Z" +"OriginalListPrice": 1900000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374563287" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "058182150" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T16:12:47Z" +"PhotosCount": 73 +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1116610730" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-10T09:34:02Z" +"StoriesTotal": "1" +"StreetName": "Quartz" +"StreetNumber": "739" +"StreetNumberNumeric": "739" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06081-N-058182150-R-N" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R10006" +"CustomFields": """ {\n "EatingArea": "Breakfast Nook",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1116610730"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1116610730')" +"CurrentPrice": 1900000.0 +"provider_name": "CRMLS" +"RecordSignature": -1231042657 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:058182150" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368557561" +"OriginatingSystemListAgentMemberKey": "372243179" +"Media": array:73 [ 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] 47 => array:57 [ …57] 48 => array:57 [ …57] 49 => array:57 [ …57] 50 => array:57 [ …57] 51 => array:57 [ …57] 52 => array:57 [ …57] 53 => array:57 [ …57] 54 => array:57 [ …57] 55 => array:57 [ …57] 56 => array:57 [ …57] 57 => array:57 [ …57] 58 => array:57 [ …57] …14 ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1108646019" +"ListingId": "ML81997870" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T22:33:29Z" +"RFModificationTimestamp": "2025-06-14T18:17:18.374266+00:00" +"ListPrice": 3998999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 15167.0 +"LivingArea": 2000.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94062" +"UnparsedAddress": "3803 Hamilton Way, Redwood City, California 94062" +"Coordinates": array:2 [ …2] +"Latitude": 37.46375787 +"Longitude": -122.26050413 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cher Rowland" +"ListOfficeName": "Intero Real Estate Services" +"ListAgentMlsId": "ML5072933" +"ListOfficeMlsId": "ML29158" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Single-Story 4 Bedroom, 2 Full Bath Exceptionally Renovated and Constructed Home located on expansive 15,000+ sq.ft. lot with park-like setting in the sought after Emerald Hills Neighborhood. 6-7 car driveway with garage and Electric Vehicle Hookup (240v/50amp). This private, quite and secluded neighborhood is NOT a thoroughfare, is located just a few blocks from Roy Cloud Elementary School District, provides Spectacular Views of the Bay Area, both San Mateo and Dumbarton Bridges, and is just minutes away from the markets, restaurants and downtown Redwood City amenities. Too many upgrades to list. No details spared on renovation. Remarkably, as well, inspection reports verify no dry rot, no termites - an amazingly dry piece of property! Move in for life and enjoy serenity and peace of mind." +"AccessibilityFeatures": "Parking,Accessible Doors" +"Appliances": "Disposal,Microwave,Refrigerator,Range Hood" +"ArchitecturalStyle": "Ranch" +"AttachedGarageYN": true +"BasementYN": true +"BathroomsFull": 2 +"CLIP": 6625772735 +"CarportSpaces": "7.0" +"CarportYN": true +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-03-13" +"Cooling": "Central Air,Whole House Fan" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-03-14T22:38:00.960421+00:00" +"DaysOnMarket": 93 +"DaysOnMarketReplication": 92 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "Southwest" +"Directions": "Hwy 280 to Farmhill Blvd; Left on Emerald Hill Road; Left on Jefferson to Lakeview with a Right to Hamilton OR right on E Lakeview, drive down and around with a Left to Hamilton. Street is private and resident only Cross Street: E Lakeview Way" +"ElementarySchool": "Other" +"Fencing": "Partial, Wood" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Wood" +"FoundationDetails": "Combination" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Central, Fireplace(s)" +"HeatingYN": true +"HighSchool": "Woodside" +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Utility Room,Workshop" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-477-0722" +"ListAgentEmail": "crowland5@me.com" +"ListAgentFirstName": "Cher" +"ListAgentKey": "20870092" +"ListAgentKeyNumeric": "20870092" +"ListAgentLastName": "Rowland" +"ListAgentOfficePhone": "(650) 543-7740" +"ListAgentStateLicense": "01338545" +"ListAgentURL": "http://www.cherrowland.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-543-7749" +"ListOfficeKey": "4764073" +"ListOfficeKeyNumeric": "4764073" +"ListOfficePhone": "(650) 543-7740" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-13" +"ListingKeyNumeric": 1108646019 +"ListingService": "Full Service" +"LivingAreaSource": "Other" +"LotSizeAcres": 0.3482 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 15167.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-03-13" +"OnMarketTimestamp": "2025-03-13T11:52:48Z" +"OriginalEntryTimestamp": "2025-03-13T11:30:15Z" +"OriginalListPrice": 4050000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374078891" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "057234010" +"ParkingFeatures": "Electric Vehicle Charging Station(s)" +"ParkingTotal": "8.0" +"PatioAndPorchFeatures": "Deck" +"PhotosChangeTimestamp": "2025-06-13T00:52:43Z" +"PhotosCount": 46 +"PreviousListPrice": 4050000.0 +"PriceChangeTimestamp": "2025-04-29T03:37:49Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"RoomType": "Basement,Den,Laundry,Retreat,Utility Room,Workshop" +"Sewer": "Public Sewer" +"ShowingContactPhone": "650.477.0722" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108646019" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-13T11:30:15Z" +"StoriesTotal": "1" +"StreetName": "Hamilton" +"StreetNumber": "3803" +"StreetNumberNumeric": "3803" +"StreetSuffix": "Way" +"UniversalPropertyId": "US-06081-N-057234010-R-N" +"View": "Bay, Bridge(s), Hills, Neighborhood, Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://youtu.be/8Iy Ob-ma Vb0" +"VirtualTourURLUnbranded": "https://tours.robertbarbuttiphotography.com/2311534?idx=1" +"WaterSource": "Public" +"WindowFeatures": "Bay Window(s)" +"YearBuiltSource": "Assessor" +"Zoning": "RH0S18" +"CustomFields": """ {\n "RoomType": "Retreat,Basement,Den,Laundry,Utility Room,Workshop",\n "EatingArea": "In Living Room",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1108646019"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108646019')" +"CurrentPrice": 3998999.0 +"provider_name": "CRMLS" +"RecordSignature": 1075954339 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:057234010" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368558639" +"OriginatingSystemListAgentMemberKey": "368675403" +"Media": array:46 [ …46] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114715891" +"ListingId": "ML82008913" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-13T22:05:58Z" +"RFModificationTimestamp": "2025-06-14T18:34:44.335395+00:00" +"ListPrice": 1240000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1178.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94065" +"UnparsedAddress": "394 Genoa Drive, Redwood City, California 94065" +"Coordinates": array:2 [ …2] +"Latitude": 37.54178005 +"Longitude": -122.23589688 +"YearBuilt": 1995 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Arlene Sullivan" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "ML5084316" +"ListOfficeMlsId": "ML39593" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Updated Townhouse with beautiful views of water and nature! Enter into a bright living room with hi ceilings, lovely fireplace, sliding doors to inviting deck area. Spacious dining area for formal or casual entertaining. Cheerful Kitchen with an abundance of natural light that features a gas stove, quartz counters, stainless steel appliances, ample cabinet space, recessed lighting and room for additional dining or great area for a desk for those that work from home. Upstairs you will find two generous bedrooms each with their on bathrooms, the primary bedroom has two closets, large tub with shower. Both feature high ceilings and a neutral palette. Attached two car garage with extra storage area. Well appointed complex that has lovely pool, spa area, and beautiful landscaping. Low HOA of $447.00 a month. Redwood Shores offers nature trails, library, parks, shopping, elementary schools, and a relaxed atmosphere, yet close access for the commuter too!" +"Appliances": "Disposal, Microwave, Refrigerator" +"AssociationAmenities": "Pool,Spa/Hot Tub" +"AssociationFee": "447.0" +"AssociationName": "Manor" +"AssociationPhone": "650-637-1616" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuildingName": "The Cove at California Bayside" +"CLIP": 8421224333 +"CloseDate": "2025-07-14" +"CommunityFeatures": "Pool" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-30T17:51:02.393415+00:00" +"DaysOnMarket": 14 +"DaysOnMarketReplication": 13 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "located in beautiful Redwood shores- you can take the Redwood Shores parkway - just one block east of Shearwater you will see Genoa, make a left and the unit is in the first building - easy to find and easy parking Cross Street: Meridian Drive or other cross street Redwood Parkway on the backside of complex-" +"FireplaceFeatures": "Gas Starter,Living Room" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-703-1830" +"ListAgentEmail": "asullivan@cbnorcal.com" +"ListAgentFirstName": "Arlene" +"ListAgentKey": "20858561" +"ListAgentKeyNumeric": "20858561" +"ListAgentLastName": "Sullivan" +"ListAgentOfficePhone": "(650) 558-4200" +"ListAgentStateLicense": "01053539" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-347-4067" +"ListOfficeKey": "4762530" +"ListOfficeKeyNumeric": "4762530" +"ListOfficePhone": "(650) 558-4200" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-30" +"ListingKeyNumeric": 1114715891 +"LivingAreaSource": "Assessor" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active Under Contract" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-30" +"OnMarketTimestamp": "2025-05-30T03:06:01Z" +"OriginalEntryTimestamp": "2025-05-29T17:00:00Z" +"OriginalListPrice": 1240000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374500420" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "113360150" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-13T15:55:47Z" +"PhotosCount": 34 +"PoolFeatures": "Community, Association" +"Possession": "Close Of Escrow" +"PropertySubTypeAdditional": "Condominium" +"PurchaseContractDate": "2025-06-12" +"Roof": "Composition, Other" +"Sewer": "Public Sewer" +"ShowingContactPhone": "650-703-1830" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114715891" +"SpaFeatures": "Community" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"StreetName": "Genoa" +"StreetNumber": "394" +"StreetNumberNumeric": "394" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06081-N-113360150-R-N" +"VirtualTourURLBranded": "https://www.homeatanywhere.com/394-Genoa-Drive-Redwood-Shores-CA-94065/index.html" +"VirtualTourURLUnbranded": "https://www.homeatanywhere.com/394-Genoa-Drive-Redwood-Shores-CA-94065/mlsindex.html" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R30000" +"CustomFields": """ {\n "RoomKitchenFeatures": "Quartz Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1114715891"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114715891')" +"CurrentPrice": 1240000.0 +"provider_name": "CRMLS" +"RecordSignature": 1955160586 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:113360150" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368549155" +"OriginatingSystemListAgentMemberKey": "368621073" +"Media": array:34 [ …34] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111195469" +"ListingId": "41091920" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T21:30:55Z" +"RFModificationTimestamp": "2025-06-13T22:26:01.668028+00:00" +"ListPrice": 1999000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 7285.0 +"LivingArea": 1512.0 +"BuildingAreaTotal": 0 +"City": "Redwood City" +"PostalCode": "94061" +"UnparsedAddress": "1692 Maryland St, Redwood City, California 94061" +"Coordinates": array:2 [ …2] +"Latitude": 37.45453597 +"Longitude": -122.23730226 +"YearBuilt": 1951 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Richard Hoag" +"ListOfficeName": "Richard Hoag, Broker" +"ListAgentMlsId": "CCBE-159515634BE" +"ListOfficeMlsId": "CCBE-SRZW01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Gorgeous remodeled WOODSIDE PLAZA rancher. Premium 7,280+ sq ft level lot in a coveted neighborhood. This picture-perfect home offers 3 bedrooms/2.5 bathrooms in the main living area and a separate ensuite studio/guest room with kitchenette and full bathroom. Enjoy all the modern amenities and features are you are seeking including: Central AC/furnace, fireplace with decorative mantel, stylish stainless steel appliance package (Kitchen Aid refrigerator, Jenn-Air 5-burner gas stove/oven, Bosch dishwasher, built-in microwave), new kitchen/bathroom cabinetry with quartz countertops, tile backsplash, durable plank flooring, recessed LED lighting and solar tubes, new door hardware, double-pane windows, home office, two car attached garage with epoxy floor coating, colorful landscaping/gardens and covered rear patio, stamped concrete walkways, beautiful paver stone driveway, and so much more. Excellent mid-Peninsula location with easy access to area shopping, dining, entertainment, and commute routes. Do not miss the opportunity to call this wonderful home yours! Open House Saturday 6/14 1:00PM to 3:30PM" +"Appliances": "Gas Water Heater" +"ArchitecturalStyle": "Ranch, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 5494113084 +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-04-03" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-04-16T08:56:48.975468+00:00" +"CumulativeDaysOnMarket": 96 +"DaysOnMarket": 72 +"DaysOnMarketReplication": 71 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Massachusetts-Maryland Cross Street: Massachusetts." +"FireplaceFeatures": "Living Room,Wood Burning" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air,Natural Gas" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "Bay East" +"ListAgentDirectPhone": "925-876-1460" +"ListAgentEmail": "rich@richardhoag.com" +"ListAgentFirstName": "Richard" +"ListAgentKey": "21669087" +"ListAgentKeyNumeric": "21669087" +"ListAgentLastName": "Hoag" +"ListAgentOfficePhone": "925-876-1460" +"ListAgentStateLicense": "01487192" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "rich@richardhoag.com" +"ListOfficeKey": "5748746" +"ListOfficeKeyNumeric": "5748746" +"ListOfficePhone": "925-876-1460" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-03" +"ListingKeyNumeric": 1111195469 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "Back Yard,Sprinklers Timer,Street Level" +"LotSizeAcres": 0.1672 +"LotSizeSource": "Measured" +"LotSizeSquareFeet": 7285.0 +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-04-03" +"OnMarketTimestamp": "2025-04-03T05:29:51Z" +"OriginalEntryTimestamp": "2025-04-03T12:20:57Z" +"OriginalListPrice": 2298000.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374183719" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "069074080" +"ParkingFeatures": "Garage,Garage Door Opener,Off Street" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-13T02:52:46Z" +"PhotosCount": 38 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 2198000.0 +"PriceChangeTimestamp": "2025-05-21T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"RoomType": "Family Room,Office" +"Sewer": "Public Sewer" +"ShowingContactName": "Richard Hoag" +"ShowingContactPhone": "925-876-1460" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111195469" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-28T17:00:00Z" +"Stories": "1" +"StreetName": "Maryland St" +"StreetNumber": "1692" +"StreetNumberNumeric": "1692" +"SubdivisionName": "WOODSIDE PLAZA" +"UniversalPropertyId": "US-06081-N-069074080-R-N" +"CustomFields": """ {\n "RoomType": "Family Room,Office",\n "RoomKitchenFeatures": "Remodeled Kitchen",\n "RoomBathroomFeatures": "Shower in Tub,Tile Counters,Upgraded",\n "AdminUpdateYN": "0",\n "ListingKey": "1111195469"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111195469')" +"CurrentPrice": 1999000.0 +"provider_name": "CRMLS" +"RecordSignature": -760014376 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:069074080" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "373737660" +"OriginatingSystemListAgentMemberKey": "370235988" +"Media": array:38 [ …38] } ] +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 {#5489 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5488 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115044718" +"ListingId": "OC25127680" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:47.363769+00:00" +"ListPrice": 5700000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13503.6 +"LivingArea": 2047.0 +"BuildingAreaTotal": 0 +"City": "Corona Del Mar" +"PostalCode": "92625" +"UnparsedAddress": "4621 Hampden Rd, Corona Del Mar, California 92625" +"Coordinates": array:2 [ …2] +"Latitude": 33.589326 +"Longitude": -117.859593 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lynn Paris" +"ListOfficeName": "Pinnacle Real Estate Group" +"ListAgentMlsId": "OCPARILYN" +"ListOfficeMlsId": "OC06746" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Elegant Coastal Living | Beautifully Remodeled Home in the Coveted Cameo Shores Community! As a resident of Cameo Shores, you enjoy exclusive access to the stunning private beaches, unlocked by your key to two separate entrances. These beaches are not only breathtaking, featuring incredible rock formations, but also offer a sense of privacy that's hard to find elsewhere. Additionally, residents can take advantage of scenic beach trails that meander through the picturesque Pelican Hill Golf Course, providing a perfect blend of nature and recreation. The unique pathways in the community connect you seamlessly to Third Beach in Corona del Mar and Crystal Cove State Beach, allowing for easy enjoyment of walking and surfing. Ultimately, you also have the opportunity to explore the beautiful Crystal Cove State Park, as well as the charming Village of Corona Del Mar, thereby enhancing your coastal living experience.\r\r\n This stunning property is situated on a rare 0.31-acre lot with great appreciation potential, Nestled in a private corner, this home features a tranquil backyard, front yard, and side yard that ensure ample natural light and privacy. Floor-to-ceiling windows beautifully integrate the natural landscape of the yard with the open-concept layout. The spacious design includes a large kitchen, a generous master suite, two additional bedrooms, a home office, and an outdoor dining terrace, all thoughtfully arranged. The garage and front yard provide convenient parking options. The entire home has undergone extensive renovation and upgrading.\r\r\n .A significant highlight is the rare 0.31-acre lot, which offers the potential for an ADU expansion or the construction of a new luxury home up to 8,000 square feet, complete with architect-designed plans included. This property presents tremendous potential for appreciation.\r\r\n Community Amenities: The private park and playground in Cameo Shores provide a safe space for families, allowing children and pets to play freely.\r\r\n Excellent School District: Rated 10/10, offering outstanding educational resources.Low Property HOA: Only $1,050 per year. For more details please don't hesitate to contact Lynn Paris at 949-351-1343. """ +"AssociationAmenities": "Dog Park,Golf Course,Jogging Path,Management,Barbecue,Picnic Area,Playground,Guard,Security,Trail(s)" +"AssociationFee": "1050.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Powerstone Property Management" +"AssociationPhone": "9493724022" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-351-1343" +"BathroomsFull": 3 +"CLIP": 6289835863 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Dog Park" +"Contingency": "N" +"ContractStatusChangeDate": "2024-06-01" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-07T06:26:21.386886+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "N/A" +"DocumentsChangeTimestamp": "2025-06-08T09:24:52Z" +"DocumentsCount": 1 +"ElementarySchool": "Harbor View" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Newport Harbor" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "lynnlinparis@gmail.com" +"ListAgentFirstName": "Lynn" +"ListAgentKey": "21318104" +"ListAgentKeyNumeric": "21318104" +"ListAgentLastName": "Paris" +"ListAgentOfficePhone": "626-888-9808" +"ListAgentStateLicense": "02193706" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "usnationalrealty@gmail.com" +"ListOfficeFax": "626-986-5345" +"ListOfficeKey": "3275512" +"ListOfficeKeyNumeric": "3275512" +"ListOfficePhone": "626-888-9808" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-01" +"ListingKeyNumeric": 1115044718 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,1031 Exchange" +"LivingAreaSource": "Public Records" +"LotFeatures": "Sprinklers In Front,Sprinklers On Side,Value In Land" +"LotSizeAcres": 0.31 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 13503.6 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-06T23:02:41Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Corona Del Mar" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "3" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T23:02:41Z" +"OriginalEntryTimestamp": "2025-06-06T23:02:41Z" +"OriginalListPrice": 5700000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374548978" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "47505411" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-08T16:33:40Z" +"PhotosCount": 42 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office" +"Sewer": "Public Sewer" +"ShowingContactName": "Lynn Paris" +"ShowingContactPhone": "9493511343" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115044718" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T23:02:41Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Hampden Rd" +"StreetNumber": "4621" +"StreetNumberNumeric": "4621" +"StructureType": "House" +"TaxLot": "n" +"UniversalPropertyId": "US-06059-N-47505411-R-N" +"View": "Park/Greenbelt,Golf Course,Ocean,Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://www.wellcomemat.com/video/5979bb66942c1m6fu/CDM/CA/92625/Hampden-Rd/OC25127680/" +"VirtualTourURLUnbranded": "https://www.wellcomemat.com/mls/5979bb66942c1m6fu" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office",\n "AdminUpdateYN": "0",\n "ListingKey": "1115044718",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115044718')" +"CurrentPrice": 5700000.0 +"provider_name": "CRMLS" +"RecordSignature": 2080925851 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:47505411" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "143572682" +"OriginatingSystemListAgentMemberKey": "369525581" +"Media": array:42 [ …42] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5691 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112991539" +"ListingId": "ML82006135" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:32.027614+00:00" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 4.25 +"LivingArea": 950.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "38500 Paseo Padre Pkwy 102, Fremont, California 94536" +"Coordinates": array:2 [ …2] +"Latitude": 37.55788739 +"Longitude": -121.98683642 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nisha Singh" +"ListOfficeName": "eXp Realty of California Inc" +"ListAgentMlsId": "ML5101215" +"ListOfficeMlsId": "ML5009355" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover modern living in heart of Fremont in the highly desirable Parkmont neighborhood! This spacious condo has an ideal floor plan that includes a large living room, sizable bedrooms, kitchen and a formal dining area. Parkmont Gardens community includes ideal amenities including a lush greenbelt and a swimming pool! This home is in an excellent commuter location, walking distance from BART and nearby Centerville Train Station, 880 freeway, 680 freeway and Niles Canyon. Around the corner from multiple shopping centers, Whole Foods, Centerville Community Park, Alameda Creek Trail, great schools and beloved local eateries! This home is a must see!" +"Appliances": "Gas Cooktop,Refrigerator" +"AssociationAmenities": "Trash" +"AssociationFee": "550.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Parkmont Gardens HOA" +"AssociationPhone": "925-495-4545" +"AssociationYN": true +"BathroomsFull": 1 +"CLIP": 8478246755 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-09T04:14:15.565194+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: paseo padre" +"Flooring": "Carpet" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Wall Furnace" +"HeatingYN": true +"HighSchoolDistrict": "Alameda City Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentEmail": "nishasingh@gmail.com" +"ListAgentFirstName": "Nisha" +"ListAgentKey": "24251205" +"ListAgentKeyNumeric": "24251205" +"ListAgentLastName": "Singh" +"ListAgentOfficePhone": "(888) 584-942..." +"ListAgentStateLicense": "01937867" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "925-262-1171" +"ListOfficeKey": "4763658" +"ListOfficeKeyNumeric": "4763658" +"ListOfficePhone": "(888) 584-942..." +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112991539 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0001 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4.25 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T13:48:49Z" +"OriginalEntryTimestamp": "2025-05-08T13:21:18Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374380809" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "501153439" +"ParkingFeatures": "Covered,Off Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T18:36:45Z" +"PhotosCount": 7 +"PoolFeatures": "In Ground" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Other" +"Sewer": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112991539" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-08T13:21:18Z" +"StreetName": "Paseo Padre Pkwy" +"StreetNumber": "38500" +"StreetNumberNumeric": "38500" +"UnitNumber": "102" +"UniversalPropertyId": "US-06001-N-501153439-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "Residential" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1112991539"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112991539')" +"CurrentPrice": 499000.0 +"provider_name": "CRMLS" +"RecordSignature": -1685891191 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:501153439" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558053" +"OriginatingSystemListAgentMemberKey": "372906814" +"Media": array:7 [ …7] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5692 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112308116" +"ListingId": "25531679" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:19.378602+00:00" +"ListPrice": 414500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5320.0 +"LivingArea": 726.0 +"BuildingAreaTotal": 726.0 +"City": "San Bernardino" +"PostalCode": "92411" +"UnparsedAddress": "1256 W 6th Street, San Bernardino, California 92411" +"Coordinates": array:2 [ …2] +"Latitude": 34.110461 +"Longitude": -117.312781 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eran Fattal" +"ListOfficeName": "Dynasty Real Estate" +"ListAgentMlsId": "CLW-C103971" +"ListOfficeMlsId": "CLW-X78890" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "REMODELED FHA APPROVED HOME: 3 BEDS PLUS 1.5 BATH. (PUBLIC RECORDS SHOW 2 PLUS 1) NEW DUAL PANE WINDOWS. REPLACED CENTRAL AIR AND HEAT. NEW CUSTOM PORCELAIN TILE FLOORING IN KITCHEN, LIVING ROOM, BATHROOMS, AND LAUNDRY ROOM. NEW GRAY RUSTIC STYLE LAMINATE FLOORING IN BEDROOMS. THE KITCHEN IS BRAND NEW. NEW CUSTOM KITCHEN CABINETS, NEW QUARTZ STONE COUNTERS, NEW GARBAGE DISPOSAL, NEW PULL-OUT FAUCET. NEW BATHTUB, NEW TILED UP SHOWERS WALLS WITH ELEGANT MOSAIC DESIGN, NEW VANITIES. NEW TOILETS. ALL NEW PLUMBING FIXTURES. NEW LIGHT FIXTURES. NEW PAINT INSIDE AND OUT. NEW GARAGE DOOR. FHA/VA/DOWN PAYMENT ASSISTANCE/OK" +"Appliances": "Disposal" +"ArchitecturalStyle": "See Remarks" +"BathroomsFull": 1 +"BuyerFinancing": "Conventional, FHA, VA" +"CLIP": 8804738686 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-29T19:32:38.644803+00:00" +"DaysOnMarket": 46 +"DaysOnMarketReplication": 46 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "PLEASE REFER TO GOOGLE MAPS" +"FireplaceFeatures": "None" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Out of Area Board" +"ListAgentDirectPhone": "747-343-1266" +"ListAgentEmail": "eranfattal@icloud.com" +"ListAgentFax": "909-373-2515" +"ListAgentFirstName": "Eran" +"ListAgentKey": "17056852" +"ListAgentKeyNumeric": "17056852" +"ListAgentLastName": "Fattal" +"ListAgentOfficePhone": "909-373-2505" +"ListAgentStateLicense": "01304180" +"ListOfficeAOR": "Out of Area Board" +"ListOfficeFax": "909-373-2515" +"ListOfficeKey": "3237841" +"ListOfficeKeyNumeric": "3237841" +"ListOfficePhone": "909-373-2505" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112308116 +"ListingService": "Entry Only" +"LotSizeAcres": 0.1221 +"LotSizeDimensions": "38x140" +"LotSizeSquareFeet": 5320.0 +"MLSAreaMajor": "274 - San Bernardino" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T04:31:51Z" +"OriginalEntryTimestamp": "2025-04-29T11:17:09Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374319567" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "0138052070000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-29T20:25:39Z" +"PhotosCount": 8 +"PoolFeatures": "None" +"PostalCodePlus4": "2705" +"PreviousListPrice": 425000.0 +"PriceChangeTimestamp": "2025-06-14T16:51:35Z" +"PropertySubTypeAdditional": "Single Family Residence" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112308116" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-29T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "6th" +"StreetNumber": "1256" +"StreetNumberNumeric": "1256" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06071-N-0138052070000-R-N" +"View": "None" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112308116"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112308116')" +"CurrentPrice": 414500.0 +"provider_name": "CRMLS" +"RecordSignature": -791365164 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0138052070000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "113814" +"OriginatingSystemListAgentMemberKey": "442704" +"Media": array:8 [ …8] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5693 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117318108" +"ListingId": "PW25130551" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:31.621904+00:00" +"ListPrice": 1295000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7800.0 +"LivingArea": 1463.0 +"BuildingAreaTotal": 0 +"City": "Mission Viejo" +"PostalCode": "92691" +"UnparsedAddress": "23266 Via Ronda, Mission Viejo, California 92691" +"Coordinates": array:2 [ …2] +"Latitude": 33.625063 +"Longitude": -117.655413 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Baroth" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "PWBARRAC" +"ListOfficeMlsId": "PB1364" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 23266 Via Ronda in sought after Barcelona neighborhood offering 4 bedrooms, 3 baths, a spacious entertainers backyard featuring a custom heated pool and spa, a fully insulated patio cover complete with lighting, ceiling fans and custom curtain brackets for additional shade & comfort also boast beautiful easy care tropical fauna, mature lemon and orange trees, and a versatile large playhouse/ office/ hobby room wired with electric, lighting & internet. The perfect setting for summer BBQ’s, family birthdays, holidays or romantic evening dinners. The main level open floor plan has fireplace in cathedral ceiling living room, formal dining room with bright, natural light flowing thru kitchen window box and back door facing lush back yard patio and pool. Finishing the downstairs is a large bedroom with French doors opening to backyard, currently being used as entertainment room and a full bathroom. Retreat to the upstairs primary bedroom full en suite bath with jetted tub, walk in closet completed with vanity, custom shelving and drawers. Another full bath and 2 bedrooms, one loft style that could double as home office and LVP flooring throughout complete the upstairs. Energy-efficient solar panels provide cost-saving benefits, making this home as practical as it is beautiful. Completing this home is Central HVAC system, large 2 car attached garage with washer and dryer hookups, beautiful artificial turf for low maintenance front yard, And Full Access to Lake Mission Viejo Membership and all it has to offer. Talk about location, Award winning Capistrano schools, nearby Aurora Park with fields, playground, volleyball & basketball court, beautiful wooded area for the evening strolls, fine restaurants, shopping and golf course all nearby!" +"Appliances": "Dishwasher,Gas Oven,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Controlled Access,Picnic Area,Playground" +"AssociationFee": "179.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Mission Viejo Lake Membership" +"AssociationPhone": "949-770-1313" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "rachel@rachelbaroth.com" +"BathroomsFull": 3 +"CLIP": 8991206809 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gutter(s)" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-13T03:02:02.144261+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit 5 freeway at Alicia Parkway, follow Alicia Parkway to Right on Via Aura to Right on Via Ronda" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Capistrano Valley" +"HighSchoolDistrict": "Capistrano Unified" +"Inclusions": "Refrigerator" +"InteriorFeatures": "Cathedral Ceiling(s),Separate/Formal Dining Room,Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "rachel@rachelbaroth.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "17072220" +"ListAgentKeyNumeric": "17072220" +"ListAgentLastName": "Baroth" +"ListAgentOfficePhone": "562-989-4608" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01396461" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-989-4803" +"ListOfficeKey": "3284761" +"ListOfficeKeyNumeric": "3284761" +"ListOfficePhone": "562-989-4608" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Open" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1117318108 +"ListingService": "Entry Only" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1791 +"LotSizeDimensions": "130 x 60" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T16:53:41Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T16:53:41Z" +"OriginalEntryTimestamp": "2025-06-12T16:53:41Z" +"OriginalListPrice": 1295000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374576329" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "80826104" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-15T06:51:40Z" +"PhotosCount": 19 +"PoolFeatures": "Gas Heat,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2229" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Anthony" +"ShowingContactPhone": "949-334-7305" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117318108" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T16:53:41Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Via Ronda" +"StreetNumber": "23266" +"StreetNumberNumeric": "23266" +"StructureType": "House" +"TaxLot": "38" +"UniversalPropertyId": "US-06059-N-80826104-R-N" +"View": "Mountain(s), Peek-A-Boo" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Main Floor Bedroom",\n "EatingArea": "Dining Room",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1117318108",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117318108')" +"CurrentPrice": 1295000.0 +"provider_name": "CRMLS" +"RecordSignature": -1772171666 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:80826104" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "43354" +"OriginatingSystemListAgentMemberKey": "9227702" +"Media": array:19 [ …19] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5689 +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: "" } ] ]