array:2 [ "RF Query: /Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential' OR PropertyType eq 'Land' OR PropertyType eq 'Business Opportunity' OR PropertyType eq 'Commercial Sale' OR PropertyType eq 'Residential Income')/Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential' OR PropertyType eq 'Land' OR PropertyType eq 'Business Opportunity' OR PropertyType eq 'Commercial Sale' OR PropertyType eq 'Residential Income')&$expand=Media/Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential' OR PropertyType eq 'Land' OR PropertyType eq 'Business Opportunity' OR PropertyType eq 'Commercial Sale' OR PropertyType eq 'Residential Income')/Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential' OR PropertyType eq 'Land' OR PropertyType eq 'Business Opportunity' OR PropertyType eq 'Commercial Sale' OR PropertyType eq 'Residential Income')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#7588 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7597 +post_id: "62128" +post_author: 1 +"ListingKey": "1109262246" +"ListingId": "TR25065832" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-01T22:39:38Z" +"RFModificationTimestamp": "2025-06-01T22:44:23.656976+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 35065.0 +"LivingArea": 3388.0 +"BuildingAreaTotal": 0 +"City": "Claremont" +"PostalCode": "91711" +"UnparsedAddress": "3518 N Mills Avenue, Claremont, California 91711" +"Coordinates": array:2 [ …2] +"Latitude": 34.133175 +"Longitude": -117.706758 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Fuguo Wang" +"ListOfficeName": "168 Realty Inc." +"ListAgentMlsId": "TRWANGFUG" +"ListOfficeMlsId": "PB6143" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Modern Elegance in North Claremont – Renovated 5-Bedroom Single-Story Home.\r\r\n This beautifully updated single-story home in North Claremont offers 5 bedrooms, 4 bathrooms, an office, and a spacious flat lot. Thoughtfully renovated throughout, it blends modern design with comfort and function.\r\r\n Inside, enjoy soaring ceilings, large new windows with mountain views, and an open layout ideal for daily living and entertaining. The home features a luxurious primary suite, two additional en-suites, and two guest rooms—perfect for multi-generational living.\r\r\n Highlights include a brand-new gourmet kitchen, updated baths, designer tile and vinyl flooring, fresh paint, new plumbing, and RV access. The huge backyard offers endless potential for outdoor living, framed by stunning mountain views.\r\r\n Complete with a welcoming courtyard and 3-car garage, this turnkey gem is a rare find in sought-after College City. """ +"AttachedGarageYN": true +"AttributionContact": "909-518-5233" +"BackOnMarketDate": "2025-05-28" +"BathroomsFull": 4 +"CLIP": 3774385150 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Foothills, Hiking" +"ContractStatusChangeDate": "2025-03-26" +"Cooling": "Central Air,Dual" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-05-16T03:56:45.239050+00:00" +"CumulativeDaysOnMarket": 67 +"DaysOnMarket": 72 +"DaysOnMarketReplication": 67 +"DaysOnMarketReplicationDate": "2025-06-01" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From the Baseline Rd to N Mills ave" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Claremont" +"HighSchoolDistrict": "Claremont Unified" +"InteriorFeatures": "All Bedrooms Down,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Tri-Counties" +"ListAgentDirectPhone": "909-518-5233" +"ListAgentEmail": "housebygary@gmail.com" +"ListAgentFirstName": "Fuguo" +"ListAgentKey": "17152181" +"ListAgentKeyNumeric": "17152181" +"ListAgentLastName": "Wang" +"ListAgentOfficePhone": "626-965-7788" +"ListAgentStateLicense": "02011966" +"ListOfficeAOR": "Tri-Counties" +"ListOfficeFax": "626-606-1810" +"ListOfficeKey": "3286655" +"ListOfficeKeyNumeric": "3286655" +"ListOfficePhone": "626-965-7788" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-26" +"ListingKeyNumeric": 1109262246 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to Existing Loan,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.805 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 35065.0 +"MLSAreaMajor": "683 - Claremont" +"MainLevelBathrooms": 4 +"MainLevelBedrooms": 5 +"MajorChangeTimestamp": "2025-05-28T14:58:14Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-05-28" +"OffMarketTimestamp": "2025-05-28T14:29:06Z" +"OnMarketDate": "2025-03-26" +"OnMarketTimestamp": "2025-05-28T14:58:14Z" +"OriginalEntryTimestamp": "2025-03-26T09:43:07Z" +"OriginalListPrice": 1790000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374138258" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "8671014040" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-05-28T22:25:44Z" +"PhotosCount": 36 +"PoolFeatures": "None" +"PostalCodePlus4": "2063" +"PreviousListPrice": 1790000.0 +"PriceChangeTimestamp": "2025-05-10T11:02:28Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Center Hall,Family Room,Kitchen,Laundry,Primary Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1109262246" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-28T14:58:14Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "Mills" +"StreetNumber": "3518" +"StreetNumberNumeric": "3518" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "16" +"UniversalPropertyId": "US-06037-N-8671014040-R-N" +"View": "Mountain(s), Neighborhood" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=b H9fr Hgczw N" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"Zoning": "CLRA1*" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Center Hall,Family Room,Kitchen,Laundry,Primary Suite",\n "AdminUpdateYN": "0",\n "ListingKey": "1109262246",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1109262246')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 543936582 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:8671014040" +"CountrySubdivision": "06037" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "105855" +"OriginatingSystemListAgentMemberKey": "13848317" +"Media": array:36 [ …36] +"ID": "62128" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7595 +post_id: "106562" +post_author: 1 +"ListingKey": "1112991561" +"ListingId": "TR25102337" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-01T21:48:17Z" +"RFModificationTimestamp": "2025-06-01T21:52:59.007501+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 3000.0 +"LivingArea": 1904.0 +"BuildingAreaTotal": 0 +"City": "Irvine" +"PostalCode": "92603" +"UnparsedAddress": "7 Honeydew, Irvine, California 92603" +"Coordinates": array:2 [ …2] +"Latitude": 33.646776 +"Longitude": -117.777796 +"YearBuilt": 2004 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Aileen Zhang" +"ListOfficeName": "JC Pacific Corp." +"ListAgentMlsId": "HZHANAIL" +"ListOfficeMlsId": "PB22333" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This beautifully upgraded Linden Collection Residence 1 by William Lyon Homes sits on a premium lot with an expansive driveway in Irvine’s desirable Quail Hill community. Detached home featuring 3 bedrooms and 3 bathrooms, the home offers wide-plank grey hardwood flooring, custom interior paint, plantation shutters, and white cabinetry throughout. The chef-inspired kitchen includes granite countertops, a full decorative backsplash, stainless steel appliances, and custom built-ins. French doors from the family room open to a private patio, perfect for outdoor living. Residents enjoy resort-style amenities including three pools, five parks, a fitness center, BBQ and picnic areas, and scenic hiking and biking trails. Located within the award-winning Irvine Unified School District, near Alderwood Elementary, Quail Hill Shopping Center, Irvine Spectrum, Hoag, Kaiser Permanente, John Wayne Airport, and Laguna Beach—this is a rare opportunity to own a refined home in one of Irvine’s most coveted neighborhoods." +"ActivationDate": "2025-05-09" +"Appliances": "Convection Oven,Dishwasher,Gas Range,Microwave,Refrigerator,Range Hood,Water Heater" +"AssociationAmenities": "Clubhouse,Controlled Access,Sport Court,Dog Park,Fitness Center,Outdoor Cooking Area,Barbecue,Picnic Area,Playground,Pool,Spa/Hot Tub,Tennis Court(s),Trail(s)" +"AssociationFee": "160.0" +"AssociationFee2": "115.0" +"AssociationFee2Frequency": "Monthly" +"AssociationFeeFrequency": "Monthly" +"AssociationName2": "Linden & Laurel" +"AssociationPhone": "/" +"AssociationPhone2": "/" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "626-271-0207" +"BathroomsFull": 3 +"CLIP": 6622607614 +"CoListAgentAOR": "Orange County" +"CoListAgentEmail": "cyc.mochaco@gmail.com" +"CoListAgentFirstName": "Ying" +"CoListAgentFullName": "Ying Cui" +"CoListAgentKey": "23379442" +"CoListAgentKeyNumeric": "23379442" +"CoListAgentLastName": "Cui" +"CoListAgentMlsId": "OCYINGCUI" +"CoListAgentOfficePhone": "626-245-6226" +"CoListAgentStateLicense": "02230708" +"CoListOfficeAOR": "Orange County" +"CoListOfficeEmail": "moonlife513@gmail.com" +"CoListOfficeKey": "5656045" +"CoListOfficeKeyNumeric": "5656045" +"CoListOfficeMlsId": "OC19013" +"CoListOfficeName": "JC Pacific Corp" +"CoListOfficePhone": "626-245-6226" +"CommonInterest": "Condominium" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Dog Park,Street Lights,Sidewalks,Park,Pool" +"ContractStatusChangeDate": "2025-05-01" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-05-09T13:25:53.095948+00:00" +"CumulativeDaysOnMarket": 23 +"DaysOnMarket": 28 +"DaysOnMarketReplication": 23 +"DaysOnMarketReplicationDate": "2025-06-01" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Knollcrest & Radiance" +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure" +"DoorFeatures": "French Doors,Sliding Doors" +"Electric": "Standard" +"ElementarySchool": "Alderwood" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"Fencing": "Brick" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Tile, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central, Fireplace(s)" +"HeatingYN": true +"HighSchool": "University" +"HighSchoolDistrict": "Irvine Unified" +"InteriorFeatures": "Ceiling Fan(s),Granite Counters,High Ceilings,All Bedrooms Up,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Gas Dryer Hookup,Inside,Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Tri-Counties" +"ListAgentEmail": "yzaileen@yahoo.com" +"ListAgentFirstName": "Aileen" +"ListAgentKey": "17034914" +"ListAgentKeyNumeric": "17034914" +"ListAgentLastName": "Zhang" +"ListAgentOfficePhone": "949-245-6226" +"ListAgentStateLicense": "01374582" +"ListOfficeAOR": "Tri-Counties" +"ListOfficeKey": "5656778" +"ListOfficeKeyNumeric": "5656778" +"ListOfficePhone": "949-245-6226" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-01" +"ListingKeyNumeric": 1112991561 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Near Park,Rectangular Lot" +"LotSizeAcres": 0.0689 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 3000.0 +"MLSAreaMajor": "QH - Quail Hill" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-05-09T00:30:36Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Rancho San Joaquin" +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 100 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-09" +"OnMarketTimestamp": "2025-05-09T00:30:36Z" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2025-05-08T20:44:21Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374380806" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "93327338" +"ParkingFeatures": "Concrete,Door-Multi,Direct Access,Driveway,Garage Faces Front,Garage,Garage Door Opener,Paved" +"ParkingTotal": "5.0" +"PatioAndPorchFeatures": "Front Porch" +"PhotosChangeTimestamp": "2025-05-10T06:36:40Z" +"PhotosCount": 21 +"PoolFeatures": "Community, Association" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "4205" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Condominium" +"RoadSurfaceType": "Paved" +"Roof": "Spanish Tile,Tile" +"RoomType": "Bedroom,Den,Entry/Foyer,Family Room,Kitchen,Laundry,Living Room,Other" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112991561" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-05-09" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-09T00:30:36Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Honeydew" +"StreetNumber": "7" +"StreetNumberNumeric": "7" +"StructureType": "House" +"TaxLot": "18" +"UniversalPropertyId": "US-06059-N-93327338-R-N" +"Utilities": "Cable Connected,Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "City Lights,Hills" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Screens, Shutters" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Den,Entry,Family Room,Kitchen,Laundry,Living Room,Walk-In Closet",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island,Kitchen Open to Family Room",\n "RoomBathroomFeatures": "Bathtub,Shower,Closet in bathroom,Double sinks in bath(s),Double Sinks in Primary Bath,Jetted Tub,Main Floor Full Bath,Privacy toilet door,Separate tub and shower,Stone Counters,Tile Counters,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1112991561",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112991561')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 2094871221 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:93327338" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Coming Soon" +"OriginatingSystemListOfficeKey": "373497750" +"OriginatingSystemCoListOfficeKey": "373475238" +"OriginatingSystemListAgentMemberKey": "223619" +"OriginatingSystemCoListAgentMemberKey": "372539414" +"Media": array:21 [ …21] +"ID": "106562" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7598 +post_id: "125569" +post_author: 1 +"ListingKey": "1114383404" +"ListingId": "25541897" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-01T23:06:33Z" +"RFModificationTimestamp": "2025-06-01T23:09:17.818209+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 6888.0 +"LivingArea": 1479.0 +"BuildingAreaTotal": 1479.0 +"City": "Los Angeles" +"PostalCode": "90019" +"UnparsedAddress": "1524 S Fairfax Avenue, Los Angeles, California 90019" +"Coordinates": array:2 [ …2] +"Latitude": 34.048861 +"Longitude": -118.366894 +"YearBuilt": 1925 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Doron Baruch" +"ListOfficeName": "Christie's International Real Estate SoCal" +"ListAgentMlsId": "CLW-C108518" +"ListOfficeMlsId": "CLW-X83391" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "DEVELOPMENT DEAL. Prime Development Opportunity R3 Lot with Partial RTIAn exceptional opportunity for developers and investors! This R3-zoned lot comes with a partially RTI (Ready-To-Issue) permit, having already passed Planning and currently awaiting approval from the Building and Safety Department. The proposed project is sited for a 20-unit build, consisting of 16 primary units plus 4 ADUs on the ground floor, maximizing the lot's development potential.Located in a high-demand area with strong rental upside, this property is ideal for those looking to capitalize on Los Angeles's growing need for multi-family housing. With much of the entitlement process already completed, this is a rare chance to step into a nearly shovel-ready development with significant upside.Don't miss this outstanding investment opportunity to build a high-yield asset in a desirable neighborhood. The home currently is a Single Family. Floors have been redone, home has been painted inside and out, new Kitchen, new bathrooms, has never been lived in. Large lot of almost 7k sq feet with a newly constructed backyard. This beautiful home is move in ready. Location is ideal, min from Beverly Grove and a few blocks from Freeway. Easy to show and could be leased furnished as well. Already cash flowing at $4,800/ month with tenant in place month to month" +"Appliances": "Gas Cooktop,Refrigerator,Vented Exhaust Fan,Dryer,Washer" +"ArchitecturalStyle": "Craftsman" +"BathroomsFull": 1 +"CLIP": 7869184537 +"CoListAgentAOR": "Beverly Hills/Greater LA" +"CoListAgentDirectPhone": "310-919-1038" +"CoListAgentEmail": "tomer@thefridmangroup.com" +"CoListAgentFirstName": "Tomer" +"CoListAgentFullName": "Tomer Fridman" +"CoListAgentKey": "17085540" +"CoListAgentKeyNumeric": "17085540" +"CoListAgentLastName": "Fridman" +"CoListAgentMlsId": "CLW-X87705" +"CoListAgentOfficePhone": "424-249-7162" +"CoListAgentStateLicense": "01750717" +"CoListAgentURL": "www.thefridmangroup.com" +"CoListOfficeAOR": "Beverly Hills/Greater LA" +"CoListOfficeKey": "5112795" +"CoListOfficeKeyNumeric": "5112795" +"CoListOfficeMlsId": "CLW-X83391" +"CoListOfficeName": "Christie's International Real Estate SoCal" +"CoListOfficePhone": "424-249-7162" +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-21" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-05-21T22:59:48.225788+00:00" +"DaysOnMarket": 16 +"DaysOnMarketReplication": 11 +"DaysOnMarketReplicationDate": "2025-06-01" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "West" +"Directions": "south of Pico north of venice" +"FireplaceFeatures": "Den" +"FireplaceYN": true +"Flooring": "Wood" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Floor Furnace" +"HeatingYN": true +"InteriorFeatures": "Separate/Formal Dining Room" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Kitchen" +"Levels": "One" +"ListAgentAOR": "Beverly Hills/Greater LA" +"ListAgentDirectPhone": "310-628-5788" +"ListAgentEmail": "dbaruchrealty@gmail.com" +"ListAgentFirstName": "Doron" +"ListAgentKey": "17059652" +"ListAgentKeyNumeric": "17059652" +"ListAgentLastName": "Baruch" +"ListAgentOfficePhone": "424-249-7162" +"ListAgentStateLicense": "01902157" +"ListAgentURL": "www.doronbaruch.com" +"ListOfficeAOR": "Beverly Hills/Greater LA" +"ListOfficeKey": "5112795" +"ListOfficeKeyNumeric": "5112795" +"ListOfficePhone": "424-249-7162" +"ListingAgreement": "Seller Reserved" +"ListingContractDate": "2025-05-21" +"ListingKeyNumeric": 1114383404 +"ListingService": "Full Service" +"LotSizeAcres": 0.1581 +"LotSizeDimensions": "55x125" +"LotSizeSquareFeet": 6888.0 +"MLSAreaMajor": "C16 - Mid Los Angeles" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-21" +"OnMarketTimestamp": "2025-05-21T08:26:37Z" +"OriginalEntryTimestamp": "2025-05-21T15:16:09Z" +"OriginalListPrice": 1900000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374450589" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "5068023020" +"ParkingFeatures": "None" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-21T22:36:40Z" +"PhotosCount": 16 +"PoolFeatures": "None" +"PostalCodePlus4": "4911" +"PreviousListPrice": 1900000.0 +"PriceChangeTimestamp": "2025-06-01T08:51:37Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Dining Room" +"SecurityFeatures": "Security Gate" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114383404" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-21T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "S" +"StreetName": "Fairfax" +"StreetNumber": "1524" +"StreetNumberNumeric": "1524" +"StreetSuffix": "Avenue" +"UniversalPropertyId": "US-06037-N-5068023020-R-N" +"View": "None" +"Zoning": "LAR3" +"CustomFields": """ {\n "EatingArea": "Dining Room",\n "RoomBathroomFeatures": "Tile Counters",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "0",\n "ListingKey": "1114383404"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114383404')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 332036808 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:5068023020" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "370609097" +"OriginatingSystemCoListOfficeKey": "370609097" +"OriginatingSystemListAgentMemberKey": "515349" +"OriginatingSystemCoListAgentMemberKey": "262177" +"Media": array:16 [ …16] +"ID": "125569" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7594 +post_id: "90692" +post_author: 1 +"ListingKey": "1112138710" +"ListingId": "NDP2503979" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-05-17T19:54:51Z" +"RFModificationTimestamp": "2025-05-17T20:31:25.163743+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5000.0 +"LivingArea": 2323.0 +"BuildingAreaTotal": 0 +"City": "Carlsbad" +"PostalCode": "92011" +"UnparsedAddress": "1695 Robin Place, Carlsbad, California 92011" +"Coordinates": array:2 [ …2] +"Latitude": 33.097037 +"Longitude": -117.277765 +"YearBuilt": 1997 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Megan Schenck" +"ListOfficeName": "Three Lagoons Realty" +"ListAgentMlsId": "101080" +"ListOfficeMlsId": "10175" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to your dream home in the highly sought-after Tramonto community of Aviara in Carlsbad! This beautifully remodeled 2,323 sq ft home offers 3 spacious bedrooms, a versatile loft, and sits on the largest lot in the neighborhood, with gorgeous views of the Batiquitos Lagoon, rolling hills, open space, and even peek-a-boo ocean views. Step inside to an inviting open-concept layout, where every detail has been thoughtfully upgraded. The kitchen features white shaker cabinets, stainless steel appliances, quartz countertops, and flows seamlessly into the dining and living areas with stylish LVP flooring throughout the main level. Upstairs, the generous loft space offers endless flexibility—perfect for a home office, playroom, or media space. The oversized primary suite is a true retreat, boasting a luxurious en suite bath with dual sinks, a separate soaking tub, walk-in shower, and high-end designer finishes. Both the primary and guest bathrooms have been fully remodeled, including upgraded tile, vanities, lighting, and fixtures. White plantation shutters are on every upstairs window for a clean, cohesive look. The leased solar provides low cost energy consumption. Enjoy Carlsbad’s coastal lifestyle in your backyard oasis, featuring a built-in BBQ, gas fire pit, custom putting green, and artificial turf for easy maintenance—all framed by serene views and enhanced privacy. An extra-long driveway offers ample parking for guests. This home is just a short stroll to the Batiquitos Lagoon, shopping, dining, and a 5-minute drive to Carlsbad’s pristine beaches. An added bonus is this home is located within the boundaries of top-rated Carlsbad schools. Residents of Tramonto enjoy access to a community pool, spa, and green spaces—all within the prestigious Aviara Master Plan. Don’t miss this rare opportunity to own a fully updated, view home on an expansive lot in one of Carlsbad’s most desirable communities!" +"Appliances": "Dishwasher,Freezer,Gas Cooking,Gas Cooktop,Disposal,Gas Oven,Gas Water Heater,Ice Maker,Microwave,Refrigerator,Range Hood,Water Heater,Dryer,Washer" +"AssociationAmenities": "Maintenance Grounds,Management,Maintenance Front Yard,Picnic Area,Pool,Pets Allowed,RV Parking,Spa/Hot Tub" +"AssociationFee": "258.0" +"AssociationFee2": "128.0" +"AssociationFee2Frequency": "Monthly" +"AssociationFeeFrequency": "Monthly" +"AssociationName2": "Aviara Master Plan Association" +"AssociationPhone": "(760) 931-4180" +"AssociationPhone2": "(949) 833-2600" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "megan@3lagoons.com" +"BathroomsFull": 2 +"CLIP": 3629484581 +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Street Lights,Suburban,Sidewalks,Pool" +"ContractStatusChangeDate": "2025-05-16" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "San Diego" +"CreationDate": "2025-04-24T19:13:07.857984+00:00" +"DaysOnMarket": 43 +"DaysOnMarketReplication": 23 +"DaysOnMarketReplicationDate": "2025-05-17" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Use smart phone" +"ElementarySchool": "Aviara Oaks" +"EntryLevel": 1 +"EntryLocation": "Living Room" +"ExteriorFeatures": "Fire Pit" +"FireplaceFeatures": "Gas,Gas Starter,Great Room,Primary Bedroom,Outside" +"FireplaceYN": true +"Flooring": "Carpet, Tile, Vinyl" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central, Fireplace(s)" +"HeatingYN": true +"HighSchool": "Carlsbad" +"HighSchoolDistrict": "Carlsbad Unified" +"InteriorFeatures": "Ceiling Fan(s),Coffered Ceiling(s),Separate/Formal Dining Room,Eat-in Kitchen,Open Floorplan,Recessed Lighting,All Bedrooms Up,Loft,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "North San Diego County" +"ListAgentDirectPhone": "858-776-0427" +"ListAgentEmail": "megan@3lagoons.com" +"ListAgentFirstName": "Megan" +"ListAgentKey": "17218574" +"ListAgentKeyNumeric": "17218574" +"ListAgentLastName": "Schenck" +"ListAgentOfficePhone": "858-776-0427" +"ListAgentStateLicense": "01735296" +"ListAgentURL": "http://www.threelagooons.com" +"ListOfficeAOR": "North San Diego County" +"ListOfficeEmail": "megan@3lagoons.com" +"ListOfficeKey": "3237719" +"ListOfficeKeyNumeric": "3237719" +"ListOfficePhone": "858-776-0427" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-24" +"ListingKeyNumeric": 1112138710 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,1031 Exchange,VA Loan" +"LivingAreaSource": "Public Records" +"LotFeatures": "Back Yard,Corner Lot,Cul-De-Sac,Level,Yard" +"LotSizeAcres": 0.1148 +"LotSizeSource": "See Remarks" +"LotSizeSquareFeet": 5000.0 +"MLSAreaMajor": "92011 - Carlsbad" +"MainLevelBathrooms": 1 +"MiddleOrJuniorSchool": "Aviara Oaks" +"MlsStatus": "Active Under Contract" +"NumberOfUnitsInCommunity": 131 +"OccupantType": "Tenant" +"OnMarketDate": "2025-04-24" +"OnMarketTimestamp": "2025-04-24T03:45:19Z" +"OpenParkingSpaces": "4.0" +"OriginalEntryTimestamp": "2025-04-24T10:35:27Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "CRP" +"OriginatingSystemKey": "374295026" +"OriginatingSystemSubName": "CRMLS_CRP" +"ParcelNumber": "2157400806" +"ParkName": "Tramonto" +"ParkingFeatures": "Door-Multi,Direct Access,Driveway,Garage Faces Front,Garage,Garage Door Opener,Side By Side" +"ParkingTotal": "6.0" +"PatioAndPorchFeatures": "Patio" +"PhotosChangeTimestamp": "2025-04-24T18:39:41Z" +"PhotosCount": 64 +"PoolFeatures": "Community,In Ground,Association" +"PreviousListPrice": 1750000.0 +"PriceChangeTimestamp": "2025-04-23T17:00:00Z" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-05-16" +"RoadSurfaceType": "Paved" +"Roof": "Composition, Tile" +"RoomType": "Bedroom,Den,Laundry,Loft,Living Room,Primary Bathroom,Primary Bedroom,Other,Dining Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Megan Schenck" +"ShowingContactPhone": "858-776-0427" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112138710" +"SpaFeatures": "Heated,In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-16T17:00:00Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "ROBIN" +"StreetNumber": "1695" +"StreetNumberNumeric": "1695" +"StreetSuffix": "Place" +"TaxTract": "09027" +"UniversalPropertyId": "US-06073-N-2157400806-R-N" +"Utilities": "Electricity Connected" +"View": "Neighborhood, Ocean, Panoramic, Peek-A-Boo, Water" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/crmls/NDP2503979" +"WindowFeatures": "Double Pane Windows,Screens,Shutters" +"Zoning": "R1" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Den,Laundry,Living Room,Loft,Primary Bathroom,Primary Bedroom,Primary Suite,Walk-In Closet",\n "EatingArea": "Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Kitchen Open to Family Room,Kitchen Island,Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Double Sinks in Primary Bath,Exhaust fan(s),Linen Closet/Storage,Privacy toilet door,Quartz Counters,Remodeled,Upgraded,Walk-in shower,Shower,Bathtub",\n "AdminUpdateYN": "0",\n "ListingKey": "1112138710"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112138710')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": -786153384 +"UniversalParcelId": "urn:reso:upi:2.0:US:06073:2157400806" +"CountrySubdivision": "06073" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "122927596" +"OriginatingSystemListAgentMemberKey": "123431430" +"Media": array:64 [ …64] +"ID": "90692" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7596 +post_id: "135684" +post_author: 1 +"ListingKey": "1115004958" +"ListingId": "25548819" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-06T18:18:24Z" +"RFModificationTimestamp": "2025-06-06T18:23:11.537149+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 6145.0 +"LivingArea": 4146.0 +"BuildingAreaTotal": 4146.0 +"City": "Woodland Hills" +"PostalCode": "91367" +"UnparsedAddress": "23042 Ostronic Drive, Woodland Hills, California 91367" +"Coordinates": array:2 [ …2] +"Latitude": 34.165611 +"Longitude": -118.628848 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Andrew Mortaza" +"ListOfficeName": "The Agency" +"ListAgentMlsId": "CLW-X89821" +"ListOfficeMlsId": "CLW-X7901306" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Nestled in the prestigious Walnut Acres neighborhood of Woodland Hills, this breathtaking 5-bedroom, 5.5-bathroom home offers the perfect blend of luxury and comfort. The expansive open-concept living space is designed for modern living, featuring soaring cathedral ceilings in the living room that create an airy, grand atmosphere. The gourmet kitchen with Viking appliances opens seamlessly into the family room, providing the perfect space for entertaining. The spacious master bedroom is a true retreat, offering ample space, natural light, and a luxurious ensuite bath with all the amenities you could desire. In addition to the master suite, there are 4 generous guest bedrooms, each with its own en-suite bathroom, ensuring privacy and comfort for family or visitors. Step outside to your own private paradise, where a sparkling pool and hot tub invite you to relax and unwind in style. Whether you're hosting a summer party or enjoying a quiet evening, the backyard offers the ideal setting for outdoor living. This home truly has it all: privacy, luxury, and an incredible location. Don't miss the opportunity to make this dream home yours!" +"Appliances": "Disposal" +"ArchitecturalStyle": "Spanish" +"BathroomsFull": 5 +"CLIP": 4600015581 +"CoListAgentAOR": "Beverly Hills/Greater LA" +"CoListAgentDirectPhone": "310-895-5572" +"CoListAgentEmail": "Bryan.Castaneda@The Agency RE.com" +"CoListAgentFirstName": "Bryan" +"CoListAgentFullName": "Bryan Castaneda" +"CoListAgentKey": "17090197" +"CoListAgentKeyNumeric": "17090197" +"CoListAgentLastName": "Castaneda" +"CoListAgentMlsId": "CLW-C125233" +"CoListAgentOfficePhone": "818-379-7700" +"CoListAgentStateLicense": "01309833" +"CoListAgentURL": "www.The Agency RE.com" +"CoListOfficeAOR": "Beverly Hills/Greater LA" +"CoListOfficeKey": "3277389" +"CoListOfficeKeyNumeric": "3277389" +"CoListOfficeMlsId": "CLW-X7901306" +"CoListOfficeName": "The Agency" +"CoListOfficePhone": "818-379-7700" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gated" +"ContractStatusChangeDate": "2025-06-06" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-06-06T15:27:15.730334+00:00" +"DaysOnMarketReplicationDate": "2025-06-06" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "North" +"Directions": "East of Valley Circle, North of Ventura, West of Fallbrook" +"EntryLocation": "Main Level" +"Exclusions": "Chandelier in Living Room and Stairwell. Washer and Dryer." +"FireplaceFeatures": "Family Room,Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Stone" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"InteriorFeatures": "Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Beverly Hills/Greater LA" +"ListAgentDirectPhone": "818-458-2218" +"ListAgentEmail": "andrew.mortaza@theagencyre.com" +"ListAgentFirstName": "Andrew" +"ListAgentKey": "17091445" +"ListAgentKeyNumeric": "17091445" +"ListAgentLastName": "Mortaza" +"ListAgentOfficePhone": "818-379-7700" +"ListAgentStateLicense": "01470043" +"ListAgentURL": "https://www.theagencyre.com/agent/andrew-mortaza" +"ListOfficeAOR": "Beverly Hills/Greater LA" +"ListOfficeKey": "3277389" +"ListOfficeKeyNumeric": "3277389" +"ListOfficePhone": "818-379-7700" +"ListingAgreement": "Seller Reserved" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1115004958 +"ListingService": "Full Service" +"LotSizeAcres": 0.1411 +"LotSizeSquareFeet": 6145.0 +"MLSAreaMajor": "WHLL - Woodland Hills" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T00:56:33Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-06-06T07:46:05Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374541546" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "2042019022" +"ParkingFeatures": "Door-Multi, Driveway, Garage, Guest" +"PhotosChangeTimestamp": "2025-06-06T15:13:41Z" +"PhotosCount": 32 +"PoolFeatures": "In Ground" +"PostalCodePlus4": "6142" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Entry/Foyer,Family Room,Guest Quarters,Living Room,Other" +"SecurityFeatures": "Security Gate,Gated Community" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115004958" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T00:00:00Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Ostronic" +"StreetNumber": "23042" +"StreetNumberNumeric": "23042" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06037-N-2042019022-R-N" +"View": "None" +"Zoning": "LAR1" +"CustomFields": """ {\n "RoomType": "Entry,Family Room,Guest/Maid\u0027s Quarters,Living Room,Walk-In Closet",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1115004958"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115004958')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 780810520 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:2042019022" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "131773027" +"OriginatingSystemCoListOfficeKey": "131773027" +"OriginatingSystemListAgentMemberKey": "262778" +"OriginatingSystemCoListAgentMemberKey": "40966858" +"Media": array:32 [ …32] +"ID": "135684" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7599 +post_id: "102999" +post_author: 1 +"ListingKey": "1112891420" +"ListingId": "ML82005781" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-04T16:36:05Z" +"RFModificationTimestamp": "2025-06-04T17:03:46.326400+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 4864.0 +"LivingArea": 1500.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94555" +"UnparsedAddress": "4480 Norocco Circle, Fremont, California 94555" +"Coordinates": array:2 [ …2] +"Latitude": 37.57404267 +"Longitude": -122.04769353 +"YearBuilt": 1983 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Serena Zhang" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "ML5087869" +"ListOfficeMlsId": "ML39091" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "East Facing front door. Walk-In Closet! This spacious and beautifully upgraded 3-bedroom, 2-bath,1-office corner-unit home in the highly sought-after Ardenwood neighborhood offers an ideal blend of comfort, function, and modern design, with abundant natural sunlight throughout. The master bedroom features a rare oversized walk-in closet, while the updated kitchen includes a walk-in pantry, stylish countertops, modern backsplash, high-end sink, and a full suite of new stainless steel appliances including a refrigerator, stove, and dishwasher. The layout includes separate living and family rooms with soaring high ceilings, plus office, storage, and a fun kids play loft, perfect for todays flexible lifestyle. Brand-new central HVAC system, brand-new laminate flooring, recessed lighting throughout, dual-pane windows, and customized closet systems in every bedroom. The garage has new epoxy flooring and offers ample storage space, along with a top-of-the-line washer and dryer. Outside, enjoy a large, low-maintenance backyard with excellent privacy no neighboring windows face the yard. Located just a short walk from top-rated Ardenwood Elementary School, this move-in ready home is a rare gem in Fremont's most desirable and family-friendly neighborhood." +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3770589792 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-07" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-07T15:40:29.087176+00:00" +"DaysOnMarket": 30 +"DaysOnMarketReplication": 28 +"DaysOnMarketReplicationDate": "2025-06-04" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Shylock" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Other" +"HighSchoolDistrict": "Fremont Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "510-272-7777" +"ListAgentEmail": "realtorserena1988@gmail.com" +"ListAgentFirstName": "Serena" +"ListAgentKey": "20859129" +"ListAgentKeyNumeric": "20859129" +"ListAgentLastName": "Zhang" +"ListAgentOfficePhone": "(408) 252-1133" +"ListAgentStateLicense": "02049392" +"ListAgentURL": "https://www.serenazhang.net/" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "408-252-0538" +"ListOfficeKey": "4763973" +"ListOfficeKeyNumeric": "4763973" +"ListOfficePhone": "(408) 252-1133" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-07" +"ListingKeyNumeric": 1112891420 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1117 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 4864.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-07" +"OnMarketTimestamp": "2025-05-07T01:22:27Z" +"OriginalEntryTimestamp": "2025-05-07T01:06:13Z" +"OriginalListPrice": 1799000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374366145" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "5430418164" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-04T05:21:40Z" +"PhotosCount": 48 +"PreviousListPrice": 1799000.0 +"PriceChangeTimestamp": "2025-06-03T15:04:57Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112891420" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-07T01:06:13Z" +"StoriesTotal": "1" +"StreetName": "Norocco" +"StreetNumber": "4480" +"StreetNumberNumeric": "4480" +"StreetSuffix": "Circle" +"UniversalPropertyId": "US-06001-N-5430418164-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R-1" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1112891420"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112891420')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": -1872403260 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:5430418164" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558363" +"OriginatingSystemListAgentMemberKey": "368621691" +"Media": array:48 [ …48] +"ID": "102999" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7600 +post_id: "67375" +post_author: 1 +"ListingKey": "1109443762" +"ListingId": "BB25053125" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-04T16:48:02Z" +"RFModificationTimestamp": "2025-06-04T17:16:25.133091+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 10553.0 +"LivingArea": 3562.0 +"BuildingAreaTotal": 0 +"City": "Stevenson Ranch" +"PostalCode": "91381" +"UnparsedAddress": "26031 Tennyson Lane, Stevenson Ranch, California 91381" +"Coordinates": array:2 [ …2] +"Latitude": 34.395138 +"Longitude": -118.599572 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marije Kruythoff" +"ListOfficeName": "Redfin Corporation" +"ListAgentMlsId": "BB43162" +"ListOfficeMlsId": "bh5345356" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Breathtaking Views & Luxury Living in Stevenson Ranch. Welcome to 26031 Tennyson, a stunning 5-bedroom, 4.5-bathroom home perched at the top of Stevenson Ranch in a serene cul-de-sac. Spanning 3,562 sq. ft., this sought-after Twilight Vista residence offers the perfect blend of elegance, comfort, and breathtaking unobstructed mountain views. This home sits on a large 10,553 sq. ft. lot. Upon entering, you are greeted by soaring high ceilings and an inviting living room. The highly desirable first-floor guest suite with an ensuite bathroom provides privacy and convenience, perfect for overnight guests or extended family stays. The elegant formal dining room offers generous seating, making it ideal for hosting unforgettable gatherings and intimate dinners. At the heart of the home is a chef’s dream kitchen, featuring an oversized marble waterfall island, trendy backsplash, and high-end Viking appliances, including a double oven and refrigerator. The resort-style backyard is an entertainer’s paradise, complete with an outdoor kitchen, fire pit, pool, spa, and endless panoramic views ideal for hosting or unwinding in your private retreat. Upstairs, a spacious loft leads to four additional bedrooms, including the primary suite, which boasts an oversized deck perfect for sipping morning coffee or enjoying spectacular sunsets with a glass of wine. The remodeled primary bathroom features a soaking tub, walk-in shower, dual vanities, and separate closets. One of the secondary bedrooms also includes a remodeled ensuite bathroom with stylish tile and quartz countertops, while two additional bedrooms share a beautifully updated hallway bathroom. The upstairs laundry room has been upgraded with sleek gray tile floors and modern countertops. Located near top-rated schools and parks with trails, sports fields, a playground, and tennis courts, this home offers both luxury and convenience. Plus, easy freeway access makes Stevenson Ranch highly desirable among commuters. Don’t miss this amazing opportunity to own a home that truly has it all!" +"ActivationDate": "2025-04-03" +"Appliances": "6 Burner Stove,Built-In Range,Barbecue,Convection Oven,Double Oven,Dishwasher,Electric Oven,Gas Cooktop,Gas Water Heater,Refrigerator,Range Hood,Self Cleaning Oven,Water Softener,Vented Exhaust Fan,Water To Refrigerator,Water Heater" +"AssociationAmenities": "Call for Rules,Security" +"AssociationFee": "60.0" +"AssociationFeeFrequency": "Annually" +"AssociationPhone": "6612945270" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 3 +"BathroomsThreeQuarter": 1 +"CLIP": 2326855869 +"CommonInterest": "Planned Development" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Curbs,Foothills,Golf,Gutter(s),Hiking,Park,Storm Drain(s),Street Lights,Suburban,Sidewalks" +"ContractStatusChangeDate": "2025-05-30" +"Cooling": "Central Air,Zoned" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-04-04T01:01:32.310992+00:00" +"CumulativeDaysOnMarket": 62 +"DaysOnMarket": 64 +"DaysOnMarketReplication": 62 +"DaysOnMarketReplicationDate": "2025-06-04" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Near Tennyson Ln & Waycott Way" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Fire Pit" +"Fencing": "Good Condition,Masonry,Wrought Iron" +"FireplaceFeatures": "Family Room,Gas,Gas Starter,Living Room,Masonry,Outside" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central, Fireplace(s), Solar" +"HeatingYN": true +"HighSchoolDistrict": "William S. Hart Union" +"Inclusions": "Refrigerator(s), Washer(s), Dryer(s), Stove(s), TV Brackets(s), Cabinets, Storage Shelves, Lighting Fixtures, Solar power system" +"InteriorFeatures": "Built-in Features,Balcony,Chair Rail,Ceiling Fan(s),Crown Molding,Cathedral Ceiling(s),Central Vacuum,Furnished,High Ceilings,In-Law Floorplan,Open Floorplan,Pantry,Quartz Counters,Stone Counters,Recessed Lighting,Storage,Two Story Ceilings,Wired for Data,Wired for Sound,Attic,Dressing Area" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Electric Dryer Hookup,Inside,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Burbank" +"ListAgentEmail": "marije.kruythoff@redfin.com" +"ListAgentFirstName": "Marije" +"ListAgentKey": "24819069" +"ListAgentKeyNumeric": "24819069" +"ListAgentLastName": "Kruythoff" +"ListAgentOfficePhone": "877-973-3346" +"ListAgentStateLicense": "01969880" +"ListOfficeAOR": "Burbank" +"ListOfficeEmail": "mark.bennett@redfin.com" +"ListOfficeKey": "3245255" +"ListOfficeKeyNumeric": "3245255" +"ListOfficePhone": "877-973-3346" +"ListOfficeURL": "http://www.redfin.com/" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-28" +"ListingKeyNumeric": 1109443762 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard" +"LotSizeAcres": 0.2423 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 10553.0 +"MLSAreaMajor": "STEV - Stevenson Ranch" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-04T09:22:21Z" +"MajorChangeType": "Active Under Contract" +"MlsStatus": "Active Under Contract" +"NumberOfUnitsInCommunity": 3679 +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-04-03" +"OnMarketTimestamp": "2025-04-03T15:10:46Z" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2025-03-28T12:20:28Z" +"OriginalListPrice": 1800000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374154586" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "2826113021" +"ParkingFeatures": "Concrete,Door-Multi,Direct Access,Driveway,Driveway Up Slope From Street,Garage Faces Front,Garage,Garage Door Opener,Private" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-04-08T02:18:41Z" +"PhotosCount": 75 +"PoolFeatures": "Fenced,Fiberglass,Filtered,Electric Heat,Heated,In Ground,Private,Solar Heat,Waterfall" +"PoolPrivateYN": true +"PostalCodePlus4": "1019" +"PreviousListPrice": 1775000.0 +"PriceChangeTimestamp": "2025-05-08T16:50:32Z" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-05-30" +"Roof": "Spanish Tile" +"RoomType": "Attic,Bonus Room,Center Hall,Den,Entry/Foyer,Family Room,Foyer,Guest Quarters,Great Room,Kitchen,Laundry,Living Room,Office,Other,Pantry" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1109443762" +"SpaFeatures": "Heated,In Ground,Private,Solar Heat" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-04-03" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-04T09:22:21Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Tennyson" +"StreetNumber": "26031" +"StreetNumberNumeric": "26031" +"StreetSuffix": "Lane" +"StructureType": "House" +"SubdivisionName": "Twilight Vista (TWLV)" +"TaxLot": "198" +"UniversalPropertyId": "US-06037-N-2826113021-R-N" +"View": "Canyon, Desert, Hills, Mountain(s), Neighborhood, Panoramic, Valley" +"ViewYN": true +"VirtualTourURLBranded": "https://my.matterport.com/show/?m=j FK6Bu9j D1H&mls=1" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=j FK6Bu9j D1H&mls=1" +"VirtualTourURLUnbranded2": "https://www.youtube.com/watch?v=m CCdx X6_3oo" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "LCA25*" +"CustomFields": """ {\n "RoomType": "Attic,Bonus Room,Center Hall,Den,Dressing Area,Entry,Family Room,Formal Entry,Foyer,Galley Kitchen,Great Room,Guest/Maid\u0027s Quarters,Kitchen,Laundry,Living Room,Office,Separate Family Room,Walk-In Closet,Walk-In Pantry",\n "RoomKitchenFeatures": "Built-in Trash/Recycling,Kitchen Island,Kitchen Open to Family Room,Pots \u0026 Pan Drawers,Quartz Counters,Remodeled Kitchen,Walk-In Pantry",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub,Closet in bathroom,Double sinks in bath(s),Dual shower heads (or Multiple),Exhaust fan(s),Hollywood Bathroom (Jack\u0026Jill),Linen Closet/Storage,Quartz Counters,Remodeled,Separate tub and shower,Soaking Tub,Upgraded,Vanity area,Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1109443762",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1109443762')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 938757279 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:2826113021" +"CountrySubdivision": "06037" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "122470" +"OriginatingSystemListAgentMemberKey": "373283165" +"Media": array:75 [ …75] +"ID": "67375" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7593 +post_id: "122632" +post_author: 1 +"ListingKey": "1114390188" +"ListingId": "V1-30091" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-04T18:55:20Z" +"RFModificationTimestamp": "2025-06-04T19:58:26.749825+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 9583.0 +"LivingArea": 1622.0 +"BuildingAreaTotal": 0 +"City": "Ventura" +"PostalCode": "93001" +"UnparsedAddress": "941 Buena Vista Street, Ventura, California 93001" +"Coordinates": array:2 [ …2] +"Latitude": 34.282879 +"Longitude": -119.28638 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Robert Shimp" +"ListOfficeName": "Engel & Voelkers Westlake" +"ListAgentMlsId": "v159097138" +"ListOfficeMlsId": "VC8471" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Maui meets Ventura with this stunning single level hillside home offering breathtaking 180-degree panoramic ocean, island, coastline sunset, and city lights views. As you step through the hand carved entry door, a sense of calm and relaxation envelopes your soul as you are greeted with tons of natural light and a massive window with explosive ocean views. Features include formal living and family rooms with custom built-in cabinetry and shelving, a gorgeous kitchen open to the family room with island seating, custom cabinetry, granite counter tops and stainless-steel appliances including built-in double ovens, microwave and wine refrigerator. The primary bedrooms offer beautiful ocean views and the primary bath includes custom cabinetry and relaxing soaking tub. The spacious Jr. Suite includes an ensuite bath and the additional guest bedroom has custom built-in cabinetry so it can double as an office and slider opening to a gorgeous patio with ocean views. The outdoor spaces are highlighted by lush, tropical landscaping, stamped concrete patio, multiple fruit trees, large sandstone patio designed to capture natures beauty and relaxing in ground sandstone lined spa with unparalleled views of the ocean, Ventura Pier, and C street all the way down the Oxnard coastline. The private setting enhances the experience of this one-of-a-kind property. Ideally located with great walkability, you can enjoy Main Street shops and restaurants, Ventura Pier, the Boardwalk, Ventura Fairgrounds or catch train to Santa Barbara all within a matter of minutes." +"Appliances": "Double Oven,Dishwasher,Freezer,Gas Cooktop,Microwave,Refrigerator,Range Hood,Trash Compactor,Water Heater" +"BathroomsThreeQuarter": 2 +"CLIP": 8858837139 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Fishing,Hiking,Storm Drain(s),Street Lights,Park" +"ConstructionMaterials": "Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Ventura" +"CreationDate": "2025-05-22T03:25:12.800578+00:00" +"CumulativeDaysOnMarket": 14 +"DaysOnMarket": 16 +"DaysOnMarketReplication": 14 +"DaysOnMarketReplicationDate": "2025-06-04" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From E Main Street, North on N Kalamara Street, Turn Right on Church Street, Take Immediate Right into Driveway and Follow to the Back House" +"DocumentsChangeTimestamp": "2025-05-21T19:38:20Z" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "Chain Link,Masonry" +"FireplaceFeatures": "None" +"Flooring": "Bamboo, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air,Natural Gas" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Ventura Coastal" +"ListAgentDirectPhone": "(818) 314-8606" +"ListAgentEmail": "ryanshimpre@gmail.com" +"ListAgentFirstName": "Robert" +"ListAgentKey": "17320249" +"ListAgentKeyNumeric": "17320249" +"ListAgentLastName": "Shimp" +"ListAgentOfficePhone": "(818) 889-1602" +"ListAgentStateLicense": "01864245" +"ListAgentURL": "http://www.ryanshimp.evusa.com" +"ListOfficeAOR": "Ventura Coastal" +"ListOfficeFax": "(818) 889-1603" +"ListOfficeKey": "3281425" +"ListOfficeKeyNumeric": "3281425" +"ListOfficePhone": "(818) 889-1602" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-21" +"ListingKeyNumeric": 1114390188 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Back Yard,Drip Irrigation/Bubblers,Sprinklers In Rear,Irregular Lot,Lawn,Landscaped,Near Park,Near Public Transit,Sprinklers Timer,Sprinkler System,Sloped Up,Yard" +"LotSizeAcres": 0.22 +"LotSizeSquareFeet": 9583.0 +"MLSAreaMajor": "VC29 - Hillside above Poli St./ Foothill Rd" +"MlsStatus": "Active Under Contract" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-21" +"OnMarketTimestamp": "2025-05-21T12:53:31Z" +"OriginalEntryTimestamp": "2025-05-21T19:38:17Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "CRF" +"OriginatingSystemKey": "374452670" +"OriginatingSystemSubName": "CRMLS_CRF" +"ParcelNumber": "0720116050" +"ParkingFeatures": "Concrete,Driveway,Driveway Up Slope From Street,Garage,Off Street,Shared Driveway" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete,Front Porch,Stone" +"PhotosChangeTimestamp": "2025-05-22T03:10:41Z" +"PhotosCount": 31 +"PoolFeatures": "None" +"PostalCodePlus4": "2031" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Center Hall,Family Room,Kitchen,Living Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Ryan Shimp" +"ShowingContactPhone": "818-314-8606" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114390188" +"SpaFeatures": "Gunite,Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-03T17:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Buena Vista" +"StreetNumber": "941" +"StreetNumberNumeric": "941" +"StreetSuffix": "Street" +"StructureType": "House" +"UniversalPropertyId": "US-06111-N-0720116050-R-N" +"View": "City Lights,Coastline,Mountain(s),Ocean,Panoramic,Pier,Water" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Center Hall,Kitchen,Living Room,Family Room",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Open to Family Room,Remodeled Kitchen",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1114390188"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114390188')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": -1779163655 +"UniversalParcelId": "urn:reso:upi:2.0:US:06111:0720116050" +"CountrySubdivision": "06111" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "364101396" +"OriginatingSystemListAgentMemberKey": "570254" +"Media": array:31 [ …31] +"ID": "122632" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7592 +post_id: "85484" +post_author: 1 +"ListingKey": "1111828263" +"ListingId": "250024637SD" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-04T15:42:31Z" +"RFModificationTimestamp": "2025-06-04T16:06:36.962308+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6100.0 +"LivingArea": 1932.0 +"BuildingAreaTotal": 0 +"City": "San Diego" +"PostalCode": "92103" +"UnparsedAddress": "2019 Fort Stockton Dr, San Diego, California 92103" +"Coordinates": array:2 [ …2] +"Latitude": 32.75320194 +"Longitude": -117.18399208 +"YearBuilt": 1935 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Andrea Loomis-Williams" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "SAND-659756" +"ListOfficeMlsId": "SAND-66783" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Opportunity awaits! Serious price reduction! Charming 1935 single-story craftsman home in the heart of the Mission Hills Historic District. From its premier location, curb appeal and large elevated lot, this home shouldn't be missed. The property offers so much of its original charm, including beautiful hardwood floors, coved ceilings and a wonderful covered front porch. The living room includes a beautiful brick fireplace and multiple picture windows, filling the room with light. The lovely formal dining room sits just off the kitchen with original moldings and period accents. Includes a spacious patio, nice-sized yard and an ally-access garage with workshop. This rare property will not last!" +"Appliances": "6 Burner Stove,Dishwasher,Gas Cooktop,Disposal,Gas Oven,Gas Range,Refrigerator" +"BackOnMarketDate": "2025-05-14" +"BathroomsFull": 2 +"CLIP": 3106722960 +"ConstructionMaterials": "Wood Siding" +"ContractStatusChangeDate": "2025-04-11" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "San Diego" +"CreationDate": "2025-04-16T21:37:28.416716+00:00" +"CumulativeDaysOnMarket": 40 +"DaysOnMarket": 38 +"DaysOnMarketReplication": 35 +"DaysOnMarketReplicationDate": "2025-06-04" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Google Maps gives incorrect directions. Use Apple maps. Construction on streets surrounding home M-F. You may need to park 1/2 block away on Hickory or Pine. Cross Street: Pine." +"Fencing": "Partial" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Laminate, Tile, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "See Remarks" +"HeatingYN": true +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Gas Dryer Hookup,Inside" +"Levels": "One" +"ListAgentAOR": "San Diego" +"ListAgentDirectPhone": "858-449-2115" +"ListAgentEmail": "andreaw@coldwellbanker.com" +"ListAgentFax": "858-449-2115" +"ListAgentFirstName": "Andrea" +"ListAgentKey": "17243843" +"ListAgentKeyNumeric": "17243843" +"ListAgentLastName": "Loomis-Williams" +"ListAgentOfficePhone": "858-755-0075" +"ListAgentStateLicense": "01912456" +"ListOfficeAOR": "San Diego" +"ListOfficeEmail": "jed.etters@camoves.com" +"ListOfficeFax": "858-755-3086" +"ListOfficeKey": "3288415" +"ListOfficeKeyNumeric": "3288415" +"ListOfficePhone": "858-755-0075" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-11" +"ListingKeyNumeric": 1111828263 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.14 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6100.0 +"MLSAreaMajor": "92103 - Mission Hills" +"MlsStatus": "Active" +"OffMarketDate": "2025-04-30" +"OffMarketTimestamp": "2025-05-01T08:35:57Z" +"OnMarketDate": "2025-04-15" +"OnMarketTimestamp": "2025-04-16T06:55:27Z" +"OriginalEntryTimestamp": "2025-04-16T13:48:28Z" +"OriginalListPrice": 1850000.0 +"OriginatingSystemID": "SAND" +"OriginatingSystemKey": "374252652" +"OriginatingSystemSubName": "CRMLS_SAND" +"ParcelNumber": "4432511700" +"ParkingFeatures": "Garage Faces Rear" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Covered" +"PhotosChangeTimestamp": "2025-04-21T17:35:40Z" +"PhotosCount": 22 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PreviousListPrice": 1850000.0 +"PriceChangeTimestamp": "2025-05-27T17:00:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom,Den,Family Room" +"ShowingContactPhone": "858-449-2115" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111828263" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-20T17:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Fort Stockton Dr" +"StreetNumber": "2019" +"StreetNumberNumeric": "2019" +"SubdivisionName": "Mission Hills" +"UniversalPropertyId": "US-06073-N-4432511700-R-N" +"VirtualTourURLUnbranded": "http://ranchophotos.com/2019-fort-stockton-dr/" +"Zoning": "R-1:SINGLE" +"CustomFields": """ {\n "RoomType": "Main Floor Bedroom,Den,Family Room",\n "EatingArea": "Area",\n "AdminUpdateYN": "0",\n "ListingKey": "1111828263"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111828263')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": -1662363646 +"UniversalParcelId": "urn:reso:upi:2.0:US:06073:4432511700" +"CountrySubdivision": "06073" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "123471367" +"OriginatingSystemListAgentMemberKey": "123567619" +"Media": array:22 [ …22] +"ID": "85484" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7591 +post_id: "45097" +post_author: 1 +"ListingKey": "1102562199" +"ListingId": "250000702SD" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-05T02:12:53Z" +"RFModificationTimestamp": "2025-06-05T03:45:54.276349+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 109335.0 +"LivingArea": 6691.0 +"BuildingAreaTotal": 0 +"City": "Valley Center" +"PostalCode": "92082" +"UnparsedAddress": "28114 Queensbridge Rd, Valley Center, California 92082" +"Coordinates": array:2 [ …2] +"Latitude": 33.22401685 +"Longitude": -116.99749323 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Anna Cuevas" +"ListOfficeName": "USAFC Realty" +"ListAgentMlsId": "SAND-662738" +"ListOfficeMlsId": "SAND-61611" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Luxurious Multi-Generational Estate with Equestrian Facilities in Valley Center This exclusive 2.5-acre estate offers 3 separate dwellings, perfect for multi-generational families or luxury vacation rentals. The main home features 5 beds, 4 baths + office, a gourmet kitchen with 2 quartz waterfall islands, and a spa-like master suite. The 2-bed guest house and studio apartment provide privacy for extended family or rental income. Enjoy resort-style living with a pool, tennis court, and 864 sqft cabana. Equestrian enthusiasts will appreciate the on-site barn and ample space for riding. Nestled in the peaceful countryside, yet just minutes from shopping and fine dining, this estate offers the ultimate in privacy and convenience. Whether you're seeking a private retreat or an investment property, this estate presents endless possibilities. See it asap to experience this rare opportunity Perfect for Multi-gen - Next-Gen living in the North San Diego countryside! Just 15 minutes from Escondido. Fun fact: This property has been featured in several commercials and ad campaigns. It has a great ROI as a short term rental for large family reunions. Close to Harrahs San Diego Resort and Valley View Casinos. If a buyer is interested: all furnishings can be negotiated to be purchased separately to make it completely move in ready. Main home 5bd 4 bath +optional office bedroom 2 bedroom 1 bath guest house 928 sq ft Studio Apartment 1 bath 528 sq ft Cabana Game Room 864 sq ft Large Barn/Workshop 880 sq ft Storage/stable 200 sq ft 3 car garage 2 car garage Private tennis court & pool (Office in main home & 528 sq ft studio apartment w/kitchenette are the optional bedrooms included in listing.) •PLEASE NOTE• VERY IMPORTANT DO NOT DISTURB OCCUPANTS-DO NOT WALK ONTO THE PROPERTY WITHOUT AN APPOINTMENT SET - SHOWN BY APPOINTMENT with AGENT ONLY" +"AccessibilityFeatures": "Parking" +"Appliances": "Counter Top,Double Oven,Dishwasher,Electric Range,Free-Standing Range,Disposal,Gas Range,Propane Water Heater" +"ArchitecturalStyle": "Cape Cod,Modern,Ranch,Traditional" +"AssociationAmenities": "Fire Pit,Other,Picnic Area,Spa/Hot Tub" +"AssociationFee": "559.0" +"AssociationFeeFrequency": "Annually" +"AssociationPhone": "Po box 23" +"AssociationYN": true +"BathroomsFull": 6 +"CLIP": 3073919770 +"ContractStatusChangeDate": "2025-01-09" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Diego" +"CreationDate": "2025-01-09T18:46:31.825803+00:00" +"CumulativeDaysOnMarket": 146 +"DaysOnMarket": 148 +"DaysOnMarketReplication": 146 +"DaysOnMarketReplicationDate": "2025-06-05" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Valley Center Road to Queensbridge Road Cross Street: Roundtree." +"Disclosures": "Unincorporated" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Fire Pit" +"Fencing": "Fair Condition" +"FireplaceFeatures": "Family Room,Living Room" +"FireplaceYN": true +"Flooring": "Tile, Wood" +"GarageSpaces": "5.0" +"GarageYN": true +"Heating": "Electric,Fireplace(s),Heat Pump" +"HeatingYN": true +"InteriorFeatures": "Pantry,All Bedrooms Down,Workshop" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Electric Dryer Hookup,Laundry Room" +"Levels": "Multi/Split" +"ListAgentAOR": "San Diego" +"ListAgentDirectPhone": "760-594-4598" +"ListAgentEmail": "acuevas@me.com" +"ListAgentFax": "760-594-4598" +"ListAgentFirstName": "Anna" +"ListAgentKey": "17137481" +"ListAgentKeyNumeric": "17137481" +"ListAgentLastName": "Cuevas" +"ListAgentOfficePhone": "858-560-1100" +"ListAgentStateLicense": "00991702" +"ListOfficeAOR": "San Diego" +"ListOfficeFax": "858-633-2880" +"ListOfficeKey": "3213209" +"ListOfficeKeyNumeric": "3213209" +"ListOfficePhone": "858-560-1100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-01-09" +"ListingKeyNumeric": 1102562199 +"ListingService": "Full Service" +"ListingTerms": "Cash" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 2.51 +"LotSizeDimensions": "381x321x257x384" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 109335.0 +"MLSAreaMajor": "92082 - Valley Center" +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 3 +"OccupantType": "Tenant" +"OnMarketDate": "2025-01-08" +"OnMarketTimestamp": "2025-01-09T02:19:45Z" +"OpenParkingSpaces": "20.0" +"OriginalEntryTimestamp": "2025-01-09T10:14:21Z" +"OriginalListPrice": 1775000.0 +"OriginatingSystemID": "SAND" +"OriginatingSystemKey": "373773260" +"OriginatingSystemSubName": "CRMLS_SAND" +"OtherStructures": "Barn(s),Guest House Detached,Guest House,Storage,Tennis Court(s),Cabana" +"ParcelNumber": "1890412500" +"ParkName": "Valley Center Estates" +"ParkingFeatures": "Asphalt,Door-Multi,Garage,Workshop in Garage" +"ParkingTotal": "25.0" +"PatioAndPorchFeatures": "Concrete, Deck" +"PhotosChangeTimestamp": "2025-01-19T11:39:55Z" +"PhotosCount": 43 +"PoolFeatures": "Heated, Private" +"PoolPrivateYN": true +"PreviousListPrice": 1699000.0 +"PriceChangeTimestamp": "2025-06-03T17:00:00Z" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom,Game Room,Office,Workshop" +"Sewer": "Septic Tank" +"ShowingContactName": "Listing agent: Anna Cuevas" +"ShowingContactPhone": "7605944598" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1102562199" +"SpaYN": true +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-02T16:00:00Z" +"StreetName": "Queensbridge Rd" +"StreetNumber": "28114" +"StreetNumberNumeric": "28114" +"SubdivisionName": "Valley Center" +"UniversalPropertyId": "US-06073-N-1890412500-R-N" +"Utilities": "Cable Available,Propane" +"View": "Park/Greenbelt, Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/snd/250000702" +"YearBuiltSource": "Assessor" +"Zoning": "A8" +"CustomFields": """ {\n "RoomType": "Office,Workshop,Game Room,All Bedrooms Down",\n "AdminUpdateYN": "0",\n "ListingKey": "1102562199"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1102562199')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 1048168852 +"UniversalParcelId": "urn:reso:upi:2.0:US:06073:1890412500" +"CountrySubdivision": "06073" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "123470693" +"OriginatingSystemListAgentMemberKey": "364261865" +"Media": array:43 [ …43] +"ID": "45097" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7590 +post_id: "127482" +post_author: 1 +"ListingKey": "1114561213" +"ListingId": "219130636DA" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-29T20:06:48Z" +"RFModificationTimestamp": "2025-05-29T23:20:03.485037+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13068.0 +"LivingArea": 1861.0 +"BuildingAreaTotal": 0 +"City": "Palm Springs" +"PostalCode": "92262" +"UnparsedAddress": "1029 E El Alameda, Palm Springs, California 92262" +"Coordinates": array:2 [ …2] +"Latitude": 33.835057 +"Longitude": -116.536321 +"YearBuilt": 1935 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kathleen Negrete" +"ListOfficeName": "McGraw REALTORS & Associates" +"ListAgentMlsId": "CDAR-D70598" +"ListOfficeMlsId": "CDAR-oD8207" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Step back in time and embrace the allure of this exquisite 1930s bungalow, a true gem nestled in the heart of the historic movie colony. Imagine the whispers of early Hollywood echoing through these walls, with the legendary Bing Crosby as your next-door neighbor. Just a leisurely stroll away lies the picturesque Ruth Hardy Park, offering breathtaking panoramic mountain vistas that have captivated generations.This charming desert oasis boasts four bedrooms and four bathrooms, including a wonderfully convenient poolside retreat. Picture yourself unwinding on the expansive lot, complete with stylish cabanas, a sparkling pool, and a rejuvenating spa, all while soaking in those magnificent views from the unique grandfathered balcony.Inside, discover the thoughtful blend of vintage charm and modern comfort. A captivating fireplace from the bungalow's original era serves as a warm focal point in the spacious living areas, filled with delightful nooks and crannies just waiting to be explored. With the added convenience of a 3-ton Havoc system and energy-efficient mini-splits throughout, comfort and conservation go hand in hand. And for ultimate flexibility, the property features not one, but two luxurious master suites!Don't miss this extraordinary opportunity to live in a piece of mid-century history, a custom property brimming with character and ready to create your own unforgettable memories.'" +"Appliances": "Dishwasher,Gas Cooktop,Gas Oven,Gas Range,Gas Water Heater,Refrigerator,Range Hood,Vented Exhaust Fan" +"ArchitecturalStyle": "Bungalow" +"BathroomsFull": 4 +"CLIP": 4699589946 +"CarportSpaces": "4.0" +"CarportYN": true +"CommunityFeatures": "Park" +"ContractStatusChangeDate": "2025-04-28" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-27T16:48:38.429917+00:00" +"DaysOnMarket": 10 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-05-29" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "E El Alameda and Tamarisk Across from Ruth Hardy Park Cross Street: Ruth Hardy Park and East El Alameda." +"Disclosures": "Historical,Home Warranty" +"DocumentsChangeTimestamp": "2025-05-27T09:11:20Z" +"ExteriorFeatures": "Barbecue, Kennel" +"FireplaceFeatures": "Decorative,Gas,Great Room" +"FireplaceYN": true +"Flooring": "Laminate, Tile, Wood" +"Heating": "Forced Air,Fireplace(s),Natural Gas" +"HeatingYN": true +"InteriorFeatures": "Separate/Formal Dining Room" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 702-1212" +"ListAgentEmail": "mydesertproperties@gmail.com" +"ListAgentFirstName": "Kathleen" +"ListAgentKey": "17292928" +"ListAgentKeyNumeric": "17292928" +"ListAgentLastName": "Negrete" +"ListAgentOfficePhone": "760-702-1212" +"ListAgentStateLicense": "00974042" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "mydesertproperties@gmail.com" +"ListOfficeKey": "3213890" +"ListOfficeKeyNumeric": "3213890" +"ListOfficePhone": "760-702-1212" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-04-28" +"ListingKeyNumeric": 1114561213 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,FHA,VA Loan,VA No Loan,VA No No Loan" +"LivingAreaSource": "Other" +"LotFeatures": "Near Park,Sprinklers Timer,Sprinkler System" +"LotSizeAcres": 0.3 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 13068.0 +"MLSAreaMajor": "332 - Central Palm Springs" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-27" +"OnMarketTimestamp": "2025-05-27T02:25:36Z" +"OpenParkingSpaces": "4.0" +"OriginalEntryTimestamp": "2025-05-27T09:11:19Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374473752" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "507233002" +"ParkingFeatures": "Circular Driveway" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-05-27T16:39:41Z" +"PhotosCount": 78 +"PoolFeatures": "Gunite,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "5815" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Clay" +"RoomType": "Bonus Room,Game Room,Dining Room" +"ShowingContactName": "Kathleen McGraw Negrete" +"ShowingContactPhone": "760-702-1212" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114561213" +"SpaFeatures": "Gunite,Heated,In Ground,Private" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-26T22:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "El Alameda" +"StreetNumber": "1029" +"StreetNumberNumeric": "1029" +"UniversalPropertyId": "US-06065-N-507233002-R-N" +"View": "Mountain(s), Panoramic" +"ViewYN": true +"WindowFeatures": "Blinds" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Game Room,Bonus Room",\n "EatingArea": "Dining Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1114561213",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114561213')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": -2030359985 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:507233002" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "8204093" +"OriginatingSystemListAgentMemberKey": "8228903" +"Media": array:78 [ …78] +"ID": "127482" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7589 +post_id: "51506" +post_author: 1 +"ListingKey": "1108720673" +"ListingId": "ML81998128" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-05T19:52:07Z" +"RFModificationTimestamp": "2025-06-05T19:59:26.735281+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 13520.0 +"LivingArea": 2537.0 +"BuildingAreaTotal": 0 +"City": "Orinda" +"PostalCode": "94563" +"UnparsedAddress": "27 Whitehall Drive, Orinda, California 94563" +"Coordinates": array:2 [ …2] +"Latitude": 37.84732093 +"Longitude": -122.14928153 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "David Lam" +"ListOfficeName": "Kha David C. Lam, Broker" +"ListAgentMlsId": "ML163349" +"ListOfficeMlsId": "ML39936" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Nestled in the sought-after Ivy Drive area, this beautifully updated 4 bedrooms, 3-baths, 2,537 sq. ft. home on a 0.31-acre lot blends casual elegance w/ modern functionality. Perfectly positioned between all K-12 schools, near MV Swim & Tennis Club, and MCC, this home offers the best of convenience and community. Step inside to an open floor plan designed for seamless indoor-outdoor living. Two sun-drenched decks create the perfect space for entertaining or unwinding, while large windows invite natural light throughout. The split-level layout offers ultimate privacy, with a stunning master retreat upstairs, complete with a private deck and flex space (ie, nursery, home office, or meditation room). On the first floor, a second en-suite bedroom provides comfort for guests or multi-generational living. The fourth bedroom doesn't have a closet and can be transformed into a home office, game room, or keep as a bedroom; the possibilities are endless! Don't cross this home off your list, come see this home and you'll love it." +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 7909551643 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-03-15" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Contra Costa" +"CreationDate": "2025-03-16T05:49:57.034741+00:00" +"DaysOnMarket": 83 +"DaysOnMarketReplication": 82 +"DaysOnMarketReplicationDate": "2025-06-05" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From 24, go east/south bound on Moraga Wy and then turn onto Whitehall Dr. Cross Street: Moraga Way" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "408-439-0547" +"ListAgentEmail": "lamdavidkc@gmail.com" +"ListAgentFax": "408-519-6771" +"ListAgentFirstName": "David" +"ListAgentKey": "20885087" +"ListAgentKeyNumeric": "20885087" +"ListAgentLastName": "Lam" +"ListAgentOfficePhone": "408-439-0547" +"ListAgentStateLicense": "01343016" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "408-519-6771" +"ListOfficeKey": "4769445" +"ListOfficeKeyNumeric": "4769445" +"ListOfficePhone": "408-439-0547" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-15" +"ListingKeyNumeric": 1108720673 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.3104 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 13520.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-03-15" +"OnMarketTimestamp": "2025-03-15T15:35:27Z" +"OriginalEntryTimestamp": "2025-03-15T15:04:54Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374088268" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "2713400147" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-03-19T19:10:41Z" +"PhotosCount": 29 +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108720673" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-15T15:04:54Z" +"StoriesTotal": "2" +"StreetName": "Whitehall" +"StreetNumber": "27" +"StreetNumberNumeric": "27" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06013-N-2713400147-R-N" +"VirtualTourURLBranded": "https://vimeo.com/971015158" +"VirtualTourURLUnbranded": "https://vimeo.com/971015244" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R1" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1108720673"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108720673')" +"CurrentPrice": 1750000.0 +"provider_name": "CRMLS" +"RecordSignature": 1467491196 +"UniversalParcelId": "urn:reso:upi:2.0:US:06013:2713400147" +"CountrySubdivision": "06013" +"OriginatingSystemListOfficeKey": "368565238" +"OriginatingSystemListAgentMemberKey": "368695701" +"Media": array:29 [ …29] +"ID": "51506" } ] +success: true +page_size: 12 +page_count: 7663 +count: 91948 +after_key: "" } "RF Response Time" => "0.18 seconds" ] "RF Query: /Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease')/Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease')&$expand=Media/Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease')/Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$skip=17964&$filter=(StandardStatus in ('Active','Active Under Contract')) and (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#7604 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#313 +post_id: "7233" +post_author: 1 +"ListingKey": "446931970" +"ListingId": "PW20091457" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-06T20:51:44Z" +"RFModificationTimestamp": "2025-05-06T22:05:06.070755+00:00" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 56628.0 +"LivingArea": 0 +"BuildingAreaTotal": 2400.0 +"City": "La Habra" +"PostalCode": "90631" +"UnparsedAddress": "2424 W Whittier Boulevard, La Habra, California 90631" +"Coordinates": array:2 [ …2] +"Latitude": 33.939703 +"Longitude": -117.973457 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gregory Jones" +"ListOfficeName": "Jones Real Estate" +"ListAgentMlsId": "NJONEGRE" +"ListOfficeMlsId": "N239" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Multi-tenant shopping center. Great exposure on Whittier Blvd with common area parking. Co-Tenants are Laundry, Honey Baked Hams, Nail Salon, Dentist, Jax Donuts and Shang Hwa Restaurant. \r\r\n \r\r\n Available:\r\r\n Unit 2418 - 1,520 SF - $$1.50 NNN $0.40\r\r\n Unit 2424 - 100 - 1,000 SF $TBD\r\r\n Unit 2436 - 2,222 SF - $1.50 NNN $ 0.54 """ +"AttributionContact": "greg@Jones RE.net" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Park" +"ContractStatusChangeDate": "2020-05-13" +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2022-12-28T16:58:14.315440+00:00" +"CumulativeDaysOnMarket": 1814 +"DaysOnMarket": 1845 +"DaysOnMarketReplication": 1814 +"DaysOnMarketReplicationDate": "2025-05-06" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "On Whittier Boulevard, Between Beach and Valley Home" +"ExistingLeaseType": "NNN" +"Fencing": "None" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "greg@Jones RE.net" +"ListAgentFax": "562-697-9999" +"ListAgentFirstName": "Gregory" +"ListAgentKey": "17102101" +"ListAgentKeyNumeric": "17102101" +"ListAgentLastName": "Jones" +"ListAgentOfficePhone": "562-697-3333" +"ListAgentOfficePhoneExt": "0" +"ListAgentPager": "000-0000" +"ListAgentStateLicense": "00661121" +"ListAgentURL": "Jones RE.net" +"ListAgentVoiceMail": "000-0000" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-697-9999" +"ListOfficeKey": "3259195" +"ListOfficeKeyNumeric": "3259195" +"ListOfficePhone": "562-697-3333" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2020-05-13" +"ListingKeyNumeric": 446931970 +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Landscaped,Near Park,Near Public Transit" +"LotSizeAcres": 1.3 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 56628.0 +"MLSAreaMajor": "87 - La Habra" +"MajorChangeTimestamp": "2020-05-18T14:45:50Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2020-05-18" +"OnMarketTimestamp": "2020-05-18T14:45:50Z" +"OriginalEntryTimestamp": "2020-05-18T14:45:50Z" +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "364429345" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "01831211" +"PhotosChangeTimestamp": "2025-05-06T20:54:40Z" +"PhotosCount": 3 +"PostalCodePlus4": "3407" +"PropertySubTypeAdditional": "Retail" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "446931970" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2020-05-18T14:45:50Z" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "Whittier" +"StreetNumber": "2424" +"StreetNumberNumeric": "2424" +"StreetSuffix": "Boulevard" +"UniversalPropertyId": "US-06059-N-01831211-R-N" +"WaterSource": "Public" +"CustomFields": """ {\n "ListingKey": "446931970",\n "DPResourceYN": "0",\n "ConcessionInPrice": "",\n "ConcessionInPriceType": "",\n "AdminUpdateYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('446931970')" +"provider_name": "CRMLS" +"RecordSignature": -1835550745 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:01831211" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "41276" +"OriginatingSystemListAgentMemberKey": "275501" +"Media": array:3 [ …3] +"ID": "7233" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7576 +post_id: "94260" +post_author: 1 +"ListingKey": "1112278398" +"ListingId": "SW25093397" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-06T20:24:41Z" +"RFModificationTimestamp": "2025-05-06T20:28:23.800156+00:00" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1874.0 +"LivingArea": 0 +"BuildingAreaTotal": 1874.0 +"City": "Wildomar" +"PostalCode": "92595" +"UnparsedAddress": "34859 Frederick Street 114, Wildomar, California 92595" +"Coordinates": array:2 [ …2] +"Latitude": 33.61472 +"Longitude": -117.258603 +"YearBuilt": 2004 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Daniel Olszko" +"ListOfficeName": "McDermott Realty Group" +"ListAgentMlsId": "SWOLSZDAN" +"ListOfficeMlsId": "SWJMB01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Prime End-Cap Retail/Office Space with Freeway Visibility – Willow Creek Center, Wildomar, CA Outstanding opportunity to lease or purchase a highly desirable end-cap retail/office unit with exceptional signage visibility and direct access to the I-15 Freeway. Strategically located within close proximity to Inland Valley Medical Center and several major commercial and residential developments. Located within the Willow Creek Professional Center, a well-maintained 14-unit commercial office condominium complex, this ±1,874 SF ground-floor unit (Unit #114) is ideal for retail, showroom, or professional office uses. The unit offers a functional standard office build-out, including: • Laminate flooring and ceramic tile flooring • T-bar suspended ceiling with integrated LED lighting • Drywall interior partition walls • Private restroom As part of the larger Willow Creek project, the center offers tenants and owners shared exposure alongside a ±34,183 SF multi-tenant retail center, providing excellent synergy and foot traffic. Key Highlights: • End-cap location with strong visibility • Immediate freeway access (I-15 Freeway) • Excellent signage opportunities • Close to Inland Valley Medical Center • Ample parking • Centrally located within Wildomar’s growing commercial corridor This is a rare opportunity to position your business in a vibrant, accessible location that benefits from both medical and retail traffic. Contact us today for a private tour or additional information!" +"BuildingAreaUnits": "Square Feet" +"CLIP": 3235029028 +"ContractStatusChangeDate": "2025-04-24" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-04-28T23:36:08.145874+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 39 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-05-06" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit Wildomar trail off of the 15 fwy. Head east and turn left on Monte Vista. Center is located on the left hand side. Please make sure to put suite number in when using google maps." +"EntryLevel": 1 +"ExistingLeaseType": "NNN" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Southwest Riverside County" +"ListAgentEmail": "dan@mcdermottrealtygroup.com" +"ListAgentFirstName": "Daniel" +"ListAgentKey": "25891076" +"ListAgentKeyNumeric": "25891076" +"ListAgentLastName": "Olszko" +"ListAgentOfficePhone": "951-314-1856" +"ListAgentStateLicense": "02251426" +"ListOfficeAOR": "Southwest Riverside County" +"ListOfficeEmail": "info@mcdermottrealtygroup.com" +"ListOfficeFax": "951-926-2945" +"ListOfficeKey": "3285416" +"ListOfficeKeyNumeric": "3285416" +"ListOfficePhone": "951-314-1856" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-04-24" +"ListingKeyNumeric": 1112278398 +"LotFeatures": "11-15 Units/Acre" +"LotSizeAcres": 0.043 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 1874.0 +"MLSAreaMajor": "SRCAR - Southwest Riverside County" +"MajorChangeTimestamp": "2025-04-28T15:05:34Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"OccupantType": "Tenant" +"OnMarketDate": "2025-04-28" +"OnMarketTimestamp": "2025-04-28T15:05:34Z" +"OriginalEntryTimestamp": "2025-04-28T15:05:34Z" +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374315999" +"OriginatingSystemSubName": "CRMLS_CRM" +"OwnerPays": "None" +"ParcelNumber": "367181014" +"PhotosChangeTimestamp": "2025-04-28T22:43:40Z" +"PhotosCount": 13 +"PostalCodePlus4": "7007" +"PropertySubTypeAdditional": "Office" +"ShowingContactName": "Daniel Olszko" +"ShowingContactPhone": "951-834-4266" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112278398" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-28T15:05:34Z" +"StoriesTotal": "1" +"StreetName": "Frederick" +"StreetNumber": "34859" +"StreetNumberNumeric": "34859" +"StreetSuffix": "Street" +"TenantPays": "Association Fees,All Utilities,HVAC Maintenance,Taxes" +"UnitNumber": "114" +"UniversalPropertyId": "US-06065-N-367181014-R-N" +"WaterSource": "Public" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1112278398"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112278398')" +"provider_name": "CRMLS" +"RecordSignature": 613184384 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:367181014" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "14012162" +"OriginatingSystemListAgentMemberKey": "373832914" +"Media": array:13 [ …13] +"ID": "94260" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7603 +post_id: "101777" +post_author: 1 +"ListingKey": "1112677988" +"ListingId": "TR25099880" +"PropertyType": "Commercial Lease" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-05T23:41:22Z" +"RFModificationTimestamp": "2025-05-06T01:02:01.722668+00:00" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 242015.0 +"LivingArea": 0 +"BuildingAreaTotal": 300000.0 +"City": "Highland" +"PostalCode": "92346" +"UnparsedAddress": "7820 Victoria Avenue, Highland, California 92346" +"Coordinates": array:2 [ …2] +"Latitude": 34.111639 +"Longitude": -117.226354 +"YearBuilt": 2023 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ivy Su" +"ListOfficeName": "WeTrust Realty" +"ListAgentMlsId": "TRSUIVY" +"ListOfficeMlsId": "PB22120" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ For Sublease – Brand New Gated Yard with Trailer and Small Parking Stalls\r\r\n \r\r\n Available for sublease is approximately 44,000 SF of gated yard space, part of a brand-new warehouse property. The sublessor occupies the warehouse and a portion of the lot; the remaining yard (as shown in the site plan) is available for lease.\r\r\n \r\r\n The available space includes:\r\r\n Approx. 33 trailer parking stalls, each measuring about 106’ x 12’\r\r\n 5 smaller parking stalls, each about 40’ x 11’\r\r\n \r\r\n Rental Options:\r\r\n Entire yard preferred at $0.35/SF per month gross\r\r\n Or lease by individual stalls:\r\r\n Trailer parking: $500/stall/month\r\r\n Smaller parking stalls: $300/stall/month\r\r\n Rates negotiable\r\r\n This is a brand-new, gated facility, offering a clean, secure, and professional environment for your operations.\r\r\n \r\r\n Note: All sizes are approximate. Prospective tenants and/or their agents are advised to conduct their own investigation to independently verify all details and satisfy themselves.\r\r\n \r\r\n Sublease is subject to the master landlord’s final approval. """ +"BuildingAreaUnits": "Square Feet" +"CLIP": 1013719727 +"ContractStatusChangeDate": "2025-05-01" +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-05-06T01:02:01.484794+00:00" +"DaysOnMarketReplicationDate": "2025-05-05" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "please use GPS" +"ExistingLeaseType": "Other" +"RFTransactionType": "For Rent" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Tri-Counties" +"ListAgentEmail": "realty@ivysu.com" +"ListAgentFirstName": "Ivy" +"ListAgentKey": "25752715" +"ListAgentKeyNumeric": "25752715" +"ListAgentLastName": "Su" +"ListAgentOfficePhone": "626-587-4866" +"ListAgentStateLicense": "02235547" +"ListOfficeAOR": "Tri-Counties" +"ListOfficeEmail": "admin@wetrustrealty.com" +"ListOfficeFax": "626-287-7797" +"ListOfficeKey": "5359666" +"ListOfficeKeyNumeric": "5359666" +"ListOfficePhone": "626-587-4866" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-05-01" +"ListingKeyNumeric": 1112677988 +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Lot Over 40000 Sqft,Paved,Yard" +"LotSizeAcres": 5.5559 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 242015.0 +"MLSAreaMajor": "276 - Highland" +"MajorChangeTimestamp": "2025-05-05T16:08:13Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"OccupantType": "Tenant" +"OnMarketDate": "2025-05-05" +"OnMarketTimestamp": "2025-05-05T16:08:13Z" +"OriginalEntryTimestamp": "2025-05-05T16:08:13Z" +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374358396" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "1192281150000" +"PhotosChangeTimestamp": "2025-05-05T23:42:39Z" +"PhotosCount": 11 +"PropertySubTypeAdditional": "Industrial" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112677988" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-05T16:08:13Z" +"StreetName": "Victoria" +"StreetNumber": "7820" +"StreetNumberNumeric": "7820" +"StreetSuffix": "Avenue" +"UniversalPropertyId": "US-06071-N-1192281150000-R-N" +"WaterSource": "Other" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1112677988"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112677988')" +"provider_name": "CRMLS" +"short_address": "Highland, California 92346, US" +"RecordSignature": -1702356090 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:1192281150000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "372469977" +"OriginatingSystemListAgentMemberKey": "373746757" +"Media": array:11 [ …11] +"ID": "101777" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7575 +post_id: "101360" +post_author: 1 +"ListingKey": "1112599571" +"ListingId": "MB25099418" +"PropertyType": "Commercial Lease" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-05T19:39:10Z" +"RFModificationTimestamp": "2025-05-05T22:54:16.842691+00:00" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 6024.0 +"LivingArea": 0 +"BuildingAreaTotal": 2400.0 +"City": "Huntington Park" +"PostalCode": "90255" +"UnparsedAddress": "6823 Seville Avenue, Huntington Park, California 90255" +"Coordinates": array:2 [ …2] +"Latitude": 33.977187 +"Longitude": -118.222817 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "MARIA CAMELO" +"ListOfficeName": "EXCELLENCE RE REAL ESTATE" +"ListAgentMlsId": "M447477" +"ListOfficeMlsId": "9702" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Seize a turnkey opportunity in Huntington Park's thriving restaurant scene. This space, currently an Italian / Mexican Restaurant, comes equipped with valuable infrastructure, including a kitchen with, restrooms, and ample storage. The versatile layout can accommodate and is perfect for a variety of concepts. Benefit from high visibility on and proximity to. This is more than just a lease; it's a chance to establish a beloved restaurant in a dynamic market" +"AttributionContact": "323-945-7947" +"BuildingAreaUnits": "Square Feet" +"CLIP": 4195170633 +"ContractStatusChangeDate": "2025-05-05" +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-05-05T22:54:16.367959+00:00" +"DaysOnMarketReplicationDate": "2025-05-05" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Corner of Saturn and Seville next to Guadalupe Clinic" +"EntryLevel": 1 +"Exclusions": "Beer and Wine license negotiable" +"ExistingLeaseType": "Other" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Montebello District" +"ListAgentDirectPhone": "323-945-7947" +"ListAgentEmail": "MARISOL@CAMELOREALTY.COM" +"ListAgentFax": "888-855-9352" +"ListAgentFirstName": "MARIA" +"ListAgentKey": "17056906" +"ListAgentKeyNumeric": "17056906" +"ListAgentLastName": "CAMELO" +"ListAgentOfficePhone": "562-948-4553" +"ListAgentStateLicense": "02033615" +"ListAgentVoiceMail": "323-945-7947" +"ListOfficeAOR": "Montebello District" +"ListOfficeEmail": "RONMACIAS730@YAHOO.COM" +"ListOfficeFax": "562-948-2806" +"ListOfficeKey": "3111815" +"ListOfficeKeyNumeric": "3111815" +"ListOfficePhone": "562-948-4553" +"ListOfficeURL": "Excellence RE.com" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-05-05" +"ListingKeyNumeric": 1112599571 +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Walkstreet" +"LotSizeAcres": 0.1383 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6024.0 +"MLSAreaMajor": "T5 - WalnutPk, HuntPk, Bell N of Florence, and Cud" +"MajorChangeTimestamp": "2025-05-05T12:03:23Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-05" +"OnMarketTimestamp": "2025-05-05T12:03:23Z" +"OriginalEntryTimestamp": "2025-05-05T12:03:23Z" +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374356703" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "6322016011" +"PhotosChangeTimestamp": "2025-05-05T19:39:40Z" +"PhotosCount": 2 +"PostalCodePlus4": "4805" +"PropertySubTypeAdditional": "Business" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112599571" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-05T12:03:23Z" +"StoriesTotal": "1" +"StreetName": "Seville" +"StreetNumber": "6823" +"StreetNumberNumeric": "6823" +"StreetSuffix": "Avenue" +"UniversalPropertyId": "US-06037-N-6322016011-R-N" +"WaterSource": "Public" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1112599571"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112599571')" +"provider_name": "CRMLS" +"short_address": "Huntington Park, California 90255, US" +"RecordSignature": 1251119266 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:6322016011" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "104737" +"OriginatingSystemListAgentMemberKey": "359581749" +"Media": array:2 [ …2] +"ID": "101360" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7577 +post_id: "42117" +post_author: 1 +"ListingKey": "1108258798" +"ListingId": "WS25043135" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-03-17T20:08:40Z" +"RFModificationTimestamp": "2025-03-18T01:20:38.992307+00:00" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 28390.0 +"LivingArea": 0 +"BuildingAreaTotal": 74024.0 +"City": "Alhambra" +"PostalCode": "91801" +"UnparsedAddress": "101 S Chapel Avenue 101, Alhambra, California 91801" +"Coordinates": array:2 [ …2] +"Latitude": 34.095391 +"Longitude": -118.123296 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "QI DING" +"ListOfficeName": "SAFCO REALTY" +"ListAgentMlsId": "W74014" +"ListOfficeMlsId": "7607" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "The only one office/retail space available at 101 Alhambra Square, a corner space at the brand new mixed-use contemporary condo built in 2024. Perfectly situated in the heart of the downtown Alhambra, boasting an enviable central location, this office unit is completely built-out including its own central A/C, a private restroom, fire sprinkler, exposed ceiling, cabinets, a hand sink and a build-in fridge. It is right next to bustling shopping centers anchored with popular destinations such as Edward Renaissance Theater, Sprouts, Sephora, and many restaurants and local retail stores. Nearby freeway 10 and 710, 101 Alhambra Square offers easy access to DTLA, Old Town Pasadena with high foot traffic. Please call to schedule a tour!" +"AttributionContact": "626-641-3216" +"BuildingAreaUnits": "Square Feet" +"BuildingName": "101 Alhambra Square" +"CLIP": 2335362756 +"CarportSpaces": "4.0" +"CarportYN": true +"ConstructionMaterials": "Drywall, Concrete" +"ContractStatusChangeDate": "2025-03-03" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-03-08T11:35:33.799236+00:00" +"CumulativeDaysOnMarket": 13 +"CurrentUse": "Multi-Family" +"DaysOnMarket": 94 +"DaysOnMarketReplication": 13 +"DaysOnMarketReplicationDate": "2025-03-17" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "South of Main Street" +"EntryLevel": 1 +"Exclusions": "Microwave" +"ExistingLeaseType": "NNN" +"Inclusions": "Fridge" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "West San Gabriel Valley" +"ListAgentDirectPhone": "626-289-4088" +"ListAgentEmail": "jackie216@yahoo.com" +"ListAgentFax": "626-300-8025" +"ListAgentFirstName": "QI" +"ListAgentKey": "17055999" +"ListAgentKeyNumeric": "17055999" +"ListAgentLastName": "DING" +"ListAgentOfficePhone": "626-289-4088" +"ListAgentStateLicense": "01744140" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "West San Gabriel Valley" +"ListOfficeEmail": "karenasujo@yahoo.com" +"ListOfficeFax": "626-289-4088" +"ListOfficeKey": "3267697" +"ListOfficeKeyNumeric": "3267697" +"ListOfficePhone": "626-289-4088" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2025-03-03" +"ListingKeyNumeric": 1108258798 +"ListingService": "Full Service" +"LotFeatures": "Near Public Transit" +"LotSizeAcres": 0.6517 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 28390.0 +"MLSAreaMajor": "601 - Alhambra" +"MajorChangeTimestamp": "2025-03-04T15:16:42Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-03-04" +"OnMarketTimestamp": "2025-03-04T15:16:42Z" +"OriginalEntryTimestamp": "2025-03-04T15:16:42Z" +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374025809" +"OriginatingSystemSubName": "CRMLS_CRM" +"OwnerPays": "Roof Maintenance,Trash Collection" +"ParcelNumber": "5345004006" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-03-04T23:53:41Z" +"PhotosCount": 8 +"PostalCodePlus4": "3951" +"PropertySubTypeAdditional": "Office" +"ShowingContactPhone": "6265008157" +"ShowingContactType": "Property Manager" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108258798" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-04T15:16:42Z" +"StoriesTotal": "5" +"StreetDirPrefix": "S" +"StreetName": "Chapel" +"StreetNumber": "101" +"StreetNumberNumeric": "101" +"StreetSuffix": "Avenue" +"TenantPays": "All Utilities,Cable TV,Electricity,HVAC Maintenance,Insurance,Pest Control,Repairs,See Remarks,Sewer,Water" +"UnitNumber": "101" +"UniversalPropertyId": "US-06037-N-5345004006-R-N" +"Utilities": "Electricity Connected,Sewer Connected,Water Connected" +"WaterSource": "Public" +"YearBuiltSource": "Builder" +"Zoning": "CBD" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1108258798"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108258798')" +"provider_name": "CRMLS" +"RecordSignature": 282229108 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:5345004006" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "1632" +"OriginatingSystemListAgentMemberKey": "184624" +"Media": array:8 [ …8] +"ID": "42117" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7602 +post_id: "61846" +post_author: 1 +"ListingKey": "1109317683" +"ListingId": "PW25067019" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-03-27T19:10:05Z" +"RFModificationTimestamp": "2025-03-27T23:35:56.910244+00:00" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 6203.0 +"LivingArea": 0 +"BuildingAreaTotal": 4000.0 +"City": "Long Beach" +"PostalCode": "90807" +"UnparsedAddress": "4346 Atlantic Avenue, Long Beach, California 90807" +"Coordinates": array:2 [ …2] +"Latitude": 33.835416 +"Longitude": -118.184632 …94 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7609 …118} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7574 …121} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7573 …111} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7572 …112} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7571 …115} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7605 …128} ] +success: true +page_size: 12 +page_count: 1514 +count: 18164 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]
