Stunning new and private warm contemporary with explosive golf and mountain views on one of the best streets in the ultra desired Madison Club. Top of the line design and construction and that special world class interior design touch that makes instant magic happen and gives you goose bumps as you walk in and imagine the life style experience this property would surely provide it's future very lucky owner. The perfect open floor plan with more than 13,000 SF under roof and Approx. 9,400 SF under A/C boasting a total of 9 beds (6 bedroom suites) including an approx. 1,800 SF 2-bedroom guest penthouse with fireplaces and mountain views, a killer cinema, Italian main kitchen and chef kitchen, a bar area, 3 car garage and an additional golf cart garage all tiled and with RGB lighting, shaded car port and large and gated motor court, a zero edge oversized pool with a large built in fire pit area, covered patio and loggia with 4 different sitting areas, outdoor living room with a fireplace, extensive BBQ area, a private master patio with a spa, outdoor shower and a fire pit, and one of the nicest closets/bath combos out there. A massive sound system fills the spaces with warm and fuzzy bass and perfect frequencies and 16 TV's plus one 210" screen deliver perfect images of the many Apple TV's around. Top of the line home automation and control and the most efficient AC system available today modulating up to 26 SEER joining the solar system of the house in maximizing future savings. Sold furnished and including 19 abstract art pieces curated especially for the property. And yes full sun on the pool and full shade on the covered patio all day. .. every day. .. weekends and winter included.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
4
Baths
4.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.6 Acres
Year renovated
2023
Sq. Ft.
9,391
Year built
2023
Style
Other
County
Riverside County
APN
779490040
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 7, 2026.
RL
SP 99-035 COUNTRY CLUB OF THE DESERT
EOD
Low Density Residential District
To provide for the development and preservation of low density neighborhoods 2 to 4 units per acre, except as provided in Section 9.40.020, Conditions for varying residential densities with 1 and 2 story single-family detached dwellings on large or medium size lots and; or, subject to a specific plan, projects with clustered smaller dwellings, such as 1 and 2 story single-family attached, townhome or condominium dwellings, with generous open space.
Zone overlays
Equestrian Overlay District
Permitted uses
Include but are not limited to:
Equestrian facility
Housing-Single unit
Housing-Senior
Golf related
Housing-Mobile home park
Park & open space
Dec 5, 2023 • Final
Solar (web)
Install a solar photovoltaic system with panels and microinverters.
Electrical
Solar
Sep 15, 2023 • Final
Pool construction (web)
Install a water feature at the entry courtyard.
Pool and hot tub
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Garage
Garage, 3 Car Garage, Private, Gated, Golf Cart
# of Garage Spaces: 4
Parking
# of Parking Spaces (Total): 15
# of Covered Parking Spaces: 6
Interior
Bathroom Information
# of Baths (Full): 7
Laundry Information
Laundry Inside
Additional Rooms
Other Room
Interior Features
Furnished
Fireplace Information
Other (See Remarks)
# of Fireplaces: 6
Flooring Information
Other Floors
Equipment
Other
Heating & Cooling
Central Cooling
Central Heat
Exterior
Building Information
Total Floors: 1
One Level
Detached
Detached/No Common Walls
Security Features: Gated Community with Guard
Builder's Tract Code: 805
Builder's Tract Name: The Madison
Pool Information
Heated Pool
Heated Spa
Property Information
Property Type: Residential Single-Family
Property Condition: New Construction
Land Information
Other Structures: None
Lot Information
Lot Size (Sq. Ft.): 26,136
Lot Size (Acres): 0.6
Lot Location: On Golf Course
Lot Description: Gated with Guard
Property Features
Has View
View: Golf Course, Mountains
Financial
Assessment Information
Assessor Parcel Number: 779-490-040
Location
HOA Information
Fee #1: $5,260
Fee #1 Frequency: Quarterly
Location Information
Directions: Across from the Polo Fields at 52nd and Madison
Public facts
Beds: 4
Baths: 4.5
Sq. Ft.: 9,391
Stories: 2.0
Lot Size: 0.6 acres
Style: Other
Year Built: 2023
Year Renovated: 2023
County: Riverside County
APN: 779490040
Home facts updated by county records on Aug 7, 2026
Other
Documents & Disclosures
Disclosures: LA/Owner Related, Owner Has R.E. License, CC and R
Around this home
Schools
Mountain Vista Elementary School
Public K-6 • Assigned • 1.7mi
4/10
Cahuilla Desert Academy Junior High
Public 7-8 • Assigned • 1.3mi
3/10
Coachella Valley High School
Public 9-12 • Assigned • 2.9mi
3/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
3/10 Fire Factor
0.62% chance of being in a wildfire in next 30 years
10/10 Heat Factor
7 days above 115° expected this year, 19 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
La Quinta, CA • 92253
Average low and high temperatures (°F)
71
46
79
53
85
59
86
61
94
68
104
75
105
78
107
80
100
75
92
64
76
51
75
47
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
Try the sun simulator tool to see how light moves across the property at different times of day and year.
Provided by Shadowmap
Estimated sale price
$23.55M – $28.50M
Reach more buyers when you sell with Redfin. Save up to $247,856 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.