Mountain Homes Realty
Enter City, Zip or MLS

78625 avenida ultimo

La Quinta, CA 92253

$1,550,000

4 BEDS 3-Full 1-Half BATHS
2,611 SQFT0.28 AC LOT
Residential - Single Family
New Listing
Image 1
Image 2
Image 3
Image 4
Bedrooms 4
Total Baths 4
Full Baths 3
Square Feet 2611
Acreage 0.28
Status Active
MLS # 219149858DA
County Riverside
More Info
Category Residential - Single Family
Status Active
Square Feet 2611
Acreage 0.28
MLS # 219149858DA
County Riverside
No HOA! Located in desirable Desert Club Estates near Old Town La Quinta, this custom-built 4-bedroom, 4-bath home sits on a large lot surrounded by other custom residences. Completely remodeled from top to bottom, the property features a brand-new pool, beautifully landscaped grounds, expansive patio space, and grassy areas ideal for entertaining. The open floor plan includes a spacious great room, chef's kitchen with large island and premium appliances, generous dining area, and covered patio for outdoor dining. The primary suite offers French doors to the garden and a spa-inspired bath. Three additional guest rooms continue the elevated design, each with French doors opening to the pool and garden. The garage is equipped with an electric vehicle charging station. Offered turnkey furnished with designer furnishings and everything needed to enjoy the La Quinta desert lifestyle.
Location not available
Listing
Street
Satellite

Exterior Features

  • Construction Single Family
  • Garage Yes
  • Garage Description DirectAccess, Driveway, Garage, GarageDoorOpener
  • Lot Description DripIrrigationBubblers, SprinklersTimer, SprinklerSystem

Interior Features

  • Appliances ConvectionOven, Dishwasher, Microwave, Refrigerator, WaterToRefrigerator
  • Heating ForcedAir
  • Cooling CentralAir, Zoned
  • Fireplaces No
  • Living Area 2,611 SQFT
  • Year Built 1991

Neighborhood & Schools

  • Subdivision Desert Club Estates

Financial Information

  • Parcel ID 770092002

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Equity Union
The data for this listing came from the California Regional MLS
Listing data is current as of 07/07/2026.
California DRE #02247371

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.