Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=30&$filter=City eq 'La Quinta'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=30&$filter=City eq 'La Quinta'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=30&$filter=City eq 'La Quinta'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=30&$filter=City eq 'La Quinta'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4018 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: 130099 +post_author: 1 +"ListingKey": "1108707189" +"ListingId": "219126560DA" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T16:30:19Z" +"RFModificationTimestamp": "2025-06-14T22:55:40.551600+00:00" +"ListPrice": 595000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 2178.0 +"LivingArea": 1621.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "55438 Firestone, La Quinta, California 92253" +"Coordinates": array:2 [ 0 => -116.271951 1 => 33.647636 ] +"Latitude": 33.647636 +"Longitude": -116.271951 +"YearBuilt": 1988 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rick Parnell" +"ListOfficeName": "Compass" +"ListAgentMlsId": "CDAR-D78332" +"ListOfficeMlsId": "CDAR-oD23728" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "GOLFER ENTHUSIAST SPECIAL!. PRICE INCLUDES A FULL PREMIER GOLF MEMBERSHIP AT PGA WEST, AND A GOLF CART WITH LITHIUM BATTERY! Welcome to this stunning remodeled townhouse in the exclusive PGA West. This 3-bedroom, 2.5-bathroom gem boasts magnificent views of the serene lake with multiple waterfalls and community pools/spas. With its tall vaulted ceiling and expansive floor-to-ceiling windows, the dramatic living room floods the space with natural light, seamlessly connecting to a private patio through two sets of sliding glass doors--perfect for indoor/outdoor living and entertaining. Culinary enthusiasts will adore the remodeled chef's kitchen, which has granite countertops. Host family and friends in the spacious formal dining room. Relax in the spacious living room, or the morning room off the kitchen. With direct access to the front load double car garage, coming and going is very convenient. Upstairs, the primary bedroom features an attached deck, walk-in closet, and a luxurious remodeled en-suite bath. Two additional bedrooms sharing a full guest bath provide ample space for family or guests. A community pool/spa is conveniently located only steps away. PGA West features 3 Private and 3 Public courses, tennis, pickleball, three clubhouses, restaurants, and more. HOAs include building maintenance, complete landscaping, irrigation water/equipment, exterior paint, roof, cable, internet, trash, and 24-hour guarded gated security. Offered fully furnished per written Inventory." +"Appliances": "Dishwasher,Disposal,Gas Water Heater,Microwave,Refrigerator,Range Hood,Vented Exhaust Fan,Water To Refrigerator" +"AssociationAmenities": "Controlled Access,Maintenance Grounds,Security,Trash,Cable TV" +"AssociationFee": "767.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": "Earthquake Insurance,Sewer" +"AssociationName": "PGA West Residential I" +"AssociationPhone": "760-771-1234" +"AssociationYN": true +"BathroomsFull": 2 +"BuilderModel": "Greens E" +"BuilderName": "Sunrise" +"CLIP": 4332750577 +"CoListAgentAOR": "California Desert" +"CoListAgentDirectPhone": "(360) 791-1361" +"CoListAgentEmail": "kyleparnell360@gmail.com" +"CoListAgentFirstName": "Kyle" +"CoListAgentFullName": "Kyle Parnell" +"CoListAgentKey": "24296321" +"CoListAgentKeyNumeric": "24296321" +"CoListAgentLastName": "Parnell" +"CoListAgentMlsId": "CDAR-d85871" +"CoListAgentOfficePhone": "(760) 249-2120" +"CoListAgentStateLicense": "01933817" +"CoListOfficeAOR": "California Desert" +"CoListOfficeEmail": "george.rider@compass.com" +"CoListOfficeKey": "3254138" +"CoListOfficeKeyNumeric": "3254138" +"CoListOfficeMlsId": "CDAR-o D23728" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "(760) 249-2120" +"CommunityFeatures": "Golf, Gated" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-03-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-04-15T05:04:32.306950+00:00" +"DaysOnMarket": 91 +"DaysOnMarketReplication": 91 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "South on Jefferson into PGA West. First right into Arnold Palmer Residential Gate. Continue straight to Firestone. Turn right and condo will be on the right. Cross Street: Arnold Palmer." +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure" +"DocumentsChangeTimestamp": "2025-03-15T06:57:28Z" +"DoorFeatures": "Sliding Doors" +"Electric": "220 Volts in Laundry" +"ExteriorFeatures": "Barbecue" +"FireplaceFeatures": "Family Room,Gas,Gas Starter" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Forced Air,Fireplace(s),Natural Gas" +"HeatingYN": true +"Inclusions": "Furnished per written inventory." +"InteriorFeatures": "Separate/Formal Dining Room,All Bedrooms Up,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "Two" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(360) 280-4178" +"ListAgentEmail": "rdparnell@icloud.com" +"ListAgentFirstName": "Rick" +"ListAgentKey": "17293247" +"ListAgentKeyNumeric": "17293247" +"ListAgentLastName": "Parnell" +"ListAgentOfficePhone": "(760) 249-2120" +"ListAgentStateLicense": "01926331" +"ListAgentURL": "http://searchcaliforniadesertproperties.com" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "george.rider@compass.com" +"ListOfficeKey": "3254138" +"ListOfficeKeyNumeric": "3254138" +"ListOfficePhone": "(760) 249-2120" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-12" +"ListingKeyNumeric": 1108707189 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Close to Clubhouse,Drip Irrigation/Bubblers,Planned Unit Development,Sprinklers Timer,Sprinkler System" +"LotSizeAcres": 0.05 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 2178.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Active" +"OnMarketDate": "2025-03-15" +"OnMarketTimestamp": "2025-03-15T00:14:50Z" +"OriginalEntryTimestamp": "2025-03-15T06:57:27Z" +"OriginalListPrice": 659000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374086548" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "775151065" +"ParkingFeatures": "Direct Access,Garage,Garage Door Opener,On Street" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Brick" +"PhotosChangeTimestamp": "2025-05-15T14:21:47Z" +"PhotosCount": 32 +"PostalCodePlus4": "4693" +"PreviousListPrice": 629000.0 +"PriceChangeTimestamp": "2025-04-14T17:19:07Z" +"PropertyAttachedYN": true +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Tile" +"RoomType": "Bonus Room,Bedroom,Living Room,Primary Bedroom,Dining Room" +"SecurityFeatures": "Gated Community,24 Hour Security" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108707189" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-03-14T22:00:00Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Firestone" +"StreetNumber": "55438" +"StreetNumberNumeric": "55438" +"SubdivisionName": "PGA Palmer Private" +"UniversalPropertyId": "US-06065-N-775151065-R-N" +"Utilities": "Cable Available" +"View": "Desert, Lake, Mountain(s), Panoramic, Valley" +"ViewYN": true +"WindowFeatures": "Shutters" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Living Room,Bonus Room,All Bedrooms Up,Primary Suite",\n "EatingArea": "Dining Room",\n "RoomKitchenFeatures": "Remodeled Kitchen,Granite Counters",\n "RoomBathroomFeatures": "Vanity area,Shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1108707189",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108707189')" +"CurrentPrice": 595000.0 +"provider_name": "CRMLS" +"RecordSignature": 686330576 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:775151065" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "361438344" +"OriginatingSystemCoListOfficeKey": "361438344" +"OriginatingSystemListAgentMemberKey": "8229179" +"OriginatingSystemCoListAgentMemberKey": "373040893" +"Media": array:32 [ 0 => array:58 [ …58] 1 => array:58 [ …58] 2 => array:58 [ …58] 3 => array:58 [ …58] 4 => array:58 [ …58] 5 => array:58 [ …58] 6 => array:58 [ …58] 7 => array:58 [ …58] 8 => array:58 [ …58] 9 => array:58 [ …58] 10 => array:58 [ …58] 11 => array:58 [ …58] 12 => array:58 [ …58] 13 => array:58 [ …58] 14 => array:58 [ …58] 15 => array:58 [ …58] 16 => array:58 [ …58] 17 => array:58 [ …58] 18 => array:58 [ …58] 19 => array:58 [ …58] 20 => array:58 [ …58] 21 => array:58 [ …58] 22 => array:58 [ …58] 23 => array:58 [ …58] 24 => array:58 [ …58] 25 => array:58 [ …58] 26 => array:58 [ …58] 27 => array:58 [ …58] 28 => array:58 [ …58] 29 => array:58 [ …58] 30 => array:58 [ …58] 31 => array:58 [ …58] ] +"ID": 130099 } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: "68856" +post_author: 1 +"ListingKey": "1112386026" +"ListingId": "219129347DA" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-14T16:15:12Z" +"RFModificationTimestamp": "2025-06-14T23:01:40.570277+00:00" +"ListPrice": 439000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 4792.0 +"LivingArea": 1230.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "52225 Avenida Martinez, La Quinta, California 92253" +"Coordinates": array:2 [ 0 => -116.307336 1 => 33.668858 ] +"Latitude": 33.668858 +"Longitude": -116.307336 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "JJ Siquot" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "CDAR-D80010" +"ListOfficeMlsId": "CDAR-od23874" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this charming La Quinta Cove home, ideally located on a desirable corner lot with breathtaking mountain views in every direction! The lush, grassed front yard adds to the excellent curb appeal and features several producing citrus trees--Mexican limes, blood oranges, and a tangelo--while the block wall fencing surrounding the property ensures privacy and security. This well-cared-for home offers 1,230 sq ft of comfortable living space, featuring 3 bedrooms and 2 full bathrooms. The open-concept living and dining area is filled with natural light, creating a warm and welcoming atmosphere--ideal for both relaxing and entertaining. The kitchen includes a functional island for prep space or casual dining, granite countertops, newer appliances, and a microwave replaced in 2021--a perfect setup for today's modern lifestyle. Recent upgrades include a new air conditioning system (2021) and newer washer and dryer in the spacious two-car garage. The home is connected to city sewer and natural gas, adding convenience and value. The covered side patio offers a peaceful outdoor retreat, complete with a fruit-bearing tangelo tree for a touch of sweetness, while the generous RV parking area with double gates and extended driveway provides ample space for recreational vehicles, trailers, or guest parking. With stunning views, privacy, and a functional layout, this delightful property is ideal as a primary residence, weekend getaway, or investment opportunity. Come experience the best of desert living in this La Quinta gem!" +"Appliances": "Dishwasher,Disposal,Gas Range,Gas Water Heater,Microwave" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 1964832259 +"ConstructionMaterials": "Plaster" +"ContractStatusChangeDate": "2025-06-13" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-01T14:01:05.753636+00:00" +"DaysOnMarket": 43 +"DaysOnMarketReplication": 43 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "From Eisenhower Drive heading south, turn left onto Calle Sonora. The house is on the first right corner at Calle Sonora and Avenida Martinez. Cross Street: Calle Sonoma." +"DocumentsChangeTimestamp": "2025-05-01T06:02:31Z" +"DoorFeatures": "Sliding Doors" +"Fencing": "Block" +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air,Natural Gas" +"HeatingYN": true +"InteriorFeatures": "Breakfast Bar,Separate/Formal Dining Room,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(310) 980-6781" +"ListAgentEmail": "jjsiquotrealtor@gmail.com" +"ListAgentFirstName": "JJ" +"ListAgentKey": "17308607" +"ListAgentKeyNumeric": "17308607" +"ListAgentLastName": "Siquot" +"ListAgentOfficePhone": "(760) 564-9575" +"ListAgentStateLicense": "01957835" +"ListAgentURL": "http://jjsiquot.bhhscaproperties.com" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "gina.tegland@bhhscaproperties.com" +"ListOfficeKey": "3260771" +"ListOfficeKeyNumeric": "3260771" +"ListOfficePhone": "(760) 564-9575" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-16" +"ListingKeyNumeric": 1112386026 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,Cal Vet Loan,FHA,Fannie Mae,Submit,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Corner Lot,Front Yard,Lawn,Landscaped,Sprinklers Timer,Sprinkler System" +"LotSizeAcres": 0.11 +"LotSizeSource": "Appraiser" +"LotSizeSquareFeet": 4792.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Pending" +"OccupantType": "Vacant" +"OffMarketDate": "2025-06-13" +"OffMarketTimestamp": "2025-06-14T02:04:44Z" +"OnMarketDate": "2025-05-01" +"OnMarketTimestamp": "2025-04-30T23:15:33Z" +"OriginalEntryTimestamp": "2025-05-01T06:02:30Z" +"OriginalListPrice": 439000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374333036" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "773271012" +"ParkingFeatures": "Driveway,Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Brick, Covered" +"PhotosChangeTimestamp": "2025-05-15T19:24:40Z" +"PhotosCount": 40 +"Possession": "Close Of Escrow" +"PostalCodePlus4": "3299" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-06-13" +"RVParkingDimensions": "unkown" +"Roof": "Shingle" +"RoomType": "Living Room,Primary Bedroom,Dining Room" +"ShowingContactName": "JJ Siquot" +"ShowingContactPhone": "310-980-6781" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112386026" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T22:00:00Z" +"StoriesTotal": "1" +"StreetName": "Avenida Martinez" +"StreetNumber": "52225" +"StreetNumberNumeric": "52225" +"SubdivisionName": "La Quinta Cove" +"UniversalPropertyId": "US-06065-N-773271012-R-N" +"Utilities": "Cable Available" +"View": "Mountain(s)" +"ViewYN": true +"WindowFeatures": "Blinds" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Living Room,Primary Suite",\n "EatingArea": "Breakfast Counter / Bar,Dining Room",\n "RoomKitchenFeatures": "Granite Counters,Kitchen Island",\n "RoomBathroomFeatures": "Shower in Tub,Tile Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1112386026",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112386026')" +"CurrentPrice": 439000.0 +"provider_name": "CRMLS" +"RecordSignature": -2076037346 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:773271012" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "363386284" +"OriginatingSystemListAgentMemberKey": "8996536" +"Media": array:40 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] 35 => array:57 [ …57] 36 => array:57 [ …57] 37 => array:57 [ …57] 38 => array:57 [ …57] 39 => array:57 [ …57] ] +"ID": "68856" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: 130100 +post_author: 1 +"ListingKey": "1111679433" +"ListingId": "219128325DA" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T15:21:26Z" +"RFModificationTimestamp": "2025-06-14T23:22:40.130850+00:00" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 3049.0 +"LivingArea": 2596.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "79835 Pecan, La Quinta, California 92253" +"Coordinates": array:2 [ 0 => -116.26876 1 => 33.638221 ] +"Latitude": 33.638221 +"Longitude": -116.26876 +"YearBuilt": 1990 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Karista Smith" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "CDAR-D22155" +"ListOfficeMlsId": "CDAR-oD2174" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Light & Bright Legends Plan 20 | Premier Location in PGA WestWelcome to effortless desert living in one of PGA West's most desirable enclaves. This beautifully appointed Legends Plan 20 offers a spacious and thoughtful layout featuring two primary suites, a third ensuite guest room, and a convenient powder room. Vaulted ceilings add volume and light, while the open-concept design creates a seamless flow throughout the home.Nestled on a quiet cul-de-sac along the 9th fairway of the Jack Nicklaus Private Course, the home enjoys serene golf course views without the interruption of a cart path. A rarely used, large community pool and spa are nearby, offering a resort-style experience just steps away. The two-tier patio is bathed in soft morning light, creating an inviting space for coffee, dining, or simply unwinding.Offered furnished, the home is decorated in calming, neutral tones with stylish shutters and custom paint throughout. The great room includes a sit-down wet bar and a cozy fireplace, perfect for entertaining or relaxing. The kitchen is both functional and charming, featuring an island, a built-in desk area, a breakfast nook, and plenty of storage space.Recent improvements include newer appliances, dual-zone AC units, water heaters, and a state-of-the-art water filtration system--bringing modern comfort and peace of mind to this desert retreat.Located just moments from the private PGA West clubhouse, residents enjoy access to championship golf, upscale dining, tennis, pickleball, fitness facilities, and a dynamic calendar of social events. With HOA-maintained landscaping and a true lock-and-leave lifestyle, this home offers the perfect blend of luxury and convenience.With just a few personal touches, this home becomes an exceptional opportunity and one of the best values in PGA West." +"AssociationAmenities": "Controlled Access,Trash,Cable TV" +"AssociationFee": "934.78" +"AssociationFeeFrequency": "Monthly" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 3 +"CLIP": 2600329112 +"CommunityFeatures": "Golf, Gated, Pool" +"ContractStatusChangeDate": "2025-04-11" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-04-12T05:13:47.603712+00:00" +"DaysOnMarket": 64 +"DaysOnMarketReplication": 64 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Use the Nick gate Cross Street: PGA WEST Blvd." +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure" +"DocumentsChangeTimestamp": "2025-04-11T16:17:20Z" +"Exclusions": "bedding and some art and decor that is staging" +"FireplaceFeatures": "Gas,Great Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"GarageSpaces": "2.5" +"GarageYN": true +"Heating": "Central,Forced Air,Fireplace(s),Natural Gas" +"HeatingYN": true +"InteriorFeatures": "Cathedral Ceiling(s),High Ceilings,Bar" +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 641-6895" +"ListAgentEmail": "ksmithre@live.com" +"ListAgentFirstName": "Karista" +"ListAgentKey": "17296586" +"ListAgentKeyNumeric": "17296586" +"ListAgentLastName": "Smith" +"ListAgentOfficePhone": "(760) 345-2527" +"ListAgentStateLicense": "01311385" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "tony.papillo@camoves.com" +"ListOfficeFax": "(760) 360-1342" +"ListOfficeKey": "3288285" +"ListOfficeKeyNumeric": "3288285" +"ListOfficePhone": "(760) 345-2527" +"ListOfficeURL": "http://www.Coldwell Banker Homes.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-11" +"ListingKeyNumeric": 1111679433 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Planned Unit Development,Sprinklers Timer,Sprinkler System" +"LotSizeAcres": 0.07 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 3049.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-11" +"OnMarketTimestamp": "2025-04-11T09:35:10Z" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2025-04-11T16:17:19Z" +"OriginalListPrice": 775000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374235425" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "762023016" +"ParkingFeatures": "Driveway,Garage,Golf Cart Garage,Garage Door Opener,Side By Side" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-06-14T15:21:42Z" +"PhotosCount": 35 +"PoolFeatures": "Community,Gunite,In Ground" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "5021" +"PreviousListPrice": 775000.0 +"PriceChangeTimestamp": "2025-05-07T20:37:28Z" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Condominium" +"RoomType": "Entry/Foyer,Great Room" +"SecurityFeatures": "Gated Community,24 Hour Security" +"ShowingContactName": "Karista Smith" +"ShowingContactPhone": "760-641-6895" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111679433" +"SpaFeatures": "Community,In Ground" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-10T22:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Pecan" +"StreetNumber": "79835" +"StreetNumberNumeric": "79835" +"SubdivisionName": "PGA Nicklaus Private" +"UniversalPropertyId": "US-06065-N-762023016-R-N" +"View": "Golf Course,Mountain(s)" +"ViewYN": true +"WindowFeatures": "Shutters" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Formal Entry,Great Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1111679433",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111679433')" +"CurrentPrice": 725000.0 +"provider_name": "CRMLS" +"RecordSignature": -418984502 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:762023016" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "8207277" +"OriginatingSystemListAgentMemberKey": "8221219" +"Media": array:35 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] 25 => array:57 [ …57] 26 => array:57 [ …57] 27 => array:57 [ …57] 28 => array:57 [ …57] 29 => array:57 [ …57] 30 => array:57 [ …57] 31 => array:57 [ …57] 32 => array:57 [ …57] 33 => array:57 [ …57] 34 => array:57 [ …57] ] +"ID": 130100 } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: 130101 +post_author: 1 +"ListingKey": "1107670566" +"ListingId": "PTP2501381" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2025-06-14T14:50:54Z" +"RFModificationTimestamp": "2025-06-14T15:51:20.759611+00:00" +"ListPrice": 1945000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 15682.0 +"LivingArea": 3739.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "81380 National Drive, La Quinta, California 92253" +"Coordinates": array:2 [ 0 => -116.24472 …1 ] +"Latitude": 33.644593 +"Longitude": -116.24472 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lezley Jones" +"ListOfficeName": "eXp Realty of California, Inc." +"ListAgentMlsId": "243127" +"ListOfficeMlsId": "87594" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "A Rare Desert Retreat in Norman Estates at PGA West Welcome to refined desert living in the prestigious Norman Estates—an exclusive, double-gated enclave in PGA West, once home to golf legend Greg Norman. This rare offering sits on the 10th fairway of the Greg Norman Course and offers privacy, panoramic views, and effortless elegance. Boasting 5 bedrooms, 5 bathrooms, and over 3,700 sq. ft., the home features soaring ceilings, sun-filled open living areas, and a gourmet kitchen with granite countertops, premium appliances, and an oversized island. A private detached casita serves as a luxury guest suite. Step outside to your own resort-style oasis with a sparkling pool and spa, palapa-covered BBQ island, and multiple patios perfect for relaxing or entertaining. The primary suite is a tranquil retreat with a fireplace, dual walk-in closets, a spa-like bath, and direct pool access. A tucked-away private patio is ideal for quiet mornings or stargazing in the balmy desert evenings. Located in one of La Quinta’s most coveted communities, residents enjoy championship golf, tennis, fitness, and close access to world-class dining, shopping, and events. Don’t miss this rare opportunity to own a slice of paradise in the heart of the desert. Schedule your private tour today." +"AccessibilityFeatures": "Accessible Entrance" +"Appliances": "6 Burner Stove,Built-In Range,Barbecue,Convection Oven,Dishwasher,Disposal,Refrigerator,Range Hood,Water Heater,Dryer,Washer" +"AssociationAmenities": "Maintenance Grounds,Maintenance Front Yard,Pool,Security" +"AssociationFee": "724.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Fairways Association" +"AssociationPhone": "760 862-6334" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "lezleymjones@gmail.com" +"BathroomsFull": 4 +"BuyerAgentAOR": "Palm Springs" +"BuyerAgentDirectPhone": "(760) 656-6142" +"BuyerAgentEmail": "brian@bradysandahl.com" +"BuyerAgentFirstName": "Brian" +"BuyerAgentFullName": "Brian Johnson" +"BuyerAgentKey": "23323811" +"BuyerAgentKeyNumeric": "23323811" +"BuyerAgentLastName": "Johnson" +"BuyerAgentMlsId": "PS02227168" +"BuyerAgentStateLicense": "02227168" +"BuyerFinancing": "Conventional" +"BuyerOfficeAOR": "Palm Springs" +"BuyerOfficeKey": "3111228" +"BuyerOfficeKeyNumeric": "3111228" +"BuyerOfficeMlsId": "PS4760" +"BuyerOfficeName": "Keller Williams Luxury Homes" +"BuyerOfficePhone": "(760) 322-2286" +"CLIP": 3754194198 +"CloseDate": "2025-06-13" +"ClosePrice": 1900000.0 +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Golf" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-06-14T15:50:49.262650+00:00" +"DaysOnMarket": 71 +"DaysOnMarketReplication": 71 +"DaysOnMarketReplicationDate": "2025-06-14" +"DirectionFaces": "South" +"Directions": "Enter through Greg Norman Gate and take immediate right through the secondary gate which is Medalist and that turns into National Drive Cross Street: Madison" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Barbecue, Lighting" +"FireplaceFeatures": "Living Room,Primary Bedroom,Outside" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchoolDistrict": "Desert Sands Unified" +"Inclusions": "Optionally available fully furnished." +"InteriorFeatures": "Bedroom on Main Level,Main Level Primary,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Pacific Southwest" +"ListAgentDirectPhone": "619-746-1669" +"ListAgentEmail": "lezleymjones@gmail.com" +"ListAgentFirstName": "Lezley" +"ListAgentKey": "17159095" +"ListAgentKeyNumeric": "17159095" +"ListAgentLastName": "Jones" +"ListAgentOfficePhone": "888-584-9427" +"ListAgentStateLicense": "01841705" +"ListOfficeAOR": "Pacific Southwest" +"ListOfficeEmail": "deborah.penny@exprealty.net" +"ListOfficeKey": "3287881" +"ListOfficeKeyNumeric": "3287881" +"ListOfficePhone": "888-584-9427" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-02-21" +"ListingKeyNumeric": 1107670566 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Irregular Lot,Lawn,Landscaped,On Golf Course,Sprinkler System,Waterfront,Yard" +"LotSizeAcres": 0.36 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 15682.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Closed" +"OffMarketDate": "2025-05-05" +"OffMarketTimestamp": "2025-05-29T01:17:55Z" +"OnMarketDate": "2025-02-23" +"OnMarketTimestamp": "2025-02-23T00:15:44Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-02-23T08:07:24Z" +"OriginalListPrice": 2100000.0 +"OriginatingSystemID": "CRP" +"OriginatingSystemKey": "373981420" +"OriginatingSystemSubName": "CRMLS_CRP" +"OtherStructures": "Guest House" +"ParcelNumber": "780230010" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-06-14T14:51:42Z" +"PhotosCount": 42 +"PoolFeatures": "In Ground,Private,Waterfall,Association" +"PoolPrivateYN": true +"PreviousListPrice": 1945000.0 +"PriceChangeTimestamp": "2025-06-13T17:00:00Z" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-05-05" +"Roof": "Spanish Tile" +"RoomType": "Bedroom,Kitchen,Laundry,Primary Bathroom,Primary Bedroom,Other" +"Sewer": "Public Sewer" +"ShowingContactName": "Lezley Jones" +"ShowingContactPhone": "619-746-1669" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1107670566" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "National" +"StreetNumber": "81380" +"StreetNumberNumeric": "81380" +"StreetSuffix": "Drive" +"TaxBlock": "Lot 38 Mb 292/060 Tr 2965" +"UniversalPropertyId": "US-06065-N-780230010-R-N" +"View": "Golf Course,Mountain(s),Pond" +"ViewYN": true +"VirtualTourURLUnbranded": "https://81380National Dr.com/idx" +"WaterfrontFeatures": "Waterfront" +"WaterfrontYN": true +"YearBuiltSource": "Assessor" +"Zoning": "A120" +"CustomFields": """ {\n "RoomType": "Kitchen,Laundry,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom,Walk-In Closet",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1107670566"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1107670566')" +"CurrentPrice": 1900000.0 +"provider_name": "CRMLS" +"short_address": "La Quinta, California 92253, US" +"RecordSignature": -817136567 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:780230010" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "129543937" +"OriginatingSystemBuyerOfficeKey": "133503" +"OriginatingSystemListAgentMemberKey": "363072790" +"OriginatingSystemBuyerAgentMemberKey": "372451216" +"Media": array:42 [ …42] +"ID": 130101 } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: 130102 +post_author: 1 +"ListingKey": "1111449403" +"ListingId": "IN25076474" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2025-06-14T12:33:53Z" +"RFModificationTimestamp": "2025-06-14T14:28:37.324183+00:00" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 4792.0 +"LivingArea": 1624.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "52394 Avenida Juarez, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.667761 +"Longitude": -116.31636 +"YearBuilt": 1994 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "KAHLIL MCALPIN" +"ListOfficeName": "Kahlil J. McAlpin" +"ListAgentMlsId": "NMCALKAH" +"ListOfficeMlsId": "N1712" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "A very charming 4 bedroom house with a pool in the front yard and a roof patio over the garage. The house has Spanish tiles throughout and very nice mountain view from the master bedroom and the TV Room. While the records state the house has 4 bedrooms, the 4th bedroom does not have a closet and is used by the owners as a TV Room that looks out to the pool. Small backyard and side yard and 2 car garage with washer and dryers the garage." +"ActivationDate": "2025-04-08" +"Appliances": "Dishwasher,Electric Cooktop,Disposal,Gas Oven,Gas Water Heater,Microwave,Refrigerator,Dryer,Washer" +"AttachedGarageYN": true +"AttributionContact": "310-350-7836" +"BathroomsFull": 2 +"BuyerAgentAOR": "Citrus Valley" +"BuyerAgentEmail": "1ruthsoto@gmail.com" +"BuyerAgentFirstName": "Ruth" +"BuyerAgentFullName": "Ruth Soto" +"BuyerAgentKey": "17247855" +"BuyerAgentKeyNumeric": "17247855" +"BuyerAgentLastName": "Soto" +"BuyerAgentMlsId": "CV39609" +"BuyerAgentStateLicense": "01770759" +"BuyerFinancing": "Cash to New Loan" +"BuyerOfficeAOR": "Citrus Valley" +"BuyerOfficeEmail": "vkyan@rmasters.com" +"BuyerOfficeKey": "3288755" +"BuyerOfficeKeyNumeric": "3288755" +"BuyerOfficeMlsId": "51549" +"BuyerOfficeName": "REALTY MASTERS & ASSOCIATES" +"BuyerOfficePhone": "909-993-5710" +"CLIP": 9245218445 +"CloseDate": "2025-06-09" +"ClosePrice": 560000.0 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking, Golf, Hiking" +"ContractStatusChangeDate": "2025-06-09" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-04-09T09:19:32.975617+00:00" +"CumulativeDaysOnMarket": 20 +"DaysOnMarket": 20 +"DaysOnMarketReplication": 20 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "10 blocks West of Eisenhower and between Calle Ensenada & Calle Sonora" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room" +"FireplaceYN": true +"Flooring": "Tile" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Desert Sands Unified" +"InteriorFeatures": "Ceiling Fan(s),High Ceilings,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Inglewood" +"ListAgentDirectPhone": "310-338-0554" +"ListAgentEmail": "kahlil24@aol.com" +"ListAgentFax": "310-338-0527" +"ListAgentFirstName": "KAHLIL" +"ListAgentKey": "17039291" +"ListAgentKeyNumeric": "17039291" +"ListAgentLastName": "MCALPIN" +"ListAgentOfficePhone": "424-260-6071" +"ListAgentStateLicense": "01129390" +"ListOfficeAOR": "Inglewood" +"ListOfficeFax": "424-203-6071" +"ListOfficeKey": "3178724" +"ListOfficeKeyNumeric": "3178724" +"ListOfficePhone": "424-260-6071" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-05" +"ListingKeyNumeric": 1111449403 +"ListingService": "Full Service" +"ListingTerms": "Cash to New Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.11 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 4792.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-14T00:09:32Z" +"MajorChangeType": "Closed" +"MlsStatus": "Closed" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-04-28" +"OffMarketTimestamp": "2025-04-28T17:17:22Z" +"OnMarketDate": "2025-04-08" +"OnMarketTimestamp": "2025-04-08T23:23:39Z" +"OriginalEntryTimestamp": "2025-04-07T21:55:37Z" +"OriginalListPrice": 550000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374206338" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "773251009" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-08T05:19:40Z" +"PhotosCount": 32 +"PoolFeatures": "In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "3224" +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-04-28" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactName": "Kahlil McAlpin" +"ShowingContactPhone": "310.350.7836" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111449403" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-04-08" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-14T00:09:32Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Avenida Juarez" +"StreetNumber": "52394" +"StreetNumberNumeric": "52394" +"StructureType": "House" +"TaxBlock": "8" +"TaxLot": "14" +"UniversalPropertyId": "US-06065-N-773251009-R-N" +"Utilities": "Propane" +"View": "Desert, Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"Zoning": "R1" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "RoomBathroomFeatures": "Bathtub",\n "AdminUpdateYN": "0",\n "ListingKey": "1111449403",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111449403')" +"CurrentPrice": 560000.0 +"provider_name": "CRMLS" +"RecordSignature": 1145360193 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:773251009" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "18475" +"OriginatingSystemBuyerOfficeKey": "92724226" +"OriginatingSystemListAgentMemberKey": "197663" +"OriginatingSystemBuyerAgentMemberKey": "87575649" +"Media": array:32 [ …32] +"ID": 130102 } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: 130103 +post_author: 1 +"ListingKey": "1117366538" +"ListingId": "219131466DA" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T12:13:03Z" +"RFModificationTimestamp": "2025-06-14T14:43:49.213337+00:00" +"ListPrice": 409000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 2614.0 +"LivingArea": 1280.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "79495 Horizon Palms Circle, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.728684 +"Longitude": -116.278949 +"YearBuilt": 1987 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brooke Baxley-Salas" +"ListOfficeName": "Desert Properties Realtors" +"ListAgentMlsId": "CDAR-D21916" +"ListOfficeMlsId": "CDAR-oD21732" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This South facing, renovated 3 bedroom, 3 full bath home is situated behind the gates of the highly sought after La Quinta Palms community. The 3rd bedroom is currently set up as a rental and has its own private entrance, kitchenette and en-suite bathroom perfect for guests, renter or an extra private primary bedroom.The kitchen has quartz countertops, upgraded cabinetry and stainless steel appliances. The open floor plan provides a comfortable setting for gatherings with family and friends. The bathrooms have upgraded cabinetry and tile showers and each bedroom has its own bath. As you step out onto the back patio you'll enjoy southern mountain and pool views. La Quinta Palms offers pools, Tennis and Pickleball courts, a putting green, extensive green belts and citrus trees and is located steps away from the IW Tennis Garden, shopping, Golf courses, Schools and Parks." +"Appliances": "Dishwasher,Electric Cooktop,Electric Oven,Microwave,Refrigerator" +"ArchitecturalStyle": "Mediterranean" +"AssociationAmenities": "Controlled Access,Management,Pet Restrictions,Security,Tennis Court(s),Trash" +"AssociationFee": "483.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "La Quinta Palms Homeowners Association" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 1 +"BathroomsThreeQuarter": 2 +"CLIP": 4281010304 +"CommunityFeatures": "Gated, Pool" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-05-12" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-06-14T02:48:07.530082+00:00" +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Fred Waring East to La Quinta Palms Cross Street: Fred Waring." +"Disclosures": "HOA Disclosure" +"DocumentsChangeTimestamp": "2025-06-13T14:31:42Z" +"DoorFeatures": "Sliding Doors" +"ElementarySchool": "Amelia Earhart" +"Flooring": "Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"HighSchool": "La Quinta" +"InteriorFeatures": "Multiple Primary Suites" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 399-7885" +"ListAgentEmail": "brookesalasre@gmail.com" +"ListAgentFirstName": "Brooke" +"ListAgentKey": "17316321" +"ListAgentKeyNumeric": "17316321" +"ListAgentLastName": "Baxley-Salas" +"ListAgentOfficePhone": "(760) 636-5020" +"ListAgentStateLicense": "01896390" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "realpropmarlene@gmail.com" +"ListOfficeFax": "(760) 636-5023" +"ListOfficeKey": "3229739" +"ListOfficeKeyNumeric": "3229739" +"ListOfficePhone": "(760) 636-5020" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-12" +"ListingKeyNumeric": 1117366538 +"ListingService": "Full Service" +"ListingTerms": "Cash to New Loan" +"LivingAreaSource": "Other" +"LotFeatures": "Drip Irrigation/Bubblers,Greenbelt,Planned Unit Development,Sprinkler System" +"LotSizeAcres": 0.06 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 2614.0 +"MLSAreaMajor": "308 - La Quinta North of HWY 111, Indian Springs" +"MiddleOrJuniorSchool": "John Glenn" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-13" +"OnMarketTimestamp": "2025-06-13T07:44:42Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-06-13T14:31:42Z" +"OriginalListPrice": 409000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374583418" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "604100006" +"ParkingFeatures": "Driveway, Guest" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-06-13T21:57:45Z" +"PhotosCount": 27 +"PoolFeatures": "Community,Electric Heat,In Ground" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "3908" +"PropertyAttachedYN": true +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Tile" +"RoomType": "Guest Quarters,Primary Bedroom" +"SecurityFeatures": "Gated Community,Security Lights" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117366538" +"SpaFeatures": "Heated,In Ground" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T22:00:00Z" +"StoriesTotal": "1" +"StreetName": "Horizon Palms" +"StreetNumber": "79495" +"StreetNumberNumeric": "79495" +"StreetSuffix": "Circle" +"SubdivisionName": "La Quinta Palms" +"UniversalPropertyId": "US-06065-N-604100006-R-N" +"View": "Mountain(s), Pool" +"ViewYN": true +"WindowFeatures": "Blinds" +"YearBuiltSource": "See Remarks" +"CustomFields": """ {\n "RoomType": "Guest/Maid\u0027s Quarters,Two Primaries",\n "EatingArea": "In Living Room",\n "RoomKitchenFeatures": "Kitchenette,Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Tile Counters",\n "AdminUpdateYN": "0",\n "ListingKey": "1117366538",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117366538')" +"CurrentPrice": 409000.0 +"provider_name": "CRMLS" +"RecordSignature": -885256017 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:604100006" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "8206455" +"OriginatingSystemListAgentMemberKey": "8221093" +"Media": array:27 [ …27] +"ID": 130103 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: 130104 +post_author: 1 +"ListingKey": "1117357420" +"ListingId": "219131454DA" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T12:13:03Z" +"RFModificationTimestamp": "2025-06-14T14:44:37.928646+00:00" +"ListPrice": 815000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 4356.0 +"LivingArea": 1591.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "77489 Avenida Madrugada, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.684463 +"Longitude": -116.310426 +"YearBuilt": 1982 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Carol-Lynne Mittelbusher" +"ListOfficeName": "California Lifestyle Realty" +"ListAgentMlsId": "CDAR-D72782" +"ListOfficeMlsId": "CDAR-oD2470" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Embrace your dream of the desert! This rare location is a light-filled extravagance of mountain views, seldom found in this three-bedroom Chapala model! Volume ceilings emphasize the spacious living-dining area, which offers ample room for entertaining. A charming fireplace enhances the appeal on those chilly mornings, and a patio opens onto a green space alive with Bougainvillea and fruit trees. The nearby pool and spa beckon you to enjoy a few laps or a relaxing soak after a game of golf, pickleball, or tennis! Encircled by the Santa Rosa Mountains, every room of this beautiful home offers a view! The spacious master suite boasts a romantic fireplace, and opens to a serene private patio. Dual closets and a recently redone bath with a double vanity and an oversize step-in shower complete the luxurious feel. Your guests will enjoy the serenity of the second bedroom adjoining the hall bath, which has also benefited from a recent contemporary remodel. The current sitting room/office space can easily be converted to a third bedroom, perfect for the friends who want to share in your new lifestyle! Santa Rosa cove offers 10 pools and spas, 3 tennis courts, and enviable proximity to the La Quinta Resort and Old Town La Quinta. Two golf courses wind through the community, and the Pete Dye Clubhouse is on site for dining, drinks and events. Your desert dream begins here!" +"Appliances": "Dishwasher,Electric Range,Disposal,Gas Water Heater,Microwave,Refrigerator,Range Hood,Vented Exhaust Fan" +"ArchitecturalStyle": "Spanish" +"AssociationAmenities": "Controlled Access,Maintenance Grounds,Management,Pet Restrictions,Security,Tennis Court(s)" +"AssociationFee": "730.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Santa Rosa Cove HOA" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuilderModel": "Chapala" +"CLIP": 2215549294 +"CommunityFeatures": "Golf, Gated, Pool" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-06-13T22:50:42.639980+00:00" +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "South on Eisenhower from 111. Right through Santa Rosa Coave gate at Ave 50.Straight to second left; home is on the corner.one of Cross Street: Calle Mazatlan." +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure,Pet Restrictions" +"DocumentsChangeTimestamp": "2025-06-13T12:16:18Z" +"DoorFeatures": "Double Door Entry,Sliding Doors" +"EntryLevel": 1 +"Exclusions": "personal items, mementos" +"Fencing": "None" +"FireplaceFeatures": "Gas,Living Room,Primary Bedroom" +"FireplaceYN": true +"Flooring": "Carpet, Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air,Natural Gas" +"HeatingYN": true +"Inclusions": "Furnishings, accessories and artwork per written inventory." +"InteriorFeatures": "Breakfast Area,Cathedral Ceiling(s),Separate/Formal Dining Room,High Ceilings,Primary Suite,Utility Room" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "One" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 449-6216" +"ListAgentEmail": "lqhomz@gmail.com" +"ListAgentFax": "(760) 771-3087" +"ListAgentFirstName": "Carol-Lynne" +"ListAgentKey": "17317774" +"ListAgentKeyNumeric": "17317774" +"ListAgentLastName": "Mittelbusher" +"ListAgentOfficePhone": "(760) 564-1200" +"ListAgentStateLicense": "01748955" +"ListAgentURL": "http://www.LQHOMZ.com" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "toni.holliday@waldorfastoria.com" +"ListOfficeFax": "(760) 564-0200" +"ListOfficeKey": "3251988" +"ListOfficeKeyNumeric": "3251988" +"ListOfficePhone": "(760) 564-1200" +"ListOfficeURL": "http://www.californialifestylerealty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-13" +"ListingKeyNumeric": 1117357420 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Corner Lot,Drip Irrigation/Bubblers,Front Yard,Greenbelt,Lawn,Landscaped,Planned Unit Development,Sprinklers Timer,Sprinkler System" +"LotSizeAcres": 0.1 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 4356.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "334" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-13" +"OnMarketTimestamp": "2025-06-13T05:28:55Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-06-13T12:16:17Z" +"OriginalListPrice": 815000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374581482" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "773340042" +"ParkingFeatures": "Driveway,Garage,Garage Door Opener,Side By Side" +"ParkingTotal": "6.0" +"PatioAndPorchFeatures": "Concrete, Covered" +"PhotosChangeTimestamp": "2025-06-13T19:45:45Z" +"PhotosCount": 36 +"PoolFeatures": "Community,Gunite,Electric Heat,In Ground" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "2602" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Condominium" +"Roof": "Clay, Elastomeric" +"RoomType": "Entry/Foyer,Great Room,Primary Bedroom,Utility Room,Dining Room" +"SecurityFeatures": "Gated Community" +"ShowingContactName": "Carol-Lynne Mittelbusher" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117357420" +"SpaFeatures": "Community,Gunite,Heated,In Ground" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T22:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Avenida Madrugada" +"StreetNumber": "77489" +"StreetNumberNumeric": "77489" +"SubdivisionName": "Santa Rosa Cove Coun" +"UniversalPropertyId": "US-06065-N-773340042-R-N" +"Utilities": "Cable Available" +"View": "Park/Greenbelt, Mountain(s)" +"ViewYN": true +"WindowFeatures": "Blinds" +"YearBuiltSource": "Assessor" +"Zoning": "R-2" +"CustomFields": """ {\n "RoomType": "Entry,Utility Room,Great Room,Primary Suite",\n "EatingArea": "Breakfast Nook,Dining Room",\n "RoomKitchenFeatures": "Tile Counters",\n "RoomBathroomFeatures": "Remodeled,Low Flow Toilet(s),Low Flow Shower,Vanity area",\n "AdminUpdateYN": "0",\n "ListingKey": "1117357420",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117357420')" +"CurrentPrice": 815000.0 +"provider_name": "CRMLS" +"RecordSignature": -511041542 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:773340042" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "8207464" +"OriginatingSystemListAgentMemberKey": "8212532" +"Media": array:36 [ …36] +"ID": 130104 } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: 130105 +post_author: 1 +"ListingKey": "1112519890" +"ListingId": "219129467DA" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T12:13:03Z" +"RFModificationTimestamp": "2025-06-14T14:46:10.133685+00:00" +"ListPrice": 597000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 5227.0 +"LivingArea": 1248.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "54125 Avenida Ramirez, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.65533 +"Longitude": -116.311768 +"YearBuilt": 1982 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Amirah Halum" +"ListOfficeName": "Compass" +"ListAgentMlsId": "CDAR-D79279" +"ListOfficeMlsId": "CDAR-oD23728" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Nestled high in the desirable La Quinta Cove. This all-electric residence blends sustainable living with modern comfort and stunning mountain views. Designed with energy efficiency in mind, the property also offers the potential for solar installation--perfect for those seeking a greener footprint.Step outside into a resort-style home featuring a sparkling pool and spa, a putting green, cozy fire pit, and a lush lawn--ideal for hosting or relaxing under the stars. Inside, the open-concept floor plan is equally impressive with spacious living and dining areas, ideal for entertaining. Enjoy movie nights with a built-in 65'' Samsung Smart TV and seamless indoor-outdoor flow.Surrounded by scenic hiking and biking trails, including Bear Creek and the Cove to Lake Trailhead, this home is perfect for nature lovers and adventure seekers. Located minutes from world-class golf courses, restaurants, art galleries, and Old Town La Quinta, this home offers the best of desert living. Whether you're looking for a full-time residence, vacation getaway, or investment property, this home checks every box." +"Appliances": "Electric Cooktop,Electric Oven,Refrigerator,Range Hood" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 1963172929 +"ContractStatusChangeDate": "2025-05-02" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-02T20:20:05.255474+00:00" +"DaysOnMarket": 43 +"DaysOnMarketReplication": 43 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "From I-10 East, exit at Washington St and head south for 6.5 miles. Turn left onto Avenue 52, right onto Avenida Bermudas, then left onto Calle Sinaloa. Turn right onto Avenida Ramirez. 54125 Avenida Ramirez will be on the left. Cross Street: Calle Chillon and Madrid." +"DocumentsChangeTimestamp": "2025-05-02T12:20:57Z" +"DoorFeatures": "Sliding Doors" +"Fencing": "Block" +"Flooring": "Laminate" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"Inclusions": "Fully furnished" +"InteriorFeatures": "Breakfast Bar,Separate/Formal Dining Room" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 625-7247" +"ListAgentEmail": "amirah.halum@gmail.com" +"ListAgentFirstName": "Amirah" +"ListAgentKey": "17304523" +"ListAgentKeyNumeric": "17304523" +"ListAgentLastName": "Halum" +"ListAgentOfficePhone": "(760) 249-2120" +"ListAgentStateLicense": "01945548" +"ListAgentURL": "http://camoves.com/amirah.halum" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "george.rider@compass.com" +"ListOfficeKey": "3254138" +"ListOfficeKeyNumeric": "3254138" +"ListOfficePhone": "(760) 249-2120" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-02" +"ListingKeyNumeric": 1112519890 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,FHA" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Drip Irrigation/Bubblers,Front Yard,Landscaped" +"LotSizeAcres": 0.12 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5227.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-02" +"OnMarketTimestamp": "2025-05-02T05:30:20Z" +"OpenParkingSpaces": "1.0" +"OriginalEntryTimestamp": "2025-05-02T12:20:56Z" +"OriginalListPrice": 619000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374346789" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "774211018" +"ParkingFeatures": "Driveway,Garage,Garage Door Opener,On Street" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete" +"PhotosChangeTimestamp": "2025-05-02T19:57:51Z" +"PhotosCount": 25 +"PoolFeatures": "In Ground" +"PoolPrivateYN": true +"PostalCodePlus4": "3623" +"PreviousListPrice": 619000.0 +"PriceChangeTimestamp": "2025-05-22T09:16:20Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Living Room,Dining Room" +"ShowingContactName": "Amirah" +"ShowingContactPhone": "Halum" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112519890" +"SpaFeatures": "Heated,In Ground" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-01T22:00:00Z" +"StoriesTotal": "1" +"StreetName": "Avenida Ramirez" +"StreetNumber": "54125" +"StreetNumberNumeric": "54125" +"SubdivisionName": "La Quinta Cove" +"UniversalPropertyId": "US-06065-N-774211018-R-N" +"View": "Mountain(s)" +"ViewYN": true +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Living Room",\n "EatingArea": "Dining Room,Breakfast Counter / Bar",\n "RoomBathroomFeatures": "Low Flow Shower,Tile Counters,Shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1112519890",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112519890')" +"CurrentPrice": 597000.0 +"provider_name": "CRMLS" +"RecordSignature": 401052143 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:774211018" +"CountrySubdivision": "06065" +"OriginatingSystemListOfficeKey": "361438344" +"OriginatingSystemListAgentMemberKey": "8224845" +"Media": array:25 [ …25] +"ID": 130105 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4016 +post_id: "101345" +post_author: 1 +"ListingKey": "1115016270" +"ListingId": "219131157DA" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T12:13:03Z" +"RFModificationTimestamp": "2025-06-14T14:46:09.629700+00:00" +"ListPrice": 420000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 5227.0 +"LivingArea": 1282.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "54205 Avenida Martinez, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.654762 +"Longitude": -116.307368 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jennifer Caridi" +"ListOfficeName": "Bennion Deville Homes" +"ListAgentMlsId": "CDAR-D76294" +"ListOfficeMlsId": "CDAR-oD8051" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Great opportunity to buy a home high in the La Quinta Cove. Prime location, quiet street with stunning mountain views. This 3 bedroom, 2 bathroom home has saltillo tiles & wood shutters throughout. French doors open to a covered patio in the backyard. 2 car attached garage." +"Appliances": "Dishwasher,Electric Cooktop,Electric Oven" +"AttachedGarageYN": true +"BackOnMarketDate": "2025-06-13" +"BathroomsFull": 2 +"CLIP": 4028297828 +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-06-06" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-06-13T17:59:46.752353+00:00" +"DaysOnMarket": 5 +"DaysOnMarketReplication": 5 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Avenida Bermudas south to Calle Madrid turn right, second street Avenida Martinez turn right, house is 3rd down on the left Cross Street: Calle Madrid." +"DocumentsChangeTimestamp": "2025-06-06T10:15:14Z" +"DoorFeatures": "French Doors" +"Fencing": "Block" +"Flooring": "Carpet, Tile" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Forced Air" +"HeatingYN": true +"InteriorFeatures": "Breakfast Area,Separate/Formal Dining Room,All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 391-3099" +"ListAgentEmail": "jencaridi@gmail.com" +"ListAgentFirstName": "Jennifer" +"ListAgentKey": "17138708" +"ListAgentKeyNumeric": "17138708" +"ListAgentLastName": "Caridi" +"ListAgentOfficePhone": "(760) 773-3958" +"ListAgentStateLicense": "01875575" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "coachellavalley@BDHomes.com" +"ListOfficeFax": "(760) 773-3959" +"ListOfficeKey": "3232886" +"ListOfficeKeyNumeric": "3232886" +"ListOfficePhone": "(760) 773-3958" +"ListOfficeURL": "http://www.BDHomes.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1115016270 +"ListingService": "Full Service" +"ListingTerms": "Cash to New Loan,Conventional,FHA" +"LivingAreaSource": "Assessor" +"LotFeatures": "Sprinklers Timer" +"LotSizeAcres": 0.12 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 5227.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MlsStatus": "Active" +"OffMarketDate": "2025-06-08" +"OffMarketTimestamp": "2025-06-09T05:29:52Z" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T03:30:38Z" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-06-06T10:15:13Z" +"OriginalListPrice": 420000.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374542753" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "774221022" +"ParkingFeatures": "Driveway" +"ParkingTotal": "4.0" +"PatioAndPorchFeatures": "Concrete" +"PhotosChangeTimestamp": "2025-06-06T17:49:40Z" +"PhotosCount": 24 +"Possession": "Close Plus 2 Days,Negotiable" +"PostalCodePlus4": "6603" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Living Room,Dining Room" +"ShowingContactName": "Jennifer Caridi" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115016270" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T22:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Avenida Martinez" +"StreetNumber": "54205" +"StreetNumberNumeric": "54205" +"SubdivisionName": "La Quinta Cove" +"UniversalPropertyId": "US-06065-N-774221022-R-N" +"View": "Mountain(s)" +"ViewYN": true +"WindowFeatures": "Shutters" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Living Room,All Bedrooms Down",\n "EatingArea": "Breakfast Nook,Dining Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1115016270",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115016270')" +"CurrentPrice": 420000.0 +"provider_name": "CRMLS" +"RecordSignature": -909556962 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:774221022" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "8204005" +"OriginatingSystemListAgentMemberKey": "8229234" +"Media": array:24 [ …24] +"ID": "101345" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4017 +post_id: 130106 +post_author: 1 +"ListingKey": "1112571270" +"ListingId": "219129564DA" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Closed" +"ModificationTimestamp": "2025-06-14T12:13:03Z" +"RFModificationTimestamp": "2025-06-14T14:48:22.827081+00:00" +"ListPrice": 864900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 13068.0 +"LivingArea": 3001.0 +"BuildingAreaTotal": 0 +"City": "La Quinta" +"PostalCode": "92253" +"UnparsedAddress": "57730 Cantata Drive, La Quinta, California 92253" +"Coordinates": array:2 [ …2] +"Latitude": 33.629415 +"Longitude": -116.236954 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Albert Catalano" +"ListOfficeName": "Century 21 Affiliated" +"ListAgentMlsId": "CDAR-d86159" +"ListOfficeMlsId": "CDAR-d24402" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to this beautifully maintained 3,001 sq. ft. residence located in the gated community of Piazza Serena. This spacious home features 3 bedrooms, 3 full bathrooms, and a powder room, with an optional 4th bedroom that can be easily converted--ideal for a home office, den, or guest space.Set on one of the community's largest lots (13,068 sq. ft.), this property offers breathtaking views of the Santa Rosa Mountains and an expansive backyard designed for entertaining. Enjoy a resort-style swimmer's pool with a Baja shelf perfect for sunbathing or umbrella lounging, a soothing waterfall feature, and a spa with fiber optic lighting--all controlled by a state-of-the-art remote system.Inside, the gourmet kitchen is perfect for home chefs, and the spacious primary suite includes a flexible retreat space that can serve as an office or be converted into an additional bedroom. A 3-car garage provides ample storage and convenience.With low HOA dues and an exceptional layout on a prime lot, this home offers both luxury and value. The beautifully landscaped yard includes a multiple-hole putting green, making it a perfect desert oasis." +"AssociationAmenities": "Controlled Access,Picnic Area" +"AssociationFee": "100.0" +"AssociationFeeFrequency": "Monthly" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 3 +"BuyerAgentAOR": "The Inland Gateway" +"BuyerAgentDirectPhone": "951-433-0372" +"BuyerAgentEmail": "christine@christinehomesales.com" +"BuyerAgentFirstName": "Christine" +"BuyerAgentFullName": "Christine Bati" +"BuyerAgentKey": "17203447" +"BuyerAgentKeyNumeric": "17203447" +"BuyerAgentLastName": "Bati" +"BuyerAgentMlsId": "IGBATICHR" +"BuyerAgentStateLicense": "02091672" +"BuyerAgentURL": "https://christine.kellymclarenproperties.com/" +"BuyerOfficeAOR": "The Inland Gateway" +"BuyerOfficeEmail": "Lisa.Schulz@rrector.com" +"BuyerOfficeKey": "3288212" +"BuyerOfficeKeyNumeric": "3288212" +"BuyerOfficeMlsId": "KROG01" +"BuyerOfficeName": "Realty ONE Group West" +"BuyerOfficePhone": "951-547-8400" +"CLIP": 7861776390 +"CloseDate": "2025-06-13" +"ClosePrice": 855000.0 +"CommunityFeatures": "Gated" +"ContractStatusChangeDate": "2025-06-13" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Riverside" +"CreationDate": "2025-05-05T00:55:56.564826+00:00" +"DaysOnMarket": 15 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2025-06-14" +"Directions": "Interstate 10 east exit Monroe St right, take Monroe pass Hwy 111, pass Airport, right on Ave 58 then right on Pasatiempo Ct, left on IL Serenata Dr and a right on Cantata Dr. Home will be on your right hand side. Cross Street: Monroe Ave & 58th." +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure,Pet Restrictions" +"DocumentsChangeTimestamp": "2025-05-04T16:37:39Z" +"Exclusions": "Some personal Items" +"FireplaceFeatures": "Gas Starter,Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Tile" +"GarageSpaces": "3.0" +"GarageYN": true +"Heating": "Forced Air,Fireplace(s)" +"HeatingYN": true +"HighSchool": "La Quinta" +"HighSchoolDistrict": "Desert Sands Unified" +"Inclusions": "Furnished per seller inventory" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentAOR": "California Desert" +"ListAgentDirectPhone": "(760) 969-2916" +"ListAgentEmail": "albertcatalano1@gmail.com" +"ListAgentFirstName": "Albert" +"ListAgentKey": "26094094" +"ListAgentKeyNumeric": "26094094" +"ListAgentLastName": "Catalano" +"ListAgentOfficePhone": "(619) 471-2000" +"ListAgentStateLicense": "02253921" +"ListOfficeAOR": "California Desert" +"ListOfficeEmail": "ca.broker@c21affiliated.com" +"ListOfficeKey": "5209450" +"ListOfficeKeyNumeric": "5209450" +"ListOfficePhone": "(619) 471-2000" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-02" +"ListingKeyNumeric": 1112571270 +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Sprinkler System" +"LotSizeAcres": 0.3 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 13068.0 +"MLSAreaMajor": "313 - La Quinta South of HWY 111" +"MiddleOrJuniorSchool": "John Glenn" +"MlsStatus": "Closed" +"OccupantType": "Vacant" +"OffMarketDate": "2025-05-18" +"OffMarketTimestamp": "2025-05-19T01:50:34Z" +"OnMarketDate": "2025-05-04" +"OnMarketTimestamp": "2025-05-04T09:55:35Z" +"OpenParkingSpaces": "5.0" +"OriginalEntryTimestamp": "2025-05-04T16:37:38Z" +"OriginalListPrice": 864900.0 +"OriginatingSystemID": "CDAR" +"OriginatingSystemKey": "374354562" +"OriginatingSystemSubName": "CRMLS_CDAR" +"ParcelNumber": "764470053" +"ParkingFeatures": "Driveway,Garage,Garage Door Opener" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-05-08T02:28:40Z" +"PhotosCount": 27 +"PoolFeatures": "Electric Heat,In Ground,Waterfall" +"PoolPrivateYN": true +"PropertySubTypeAdditional": "Single Family Residence" +"PurchaseContractDate": "2025-05-19" +"RoomType": "Den,Entry/Foyer,Family Room,Game Room,Living Room" +"SecurityFeatures": "Gated Community" +"ShowingContactName": "Albert Catalano" +"ShowingContactPhone": "760-969-2916" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112571270" +"SpaFeatures": "Heated,In Ground" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T22:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Cantata" +"StreetNumber": "57730" +"StreetNumberNumeric": "57730" +"StreetSuffix": "Drive" +"SubdivisionName": "Piazza Serena" +"UniversalPropertyId": "US-06065-N-764470053-R-N" +"View": "Mountain(s)" +"ViewYN": true +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Game Room,Living Room,Formal Entry,Family Room,Den",\n "AdminUpdateYN": "0",\n "ListingKey": "1112571270",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112571270')" +"CurrentPrice": 855000.0 +"provider_name": "CRMLS" +"RecordSignature": -555602463 +"UniversalParcelId": "urn:reso:upi:2.0:US:06065:764470053" +"CountrySubdivision": "06065" +"PreviousStandardStatus": "Pending" +"OriginatingSystemListOfficeKey": "371626380" +"OriginatingSystemBuyerOfficeKey": "114957" +"OriginatingSystemListAgentMemberKey": "374032516" +"OriginatingSystemBuyerAgentMemberKey": "362842113" +"Media": array:27 [ …27] +"ID": 130106 } ] +success: true +page_size: 10 +page_count: 1128 +count: 11278 +after_key: "" } "RF Response Time" => "0.32 seconds" ] "RF Cache Key: 6fcb4f7485c5bdec065815991a46b1e8a6c434d8af56de05b7c48dd93c89de8f" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4005 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4016} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4017} ] +success: true +page_size: 10 +page_count: 1128 +count: 11278 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5512 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5507 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112308116" +"ListingId": "25531679" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:19.378602+00:00" +"ListPrice": 414500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5320.0 +"LivingArea": 726.0 +"BuildingAreaTotal": 726.0 +"City": "San Bernardino" +"PostalCode": "92411" +"UnparsedAddress": "1256 W 6th Street, San Bernardino, California 92411" +"Coordinates": array:2 [ …2] +"Latitude": 34.110461 +"Longitude": -117.312781 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eran Fattal" +"ListOfficeName": "Dynasty Real Estate" +"ListAgentMlsId": "CLW-C103971" +"ListOfficeMlsId": "CLW-X78890" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "REMODELED FHA APPROVED HOME: 3 BEDS PLUS 1.5 BATH. (PUBLIC RECORDS SHOW 2 PLUS 1) NEW DUAL PANE WINDOWS. REPLACED CENTRAL AIR AND HEAT. NEW CUSTOM PORCELAIN TILE FLOORING IN KITCHEN, LIVING ROOM, BATHROOMS, AND LAUNDRY ROOM. NEW GRAY RUSTIC STYLE LAMINATE FLOORING IN BEDROOMS. THE KITCHEN IS BRAND NEW. NEW CUSTOM KITCHEN CABINETS, NEW QUARTZ STONE COUNTERS, NEW GARBAGE DISPOSAL, NEW PULL-OUT FAUCET. NEW BATHTUB, NEW TILED UP SHOWERS WALLS WITH ELEGANT MOSAIC DESIGN, NEW VANITIES. NEW TOILETS. ALL NEW PLUMBING FIXTURES. NEW LIGHT FIXTURES. NEW PAINT INSIDE AND OUT. NEW GARAGE DOOR. FHA/VA/DOWN PAYMENT ASSISTANCE/OK" +"Appliances": "Disposal" +"ArchitecturalStyle": "See Remarks" +"BathroomsFull": 1 +"BuyerFinancing": "Conventional, FHA, VA" +"CLIP": 8804738686 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-29T19:32:38.644803+00:00" +"DaysOnMarket": 46 +"DaysOnMarketReplication": 46 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "PLEASE REFER TO GOOGLE MAPS" +"FireplaceFeatures": "None" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Out of Area Board" +"ListAgentDirectPhone": "747-343-1266" +"ListAgentEmail": "eranfattal@icloud.com" +"ListAgentFax": "909-373-2515" +"ListAgentFirstName": "Eran" +"ListAgentKey": "17056852" +"ListAgentKeyNumeric": "17056852" +"ListAgentLastName": "Fattal" +"ListAgentOfficePhone": "909-373-2505" +"ListAgentStateLicense": "01304180" +"ListOfficeAOR": "Out of Area Board" +"ListOfficeFax": "909-373-2515" +"ListOfficeKey": "3237841" +"ListOfficeKeyNumeric": "3237841" +"ListOfficePhone": "909-373-2505" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112308116 +"ListingService": "Entry Only" +"LotSizeAcres": 0.1221 +"LotSizeDimensions": "38x140" +"LotSizeSquareFeet": 5320.0 +"MLSAreaMajor": "274 - San Bernardino" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T04:31:51Z" +"OriginalEntryTimestamp": "2025-04-29T11:17:09Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374319567" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "0138052070000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-29T20:25:39Z" +"PhotosCount": 8 +"PoolFeatures": "None" +"PostalCodePlus4": "2705" +"PreviousListPrice": 425000.0 +"PriceChangeTimestamp": "2025-06-14T16:51:35Z" +"PropertySubTypeAdditional": "Single Family Residence" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112308116" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-29T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "6th" +"StreetNumber": "1256" +"StreetNumberNumeric": "1256" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06071-N-0138052070000-R-N" +"View": "None" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112308116"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112308116')" +"CurrentPrice": 414500.0 +"provider_name": "CRMLS" +"RecordSignature": -791365164 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0138052070000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "113814" +"OriginatingSystemListAgentMemberKey": "442704" +"Media": array:8 [ …8] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5508 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112991539" +"ListingId": "ML82006135" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:32.027614+00:00" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 4.25 +"LivingArea": 950.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "38500 Paseo Padre Pkwy 102, Fremont, California 94536" +"Coordinates": array:2 [ …2] +"Latitude": 37.55788739 +"Longitude": -121.98683642 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nisha Singh" +"ListOfficeName": "eXp Realty of California Inc" +"ListAgentMlsId": "ML5101215" +"ListOfficeMlsId": "ML5009355" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover modern living in heart of Fremont in the highly desirable Parkmont neighborhood! This spacious condo has an ideal floor plan that includes a large living room, sizable bedrooms, kitchen and a formal dining area. Parkmont Gardens community includes ideal amenities including a lush greenbelt and a swimming pool! This home is in an excellent commuter location, walking distance from BART and nearby Centerville Train Station, 880 freeway, 680 freeway and Niles Canyon. Around the corner from multiple shopping centers, Whole Foods, Centerville Community Park, Alameda Creek Trail, great schools and beloved local eateries! This home is a must see!" +"Appliances": "Gas Cooktop,Refrigerator" +"AssociationAmenities": "Trash" +"AssociationFee": "550.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Parkmont Gardens HOA" +"AssociationPhone": "925-495-4545" +"AssociationYN": true +"BathroomsFull": 1 +"CLIP": 8478246755 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-09T04:14:15.565194+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: paseo padre" +"Flooring": "Carpet" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Wall Furnace" +"HeatingYN": true +"HighSchoolDistrict": "Alameda City Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentEmail": "nishasingh@gmail.com" +"ListAgentFirstName": "Nisha" +"ListAgentKey": "24251205" +"ListAgentKeyNumeric": "24251205" +"ListAgentLastName": "Singh" +"ListAgentOfficePhone": "(888) 584-942..." +"ListAgentStateLicense": "01937867" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "925-262-1171" +"ListOfficeKey": "4763658" +"ListOfficeKeyNumeric": "4763658" +"ListOfficePhone": "(888) 584-942..." +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112991539 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0001 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4.25 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T13:48:49Z" +"OriginalEntryTimestamp": "2025-05-08T13:21:18Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374380809" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "501153439" +"ParkingFeatures": "Covered,Off Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T18:36:45Z" +"PhotosCount": 7 +"PoolFeatures": "In Ground" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Other" +"Sewer": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112991539" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-08T13:21:18Z" +"StreetName": "Paseo Padre Pkwy" +"StreetNumber": "38500" +"StreetNumberNumeric": "38500" +"UnitNumber": "102" +"UniversalPropertyId": "US-06001-N-501153439-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "Residential" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1112991539"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112991539')" +"CurrentPrice": 499000.0 +"provider_name": "CRMLS" +"RecordSignature": -1685891191 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:501153439" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558053" +"OriginatingSystemListAgentMemberKey": "372906814" +"Media": array:7 [ …7] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5485 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115044718" +"ListingId": "OC25127680" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:47.363769+00:00" +"ListPrice": 5700000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13503.6 +"LivingArea": 2047.0 +"BuildingAreaTotal": 0 +"City": "Corona Del Mar" +"PostalCode": "92625" +"UnparsedAddress": "4621 Hampden Rd, Corona Del Mar, California 92625" +"Coordinates": array:2 [ …2] +"Latitude": 33.589326 +"Longitude": -117.859593 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lynn Paris" +"ListOfficeName": "Pinnacle Real Estate Group" +"ListAgentMlsId": "OCPARILYN" +"ListOfficeMlsId": "OC06746" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Elegant Coastal Living | Beautifully Remodeled Home in the Coveted Cameo Shores Community! As a resident of Cameo Shores, you enjoy exclusive access to the stunning private beaches, unlocked by your key to two separate entrances. These beaches are not only breathtaking, featuring incredible rock formations, but also offer a sense of privacy that's hard to find elsewhere. Additionally, residents can take advantage of scenic beach trails that meander through the picturesque Pelican Hill Golf Course, providing a perfect blend of nature and recreation. The unique pathways in the community connect you seamlessly to Third Beach in Corona del Mar and Crystal Cove State Beach, allowing for easy enjoyment of walking and surfing. Ultimately, you also have the opportunity to explore the beautiful Crystal Cove State Park, as well as the charming Village of Corona Del Mar, thereby enhancing your coastal living experience.\r\r\n This stunning property is situated on a rare 0.31-acre lot with great appreciation potential, Nestled in a private corner, this home features a tranquil backyard, front yard, and side yard that ensure ample natural light and privacy. Floor-to-ceiling windows beautifully integrate the natural landscape of the yard with the open-concept layout. The spacious design includes a large kitchen, a generous master suite, two additional bedrooms, a home office, and an outdoor dining terrace, all thoughtfully arranged. The garage and front yard provide convenient parking options. The entire home has undergone extensive renovation and upgrading.\r\r\n .A significant highlight is the rare 0.31-acre lot, which offers the potential for an ADU expansion or the construction of a new luxury home up to 8,000 square feet, complete with architect-designed plans included. This property presents tremendous potential for appreciation.\r\r\n Community Amenities: The private park and playground in Cameo Shores provide a safe space for families, allowing children and pets to play freely.\r\r\n Excellent School District: Rated 10/10, offering outstanding educational resources.Low Property HOA: Only $1,050 per year. For more details please don't hesitate to contact Lynn Paris at 949-351-1343. """ +"AssociationAmenities": "Dog Park,Golf Course,Jogging Path,Management,Barbecue,Picnic Area,Playground,Guard,Security,Trail(s)" +"AssociationFee": "1050.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Powerstone Property Management" +"AssociationPhone": "9493724022" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-351-1343" +"BathroomsFull": 3 +"CLIP": 6289835863 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Dog Park" +"Contingency": "N" +"ContractStatusChangeDate": "2024-06-01" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-07T06:26:21.386886+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "N/A" +"DocumentsChangeTimestamp": "2025-06-08T09:24:52Z" +"DocumentsCount": 1 +"ElementarySchool": "Harbor View" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Newport Harbor" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "lynnlinparis@gmail.com" +"ListAgentFirstName": "Lynn" +"ListAgentKey": "21318104" +"ListAgentKeyNumeric": "21318104" +"ListAgentLastName": "Paris" +"ListAgentOfficePhone": "626-888-9808" +"ListAgentStateLicense": "02193706" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "usnationalrealty@gmail.com" +"ListOfficeFax": "626-986-5345" +"ListOfficeKey": "3275512" +"ListOfficeKeyNumeric": "3275512" +"ListOfficePhone": "626-888-9808" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-01" +"ListingKeyNumeric": 1115044718 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,1031 Exchange" +"LivingAreaSource": "Public Records" +"LotFeatures": "Sprinklers In Front,Sprinklers On Side,Value In Land" +"LotSizeAcres": 0.31 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 13503.6 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-06T23:02:41Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Corona Del Mar" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "3" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T23:02:41Z" +"OriginalEntryTimestamp": "2025-06-06T23:02:41Z" +"OriginalListPrice": 5700000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374548978" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "47505411" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-08T16:33:40Z" +"PhotosCount": 42 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office" +"Sewer": "Public Sewer" +"ShowingContactName": "Lynn Paris" +"ShowingContactPhone": "9493511343" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115044718" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T23:02:41Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Hampden Rd" +"StreetNumber": "4621" +"StreetNumberNumeric": "4621" +"StructureType": "House" +"TaxLot": "n" +"UniversalPropertyId": "US-06059-N-47505411-R-N" +"View": "Park/Greenbelt,Golf Course,Ocean,Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://www.wellcomemat.com/video/5979bb66942c1m6fu/CDM/CA/92625/Hampden-Rd/OC25127680/" +"VirtualTourURLUnbranded": "https://www.wellcomemat.com/mls/5979bb66942c1m6fu" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office",\n "AdminUpdateYN": "0",\n "ListingKey": "1115044718",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115044718')" +"CurrentPrice": 5700000.0 +"provider_name": "CRMLS" +"RecordSignature": 2080925851 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:47505411" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "143572682" +"OriginatingSystemListAgentMemberKey": "369525581" +"Media": array:42 [ …42] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5484 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113888520" +"ListingId": "ML82006272" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:54.002631+00:00" +"ListPrice": 2725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 8370.0 +"LivingArea": 2380.0 +"BuildingAreaTotal": 0 +"City": "Menlo Park" +"PostalCode": "94025" +"UnparsedAddress": "3523 Oak Drive, Menlo Park, California 94025" +"Coordinates": array:2 [ …2] +"Latitude": 37.47309796 +"Longitude": -122.19842405 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Emely Weissman" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML154192" +"ListOfficeMlsId": "ML37689" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This lovely home is set fairly far back, in a picture postcard kind of way, on its 8,370 square foot lot. The neighborhood is a favorite: green, parklike, picturesque, peaceful, great for taking a walk or joining neighbors for the neighborhood's weekly happy hour get together. The wonderful kitchen has handsome cabinetry, spacious granite counters, gas cooking, stainless steel appliances, and a built-in wine refrigerator. There are both a breakfast area and a separate dining room, both family room and living room, and a first floor bedroom that is great as an office. All bathrooms are updated or remodeled; the principal bathroom with oversized tub and shower is particularly luxurious. Hardwood floors throughout main floor, three carpeted bedrooms up and one bedroom on main floor, three skylights. Deck has an excellent built in hot tub, and there is a substantial backyard. This is a terrific place to call home." +"Appliances": "Dishwasher, Disposal, Refrigerator" +"ArchitecturalStyle": "Mediterranean, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3251173763 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-14" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-15T02:38:52.962690+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Middlefield Road, then turn onto San Benito or Placitas to left on Oak Drive, to 3523. Cross Street: Placitas" +"FireplaceFeatures": "Family Room,Wood Burning" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Menlo-Atherton" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-814-0374" +"ListAgentEmail": "emely.weissman@compass.com" +"ListAgentFax": "650-323-1143" +"ListAgentFirstName": "Emely" +"ListAgentKey": "20889480" +"ListAgentKeyNumeric": "20889480" +"ListAgentLastName": "Weissman" +"ListAgentOfficePhone": "(650) 323-1111" +"ListAgentStateLicense": "01119038" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-323-1143" +"ListOfficeKey": "4763954" +"ListOfficeKeyNumeric": "4763954" +"ListOfficePhone": "(650) 323-1111" +"ListOfficeURL": "http://www.compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-14" +"ListingKeyNumeric": 1113888520 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeAcres": 0.1921 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8370.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-14" +"OnMarketTimestamp": "2025-05-14T12:18:53Z" +"OriginalEntryTimestamp": "2025-05-13T17:00:00Z" +"OriginalListPrice": 2825000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374412483" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "060153290" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Deck" +"PhotosChangeTimestamp": "2025-06-15T07:03:19Z" +"PhotosCount": 24 +"PoolFeatures": "Above Ground" +"PreviousListPrice": 2825000.0 +"PriceChangeTimestamp": "2025-06-14T16:49:32Z" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Entry/Foyer, Laundry" +"Sewer": "Public Sewer" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1113888520" +"SpaFeatures": "Above Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-13T17:00:00Z" +"StoriesTotal": "2" +"StreetName": "Oak" +"StreetNumber": "3523" +"StreetNumberNumeric": "3523" +"StreetSuffix": "Drive" +"UniversalPropertyId": "US-06081-N-060153290-R-N" +"WaterSource": "Public" +"WindowFeatures": "Skylight(s)" +"YearBuiltSource": "Assessor" +"Zoning": "R10010" +"CustomFields": """ {\n "RoomType": "Formal Entry,Laundry",\n "AdminUpdateYN": "0",\n "ListingKey": "1113888520",\n "RoomKitchenFeatures": "Granite Counters"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1113888520')" +"CurrentPrice": 2725000.0 +"provider_name": "CRMLS" +"RecordSignature": 2051684006 +"UniversalParcelId": "urn:reso:upi:2.0:US:06081:060153290" +"CountrySubdivision": "06081" +"PreviousStandardStatus": "Active Under Contract" +"OriginatingSystemListOfficeKey": "368558344" +"OriginatingSystemListAgentMemberKey": "368705589" +"Media": array:24 [ …24] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5483 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117318108" +"ListingId": "PW25130551" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:31.621904+00:00" +"ListPrice": 1295000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7800.0 +"LivingArea": 1463.0 +"BuildingAreaTotal": 0 +"City": "Mission Viejo" +"PostalCode": "92691" +"UnparsedAddress": "23266 Via Ronda, Mission Viejo, California 92691" +"Coordinates": array:2 [ …2] +"Latitude": 33.625063 +"Longitude": -117.655413 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Baroth" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "PWBARRAC" +"ListOfficeMlsId": "PB1364" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 23266 Via Ronda in sought after Barcelona neighborhood offering 4 bedrooms, 3 baths, a spacious entertainers backyard featuring a custom heated pool and spa, a fully insulated patio cover complete with lighting, ceiling fans and custom curtain brackets for additional shade & comfort also boast beautiful easy care tropical fauna, mature lemon and orange trees, and a versatile large playhouse/ office/ hobby room wired with electric, lighting & internet. The perfect setting for summer BBQ’s, family birthdays, holidays or romantic evening dinners. The main level open floor plan has fireplace in cathedral ceiling living room, formal dining room with bright, natural light flowing thru kitchen window box and back door facing lush back yard patio and pool. Finishing the downstairs is a large bedroom with French doors opening to backyard, currently being used as entertainment room and a full bathroom. Retreat to the upstairs primary bedroom full en suite bath with jetted tub, walk in closet completed with vanity, custom shelving and drawers. Another full bath and 2 bedrooms, one loft style that could double as home office and LVP flooring throughout complete the upstairs. Energy-efficient solar panels provide cost-saving benefits, making this home as practical as it is beautiful. Completing this home is Central HVAC system, large 2 car attached garage with washer and dryer hookups, beautiful artificial turf for low maintenance front yard, And Full Access to Lake Mission Viejo Membership and all it has to offer. Talk about location, Award winning Capistrano schools, nearby Aurora Park with fields, playground, volleyball & basketball court, beautiful wooded area for the evening strolls, fine restaurants, shopping and golf course all nearby!" +"Appliances": "Dishwasher,Gas Oven,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Controlled Access,Picnic Area,Playground" +"AssociationFee": "179.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Mission Viejo Lake Membership" +"AssociationPhone": "949-770-1313" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "rachel@rachelbaroth.com" +"BathroomsFull": 3 +"CLIP": 8991206809 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gutter(s)" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-13T03:02:02.144261+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit 5 freeway at Alicia Parkway, follow Alicia Parkway to Right on Via Aura to Right on Via Ronda" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Capistrano Valley" +"HighSchoolDistrict": "Capistrano Unified" +"Inclusions": "Refrigerator" +"InteriorFeatures": "Cathedral Ceiling(s),Separate/Formal Dining Room,Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "rachel@rachelbaroth.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "17072220" +"ListAgentKeyNumeric": "17072220" +"ListAgentLastName": "Baroth" +"ListAgentOfficePhone": "562-989-4608" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01396461" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-989-4803" +"ListOfficeKey": "3284761" +"ListOfficeKeyNumeric": "3284761" +"ListOfficePhone": "562-989-4608" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Open" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1117318108 +"ListingService": "Entry Only" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1791 +"LotSizeDimensions": "130 x 60" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T16:53:41Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T16:53:41Z" +"OriginalEntryTimestamp": "2025-06-12T16:53:41Z" +"OriginalListPrice": 1295000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374576329" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "80826104" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-15T06:51:40Z" +"PhotosCount": 19 +"PoolFeatures": "Gas Heat,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2229" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Anthony" +"ShowingContactPhone": "949-334-7305" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117318108" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T16:53:41Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Via Ronda" +"StreetNumber": "23266" +"StreetNumberNumeric": "23266" +"StructureType": "House" +"TaxLot": "38" +"UniversalPropertyId": "US-06059-N-80826104-R-N" +"View": "Mountain(s), Peek-A-Boo" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Main Floor Bedroom",\n "EatingArea": "Dining Room",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1117318108",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117318108')" +"CurrentPrice": 1295000.0 +"provider_name": "CRMLS" +"RecordSignature": -1772171666 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:80826104" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "43354" +"OriginatingSystemListAgentMemberKey": "9227702" +"Media": array:19 [ …19] } ] +success: true +page_size: 5 +page_count: 135388 +count: 676939 +after_key: "" } ] ]