Mountain Homes Realty
Enter City, Zip or MLS

81074 barrel cactus

La Quinta, CA 92253

$869,000

3 BEDS 3 BATHS
1,835 SQFT0.15 AC LOT
Residential - Single Family
Image 1
Image 2
Image 3
Image 4
Bedrooms 3
Total Baths 3
Full Baths 3
Square Feet 1835
Acreage 0.16
Status Active
MLS # IG26125202
County Riverside
More Info
Category Residential - Single Family
Status Active
Square Feet 1835
Acreage 0.16
MLS # IG26125202
County Riverside
RARE golf course frontage with private pool, casita, and panoramic mountain views! This beautifully updated Oasis model by Shea Homes is ideally located on the 8th hole (par 3) in Trilogy La Quinta, offering stunning, unobstructed views of the Coral and Santa Rosa Mountains with no homes behind. Enjoy breathtaking sunsets from your private backyard oasis featuring a pool and seamless indoor-outdoor living.The home includes 2 bedrooms plus a detached private casita, perfect for guests or a private retreat, and has been tastefully remodeled and updated throughout. Electric sun setter awnings on the beautiful paver patio. Updated large kitchen has quartz countertops and new KitchenAid appliances. 3 updated bathrooms and an open floor concept. Located in a 24-hour guard-gated 55+ community, Trilogy La Quinta offers resort-style amenities including an 18-hole championship golf course (host of the final Skins Game), tennis, pickleball, bocce ball, fitness center, spa, two restaurants, and two Olympic-size pools.A rare opportunity to own one of the most sought-after locations in Trilogy.
Location not available
Listing
Street
Satellite

Exterior Features

  • Style Traditional
  • Construction Single Family
  • Roof Clay
  • Garage Yes
  • Garage Description Concrete, DirectAccess, DrivewayLevel, Driveway, Garage
  • Water Public
  • Sewer PublicSewer
  • Lot Description BackYard, CloseToClubhouse, DesertBack, Level, OnGolfCourse, Paved, StreetLevel

Interior Features

  • Appliances Dishwasher, GasCooktop, GasOven, GasRange, Microwave, Refrigerator
  • Heating Central
  • Cooling CentralAir
  • Fireplaces No
  • Fireplaces Description None
  • Living Area 1,835 SQFT
  • Year Built 2005

Neighborhood & Schools

  • Subdivision Trilogy

Financial Information

  • Parcel ID 764410015

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of RE/MAX LAKESIDE - (909) 844-6188
The data for this listing came from the California Regional MLS
Listing data is current as of 07/08/2026.
California DRE #02247371

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.