Contact Kim Barron
Contacting Kim Barron
  • All fields are required.
Schedule A Showing
Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Request more information
Adult Community
  • MLS#: 219142631DA ( Single Family Residence )
  • Street Address: 81207 Santa Rosa Court
  • Viewed: 5
  • Price: $1,195,000
  • Price sqft: $438
  • Waterfront: Yes
  • Wateraccess: Yes
  • Year Built: 2005
  • Bldg sqft: 2726
  • Bedrooms: 4
  • Total Baths: 4
  • Full Baths: 3
  • Garage / Parking Spaces: 3
  • Days On Market: 58
  • Additional Information
  • County: RIVERSIDE
  • City: La Quinta
  • Zipcode: 92253
  • Subdivision: Trilogy
  • Provided by: Bennion Deville Homes
  • Contact: John John
  • California Regional MLS IDX
  • DMCA Notice
  • 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.
Request More Information
  • All fields are required.
Features
Appliances
  1. Gas Cooktop
  2. Disposal
  3. Microwave
  4. Gas Water Heater
  5. Vented Exhaust Fan
  6. Water Line to Refrigerator
  7. Gas Oven
Association Amenities
  1. Clubhouse Paid
  2. Banquet Facilities
  3. Concierge
  4. Security
  5. Lake or Pond
  6. Management
  7. Cable TV
  8. Billiard Room
  9. Tennis Court(s)
  10. Barbecue
  11. Clubhouse
  12. Bocce Ball Court
  13. Meeting Room
  14. Card Room
  15. Sport Court
  16. Golf Course
  17. Gym/Ex Room
Association Fee
  1. 622.00
Association Fee Frequency
  1. Monthly
Builder Model
  1. Tamarisk/Casita
Builder Name
  1. Shea Homes
Carport Spaces
  1. 0.00
Construction Materials
  1. Stucco
Cooling
  1. Central Air
Country
  1. US
Door Features
  1. Sliding Doors
Eating Area
  1. Breakfast Counter / Bar
  2. Dining Room
  3. Breakfast Nook
Electric
  1. 220 Volts in Laundry
Fencing
  1. Block
Fireplace Features
  1. Gas
  2. Decorative
  3. Great Room
  4. Outside
Flooring
  1. Tile
Foundation Details
  1. Slab
Garage Spaces
  1. 3.00
Heating
  1. Natural Gas
  2. Central
Interior Features
  1. Tray Ceiling(s)
  2. Dry Bar
  3. Built-in Features
  4. High Ceilings
  5. Recessed Lighting
  6. Open Floorplan
Laundry Features
  1. Individual Room
Levels
  1. One
Living Area Source
  1. Assessor
Lockboxtype
  1. Supra
Lot Features
  1. Cul-De-Sac
  2. Landscaped
  3. Front Yard
  4. Sprinkler System
  5. Planned Unit Development
  6. Lawn
Other Structures
  1. Guest House
Parcel Number
  1. 764440009
Parking Features
  1. Direct Garage Access
  2. Side by Side
  3. Garage Door Opener
Patio And Porch Features
  1. Covered
  2. Concrete
Pool Features
  1. In Ground
  2. Waterfall
Postalcodeplus4
  1. 9338
Property Type
  1. Single Family Residence
Roof
  1. Tile
Security Features
  1. 24 Hour Security
  2. Gated Community
Spa Features
  1. In Ground
  2. Heated
Subdivision Name Other
  1. Trilogy
Uncovered Spaces
  1. 0.00
Utilities
  1. Cable Available
View
  1. Mountain(s)
  2. Pool
Window Features
  1. Shutters
  2. Bay Window(s)
  3. Drapes
Year Built
  1. 2005
Year Built Source
  1. Assessor