Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 5086bf0878929ec9f752a5ddd6531bdede8b4ae9ad8bf6ff9b938e6596ff74c0" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4932 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1103837937" +"ListingId": "MC25022258" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-16T05:06:17Z" +"RFModificationTimestamp": "2025-06-16T05:08:58.958235+00:00" +"ListPrice": 775000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 8656.0 +"LivingArea": 3054.0 +"BuildingAreaTotal": 0 +"City": "Turlock" +"PostalCode": "95382" +"UnparsedAddress": "223 Vintage Drive, Turlock, California 95382" +"Coordinates": array:2 [ 0 => -120.851115 1 => 37.536207 ] +"Latitude": 37.536207 +"Longitude": -120.851115 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Robin Popolizio" +"ListOfficeName": "Pmz Real Estate, Turlock" +"ListAgentMlsId": "mcpoporo" +"ListOfficeMlsId": "MC143M" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Rare Opportunity for an amazing home with an oasis yard and plenty of space for all your needs. No reason to take vacations when you have a resort in your own back yard! This amazing home, owned and lovingly maintained by its original owners, offers a thoughtful layout that caters to both growing families and multi-generational living. Located just a short walk from Sandra T. Medeiros Elementary and park, this property is perfect for families looking for convenience, comfort, and space. The downstairs features a full bedroom and updated bath, making it ideal for senior family members or guests. Upstairs, you'll find four spacious bedrooms and a large bonus room complete with a wall-sized chalkboard, perfect for homeschooling or creative play. Enjoy outdoor living at its best with a large pool featuring a slide for endless summer fun, as well as a relaxing spa to unwind at the end of the day. With over 3,000 square feet of living space, a large two story shed and a deep tandem garage, there's plenty of room for all your needs. Don't miss the 3 D Media to see the full floor plan! See attached list of Enhancements/Amenities/Maintenance items" +"ActivationDate": "2025-02-20" +"AttachedGarageYN": true +"AttributionContact": "209-262-7747" +"BathroomsFull": 3 +"CLIP": 8626190583 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Curbs,Dog Park,Park,Rural,Street Lights,Sidewalks" +"ContractStatusChangeDate": "2025-06-12" +"Cooling": "Central Air,Whole House Fan" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Stanislaus" +"CreationDate": "2025-03-08T02:14:19.401884+00:00" +"CumulativeDaysOnMarket": 112 +"DaysOnMarket": 112 +"DaysOnMarketReplication": 112 +"DaysOnMarketReplicationDate": "2025-06-16" +"Directions": "E Springer to Vintage" +"Electric": "220 Volts in Laundry" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "front" +"ExteriorFeatures": "Misting System" +"FireplaceFeatures": "Family Room,Gas Starter" +"FireplaceYN": true +"Flooring": "Vinyl" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Turlock Unified" +"InteriorFeatures": "Crown Molding,Pantry,Solid Surface Counters,Tandem,Bedroom on Main Level,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room,Upper Level" +"Levels": "Two" +"ListAgentAOR": "Merced County" +"ListAgentDirectPhone": "209-667-2010" +"ListAgentEmail": "rpopolizio@pmz.com" +"ListAgentFax": "209-667-7907" +"ListAgentFirstName": "Robin" +"ListAgentKey": "17143115" +"ListAgentKeyNumeric": "17143115" +"ListAgentLastName": "Popolizio" +"ListAgentOfficePhone": "209-667-2010" +"ListAgentStateLicense": "01943091" +"ListOfficeAOR": "Merced County" +"ListOfficeEmail": "shackett@pmz.com" +"ListOfficeFax": "209-667-7907" +"ListOfficeKey": "3278082" +"ListOfficeKeyNumeric": "3278082" +"ListOfficePhone": "209-667-2010" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-01-30" +"ListingKeyNumeric": 1103837937 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,Cal Vet Loan,Submit,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Front Yard,Sprinklers In Rear,Sprinklers In Front,Landscaped,Street Level" +"LotSizeAcres": 0.1987 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8656.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-15T21:51:50Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-06-12" +"OffMarketTimestamp": "2025-06-15T21:51:50Z" +"OnMarketDate": "2025-02-20" +"OnMarketTimestamp": "2025-02-20T00:31:09Z" +"OriginalEntryTimestamp": "2025-01-30T14:03:32Z" +"OriginalListPrice": 865000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "373877612" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "071062023000" +"ParkingFeatures": "Door-Multi,Garage Faces Front,Garage,Tandem" +"ParkingTotal": "3.0" +"PatioAndPorchFeatures": "Covered, Open, Patio" +"PhotosChangeTimestamp": "2025-06-05T00:10:42Z" +"PhotosCount": 75 +"PoolFeatures": "Gunite, Private" +"PoolPrivateYN": true +"PostalCodePlus4": "7332" +"PreviousListPrice": 799900.0 +"PriceChangeTimestamp": "2025-04-23T09:30:00Z" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-12" +"RoomType": "Bonus Room,Bedroom,Entry/Foyer,Family Room,Primary Bedroom,Other" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent,See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1103837937" +"SpaFeatures": "Above Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-02-20" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-15T21:51:50Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Vintage" +"StreetNumber": "223" +"StreetNumberNumeric": "223" +"StreetSuffix": "Drive" +"StructureType": "House" +"TaxLot": "309" +"UniversalPropertyId": "US-06099-N-071062023000-R-N" +"View": "Neighborhood" +"ViewYN": true +"VirtualTourURLBranded": "https://link.edgepilot.com/s/1c156e88/cr X30Sq WKEaq3IAJb5xkm A?u=https://my.matterport.com/show/?m=d Ak DAKGmch Q" +"VirtualTourURLUnbranded": "https://link.edgepilot.com/s/86f32224/2Kc Lv IAc3k Scs Y8fl QArvg?u=https://my.matterport.com/show/?m=d Ak DAKGmch Q%26mls=1" +"WaterSource": "Public" +"YearBuiltSource": "Appraiser" +"CustomFields": """ {\n "RoomType": "Bonus Room,Formal Entry,Main Floor Bedroom,Primary Suite,Separate Family Room,Walk-In Closet",\n "RoomKitchenFeatures": "Butler\u0027s Pantry,Corian Counters,Kitchen Island,Kitchen Open to Family Room,Walk-In Pantry",\n "RoomBathroomFeatures": "Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1103837937",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1103837937')" +"CurrentPrice": 775000.0 +"provider_name": "CRMLS" +"RecordSignature": -524795898 +"UniversalParcelId": "urn:reso:upi:2.0:US:06099:071062023000" +"CountrySubdivision": "06099" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "109854" +"OriginatingSystemListAgentMemberKey": "6391504" +"Media": array:75 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] …58 ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117012261" +"ListingId": "SR25128780" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T00:22:06Z" +"RFModificationTimestamp": "2025-06-16T00:24:39.899198+00:00" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 27939.0 +"LivingArea": 1847.0 +"BuildingAreaTotal": 0 +"City": "Canyon Country" +"PostalCode": "91351" +"UnparsedAddress": "20439 Kesley Street, Canyon Country, California 91351" +"Coordinates": array:2 [ …2] +"Latitude": 34.436108 +"Longitude": -118.492865 +"YearBuilt": 1988 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ron Tanzman" +"ListOfficeName": "Rodeo Realty" +"ListAgentMlsId": "F207011972" +"ListOfficeMlsId": "F2918005" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "OPEN HOUSE THIS WEEKEND, Sat 11am-3pm and Sun 1pm-4pm!!! Welcome to a spectacular 4-bedroom, 3-bathroom home nestled in the hills of Santa Clarita, offering expansive 180-degree views and a private end of a cul-de-sac lot that brings peace and space together. Truly a one-of- a kind home situated on a large over ½ acre lot! Best of all, there is no Mello-Roos or homeowner association fees to worry about! This home features a dramatic two-story entry, rich wood flooring throughout, and newer-style double-pane windows that flood the interior with natural light. The living room invites comfort with a cozy fireplace, and the home offers both formal and informal dining areas—perfect for dinner parties or casual nights in. The primary bedroom retreat provides a private sanctuary, accompanied by thoughtfully designed bathrooms with a soaking tub, walk-in shower and double sinks that combine functionality and style. The gourmet kitchen offers top of the line appliances including a French Door refrigerator, custom cabinetry, granite counter tops and more! You’ll appreciate the array of modern conveniences—from a newer HVAC system, roof, and water heater, to a money saving solar energy system and water-conserving fixtures. Storage is no issue here, with ample closet space, a spacious wine or storage area, and a finished garage complete with epoxy flooring and even more storage options. Step outside into your backyard oasis, complete with an oversized patio cover, misting system to beat the heat and a scenic perch to take in the gorgeous sunsets over your western mountain views. There’s room to park 10+ cars—yes, 10—including space for an oversized RV. Security features such as cameras and a state of the art security system for peace of mind are also included. Located minutes from Canyon High School, Golden Valley Dog Park, and major train access on Via Princessa, this home combines tranquility with convenience. Grocery and restaurant runs are a breeze with many options just around the corner. Whether you're entertaining or relaxing, this home fits the bill—with room to spare." +"Appliances": "Dishwasher,Free-Standing Range,Disposal,Gas Oven,Refrigerator,Self Cleaning Oven,Water Heater" +"ArchitecturalStyle": "Traditional" +"AttachedGarageYN": true +"AttributionContact": "818-489-2664" +"BathroomsFull": 2 +"CLIP": 9330660607 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Foothills,Hiking,Storm Drain(s),Street Lights,Sidewalks" +"ConstructionMaterials": "Frame,Stucco,Copper Plumbing" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-06-11T23:14:35.582104+00:00" +"CumulativeDaysOnMarket": 4 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 4 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Golden Valley to Ermine to Kesley" +"DoorFeatures": "Mirrored Closet Door(s),Sliding Doors" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Misting System" +"Fencing": "Block,Wrought Iron" +"FireplaceFeatures": "Gas,Living Room,See Remarks,Wood Burning" +"FireplaceYN": true +"Flooring": "Tile, Wood" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Forced Air" +"HeatingYN": true +"HighSchoolDistrict": "William S. Hart Union" +"InteriorFeatures": "Built-in Features,Block Walls,Ceiling Fan(s),Cathedral Ceiling(s),Separate/Formal Dining Room,Granite Counters,High Ceilings,Recessed Lighting,See Remarks,Storage,All Bedrooms Up,Entrance Foyer,Primary Suite,Wine Cellar,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Gas Dryer Hookup,Inside,Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Southland" +"ListAgentDirectPhone": "818-880-9100" +"ListAgentEmail": "ron@rontanzman.com" +"ListAgentFax": "818-880-8883" +"ListAgentFirstName": "Ron" +"ListAgentKey": "17165719" +"ListAgentKeyNumeric": "17165719" +"ListAgentLastName": "Tanzman" +"ListAgentOfficePhone": "818-222-7707" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01292685" +"ListAgentURL": "www.rontanzman.com" +"ListOfficeAOR": "Southland" +"ListOfficeEmail": "officeadministratorclb@rodeore.com" +"ListOfficeFax": "818-222-7872" +"ListOfficeKey": "3284584" +"ListOfficeKeyNumeric": "3284584" +"ListOfficePhone": "818-222-7707" +"ListOfficePhoneExt": "0" +"ListOfficeURL": "www.rodeore.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-11" +"ListingKeyNumeric": 1117012261 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,FHA,Fannie Mae,Freddie Mac,Submit,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Back Yard,Cul-De-Sac,Front Yard,Sprinklers In Front,Lawn,Landscaped,Secluded,Sprinkler System,Street Level" +"LotSizeAcres": 0.6414 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 27939.0 +"MLSAreaMajor": "CAN1 - Canyon Country 1" +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-06-11T14:48:11Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-11" +"OnMarketTimestamp": "2025-06-11T14:48:11Z" +"OriginalEntryTimestamp": "2025-06-11T14:48:11Z" +"OriginalListPrice": 899900.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374567618" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "2801025146" +"ParkingFeatures": "Concrete,Direct Access,Driveway,Garage Faces Front,Garage,RV Access/Parking,See Remarks" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete,Covered,Front Porch,Lanai,Patio" +"PhotosChangeTimestamp": "2025-06-13T20:28:47Z" +"PhotosCount": 40 +"PoolFeatures": "None" +"Possession": "Close Plus 2 Days" +"PostalCodePlus4": "1074" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Tile" +"RoomType": "Bedroom,Den,Family Room,Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office,Other,Wine Cellar,Dining Room" +"SecurityFeatures": "Security System,Closed Circuit Camera(s),Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Ron Tanzman" +"ShowingContactPhone": "818.880.9100" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117012261" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T14:48:11Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Kesley" +"StreetNumber": "20439" +"StreetNumberNumeric": "20439" +"StreetSuffix": "Street" +"StructureType": "House" +"SubdivisionName": "American Beauty Highlands (AMBH)" +"TaxLot": "42" +"UniversalPropertyId": "US-06037-N-2801025146-R-N" +"Utilities": "Electricity Connected,Natural Gas Connected,Sewer Connected,Water Connected" +"View": "Canyon, Hills, Neighborhood, Panoramic" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=g X6Dr JRv K4o" +"VirtualTourURLUnbranded2": "https://vimeo.com/1092638882?share=copy" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,Screens" +"YearBuiltSource": "Assessor" +"Zoning": "SCNU5" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Den,Family Room,Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Suite,Office,See Remarks,Walk-In Closet,Wine Cellar",\n "EatingArea": "Area,Dining Room,Separated,See Remarks",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Open to Family Room,Pots \u0026 Pan Drawers,Remodeled Kitchen,Self-closing cabinet doors,Self-closing drawers",\n "RoomBathroomFeatures": "Bathtub,Low Flow Toilet(s),Shower,Double Sinks in Primary Bath,Exhaust fan(s),Granite Counters,Remodeled,Separate tub and shower,Soaking Tub,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1117012261",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117012261')" +"CurrentPrice": 899900.0 +"provider_name": "CRMLS" +"RecordSignature": -92146925 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:2801025146" +"CountrySubdivision": "06037" +"OriginatingSystemListOfficeKey": "29999" +"OriginatingSystemListAgentMemberKey": "268652" +"Media": array:40 [ …40] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114517399" +"ListingId": "IG25116415" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T23:03:37Z" +"RFModificationTimestamp": "2025-06-15T00:26:56.373201+00:00" +"ListPrice": 950000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 6970.0 +"LivingArea": 2747.0 +"BuildingAreaTotal": 0 +"City": "Palm Springs" +"PostalCode": "92262" +"UnparsedAddress": "561 Skylar Lane, Palm Springs, California 92262" +"Coordinates": array:2 [ …2] +"Latitude": 33.831546 +"Longitude": -116.501175 +"YearBuilt": 2006 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Carlos Nava" +"ListOfficeName": "Re/Max Time Realty" +"ListAgentMlsId": "EVNAVACAR" +"ListOfficeMlsId": "KRMX10" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Luxury Living in Escena – A Rare Opportunity\r\r\n Discover a unique opportunity to own a move-in ready home in the prestigious, gated Escena Golf Club community in Palm Springs. This stunning standalone residence offers exceptional privacy, breathtaking mountain views, and front-row seats to the sights of planes gracefully landing at the nearby airport — all from your private sundeck.\r\r\n Designed for both comfort and elegance, the home features soaring ceilings, expansive windows, and sleek ceramic tile flooring that fill the space with natural light. The gourmet kitchen is a chef’s dream, equipped with premium stainless steel appliances, custom cabinetry, and a spacious island perfect for entertaining. A loft that could be your home office. A main level master Suite.\r\r\n \r\r\n The open-concept floor plan flows effortlessly from kitchen to living and dining areas, creating an ideal space for modern living. Outside, your own private desert oasis awaits — complete with a sparkling pool, relaxing spa, and cozy gas fire pit, all framed by a low-maintenance, professionally landscaped yard.\r\r\n Living in Escena means more than just a beautiful home — it's an exclusive lifestyle. Just a short walk from your front door, you'll find:\r\r\n * The acclaimed Escena Clubhouse Bar & Grill – perfect for brunch, dinner, or sunset cocktails\r\r\n * The 18-hole Nicklaus Design Golf Course and Pro Shop\r\r\n * Scenic walking paths and a dedicated dog park\r\r\n * Easy access to the CV Link Trail\r\r\n All this comes with low HOA dues ($240/month) and Fee Simple land – no land lease required.\r\r\n This is more than a home – it’s a retreat, a statement, and a gateway to elevated desert living. Don’t miss your chance to own in one of Palm Springs’ most coveted communities. """ +"ActivationDate": "2025-05-25" +"AssociationAmenities": "Clubhouse,Dog Park,Other" +"AssociationFee": "240.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "associate desert" +"AssociationPhone": "7603461161" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "909-782-2803" +"BathroomsFull": 2 +"CLIP": 2401305854 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Dog Park,Golf,Street Lights,Sidewalks" +"Contingency": "NONE" +"ContractStatusChangeDate": "2025-05-24" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-26T03:37:17.708756+00:00" +"CumulativeDaysOnMarket": 20 +"DaysOnMarket": 21 +"DaysOnMarketReplication": 20 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "from HGWY 111 heading south Turn left on Escena At the traffic circle, take the 2nd exit onto Grandview St Then a right on Skylar" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Misting System" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Palm Springs Unified" +"InteriorFeatures": "Bedroom on Main Level,Jack and Jill Bath,Loft,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "The Inland Gateway" +"ListAgentEmail": "navarealty1@gmail.com" +"ListAgentFirstName": "Carlos" +"ListAgentKey": "17317538" +"ListAgentKeyNumeric": "17317538" +"ListAgentLastName": "Nava" +"ListAgentOfficePhone": "909-373-0880" +"ListAgentStateLicense": "01345553" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "The Inland Gateway" +"ListOfficeEmail": "joelle@remaxtime.net" +"ListOfficeFax": "909-373-0818" +"ListOfficeKey": "3268955" +"ListOfficeKeyNumeric": "3268955" +"ListOfficePhone": "909-373-0880" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-24" +"ListingKeyNumeric": 1114517399 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,Contract" +"LivingAreaSource": "Assessor" +"LotFeatures": "Close to Clubhouse,Front Yard,Garden,Street Level" +"LotSizeAcres": 0.16 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6970.0 +"MLSAreaMajor": "332 - Central Palm Springs" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-05-25T20:17:40Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-25" +"OnMarketTimestamp": "2025-05-25T20:17:40Z" +"OriginalEntryTimestamp": "2025-05-24T15:36:08Z" +"OriginalListPrice": 950000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374469756" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "677660068" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-24T23:29:40Z" +"PhotosCount": 16 +"PoolFeatures": "Gas Heat,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "0561" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bathroom,Bedroom,Family Room,Kitchen,Laundry,Loft,Living Room,Primary Bedroom,Other" +"Sewer": "Public Sewer" +"ShowingContactName": "Carlos Nava" +"ShowingContactPhone": "9097822803" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114517399" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-05-25" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-25T20:17:40Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Skylar" +"StreetNumber": "561" +"StreetNumberNumeric": "561" +"StreetSuffix": "Lane" +"StructureType": "House" +"SubdivisionName": "Escena (33274)" +"TaxLot": "139" +"UniversalPropertyId": "US-06065-N-677660068-R-N" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Family Room,Jack \u0026 Jill,Kitchen,Laundry,Living Room,Loft,Main Floor Bedroom,Primary Bedroom,Primary Suite,Walk-In Closet",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1114517399",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114517399')" +"CurrentPrice": 950000.0 +"provider_name": "CRMLS" +"RecordSignature": 112729497 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:677660068" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Coming Soon" +"OriginatingSystemListOfficeKey": "115512" +"OriginatingSystemListAgentMemberKey": "175477" +"Media": array:16 [ …16] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111822021" +"ListingId": "IG25083576" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T17:40:55Z" +"RFModificationTimestamp": "2025-06-14T02:18:58.387067+00:00" +"ListPrice": 539990.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7878.0 +"LivingArea": 1877.0 +"BuildingAreaTotal": 0 +"City": "Yucaipa" +"PostalCode": "92399" +"UnparsedAddress": "34868 Damascus Street, Yucaipa, California 92399" +"Coordinates": array:2 [ …2] +"Latitude": 34.011316 +"Longitude": -117.043577 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "TIFFANY MELLON NAASZ" +"ListOfficeName": "KELLER WILLIAMS REALTY" +"ListAgentMlsId": "L100999" +"ListOfficeMlsId": "E1902" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Welcome to this charming single-story retreat tucked away on a quiet cul-de-sac in the heart of Yucaipa—offering peaceful living, gorgeous views, and thoughtfully upgraded spaces throughout. This 3-bedroom, 2-bathroom home spans 1,877 sq. ft. and sits on a beautifully landscaped lot designed for both relaxation and entertaining.\r\r\n \r\r\n As you step inside, upgraded tile and laminate plank flooring flow seamlessly throughout the home, setting the tone with warmth and style. The living room centers around a cozy wood-burning fireplace, creating the perfect spot for movie nights or quiet evenings. The remodeled kitchen is a dream—featuring stunning granite countertops, stainless steel appliances, and ample cabinetry.\r\r\n \r\r\n Enjoy direct access to the backyard through elegant double doors from both the living room and a secondary bedroom, blending indoor and outdoor living. Step into the enclosed patio, a tranquil space to enjoy your morning coffee while soaking in the views and fresh air.\r\r\n \r\r\n Designed with relaxation in mind, a spa-like retreat with a Jacuzzi soaking tub, walk-in shower, and a bidet, while both bathrooms have been tastefully updated. Major systems have been thoughtfully upgraded, including newer plumbing, a Culligan whole-house water softener and filtration system, newer dual-pane windows, a recently replaced water heater, and upgraded AC, furnace, and pool equipment. The roof was replaced within the last five years, ensuring long-term peace of mind.\r\r\n \r\r\n Step outside to your personal oasis. The private in-ground pool and spa are surrounded by new vinyl fencing and a misting system, perfect for warm summer days. The backyard also features mature lemon trees, a shed with electrical, and a screened patio—ideal for a home gym, art studio, or additional lounge space.\r\r\n \r\r\n The long driveway provides ample parking, including RV space, and the home is equipped with leased solar panels to help keep energy costs low.\r\r\n \r\r\n This home offers comfort, functionality, and the lifestyle you’ve been waiting for. Don’t miss your chance to own this move-in ready treasure in Yucaipa—schedule your private tour today! """ +"ActivationDate": "2025-04-26" +"Appliances": "Dishwasher, Microwave" +"ArchitecturalStyle": "Modern" +"AttributionContact": "951-377-1914" +"BathroomsFull": 2 +"CLIP": 2316410389 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs" +"ConstructionMaterials": "Frame, Stucco" +"ContractStatusChangeDate": "2025-04-15" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-26T13:00:01.696880+00:00" +"CumulativeDaysOnMarket": 48 +"DaysOnMarket": 51 +"DaysOnMarketReplication": 48 +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From I-10 exit County Line; go east on County Line; left on 3rd; right on Avenue H; left on 2nd, right on Damascus Cross Streets: Avenue H and 2nd Street" +"DoorFeatures": "French Doors" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Misting System" +"Fencing": "Vinyl" +"FireplaceFeatures": "Living Room,Wood Burning" +"FireplaceYN": true +"Flooring": "Laminate, Tile" +"FoundationDetails": "Slab" +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Yucaipa/Calimesa Unified" +"InteriorFeatures": "Ceiling Fan(s),Eat-in Kitchen,Granite Counters,All Bedrooms Down,Bedroom on Main Level,Main Level Primary,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "The Inland Gateway" +"ListAgentEmail": "tiffany@tiffanyandcorealty.com" +"ListAgentFirstName": "TIFFANY" +"ListAgentKey": "16916579" +"ListAgentKeyNumeric": "16916579" +"ListAgentLastName": "MELLON NAASZ" +"ListAgentOfficePhone": "909-793-2100" +"ListAgentStateLicense": "01710767" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "The Inland Gateway" +"ListOfficeEmail": "heath.hilgenberg@gmail.com" +"ListOfficeFax": "909-793-8200" +"ListOfficeKey": "3288141" +"ListOfficeKeyNumeric": "3288141" +"ListOfficePhone": "909-793-2100" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-15" +"ListingKeyNumeric": 1111822021 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Cul-De-Sac,Landscaped,Sprinkler System" +"LotSizeAcres": 0.1809 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7878.0 +"MLSAreaMajor": "269 - Yucaipa/Calimesa/Oak Glen" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-13T10:16:31Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-04-26" +"OnMarketTimestamp": "2025-04-26T00:30:51Z" +"OriginalEntryTimestamp": "2025-04-16T12:02:38Z" +"OriginalListPrice": 539990.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374251847" +"OriginatingSystemSubName": "CRMLS_CRM" +"OtherStructures": "Shed(s)" +"ParcelNumber": "0319401020000" +"ParkingFeatures": "Driveway,RV Access/Parking" +"PatioAndPorchFeatures": "Covered, Patio, Porch, Screened" +"PhotosChangeTimestamp": "2025-04-26T18:39:40Z" +"PhotosCount": 39 +"PoolFeatures": "In Ground,Private" +"PoolPrivateYN": true +"PostalCodePlus4": "5002" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom,Entry/Foyer,Family Room,Kitchen,Living Room,Primary Bathroom,Primary Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111822021" +"SpaFeatures": "In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-04-26" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T10:16:31Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Damascus" +"StreetNumber": "34868" +"StreetNumberNumeric": "34868" +"StreetSuffix": "Street" +"StructureType": "House" +"TaxLot": "5" +"UniversalPropertyId": "US-06071-N-0319401020000-R-N" +"View": "Mountain(s), Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"Zoning": "R" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Entry,Family Room,Kitchen,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom,Primary Suite",\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Granite Counters",\n "RoomBathroomFeatures": "Bathtub,Bidet,Shower,Granite Counters,Jetted Tub,Main Floor Full Bath,Soaking Tub",\n "AdminUpdateYN": "0",\n "ListingKey": "1111822021",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111822021')" +"CurrentPrice": 539990.0 +"provider_name": "CRMLS" +"RecordSignature": 125582641 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0319401020000" +"CountrySubdivision": "06071" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "106969" +"OriginatingSystemListAgentMemberKey": "175271" +"Media": array:39 [ …39] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112556891" +"ListingId": "TR25098525" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-12T18:43:17Z" +"RFModificationTimestamp": "2025-06-13T11:18:46.297892+00:00" +"ListPrice": 1699000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 12632.0 +"LivingArea": 2967.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "54780 Madagascar Way, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.65121 +"Longitude": -116.23955 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd Chiriano" +"ListOfficeName": "American Federal Properties" +"ListAgentMlsId": "H66317" +"ListOfficeMlsId": "8345" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Introducing, this truly gorgeous, upgraded Estate Style Home in prestigious Griffin Ranch guarded gate community. This south facing home sits on a large corner lot with a beautiful huge, park like area on two sides and a very private back yard. There is only one contiguous neighbor to the west. The Sellers purchased the home, preconstruction, in 2019, and had the Builder upgrade and/or add many amenities during construction, such as, a saltwater swimming pool and spa with tanning shelf, ambient lighting and tranquil waterfalls, a large covered patio in the pool area, ceiling fans, a built in barbeque with misters, gas firepit, and a putting green. The Sellers just installed all new upgraded Landscaping. A brand new Whole Home water filtration system was just added, a $7,500 Valve. There's a two car garage + a golf cart garage (the Sellers Golf Cart and charger may be negotiated in sale) Custom Epoxy floors in all garage spaces with built in custom storage cabinets. The unique open floor plan with the Living Room/Great Room having high ceilings, a Grand Fireplace and 10 foot sliding glass doors that open into the pool area, Also, a Formal Dining Room, a spacious separate Office and Laundry Room with sink, upper and lower cabinets and clothes folding area. The Master Bedroom has a modern en suite Bathroom with Soaking tub and large Walk in closet. The other bedrooms each have their own private Bath and the home has a 4th guest Bathroom. The oversized Office can be used as a 4th Bedroom. The Gourmet kitchen includes a large prep Island with Granite Counter Tops and Backsplash, an Eating area, a 6 burner Stovetop with dual Ovens and state of the art Stainless Steel Thermador Appliances and a large walk in Pantry. Included is an additional Refrigerator in the garage and rear patio, along with the Three + Big Screen TV's that are included in the sale. A Custom sound speaker system in the Living Room/Great room, Master Bedroom, Office, and Back and Front Patios that can be controlled individually. There is a existing ADT Security System on the premise that the new Owners can contact ADT if they wish to reactivate the system. H.O.A amenities include: State of the Art Clubhouse w/Pool, Spa and Fitness Center, Pilates & Yoga Studio, Ping pong & billiards room, Tennis, Bocce and Pickle ball courts, Putting Green, Dog Park, Community special events and more. The property is close to world renowned Golf at PGA West, PGA Gregg Norman and Silver Rock Communities." +"Appliances": "6 Burner Stove,Built-In Range,Barbecue,Double Oven,Dishwasher,ENERGY STAR Qualified Appliances,ENERGY STAR Qualified Water Heater,Freezer,Gas Cooktop,Disposal,Ice Maker,Microwave,Tankless Water Heater,Water Heater" +"AssociationAmenities": "Bocce Court,Billiard Room,Clubhouse,Dog Park,Fitness Center,Fire Pit,Golf Course,Game Room,Meeting/Banquet/Party Room,Outdoor Cooking Area,Barbecue,Picnic Area,Pickleball,Pool,Guard,Spa/Hot Tub,Security,Cable TV" +"AssociationFee": "575.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Griffin Ranch Home Owners Association" +"AssociationPhone": "7605648563" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "909-732-9994" +"BackOnMarketDate": "2025-06-09" +"BathroomsFull": 3 +"CLIP": 7001812069 +"CommonInterest": "None" +"CommonWalls": "1 Common Wall" +"CommunityFeatures": "Golf,Storm Drain(s),Sidewalks" +"ContractStatusChangeDate": "2025-05-03" +"Cooling": "Central Air,Dual,ENERGY STAR Qualified Equipment" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-06-09T21:27:38.905139+00:00" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 26 +"DaysOnMarketReplication": 22 +"DaysOnMarketReplicationDate": "2025-06-12" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "South" +"Directions": "From Intersection of Avenue 54 & Madison St: Go South on Madison St 2 10ths of a mile, turn left into Guard Gate Entrance, Continue on Merv Griffin Way, Turn right onto Northern Dancer Dr., Turn Left on Madagascar Way. Third Residence on the left." +"Electric": "220 Volts in Garage,220 Volts For Spa" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front Entrance" +"Exclusions": "Washer and Dryer" +"ExteriorFeatures": "Misting System" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Tile" +"GarageSpaces": "2.5" +"GarageYN": true +"GreenEnergyEfficient": "Appliances,Water Heater" +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Desert Sands Unified" +"Inclusions": "3 Big Screen TV's, 2 Extra Refrigerator one in the garage and one on the back patio, new whole home water filtration system." +"InteriorFeatures": "Ceiling Fan(s),Eat-in Kitchen,High Ceilings,Open Floorplan,Pantry,Recessed Lighting,Wired for Data,Wired for Sound,All Bedrooms Down,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "Tri-Counties" +"ListAgentDirectPhone": "909-861-1000" +"ListAgentEmail": "amfedprops@gmail.com" +"ListAgentFirstName": "Todd" +"ListAgentKey": "17009056" +"ListAgentKeyNumeric": "17009056" +"ListAgentLastName": "Chiriano" +"ListAgentOfficePhone": "909-861-1000" +"ListAgentStateLicense": "00699127" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Tri-Counties" +"ListOfficeKey": "3257908" +"ListOfficeKeyNumeric": "3257908" +"ListOfficePhone": "909-861-1000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-03" +"ListingKeyNumeric": 1112556891 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Corner Lot,Landscaped,Level,Rectangular Lot,Sprinkler System" +"LotSizeAcres": 0.29 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 12632.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MainLevelBathrooms": 4 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-09T12:56:17Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-05-24" +"OffMarketTimestamp": "2025-05-24T09:37:59Z" +"OnMarketDate": "2025-05-03" +"OnMarketTimestamp": "2025-06-09T12:56:17Z" +"OriginalEntryTimestamp": "2025-05-03T15:25:40Z" +"OriginalListPrice": 1699000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374353100" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "780160048" +"ParkingFeatures": "Concrete,Direct Access,Driveway,Garage Faces Front,Garage" +"ParkingTotal": "2.5" +"PhotosChangeTimestamp": "2025-05-04T00:01:41Z" +"PhotosCount": 31 +"PoolFeatures": "In Ground,Private,Salt Water,Waterfall,Association" +"PoolPrivateYN": true +"PostalCodePlus4": "8076" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Tile" +"RoomType": "Bedroom,Entry/Foyer,Great Room,Kitchen,Laundry,Primary Bedroom,Office,Other" +"SecurityFeatures": "Gated with Attendant,24 Hour Security" +"Sewer": "Public Sewer" +"ShowingContactName": "Todd Chiriano" +"ShowingContactPhone": "(909) 732-9994" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112556891" +"SpaFeatures": "Gunite,Heated,In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-09T12:56:17Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Madagascar" +"StreetNumber": "54780" +"StreetNumberNumeric": "54780" +"StreetSuffix": "Way" +"StructureType": "House" +"SubdivisionName": "Griffin Ranch (31314)" +"TaxLot": "152" +"UniversalPropertyId": "US-06065-N-780160048-R-N" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,ENERGY STAR Qualified Windows" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Formal Entry,Great Room,Kitchen,Laundry,Primary Suite,Office,Walk-In Closet",\n "EatingArea": "In Kitchen",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island,Walk-In Pantry",\n "RoomBathroomFeatures": "Bathtub,Low Flow Shower,Closet in bathroom,Double Sinks in Primary Bath,Granite Counters,Linen Closet/Storage,Soaking Tub,Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112556891",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112556891')" +"CurrentPrice": 1699000.0 +"provider_name": "CRMLS" +"RecordSignature": -1856749669 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:780160048" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "262" +"OriginatingSystemListAgentMemberKey": "144294" +"Media": array:31 [ …31] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112530048" +"ListingId": "IG25096140" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-11T15:21:13Z" +"RFModificationTimestamp": "2025-06-11T16:12:36.606991+00:00" +"ListPrice": 870000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 10890.0 +"LivingArea": 2150.0 +"BuildingAreaTotal": 0 +"City": "Corona" +"PostalCode": "92882" +"UnparsedAddress": "2010 Oakland Hills Drive, Corona, California 92882" +"Coordinates": array:2 [ …2] +"Latitude": 33.875079 +"Longitude": -117.608981 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Janet Hawkins" +"ListOfficeName": "Coldwell Banker Assoc Brokers" +"ListAgentMlsId": "KHAWKJAN" +"ListOfficeMlsId": "IGCBA02" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Orange County close is this upgraded and updated POOL home in West Corona. Double door entry leads you into this 4 bedroom and 2 bath home in almost 2200 sq ft. Spacious kitchen with stainless steel appliances, granite counter tops, walk-in pantry, travertine flooring and a seating counter. Very generous dining/eating area open to the kitchen and family room and has an amazing view of the hills and mountains. There is a main floor primary bedroom with a full bath. There is also a first-floor bonus room that could be used for an office, craft or home school room and has a door to the backyard. Family room with wood burning fireplace and hardwood floors. Upstairs are three more spacious bedrooms and a full upgraded bathroom with porcelain tile. And now for the backyard which is an entertainer's dream. Sparkling pool and spa, generous patio area with patio cover and lights, greenhouse, orange, peach and lemon trees, and a beautiful view of the local mountains. And the new owners ~ just move right in! No HOA, no mello roos. Well established neighborhood and close to shopping, schools, and restaurants." +"Appliances": "Convection Oven,Dishwasher,ENERGY STAR Qualified Water Heater,Disposal,Gas Oven,Gas Range,Gas Water Heater,High Efficiency Water Heater,Microwave,Refrigerator,Water Softener,Tankless Water Heater,Vented Exhaust Fan,Water To Refrigerator,Water Heater,Dryer,Washer" +"ArchitecturalStyle": "Mid-Century Modern" +"AssociationName": "None" +"AttachedGarageYN": true +"AttributionContact": "951-284-9196" +"BathroomsFull": 2 +"CLIP": 2746097316 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Hiking,Storm Drain(s)" +"ConstructionMaterials": "Stucco,Copper Plumbing" +"ContractStatusChangeDate": "2025-06-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-02T22:39:22.194347+00:00" +"CumulativeDaysOnMarket": 40 +"DaysOnMarket": 40 +"DaysOnMarketReplication": 40 +"DaysOnMarketReplicationDate": "2025-06-11" +"DirectionFaces": "East" +"Directions": "Paseo Grande and Via Del Rio" +"DocumentsChangeTimestamp": "2025-05-05T14:29:26Z" +"DocumentsCount": 1 +"DoorFeatures": "Double Door Entry,Sliding Doors" +"Electric": "220 Volts in Garage" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front door" +"ExteriorFeatures": "Misting System" +"Fencing": "Good Condition,Vinyl" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Tile, Wood" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"GreenEnergyEfficient": "Water Heater" +"Heating": "Central,Forced Air,Fireplace(s),High Efficiency" +"HeatingYN": true +"HighSchoolDistrict": "Corona-Norco Unified" +"InteriorFeatures": "Ceiling Fan(s),Separate/Formal Dining Room,Eat-in Kitchen,Granite Counters,Open Floorplan,Pantry,Storage,Instant Hot Water,Main Level Primary,Walk-In Pantry" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Gas Dryer Hookup,In Garage" +"Levels": "Two" +"ListAgentAOR": "The Inland Gateway" +"ListAgentEmail": "CJSHAWKINS@AOL.COM" +"ListAgentFax": "951-277-0780" +"ListAgentFirstName": "Janet" +"ListAgentKey": "17049762" +"ListAgentKeyNumeric": "17049762" +"ListAgentLastName": "Hawkins" +"ListAgentOfficePhone": "951-244-1867" +"ListAgentStateLicense": "01835692" +"ListOfficeAOR": "The Inland Gateway" +"ListOfficeEmail": "magmccoy@coldwellbankerab.com" +"ListOfficeFax": "951-244-5306" +"ListOfficeKey": "3289057" +"ListOfficeKeyNumeric": "3289057" +"ListOfficePhone": "951-244-1867" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-01" +"ListingKeyNumeric": 1112530048 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Back Yard,Drip Irrigation/Bubblers,Front Yard,Garden,Landscaped,Level,Sprinklers Timer" +"LotSizeAcres": 0.25 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 10890.0 +"MLSAreaMajor": "248 - Corona" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-11T08:03:52Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-06-11" +"OffMarketTimestamp": "2025-06-11T08:03:52Z" +"OnMarketDate": "2025-05-02" +"OnMarketTimestamp": "2025-05-02T14:06:02Z" +"OriginalEntryTimestamp": "2025-05-02T14:06:02Z" +"OriginalListPrice": 870000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374348035" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "102181019" +"ParkingFeatures": "Concrete,Door-Multi,Direct Access,Driveway,Electric Vehicle Charging Station(s),Garage Faces Front,Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete,Covered,Front Porch,Open,Patio" +"PhotosChangeTimestamp": "2025-05-05T21:43:39Z" +"PhotosCount": 34 +"PoolFeatures": "Fenced,Gunite,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2817" +"PropertyCondition": "Additions/Alterations" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-11" +"RoadFrontageType": "City Street" +"Roof": "Composition,Ridge Vents" +"RoomType": "Bonus Room,Kitchen,Living Room,Primary Bathroom,Primary Bedroom,Pantry,Dining Room" +"SecurityFeatures": "Smoke Detector(s)" +"Sewer": "Septic Tank" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112530048" +"SpaFeatures": "Gunite,Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-11T08:03:52Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Oakland Hills" +"StreetNumber": "2010" +"StreetNumberNumeric": "2010" +"StreetSuffix": "Drive" +"StructureType": "House" +"SubdivisionName": "none" +"TaxLot": "19" +"UniversalPropertyId": "US-06065-N-102181019-R-N" +"Utilities": "Electricity Connected,Sewer Connected,Water Connected" +"View": "Hills, Mountain(s), Neighborhood, Panoramic" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Blinds,Double Pane Windows,Low-Emissivity Windows,Plantation Shutters,Tinted Windows" +"YearBuiltSource": "Assessor" +"Zoning": "R-1" +"CustomFields": """ {\n "RoomType": "Bonus Room,Kitchen,Living Room,Main Floor Primary Bedroom,Primary Bathroom,Walk-In Pantry",\n "EatingArea": "Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Granite Counters,Pots \u0026 Pan Drawers,Walk-In Pantry",\n "RoomBathroomFeatures": "Bathtub,Shower,Double sinks in bath(s),Double Sinks in Primary Bath,Exhaust fan(s),Main Floor Full Bath,Privacy toilet door,Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112530048",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112530048')" +"CurrentPrice": 870000.0 +"provider_name": "CRMLS" +"RecordSignature": 333875416 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:102181019" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "99461354" +"OriginatingSystemListAgentMemberKey": "210088" +"Media": array:34 [ …34] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114761481" +"ListingId": "SR25121859" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-08T19:48:18Z" +"RFModificationTimestamp": "2025-06-08T19:57:17.211964+00:00" +"ListPrice": 898500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 8364.0 +"LivingArea": 2226.0 +"BuildingAreaTotal": 0 +"City": "Pittsburg" +"PostalCode": "94565" +"UnparsedAddress": "21 Fawn Glen Court, Pittsburg, California 94565" +"Coordinates": array:2 [ …2] +"Latitude": 38.006892 +"Longitude": -121.954253 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "William Parsons" +"ListOfficeName": "Parsons Realty" +"ListAgentMlsId": "SR202501198" +"ListOfficeMlsId": "SRF7001478" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Modern Sanctuary at the Edge of Everything. Tucked at the end of a peaceful cul-de-sac backing to open space, this solar-powered stunner blends ultimate privacy with seamless access to both urban energy and rural serenity. Step inside and discover a home designed from the ground up for effortless living—from upgraded, low-maintenance finishes to an energy-efficient footprint that keeps your utility bills jaw-droppingly low. At the heart of it all: a fully owned solar system—not leased—delivering significant long-term savings and true energy independence. Enjoy peace of mind with a whole-home security camera system, upgraded lighting, and a chef-worthy kitchen featuring high-end appliances that combine form and function in style. \r\r\n Eco-Chic Outdoor Living: take a dip in your solar-heated, zero-emission pool—perfect for sunset laps or lazy Sundays. Enjoy poolside dinners year-round under your covered patio. Entertain effortlessly on brand-new backyard pavers and soak in the ideal Mediterranean climate—your own slice of California paradise. The owned solar system powers it all efficiently, so you can enjoy every comfort without compromise. \r\r\n Location that works for you: Minutes to two BART stations (Pittsburg/Bay Point & Pittsburg Center) and quick access to Hwy 4 for easy commutes to Concord, Oakland, or even Sacramento.\r\r\n Surrounded by Nature: Walk the Suisun Bay shoreline, explore Mount Diablo trails, or kayak the Delta waterways—your adventure starts right outside your door.\r\r\n Culture, Cuisine & Community: Spend weekends in Historic Old Town Pittsburg—brewery hopping, boutique browsing, or catching live music under the stars. Enjoy weekly farmers markets, art walks, and seasonal festivals just minutes away. Close to major tech, industrial, and healthcare hubs—a commuter’s dream without the chaos.\r\r\n If you're looking for eco-conscious comfort, designer details, and a lifestyle that balances work, wellness, and weekend vibes—this is the one. """ +"AttachedGarageYN": true +"AttributionContact": "530-222-1818" +"BathroomsFull": 3 +"CLIP": 3158895342 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Mountainous, Sidewalks, Park" +"ContractStatusChangeDate": "2025-06-04" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Contra Costa" +"CreationDate": "2025-05-31T23:36:29.667275+00:00" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 4 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-06-08" +"Directions": "Take San Marco Blvd exit from Highway 4, East onto W Leland Rd, Right onto Woodhill Dr., right onto Fawn Glen Ct. Property at end of cul-de-sac." +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Ground Level" +"ExteriorFeatures": "Misting System" +"FireplaceFeatures": "Family Room,Primary Bedroom" +"FireplaceYN": true +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central, Fireplace(s)" +"HeatingYN": true +"HighSchoolDistrict": "Pittsburg" +"InteriorFeatures": "High Ceilings,Bedroom on Main Level,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Southland" +"ListAgentEmail": "bill@parsonsgroup.com" +"ListAgentFirstName": "William" +"ListAgentKey": "20775993" +"ListAgentKeyNumeric": "20775993" +"ListAgentLastName": "Parsons" +"ListAgentOfficePhone": "530-222-1818" +"ListAgentStateLicense": "01312921" +"ListOfficeAOR": "Southland" +"ListOfficeEmail": "bill@parsonsgroup.com" +"ListOfficeFax": "530-222-1818" +"ListOfficeKey": "4549160" +"ListOfficeKeyNumeric": "4549160" +"ListOfficePhone": "530-222-1818" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-31" +"ListingKeyNumeric": 1114761481 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Cul-De-Sac,Greenbelt,Near Park" +"LotSizeAcres": 0.192 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8364.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-08T12:31:23Z" +"MajorChangeType": "Pending" +"MlsStatus": "Pending" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-06-04" +"OffMarketTimestamp": "2025-06-08T12:31:23Z" +"OnMarketDate": "2025-05-31" +"OnMarketTimestamp": "2025-05-31T15:20:28Z" +"OriginalEntryTimestamp": "2025-05-31T15:20:28Z" +"OriginalListPrice": 898500.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374508361" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "0931400436" +"ParkingFeatures": "Oversized" +"ParkingTotal": "3.0" +"PatioAndPorchFeatures": "Covered" +"PhotosChangeTimestamp": "2025-05-31T23:28:39Z" +"PhotosCount": 19 +"PoolFeatures": "Heated,In Ground,Private" +"PoolPrivateYN": true +"PostalCodePlus4": "7344" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-04" +"RoadSurfaceType": "Paved" +"Roof": "Flat Tile" +"RoomType": "Bedroom,Family Room,Kitchen,Living Room,Primary Bedroom,Other" +"Sewer": "Public Sewer" +"ShowingContactName": "Nolan" +"ShowingContactPhone": "530-227-4596" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114761481" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-08T12:31:23Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Fawn Glen" +"StreetNumber": "21" +"StreetNumberNumeric": "21" +"StreetSuffix": "Court" +"StructureType": "House" +"TaxLot": "59" +"UniversalPropertyId": "US-06013-N-0931400436-R-N" +"View": "Canyon, Park/Greenbelt, Hills, Water" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Family Room,Kitchen,Living Room,Main Floor Bedroom,Primary Suite,Walk-In Closet",\n "RoomBathroomFeatures": "Bathtub",\n "AdminUpdateYN": "0",\n "ListingKey": "1114761481",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114761481')" +"CurrentPrice": 898500.0 +"provider_name": "CRMLS" +"RecordSignature": -1160440340 +"UniversalParcelId": "urn:reso:upi:2.0:US:06013:0931400436" +"CountrySubdivision": "06013" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "368247587" +"OriginatingSystemListAgentMemberKey": "368247643" +"Media": array:19 [ …19] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114891081" +"ListingId": "FR25124881" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-05T18:06:02Z" +"RFModificationTimestamp": "2025-06-05T18:26:28.307681+00:00" +"ListPrice": 639900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7344.0 +"LivingArea": 2508.0 +"BuildingAreaTotal": 0 +"City": "Clovis" +"PostalCode": "93619" +"UnparsedAddress": "3771 Wrenwood Avenue, Clovis, California 93619" +"Coordinates": array:2 [ …2] +"Latitude": 36.819119 +"Longitude": -119.638861 +"YearBuilt": 2015 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jessica Montag" +"ListOfficeName": "My True Realty" +"ListAgentMlsId": "fr19963" +"ListOfficeMlsId": "FR83007" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Meticulous maintained, like-new Bonadelle home in the perfect location! Only a 6 minute bike ride to Red Bank Elementary, 4 minute bike ride to Pasa Teimpo park and a short 3 minute walk to the neighborhood Grove park! The community features beautiful walking and bike trails. It's less than a 5 minute drive to the newest shopping center located on Leonard and Shaw. Forever curb appeal with designer low maintenance rock landscaping with synthetic lawn and in the front and backyard. The backyard is calling for fun and relaxation with a mister system, gazebo, no behind neighbors, and children's play structure. Walk into a grand entry featuring an isolated bedroom and office space in the front of the home flowing seamlessly into the open concept kitchen and living room. The kitchen features granite countertops and stainless steel appliances. Spacious island with seating to prepare your meals or entertain guests. The far end of the home has the remaining bedrooms including an expansive master bedroom, grand bathroom with separate vanities and separate soaking tub and shower with a massive walk in closet. Beautiful LVP flooring and fresh paint in main areas. This home is really turn key and ready for its new owners. And sellers are offering a $5,000 rate buy down credit with a good offer. Call today to schedule a private showing." +"AttachedGarageYN": true +"AttributionContact": "559-940-9564" +"BathroomsFull": 3 +"BathroomsOneQuarter": 1 +"CLIP": 5491075778 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking, Park, Sidewalks" +"Contingency": "none" +"ContractStatusChangeDate": "2025-06-03" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Fresno" +"CreationDate": "2025-06-04T17:52:24.880036+00:00" +"CumulativeDaysOnMarket": 32 +"DaysOnMarket": 12 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-05" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head East on Bullard, turn south on Leonard, right on Robinwood, Right on La Jolla, left on Finchwood, right on Alameda, and the left on Wrenwood, 3771." +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Misting System" +"FireplaceFeatures": "None" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchoolDistrict": "Clovis Unified" +"InteriorFeatures": "All Bedrooms Down,Attic,Bedroom on Main Level,Main Level Primary" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Fresno" +"ListAgentDirectPhone": "559-258-1004" +"ListAgentEmail": "Jessica@My True Realty.com" +"ListAgentFirstName": "Jessica" +"ListAgentKey": "17133194" +"ListAgentKeyNumeric": "17133194" +"ListAgentLastName": "Montag" +"ListAgentOfficePhone": "559-258-1004" +"ListAgentStateLicense": "01941561" +"ListAgentURL": "My True Realty.com" +"ListOfficeAOR": "Fresno" +"ListOfficeEmail": "Jessica@mytruerealty.com" +"ListOfficeKey": "3294253" +"ListOfficeKeyNumeric": "3294253" +"ListOfficePhone": "559-258-1004" +"ListOfficeURL": "My True Realty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-03" +"ListingKeyNumeric": 1114891081 +"ListingService": "Full Service" +"ListingTerms": "Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Rectangular Lot,Rocks" +"LotSizeAcres": 0.1686 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7344.0 +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-05T10:46:58Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-04" +"OnMarketTimestamp": "2025-06-04T09:54:39Z" +"OriginalEntryTimestamp": "2025-06-04T09:54:39Z" +"OriginalListPrice": 649000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374524117" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "55436059" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-04T17:35:39Z" +"PhotosCount": 39 +"PoolFeatures": "None" +"PostalCodePlus4": "8965" +"PreviousListPrice": 649000.0 +"PriceChangeTimestamp": "2025-06-05T10:46:58Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Attic,Bonus Room,Bedroom,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom" +"Sewer": "Public Sewer" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114891081" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-04T09:54:39Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Wrenwood" +"StreetNumber": "3771" +"StreetNumberNumeric": "3771" +"StreetSuffix": "Avenue" +"StructureType": "House" +"TaxLot": "148" +"UniversalPropertyId": "US-06019-N-55436059-R-N" +"View": "None" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Attic,Bonus Room,Kitchen,Laundry,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom",\n "AdminUpdateYN": "0",\n "ListingKey": "1114891081",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114891081')" +"CurrentPrice": 639900.0 +"provider_name": "CRMLS" +"RecordSignature": 457250313 +"UniversalParcelId": "urn:reso:upi:2.0:US:06019:55436059" +"CountrySubdivision": "06019" +"OriginatingSystemListOfficeKey": "364242222" +"OriginatingSystemListAgentMemberKey": "117484850" +"Media": array:39 [ …39] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112530973" +"ListingId": "SW25095137" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-04T18:28:02Z" +"RFModificationTimestamp": "2025-06-04T18:56:45.122202+00:00" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 20473.0 +"LivingArea": 5051.0 +"BuildingAreaTotal": 0 +"City": "Rancho Mirage" +"PostalCode": "92270" +"UnparsedAddress": "10 Yorkshire Court, Rancho Mirage, California 92270" +"Coordinates": array:2 [ …2] +"Latitude": 33.792404 +"Longitude": -116.410892 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Miquella Zulfiqar" +"ListOfficeName": "Realty One Group Pacific" +"ListAgentMlsId": "SWZULFMIQ" +"ListOfficeMlsId": "SWROGP" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 10 Yorkshire Court, an exceptional opportunity in the heart of Rancho Mirage. Nestled within the exclusive gated community of Victoria Falls, this well-maintained residence offers a blend of comfort, space, and potential. The home features a private pool and hot tub, perfect for enjoying the desert lifestyle year-round, while multiple misting systems keep outdoor areas cool and inviting even on the warmest days. Designed for both entertaining and everyday living, the property includes indoor and outdoor bar areas ideal for hosting gatherings or relaxing in style. Inside, you'll find generous living spaces supported by three separate air conditioning units, ensuring year-round comfort throughout the home. With solid bones and thoughtful features already in place, this property is ready for someone to update and transform it into their dream desert retreat. Whether you're seeking a serene escape or a vibrant hub for entertaining, this home offers the ideal canvas in one of the most desirable areas of Rancho Mirage." +"Appliances": "Double Oven,Dishwasher,Microwave,Refrigerator" +"ArchitecturalStyle": "Mediterranean" +"AssociationAmenities": "Maintenance Grounds,Other Courts,Tennis Court(s)" +"AssociationFee": "380.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Victoria Falls Home Owners Association" +"AssociationPhone": "760-862-1202" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "951-240-6753" +"BathroomsFull": 4 +"CLIP": 5828520604 +"CommonInterest": "Planned Development" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Sidewalks,Gated" +"ConstructionMaterials": "Frame" +"ContractStatusChangeDate": "2025-05-02" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-03T01:48:15.115625+00:00" +"CumulativeDaysOnMarket": 33 +"DaysOnMarket": 45 +"DaysOnMarketReplication": 33 +"DaysOnMarketReplicationDate": "2025-06-04" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Abby Rd and Victoria Falls Dr" +"Electric": "Standard" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"ExteriorFeatures": "Misting System" +"Fencing": "Block" +"FireplaceFeatures": "Living Room,Primary Bedroom" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Palm Springs Unified" +"InteriorFeatures": "Wet Bar,Built-in Features,Ceiling Fan(s),Separate/Formal Dining Room,Eat-in Kitchen,Granite Counters,High Ceilings,Bar,Bedroom on Main Level,Main Level Primary,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "Two" +"ListAgentAOR": "Southwest Riverside County" +"ListAgentDirectPhone": "951-240-6753" +"ListAgentEmail": "Miquella@sellersnewday.com" +"ListAgentFirstName": "Miquella" +"ListAgentKey": "17179689" +"ListAgentKeyNumeric": "17179689" +"ListAgentLastName": "Zulfiqar" +"ListAgentOfficePhone": "760-496-0760" +"ListAgentStateLicense": "02110280" +"ListOfficeAOR": "Southwest Riverside County" +"ListOfficeEmail": "felipeberni@rogpacific.com" +"ListOfficeKey": "5228194" +"ListOfficeKeyNumeric": "5228194" +"ListOfficePhone": "760-496-0760" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-02" +"ListingKeyNumeric": 1112530973 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "2-5 Units/Acre,Back Yard,Street Level" +"LotSizeAcres": 0.47 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 20473.0 +"MLSAreaMajor": "321 - Rancho Mirage" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-06-04T10:57:40Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-02" +"OnMarketTimestamp": "2025-05-02T14:30:15Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-05-02T14:30:15Z" +"OriginalListPrice": 1380000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374348121" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "676490061" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "5.0" +"PatioAndPorchFeatures": "Rear Porch,Covered" +"PhotosChangeTimestamp": "2025-05-02T22:21:51Z" +"PhotosCount": 59 +"PoolFeatures": "Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "1646" +"PreviousListPrice": 1339000.0 +"PriceChangeTimestamp": "2025-06-04T10:57:40Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "Private Road" +"RoadSurfaceType": "Paved" +"Roof": "Slate" +"RoomType": "Bedroom,Entry/Foyer,Family Room,Kitchen,Laundry,Living Room,Primary Bedroom,Other,Dining Room" +"SecurityFeatures": "Gated Community" +"Sewer": "Public Sewer" +"ShowingContactName": "Miquella" +"ShowingContactPhone": "9517174494" +"ShowingContactType": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112530973" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-02T14:30:15Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Yorkshire" +"StreetNumber": "10" +"StreetNumberNumeric": "10" +"StreetSuffix": "Court" +"StructureType": "House" +"SubdivisionName": "Victoria Falls (32211)" +"TaxLot": "9" +"UniversalPropertyId": "US-06065-N-676490061-R-N" +"Utilities": "Electricity Connected,Sewer Connected,Water Connected" +"View": "Mountain(s), Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"WindowFeatures": "Blinds,Custom Covering(s)" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Entry,Family Room,Kitchen,Laundry,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bedroom,Primary Suite,Walk-In Closet",\n "EatingArea": "Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island",\n "RoomBathroomFeatures": "Bathtub,Shower,Double Sinks in Primary Bath,Main Floor Full Bath,Separate tub and shower,Soaking Tub,Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112530973",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112530973')" +"CurrentPrice": 1299000.0 +"provider_name": "CRMLS" +"RecordSignature": -373358037 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:676490061" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "371760323" +"OriginatingSystemListAgentMemberKey": "364145466" +"Media": array:59 [ …59] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111658417" +"ListingId": "25523871PS" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Closed" +"ModificationTimestamp": "2025-06-02T18:27:19Z" +"RFModificationTimestamp": "2025-06-02T20:50:29.112018+00:00" +"ListPrice": 898000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 2201.0 +"LivingArea": 2136.0 +"BuildingAreaTotal": 2136.0 +"City": "Palm Springs" +"PostalCode": "92262" +"UnparsedAddress": "130 W Racquet Club Road 417, Palm Springs, California 92262" +"Coordinates": array:2 [ …2] +"Latitude": 33.8526 +"Longitude": -116.546921 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "TTK Represents" +"ListOfficeName": "Compass" +"ListAgentMlsId": "CLW-45050" +"ListOfficeMlsId": "CLW-8373" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "The historic Racquet Club Condos in Palm Springs offer a uniquely elegant lifestyle rarely found in condominium living. Once the glamorous playground of Hollywood's elite, the famed Palm Springs Racquet Club was a hub of mid-century sophistication, where stars like Marilyn Monroe, Frank Sinatra, and Cary Grant mingled poolside in desert-chic style. Today, that spirit of luxury and leisure lives on. This extraordinary residence has combined two adjoining condos into one expansive and luxurious home, seamlessly blending sophistication with a touch of whimsy. Soaring 10' ceilings, expansive glass doors and windows, and a seamless indoor-outdoor flow evoke the feeling of a private estate rather than a typical condo. Extensive remodeling and system updates make this home ready for you to move in. Multiple outdoor living areas enhance the resort-like ambiance, featuring a private pool and lush landscaping reminiscent of Beverly Hills opulence and Palm Springs charm, and another secluded oasis just off the primary bedroom, ideal for peaceful relaxation. A gracious courtyard off the main living space creates the perfect open-air dining room, ideal for entertaining under the stars. This is more than a home, it's a rare opportunity to live amidst history, style, and timeless glamour. Short-term rentals are allowed in the complex but must adhere to city regulations. See the attached "List of Improvements"." +"Appliances": "Dishwasher,Disposal,Microwave,Refrigerator,Range Hood,Dryer" +"ArchitecturalStyle": "Mid-Century Modern" +"AssociationAmenities": "Pool,Spa/Hot Tub,Water" +"AssociationFee": "1299.52" +"AssociationFeeFrequency": "Monthly" +"AssociationYN": true +"BathroomsFull": 2 +"BuyerAgentAOR": "Palm Springs" +"BuyerAgentDirectPhone": "760-464-5600" +"BuyerAgentEmail": "leonardo@theleonardogroup.com" +"BuyerAgentFirstName": "Leonardo" +"BuyerAgentFullName": "Leonardo Montenegro" +"BuyerAgentKey": "17199545" +"BuyerAgentKeyNumeric": "17199545" +"BuyerAgentLastName": "Montenegro" +"BuyerAgentMlsId": "CLW-48115" +"BuyerAgentStateLicense": "01413476" +"BuyerAgentURL": "http://www.The Leonardo Group.com" +"BuyerOfficeAOR": "Palm Springs" +"BuyerOfficeKey": "3940934" +"BuyerOfficeKeyNumeric": "3940934" +"BuyerOfficeMlsId": "CLW-4760" +"BuyerOfficeName": "Keller Williams Luxury Homes" +"BuyerOfficePhone": "760-322-2286" +"CLIP": 8169196500 +"CarportYN": true +"CloseDate": "2025-06-02" +"ClosePrice": 885000.0 +"CommunityFeatures": "Pool" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-02" +"Cooling": "Central Air,Dual" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-04-11T18:59:14.350915+00:00" +"DaysOnMarket": 22 +"DaysOnMarketReplication": 22 +"DaysOnMarketReplicationDate": "2025-06-02" +"DirectionFaces": "West" +"Directions": "Turn into 130 Racquet Club Road and take an immediate left towards the west entrance and park in the guest parking." +"Disclosures": "HOA Disclosure" +"DocumentsChangeTimestamp": "2025-06-02T11:26:16Z" +"DocumentsCount": 2 +"DoorFeatures": "Sliding Doors" +"EntryLevel": 1 +"EntryLocation": "Foyer" +"ExteriorFeatures": "Misting System" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"FoundationDetails": "Slab" +"Furnished": "Unfurnished" +"Heating": "Central, Zoned" +"HeatingYN": true +"HighSchoolDistrict": "Palm Springs Unified" +"InteriorFeatures": "Ceiling Fan(s),Separate/Formal Dining Room,High Ceilings,Open Floorplan,Recessed Lighting" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "Palm Springs" +"ListAgentDirectPhone": "760-904-5234" +"ListAgentEmail": "INFO@TTKREPRESENTS.COM" +"ListAgentFirstName": "TTK" +"ListAgentKey": "17196868" +"ListAgentKeyNumeric": "17196868" +"ListAgentLastName": "Represents" +"ListAgentOfficePhone": "760-350-9253" +"ListAgentStateLicense": "01327863" +"ListOfficeAOR": "Palm Springs" +"ListOfficeFax": "760-820-2629" +"ListOfficeKey": "4487939" +"ListOfficeKeyNumeric": "4487939" +"ListOfficePhone": "760-350-9253" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-11" +"ListingKeyNumeric": 1111658417 +"ListingService": "Full Service" +"LotFeatures": "Yard" +"LotSizeAcres": 0.0505 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 2201.0 +"MLSAreaMajor": "331 - North End Palm Springs" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "55" +"OffMarketDate": "2025-05-03" +"OffMarketTimestamp": "2025-05-21T04:21:36Z" +"OnMarketDate": "2025-04-11" +"OnMarketTimestamp": "2025-04-11T03:46:58Z" +"OriginalEntryTimestamp": "2025-04-11T10:33:41Z" +"OriginalListPrice": 898000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374231300" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "504340032" +"ParkingFeatures": "Assigned,Covered,Detached Carport,Gated" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Open, Patio" +"PetsAllowed": "Yes" +"PhotosChangeTimestamp": "2025-06-02T18:27:43Z" +"PhotosCount": 46 +"PoolFeatures": "Community,Heated,In Ground,Private,Association" +"PoolPrivateYN": true +"PostalCodePlus4": "5015" +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Condominium" +"PurchaseContractDate": "2025-05-03" +"RoomType": "Entry/Foyer,Family Room,Office,Dining Room" +"SecurityFeatures": "Security Gate" +"Sewer": "Other" +"ShowingContactName": "Scott Ankersen" +"ShowingContactPhone": "5038605854|" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111658417" +"SpaFeatures": "Association" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-02T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "Racquet Club" +"StreetNumber": "130" +"StreetNumberNumeric": "130" +"StreetSuffix": "Road" +"SubdivisionName": "Club Condominiums" +"UnitNumber": "417" +"UniversalPropertyId": "US-06065-N-504340032-R-N" +"View": "Mountain(s), Pool" +"ViewYN": true +"WindowFeatures": "Double Pane Windows,Tinted Windows" +"Zoning": "R3" +"CustomFields": """ {\n "RoomType": "Office,Entry,Family Room",\n "EatingArea": "Dining Room",\n "RoomBathroomFeatures": "Vanity area,Linen Closet/Storage,Remodeled,Tile Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1111658417"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111658417')" +"CurrentPrice": 885000.0 +"provider_name": "CRMLS" +"RecordSignature": 1965875805 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:504340032" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "367701216" +"OriginatingSystemBuyerOfficeKey": "364736627" +"OriginatingSystemListAgentMemberKey": "364092092" +"OriginatingSystemBuyerAgentMemberKey": "364533279" +"Media": array:46 [ …46] } ] +success: true +page_size: 10 +page_count: 16 +count: 152 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5491 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5490 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1108324479" +"ListingId": "IV25047729" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T19:51:48Z" +"RFModificationTimestamp": "2025-06-16T20:01:31.168887+00:00" +"ListPrice": 670000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 7405.0 +"LivingArea": 1693.0 +"BuildingAreaTotal": 0 +"City": "Murrieta" +"PostalCode": "92563" +"UnparsedAddress": "39859 Brandy Lane, Murrieta, California 92563" +"Coordinates": array:2 [ …2] +"Latitude": 33.563764 +"Longitude": -117.173941 +"YearBuilt": 1987 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "MARY DIMMLER-LONG" +"ListOfficeName": "COLDWELL BANKER ASSOC BRKR/CL" +"ListAgentMlsId": "IDIMMMAR" +"ListOfficeMlsId": "ICCL01" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Welcome to your dream home nestled in a sought after Murrieta neighborhood with PAID OFF "SOLAR", low taxes, and no HOA! This home offers a spacious backyard, perfect for a huge garden or your own chicken coop! A versatile man cave shed with mini split provides the ideal space for a workout room, office or creative retreat. Step inside and discover a beautifully upgraded kitchen featuring a new Samsung Stove and Microwave. Double drawer dishwasher, quartz countertops, and new tile flooring on lower level. Entertain in the 'eat in' kitchen. Dining room has natural light from a skylight. Cozy gas fireplace creates warmth & ambiance for the family room. All 3 bedrooms are upstairs. The primary suite has french doors that lead to a spacious patio overlooking a backyard filled with fruit trees (2 apple, cherry, mandarin orange, apricot, meyer lemon, banana, and seedless grapes along the fence). The primary bath features a walk in shower, jetted soaking tub, & another skylight that opens for fresh air & natural light. Walk in closet offers organizers and lots of space. This home offers quick access to shopping, walking distance to an award winning school, parks and freeway. Low maintenance front yard, 2 car garage, and an extended driveway offering ample parking for a boat or RV! That's right, fully paid off solar, approx 27 solar panels, so save on Power!!\r\r\n Some of the photos have virtual staging. """ +"AccessibilityFeatures": "None" +"Appliances": "Built-In Range,Dishwasher,Gas Oven,Gas Range,Trash Compactor" +"ArchitecturalStyle": "Traditional" +"AttachedGarageYN": true +"AttributionContact": "951-640-6968" +"BackOnMarketDate": "2025-05-27" +"BathroomsFull": 2 +"CLIP": 2317584628 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Park,Street Lights,Sidewalks" +"ConstructionMaterials": "Stucco" +"Contingency": "non sell it!" +"ContractStatusChangeDate": "2025-03-04" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-27T16:11:44.109027+00:00" +"CumulativeDaysOnMarket": 96 +"CurrentFinancing": "None" +"DaysOnMarket": 96 +"DaysOnMarketReplication": 96 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Murrieta Hot Springs to Blackthorne, go left, then left on Brandy Lane" +"DoorFeatures": "French Doors,Sliding Doors" +"Electric": "Standard" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"Fencing": "Wood" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Carpet, Laminate, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"GreenEnergyGeneration": "Solar" +"Heating": "Central,Natural Gas" +"HeatingYN": true +"HighSchool": "Vista Murrieta" +"HighSchoolDistrict": "Murrieta" +"InteriorFeatures": "Breakfast Bar,Built-in Features,Balcony,Ceiling Fan(s),Cathedral Ceiling(s),Granite Counters,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Inland Valleys" +"ListAgentDirectPhone": "951-244-1867" +"ListAgentEmail": "mary@coldwellbankerab.com" +"ListAgentFax": "951-244-5306" +"ListAgentFirstName": "MARY" +"ListAgentKey": "17098803" +"ListAgentKeyNumeric": "17098803" +"ListAgentLastName": "DIMMLER-LONG" +"ListAgentOfficePhone": "951-244-1867" +"ListAgentStateLicense": "01001124" +"ListOfficeAOR": "Inland Valleys" +"ListOfficeEmail": "Mag Mc Coy@coldwellbanker.com" +"ListOfficeFax": "951-527-5923" +"ListOfficeKey": "3285555" +"ListOfficeKeyNumeric": "3285555" +"ListOfficePhone": "951-244-1867" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-04" +"ListingKeyNumeric": 1108324479 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Front Yard,Garden,Level,Yard" +"LotSizeAcres": 0.17 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7405.0 +"MLSAreaMajor": "SRCAR - Southwest Riverside County" +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-05-27T08:43:03Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-05-22" +"OffMarketTimestamp": "2025-05-22T14:57:44Z" +"OnMarketDate": "2025-03-06" +"OnMarketTimestamp": "2025-05-27T08:43:03Z" +"OriginalEntryTimestamp": "2025-03-06T07:27:23Z" +"OriginalListPrice": 670000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374036173" +"OriginatingSystemSubName": "CRMLS_CRM" +"OtherStructures": "Shed(s)" +"ParcelNumber": "912103014" +"ParkingFeatures": "Garage Faces Front,RV Access/Parking" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Patio" +"PhotosChangeTimestamp": "2025-06-14T00:25:44Z" +"PhotosCount": 47 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PropertyCondition": "Termite Clearance" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Tile" +"RoomType": "Bedroom" +"SecurityFeatures": "Carbon Monoxide Detector(s),Security Lights" +"Sewer": "Public Sewer" +"ShowingContactName": "Mary" +"ShowingContactPhone": "951-640-6968" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108324479" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-27T08:43:03Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Brandy" +"StreetNumber": "39859" +"StreetNumberNumeric": "39859" +"StreetSuffix": "Lane" +"StructureType": "House" +"TaxLot": "126" +"UniversalPropertyId": "US-06065-N-912103014-R-N" +"Utilities": "Natural Gas Connected" +"View": "Mountain(s), Neighborhood" +"ViewYN": true +"VirtualTourURLUnbranded": "https://youtu.be/s Lt Nj3pw K04" +"VirtualTourURLUnbranded2": "https://my.matterport.com/show/?m=Lc JKa Ve Sebg&mls=1" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,Skylight(s)" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "EatingArea": "Breakfast Counter / Bar",\n "RoomKitchenFeatures": "Built-in Trash/Recycling,Granite Counters,Kitchen Open to Family Room",\n "RoomBathroomFeatures": "Double sinks in bath(s),Jetted Tub,Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1108324479",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108324479')" +"CurrentPrice": 670000.0 +"provider_name": "CRMLS" +"RecordSignature": -671413777 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:912103014" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "7714" +"OriginatingSystemListAgentMemberKey": "148550" +"Media": array:47 [ …47] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5692 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115038084" +"ListingId": "ML82010105" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T19:51:48Z" +"RFModificationTimestamp": "2025-06-16T20:03:59.778645+00:00" +"ListPrice": 938000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1349.0 +"BuildingAreaTotal": 0 +"City": "Foster City" +"PostalCode": "94404" +"UnparsedAddress": "1111 Compass Lane 106, Foster City, California 94404" +"Coordinates": array:2 [ …2] +"Latitude": 37.55179118 +"Longitude": -122.25412356 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shirikala Andra" +"ListOfficeName": "KW Silicon City" +"ListAgentMlsId": "ML5099402" +"ListOfficeMlsId": "ML5009038" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this beautifully remodeled and light-filled end unit in the prestigious Marina Point community of Foster City! This spacious 2-bedroom, 2-bath condo offers an open-concept layout with abundant natural light, a remodeled kitchen with quartz countertops and generous cabinet space, in-unit laundry, and a private balconyperfect for relaxing or entertaining. The expansive primary suite features a walk-in closet with built-ins and a tastefully updated ensuite bath. Additional highlights include hardwood floors, recessed lighting, carpeting in the bedrooms, dedicated parking, ample guest parking, extra storage, and RV parking. Enjoy a resort-style community with pool, spa, clubhouse, tennis courts, childrens parks, and beautifully landscaped walking paths. The property is adjacent to the Bay Backwater Trail, perfect for scenic strolls and outdoor activities. Conveniently located with quick access to Hwy 101 and 92, and just minutes from shopping, Ranch 99, top-rated schools, Leo Ryan Park, Shorebird Park, FC Dog Park, and leading tech employers including Visa, Oracle, Gilead, and Rakuten. HOA includes water and garbage." +"Appliances": "Dishwasher,Electric Cooktop,Electric Oven,Refrigerator" +"AssociationAmenities": "Hot Water,Spa/Hot Tub,Trash" +"AssociationFee": "840.0" +"AssociationFeeIncludes": "Sewer" +"AssociationName": "Marina Point" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 2311353908 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-06-06" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-06-07T02:26:41.610939+00:00" +"DaysOnMarket": 10 +"DaysOnMarketReplication": 10 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head SW on Foster City Blvd, Turn right on Compass Lane. Building as adjacent the tennis courts Cross Street: Foster City Blvd" +"ElementarySchool": "Other" +"FireplaceYN": true +"Flooring": "Carpet, Wood" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Electric" +"HeatingYN": true +"HighSchool": "San Mateo" +"HighSchoolDistrict": "Other" +"InteriorFeatures": "Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "313-870-8866" +"ListAgentEmail": "shirirealtyllc@gmail.com" +"ListAgentFirstName": "Shirikala" +"ListAgentKey": "22781382" +"ListAgentKeyNumeric": "22781382" +"ListAgentLastName": "Andra" +"ListAgentOfficePhone": "(408) 755-5972" +"ListAgentStateLicense": "02230953" +"ListOfficeAOR": "MLSListings" +"ListOfficeKey": "4762539" +"ListOfficeKeyNumeric": "4762539" +"ListOfficePhone": "(408) 755-5972" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1115038084 +"ListingService": "Full Service" +"LivingAreaSource": "Other" +"LotSizeSource": "Assessor" +"MLSAreaMajor": "699 - Not Defined" +"MiddleOrJuniorSchool": "Other" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T09:20:29Z" +"OriginalEntryTimestamp": "2025-06-06T08:54:27Z" +"OriginalListPrice": 938000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374547040" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "105490090" +"ParkingFeatures": "Gated" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-06T23:38:41Z" +"PhotosCount": 48 +"PoolFeatures": "In Ground" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Other" +"RoomType": "Other" +"Sewer": "Public Sewer" +"ShowingContactPhone": "408-800-1410" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115038084" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T08:54:27Z" +"StoriesTotal": "1" +"StreetName": "Compass" +"StreetNumber": "1111" +"StreetNumberNumeric": "1111" +"StreetSuffix": "Lane" +"UnitNumber": "106" +"UniversalPropertyId": "US-06081-N-105490090-R-N" +"VirtualTourURLUnbranded": "https://f8.f8re.com/videos/01974593-1976-70b0-b0fe-26d1e1c400bc" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "Residential" +"CustomFields": """ {\n "RoomType": "Walk-In Closet",\n "RoomKitchenFeatures": "Stone Counters",\n "RoomBathroomFeatures": "Bidet,Double sinks in bath(s)",\n "AdminUpdateYN": "0",\n "ListingKey": "1115038084"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115038084')" +"CurrentPrice": 938000.0 +"provider_name": "CRMLS" +"RecordSignature": 958129876 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:105490090" +"CountrySubdivision": "06081" +"OriginatingSystemListOfficeKey": "368549164" +"OriginatingSystemListAgentMemberKey": "372250825" +"Media": array:48 [ …48] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5691 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114974318" +"ListingId": "PTP2504183" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T19:51:48Z" +"RFModificationTimestamp": "2025-06-16T20:04:11.342429+00:00" +"ListPrice": 1489800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 5700.0 +"LivingArea": 2100.0 +"BuildingAreaTotal": 0 +"City": "San Diego" +"PostalCode": "92111" +"UnparsedAddress": "3262 Mount Carol Drive, San Diego, California 92111" +"Coordinates": array:2 [ …2] +"Latitude": 32.80234492 +"Longitude": -117.18100824 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Maryann Augustine" +"ListOfficeName": "Frontline Realty Group" +"ListAgentMlsId": "240198" +"ListOfficeMlsId": "25569" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Beautifully updated 5-bedroom, 2-bath home nestled on a quiet Mountain street in the heart of Clairemont, just minutes from Tecolote Canyon, Mission Bay, and San Diego’s best shopping, dining, and beach destinations. This 2,100 sq ft residence features a rare first-floor primary suite with walk-in shower which features direct patio access with a beautiful patio pergola, perfect for privacy and comfort. Step into the remodeled kitchen with custom KraftMaid cabinetry, stunning leather-like finished stone countertops with breakfast bar island, custom tile backsplash, stainless steel appliances including a gas cooktop, built-in oven with warming drawer, dishwasher, and French door refrigerator. The kitchen opens to the dining area and spacious family room with wood beam ceilings and large sliders leading to multiple outdoor patios—ideal for entertaining or relaxing year-round. The front living room showcases a gorgeous fire-and-ice gas fireplace framed by custom stonework and Plantation shutters. Both bathrooms have been stylishly remodeled. Gorgeous wood and iron staircase, upgraded vinyl & wood fencing. Enjoy central heat, dual-pane windows, tile flooring, ceiling fans and thoughtful storage throughout. Outdoors, you'll find professionally landscaped and beautiful, low-maintenance grounds featuring turf, drought-tolerant plants, DG paths, and colorful flowering vines. Multiple private patios, a pergola-covered lounge, and meandering garden walkways make the backyard a true retreat. Located just minutes from East Clairemont Community Park, Clairemont Village Shopping Center, Shopping at Balboa & Genesee, close to 3 major freeways, and less than 10 minutes to Mission Bay and the beach. Zoned for the award-winning Holmes Elementary School—just 0.8 mile away—this home blends peace, practicality, and unbeatable access to everything San Diego offers. A true gem in a prime coastal-close neighborhood!" +"Appliances": "Dishwasher,Electric Oven,Gas Cooktop,Disposal,Microwave,Refrigerator,Water Heater,Dryer,Washer" +"AttachedGarageYN": true +"AttributionContact": "Maryann@frontlinerealtygroup.com" +"BathroomsFull": 2 +"CLIP": 7979566051 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Sidewalks" +"ConstructionMaterials": "Stucco,Wood Siding" +"ContractStatusChangeDate": "2025-06-05" +"Cooling": "None" +"CountyOrParish": "San Diego" +"CreationDate": "2025-06-06T00:18:59.300031+00:00" +"DaysOnMarket": 11 +"DaysOnMarketReplication": 11 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "East" +"Directions": "use GPS - 3262 Mount Carol, San Diego CA 92111" +"DoorFeatures": "Sliding Doors" +"EntryLevel": 1 +"EntryLocation": "Front door" +"Fencing": "Wood" +"FireplaceFeatures": "Gas,Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Natural Gas" +"HeatingYN": true +"HighSchoolDistrict": "San Diego Unified" +"Inclusions": "washer/dryer/refrigerator" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Separate/Formal Dining Room,Open Floorplan,Recessed Lighting,Main Level Primary" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific Southwest" +"ListAgentDirectPhone": "619-838-7725" +"ListAgentEmail": "Maryann@frontlinerealtygroup.com" +"ListAgentFirstName": "Maryann" +"ListAgentKey": "17220244" +"ListAgentKeyNumeric": "17220244" +"ListAgentLastName": "Augustine" +"ListAgentOfficePhone": "619-885-7270" +"ListAgentStateLicense": "01224089" +"ListAgentURL": "www.frontlinerealtygroup.com" +"ListOfficeAOR": "Pacific Southwest" +"ListOfficeEmail": "admin@fronlinerealtygroup.com" +"ListOfficeFax": "619-220-8009" +"ListOfficeKey": "3267520" +"ListOfficeKeyNumeric": "3267520" +"ListOfficePhone": "619-885-7270" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-05" +"ListingKeyNumeric": 1114974318 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,Cal Vet Loan,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Drip Irrigation/Bubblers,Front Yard" +"LotSizeAcres": 0.1309 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5700.0 +"MLSAreaMajor": "92117 - Clairemont Mesa" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 1 +"OccupantType": "Owner" +"OnMarketDate": "2025-06-05" +"OnMarketTimestamp": "2025-06-05T06:49:55Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-06-05T13:43:00Z" +"OriginalListPrice": 1489800.0 +"OriginatingSystemID": "CRP" +"OriginatingSystemKey": "374536286" +"OriginatingSystemSubName": "CRMLS_CRP" +"ParcelNumber": "4264800900" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "4.0" +"PatioAndPorchFeatures": "Patio" +"PhotosChangeTimestamp": "2025-06-16T19:52:41Z" +"PhotosCount": 36 +"PoolFeatures": "None" +"Possession": "See Remarks" +"PreviousListPrice": 1489800.0 +"PriceChangeTimestamp": "2025-06-04T17:00:00Z" +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Family Room,Great Room,Kitchen,Living Room,Primary Bathroom,Primary Bedroom,Dining Room" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Maryann Augustine" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114974318" +"SpaFeatures": "None" +"SpecialListingConditions": "Trust" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-04T17:00:00Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Mount Carol" +"StreetNumber": "3262" +"StreetNumberNumeric": "3262" +"StreetSuffix": "Drive" +"SubdivisionName": "CLAIREMONT" +"TaxBlock": "703" +"UniversalPropertyId": "US-06073-N-4264800900-R-N" +"Utilities": "Cable Connected,Electricity Connected" +"View": "None" +"VirtualTourURLBranded": "https://tours.previewfirst.com/pw/152543" +"VirtualTourURLUnbranded": "https://tours.previewfirst.com/ml/152543" +"WindowFeatures": "Blinds" +"YearBuiltSource": "Assessor" +"Zoning": "R-1" +"CustomFields": """ {\n "RoomType": "Family Room,Great Room,Kitchen,Living Room,Main Floor Primary Bedroom,Primary Bathroom",\n "EatingArea": "Breakfast Counter / Bar,Dining Room",\n "RoomKitchenFeatures": "Kitchen Open to Family Room,Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Linen Closet/Storage,Quartz Counters,Remodeled,Walk-in shower,Bathtub",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "0",\n "ListingKey": "1114974318"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114974318')" +"CurrentPrice": 1489800.0 +"provider_name": "CRMLS" +"RecordSignature": 1389308382 +"UniversalParcelId": "urn:reso:upi:2.0:US:06073:4264800900" +"CountrySubdivision": "06073" +"OriginatingSystemListOfficeKey": "123464505" +"OriginatingSystemListAgentMemberKey": "123522918" +"Media": array:36 [ …36] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5694 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1107428815" +"ListingId": "25500939" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T19:51:48Z" +"RFModificationTimestamp": "2025-06-16T20:02:50.914608+00:00" +"ListPrice": 1865000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 5042.0 +"LivingArea": 2239.0 +"BuildingAreaTotal": 2239.0 +"City": "Los Angeles" +"PostalCode": "90034" +"UnparsedAddress": "3130 Hutchison Avenue, Los Angeles, California 90034" +"Coordinates": array:2 [ …2] +"Latitude": 34.033052 +"Longitude": -118.385185 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Hosh Maha" +"ListOfficeName": "EstateX inc." +"ListAgentMlsId": "CLW-C137047" +"ListOfficeMlsId": "CLW-X83832" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "First Time on the Market Since 2003 A Rare Opportunity!Charming Spanish-Style Front Unit with Modern Back Unit!This unique property features a charming 3-bedroom, 2-bathroom Spanish-style front unit with 1,166 sqft of classic character, including arched doorways and terracotta tiles. The back unit offers a sleek, modern design with 1 bedroom, 1 bathroom, and 1,073 sqft of versatile space, perfect for guests or rental income.Located near local shops, restaurants, and amenities, this home offers the perfect blend of timeless Spanish charm and modern convenience. Front unit is tenant-occupied.(Month to month) Back unit is vacant." +"Appliances": "Dishwasher, Microwave, Refrigerator, Dryer, Washer" +"ArchitecturalStyle": "See Remarks" +"BackOnMarketDate": "2025-04-14" +"BathroomsFull": 3 +"CLIP": 4604087784 +"CarportYN": true +"CoListAgentAOR": "Beverly Hills/Greater LA" +"CoListAgentDirectPhone": "310-497-3681" +"CoListAgentEmail": "Kiyomi@ciresocal.com" +"CoListAgentFirstName": "Kiyomi" +"CoListAgentFullName": "Kiyomi Fukazawa" +"CoListAgentKey": "22975613" +"CoListAgentKeyNumeric": "22975613" +"CoListAgentLastName": "Fukazawa" +"CoListAgentMlsId": "CLW-C142799" +"CoListAgentOfficePhone": "424-249-7162" +"CoListAgentStateLicense": "02224335" +"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-02-20" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Los Angeles" +"CreationDate": "2025-04-15T01:04:31.513631+00:00" +"DaysOnMarket": 110 +"DaysOnMarketReplication": 110 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Head northeast on I-10 E, Take exit 7A for La Cienega Blvd, Slight right onto the La Cienega Blvd S ramp, Turn right onto La Cienega Blvd then Turn right onto Venice Blvd. Lastly, Turn right onto Hutchison Ave. The property is on the right side." +"FireplaceFeatures": "None" +"Flooring": "Tile, Wood" +"Furnished": "Unfurnished" +"Heating": "Central, Electric" +"HeatingYN": true +"InteriorFeatures": "Ceiling Fan(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Beverly Hills/Greater LA" +"ListAgentDirectPhone": "424-522-3207" +"ListAgentEmail": "hosh@estatexrealty.com" +"ListAgentFirstName": "Hosh" +"ListAgentKey": "19183009" +"ListAgentKeyNumeric": "19183009" +"ListAgentLastName": "Maha" +"ListAgentOfficePhone": "310-770-7032" +"ListAgentStateLicense": "02131447" +"ListOfficeAOR": "Beverly Hills/Greater LA" +"ListOfficeFax": "213-426-8260" +"ListOfficeKey": "5840633" +"ListOfficeKeyNumeric": "5840633" +"ListOfficePhone": "310-770-7032" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-02-20" +"ListingKeyNumeric": 1107428815 +"ListingService": "Full Service" +"LotFeatures": "Landscaped" +"LotSizeAcres": 0.1157 +"LotSizeDimensions": "42x120" +"LotSizeSquareFeet": 5042.0 +"MLSAreaMajor": "C09 - Beverlywood Vicinity" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "2" +"OffMarketDate": "2025-04-08" +"OffMarketTimestamp": "2025-04-08T12:01:38Z" +"OnMarketDate": "2025-02-20" +"OnMarketTimestamp": "2025-02-20T03:07:05Z" +"OriginalEntryTimestamp": "2025-02-20T10:59:00Z" +"OriginalListPrice": 2075000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "373967145" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "4312005033" +"ParkingFeatures": "Carport, Driveway" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-13T04:01:10Z" +"PhotosCount": 17 +"PoolFeatures": "None" +"PostalCodePlus4": "3229" +"PreviousListPrice": 1975000.0 +"PriceChangeTimestamp": "2025-06-03T10:51:46Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Living Room" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1107428815" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-02-20T00:00:00Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Hutchison" +"StreetNumber": "3130" +"StreetNumberNumeric": "3130" +"StreetSuffix": "Avenue" +"UniversalPropertyId": "US-06037-N-4312005033-R-N" +"View": "None" +"Zoning": "LARD1.5" +"CustomFields": """ {\n "RoomType": "Living Room",\n "RoomKitchenFeatures": "Stone Counters,Kitchen Island",\n "AdminUpdateYN": "0",\n "ListingKey": "1107428815"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1107428815')" +"CurrentPrice": 1865000.0 +"provider_name": "CRMLS" +"RecordSignature": -1361982741 +"UniversalParcelId": "urn:reso:upi:2.0:US:06037:4312005033" +"CountrySubdivision": "06037" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "374319271" +"OriginatingSystemCoListOfficeKey": "370609097" +"OriginatingSystemListAgentMemberKey": "365849785" +"OriginatingSystemCoListAgentMemberKey": "372342083" +"Media": array:17 [ …17] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5696 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114448387" +"ListingId": "ML82008066" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T19:51:48Z" +"RFModificationTimestamp": "2025-06-16T20:02:07.104006+00:00" +"ListPrice": 1280000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5064.0 +"LivingArea": 2110.0 +"BuildingAreaTotal": 0 +"City": "Calistoga" +"PostalCode": "94515" +"UnparsedAddress": "1437 4th Street, Calistoga, California 94515" +"Coordinates": array:2 [ …2] +"Latitude": 38.58187658 +"Longitude": -122.58225682 +"YearBuilt": 1915 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sissy Riley" +"ListOfficeName": "Lucky Investment, Inc." +"ListAgentMlsId": "ML493094" +"ListOfficeMlsId": "ML91373" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Charming, Brightly Lit Dual-Home Property for Wine Lovers! Don't miss this rare opportunity to own two fully equipped homes on one lot in the heart of beautiful Calistoga. The main home offers 1,590 square feet of well-designed living space, featuring: 2 spacious bedrooms and 2.5 bathrooms, a generous loft filled with natural light from a skylight and windows, a formal living room and a kitchen/dining combo, direct access to a landscaped yard with a pergola, perfect for outdoor entertaining, and a welcoming front porch is ideal for morning coffee or relaxing afternoons The legalized Accessory Dwelling Unit (ADU) is a 520 SqFt one-bedroom home with: A remodeled kitchen and bathroom, soaring ceilings and an open, airy feel. Other highlights include: Central heating and A/C, long driveway with parking for 6 cars, turn-key condition, move in or rent immediately. Just a short walk to downtown Calistoga's world-renowned wineries, top restaurants, and boutique shops Live in one home and rent out the other, or create the perfect multigenerational retreat. This is your chance to own a legacy property in one of Napa Valley's most sought-after communities. Act on opportunities like this don't last!" +"BathroomsFull": 3 +"CLIP": 4708203866 +"CarportSpaces": "6.0" +"CarportYN": true +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-22" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Napa" +"CreationDate": "2025-05-23T02:33:05.279177+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-16" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: Fair Way" +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Calistoga Joint Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-290-2200" +"ListAgentEmail": "sissybroker@gmail.com" +"ListAgentFirstName": "Sissy" +"ListAgentKey": "20923163" +"ListAgentKeyNumeric": "20923163" +"ListAgentLastName": "Riley" +"ListAgentOfficePhone": "(650) 290-2200" +"ListAgentStateLicense": "01465547" +"ListAgentURL": "http://www.Sissy Riley.com" +"ListOfficeAOR": "MLSListings" +"ListOfficeKey": "4763102" +"ListOfficeKeyNumeric": "4763102" +"ListOfficePhone": "(650) 290-2200" +"ListOfficeURL": "http://www.Lucky Investment.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-22" +"ListingKeyNumeric": 1114448387 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.1163 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5064.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-22" +"OnMarketTimestamp": "2025-05-22T12:04:13Z" +"OriginalEntryTimestamp": "2025-05-22T11:30:22Z" +"OriginalListPrice": 1349000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374460774" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "011201003000" +"ParkingFeatures": "Carport" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-06-16T19:52:41Z" +"PhotosCount": 48 +"PreviousListPrice": 1349000.0 +"PriceChangeTimestamp": "2025-06-16T05:35:39Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Shingle" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114448387" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-22T11:30:22Z" +"StoriesTotal": "2" +"StreetName": "4th" +"StreetNumber": "1437" +"StreetNumberNumeric": "1437" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06055-N-011201003000-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"Zoning": "R1" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1114448387"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114448387')" +"CurrentPrice": 1280000.0 +"provider_name": "CRMLS" +"RecordSignature": -508605284 +"UniversalParcelId": "urn:reso:upi:2.0:US:06055:011201003000" +"CountrySubdivision": "06055" +"OriginatingSystemListOfficeKey": "368557281" +"OriginatingSystemListAgentMemberKey": "368738709" +"Media": array:48 [ …48] } ] +success: true +page_size: 5 +page_count: 135471 +count: 677354 +after_key: "" } ] ]