Sign In

Close

x
Showing 1 of 0
X
Save
78625 Avenida Ultimo La Quinta CA 92253US4 Bed, 4.00 Bath (3 Full Bath , 1 Half Bath), 219149858
78625 Avenida Ultimo La QuintaCA92253
1550000.0000 1/1/1900 12:00:00 AM
Realty Executives Desert Lifestyles (La Quinta)
78065 Main St #107La QuintaCA92253
760-771-9090

78625 Avenida Ultimo
La Quinta CA 92253 US

Save
1 /

Courtesy of: Raymond J Radas, Equity Union, raymondradas@gmail.com

Realty Executives Desert Lifestyles (La Quinta)
78065 Main St #107
La Quinta, CA, US 92253
760-771-9090

Get more info about this property

78625 Avenida Ultimo
La Quinta CA 92253 US

$1,550,000

Active Listing ID 219149858
bed icon
4 bed
bath icon
4.00 Bath (3 Full , 1 Half)
lot icon
Lot: 0.28 Acres
home icon
Single Family Residence

$1,550,000

Active Listing ID 219149858
Save
3d icon
Maps

78625 Avenida Ultimo 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.28 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air, Zoned
  • Floor Covering: Laminate
  • Heating Fuels: Forced Air
  • Additional Features
  • Pool

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1550000
  • unparsedaddress: 78625 Avenida Ultimo
  • postalcity: La Quinta
  • stateorprovince: CA
  • country: US
  • postalcode: 92253
  • bathroomsfull: 3
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.28
  • lotsizeunits: Acres
  • lotsizearea: 0.28
  • livingarea: 2611
  • livingareaunits: Square Feet
  • latitude: 33.681517
  • longitude: -116.292167
  • listagentfullname: Raymond J Radas
  • listagentemail: raymondradas@gmail.com
  • listagentkey: 3yd-CDARCA-D76181
  • listagentmlsid: D76181
  • listagentpreferredphone: 7604854586
  • listagentofficephone: 7604854586
  • listofficekey: 3yd-CDARCA-d24411
  • listofficemlsid: d24411
  • disclaimer: Copyright © 2026 California Desert Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: CDARCA
  • yearbuilt: 1991
  • listingcontractdate: 2026-07-02
  • listagenturl: https://equityunion.com
  • countyorparish: Riverside
  • parcelnumber: 770092002
  • appliances: Convection Oven, Dishwasher, Dryer, Microwave Oven, Refrigerator, Washer, Water Line to Refrigerator
  • cooling: Central Air, Zoned
  • flooring: Laminate
  • heating: Forced Air
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 1
  • parkingtotal: 6
  • parkingfeatures: Covered, Driveway, Open, Assigned
  • waterfrontyn: False
  • franchiseaffiliation: None
  • rooms: Bathroom 4, Bedroom 2, Bedroom 3, Bedroom 1, Bathroom 1, Bathroom 3, Bathroom 2, Bedroom 4
  • securityfeatures: Security Lighting
  • otherstructures: Pool House
  • speciallistingconditions: Standard
  • dock: False
  • poolprivateyn: True
  • spayn: True
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -116.29217, 33.68152
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Equity Union Real Estate", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"raymondradas@gmail.com", "ListBrokerageCity":"Sherman Oaks", "ListBrokerageCountry":"US", "ListBrokerageEmail":"veronica@equityunion.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Equity Union Real Estate", "ListBrokeragePhone":"(818) 631-1660", "ListBrokeragePostalCode":"91423", "ListBrokerageStateOrProvince":"CA", "ListBrokerageUnitNumber":"STE 350", "ListBrokerageUnparsedAddress":"13412 VENTURA BLVD", "ListBrokerageWebsiteUrl":"https://equityunion.com", "ListOfficeAddress1":"70115 Hwy 111 ", "ListOfficeAddress2":"STE 350", "ListOfficeBrokerMlsId":"d24411", "ListOfficeCity":"Rancho Mirage", "ListOfficeCountry":"US", "ListOfficeEmail":"veronica@equityunion.com", "ListOfficePostalCode":"92270", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - La Quinta, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/78625-Avenida-Ultimo_La-Quinta_CA_92253_M22111-85081?f=listhub&s=CDARCA&m=219149858&c=rexren", "MLSModificationTimestamp":"2026-07-03 14:11:37", "Neighborhoods":[{"Description":null, "Name":"Desert Club Estates"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/3/2026 2:26:47 PM GMT
Source Updated Date: 7/3/2026 6:48:09 PM GMT

Courtesy of: Raymond J Radas, Equity Union, raymondradas@gmail.com

Copyright © 2026 California Desert Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact