Beautiful southern exposure residence, with close-up #7 green and panoramic mountain views. A Tuscan facade entry, through custom wood door, to a private, inviting open courtyard. This gorgeous Mesquite plan with 2,789 square feet of living space includes 4 bedrooms/4 baths, plantation shutters throughout, arched doorways, cozy fireplace w/ built-in entertainment shelving, formal dining, den/office, and a 3-car garage. Enjoy a Chef's kitchen w/ stainless steel appliances, slab granite counters, double ovens, wine fridge, prep island, nook area, custom tile backsplash and rich cocoa cabinets. A detached casita with en suite bath, all open to the front courtyard. Upscale master bedroom with attached bath including soaker tub, travertine counters, spacious shower and dual closets. A showcase backyard including a pebble-tec pool with water descents, and spacious spa with flagstone enclosure and soothing dual waterfalls, mature lush landscaping and spectacular mountain range views.
Single-familyProperty Type
2005Year Built
8,712 sq ftLot Size
$348Est. Price/Sq.Ft.
3 car garageParking
Listed by John Miller•DRE #01371356• Bennion Deville Homes
•760-285-3642 (agent)
•jkmillergroup@gmail.com (agent)
Listed by John K. Miller John K. Miller Group•DRE #01371356• Bennion Deville Homes
Bought with John Miller•DRE #01371356• Bennion Deville Homes
*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
Stories
1
Lot width
—
Lot depth
—
Lot size
8,712 Sq. Ft.
Year renovated
2006
Sq. Ft.
2,789
Year built
2005
Style
Single Family Residential
County
Riverside County
APN
764420015
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 8, 2026.
RMH
SP 218 CORAL MOUNTAIN (TRILOGY)
Medium High Density Residential District
To provide for the development and preservation of medium-high density neighborhoods 8 to 12 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 small lots, 1 and 2 story single-family attached dwellings, and 1 and 2 story townhome and multifamily dwellings.
Zone overlays
Permitted uses
Include but are not limited to:
Equestrian facility
Housing-Single unit
Housing-Multiple units
Housing-Senior
Housing-Other
Golf related
Housing-Mobile home park
Park & open space
Jun 25, 2022 • Final
Building residential permit - new dwellings, additions, remodels, carports and garages
Construct and attach a new pergola to the existing house.
Addition
ADU
Jan 22, 2009 • Final
Mechanical
HVAC
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
Parking and Garage Information
Total Parking Spaces: 3
Parking: Direct Entrance, Golf Cart Garage, Oversized, Side By Side
Has Garage
Garage Description: Attached
Total Garage Spaces: 3
Interior
Virtual Tour
Bedroom Information
Bedroom Features: Master Retreat, Master Suite, Walk In Closet
Bathroom Information
Full Baths: 4
Bathroom Features: Shower Over Tub, Shower Stall, Travertine
Room Information
Rooms: Breakfast, Den - Study, Dining Room, Great Room
Eating Areas: Breakfast Room, Formal Dining Room, Kitchen Island
Kitchen Features: Granite Slab Counters, Island, Pantry
Laundry Location: Individual Room
Interior Features
Interior Features: Hi-Speed Data Wiring, High Ceilings (9 Ft+), Open Floorplan, Recessed Lighting
Appliances: Dishwasher, Disposal, Exhaust Fan, Gas Cooktop, Gas/Elec Dryer Hookup, Microwave Oven, Water Line to Refrigerator
Gas
Volt 220 Locations: In Laundry
Heating & Cooling
Heating Type: Central, Fireplace(s)
Heating Fuel: Natural Gas
Cooling Type: Air Conditioning, Ceiling Fan(s), Central Air
Exterior
Building Information
Building Style: Tuscan
Building # of Stories: 1
Year Built Source: Assessor
Levels: One
Roofing: Concrete, Tile
Exterior Construction: Stucco
Foundation: Slab
Builder's Model Name: Mesquite with casita
Builder's Name: Shea Homes
Exterior Features
Security Safety: Prewired For Alarm
Patio Features: Covered, Rock - Stone
Fencing: Block
Has Sprinklers
Casita Features: Other: detached casita
Pool Information
Has Pool
Pool Location: Community, Private
Pool Accessories: Waterfall
Pool Description: Heated
Pool Construction: In Ground, Pebble
Has Spa/Hot Tub
Spa/Hot Tub Description: Heated - Gas
Spa/Hot Tub Construction: Pebble
Land Information
Lot Acres: 0.2000
Land Type: Fee
Land Type: Fee Simple
Irrigation: Sprinkler System
Lot Information
Lot Size Source: Assessor
Lot Location: Close to Clubhouse, On Golf Course
Lot Description: Curbs, Fenced, Front Yard, Landscaped, Level, Sidewalks, Street Lighting, Street Paved, Utilities Underground
Property Features
Sq Ft Source: Assessor
View: Has View
View Type: Desert, Golf Course, Mountain(s), Panoramic, Pool
Property Sub-Type: Single Family Residence
Other Structures: Guest House/Casita
Property Attached/Detached: Detached
Property Orientation Faces: Leisure Faces South
Utilities
Utilities Information
PUD Y/N: Yes
Water: Water District
Water District Name: CVWD
Sewer: In, Connected and Paid
TV Services: Cable TV
Location
Homeowners Association Information
HOA Information: Association Fee 1: 381.00
Yes
Association 1 Frequency: Monthly
Total Monthly Association Fees: 381.00
Association Fees Include: Cable TV, Clubhouse, Concierge
Association Amenities: Banquet Facilities, Barbecue, Billiard Room, Card Room, Clubhouse, Fire Pit, Fitness Center, Golf Course, Lake or Pond, Maintenance Grounds, Management, Meeting Room, Sport Court, Tennis Courts
Location Information
Directions: check with guard.
Cross Streets: Madison / Ave 60
Community Information
Senior Community
Gated Community: Yes
Community Features: Community Mailbox, Golf Course Within Development, Pickle Ball Courts
Development Has Golf Course
Public facts
Beds: 4
Baths: 4.0
Sq. Ft.: 2,789
Stories: 1.0
Lot Size: 8,712 square feet
Style: Single Family Residential
Year Built: 2005
Year Renovated: 2006
County: Riverside County
APN: 764420015
Home facts updated by county records on Aug 8, 2026
Other
Documents & Disclosures
Disclosures: CC & R, Homeowners Association, Planned Development
Listing Information
Listing Terms: Cash, Cash to New Loan, Conventional, FHA, VA Loan
Sale Type: Standard
Possession: Close Of Escrow
Short Term Rentals: No
Will Consider Lease: No
Around this home
Schools
Westside Elementary School
Public K-6 • Assigned • 2.5mi
7/10
Cahuilla Desert Academy Junior High
Public 7-8 • Assigned • 4.4mi
3/10
Coachella Valley High School
Public 9-12 • Assigned • 3.7mi
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
2/10 Fire Factor
0.00% chance of being in a wildfire in next 30 years
10/10 Heat Factor
7 days above 114° expected this year, 17 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
4/10 Air Factor
4 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
106
79
100
75
92
64
76
51
75
47
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.9 hours in
June and 7.5 hours in December, placing it above the
U.S. average for solar exposure.
10.9 hrs
7.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$986,000 – $1.19M
Reach more buyers when you sell with Redfin. Save up to $9,708 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.