2744 Properties
Sort by:
40252 Bonica Rose Terrace , Fremont, CA 94538
40252 Bonica Rose Terrace , Fremont, CA 94538 Details
11 hours ago
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: 8ef51c769dcb2fd693a4e1883bdb8a3768fac59dcb9eeca36a52ef35fce8e8d4" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4916 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115086741" +"ListingId": "ML82008862" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T23:25:05Z" +"RFModificationTimestamp": "2025-06-15T00:18:41.581807+00:00" +"ListPrice": 1799999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 3327.0 +"LivingArea": 1950.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94555" +"UnparsedAddress": "34307 Quartz Terrace, Fremont, California 94555" +"Coordinates": array:2 [ 0 => -122.0540336 1 => 37.56299689 ] +"Latitude": 37.56299689 +"Longitude": -122.0540336 +"YearBuilt": 1989 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sanjay Mitra" +"ListOfficeName": "Intero Real Estate Services" +"ListAgentMlsId": "ML5083899" +"ListOfficeMlsId": "ML33259" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Wake up to Golden Rays and live in Light all Day in this Sun Drenched Sanctuary!! Welcome to East Facing Modern Home on Spacious Lot Nestled in a quiet and peaceful neighborhood. This meticulously maintained 1950 sqft 4 bed 2.5 bath home welcomes you with Soaring Vaulted Ceilings and where Sunlight pours in from every angle, creating a space that's as uplifting as it is beautiful.. The interior features newly installed seamless luxury vinyl and Carpet flooring , complemented by recessed lighting and new updated bathrooms. .Fresh paint inside enhances the home's move in ready appeal. The generous 3,327 soft lot offers low-maintenance pavered backyard with Banana, Pomergranate,Lemon and Orange trees. Lots of storage-with Level 2 EV charger in the two car garage. Solar panels on roof is paid off. Located near Forest Park Elementary School, this home offers exceptional convenience. Enjoy easy access to local amenities diverse dining options, and coffee shops all within walking distance. The location provides a quick commute to major employers via I-84, I-880, Facebook/Google shuttles, BART. Experience Peninsula-adjacent living at a more attractive price point, walking distance to Forest Park elementary completing this compelling package. Offer due date on 6/18th at 12pm" +"Appliances": "Dishwasher" +"ArchitecturalStyle": "Contemporary" +"AssociationFee": "38.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Association of Northern California" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 9037516122 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-06-09" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-09T15:41:47.672958+00:00" +"DaysOnMarket": 5 +"DaysOnMarketReplication": 5 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "East" +"Directions": "Google Maps Cross Street: Google Maps" +"ElementarySchool": "Other" +"Fencing": "Wood" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Solar" +"HeatingYN": true +"HighSchool": "Other" +"HighSchoolDistrict": "Fremont Unified" +"InteriorFeatures": "Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-476-1337" +"ListAgentEmail": "smitra@intero.com" +"ListAgentFirstName": "Sanjay" +"ListAgentKey": "20858388" +"ListAgentKeyNumeric": "20858388" +"ListAgentLastName": "Mitra" +"ListAgentOfficePhone": "(510) 651-6500" +"ListAgentStateLicense": "02102959" +"ListAgentURL": "http://sanjaym.agent.intero.com/" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "510-651-1545" +"ListOfficeKey": "4763917" +"ListOfficeKeyNumeric": "4763917" +"ListOfficePhone": "(510) 651-6500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-09" +"ListingKeyNumeric": 1115086741 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.0764 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 3327.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-09" +"OnMarketTimestamp": "2025-06-09T01:19:09Z" +"OriginalEntryTimestamp": "2025-06-08T17:00:00Z" +"OriginalListPrice": 1799999.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374552586" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "5430458071" +"ParkingFeatures": "Electric Vehicle Charging Station(s),Guest" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-14T23:25:43Z" +"PhotosCount": 56 +"Possession": "Close Of Escrow" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"RoomType": "Other" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115086741" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-29T06:13:04Z" +"StoriesTotal": "2" +"StreetName": "Quartz" +"StreetNumber": "34307" +"StreetNumberNumeric": "34307" +"StreetSuffix": "Terrace" +"UniversalPropertyId": "US-06001-N-5430458071-R-N" +"View": "Neighborhood" +"ViewYN": true +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=z1Aru Mnqo Vc" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R1" +"CustomFields": """ {\n "RoomType": "Walk-In Closet",\n "EatingArea": "In Living Room",\n "RoomKitchenFeatures": "Granite Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1115086741"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115086741')" +"CurrentPrice": 1799999.0 +"provider_name": "CRMLS" +"RecordSignature": -1526346697 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:5430458071" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558307" +"OriginatingSystemListAgentMemberKey": "368621041" +"Media": array:56 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112968831" +"ListingId": "41096647" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:43:44Z" +"RFModificationTimestamp": "2025-06-15T00:36:14.732555+00:00" +"ListPrice": 1485000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6300.0 +"LivingArea": 1442.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94538" +"UnparsedAddress": "5682 Turban Court, Fremont, California 94538" +"Coordinates": array:2 [ 0 => -121.97499211 1 => 37.51495972 ] +"Latitude": 37.51495972 +"Longitude": -121.97499211 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sheetal Kasliwal" +"ListOfficeName": "ValleyVentures Realty Inc" +"ListAgentMlsId": "CCBE-206534937" +"ListOfficeMlsId": "CCBE-SATV01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": ""TRANSPARENT PRICING, OPEN HOUSE ON SUNDAY" - Experience the unparalleled blend of prime location, vibrant atmosphere, and ultimate convenience in Central Fremont! This meticulously upgraded home is a true standout. The impressive curb appeal welcomes you with a lush synthetic lawn, elegant stacked stone siding, stucco exterior, a newer roof and a fully owned SOLAR. Inside, the open-concept design is bathed in natural light, fresh paint, retextured ceilings, custom craftsman doors, gleaming laminate floors, Recessed lighting throughout, custom fireplace hearth and mantle, creating a cozy ambiance. The chef-inspired kitchen boasts gorgeous granite countertops, a stylish mosaic backsplash, generous cabinetry and upscale stainless steel appliances. Retreat to the expansive master suite, with a spacious walk-in closet, elegant master bath featuring a rain shower and direct patio access. Beautifully landscaped backyard offering stamped concrete, bistro lights, Citrus fruit trees, and tall fences ensuring your privacy makes this home special. Other upgrades include dual-pane windows, copper pipes, a water softener, NEST-ready technology, central heat and air conditioning, French drains, and a finished garage — Easy access to major freeways and just a short walk to three parks." +"Appliances": "Gas Water Heater,Water Softener" +"ArchitecturalStyle": "Ranch" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 4609799254 +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-08T23:22:51.292745+00:00" +"CumulativeDaysOnMarket": 115 +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Yellowstone Park/Butano Park/Turban Cross Street: Buffalo Park." +"FireplaceFeatures": "Dining Room,Gas" +"FireplaceYN": true +"Flooring": "Laminate, Tile" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "Bay East" +"ListAgentEmail": "realtor.sheetal@gmail.com" +"ListAgentFirstName": "Sheetal" +"ListAgentKey": "21673234" +"ListAgentKeyNumeric": "21673234" +"ListAgentLastName": "Kasliwal" +"ListAgentOfficePhone": "925-413-0269" +"ListAgentStateLicense": "01929261" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "Realtorsunny@gmail.com" +"ListOfficeKey": "5092442" +"ListOfficeKeyNumeric": "5092442" +"ListOfficePhone": "925-413-0269" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112968831 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "Back Yard,Cul-De-Sac,Street Level" +"LotSizeAcres": 0.1446 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 6300.0 +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T05:28:47Z" +"OriginalEntryTimestamp": "2025-05-08T12:12:04Z" +"OriginalListPrice": 1647000.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374376431" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "53121554" +"ParkingFeatures": "Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-08T19:46:44Z" +"PhotosCount": 37 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 1647000.0 +"PriceChangeTimestamp": "2025-06-10T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"RoomType": "Kitchen" +"Sewer": "Public Sewer" +"ShowingContactName": "Listing Agent" +"ShowingContactPhone": "9259973432" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112968831" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-10T17:00:00Z" +"Stories": "1" +"StreetName": "Turban Court" +"StreetNumber": "5682" +"StreetNumberNumeric": "5682" +"SubdivisionName": "SOUTHPARK AREA" +"UniversalPropertyId": "US-06001-N-53121554-R-N" +"View": "Hills" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Xr H2Fpoh2dq" +"CustomFields": """ {\n "RoomType": "Kitchen",\n "RoomBathroomFeatures": "Shower in Tub,Bathtub",\n "AdminUpdateYN": "0",\n "ListingKey": "1112968831"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112968831')" +"CurrentPrice": 1485000.0 +"provider_name": "CRMLS" +"RecordSignature": 97057978 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:53121554" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "370140191" +"OriginatingSystemListAgentMemberKey": "370233462" +"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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115038072" +"ListingId": "ML82009294" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:21:23Z" +"RFModificationTimestamp": "2025-06-14T22:34:35.526725+00:00" +"ListPrice": 775000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 870.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94538" +"UnparsedAddress": "3698 Vision 318, Fremont, California 94538" +"Coordinates": array:2 [ 0 => -121.94526822 1 => 37.49870525 ] +"Latitude": 37.49870525 +"Longitude": -121.94526822 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Laxmi Penupothula" +"ListOfficeName": "Intero Real Estate Services" +"ListAgentMlsId": "ML5105219" +"ListOfficeMlsId": "ML38424" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Modern comfort meets upscale convenience in this beautifully upgraded condo, ideally located in Fremonts vibrant Innovation District. Highlights include a custom frameless glass door for the shower/tub combo and sand-colored zebra shades that offer blackout privacy, soft natural light, and energy-efficient cooling. Enjoy secure 1-car garage parking and exclusive access to the Chroma buildings luxury lounge, fully equipped gym, and serene courtyard. As part of a master-planned community, youll also benefit from a resort-style pool, fire pits, and a second fitness centerperfect for work-life balance. Commuters will love the quick access to Warm Springs BART, while families will appreciate the proximity to top-rated schools and nearby parks. Just minutes away, Pacific Commons offers a wide variety of shops, restaurants, and entertainment. Plus, the home is conveniently located near major tech and automotive campuses, making your daily routine easier and more connected. With tasteful upgrades, lifestyle amenities, and an unbeatable location, this condo offers exceptional value in one of Fremonts most desirable neighborhoods." +"AssociationAmenities": "Trash" +"AssociationFee": "588.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Helsing Group HOA & First Service HOA" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 1 +"CLIP": 1023666375 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-06-06" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-07T03:01:08.043996+00:00" +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "880 N to Cuishion Fremont East to Innovation Right to Vision Common. Cross Street: Innovation" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "Fremont Unified" +"InteriorFeatures": "Breakfast Bar" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "510-493-1955" +"ListAgentEmail": "laxmi.penupothula@gmail.com" +"ListAgentFirstName": "Laxmi" +"ListAgentKey": "26208413" +"ListAgentKeyNumeric": "26208413" +"ListAgentLastName": "Penupothula" +"ListAgentOfficePhone": "(408) 357-5700" +"ListAgentStateLicense": "02047105" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "408-357-5701" +"ListOfficeKey": "4763026" +"ListOfficeKeyNumeric": "4763026" +"ListOfficePhone": "(408) 357-5700" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1115038072 +"LivingAreaSource": "Other" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T09:20:28Z" +"OriginalEntryTimestamp": "2025-06-05T17:00:00Z" +"OriginalListPrice": 775000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374547039" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "5191764274" +"ParkingFeatures": "Underground, Gated" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T04:10:44Z" +"PhotosCount": 70 +"PropertySubTypeAdditional": "Condominium" +"Roof": "Composition" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115038072" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-02T01:23:16Z" +"StreetName": "Vision" +"StreetNumber": "3698" +"StreetNumberNumeric": "3698" +"UnitNumber": "318" +"UniversalPropertyId": "US-06001-N-5191764274-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "N/A" +"CustomFields": """ {\n "EatingArea": "Breakfast Counter / Bar",\n "AdminUpdateYN": "0",\n "ListingKey": "1115038072"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115038072')" +"CurrentPrice": 775000.0 +"provider_name": "CRMLS" +"RecordSignature": -1973081580 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:5191764274" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368557205" +"OriginatingSystemListAgentMemberKey": "374281628" +"Media": array:70 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117377397" +"ListingId": "41101459" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:12:04Z" +"RFModificationTimestamp": "2025-06-14T22:37:29.916530+00:00" +"ListPrice": 29500000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 193842.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94539" +"UnparsedAddress": "41246 Mission Blvd, Fremont, California 94539" +"Coordinates": array:2 [ 0 => -121.936869 1 => 37.548495 ] +"Latitude": 37.548495 +"Longitude": -121.936869 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chuck Edell" +"ListOfficeName": "REALTY EXPERTS" +"ListAgentMlsId": "CCBE-206502183" +"ListOfficeMlsId": "CCBE-SGGL01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Exceptional development opportunity in Mission San Jose! Located directly across from Mission San Jose High School, this approx. 4.45-acre parcel must be sold with the adjoining 0.46-acre parcel at 41252 Mission Blvd. Together, these properties offer a rare chance for development in one of Fremont’s most desirable neighborhoods. Ideal for builders, developers, and investors. Buyer to verify zoning, land use, development potential, and any restrictions with the City of Fremont." +"CLIP": 4280782845 +"ContractStatusChangeDate": "2025-06-13" +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-14T09:10:04.697094+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Mission Blvd Cross Street: Driscoll." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Bay East" +"ListAgentDirectPhone": "510-468-8467" +"ListAgentEmail": "chuck@realtyexperts.com" +"ListAgentFirstName": "Chuck" +"ListAgentKey": "21659269" +"ListAgentKeyNumeric": "21659269" +"ListAgentLastName": "Edell" +"ListAgentOfficePhone": "510-226-2444" +"ListAgentStateLicense": "00584793" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "bill@realtyexperts.com" +"ListOfficeFax": "510-623-6979" +"ListOfficeKey": "5103692" +"ListOfficeKeyNumeric": "5103692" +"ListOfficePhone": "510-226-2444" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-13" +"ListingKeyNumeric": 1117377397 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotSizeAcres": 4.45 +"LotSizeSquareFeet": 193842.0 +"MlsStatus": "Active" +"OnMarketDate": "2025-06-13" +"OnMarketTimestamp": "2025-06-13T14:13:19Z" +"OriginalEntryTimestamp": "2025-06-13T21:02:09Z" +"OriginalListPrice": 29500000.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374585716" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "52527532" +"PhotosChangeTimestamp": "2025-06-14T04:31:45Z" +"PhotosCount": 3 +"Possession": "Close Of Escrow" +"PossibleUse": "Residential" +"PreviousListPrice": 29500000.0 +"PriceChangeTimestamp": "2025-06-12T17:00:00Z" +"ShowingContactName": "Chuck Edell, Listing Agent" +"ShowingContactPhone": "5104688467" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117377397" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"StreetName": "Mission Blvd" +"StreetNumber": "41246" +"StreetNumberNumeric": "41246" +"SubdivisionName": "MISSION SAN JOSE" +"UniversalPropertyId": "US-06001-N-52527532-R-N" +"View": "Hills" +"ViewYN": true +"WaterSource": "Public" +"WaterfrontFeatures": "Pond" +"Zoning": "call" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1117377397"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117377397')" +"CurrentPrice": 29500000.0 +"provider_name": "CRMLS" +"RecordSignature": -27838269 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:52527532" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "370205484" +"OriginatingSystemListAgentMemberKey": "370218989" +"Media": array:3 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117321256" +"ListingId": "ML82009167" +"PropertyType": "Residential" +"PropertySubType": "Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:54:18Z" +"RFModificationTimestamp": "2025-06-14T22:53:25.048593+00:00" +"ListPrice": 1348888.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 4969.0 +"LivingArea": 2047.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "37342 Sequoia Road, Fremont, California 94536" +"Coordinates": array:2 [ 0 => -122.00183385 1 => 37.56242896 ] +"Latitude": 37.56242896 +"Longitude": -122.00183385 +"YearBuilt": 2020 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Satya Dasari" +"ListOfficeName": "Keller Williams Thrive" +"ListAgentMlsId": "ML5062300" +"ListOfficeMlsId": "ML39095" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this charming 2020-built former model designer home, featuring over $ 130,000 in builder upgrades, located in top-ranked schools. This corner-unit home, located in the premier area, boasts an ideal layout with custom upgrades, 4 bedrooms, 4 baths, and a living area of 2,047 sqft. *Family and kid-friendly community, Ideal for animal lovers. *The home offers quiet living surrounded by amenities & activities for young couples & families. *The open layout features a great room combo with a bedroom & bath, a Gourmet kitchen, island, Quartz counters, backsplash, large counter space, Gas range, & SS appliances, all on one level. *This well-cared home presents at street level - large bedroom, full bath, garage, the first floor has an open layout kitchen with great room, spacious bedroom and bath, the second floor has a spacious Master suite, a walk-in closet, dual sinks & a large second suite. Upstairs laundry. *The home offers high ceilings, large windows, owned Solar panels, LVP floor, recessed lights, multi-zone heating and cooling, a tankless water heater, a water softener, an RO water filter, a 2-car garage with a Level 2 EV charger, new paint, more. *Minutes to walking trails, to Niles, Quarry Lake Regional Park, Central Park, Lake Elizabeth. BART, ACE station." +"Appliances": "Dishwasher,Gas Cooktop,Disposal,Microwave,Vented Exhaust Fan" +"AssociationAmenities": "Management, Other, Playground" +"AssociationFee": "365.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Montecito Fremont Owners Association" +"AssociationPhone": "(925) 743-3080" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 4 +"BuildingName": "Montecito" +"CLIP": 1028602154 +"CommonInterest": "Condominium" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-14T07:57:54.675914+00:00" +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Paseo Padre Parkway" +"Flooring": "Carpet, Laminate, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Other" +"HighSchoolDistrict": "Fremont Unified" +"InteriorFeatures": "Breakfast Area,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-666-6231" +"ListAgentEmail": "sadasari@gmail.com" +"ListAgentFirstName": "Satya" +"ListAgentKey": "20923730" +"ListAgentKeyNumeric": "20923730" +"ListAgentLastName": "Dasari" +"ListAgentOfficePhone": "(408) 850-6900" +"ListAgentStateLicense": "01327436" +"ListOfficeAOR": "MLSListings" +"ListOfficeEmail": "klrw479@kw.com" +"ListOfficeFax": "408-850-6901" +"ListOfficeKey": "4763601" +"ListOfficeKeyNumeric": "4763601" +"ListOfficePhone": "(408) 850-6900" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-12" +"ListingKeyNumeric": 1117321256 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.1141 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 4969.0 +"MLSAreaMajor": "699 - Not Defined" +"MiddleOrJuniorSchool": "Other" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T12:05:00Z" +"OriginalEntryTimestamp": "2025-06-11T17:00:00Z" +"OriginalListPrice": 1348888.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374577466" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "5011838041" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-14T21:55:41Z" +"PhotosCount": 45 +"Possession": "Close Of Escrow" +"PropertySubTypeAdditional": "Townhouse" +"Roof": "Tile" +"RoomType": "Other" +"Sewer": "Public Sewer" +"ShowingContactPhone": "408-666-6231" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117321256" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-30T12:28:12Z" +"StoriesTotal": "3" +"StreetName": "Sequoia" +"StreetNumber": "37342" +"StreetNumberNumeric": "37342" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06001-N-5011838041-R-N" +"VirtualTourURLBranded": "https://tourfactorybayarea.tf.media/2288618" +"VirtualTourURLUnbranded": "https://tourfactorybayarea.tf.media/x2288618" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "co" +"CustomFields": """ {\n "RoomType": "Walk-In Closet",\n "EatingArea": "Breakfast Nook",\n "RoomKitchenFeatures": "Quartz Counters,Kitchen Island",\n "AdminUpdateYN": "0",\n "ListingKey": "1117321256"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117321256')" +"CurrentPrice": 1348888.0 +"provider_name": "CRMLS" +"RecordSignature": -502099284 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:5011838041" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368557996" +"OriginatingSystemListAgentMemberKey": "368739393" +"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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114432051" +"ListingId": "41098558" +"PropertyType": "Residential" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:39:02Z" +"RFModificationTimestamp": "2025-06-14T23:04:41.431277+00:00" +"ListPrice": 1495000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 787.0 +"LivingArea": 1401.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94539" +"UnparsedAddress": "2506 Monet Ter, Fremont, California 94539" +"Coordinates": array:2 [ 0 => -121.93687972 1 => 37.51405385 ] +"Latitude": 37.51405385 +"Longitude": -121.93687972 +"YearBuilt": 2011 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mallik Reddy Kesari" +"ListOfficeName": "Realty++" +"ListAgentMlsId": "CCBE-206539277" +"ListOfficeMlsId": "CCBE-SBHG03" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Location & Schools!! Year 2011 built, stunning upgraded 3-bedroom, 3-bathroom north-east facing corner unit, a Duet, in the highly sought-after Weibel - Irvington neighborhood! This bright and inviting home features a spacious layout with 1 bedroom and 1 full bath downstairs, perfect for guests or a home office. Enjoy modern upgrades throughout, including elegant flooring and contemporary fixtures. As a prime corner unit, it offers extra privacy and abundant natural light. Located in a top-rated school district with easy access to shopping, dining, parks, and freeways: 680, 880, 237, 101, and BART, this home is a rare find in a desirable location. Reach your office & home within minutes instead of hours. Don’t miss this highly desirable location!!" +"Appliances": "Gas Water Heater,Dryer,Washer" +"ArchitecturalStyle": "Contemporary" +"AssociationAmenities": "Maintenance Grounds,Other,Playground,Water" +"AssociationFee": "235.0" +"AssociationFeeFrequency": "Monthly" +"AssociationPhone": "408-226-3300" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 3778731036 +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-05-22" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-22T20:08:17.210989+00:00" +"CumulativeDaysOnMarket": 23 +"DaysOnMarket": 23 +"DaysOnMarketReplication": 23 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Use GPS Cross Street: Durham Road." +"FireplaceFeatures": "None" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Forced Air,Natural Gas" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentAOR": "Bay East" +"ListAgentEmail": "mallik@realtyplusplus.com" +"ListAgentFirstName": "Mallik Reddy" +"ListAgentKey": "21713473" +"ListAgentKeyNumeric": "21713473" +"ListAgentLastName": "Kesari" +"ListAgentOfficePhone": "510-299-6629" +"ListAgentStateLicense": "01844867" +"ListAgentURL": "www.realtyplusplus.cmo" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "mallik@realtyplusplus.com" +"ListOfficeKey": "5105152" +"ListOfficeKeyNumeric": "5105152" +"ListOfficePhone": "510-299-6629" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-22" +"ListingKeyNumeric": 1114432051 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional, FHA" +"LotFeatures": "Corner Lot" +"LotSizeAcres": 0.0181 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 787.0 +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-22" +"OnMarketTimestamp": "2025-05-22T05:43:48Z" +"OriginalEntryTimestamp": "2025-05-22T12:16:46Z" +"OriginalListPrice": 1495000.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374456898" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "519174530" +"ParkingFeatures": "Garage,Garage Door Opener,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-05-22T20:39:41Z" +"PhotosCount": 30 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 1495000.0 +"PriceChangeTimestamp": "2025-05-21T17:00:00Z" +"Roof": "Tile" +"Sewer": "Public Sewer" +"ShowingContactName": "Mallik Reddy Kesari" +"ShowingContactPhone": "510-299-6629" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114432051" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-28T17:00:00Z" +"StreetName": "Monet Ter" +"StreetNumber": "2506" +"StreetNumberNumeric": "2506" +"SubdivisionName": "Not Listed" +"UniversalPropertyId": "US-06001-N-519174530-R-N" +"VirtualTourURLBranded": "https://my.matterport.com/show/?m=BXPLs2CAKTC&title=0&brand=0" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=BXPLs2CAKTC&title=0&brand=0" +"CustomFields": """ {\n "RoomKitchenFeatures": "Stone Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1114432051"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114432051')" +"CurrentPrice": 1495000.0 +"provider_name": "CRMLS" +"RecordSignature": 379595691 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:519174530" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "370152574" +"OriginatingSystemListAgentMemberKey": "370235387" +"Media": array:30 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117049467" +"ListingId": "41101145" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:23:49Z" +"RFModificationTimestamp": "2025-06-14T23:07:31.695352+00:00" +"ListPrice": 1299999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 8326.0 +"LivingArea": 1148.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94538" +"UnparsedAddress": "4590 Crockett Ct, Fremont, California 94538" +"Coordinates": array:2 [ 0 => -121.97680591 1 => 37.53237032 ] +"Latitude": 37.53237032 +"Longitude": -121.97680591 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Timothy Blood" +"ListOfficeName": "Excel Realty" +"ListAgentMlsId": "CCBE-206528550" +"ListOfficeMlsId": "CCBE-SNTH01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Modern Single Story Home within Walking Distance of Schools, Parks & Facebook Bus Station. Situated in a Quiet Court on a Large Lot (8326 Sq. Ft.) Amazing Curb Appeal with Drought Resistant front yard & Beautiful Deck off Kitchen in Backyard. Well Maintained inside & out: Full Updated Kitchen-including New Custom Kitchen Cabinets (Soild Wood Construction): Stainless Steel Appliances: Quartz Countertops with Quartz Backsplash: Dual Pane Windows: Central Heating & AC: Updated Bathrooms with Updated Vanities & Flooring: Cultured Marble Shower Surrounds & Updated Fixtures: Designer Interior Paint: Newly Installed High Quality Laminate Plank Flooring & Large Baseboards with Hardwood Flooring in Bedrooms: Light & Bright with Plenty of Natural Light. Modern Light Fixtures & Recessed Lighting: Updated Electrical Panel Blacow Elementary: Walters Middle & Kennedy High. Great Location: Minutes Away from Major Shopping (Pacific Commons) & Restaurants. Easy Commute Close to I-880 & Highway-84 Dumbarton Bridge. Minutes Away from Fremont BART: Move In Ready. Virtual 3-D Tour Available. Open House Sat 6-14 & Sun 6-15 from 1-4pm" +"ArchitecturalStyle": "Ranch" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3230403088 +"ConstructionMaterials": "Stucco,Wood Siding" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-13T11:18:05.619709+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Besco to Margery to Crockett Cross Street: Crockett St." +"FireplaceFeatures": "None" +"Flooring": "Laminate, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"InteriorFeatures": "Eat-in Kitchen" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "Bay East" +"ListAgentDirectPhone": "510-673-2856" +"ListAgentEmail": "timothy@timothyblood.com" +"ListAgentFirstName": "Timothy" +"ListAgentKey": "21679311" +"ListAgentKeyNumeric": "21679311" +"ListAgentLastName": "Blood" +"ListAgentOfficePhone": "925-398-6808" +"ListAgentStateLicense": "01803305" +"ListAgentURL": "www.timothyblood.com" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "louisa@soldbylouisa.com" +"ListOfficeFax": "925-401-9501" +"ListOfficeKey": "5109232" +"ListOfficeKeyNumeric": "5109232" +"ListOfficePhone": "925-398-6808" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-12" +"ListingKeyNumeric": 1117049467 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "Back Yard,Front Yard" +"LotSizeAcres": 0.1911 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 8326.0 +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T04:29:34Z" +"OriginalEntryTimestamp": "2025-06-12T11:16:19Z" +"OriginalListPrice": 1299999.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374572602" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "52596525" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Deck" +"PhotosChangeTimestamp": "2025-06-14T21:24:41Z" +"PhotosCount": 51 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 1299999.0 +"PriceChangeTimestamp": "2025-06-11T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117049467" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T17:00:00Z" +"Stories": "1" +"StreetName": "Crockett Ct" +"StreetNumber": "4590" +"StreetNumberNumeric": "4590" +"SubdivisionName": "SOUTH SUNDALE" +"UniversalPropertyId": "US-06001-N-52596525-R-N" +"VirtualTourURLBranded": "https://www.asteroommls.com/pviewer?hideleadgen=1&token=d Knd CAPUok WDDo Ik Uf3Jyg" +"VirtualTourURLUnbranded": "https://www.asteroommls.com/pviewer?hideleadgen=1&token=d Knd CAPUok WDDo Ik Uf3Jyg" +"CustomFields": """ {\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Remodeled Kitchen",\n "AdminUpdateYN": "0",\n "ListingKey": "1117049467"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117049467')" +"CurrentPrice": 1299999.0 +"provider_name": "CRMLS" +"RecordSignature": 1550405250 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:52596525" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "370141413" +"OriginatingSystemListAgentMemberKey": "370249621" +"Media": array:51 [ 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114891201" +"ListingId": "41100070" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T21:09:30Z" +"RFModificationTimestamp": "2025-06-15T00:41:19.730506+00:00" +"ListPrice": 1750800.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 2128.0 +"LivingArea": 1918.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94538" +"UnparsedAddress": "40252 Bonica Rose Terrace, Fremont, California 94538" +"Coordinates": array:2 [ 0 => -121.9741455 1 => 37.534591 ] +"Latitude": 37.534591 +"Longitude": -121.9741455 +"YearBuilt": 2009 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tim S. Wang" +"ListOfficeName": "Legacy Real Estate & Assoc." +"ListAgentMlsId": "CCBE-206535030" +"ListOfficeMlsId": "CCBE-SMMX01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "First time on the market! Welcome to the Rosewood Community—a contemporary corner single-family residence thoughtfully designed with 4 beds, 4.5 baths, 1,918 sqft of comfort, style, and functionality within a vibrant modern living space. This modern home blends clean architectural lines with sustainable materials, offering a seamless indoor-outdoor living experience. Step into a bright and airy interior featuring soaring high ceilings and floor-to-ceilings windows. The gourmet kitchen boasts granite countertops, a large center island, custom cabinetry, and premium stainless steel appliances—ideal for hosting or casual family meals. Each of the four bedrooms includes its own private bathroom, offering privacy and convenience. The luxurious primary suite serves as a private retreat with a spa-style bathroom, walk-in shower, and oversized closet. Experience the peaceful balcony retreat perfect for unwinding. Close to Lake Elizabeth park, Fremont downtown, Shopping, Foodies, Trader Joe’s, Costco, Bart, Schools, and some More!" +"ActivationDate": "2025-06-05" +"Appliances": "Dryer, Washer" +"ArchitecturalStyle": "Cottage" +"AssociationAmenities": "Insurance, Other, Playground" +"AssociationFee": "121.0" +"AssociationFeeFrequency": "Monthly" +"AssociationPhone": "925-264-8764" +"AssociationYN": true +"AttachedGarageYN": true +"BackOnMarketDate": "2025-06-06" +"BathroomsFull": 4 +"BuilderModel": "Rosewood" +"BuilderName": "Homes" +"BuyerAgentAOR": "Bay East" +"BuyerAgentEmail": "mraoavula@gmail.com" +"BuyerAgentFirstName": "Rao" +"BuyerAgentFullName": "Rao Avula" +"BuyerAgentKey": "21686176" +"BuyerAgentKeyNumeric": "21686176" +"BuyerAgentLastName": "Avula" +"BuyerAgentMlsId": "CCBE-191017144" +"BuyerAgentStateLicense": "01515079" +"BuyerOfficeAOR": "Bay East" +"BuyerOfficeEmail": "ramana@ramanareddy.com" +"BuyerOfficeKey": "5105066" +"BuyerOfficeKeyNumeric": "5105066" +"BuyerOfficeMlsId": "CCBE-SCLH01" +"BuyerOfficeName": "Cal Homes" +"BuyerOfficePhone": "408-732-2300" +"CLIP": 2605270614 +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-06T15:03:02.383460+00:00" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 7 +"DaysOnMarketReplication": 7 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "See Google, Waze, and Other Map Apps Cross Street: Laiolo Road." +"FireplaceFeatures": "None" +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"HeatingYN": true +"HighSchoolDistrict": "Fremont Unified" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Bay East" +"ListAgentEmail": "trwexpert@gmail.com" +"ListAgentFirstName": "Tim S." +"ListAgentKey": "21690098" +"ListAgentKeyNumeric": "21690098" +"ListAgentLastName": "Wang" +"ListAgentOfficePhone": "510-744-3500" +"ListAgentStateLicense": "01930839" +"ListAgentURL": "www.timwangrealty.com" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "baboumrad@legacyrea.com" +"ListOfficeFax": "510-744-3530" +"ListOfficeKey": "5109622" +"ListOfficeKeyNumeric": "5109622" +"ListOfficePhone": "510-744-3500" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1114891201 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotSizeAcres": 0.0489 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 2128.0 +"MlsStatus": "Pending" +"OccupantType": "Owner" +"OffMarketDate": "2025-06-13" +"OffMarketTimestamp": "2025-06-14T04:13:28Z" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T00:43:22Z" +"OriginalEntryTimestamp": "2025-06-04T09:54:37Z" +"OriginalListPrice": 1750800.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374524108" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "525167476" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-05T22:39:42Z" +"PhotosCount": 53 +"PoolFeatures": "None" +"Possession": "Negotiable" +"PreviousListPrice": 1750800.0 +"PriceChangeTimestamp": "2025-06-03T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-13" +"Roof": "Tile" +"Sewer": "Public Sewer" +"ShowingContactName": "Tim Wang" +"ShowingContactPhone": "510-396-2907" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114891201" +"StartShowingDate": "2025-06-05" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:00Z" +"StreetName": "Bonica Rose Terrace" +"StreetNumber": "40252" +"StreetNumberNumeric": "40252" +"SubdivisionName": "ROSEWOOD" +"UniversalPropertyId": "US-06001-N-525167476-R-N" +"VirtualTourURLBranded": "https://www.40252bonicarose.com/unbranded" +"VirtualTourURLUnbranded": "https://www.40252bonicarose.com/unbranded" +"CustomFields": """ {\n "RoomKitchenFeatures": "Stone Counters,Kitchen Island,Remodeled Kitchen",\n "AdminUpdateYN": "0",\n "ListingKey": "1114891201"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114891201')" +"CurrentPrice": 1750800.0 +"provider_name": "CRMLS" +"RecordSignature": 1082397020 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:525167476" +"CountrySubdivision": "06001" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "370205421" +"OriginatingSystemBuyerOfficeKey": "370150865" +"OriginatingSystemListAgentMemberKey": "370239805" +"OriginatingSystemBuyerAgentMemberKey": "370237010" +"Media": array:53 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114715961" +"ListingId": "ML82006639" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T21:04:00Z" +"RFModificationTimestamp": "2025-06-15T00:43:25.536007+00:00" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 840.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "37357 Sequoia Road, Fremont, California 94536" +"Coordinates": array:2 [ 0 => -122.00117 1 => 37.562198 ] +"Latitude": 37.562198 +"Longitude": -122.00117 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eddie Oberoi" +"ListOfficeName": "Intero Real Estate Services" +"ListAgentMlsId": "ML5077548" +"ListOfficeMlsId": "ML38434" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Charming 2-Bedroom Home in the Heart of Fremont Welcome to this inviting 2-bedroom, 2-bathroom home, perfectly situated in the vibrant community of Fremont. Offering 840 square feet of well-designed living space, this cozy residence is ideal for those seeking comfort, convenience, and a low-maintenance lifestyle. The kitchen comes equipped with a built-in microwave and offers a functional layout perfect for daily meal prep. Enjoy year-round comfort with ceiling fans and additional cooling options throughout the home. The open dining area and family room create a welcoming space for relaxing or entertaining guests. Take advantage of community amenities including a refreshing pool and fully equipped gymperfect for fitness and relaxation. This home is also within walking distance to the beautiful Quarry Lakes, offering scenic trails and outdoor recreation just steps away. Located in the highly regarded Fremont Unified School District and with easy access to major freeways, this home provides both an excellent location and lifestyle. Whether you're a first-time buyer, downsizer, or investor, this property presents a fantastic opportunity. Dont miss your chance to own this delightful Fremont gemschedule your tour today!" +"Appliances": "Microwave" +"AssociationAmenities": "Other,Spa/Hot Tub" +"AssociationFee": "450.0" +"AssociationName": "MANAGEMENT SOLUTIONS" +"AssociationYN": true +"BathroomsFull": 2 +"CLIP": 3182967968 +"CarportSpaces": "1.0" +"CarportYN": true +"CoListAgentAOR": "MLSListings" +"CoListAgentDirectPhone": "650-680-5259" +"CoListAgentEmail": "kthind@intero.com" +"CoListAgentFax": "(650) 947-4799" +"CoListAgentFirstName": "Kamal" +"CoListAgentFullName": "Kamal Thind" +"CoListAgentKey": "20892229" +"CoListAgentKeyNumeric": "20892229" +"CoListAgentLastName": "Thind" +"CoListAgentMlsId": "ML5083594" +"CoListAgentOfficePhone": "(650) 947-4700" +"CoListAgentStateLicense": "02128073" +"CoListAgentURL": "http://www.intero.com" +"CoListOfficeAOR": "MLSListings" +"CoListOfficeFax": "650-947-4799" +"CoListOfficeKey": "4763027" +"CoListOfficeKeyNumeric": "4763027" +"CoListOfficeMlsId": "ML38434" +"CoListOfficeName": "Intero Real Estate Services" +"CoListOfficePhone": "(650) 947-4700" +"CoListOfficeURL": "www.intero.com" +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-30" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-30T17:49:23.840056+00:00" +"DaysOnMarket": 15 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Paseo Padre" +"FoundationDetails": "Slab" +"HeatingYN": true +"HighSchoolDistrict": "Fremont Unified" +"InteriorFeatures": "Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-771-4088" +"ListAgentEmail": "eddie@eddieoberoi.com" +"ListAgentFax": "408-404-0802" +"ListAgentFirstName": "Eddie" +"ListAgentKey": "21010313" +"ListAgentKeyNumeric": "21010313" +"ListAgentLastName": "Oberoi" +"ListAgentOfficePhone": "(650) 947-4700" +"ListAgentStateLicense": "01323567" +"ListAgentURL": "Http://Www.Eddie Oberoi.Co M" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-947-4799" +"ListOfficeKey": "4763027" +"ListOfficeKeyNumeric": "4763027" +"ListOfficePhone": "(650) 947-4700" +"ListOfficeURL": "www.intero.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-30" +"ListingKeyNumeric": 1114715961 +"LivingAreaSource": "Assessor" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-30" +"OnMarketTimestamp": "2025-05-30T03:06:00Z" +"OriginalEntryTimestamp": "2025-05-29T17:00:00Z" +"OriginalListPrice": 549000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374500417" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "5011828146" +"ParkingFeatures": "Off Street" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-12T01:21:43Z" +"PhotosCount": 25 +"PropertySubTypeAdditional": "Condominium" +"Roof": "Composition" +"RoomType": "Other" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114715961" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-13T04:04:33Z" +"StoriesTotal": "1" +"StreetName": "Sequoia" +"StreetNumber": "37357" +"StreetNumberNumeric": "37357" +"StreetSuffix": "Road" +"UniversalPropertyId": "US-06001-N-5011828146-R-N" +"VirtualTourURLBranded": "https://www.zillow.com/view-imx/27aeed01-7377-421e-bb4e-fc85ee8e49f1?set Attribution=mls&wl=true&initial View Type=pano&utm_source=dashboard" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "Condo" +"CustomFields": """ {\n "RoomType": "Walk-In Closet",\n "AdminUpdateYN": "0",\n "ListingKey": "1114715961"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114715961')" +"CurrentPrice": 549000.0 +"provider_name": "CRMLS" +"RecordSignature": 321272272 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:5011828146" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368557206" +"OriginatingSystemCoListOfficeKey": "368557206" +"OriginatingSystemListAgentMemberKey": "368824654" +"OriginatingSystemCoListAgentMemberKey": "368707747" +"Media": array:25 [ 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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117376114" +"ListingId": "41101427" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T20:30:58Z" +"RFModificationTimestamp": "2025-06-14T20:53:48.006507+00:00" +"ListPrice": 2499000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 11040.0 +"LivingArea": 2838.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "295 Hillview Dr, Fremont, California 94536" +"Coordinates": array:2 [ 0 => -121.98883336 1 => 37.57693471 ] +"Latitude": 37.57693471 +"Longitude": -121.98883336 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rahul Puri" +"ListOfficeName": "Redfin" +"ListAgentMlsId": "CCBE-206530621" +"ListOfficeMlsId": "CCBE-SRFI01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Experience luxury living in this beautifully remodeled east-facing single-story home, nestled in Fremont's historic Niles neighborhood. Spanning 2,838 sq ft on an expansive 11,040 sq ft lot, this 5-bedroom, 3-bathroom residence offers spacious formal living and family rooms, a chef-inspired kitchen with granite countertops, maple cabinets, gas stove, pantry, and stainless steel appliances. The resort-style backyard is an entertainer's dream, featuring a remodeled pool (2020), gazebo, and outdoor kitchen equipped with a PGE gas-fueled premium grill, stainless-steel refrigerator, and expansive granite countertops. Enjoy low-maintenance landscaping with premium artificial turf and established drought-resistant plants. Modern upgrades include new plumbing and electrical systems with upgraded PG&E supply, dual-zone HVAC with Nest thermostats, tankless water heater, and a new roof—all completed in 2018. Additional enhancements encompass custom cabinets in the laundry room (2023), custom wardrobes in master and guest bedrooms (2023), and updated guest bedroom with new baseboards and textures (2023). Situated adjacent to the historic Niles nursery, this home offers a serene backdrop and is conveniently located near shopping centers, top-rated schools, and recreational areas." +"Appliances": "Dryer, Washer" +"ArchitecturalStyle": "Craftsman" +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 1082431632 +"ConstructionMaterials": "See Remarks" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-06-14T12:43:33.765934+00:00" +"CumulativeDaysOnMarket": 24 +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Mission Blvd, Nursury Ave, RT on Hillview Cross Street: Niles." +"FireplaceFeatures": "Gas" +"FireplaceYN": true +"Flooring": "See Remarks" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"InteriorFeatures": "Eat-in Kitchen" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "Bay East" +"ListAgentDirectPhone": "510-913-3629" +"ListAgentEmail": "rahul.puriteam@gmail.com" +"ListAgentFirstName": "Rahul" +"ListAgentKey": "21690747" +"ListAgentKeyNumeric": "21690747" +"ListAgentLastName": "Puri" +"ListAgentOfficePhone": "877-973-3346" +"ListAgentStateLicense": "01710153" +"ListAgentURL": "www.rahulpurihomes.com" +"ListOfficeAOR": "Bay East" +"ListOfficeEmail": "mark.bennett@redfin.com" +"ListOfficeKey": "5109667" +"ListOfficeKeyNumeric": "5109667" +"ListOfficePhone": "877-973-3346" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-13" +"ListingKeyNumeric": 1117376114 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,1031 Exchange" +"LotFeatures": "Back Yard,Front Yard" +"LotSizeAcres": 0.2534 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 11040.0 +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-13" +"OnMarketTimestamp": "2025-06-13T10:29:03Z" +"OriginalEntryTimestamp": "2025-06-13T17:13:35Z" +"OriginalListPrice": 2499000.0 +"OriginatingSystemID": "CCBE" +"OriginatingSystemKey": "374585446" +"OriginatingSystemSubName": "CRMLS_CCBE" +"ParcelNumber": "5070215004" +"ParkingFeatures": "Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-14T02:40:45Z" +"PhotosCount": 35 +"PoolFeatures": "In Ground" +"Possession": "Close Of Escrow" +"PreviousListPrice": 2499000.0 +"PriceChangeTimestamp": "2025-06-12T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Sewer": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117376114" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T17:00:00Z" +"Stories": "1" +"StreetName": "Hillview Dr" +"StreetNumber": "295" +"StreetNumberNumeric": "295" +"SubdivisionName": "NILES" +"UniversalPropertyId": "US-06001-N-5070215004-R-N" +"WaterSource": "Other" +"CustomFields": """ {\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Stone Counters,Kitchen Island,Remodeled Kitchen",\n "AdminUpdateYN": "0",\n "ListingKey": "1117376114"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117376114')" +"CurrentPrice": 2499000.0 +"provider_name": "CRMLS" +"RecordSignature": 97680180 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:5070215004" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "370205647" +"OriginatingSystemListAgentMemberKey": "370250142" +"Media": array:35 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] ] } ] +success: true +page_size: 10 +page_count: 275 +count: 2744 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5449 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5448 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112308116" +"ListingId": "25531679" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:19.378602+00:00" +"ListPrice": 414500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5320.0 +"LivingArea": 726.0 +"BuildingAreaTotal": 726.0 +"City": "San Bernardino" +"PostalCode": "92411" +"UnparsedAddress": "1256 W 6th Street, San Bernardino, California 92411" +"Coordinates": array:2 [ 0 => -117.312781 1 => 34.110461 ] +"Latitude": 34.110461 +"Longitude": -117.312781 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eran Fattal" +"ListOfficeName": "Dynasty Real Estate" +"ListAgentMlsId": "CLW-C103971" +"ListOfficeMlsId": "CLW-X78890" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "REMODELED FHA APPROVED HOME: 3 BEDS PLUS 1.5 BATH. (PUBLIC RECORDS SHOW 2 PLUS 1) NEW DUAL PANE WINDOWS. REPLACED CENTRAL AIR AND HEAT. NEW CUSTOM PORCELAIN TILE FLOORING IN KITCHEN, LIVING ROOM, BATHROOMS, AND LAUNDRY ROOM. NEW GRAY RUSTIC STYLE LAMINATE FLOORING IN BEDROOMS. THE KITCHEN IS BRAND NEW. NEW CUSTOM KITCHEN CABINETS, NEW QUARTZ STONE COUNTERS, NEW GARBAGE DISPOSAL, NEW PULL-OUT FAUCET. NEW BATHTUB, NEW TILED UP SHOWERS WALLS WITH ELEGANT MOSAIC DESIGN, NEW VANITIES. NEW TOILETS. ALL NEW PLUMBING FIXTURES. NEW LIGHT FIXTURES. NEW PAINT INSIDE AND OUT. NEW GARAGE DOOR. FHA/VA/DOWN PAYMENT ASSISTANCE/OK" +"Appliances": "Disposal" +"ArchitecturalStyle": "See Remarks" +"BathroomsFull": 1 +"BuyerFinancing": "Conventional, FHA, VA" +"CLIP": 8804738686 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-29T19:32:38.644803+00:00" +"DaysOnMarket": 46 +"DaysOnMarketReplication": 46 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "PLEASE REFER TO GOOGLE MAPS" +"FireplaceFeatures": "None" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Out of Area Board" +"ListAgentDirectPhone": "747-343-1266" +"ListAgentEmail": "eranfattal@icloud.com" +"ListAgentFax": "909-373-2515" +"ListAgentFirstName": "Eran" +"ListAgentKey": "17056852" +"ListAgentKeyNumeric": "17056852" +"ListAgentLastName": "Fattal" +"ListAgentOfficePhone": "909-373-2505" +"ListAgentStateLicense": "01304180" +"ListOfficeAOR": "Out of Area Board" +"ListOfficeFax": "909-373-2515" +"ListOfficeKey": "3237841" +"ListOfficeKeyNumeric": "3237841" +"ListOfficePhone": "909-373-2505" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112308116 +"ListingService": "Entry Only" +"LotSizeAcres": 0.1221 +"LotSizeDimensions": "38x140" +"LotSizeSquareFeet": 5320.0 +"MLSAreaMajor": "274 - San Bernardino" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T04:31:51Z" +"OriginalEntryTimestamp": "2025-04-29T11:17:09Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374319567" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "0138052070000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-29T20:25:39Z" +"PhotosCount": 8 +"PoolFeatures": "None" +"PostalCodePlus4": "2705" +"PreviousListPrice": 425000.0 +"PriceChangeTimestamp": "2025-06-14T16:51:35Z" +"PropertySubTypeAdditional": "Single Family Residence" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112308116" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-29T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "6th" +"StreetNumber": "1256" +"StreetNumberNumeric": "1256" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06071-N-0138052070000-R-N" +"View": "None" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112308116"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112308116')" +"CurrentPrice": 414500.0 +"provider_name": "CRMLS" +"RecordSignature": -791365164 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0138052070000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "113814" +"OriginatingSystemListAgentMemberKey": "442704" +"Media": array:8 [ …8] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5635 +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] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5638 +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] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5636 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113888520" +"ListingId": "ML82006272" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:54.002631+00:00" +"ListPrice": 2725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 8370.0 +"LivingArea": 2380.0 +"BuildingAreaTotal": 0 +"City": "Menlo Park" +"PostalCode": "94025" +"UnparsedAddress": "3523 Oak Drive, Menlo Park, California 94025" +"Coordinates": array:2 [ …2] +"Latitude": 37.47309796 +"Longitude": -122.19842405 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Emely Weissman" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML154192" +"ListOfficeMlsId": "ML37689" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This lovely home is set fairly far back, in a picture postcard kind of way, on its 8,370 square foot lot. The neighborhood is a favorite: green, parklike, picturesque, peaceful, great for taking a walk or joining neighbors for the neighborhood's weekly happy hour get together. The wonderful kitchen has handsome cabinetry, spacious granite counters, gas cooking, stainless steel appliances, and a built-in wine refrigerator. There are both a breakfast area and a separate dining room, both family room and living room, and a first floor bedroom that is great as an office. All bathrooms are updated or remodeled; the principal bathroom with oversized tub and shower is particularly luxurious. Hardwood floors throughout main floor, three carpeted bedrooms up and one bedroom on main floor, three skylights. Deck has an excellent built in hot tub, and there is a substantial backyard. This is a terrific place to call home." +"Appliances": "Dishwasher, Disposal, Refrigerator" +"ArchitecturalStyle": "Mediterranean, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3251173763 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-14" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-15T02:38:52.962690+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Middlefield Road, then turn onto San Benito or Placitas to left on Oak Drive, to 3523. Cross Street: Placitas" +"FireplaceFeatures": "Family Room,Wood Burning" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Menlo-Atherton" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-814-0374" +"ListAgentEmail": "emely.weissman@compass.com" +"ListAgentFax": "650-323-1143" +"ListAgentFirstName": "Emely" +"ListAgentKey": "20889480" +"ListAgentKeyNumeric": "20889480" +"ListAgentLastName": "Weissman" +"ListAgentOfficePhone": "(650) 323-1111" +"ListAgentStateLicense": "01119038" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-323-1143" +"ListOfficeKey": "4763954" +"ListOfficeKeyNumeric": "4763954" +"ListOfficePhone": "(650) 323-1111" +"ListOfficeURL": "http://www.compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-14" +"ListingKeyNumeric": 1113888520 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeAcres": 0.1921 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8370.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-14" +"OnMarketTimestamp": "2025-05-14T12:18:53Z" +"OriginalEntryTimestamp": "2025-05-13T17:00:00Z" +"OriginalListPrice": 2825000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374412483" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "060153290" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Deck" +"PhotosChangeTimestamp": "2025-06-15T07:03:19Z" +"PhotosCount": 24 +"PoolFeatures": "Above Ground" +"PreviousListPrice": 2825000.0 +"PriceChangeTimestamp": "2025-06-14T16:49:32Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Entry/Foyer, Laundry" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1113888520" +"SpaFeatures": "Above Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:00Z" +"StoriesTotal": "2" +"StreetName": "Oak" +"StreetNumber": "3523" +"StreetNumberNumeric": "3523" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06081-N-060153290-R-N" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R10010" +"CustomFields": """ {\n "RoomType": "Formal Entry,Laundry",\n "AdminUpdateYN": "0",\n "ListingKey": "1113888520",\n "RoomKitchenFeatures": "Granite Counters"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1113888520')" +"CurrentPrice": 2725000.0 +"provider_name": "CRMLS" +"RecordSignature": 2051684006 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:060153290" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "368558344" +"OriginatingSystemListAgentMemberKey": "368705589" +"Media": array:24 [ …24] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5633 +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] } ] +success: true +page_size: 5 +page_count: 135388 +count: 676939 +after_key: "" } ] ]
