Back to Search
81207 Santa Rosa Ct
For Sale $1,195,000 ($438.37 per Sq Ft)
$1,195,000 ($438.37 per Sq Ft)
- 4 Bedrooms
- 4 Bathrooms
- 2,726 Sq Ft
- 15,246 Sq Ft
Description
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.
Amenities
Garage
Pool
Garden
Security System
Internet
Telephone
Heating
Fireplace
Balcony & Patio
TV / Cable
Laundry
Hardwood Floors
Spa
Air Conditioning
Solar Power
Floor Plan
Great Views
Natural Light
Quiet
Water View
Elevator
Guest Unit(s)
Furnished
220 Volt
Property Details
| List Price | $1,195,000 |
| Property Type | Single Family Homes |
| Usable Sqft | 2,726 |
| Number of Stories | 1 stories |
| Parking Spots | 3 spots |
| Year Built | 2005 |
| Last Sold | Unknown |
| Sold Price | Unknown |
| HOA Fees: | $595 |
| Association Name: | Trilogy La Quinta HOA |
| Association Amenities: | Bocce Court,Billiard Room,Clubhouse,Sport Court,Fitness Center,Golf Course,Game Room,Lake or Pond,Meeting Room,Management,Meeting/Banquet/Party Room,Barbecue,Security,Tennis Court(s),Cable TV |
| APN # | 764440009 |
| MLS # | 219136521DA |
| Property ID | 318947915 |
| Lot Sqft | 15,246 |
| Zoning | Unknown |
| Days on Market | 126 |
| Original List Price | $1,195,000 |
| Applicances | Gas Cooktop,Disposal,Gas Oven,Gas Water Heater,Microwave,Vented Exhaust Fan,Water To Refrigerator% |
| Date Updated | October 12, 2025 |
| Date Created | October 07, 2025 |
Listing Provided By
John Miller an agent of Bennion Deville Homes. Lic #01371356
© 2026 CRMLS. All rights reserved. Some listings on this website are from CRMLS as of October 12, 2025 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.
Contact Agent
Schedule Appointment
Showing Agent
Loading agent...
- 30 mins
- America/Phoenix
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Robert Crawford
REAL ESTATE AGENT