Trilogy La Quinta - One of the best panoramic south mountain and fairway views in the desert - a $1,000,000+ view at half price! Enjoy paradise everyday with this 3 bedrooms( one bedroom is a detached casita), 3 baths, 2 car garage home with pool and spa. This Maurea plan with courtyard casita has a great room open to the kitchen with pantry, breakfast bar, and dining area. The master suite features walk in closet, dual vanities, and large shower. The casita features a breakfast bar with refrigerator and private bath. The backyard has a wonderful pool and spa with the breathtaking south mountain and golf course views.
Single-familyProperty Type
2004Year Built
6,098 sq ftLot Size
$411Est. Price/Sq.Ft.
2 car garageParking
Listed by Lori Bowers•DRE #01293735• The Lori Bowers Group
•760-831-1595 (agent)
•theloribowersgroup@gmail.com (agent)
Bought with Carlo Lombardelli•DRE #01017816• RE/MAX Consultants
*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
3
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
6,098
Year renovated
2005
Sq. Ft.
1,641
Year built
2004
Style
Single Family Residential
County
Riverside County
APN
764420019
Parking Spaces
2
Basement
No
Accessible
Yes
HOA Dues
$381 /month
Garage
Yes
Features
Views, Pool
Last updated by owner on Jan 7, 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
Jan 20, 2021 • Final
Pool drain permits
Remove calcium buildup from the plumbing lines.
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.
Association Amenities: Banquet Facilities, Barbecue, Billiard Room, Bocce Ball Court, Card Room, Clubhouse, Controlled Access, Elevator(s), Fitness Center, Golf Course, Greenbelt/Park, Lake or Pond, Maintenance Grounds, Management, Pet Rules, Picnic Area, Sport Court, Tennis Courts
Location Information
Directions: Enter gate on Ave 60. Go to stop sign by clubhouse. Go left to Ulrich. Go right at stop sign to Livingstone. Go right to Red Rock. Go right. Home is on the right.
Cross Streets: Livingstone
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: 3
Baths: 3.0
Sq. Ft.: 1,641
Stories: 1.0
Parking Spaces: 2
Basement: No
Accessible: Yes
Lot Size: 6,098 square feet
Style: Single Family Residential
Year Built: 2004
Year Renovated: 2005
County: Riverside County
APN: 764420019
HOA Dues: $381/month
Garage: Yes
Features: Views, Pool
Home facts updated by owner on Jan 7, 2026
Other
Documents & Disclosures
Disclosures: CC & R, Homeowners Association
Listing Information
Listing Terms: Cash, Cash to New Loan
Sale Type: Standard
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.6mi
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
9/10 Heat Factor
6 days above 114° expected this year, 15 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
$642,000 – $777,000
Reach more buyers when you sell with Redfin. Save up to $6,748 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.