Skip main navigation
For sale
  • Listed by: Equity Union • Raymond Radas • Contact: 760-485-4586
    $1,550,000

    78625 Avenida Ultimo, La Quinta, CA 92253

    4beds
    2,611sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1991
    0.28 Acres Lot
    $1,459,600 Zestimate®
    $594/sqft
    $-- HOA

    What's special

    Large lotBrand-new poolExpansive patio spaceBeautifully landscaped groundsOpen floor planGenerous dining areaSpacious great room
    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.
    10 days
    |
    921
    |
    65
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Raymond Radas DRE #01091175 760-485-4586,

    Equity Union

    Source: CRMLS,MLS#: 219149858DAMLS LogoOriginating MLS: California Desert AOR & Palm Springs AOR

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Rooms
      • Room types: Great Room, Dining Room
      Kitchen
      • Features: Kitchen Island, Remodeled, Updated Kitchen
      Heating
      • Forced Air
      Cooling
      • Central Air, Zoned
      Appliances
      • Included: Convection Oven, Dishwasher, Microwave, Refrigerator, Water To Refrigerator
      • Laundry: Laundry Room
      Features
      • Breakfast Bar, Separate/Formal Dining Room, Furnished, High Ceilings
      • Flooring: Laminate
      • Doors: French Doors
      • Has fireplace: No
      • Furnished: Yes
      Interior area
      • Total interior livable area: 2,611 sqft

      Property

      Parking
      • Total spaces: 6
      • Parking features: Direct Access, Driveway, Garage, Garage Door Opener
      • Attached garage spaces: 2
      • Uncovered spaces: 2
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Wrap Around
      • Has private pool: Yes
      • Pool features: In Ground, Private, Salt Water
      • Spa features: Heated, In Ground, Private
      • Fencing: Stucco Wall
      • Has view: Yes
      • View description: Mountain(s)
      Lot
      • Size: 0.28 Acres
      • Features: Drip Irrigation/Bubblers, Sprinklers Timer, Sprinkler System
      Details
      • Parcel number: 770092002
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Condition
      • Updated/Remodeled
      • New construction: No
      • Year built: 1991

      Utilities & green energy

      • Electric: 220 Volts in Garage

      Community & HOA

      Community
      • Security: Closed Circuit Camera(s), Security Gate, Security Lights
      • Subdivision: Desert Club Estates
      Location
      • Region: La Quinta

      Financial & listing details

      • Price per square foot: $594/sqft
      • Tax assessed value: $771,394
      • Annual tax amount: $10,251
      • Date on market: 7/2/2026
      • Listing terms: Cash,Cash to New Loan,1031 Exchange
      • Inclusions: Turnkey furnished.

        Estimated market value

        $1,459,600

        $1.39M - $1.53M

        $5,336/mo

        Price history

        DateEventPrice
        7/2/2026Listed for sale$1,550,000+20.6%$594/sqft
        Source: CDAR/ Desert Area MLS #219149858 Report a problem
        6/6/2026Listing removed$6,996$3/sqft
        Source: Zillow Rentals Report a problem
        2/28/2025Price change$6,996-28.2%$3/sqft
        Source: Zillow Rentals Report a problem
        11/30/2024Listed for rent$9,750-1.2%$4/sqft
        Source: Zillow Rentals Report a problem
        7/25/2024Listing removed--
        Source: Zillow Rentals Report a problem
        5/6/2024Listed for rent$9,870+182%$4/sqft
        Source: Zillow Rentals Report a problem
        8/22/2023Listing removed--
        Source: HomeSmart Report a problem
        4/28/2023Price change$1,285,000-1.2%$492/sqft
        Source: Greater Palm Springs Realtors #219094216 Report a problem
        11/11/2022Listed for sale$1,300,000+92.6%$498/sqft
        Source: CDAR/ Desert Area MLS #219087104 Report a problem
        8/24/2021Sold$675,000-9.9%$259/sqft
        Source: CDAR/ Desert Area MLS #219062756 Report a problem
        8/9/2021Contingent$749,000$287/sqft
        Source: Greater Palm Springs Realtors #219062756 Report a problem
        5/28/2021Listed for sale$749,000+26650%$287/sqft
        Source: Greater Palm Springs Realtors #219062756 Report a problem
        8/16/2019Sold$2,800-99.4%$1/sqft
        Source: Greater Palm Springs Realtors #19474382PS Report a problem
        6/25/2019Listing removed$3,500$1/sqft
        Source: Hayes Real Estate #19474382PS Report a problem
        6/8/2019Price change$475,000-5%$182/sqft
        Source: Hayes Real Estate #19474366PS Report a problem
        6/5/2019Listed for rent$3,500$1/sqft
        Source: Hayes Real Estate #19474382PS Report a problem
        2/20/2019Price change$499,900-5.5%$191/sqft
        Source: HK Lane Real Estate #218033026 Report a problem
        11/23/2018Price change$529,000-3.6%$203/sqft
        Source: HK Lane Real Estate #218033026 Report a problem
        8/13/2018Listed for sale$549,000+23.4%$210/sqft
        Source: Bennion Deville Homes #218022472 Report a problem
        10/5/2004Sold$445,000$170/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$10,251 +2.3%$771,394 +9.8%
        2024$10,015 +14.1%$702,269 +2%
        2023$8,780 +2.5%$688,500 +2%
        2022$8,561 +16.9%$675,000 +16%
        2021$7,322 +12.7%$581,875 +12%
        2020$6,497 +3.1%$519,532 +3%
        2019$6,302 +4.2%$504,400 +4%
        2018$6,049 +6.8%$485,000 +6.6%
        2017$5,666 $455,000 -3.8%
        2016$5,666 -6.5%$473,000 -1.9%
        2015$6,058 +23.1%$482,000 +23.9%
        2014$4,923 $389,000 +10.2%
        2013-- $353,000 +20.1%
        2012-- $294,000 -8.1%
        2011-- $320,000 +0.6%
        2010-- $318,000 -16.1%
        2009-- $379,000 -23.2%
        2008-- $493,459 +2%
        2007-- $483,785 +2%
        2006-- $474,300 +6.6%
        2005-- $445,000 +62%
        2003-- $274,708 +2%
        2002-- $269,323 +2%
        2001$3,532 +1.7%$264,044 +2%
        2000$3,473 $258,868
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 92253

        Getting around

        45 / 100
        Car-Dependent
        30 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            • Local buyer's agents are ready to help