Amazing Mesquite Plan with Casita - located off the 7th Green at Trilogy Golf & Country Club in La Quinta. Once you step foot through the courtyard door you're greeted with the most inviting outdoor living space imagineable. Ample seating, soothing water feature and a gorgeous alumawood pergola affording the right mix of sun and shade. This is definitely a Mesquite like no other!!! Expanded & updated!! Redesigned Great Room with wall of glass & sliding doors that maximize the South facing Mountain & Golf Course Views!!!! Beautiful stacked stone fireplace and entertainment center. Spectacular Gourmet Kitchen with upgraded Granite Slab counters & stacked stone backsplash. Outdoor Entertaining Space with Backyard Spool with water features and electric awnings across the back of the home. The southern mountain views go on forever. Take a tour of this unique property.
Single-familyProperty Type
2005Year Built
8,712 sq ftLot Size
$444Est. Price/Sq.Ft.
Listed by John Miller•DRE #01371356• Coldwell Banker Residential Brokerage
Listed by John K. Miller John K. Miller Group•DRE #01371356• Coldwell Banker Residential Brokerage
Bought with Elaine Stewart•DRE #01169846• Coldwell Banker Residential Brokerage
*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
Beds
4
Baths
4
Stories
1
Lot width
—
Lot depth
—
Lot size
8,712 Sq. Ft.
Year renovated
2006
Sq. Ft.
2,584
Year built
2005
Style
Single Family Residential
County
Riverside County
APN
764420014
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
Property details
Interior
Virtual Tour
Bedroom Information
Bedroom Features: 2 Master Bedrooms, Walk In Closet, Master Suite, Main Floor Master Bedroom
Bathroom Information
Full Baths: 4
Room Information
Kitchen Features: Island, Pantry
Interior Features
Interior Features: High Ceilings (9 Ft+), Hi-Speed Data Wiring
Doors: French Doors, Sliding Doors
Window Treatments: Blinds
Fireplace Information
Has Fireplace(s)
Fireplace Location: Great Room
Flooring
Carpet, Ceramic Tile
Equipment
Appliances: Dishwasher, Water Line to Refrigerator, Refrigerator, Disposal
Heating & Cooling
Heating Type: Central, Forced Air
Cooling Type: Air Conditioning, Electric, Central Air, Ceiling Fan(s)
Exterior
Building Information
Levels: One
Roofing: Concrete, Tile
Foundation: Slab
Builder's Model Name: Mesquite with casita
Builder's Name: Shea Homes
Exterior Features
Other Exterior Features: Slab
Fencing: Block
Has Sprinklers
Pool Information
Has Pool
Pool Location: Private, Community
Pool Description: Heated
Pool Construction: In Ground
Has Spa/Hot Tub
Spa/Hot Tub Description: Community, Private, Heated
Spa/Hot Tub Construction: In Ground
Land Information
Lot Acres: 0.2000
Land Type: Fee
Land Type: Fee Simple
Irrigation: Sprinkler Timer
Lot Information
Lot Location: On Golf Course
Lot Description: Level, Sidewalks
Property Features
View: Has View
View Type: Golf Course, Mountain(s)
Property Sub-Type: Single Family Residence
Property Attached/Detached: Detached
Property Orientation Faces: Front Door Faces North
Utilities
Utilities Information
Water District Name: CVWD
Sewer: In, Connected and Paid
TV Services: Cable TV
Location
Homeowners Association Information
HOA Information: Association Fee 1: 288.00
Yes
Total Monthly Association Fees: 288.00
Association Fees Include: Clubhouse, Concierge
Association Amenities: Barbecue, Recreation Room, Golf Course, Fitness Center, Card Room, Clubhouse, Billiard Room
Association Pet Rules: Assoc Pet Rules
School Information
School District: Coachella Valley Unified
Location Information
Directions: Trilogy Pkwy. to Desert Rose (Right) to Stone Crop (Left) - next left & right on Red Rock - Home is ahead on the left.
Ground Floor
Cross Streets: Madison/Ave. 60
Community Information
Unit Total in Complex: 1238
Unit Total in Complex: 1238
Senior Community
Community Features: Community Mailbox
Public facts
Beds: 4
Baths: 4.0
Sq. Ft.: 2,584
Stories: 1.0
Lot Size: 8,712 square feet
Style: Single Family Residential
Year Built: 2005
Year Renovated: 2006
County: Riverside County
APN: 764420014
Home facts updated by county records on Aug 8, 2026
Other
Documents & Disclosures
Disclosures: CC & R, Private Transfer Taxes
Listing Information
Listing Terms: Cash, Cash to New Loan
Possession: Close Of Escrow
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
1/10 Fire Factor
Unlikely to be 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
$1.18M – $1.42M
Reach more buyers when you sell with Redfin. Save up to $12,383 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.