Skip main navigation
For sale
  • Listed by: Equity Union • Richard MacMillan • 760-574-2299
    $965,000

    78515 Avenida Ultimo, La Quinta, CA 92253

    3beds
    2,246sqft
    : 
    $6,804/mo
    Get pre-qualified
    Single Family Residence
    Built in 1996
    0.3 Acres Lot
    $935,600 Zestimate®
    $430/sqft
    $-- HOA

    What's special

    Private pool and spaOutdoor fireplaceMature landscapingAbundant natural lightOversized lotResort-style outdoor amenitiesHigh ceilings
    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 indoor, 1 outdoor), indoor laundry, multiple French doors providing access to the backyard, and an oversized lot that gives the property a wonderful sense of space and privacy.A distinctive La Quinta property offering space, privacy, solar, mountain views and true indoor-outdoor desert living.
    38 days
    1,235
    85

    Zillow last checked:

    Listing updated:

    Listed by:

    Richard MacMillan DRE #01183445 760-574-2299,

    Equity Union,

    Paige Maccio-Smith DRE #01956853 760-851-8514,

    Equity Union

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 3
      Rooms
      • Room types: Family Room, Great Room
      Heating
      • Central
      Cooling
      • Central Air
      Features
      • Partially Furnished
      • Flooring: Carpet, Tile
      • Has fireplace: Yes
      • Fireplace features: Family Room, Gas, Outside
      Interior area
      • Total interior livable area: 2,246 sqft

      Property

      Parking
      • Total spaces: 6
      • Parking features: Driveway
      • Attached garage spaces: 3
      • Uncovered spaces: 3
      Features
      • Levels: One
      • Stories: 1
      • Has private pool: Yes
      • Pool features: In Ground
      • Spa features: In Ground, Private
      Lot
      • Size: 0.3 Acres
      • Features: Sprinklers Timer
      Details
      • Parcel number: 770091002
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Condition
      • New construction: No
      • Year built: 1996

      Community & HOA

      Community
      • Subdivision: Desert Club Estates
      Location
      • Region: La Quinta

      Financial & listing details

      • Price per square foot: $430/sqft
      • Tax assessed value: $1,045,499
      • Date on market: 9/5/2026
      • Listing terms: Cash,Cash to New Loan,FHA,VA Loan

        Estimated market value

        $935,600

        $889,000 - $982,000

        $5,003/mo

        Price history

        DateEventPrice
        9/6/2026Listed for sale$965,000-14.2%$430/sqft
        Source: Greater Palm Springs Realtors #219152370 Report a problem
        12/16/2025Listing removed$1,125,000$501/sqft
        Source: CDAR/ Desert Area MLS #219136566 Report a problem
        10/8/2025Listed for sale$1,125,000-6.3%$501/sqft
        Source: Greater Palm Springs Realtors #219136566 Report a problem
        10/7/2025Listing removed$1,200,000$534/sqft
        Source: Greater Palm Springs Realtors #219130788 Report a problem
        6/19/2025Price change$1,200,000-4%$534/sqft
        Source: CDAR/ Desert Area MLS #219130788 Report a problem
        5/30/2025Listed for sale$1,250,000+22%$557/sqft
        Source: Greater Palm Springs Realtors #219130788 Report a problem
        12/3/2024Sold$1,025,000-3.2%$456/sqft
        Source: CRMLS #SB24077175 Report a problem
        11/29/2024Pending sale$1,059,000$472/sqft
        Source: CRMLS #SB24077175 Report a problem
        10/24/2024Contingent$1,059,000$472/sqft
        Source: CRMLS #SB24077175 Report a problem
        10/4/2024Price change$1,059,000-7.8%$472/sqft
        Source: CRMLS #SB24077175 Report a problem
        10/2/2024Listed for sale$1,149,000-8.1%$512/sqft
        Source: CRMLS #SB24077175 Report a problem
        11/14/2022Listing removed--
        Source: CDAR/ Desert Area MLS Report a problem
        11/13/2022Listed for sale$1,249,999+380.8%$557/sqft
        Source: CDAR/ Desert Area MLS #219087177 Report a problem
        10/15/2009Sold$260,000+4%$116/sqft
        Source: Public Record Report a problem
        9/12/2009Price change$249,900-9.1%$111/sqft
        Source: foreclosure.com Report a problem
        8/7/2009Price change$274,900-9.2%$122/sqft
        Source: foreclosure.com Report a problem
        7/2/2009Listed for sale$302,900-10.6%$135/sqft
        Source: foreclosure.com Report a problem
        2/25/2009Sold$338,852+50.6%$151/sqft
        Source: Public Record Report a problem
        10/6/2000Sold$225,000+800%$100/sqft
        Source: Public Record Report a problem
        12/4/1995Sold$25,000$11/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026-- $1,045,499 +2%
        2025$13,356 +184.3%$1,025,000 +211.5%
        2024$4,698 +3.1%$329,012 +2%
        2023$4,558 +3.6%$322,562 +2%
        2022$4,401 +2.6%$316,238 +2%
        2021$4,289 +1.8%$310,038 +1%
        2020$4,212 +2.1%$306,860 +2%
        2019$4,127 +2.2%$300,845 +2%
        2018$4,037 +1.5%$294,947 +2%
        2017$3,976 $289,164 +2%
        2016$3,976 +1.6%$283,495 +1.5%
        2015$3,913 +1.6%$279,240 +2%
        2014$3,851 $273,773 +0.5%
        2013-- $272,538 +2%
        2012-- $267,195 +2%
        2011-- $261,957 +0.8%
        2010-- $260,000 -1.2%
        2009-- $263,272 +2%
        2008-- $258,111 +2%
        2007-- $253,051 +2%
        2006-- $248,090 +2%
        2005-- $243,226 +3.9%
        2003-- $234,090 +2%
        2002-- $229,500 +2%
        2001$3,359 +12.2%$225,000 +21%
        2000$2,994 $185,971
        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 92253

        Getting around

        53 / 100
        Somewhat Walkable
        44 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts