Custom designed gated 3 car garage home!!!Gorgeous remodeled kitchen and Primary Bath! Living Room, Formal Dining Room, Foyer, Great Room, Family Room, Casual Dining Room, Kitchen, Laundry Room, 3 Bedrooms (2 are matching primary suites) and 3 Full Bathrooms! Dramatic waterfall pool and spa! Living room/Dining Room have 12-foot ceilings, all the other rooms have 9-foot ceilings. Washer, Dryer, Counter-depth Frig, Gas Cook-top (w/ down-draft), Dishwasher, built-in Full-size Double Ovens, Built-in Beverage/Wine Frig and Built-in Microwave Oven. Kitchen remodel (2022). Italian Stainless-steel sink. Chrome Faucet. High-end Decorator solid chrome handles in kitchen, all 3 bathrooms, laundry room and closet. This subdivision is private and quiet, no through streets. No HOA! This home is great for entertaining. Living/dining room opens to the great room which opens to the yard/pool. open concept kitchen, family room, casual dining. Outdoor entertaining is ready with built in BBQ, large yard pool and spa, Fireplace (gas) and patio off of primary suite. Great family home or vacation home. Owned Solar.
Property Details
Price:
$1,125,000
MLS #:
219136566PS
Status:
Active
Beds:
3
Baths:
3
Type:
Single Family
Subtype:
Single Family Residence
Subdivision:
Desert Club Estates
Listed Date:
Oct 8, 2025
Finished Sq Ft:
2,246
Lot Size:
13,068 sqft / 0.30 acres (approx)
Year Built:
1996
See this Listing
Schools
Interior
Appliances
Gas Cooktop, Electric Oven, Vented Exhaust Fan, Water Line to Refrigerator, Refrigerator, Dishwasher, Range Hood
Cooling
Gas
Fireplace Features
Masonry, Gas, Outside, Family Room
Flooring
Tile
Heating
Central, Natural Gas
Interior Features
Partially Furnished
Exterior
Fencing
Stucco Wall
Garage Spaces
3.00
Lot Features
Sprinklers Drip System, Sprinkler System
Parking Features
Garage Door Opener
Pool Features
Waterfall, Pebble, Electric Heat
Security Features
Automatic Gate
Spa Features
Heated, In Ground
Stories Total
1
View
Pool
Financial
Map
Community
- Address78515 Avenida Ultimo La Quinta CA
- SubdivisionDesert Club Estates
- 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 Desert Club Estates subdivision, 78515 Avenida Ultimo La Quinta CA is a Single Family for sale in La Quinta, CA, 92253. It is listed for $1,125,000 and features 3 beds, 3 baths, and has approximately 2,246 square feet of living space, and was originally constructed in 1996. The current price per square foot is $501. 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
78515 Avenida Ultimo
La Quinta, CA