81207 Santa Rosa Court, La Quinta, CA 92253 (MLS# 219113524)

81207 Santa Rosa Court, La Quinta, CA 92253

$825,000

Property Type: Residential Bedrooms: 4 Baths: 4 Square Footage: 2,726 Status: Closed

Current Price: $825,000 List Date: 6/28/2024 Last Modified: 9/09/2026

Overview

Description

Hollywood glamour comes to Trilogy La Quinta. This rare, outstanding Tamarisk model home spans 2,726 square feet with four-bedrooms (or three-bedrooms plus office), private courtyard with a separate Casita, dramatic cascading waterfalls over a raised spa to a salt-water pool below, and a grand bronze-colored entry gate befitting a Hollywood estate. Located on a cul de sac, the home sits on a sprawling one-third plus acre with tall palms, lush gardens, and towering southwest mountain views from the back and side yards. Step into the main home foyer and you're immediately captivated by the elegance of the bright and open floor plan as it flows effortlessly from one room to the next. Throughout the main living area the ten-foot ceilings and over-sized windows offer awe-inspiring views from every room. The great room features a media niche and sliding door to a private covered patio with an automated sunscreen. Mountain vistas, green gardens, and waterfalls take center-stage when seated in ... (Read more)

Supplements: A nearby breakfast nook with built-in desk looks out over the lush landscaping, pool and barbecue station and spanish-tiled raised hearth gas fireplace. Doors from the nook lead to an outdoor covered patio, the perfect place to sip that first fresh cup of coffee and feel the light morning breeze. The primary bedroom is a spacious retreat with a lar ... (Read more)

Listing Details MLS# 219113524

General Property Information

Total Bedrooms: 4
Full Baths: 3
3/4 Baths: Yes
Approx SqFt: 2726
Total Baths: 4
SqFt Source: Assessor
Fireplace: Yes
Total Fireplaces: Yes
Pool: Yes
Garage: Yes
Garage Description: Attached
Sprinklers: Yes
Building # of Stories: Yes
Lot Size Source: Assessor
Year Built: 2005
Furnished: Partially
Cross Streets: Livingstone Dr

Property Features

Sale Type: Standard Listing Terms: Cash; Conventional Lot Description: Back Yard; Front Yard; Landscaped; Lawn; Level; Private; Single Lot; Utilities Underground; Yard Lot Location: Cul-De-Sac View Type: Mountain(s) Property Orientation Faces: Leisure Faces South Other Structures: Guest House/Casita Other Structural Features: Misting System; Premium Lot Irrigation: Drip System; Sprinkler System; Sprinkler Timer Fencing: Block Disclosures: CC & R; Home Warranty Plan; Homeowners Association; Pet Restrictions; Planned Development Casita Features: Kitchenette Community Features: Community Mailbox; Curbs; Golf Course Within Development; Pickle Ball Courts; Sidewalks; Street Lighting Levels: One Entry Location: Foyer Appliances: Convection Oven; Dishwasher; Disposal; Dryer; Electric Oven; Exhaust Fan; Gas Cooktop; Ice Maker; Microwave Oven; Refrigerator; Self Cleaning Oven; Washer; Water Line to Refrigerator Kitchen Features: Granite Slab Counters; Island; Pantry Eating Areas: Breakfast Counter/Bar; Breakfast Nook; Formal Dining Room; Kitchen Island Bedroom Features: All Bedrooms Down; Primary Retreat; Primary Suite; Walk In Closet Bathroom Features: Double Vanity(s); Linen Closet; Marble Counters; Shower & Tub; Shower Over Tub Doors: Sliding Doors Exterior Construction: Stucco Flooring: Ceramic Tile Cooling Type: Air Conditioning; Ceiling Fan(s); Central Air Pool Location: Private Pool Accessories: Waterfall Pool Construction: Pebble Pool Description: Heated; In Ground; Private; Salt Water; Waterfall Heating: Central; Forced Air Heating Fuel: Natural Gas Fireplace Location: Exterior; Patio Fireplace Features: Gas & Wood; Raised Hearth; Tile Rooms: Breakfast; Casita - Guest House; Dining Room; Entry; Great Room; Walk In Pantry Interior Features: Built-In Features; High Ceilings (9 Ft+); Open Floorplan; Recessed Lighting TV Services: Cable TV Laundry: Electric Dryer Hookup; Gas Dryer Hookup; Individual Room Security Safety: Gated Community; Resident Manager Disability Access: No Interior Steps Window Treatments: Awnings; Custom Window Covering; Double Pane Windows; Screens Roofing: Concrete; Tile Patio Features: Brick - Tile; Concrete Slab; Covered; Misters Sewer: In, Connected and Paid Water: Water District Water Heater Feature: Water Heater Central; Water Heater Unit Parking: Driveway; Garage Door Opener; Golf Cart Garage; Oversized; Side By Side Road Surface Type: Paved Association 1 Frequency: Monthly Association Amenities: Banquet Facilities; Barbecue; Billiard Room; Bocce Ball Court; Card Room; Clubhouse; Elevator(s); Fire Pit; Fitness Center; Golf Course; Maintenance Grounds; Management; Meeting Room; Pet Rules; Tennis Courts Association Fees Include: Cable TV; Clubhouse; Concierge; Security; Trash Association Pet Rules: Assoc Pet Rules; Call Contingent Upon: Appraisal; Inspection; Loan Approval Land Lease Type: Fee Simple

Listing Location and Property Info

APN: 764440009
Original List Price: 995000
Property Sub-Type: Single Family Residence
Street #: 81207
Street Name: Santa Rosa
Street Suffix: Court
County: Riverside
State: CA
Zip Code: 92253
Area: 313 -La Quinta South of HWY 111
Country: US

Listing Info

Short Term Rentals: No
Will Consider Lease: No

Tax Info

Tax Mello Roos: No

Property Info

Golf Course Within Development: Yes
Senior Community: Yes
Gated Community: Yes
PUD Y/N: Yes
Total Monthly Association Fees: 552
View: Yes

More Information

Status Change Info

Status Change Date: 2025-02-21
Pending Date: 2025-02-11
Closed Date: 2025-02-21
Closed Price: 825000

Builders Information

Builder's Name: Shea Homes

Water

Water District Name: Coachella Valley Water District
Water District: Yes

Parking SpacesInformation

Total Garage Spaces: 3
Total Parking Spaces: 3

HOA Information

HOA: Yes
HOA Fee 1: 552

Association Information

Association Name: Trilogy at La Quinta Maintenance Assn
Association Phone Number: (760)777-6059
Mgmt Company Email: customercare.ca@fsresidential.

DPR

DPR Eligible: No

Listing, Location and Property Info

Entry Date: 2024-06-27
Land Type: Fee
Subdivision: Trilogy

Community Features

Community Mailbox: Yes
Curbs: Yes
Golf Course Within Development: Yes
Pickle Ball Courts: Yes
Sidewalks: Yes
Street Lighting: Yes

Fencing

Block: Yes

Sale Type

Standard: Yes

Road Surface Type

Paved: Yes

Listing Terms

Cash: Yes
Conventional: Yes

Parking Spaces/Information

RV: None
Total Covered Spaces: 0
Total Uncovered/Assigned Spaces: 0

Lot Description

Back Yard: Yes
Front Yard: Yes
Landscaped: Yes
Lawn: Yes
Level: Yes
Private: Yes
Single Lot: Yes
Utilities Underground: Yes
Yard: Yes

Lot Location

Cul-De-Sac: Yes

View Type

Mountain(s): Yes

Property Orientation Faces

Leisure Faces South: Yes

Other Structures

Guest House/Casita: Yes

Other Structural Features

Misting System: Yes
Premium Lot: Yes

Irrigation

Drip System: Yes
Sprinkler System: Yes
Sprinkler Timer: Yes

Disclosures

CC & R: Yes
Home Warranty Plan: Yes
Homeowners Association: Yes
Pet Restrictions: Yes
Planned Development: Yes

Casita Features

Kitchenette: Yes

Levels

One: Yes

Entry Location

Foyer: Yes

Appliances

Convection Oven: Yes
Dishwasher: Yes
Disposal: Yes
Dryer: Yes
Electric Oven: Yes
Exhaust Fan: Yes
Gas Cooktop: Yes
Ice Maker: Yes
Microwave Oven: Yes
Refrigerator: Yes
Self Cleaning Oven: Yes
Washer: Yes
Water Line to Refrigerator: Yes

Kitchen Features

Granite Slab Counters: Yes
Island: Yes
Pantry: Yes

Eating Areas

Breakfast Counter/Bar: Yes
Breakfast Nook: Yes
Formal Dining Room: Yes
Kitchen Island: Yes

Bedroom Features

All Bedrooms Down: Yes
Primary Retreat: Yes
Primary Suite: Yes
Walk In Closet: Yes

Bathroom Features

Double Vanity(s): Yes
Linen Closet: Yes
Marble Counters: Yes
Shower & Tub: Yes
Shower Over Tub: Yes

Doors

Sliding Doors: Yes

Exterior Construction

Stucco: Yes

Flooring

Ceramic Tile: Yes

Cooling Type

Air Conditioning: Yes
Ceiling Fan(s): Yes
Central Air: Yes

Pool Location

Private: Yes

Pool Accessories

Waterfall: Yes

Pool Construction

Pebble: Yes

Pool Description

Heated: Yes
In Ground: Yes
Private: Yes
Salt Water: Yes
Waterfall: Yes

Spa/Hot Tub Construction

Pebble: Yes

Spa/Hot Tub Description

Heated - Gas: Yes
Private: Yes

Heating

Central: Yes
Forced Air: Yes

Heating Fuel

Natural Gas: Yes

Fireplace Location

Exterior: Yes
Patio: Yes

Fireplace Features

Gas & Wood: Yes
Raised Hearth: Yes
Tile: Yes

Rooms

Breakfast: Yes
Casita - Guest House: Yes
Dining Room: Yes
Entry: Yes
Great Room: Yes
Walk In Pantry: Yes

Interior Features

Built-In Features: Yes
High Ceilings (9 Ft+): Yes
Open Floorplan: Yes
Recessed Lighting: Yes

TV Services

Cable TV: Yes

Laundry

Electric Dryer Hookup: Yes
Gas Dryer Hookup: Yes
Individual Room: Yes

Security Safety

Gated Community: Yes
Resident Manager: Yes

Disability Access

No Interior Steps: Yes

Window Treatments

Awnings: Yes
Custom Window Covering: Yes
Double Pane Windows: Yes
Screens: Yes

Roofing

Concrete: Yes
Tile: Yes

Patio Features

Brick - Tile: Yes
Concrete Slab: Yes
Covered: Yes
Misters: Yes

Sewer

In, Connected and Paid: Yes

Water Heater Feature

Water Heater Central: Yes
Water Heater Unit: Yes

Parking

Driveway: Yes
Garage Door Opener: Yes
Golf Cart Garage: Yes
Oversized: Yes
Side By Side: Yes

Association Amenities

Banquet Facilities: Yes
Barbecue: Yes
Billiard Room: Yes
Bocce Ball Court: Yes
Card Room: Yes
Clubhouse: Yes
Elevator(s): Yes
Fire Pit: Yes
Fitness Center: Yes
Golf Course: Yes
Maintenance Grounds: Yes
Management: Yes
Meeting Room: Yes
Pet Rules: Yes
Tennis Courts: Yes

Association 1 Frequency

Monthly: Yes

Association Fees Include

Cable TV: Yes
Clubhouse: Yes
Concierge: Yes
Security: Yes
Sewer: Yes
Trash: Yes

Association Pet Rules

Assoc Pet Rules: Yes
Call: Yes

Contingent Upon

Appraisal: Yes
Inspection: Yes
Loan Approval: Yes

Land Lease Type

Fee Simple: Yes

Listing Office: Equity Union

Listing Agent: Donna Ambrose

Last Updated: September - 09 - 2026

Information deemed reliable but not guaranteed.