Property Attributes
- MLS#219152177DA
- TypeSingle Family
- Listing Status Active
- CountyRiverside
- CityLa Quinta
- Area La Quinta South of HWY 111
- NeighborhoodTrilogy
- Zip92253
- Style
- Year Built2005
- Price$ 1,125,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms0
- Sqr Footage2726
- Lot Size0.35 Acres
Data Source:
California Regional MLS (CRMLS)
Property Description
Welcome to this exceptional home in Trilogy La Quinta, where resort-style living and effortless desert entertaining come together beautifully. This stunning Tamarisk floor plan has been thoughtfully remodeled creating a home that feels fresh, stylish, and perfectly suited to the La Quinta lifestyle. Set on a private, oversized lot, this home was made for gathering, relaxing, and enjoying those fabulous desert days and evenings. And when guests arrive? They'll have their very own private casita, beautifully furnished and complete with a convenient coffee bar because everyone deserves their own little retreat! Step inside the main residence and you'll immediately feel the welcoming energy of the open-concept design. The beautifully remodeled kitchen features a spectacular Gucci quartzite island, new cabinetry, double ovens, stainless-steel sink, designer accent walls, and stylish wall sconces. It's the kind of kitchen that makes entertaining feel easy and somehow makes everyone want to hang out in the kitchen! Just beyond the kitchen, the cozy breakfast nook is the perfect spot for morning coffee, a leisurely breakfast, or those conversations that somehow last all afternoon. Then step outside and let the fun begin. The backyard is your own private desert oasis, featuring a sparkling pool and spa, dramatic stone waterfall, outdoor fireplace and three covered patio areas designed for everything from al fresco dining to cocktails under the stars. Come see why this Trilogy beauty is ready to be your next desert escape!
| Price History | |
|---|---|
| 9/2/2026 | Listed $1,125,000 |
General Features
| Living Area | 2726 |
|---|---|
| Heating | Central,Fireplace(s),Natural Gas |
| Cooling | Central Air |
| Utilities | Cable Available |
| Possession | Close Of Escrow |
| Roof | Tile |
| Appliances | Dishwasher,Gas Water Heater,Microwave,Refrigerator |
| HOA Fee | 622 |
| Garage Spaces | 2 |
| Patio/Porch Features | Covered,Wrap Around |
| Pool Features | Electric Heat,In Ground,Private,Salt Water,Waterfall |
| Security Features | Gated Community,24 Hour Security |
| Construction Materials | Stucco |
| Exclusions | Furniture available outside of escrow. |
| Year Built | 2005 |
| Electric | 220 Volts in Laundry |
| View | Mountain(s) |
| Stories Count | 1 |
| Levels | One |
| Property Subtype | Single Family Residence |
| Community Features | Golf,Gated |
| Assoc Fee Paid Per | Monthly |
| County | Riverside |
| New Construction | false |
| Property Type | Residential |
| Association Amenities | Billiard Room,Clubhouse,Fitness Center,Tennis Court(s),Cable TV |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Trilogy |
| Garage Y/N | true |
| Full Baths | 3 |
| Special Listing Conditions | Standard |
| Status | Active |
| Directions | Through the main gate to the first stop sign. Turn left on Desert Rose, Right on Ulrich, Right on Living Stone and left on Santa Rosa Cross Street: Living Stone. |
| City | La Quinta |
| Disclosures | Covenants/Restrictions Disclosure,HOA Disclosure |
| Senior Community Y/N | true |
| Open Parking Spaces | 2 |
| MLS Area | 313 - La Quinta South of HWY 111 |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 15246 |
| Listing Terms | Cash,Cash to New Loan,Conventional,FHA,VA Loan |
| Spa Features | Heated,In Ground,Private |
| Property Attached Y/N | false |
| Land Lease Y/N | false |
| Property Condition | Updated/Remodeled |
| Lease Considered Y/N | false |
| Virtual Tour | https://www.autoreelapp.com/share/o/c659faa3-19b5-4259-873a-429a8677a4e2 |
| Builder Name | Shea Homes |
| Standard Status | Active |
| Year Built Source | Assessor |
| Virtual Tour | https://www.autoreelapp.com/share/o/c659faa3-19b5-4259-873a-429a8677a4e2 |
| Property Sub Type Additional | Single Family Residence |
| PostalCity | LA QUINTA |
Interior Features
| Interior Amenities | Breakfast Bar,Separate/Formal Dining Room,High Ceilings,Primary Suite,Walk-In Pantry |
|---|---|
| Flooring | Carpet,Tile |
| Fireplace Features | Decorative,Electric,Living Room,Outside |
| Total Stories | 1 |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Bay Window(s),Shutters |
| Fireplace Y/N | true |
| 3/4 Baths | 1 |
| Laundry Features | Laundry Room |
| Total Bedrooms | 4 |
| LivingAreaSource | Assessor |
| Total Baths | 4 |
Exterior Features
| Fencing | Block |
|---|---|
| Parking Features | Driveway,Garage,Garage Door Opener |
| Lot Features | Planned Unit Development,Sprinklers Timer,Sprinkler System |
| Total Parking | 4 |
| Lot Size Area | 15246 |
| Foundation Details | Slab |
| Spa | false |
| Lot Size Acres | 0.35 |
| Private Pool | true |
| Lot Size Source | Assessor |
| Door Features | Sliding Doors |
| Builder Model | Tamarisk w/casita |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Based on information from California Regional Multiple Listing Service, Inc. as of September 27, 2026 7:12 AM UTC This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.
Copyright Southeast Florida Multiple Listing Service © 2026. Accuracy of listing information is not guaranteed. Listing information is provided for personal consumer, non-commercial use, solely to identify potential properties for potential purchase. All other use is strictly prohibited, is a violation of the terms of use, and may violate federal and state law.
Data Last Updated: September 27, 2026 7:11 AM UTC
The data relating to real estate for sale on this web site comes in part from the INTERNET DATA EXCHANGE Program of the Greater Las Vegas Association of REALTORS® MLS. Real estate listings held by brokerage firms other than this site-owner are marked with the IDX logo. The information being provided is for the consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this
The content relating to real estate for sale on this website comes in part from the MLS of Central Oregon. Real estate listings held by Brokerages other than qa are marked with the Reciprocity/IDX logo, and detailed information about these properties includes the name of the listing Brokerage. © MLS of Central Oregon (MLSCO).
This content last updated on September 27, 2026 6:42 AM UTC Some properties which appear for sale on this website may subsequently have sold or may no longer be available.
All
Information provided courtesy of LERA MLS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is believed to be accurate but not guaranteed. Provided courtesy of LERA MLS. Copyright 2026 LERA MLS, All Rights Reserved. Data last updated September 27, 2026 6:30 AM UTC
The data relating to real estate for sale on this web site comes from the participating brokers of the South Jersey Shore MLS. Any use of search facilities of data on the site, other than a consumer looking to purchase real estate, is prohibited. Information displayed on this web site is Deemed Reliable But Not Guaranteed. This data is updated daily.
© 2026 Florida Gulf Coast MLS (FGCMLS) Information deemed reliable, but not guaranteed. The IDX data relating to real estate for sale on this web site comes in part from the Florida Gulf Coast Multiple Listing Service. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Wasatch Front Regional MLS - Salt Lake Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties
Southern Oregon Multiple Listing Service All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
Information is deemed to be reliable, but is not guaranteed. © 2026 MLS and FBS. Prepared by Florida Keys MLS, Inc. on September 27, 2026 7:03 AM UTC The information on this sheet has been made available by the MLS and may not be the listing of the provider. The data relating to real estate for sale on this web site comes in part from the Florida Keys MLS, Inc. Information provided is deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. The information
The content relating to real estate for sale and/or lease on this Web site comes in part from
the Internet Data eXchange ("IDX") program of the Northwest Indiana REALTORS® Association Multiple Listing Service ("NIRA MLS"). and is communicated verbatim, without change, as filed by its members. This information is being provided for the consumers' personal, noncommercial use and may not be used for any other purpose other than to identify prospective properties consumers may be interested in purchasing
West Central Association Of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2018 All rights reserved. Last Update: September 27, 2026 6:59 AM UTC
OneKey® MLS required Copyright, Source of Data and Disclaimer for IDX display
Information Copyright 2026, OneKey® MLS. All Rights Reserved.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers' personal, non-commercial use.
The data relating to real estate for sale on this website comes in part from the
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating