---
listing_id: CR219152370DA
status: Active
price: 935000
beds: 3
baths_full: 3
baths_half: 0
sqft_living: 2246
sqft_lot: 13068
lot_acres: 0.3
year_built: 1996
property_type: Residential
property_subtype: Single Family Residence
address: "78515 Avenida Ultimo"
city: La Quinta
state: CA
zip: 92253
county: "Riverside County"
lat: 33.6815349
lng: -116.2942208
days_on_market: 54
hoa_fee: 
hoa_frequency: 
garage_spaces: 3
list_agent: "Richard MacMillan"
list_office: "Equity Union"
list_agent_phone: "(760) 574-2299"
list_agent_license: 01183445
mls_source: CRMLS
modified: 2026-10-29
transaction_type: buy
---

Home | Riverside County | La Quinta | 92253 | 78515 Avenida Ultimo

78515 Avenida Ultimo, La Quinta, CA 92253

MLS: CR219152370DA | Status: Active | Price: $935,000
Beds/Baths: 3 / 3
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Acres Lot Yr Built
3 3 2,246 0.3 1996

Upcoming Open Houses

Date Time Hosted By
Saturday, October 31 11:00 am - 1:00 pm Richard MacMillan
Sunday, November 1 11:00 am - 1:00 pm Richard MacMillan

Remarks

Private La Quinta Retreat with Pool, Mountain Views & Owned Solar.Welcome to a private desert retreat in desirable Desert Club Estates, where generous living spaces, mature landscaping and resort-style outdoor amenities come together in a setting designed for the La Quinta lifestyle.This spacious 3-bedroom, 3-bath residence offers approximately 2,560 square feet of living space on an approximately 13,068-square-foot lot with a 3-car garage. Inside, an open and versatile floor plan features multiple living and dining areas, high ceilings and abundant natural light. The kitchen offers granite countertops, stainless-steel appliances, double ovens, a gas cooktop and plenty of cabinetry, opening comfortably to the surrounding living spaces.Step outside and discover a backyard made for enjoying the desert. A private pool and spa, covered patio areas, outdoor fireplace, built-in BBQ/outdoor kitchen and mature landscaping create multiple spaces for entertaining or simply relaxing at home. Palm trees and surrounding greenery enhance the sense of privacy, while desert and mountain views provide a beautiful backdrop.The home also provides a 32-panel owned solar energy system, offering the benefit of solar-generated electricity.Additional highlights include a 3-car garage, two fireplaces (1

MLS Listing Information

Field Value
MLS # CR219152370DA
MLS Source California Regional MLS
Days on Site 54

Features

Interior Features

Feature Details
Family Room Other
Fireplace Family Room, Gas Burning, Outside
Cooling Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Pool In Ground, Spa - Private

Parking, School, and Other Information

Feature Details
Garage/Parking Other, Garage: 3 Car(s)

Contact Information

Listing Agent Co-Listing Agent
Richard MacMillan Paige Maccio Smith
Equity Union Equity Union
License #: 01183445 License #: 01956853
Phone: (760) 574-2299 Phone: (760) 851-8514

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
John Adams Early Childhood Learning Center public KG,1 0.39 mi N/A
Harry S. Truman Elementary School public K-5 0.51 mi 5
La Quinta Middle School public 6-8 0.61 mi 4
Benjamin Franklin Elementary School public K-5 0.70 mi 6
La Quinta High School public 9-12 2.35 mi 7
Mountain Vista Elementary School public K-6 2.78 mi 4
Amelia Earhart Elementary School Of International Studies public K-5 2.86 mi 6
John Glenn Middle School Of International Studies public 6-8 2.91 mi 6
James Madison Elementary School public K-5 3.21 mi 3
Gerald R. Ford Elementary School public K-5 3.36 mi 9
Desert Sands Adult public UG 3.54 mi N/A
Colonel Mitchell Paige Middle School public 6-8 3.54 mi 2
Horizon School public K-12 3.61 mi 4
Summit High (Continuation) School public 10-12 3.61 mi 2
Indio Middle School public 6-8 3.77 mi 1
Dr. Reynaldo J. Carreon Jr. Academy public K-5 3.88 mi 6
Indio High School public 9-12 3.88 mi 4
John F. Kennedy Elementary School public K-5 4.04 mi 1
Cahuilla Desert Academy Junior High public 7-8 4.11 mi 3
Carrillo Ranch Elementary School public K-5 4.22 mi 6

Nearby Homes

Address Price Beds Baths Sq Ft Status
48345 via Solana $899,000 3 3 2,040 Contingent
51862 via Jimeno $950,000 4 3/1 2,653 Active
51304 Avenida Vallejo $885,000 4 4 1,870 Active
53480 Avenida Mendoza $849,000 3 2/1 1,629 Active

Disclosures

©2026 California Regional MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from California Regional MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of October 29, 2026. For the most current information, please contact Richard MacMillan, (760) 574-2299.