Skip main navigation
Off market
  • $976,300

    78745 Avenida Ultimo, La Quinta, CA 92253

    4beds
    3,135sqft
    SingleFamily
    Built in 2003
    0.27 Acres Lot
    $976,300 Zestimate®
    $311/sqft
    $5,798 Estimated rent

    Home value

    $976,300

    $898,000 - $1.06M

    $5,798/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,798/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,798/mo

    Rent Zestimate®

    Refinance and save

    $6,137/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,137/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    On one of the finest streets in Desert Club Estates, we proudly present this custom built and newly remodeled pool home on Avenida Ultimo. No expense was spared on this large 4 bedroom 3 bath home opposite to a beautiful golf course. Beautiful dark hardwood flooring flows throughout the home. Two large fireplaces with custom stonework are featured prominently in the family room and Master bedroom. The master bedroom also features two large walk in closets and stunning granite on the vanity and surrounding the tub. A large entertainer's kitchen with stainless steel appliances and stunning dark granite. The covered patio and outdoor entertainment area includes a built in bbq, custom pool and spa, and gorgeous mountain views. Close to Old Town La Quinta and Silver Rock golf course where La Quinta residents pay only $35. No HOA! A must see and priced for immediate sale.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Forced air, Other, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Trash compactor, Washer
    • Laundry: Laundry Area
    Features
    • Flooring: Tile, Hardwood
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 3,135 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stucco
    • Has spa: Yes
    • Has view: Yes
    • View description: Mountain
    Lot
    • Size: 0.27 Acres
    Details
    • Parcel number: 770092006

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Other
    Condition
    • Year built: 2003

    Community & neighborhood

    Location
    • Region: La Quinta

    Other

    Other facts
    • LandLeaseType: Fee
    • ParkingGarage: Driveway, Garage - 3 Car
    • PropertyType: Residential
    • Equipment: Range/Oven, Gas Dryer Hookup, Barbeque
    • Heating: Central
    • Rooms: Master Bedroom, Entry, Great Room, Den
    • Laundry: Laundry Area
    • SourceLivingArea: Vendor Enhanced
    • SourceLotSizeArea: Vendor Enhanced
    • Style: Mediterranean
    • ListingArea: La Quinta South of HWY 111
    • Disclosures: LA/Owner Related

    Price history

    DateEventPrice
    12/21/2017Sold$550,000+1.9%$175/sqft
    Source: CDAR/ Desert Area MLS #17274654 Report a problem
    10/15/2017Pending sale$540,000$172/sqft
    Source: Gilbert Avriette #17274654PS Report a problem
    9/29/2017Listed for sale$540,000+19185.7%$172/sqft
    Source: Gilbert Avriette #17274654PS Report a problem
    6/27/2016Sold$2,800-99.5%$1/sqft
    Source: Agent Provided Report a problem
    5/24/2016Listed for sale$540,000$172/sqft
    Source: Hom Sotheby's International Re #16108250PS Report a problem
    5/21/2016Pending sale$540,000$172/sqft
    Source: Hom Sotheby's International Re #16108250PS Report a problem
    4/20/2016Price change$540,000-1.3%$172/sqft
    Source: Hom Sotheby's International Re #a002 Report a problem
    1/13/2016Price change$547,000-1.8%$174/sqft
    Source: Gilbert Avriette #15951481PS Report a problem
    11/30/2015Price change$557,000+1.3%$178/sqft
    Source: Gilbert Avriette #15951481PS Report a problem
    10/19/2015Listed for sale$550,000-5%$175/sqft
    Source: Gilbert Avriette #15892939PS Report a problem
    8/15/2015Listing removed$579,000$185/sqft
    Source: Gilbert Avriette #15892939PS Report a problem
    5/18/2015Price change$579,000-1.7%$185/sqft
    Source: Gilbert Avriette #15892939PS Report a problem
    4/15/2015Price change$589,000-1.5%$188/sqft
    Source: Gilbert Avriette #15892939PS Report a problem
    4/4/2015Listed for sale$598,000+32.3%$191/sqft
    Source: Gilbert Avriette #15892939PS Report a problem
    1/26/2015Sold$452,000+25.2%$144/sqft
    Source: Public Record Report a problem
    1/9/2015Price change$360,980+41.6%$115/sqft
    Source: Auction.com Report a problem
    1/7/2015Price change$255,000-36.3%$81/sqft
    Source: Auction.com Report a problem
    12/25/2014Price change--
    Source: Auction.com Report a problem
    10/25/2014Listed for sale$400,000$128/sqft
    Source: Maritime Properties #14790413PS Report a problem
    9/15/2014Listing removed$400,000$128/sqft
    Source: Maritime Properties #14790413PS Report a problem
    9/8/2014Listed for sale$400,000$128/sqft
    Source: Maritime Properties #14790413PS Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$8,382 +2.4%$625,802 +2%
    2024$8,182 +2.6%$613,532 +2%
    2023$7,974 +2.9%$601,503 +2%
    2022$7,750 +2.3%$589,710 +2%
    2021$7,572 +1.9%$578,148 +1%
    2020$7,432 $572,220 +2%
    2019-- $561,000 +2%
    2018$7,218 +19.5%$550,000 +21.5%
    2017$6,043 $452,551 +2%
    2016$6,043 +1.7%$443,678 +1.5%
    2015$5,940 +1.6%$437,016 +2%
    2014$5,845 $428,458 +0.5%
    2013-- $426,523 +5.8%
    2012-- $403,000 -1.7%
    2011-- $409,962 +0.8%
    2010-- $406,900 -0.2%
    2009-- $407,869 +2%
    2008-- $399,873 +2%
    2007-- $392,034 +10.6%
    2006-- $354,348 +1587.4%
    2005-- $21,000 +3.9%
    2003-- $20,212 +2%
    2002-- $19,816 +2%
    2001$720 +0.8%$19,428 +2%
    2000$715 $19,048

    Find assessor info on the county website

    Neighborhood: 92253

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $976,300
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $976,300