Joe Lambert Real Estate Agent

Joe Lambert

REALTOR®
License# 02176918
0
Reviews
(951) 438-7889

78625 Avenida Ultimo, La Quinta, CA 92253 (Sold on )

  • Open House
  • New Listing
  • Price Reduced$51,000
  • VIRTUAL SHOWING
  • PENDING UNDER CONTRACT
  • The seller has accepted an offer on this property.
  • Virtual Tour
  • Coming Soon

 $1,499,000

  • Saved Save Listing
  • Share Listing
  • Virtual Tour
more_vert
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
galleryimage
  • 4 BedBeds
  • 4 BathBaths
  • 2,611 SqftSqft
  • TypeSingle Family
  • Active
  • MLS# 219149858DA

Virtual Tours

  • VirtualTourImage
  • VirtualAdditionalTourImage

Property Description

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.

Marketed By

Joe Lambert

License# 02176918
Email Me My Website My Listings

Thank you for requesting a showing of this property. A representative will be in touch with you shortly to confirm the requested showing date and time.
Please note that your appointment is not confirmed until someone contacts you.

Request Info / Schedule Showing

Submit

Property Details 78625 Avenida Ultimo, La Quinta, CA 92253

General

  • MLS#: 219149858DA
  • Property Type: Single Family
  • Property Sub Type: Single Family Residence
  • List Date: 07/02/2026
  • Year Built: 1991
  • Area: 313 - La Quinta South of HWY 111
  • Subdivision: Desert Club Estates
  • County: Riverside
  • Beds: 4
  • Full Bath: 3
  • Half Baths: 1
  • Total Baths: 4

Interior Features

  • Interior Features: Breakfast Bar, Separate/Formal Dining Room, Furnished, High Ceilings
  • Flooring: Laminate
  • Appliances: Convection Oven, Dishwasher, Microwave, Refrigerator, Water To Refrigerator
  • Door Features: French Doors
  • Laundry Features: Laundry Room
  • Security Features: Closed Circuit Camera(s), Security Gate, Security Lights

Exterior Features

  • Fencing: Stucco Wall
  • Private Pool: Yes
  • Pool Features: In Ground, Private, Salt Water
  • Carport Spaces: 0.00
  • Garage Spaces: 2
  • Patio and Porch Features: Covered, Wrap Around

Structure

  • Stories: 1
  • Attached Garage: Yes

Size & Lot

  • Lot Size Acres: 0.2800
  • Lot Size SqFt: 12,197
  • Lot Features: Drip Irrigation/Bubblers, Sprinklers Timer, Sprinkler System

Utilities

  • Heating: Forced Air
  • Cooling: Central Air, Zoned

Estimated Monthly Mortgage Calculator

This calculator is provided for informational purposes. You should not make any decisions based simply on the information provided. Values indicated are estimates and may not be accurate and are only to be used as a guide. This calculator should not be relied upon in any way as the sole source of information. Please consult your financial, tax or legal advisers for an accurate assessment of your mortgage payments and any advice relating to your personal circumstances.

 

Similar Listings

    57910 Stone Creek Trail W, La Quinta
    $1,845,000
    MLS# OC26103759Single Family
    3,908 Sq. Ft.
    4 BEDS5 BATHS
    Request Info
    Delete
    Details
      54280 Affirmed Court, La Quinta
      $1,795,000
      MLS# 219150358DASingle Family
      3,152 Sq. Ft.
      4 BEDS4 BATHS
      Request Info
      Delete
      Details
        56063 Winged Foot, La Quinta
        $1,795,000
        MLS# 219148840DASingle Family
        3,102 Sq. Ft.
        3 BEDS4 BATHS
        Request Info
        Delete
        Details
          78930 Via Florence, La Quinta
          $1,725,000
          MLS# 219150011DASingle Family
          3,074 Sq. Ft.
          5 BEDS4 BATHS
          Request Info
          Delete
          Details
            81660 Chant Court, La Quinta
            $1,725,000
            MLS# 219146210DASingle Family
            2,967 Sq. Ft.
            3 BEDS4 BATHS
            Request Info
            Delete
            Details
              50700 Calle Paloma, La Quinta
              $1,699,500
              MLS# 219150962DASingle Family
              3,280 Sq. Ft.
              4 BEDS4 BATHS
              Request Info
              Delete
              Details
                81655 Brown Deer, La Quinta
                $1,699,000
                MLS# 219144794DASingle Family
                3,593 Sq. Ft.
                4 BEDS4 BATHS
                Request Info
                Delete
                Details
                  49940 W Mission Drive W, La Quinta
                  $1,685,000
                  MLS# 219136606DASingle Family
                  2,924 Sq. Ft.
                  4 BEDS4 BATHS
                  Request Info
                  Delete
                  Details
                    50465 Verano Drive, La Quinta
                    $1,685,000
                    MLS# 219150514DASingle Family
                    3,011 Sq. Ft.
                    3 BEDS4 BATHS
                    Request Info
                    Delete
                    Details
                      80440 Old Ranch Trail S, La Quinta
                      $1,659,000
                      MLS# 219147485DASingle Family
                      3,156 Sq. Ft.
                      4 BEDS4 BATHS
                      Request Info
                      Delete
                      Details
                        77745 Concha Court, La Quinta
                        $1,650,000
                        MLS# 219148034DASingle Family
                        2,748 Sq. Ft.
                        4 BEDS4 BATHS
                        Request Info
                        Delete
                        Details
                          80174 Champions, La Quinta
                          $1,650,000
                          MLS# CV26148390Single Family
                          2,277 Sq. Ft.
                          3 BEDS3 BATHS
                          Request Info
                          Delete
                          Details

                          • Office

                          • 27291 Newport Road, Suite #120 Menifee CA 92584
                          • Qualifying Broker
                          Do Not Sell My Personal Information
                          DMCA.com Protection Status
                          © 2026 Berkshire Hathaway HomeServices California Properties (BHHSCP) is a member of the franchise system of BHH Affiliates LLC. BHHS and the BHHS symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. BHH Affiliates LLC and BHHSCP do not guarantee accuracy of all data including measurements, conditions, and features of property. Information is obtained from various sources and will not be verified by broker or MLS. Buyer is advised to independently verify the accuracy of that information. Equal Housing Opportunity.
                          Copyright © 2026 BHHS California Properties. All Rights Reserved.

                          Berkshire Hathaway HomeServices California Properties is powered by Burrow Services, Inc.