Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 824514
[post_author] => 1
[ListingKey] => 1195070423
[ListingId] => OC26221479
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-15T16:05:40Z
[RFModificationTimestamp] => 2026-11-15T16:08:33Z
[ListPrice] => 2895000
[BathroomsTotalInteger] => 7
[BathroomsHalf] => 2
[BedroomsTotal] => 4
[LotSizeArea] => 12197
[LivingArea] => 4318
[BuildingAreaTotal] => 0
[City] => La Quinta
[PostalCode] => 92253
[UnparsedAddress] => 56285 Village Drive, La Quinta, California 92253
[Coordinates] => Array
(
[0] => -116.236946
[1] => 33.641543
)
[Latitude] => 33.641543
[Longitude] => -116.236946
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => John Sturdevant
[ListOfficeName] => Regency Real Estate Brokers
[ListAgentMlsId] => DSTURJOH
[ListOfficeMlsId] => D031
[OriginatingSystemName] => CRMLS
[PublicRemarks] => EXCEPTIONAL NEW CONSTRUCTION CUSTOM ESTATE WITH SOME OF THE FINEST VIEWS IN THE GUARD-GATED PALMS COMMUNITY. Situated on a desirable single-loaded street, this magnificent residence enjoys unobstructed panoramic views of the 15th green, swaying palms, and majestic mountains. The coveted south-facing rear exposure provides a spectacular setting for enjoying the desert lifestyle. Located within the Fred Couples-designed championship golf community, this stunning single-level home offers approximately 4,318 square feet on an expansive 12,197-square-foot lot, blending Modern Mediterranean architecture with sophisticated contemporary design. Dramatic 14-foot ceilings and luxurious appointments create an extraordinary sense of elegance. Designed for grand-scale entertaining, the impressive great room features a spectacular 10-foot linear fireplace, speakers with TV-ready connections above. Automated lighting and dimmers in select areas add convenience and ambiance. The spectacular chef's kitchen features an enormous center island, exquisite quartzite countertops, custom cabinetry, and premium built-in Thermador appliances. A separate butler's pantry offers additional preparation and storage space, while an elegant bar with glass-enclosed wine display creates the perfect entertaining space. A generous formal dining room is ideal for memorable gatherings. The main residence features three spacious bedroom suites, each with a private bathroom, plus a powder room and pool bath. A beautifully appointed guest house offers an additional bedroom, bathroom, living room, and kitchenette, providing exceptional privacy. Expansive living areas open to a magnificent outdoor retreat featuring a private pool and spa, inviting firepit, and enormous covered patio with built-in BBQ bar, patio heater, and ceiling fans, all overlooking the lush 15th green and breathtaking mountain panorama. Additional highlights include a fully owned solar system with Tesla Powerwall battery storage and an oversized three-car garage offering generous parking and storage. Exceptional craftsmanship, exquisite finishes, and resort-inspired outdoor living distinguish this remarkable custom residence. An extraordinary opportunity to experience luxury desert living in The Palms.
[AccessibilityFeatures] => Safe Emergency Egress from Home,Low Pile Carpet,No Stairs,Accessible Doors
[Appliances] => 6 Burner Stove,Barbecue,Double Oven,Dishwasher,Free-Standing Range,Freezer,Disposal,Gas Range,Gas Water Heater,Ice Maker,Microwave,Refrigerator,Range Hood,Self Cleaning Oven,Tankless Water Heater,Vented Exhaust Fan,Water To Refrigerator,Dryer,Washer
[ArchitecturalStyle] => Contemporary, Spanish
[AssociationAmenities] => Controlled Access,Dog Park,Maintenance Grounds,Management,Pets Allowed,Guard
[AssociationFee] => 600.0
[AssociationFeeFrequency] => Monthly
[AssociationPhone] => 760-346-1161
[AssociationYN] => 1
[AttachedGarageYN] => 1
[AttributionContact] => 949-584-5619
[BathroomsFull] => 4
[BathroomsOneQuarter] => 1
[CLIP] => 8472685146
[CommonInterest] => Planned Development
[CommonWalls] => No Common Walls
[CommunityFeatures] => Curbs,Dog Park,Fishing,Golf,Gutter(s),Hiking,Horse Trails,Stable(s),Lake,Park,Street Lights,Gated
[ConstructionMaterials] => Drywall, Glass, Stucco
[ContractStatusChangeDate] => 2026-11-12
[Cooling] => Central Air,Dual,Zoned
[CoolingYN] => 1
[Country] => US
[CountyOrParish] => Riverside
[CreationDate] => 2026-11-12T08:53:34.314570+00:00
[CumulativeDaysOnMarket] => 3
[DaysOnMarket] => 3
[DaysOnMarketReplication] => 3
[DaysOnMarketReplicationDate] => 2026-11-15
[DaysOnMarketReplicationIncreasingYN] => 1
[DirectionFaces] => North
[Directions] => 10 Freeway East, Exit Jefferson to the right, left onto 52nd St, right onto Madison, left onto Airport Drive, Right onto Golf Club Drive
[Disclosures] => Covenants/Restrictions Disclosure,HOA Disclosure
[DoorFeatures] => Panel Doors,Sliding Doors
[Electric] => Electricity - On Property,220 Volts in Garage,220 Volts in Laundry,Photovoltaics on Grid,Photovoltaics Seller Owned,220 Volts
[ElevationUnits] => Feet
[EntryLevel] => 1
[EntryLocation] => Ground
[ExteriorFeatures] => Barbecue,Lighting,Rain Gutters,Fire Pit
[Fencing] => Block
[FireplaceFeatures] => Electric,Living Room
[FireplaceYN] => 1
[Flooring] => Carpet, Tile
[FoundationDetails] => Slab
[GarageSpaces] => 3.0
[GarageYN] => 1
[Heating] => Central,Forced Air,Fireplace(s)
[HeatingYN] => 1
[HighSchoolDistrict] => Coachella Valley Unified
[HorseAmenities] => Riding Trail
[InteriorFeatures] => Wet Bar,Breakfast Bar,Built-in Features,Breakfast Area,Ceiling Fan(s),Dry Bar,Coffered Ceiling(s),Separate/Formal Dining Room,Eat-in Kitchen,High Ceilings,In-Law Floorplan,Open Floorplan,Pantry,Recessed Lighting,Storage,Smart Home,Tandem,Wired for Data,Bar,Wired for Sound,All Bedrooms Down
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Washer Hookup,Electric Dryer Hookup,Gas Dryer Hookup,Inside,Laundry Room
[Levels] => One
[ListAgentAOR] => Orange County
[ListAgentDesignation] => Accredited Buyer's Representative / ABR
[ListAgentDirectPhone] => 949-584-5619
[ListAgentEmail] => John@JNSRE.com
[ListAgentFirstName] => John
[ListAgentKey] => 17184428
[ListAgentKeyNumeric] => 17184428
[ListAgentLastName] => Sturdevant
[ListAgentOfficePhone] => 949-707-4400
[ListAgentStateLicense] => 01193545
[ListAgentURL] => https://JNSRE.com
[ListAgentVoiceMail] => 949-584-5619
[ListOfficeAOR] => Orange County
[ListOfficeEmail] => compliance@regencyre.com
[ListOfficeFax] => 949-707-5415
[ListOfficeKey] => 3289650
[ListOfficeKeyNumeric] => 3289650
[ListOfficePhone] => 949-707-4400
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-11-12
[ListingKeyNumeric] => 1195070423
[ListingService] => Full Service
[ListingTerms] => Cash,Cash to New Loan,Conventional,FHA,VA Loan
[LivingAreaUnits] => SquareFeet
[LotFeatures] => Back Yard,Front Yard,Greenbelt,Sprinklers In Rear,Sprinklers In Front,Landscaped,On Golf Course,Sprinklers Timer,Sprinkler System,Street Level,Yard
[LotSizeAcres] => 0.28
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 12197
[LotSizeUnits] => SquareFeet
[MLSAreaMajor] => 313 - La Quinta South of HWY 111
[MainLevelBathrooms] => 6
[MainLevelBedrooms] => 4
[MajorChangeTimestamp] => 2026-11-12T00:40:28Z
[MajorChangeType] => New Listing
[MlsStatus] => Active
[NewConstructionYN] => 1
[NumberOfUnitsInCommunity] => 101
[NumberOfUnitsTotal] => 1
[OccupantType] => Vacant
[OnMarketDate] => 2026-11-12
[OnMarketTimestamp] => 2026-11-12T00:40:28Z
[OpenParkingSpaces] => 2.0
[OriginalEntryTimestamp] => 2026-11-12T00:40:28Z
[OriginalListPrice] => 2895000
[OriginatingSystemID] => CRM
[OriginatingSystemKey] => 711486721
[OriginatingSystemSubName] => CRMLS_CRM
[OtherStructures] => Guest House
[ParcelNumber] => 764040003
[ParkingFeatures] => Concrete,Door-Multi,Direct Access,Driveway,Garage Faces Front,Garage,Garage Door Opener,Oversized,Side By Side,Tandem
[ParkingTotal] => 5.0
[PatioAndPorchFeatures] => Concrete,Covered,Front Porch,Patio,Porch,Tile
[PhotosChangeTimestamp] => 2026-11-15T04:51:48Z
[PhotosCount] => 4
[PoolFeatures] => Filtered,Gas Heat,Heated,In Ground,Pebble,Permits,Private
[PoolPrivateYN] => 1
[Possession] => Close Plus 3 Days
[PostalCity] => LA QUINTA
[PostalCodePlus4] => 8754
[PropertyCondition] => Turnkey
[PropertySubTypeAdditional] => Single Family Residence
[RoadFrontageType] => City Street,Private Road
[RoadSurfaceType] => Paved
[Roof] => Concrete,Spanish Tile,Tile
[RoomType] => Bedroom,Entry/Foyer,Foyer,Guest Quarters,Great Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Other,Pantry,Wine Cellar,Dining Room
[SecurityFeatures] => Prewired,Security System,Carbon Monoxide Detector(s),Fire Detection System,Fire Sprinkler System,Security Gate,Gated with Guard,Gated Community,Gated with Attendant,Smoke Detector(s)
[Sewer] => Public Sewer
[ShowingContactName] => John Sturdevant
[ShowingContactPhone] => 949-584-5619
[ShowingContactType] => Agent
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1195070423
[SpaFeatures] => Heated,In Ground,Permits,Private
[SpaYN] => 1
[SpecialListingConditions] => Standard
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-11-12T00:40:28Z
[Stories] => 1
[StoriesTotal] => 1
[StreetName] => Village
[StreetNumber] => 56285
[StreetNumberNumeric] => 56285
[StreetSuffix] => Drive
[StructureType] => House
[SubdivisionName] => The Palms (31366)
[TaxLot] => 40
[UniversalPropertyId] => US-06065-N-764040003-R-N
[Utilities] => Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Water Connected
[View] => Golf Course,Hills,Mountain(s),Panoramic,Pool,Water
[ViewYN] => 1
[WaterSource] => Public
[WindowFeatures] => Casement Window(s),Double Pane Windows,Low-Emissivity Windows,Skylight(s)
[YearBuiltSource] => Builder
[CustomFields] => {
"RoomType": "Primary Bedroom,Primary Bathroom,Foyer,Primary Suite,Laundry,Main Floor Primary Bedroom,Main Floor Bedroom,Dressing Area,Living Room,Walk-In Pantry,Guest/Maid\u0027s Quarters,Great Room,Entry,All Bedrooms Down,Kitchen,Wine Cellar,Walk-In Closet",
"EatingArea": "Breakfast Counter / Bar,Dining Room,In Kitchen,Breakfast Nook",
"DPResourceYN": "0",
"RoomKitchenFeatures": "Kitchen Open to Family Room,Stone Counters,Self-closing cabinet doors,Kitchen Island,Built-in Trash/Recycling,Butler\u0027s Pantry,Self-closing drawers,Walk-In Pantry",
"RoomBathroomFeatures": "Shower in Tub,Exhaust fan(s),Walk-in shower,Main Floor Full Bath,Linen Closet/Storage,Separate tub and shower,Dual shower heads (or Multiple),Privacy toilet door,Bathtub,Double Sinks in Primary Bath,Vanity area,Shower",
"AdminUpdateYN": "0",
"SellerConsiderConcessionYN": "1",
"ListingKey": "1195070423"
}
[PricePerArea] => 670.45
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1195070423')
[CurrentPrice] => 2895000
[provider_name] => CRMLS
[RecordSignature] => -1333318191
[UniversalParcelId] => urn:reso:upi:2.0:US:06065:764040003
[CountrySubdivision] => 06065
[OriginatingSystemListOfficeKey] => 25591
[OriginatingSystemListAgentMemberKey] => 245559
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006194756185
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1195070423/c4040471c5eafc52082735767ab7a6ff.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 233006
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1195070423/thumbnail-c4040471c5eafc52082735767ab7a6ff.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 17184428
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 3289650
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => D031
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006194756185
[PropertySubType] => Single Family Residence
[RecordSignature] => 1531765193
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => OC26221479
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1195070423
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CRM
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CRM
[ResourceRecordKeyNumeric] => 1195070423
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 711486721
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 711486721
)
[1] => Array
(
[Order] => 2
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006194756188
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1195070423/22b5d961b9ea92fa15910143951c702d.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 221441
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1195070423/thumbnail-22b5d961b9ea92fa15910143951c702d.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 17184428
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 3289650
[MediaCategory] => Photo
[MediaObjectID] => 1.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => D031
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006194756188
[PropertySubType] => Single Family Residence
[RecordSignature] => 1531765193
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => OC26221479
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1195070423
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CRM
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CRM
[ResourceRecordKeyNumeric] => 1195070423
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 711486721
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 711486721
)
[2] => Array
(
[Order] => 3
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006194756186
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1195070423/cfe0cb71c915921ec667c1fcc025d72a.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 241130
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1195070423/thumbnail-cfe0cb71c915921ec667c1fcc025d72a.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 17184428
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 3289650
[MediaCategory] => Photo
[MediaObjectID] => 2.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => D031
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006194756186
[PropertySubType] => Single Family Residence
[RecordSignature] => 1531765193
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => OC26221479
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1195070423
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CRM
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CRM
[ResourceRecordKeyNumeric] => 1195070423
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 711486721
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 711486721
)
[3] => Array
(
[Order] => 4
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006194756187
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1195070423/08d18baa3bef0d79e590e11de7134f13.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 236160
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1195070423/thumbnail-08d18baa3bef0d79e590e11de7134f13.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 17184428
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 3289650
[MediaCategory] => Photo
[MediaObjectID] => 3.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => D031
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006194756187
[PropertySubType] => Single Family Residence
[RecordSignature] => 1531765193
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => OC26221479
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1195070423
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CRM
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CRM
[ResourceRecordKeyNumeric] => 1195070423
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 711486721
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-11-15T04:50:58.500-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 711486721
)
)
[ID] => 824514
)