An extraordinary opportunity within The Madison Club–this oversized, premier homesite commands a coveted position overlooking the 10th and 11th fairways of the Tom Fazio-designed course. Offering an expansive canvas for a world-class estate, the property seamlessly blends privacy, scale, and breathtaking golf course vistas. Surrounded by architectural excellence and set against a dramatic desert backdrop, this is a legacy offering in one of the most prestigious enclaves in the country.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 628270
[post_author] => 1
[ListingKey] => 1168413758
[ListingId] => 219148025DA
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-05-18T18:25:22Z
[RFModificationTimestamp] => 2026-05-18T18:34:24Z
[ListPrice] => 15000000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 57935
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => La Quinta
[PostalCode] => 92253
[UnparsedAddress] => 53650 Fremont Way, La Quinta, California 92253
[Coordinates] => Array
(
[0] => -116.239439
[1] => 33.659598
)
[Latitude] => 33.659598
[Longitude] => -116.239439
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Glenn Cassell
[ListOfficeName] => Madison Club Properties
[ListAgentMlsId] => CDAR-D80313
[ListOfficeMlsId] => CDAR-d23886
[OriginatingSystemName] => CRMLS
[PublicRemarks] => An extraordinary opportunity within The Madison Club--this oversized, premier homesite commands a coveted position overlooking the 10th and 11th fairways of the Tom Fazio-designed course. Offering an expansive canvas for a world-class estate, the property seamlessly blends privacy, scale, and breathtaking golf course vistas. Surrounded by architectural excellence and set against a dramatic desert backdrop, this is a legacy offering in one of the most prestigious enclaves in the country.
[AssociationFee] => 7200.0
[CLIP] => 1118215838
[CoListAgentAOR] => California Desert
[CoListAgentDirectPhone] => (310) 927-9307
[CoListAgentEmail] => ginger@gingerglass.com
[CoListAgentFirstName] => Ginger
[CoListAgentFullName] => Ginger Glass
[CoListAgentKey] => 20785224
[CoListAgentKeyNumeric] => 20785224
[CoListAgentLastName] => Glass
[CoListAgentMlsId] => CDAR-d84505
[CoListAgentStateLicense] => 01478465
[CoListOfficeAOR] => California Desert
[CoListOfficeEmail] => kathy@compass.com
[CoListOfficeKey] => 3199664
[CoListOfficeKeyNumeric] => 3199664
[CoListOfficeMlsId] => CDAR-o D23176
[CoListOfficeName] => Compass
[CoListOfficePhone] => (310) 230-5478
[ContractStatusChangeDate] => 2026-05-12
[Country] => US
[CountyOrParish] => Riverside
[CreationDate] => 2026-05-18T17:43:37.473701+00:00
[DaysOnMarketReplicationDate] => 2026-05-18
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Please call for an appointment. The Madison Club is located on Avenue 52 between Madison and Monroe Streets
[Disclosures] => Covenants/Restrictions Disclosure,HOA Disclosure
[DocumentsChangeTimestamp] => 2026-05-18T10:13:55Z
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => California Desert
[ListAgentDirectPhone] => (760) 777-9320
[ListAgentEmail] => tcassell@madisonclubca.com
[ListAgentFirstName] => Glenn
[ListAgentKey] => 17143663
[ListAgentKeyNumeric] => 17143663
[ListAgentLastName] => Cassell
[ListAgentOfficePhone] => (760) 777-9320
[ListAgentStateLicense] => 01953599
[ListOfficeAOR] => California Desert
[ListOfficeEmail] => info@maidsonclubca.com
[ListOfficeKey] => 3270257
[ListOfficeKeyNumeric] => 3270257
[ListOfficePhone] => (760) 777-9320
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-05-12
[ListingKeyNumeric] => 1168413758
[ListingService] => Full Service
[ListingTerms] => Cash to New Loan
[LotFeatures] => On Golf Course
[LotSizeAcres] => 1.33
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 57935
[MLSAreaMajor] => 313 - La Quinta South of HWY 111
[MlsStatus] => Active
[OnMarketDate] => 2026-05-18
[OnMarketTimestamp] => 2026-05-18T10:28:58Z
[OriginalEntryTimestamp] => 2026-05-18T10:13:55Z
[OriginalListPrice] => 15000000
[OriginatingSystemID] => CDAR
[OriginatingSystemKey] => 433343277
[OriginatingSystemSubName] => CRMLS_CDAR
[ParcelNumber] => 779510033
[PhotosChangeTimestamp] => 2026-05-18T17:30:42Z
[PhotosCount] => 1
[Possession] => Close Of Escrow
[PostalCity] => LA QUINTA
[PostalCodePlus4] => 5559
[Sewer] => Unknown
[ShowingContactName] => Trae Cassell
[ShowingContactPhone] => 949-212-5890
[ShowingContactType] => Agent
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1168413758
[SpecialListingConditions] => Standard
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-05-17T22:00:00Z
[StreetName] => Fremont
[StreetNumber] => 53650
[StreetNumberNumeric] => 53650
[StreetSuffix] => Way
[SubdivisionName] => The Madison
[TaxTract] => The Madison
[UniversalPropertyId] => US-06065-N-779510033-R-N
[View] => Golf Course,Mountain(s),Panoramic
[ViewYN] => 1
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1168413758"
}
[PricePerArea] => 258.91
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1168413758')
[CurrentPrice] => 15000000
[provider_name] => CRMLS
[RecordSignature] => -49352542
[UniversalParcelId] => urn:reso:upi:2.0:US:06065:779510033
[CountrySubdivision] => 06065
[OriginatingSystemListOfficeKey] => 363873459
[OriginatingSystemCoListOfficeKey] => 12341791
[OriginatingSystemListAgentMemberKey] => 32968748
[OriginatingSystemCoListAgentMemberKey] => 368290566
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005316845504
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1168413758/b981994558ec0e88f97ddade562ccb65.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 72404
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1168413758/thumbnail-b981994558ec0e88f97ddade562ccb65.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 17143663
[PropertyType] => Land
[ResourceName] => Property
[ListOfficeKey] => 3270257
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => CDAR-d23886
[LongDescription] => Primary Photo
[MediaAlteration] =>
[MediaKeyNumeric] => 2005316845504
[PropertySubType] =>
[RecordSignature] => 1143302418
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => 219148025DA
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1168413758
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CDAR
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-05-18T17:30:20.810-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CDAR
[ResourceRecordKeyNumeric] => 1168413758
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 433343277
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-05-18T17:30:20.810-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 433343277
)
)
[DaysOnMarket] => 182
[ID] => 628270
)
MLS On The Fly Debug Panel
Array
(
[RF Query: /Property?$select=ALL&$top=20&$filter=(StandardStatus eq 'Active' or (ListAgentMlsId eq 'ZHOCHHOY') or (ListAgentMlsId eq 'CDAR-D81064')) and ListingKey eq 1168413758 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 628270
[post_author] => 1
[ListingKey] => 1168413758
[ListingId] => 219148025DA
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-05-18T18:25:22Z
[RFModificationTimestamp] => 2026-05-18T18:34:24Z
[ListPrice] => 15000000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 57935
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => La Quinta
[PostalCode] => 92253
[UnparsedAddress] => 53650 Fremont Way, La Quinta, California 92253
[Coordinates] => Array
(
[0] => -116.239439
[1] => 33.659598
)
[Latitude] => 33.659598
[Longitude] => -116.239439
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Glenn Cassell
[ListOfficeName] => Madison Club Properties
[ListAgentMlsId] => CDAR-D80313
[ListOfficeMlsId] => CDAR-d23886
[OriginatingSystemName] => CRMLS
[PublicRemarks] => An extraordinary opportunity within The Madison Club--this oversized, premier homesite commands a coveted position overlooking the 10th and 11th fairways of the Tom Fazio-designed course. Offering an expansive canvas for a world-class estate, the property seamlessly blends privacy, scale, and breathtaking golf course vistas. Surrounded by architectural excellence and set against a dramatic desert backdrop, this is a legacy offering in one of the most prestigious enclaves in the country.
[AssociationFee] => 7200.0
[CLIP] => 1118215838
[CoListAgentAOR] => California Desert
[CoListAgentDirectPhone] => (310) 927-9307
[CoListAgentEmail] => ginger@gingerglass.com
[CoListAgentFirstName] => Ginger
[CoListAgentFullName] => Ginger Glass
[CoListAgentKey] => 20785224
[CoListAgentKeyNumeric] => 20785224
[CoListAgentLastName] => Glass
[CoListAgentMlsId] => CDAR-d84505
[CoListAgentStateLicense] => 01478465
[CoListOfficeAOR] => California Desert
[CoListOfficeEmail] => kathy@compass.com
[CoListOfficeKey] => 3199664
[CoListOfficeKeyNumeric] => 3199664
[CoListOfficeMlsId] => CDAR-o D23176
[CoListOfficeName] => Compass
[CoListOfficePhone] => (310) 230-5478
[ContractStatusChangeDate] => 2026-05-12
[Country] => US
[CountyOrParish] => Riverside
[CreationDate] => 2026-05-18T17:43:37.473701+00:00
[DaysOnMarketReplicationDate] => 2026-05-18
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Please call for an appointment. The Madison Club is located on Avenue 52 between Madison and Monroe Streets
[Disclosures] => Covenants/Restrictions Disclosure,HOA Disclosure
[DocumentsChangeTimestamp] => 2026-05-18T10:13:55Z
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => California Desert
[ListAgentDirectPhone] => (760) 777-9320
[ListAgentEmail] => tcassell@madisonclubca.com
[ListAgentFirstName] => Glenn
[ListAgentKey] => 17143663
[ListAgentKeyNumeric] => 17143663
[ListAgentLastName] => Cassell
[ListAgentOfficePhone] => (760) 777-9320
[ListAgentStateLicense] => 01953599
[ListOfficeAOR] => California Desert
[ListOfficeEmail] => info@maidsonclubca.com
[ListOfficeKey] => 3270257
[ListOfficeKeyNumeric] => 3270257
[ListOfficePhone] => (760) 777-9320
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-05-12
[ListingKeyNumeric] => 1168413758
[ListingService] => Full Service
[ListingTerms] => Cash to New Loan
[LotFeatures] => On Golf Course
[LotSizeAcres] => 1.33
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 57935
[MLSAreaMajor] => 313 - La Quinta South of HWY 111
[MlsStatus] => Active
[OnMarketDate] => 2026-05-18
[OnMarketTimestamp] => 2026-05-18T10:28:58Z
[OriginalEntryTimestamp] => 2026-05-18T10:13:55Z
[OriginalListPrice] => 15000000
[OriginatingSystemID] => CDAR
[OriginatingSystemKey] => 433343277
[OriginatingSystemSubName] => CRMLS_CDAR
[ParcelNumber] => 779510033
[PhotosChangeTimestamp] => 2026-05-18T17:30:42Z
[PhotosCount] => 1
[Possession] => Close Of Escrow
[PostalCity] => LA QUINTA
[PostalCodePlus4] => 5559
[Sewer] => Unknown
[ShowingContactName] => Trae Cassell
[ShowingContactPhone] => 949-212-5890
[ShowingContactType] => Agent
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1168413758
[SpecialListingConditions] => Standard
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-05-17T22:00:00Z
[StreetName] => Fremont
[StreetNumber] => 53650
[StreetNumberNumeric] => 53650
[StreetSuffix] => Way
[SubdivisionName] => The Madison
[TaxTract] => The Madison
[UniversalPropertyId] => US-06065-N-779510033-R-N
[View] => Golf Course,Mountain(s),Panoramic
[ViewYN] => 1
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1168413758"
}
[PricePerArea] => 258.91
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1168413758')
[CurrentPrice] => 15000000
[provider_name] => CRMLS
[RecordSignature] => -49352542
[UniversalParcelId] => urn:reso:upi:2.0:US:06065:779510033
[CountrySubdivision] => 06065
[OriginatingSystemListOfficeKey] => 363873459
[OriginatingSystemCoListOfficeKey] => 12341791
[OriginatingSystemListAgentMemberKey] => 32968748
[OriginatingSystemCoListAgentMemberKey] => 368290566
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005316845504
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1168413758/b981994558ec0e88f97ddade562ccb65.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 72404
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1168413758/thumbnail-b981994558ec0e88f97ddade562ccb65.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 17143663
[PropertyType] => Land
[ResourceName] => Property
[ListOfficeKey] => 3270257
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => CDAR-d23886
[LongDescription] => Primary Photo
[MediaAlteration] =>
[MediaKeyNumeric] => 2005316845504
[PropertySubType] =>
[RecordSignature] => 1143302418
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => 219148025DA
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1168413758
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CDAR
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-05-18T17:30:20.810-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CDAR
[ResourceRecordKeyNumeric] => 1168413758
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 433343277
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-05-18T17:30:20.810-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 433343277
)
)
[DaysOnMarket] => 182
[ID] => 628270
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.32 seconds
)
)
MLS On The Fly Debug Panel
[Warning] Undefined array key "file" in /mnt/customers/customers-bh-1pq6z0/e79c15af-daf5-4b07-94b5-b8edbc56c945/wp-content/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /mnt/customers/customers-bh-1pq6z0/e79c15af-daf5-4b07-94b5-b8edbc56c945/wp-content/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147