With a portal you are able to:
- Save your searches
- Get updates on listings
- Track listings
- Add notes and messages
- Personalize your dashboard
57914 Santa Rosa Trail, La Quinta, CA 92253
$1,244,000
Property Type:
Residential
Bedrooms:
4
Baths:
5
Square Footage:
2,755
Status:
Active
Current Price:
$1,244,000
List Date:
11/11/2025
Last Modified:
12/22/2025
Description
Stunning Resort-Style Home in Gated Community with Mountain Views!
Welcome to your dream retreat! Nestled in a prestigious gated community, this immaculate 4-bedroom, 4.5-bathroom home offers 2,755 sq. ft. of luxurious living space and every upgrade imaginable. From the moment you step through the elegant double-door entry, you'll be captivated by the open floor plan, high-end finishes, and seamless indoor-outdoor living.
The backyard oasis is perfect for private entertaining, featuring a pebbled saltwater pool and spa with cascading waterfalls, a built-in BBQ grill, patio gas fireplace, and mini golf course — all surrounded by expansive patio space ideal for lounging or dining under the stars.
Inside, the home boasts updated stainless steel appliances, a commercial-grade air purifier using NASA technology, and a filtered drinking water system with an alkaline water option. The spacious 3-car garage includes epoxy flooring and ample storage.
The luxurious primary suite features a cozy fireplace, walk-in closet, jet spa tub, and stand-alone shower, creating a perfect sanctuary.
As a bonus, enjoy a detached casita with a full bathroom — ideal as a guest suite, home office, or income-producing rental.
Located just minutes from PGA West, Lake Cahuilla, and world-famous Coachella Valley music festivals, this home offers the ultimate in resort-style desert living — complete with breathtaking views of the Santa Rosa Mountains.
More Information MLS# 219138594
Listing, Location and Property Info
Entry Date: 2025-11-11
Land Type: Fee
General Property Information
Fireplace: Yes
Building # of Stories: 1
Total Fireplaces: 3
Pool: Yes
Garage: Yes
Garage Description: Attached
Sprinklers: Yes
Furnished: Furnished
Total Bedrooms: 4
Full Baths: 4
Half Baths: 1
Approx SqFt: 2755
Total Baths: 5
SqFt Source: Assessor
Lot Size: 10019
Lot Size Source: Assessor
Year Built: 2005
Cross Streets: Madison & Avenue 58
Listing Info
Short Term Rentals: Unknown
Will Consider Lease: No
School District: Desert Sands Unified
Junior Middle School: Cahuilla Desert Acad
High School: Coachella Valley
Tax Info
Tax Mello Roos: No
Property Info
View: Yes
Entry Floor Number: 1
Golf Course Within Development: No
Senior Community: No
Gated Community: Yes
PUD Y/N: No
Total Monthly Association Fees: 240
Community Features
Dog Park: 1
Fencing
Block: 1
Utilities
Electricity Connected: 1
Natural Gas Connected: 1
Sewer Connected: 1
Water Connected: 1
Sale Type
Standard: 1
Road Surface Type
Asphalt: 1
Listing Terms
Cash: 1
Cash to New Loan: 1
Possession
Close Of Escrow: 1
Parking Spaces/Information
Total Covered Spaces: 3
Total Uncovered/Assigned Spaces: 0
Lot Description
Back Yard: 1
Front Yard: 1
Landscaped: 1
Lawn: 1
View Type
Mountain(s): 1
Pool: 1
Trees/Woods: 1
Valley: 1
Property Orientation Faces
Front Door Faces East: 1
Other Structures
Guest House/Casita: 1
Other Structural Features
Barbeque Private: 1
Slab: 1
Irrigation
Sprinkler System: 1
Disclosures
CC & R: 1
Homeowners Association: 1
Casita Features
Other: Full bathroom
Building Style
Spanish: 1
Levels
One: 1
Entry Location
Ground Level - No Steps: 1
Appliances
Dishwasher: 1
Gas Oven: 1
Gas Range: 1
Water Purifier: 1
Water Softener: 1
Built-In BBQ
Gas: 1
Range Hood
Yes: 1
Warmer Oven Drawer
No: 1
Kitchen Features
Gourmet Kitchen: 1
Granite Counters: 1
Island: 1
Pantry: 1
Eating Areas
Breakfast Counter/Bar: 1
Dining Area: 1
Bedroom Features
Primary Retreat: 1
Bathroom Features
Double Vanity(s): 1
Linen Closet: 1
Tub With Jets: 1
Exterior Construction
Stucco: 1
Foundation
Slab: 1
Flooring
Carpet: 1
Tile: 1
Cooling Type
Air Conditioning: 1
Ceiling Fan(s): 1
Central Air: 1
Dual: 1
Pool Location
Private: 1
Pool Accessories
Waterfall: 1
Pool Construction
In Ground: 1
Pebble: 1
Pool Description
Heated: 1
In Ground: 1
Salt Water: 1
Spa/Hot Tub Construction
Pebble: 1
Spa/Hot Tub Description
Heated - Gas: 1
Heating
Forced Air: 1
Heating Fuel
Natural Gas: 1
Fireplace Location
Living Room: 1
Patio: 1
Primary Retreat: 1
Fireplace Features
Gas: 1
Rooms
Casita - Guest House: 1
Entry: 1
Living Room: 1
Walk In Pantry: 1
Laundry
Individual Room: 1
Security Safety
Gated Community: 1
Window Treatments
Shutters: 1
Roofing
Clay Tile: 1
Sewer
In, Connected and Paid: 1
Water
In Street: 1
Parking
Driveway: 1
HOA Information
HOA: Yes
HOA Fee 1: 240
Association Amenities
Other: 1
Association 1 Frequency
Monthly: 1
Association Information
Association Name: Santa Rosa Trail Owners Association, Inc.
Land Lease Type
Fee Simple: 1
DPR
DPR Eligible: No
Listing Location and Property Info
APN: 762460032
Status: Active
Listing Date: 2025-11-11
Original List Price: 1244000
List Price: $1,244,000
Current Price: $1,244,000
Property Sub-Type: Single Family Residence
Street #: 57914
Street Name: Santa Rosa
Street Suffix: Trail
County: Riverside
State: CA
Zip Code: 92253
Area: 313 -La Quinta South of HWY 111
Subdivision: Santa Rosa Trail
Country: US
Status Change Info
Status Change Date: 2025-11-11
Parking SpacesInformation
Total Garage Spaces: 3
Total Parking Spaces: 6
Property Features
Sale Type: Standard
Listing Terms: Cash; Cash to New Loan
Possession: Close Of Escrow
Lot Description: Back Yard; Front Yard; Landscaped; Lawn
View Type: Mountain(s); Pool; Trees/Woods; Valley
Property Orientation Faces: Front Door Faces East
Other Structures: Guest House/Casita
Other Structural Features: Barbeque Private; Slab
Irrigation: Sprinkler System
Fencing: Block
Disclosures: CC & R; Homeowners Association
Community Features: Dog Park
Building Style: Spanish
Levels: One
Entry Location: Ground Level - No Steps
Appliances: Dishwasher; Gas Oven; Gas Range; Water Purifier; Water Softener
Built-In BBQ: Gas
Range Hood: Yes
Warmer Oven Drawer: No
Kitchen Features: Gourmet Kitchen; Granite Counters; Island; Pantry
Eating Areas: Breakfast Counter/Bar; Dining Area
Bedroom Features: Primary Retreat
Bathroom Features: Double Vanity(s); Linen Closet; Tub With Jets
Exterior Construction: Stucco
Foundation: Slab
Flooring: Carpet; Tile
Cooling Type: Air Conditioning; Ceiling Fan(s); Central Air; Dual
Pool Location: Private
Pool Accessories: Waterfall
Pool Construction: In Ground; Pebble
Pool Description: Heated; In Ground; Salt Water
Heating: Forced Air
Heating Fuel: Natural Gas
Fireplace Location: Living Room; Patio; Primary Retreat
Fireplace Features: Gas
Rooms: Casita - Guest House; Entry; Living Room; Walk In Pantry
Laundry: Individual Room
Security Safety: Gated Community
Window Treatments: Shutters
Roofing: Clay Tile
Utilities: Electricity Connected; Natural Gas Connected; Sewer Connected; Water Connected
Sewer: In, Connected and Paid
Water: In Street
Parking: Driveway
Road Surface Type: Asphalt
Association 1 Frequency: Monthly
Association Amenities: Other
Land Lease Type: Fee Simple
Listing Office:
Berkshire Hathaway HomeServices California Properties
Listing Agent:
Douglas S Kolker
Last Updated: December - 22 - 2025
Information deemed reliable but not guaranteed.