Experience the pinnacle of desert living in this rare Tamarisk model with detached casita, ideally situated on a private cul-de-sac within Trilogy La Quinta. Set on an expansive .35-acre homesite, this exceptional residence offers a beautifully landscaped front lawn, an inviting courtyard with ornate entry gate, three covered patios, an outdoor fireplace, and a resort-style pool and spa highlighted by a dramatic stone waterfall. Encompassing approximately 2,726 sq. ft. of refined single-level living, the home showcases 4 bedrooms, 4 bathrooms, a formal dining room with bay window, and a spacious great room with custom media niche. Recent upgrades include fresh interior and exterior paint (including the casita), new porcelain tile flooring with 7-inch baseboards, shutters, shades, and a custom-designed TV and electric fireplace wall. The gourmet kitchen is a true showpiece, boasting all-new cabinetry, quartz Gucci stone island, stainless steel sink, Monogram cooktop, built-in double ovens, designer accent walls and wall sconces, and a charming breakfast nook with custom bench seating and dry bar. The primary suite impresses with a tray ceiling, bay-window sitting area, walk-in closet, updated shutters, and a luxurious bathroom with separate shower. Additional enhancements include new toilets and faucets throughout, upgraded ceiling fans, custom built-ins, and a split 3-car garage. A rare offering of style, space, and upgrades, this home is not to be missed.
Property Details
Price:
$1,195,000
MLS #:
219136521DA
Status:
Active
Beds:
4
Baths:
4
Type:
Single Family
Subtype:
Single Family Residence
Subdivision:
Trilogy
Neighborhood:
313
Listed Date:
Oct 7, 2025
Finished Sq Ft:
2,726
Lot Size:
15,246 sqft / 0.35 acres (approx)
Year Built:
2005
See this Listing
Schools
Interior
Exterior
Community
55+
Parking Spots
3
Financial
HOA Fee
$595
HOA Frequency
MO
Map
Community
- AddressSanta Rosa CT La Quinta CA
- SubdivisionTrilogy
- CityLa Quinta
- CountyRiverside
- Zip Code92253
Subdivisions in La Quinta
- Acacia At La Quinta
- Acacia at La Quinta 30801
- Aliso 30802
- Alta Verde Coral MT
- Andalusia at CM
- Bajada Estates
- Bella Vista
- Bella Vista 30803
- Cactus Flower
- Capistrano at La Quinta 31304
- Capistrano at LQ
- Carmela
- Carmela 31305
- Casitas Las Rosas
- Codorniz
- Codorniz 31307
- Desert Club Estates
- Desert Club Estates 31308
- Desert Cove 31309
- Desert Pride
- Desert Pride 30805
- Duna La Quinta
- Enclave Mountain Est
- Esplanade
- Flores Montanas
- Floresta
- Griffin Ranch
- Haciendas at La Quinta
- Hidden Canyon
- Hidden Canyon 31316
- Highland Palms 31317
- Indian Wells C.C.
- La Cantera
- La Cantera 31318
- La Quinta Cove
- La Quinta Cove 31319
- La Quinta Cove*
- La Quinta Del Oro
- La Quinta Del Oro 30807
- La Quinta Del Rey
- La Quinta Del Rey 30808
- La Quinta Desert Villas 30825
- La Quinta Fairways
- La Quinta Fairways 31320
- La Quinta Palms
- La Quinta Palms 30810
- La Quinta Polo Est
- La Quinta Polo Estates
- La Quinta Vastas
- La Quinta Villas 30811
- La Quinta Vistas
- Laguna De La Paz
- Lake La Quinta
- Lake La Quinta 31325
- Legacy Villas
- Legacy Villas 31326
- Lions Gate
- Los Estados
- LQCC Estates
- LQCC Fairways
- LQCC Golf Estates
- LQCC Golf Estates 31332
- LQCC Lago La Quinta
- LQCC Montero Estates
- LQCC Villas of LQ
- Mira Flores
- Monticello
- Monticello 30814
- Mountain View CC
- Palm Royale
- Palmilla
- Palo Verde
- Parc La Quinta
- PGA Greg Norman
- PGA Greg Norman 31342
- PGA Legends
- PGA Legends 31343
- PGA Nicklaus Private
- PGA Nicklaus Private 31344
- PGA Nicklaus Tournament 31345
- PGA Nicklaus Trnamnt
- PGA Palmer Private
- PGA Palmer Private 31346
- PGA Stadium
- PGA Stadium 31347
- PGA Weiskopf
- PGA West Monterra
- PGA West Signature
- PGA West Signature1861
- Piazza Serena
- Point Happy Estates
- Puerta Azul
- Quinterra
- Rancho La Quinta CC
- Rancho La Quinta CC 31352
- Rancho Ocotillo 30817
- Rancho Santana
- Rancho Santana 31353
- Renaissance
- Renaissance 31354
- Santa Rosa Cove CC 31355
- Santa Rosa Cove Coun
- Santa Rosa Trail
- Santerra
- Sonrisa
- Starlight Dunes
- Starlight Dunes 30819
- Stone Creek Ranch
- Stone Creek Ranch 31357
- Sunflower
- Talante
- Talante 31358
- The Citrus
- The Citrus 31359
- The Enclave
- The Enclave 31360
- The Estancias Rancho LQ
- The Estates at La Quinta
- The Estates at La Quinta 31362
- The Hideaway
- The Madison
- The Palms
- The Quarry
- The Quarry 31367
- The Tradition 31368
- Topaz
- Tradition Golf Club
- Tradition Golf Club
- Trilogy
- Trilogy 31369
- Villa La Quinta 31386
- Watercolors
- Watercolors 31371
- Westward Isle
- Westward Isle 30822
- Westward Shadows
- Westward Shadows 30823
Market Summary
Current real estate data for Single Family in La Quinta as of Nov 28, 2025
456
Single Family Listed
85
Avg DOM
519
Avg $ / SqFt
$2,075,832
Avg List Price
Property Summary
- Located in the Trilogy subdivision, Santa Rosa CT La Quinta CA is a Single Family for sale in La Quinta, CA, 92253. It is listed for $1,195,000 and features 4 beds, 4 baths, and has approximately 2,726 square feet of living space, and was originally constructed in 2005. The current price per square foot is $438. The average price per square foot for Single Family listings in La Quinta is $519. The average listing price for Single Family in La Quinta is $2,075,832.
Similar Listings Nearby

Santa Rosa CT
La Quinta, CA




































































































