Jen & Rob Hernandez IDC Global Agent

Jen & Rob Hernandez

License# 02093432 / 02093404
0
Reviews
(213) 364-4044

47870 Rosemary Street, La Quinta, CA 92253 (Sold on )

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

 $549,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
  • 3 BedBeds
  • 3 BathBaths
  • 1,920 SqftSqft
  • TypeSingle Family
  • Active Under Contract
  • MLS# 219143054DA

Virtual Tours

  • VirtualAdditionalTourImage

Property Description

Price Improvement on this AFFORDABLE LQ Home that Exudes Pride of Ownership in this Centrally Located Community of Mira Flores! User-Friendly Open-Concept Floor Plan Delivers a Functional Flow that is both AIRY and OPEN. You'll Appreciate the Generous Kitchen w/Granite Counters and Backsplash, Stainless Appliances, Rich Cabinetry which Opens to the Family Room w/a Cozy Fireplace and Wrap-Around Sliding Glass Doors Framing the Patio. Bedrooms are Appropriately Spaced for Privacy and a Versatile Bonus Room has Potential for a Home Office, Hobby Room or a Potential Fourth Bedroom. The Primary Suite is a Tranquil Retreat with a Walk-in Closet, Ensuite Bathroom w/Dual Sinks and Walk-in shower. Outdoor Living is Easy w/a Generous Patio, Peek a Boo Mountain Views and Low Maintenance Landscaping. Truly a Triple Option of Opportunity; a Primary Residence, a Vacation Getaway -or- a Rental Opportunity that could be Ready for Revenue! HOA covers Front Yard Maintenance, Front Gate, Community Pool/Spa and a Pet Friendly Greenbelt. Bonus: Low HOA Dues, Desirable Schools, Close to Restaurants, Costco, Shopping, Music Festivals, Theatres, Hwy 111 and All La Quinta has to Offer!

Marketed By

Jen & Rob Hernandez

License# 02093432 / 02093404
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 47870 Rosemary Street, La Quinta, CA 92253

General

  • MLS#: 219143054DA
  • Property Type: Single Family
  • Property Sub Type: Single Family Residence
  • List Date: 02/11/2026
  • Year Built: 2001
  • Area: 313 - La Quinta South of HWY 111
  • Subdivision: Mira Flores
  • County: Riverside
  • Zoning: R-1
  • Beds: 3
  • Full Bath: 1
  • Half Baths: 1
  • Three-Quarter Baths: 1
  • Total Baths: 3
  • Association Fee: $324.00
  • Association Fee Frequency: Monthly
  • Association Amenities: Pet Restrictions

Interior Features

  • Interior Features: Breakfast Bar, Separate/Formal Dining Room, High Ceilings, Open Floorplan, Main Level Primary, Walk-In Closet(s)
  • Flooring: Carpet, Laminate, Tile
  • Appliances: Convection Oven, Dishwasher, Electric Oven, Gas Cooktop, Disposal, Gas Water Heater, Microwave, Refrigerator, Vented Exhaust Fan, Water To Refrigerator
  • Door Features: Sliding Doors
  • Window Features: Drapes, Shutters
  • Laundry Features: Laundry Room
  • Security Features: Security Gate, Gated Community

Exterior Features

  • Community Features: Gated, Park, Pool
  • Fencing: Stucco Wall, Wood
  • Private Pool: Yes
  • Pool Features: Community, Electric Heat, In Ground
  • Carport Spaces: 0.00
  • Garage Spaces: 2
  • Patio and Porch Features: Concrete
  • Roof: Clay

Schools

  • Elementary School: Truman
  • Middle or Junior School: La Quinta
  • High School: La Quinta
  • High School District: Desert Sands Unified

Structure

  • Architectural Style: Spanish
  • Stories: 1
  • Attached Garage: Yes

Size & Lot

  • Lot Size Acres: 0.1300
  • Lot Size SqFt: 5,663
  • Lot Features: Drip Irrigation/Bubblers, Level, Near Park, Planned Unit Development, Sprinklers Timer, Sprinkler System, Yard

Utilities

  • Heating: Central, Forced Air, Fireplace(s), Natural Gas
  • Cooling: Central Air

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

    80801 Calle Azul, La Quinta
    $685,000
    MLS# IG25276753Single Family
    1,557 Sq. Ft.
    2 BEDS3 BATHS
    Request Info
    Delete
    80801 Calle Azul, La QuintaDetails
      53140 Avenida Vallejo, La Quinta
      $685,000
      MLS# SB26058645Single Family
      1,797 Sq. Ft.
      3 BEDS2 BATHS
      Request Info
      Delete
      53140 Avenida Vallejo, La QuintaDetails
        81827 Via Barranca, La Quinta
        $682,617
        MLS# SW26020320Single Family
        2,529 Sq. Ft.
        3 BEDS3 BATHS
        Request Info
        Delete
        81827 Via Barranca, La QuintaDetails
          53605 Avenida Navarro, La Quinta
          $679,750
          MLS# 219144690DASingle Family
          1,415 Sq. Ft.
          3 BEDS2 BATHS
          Request Info
          Delete
          53605 Avenida Navarro, La QuintaDetails
            43875 Milan Court, La Quinta
            $679,000
            MLS# 219139919DASingle Family
            2,523 Sq. Ft.
            4 BEDS3 BATHS
            Request Info
            Delete
            43875 Milan Court, La QuintaDetails
              44850 Via Catalina, La Quinta
              $679,000
              MLS# 219144032DASingle Family
              2,645 Sq. Ft.
              3 BEDS3 BATHS
              Request Info
              Delete
              44850 Via Catalina, La QuintaDetails
                54700 Avenida Alvarado, La Quinta
                $675,000
                MLS# 219142404DASingle Family
                1,640 Sq. Ft.
                3 BEDS2 BATHS
                Request Info
                Delete
                54700 Avenida Alvarado, La QuintaDetails
                  53745 Avenida Juarez, La Quinta
                  $675,000
                  MLS# 219147183DASingle Family
                  1,518 Sq. Ft.
                  3 BEDS2 BATHS
                  Request Info
                  Delete
                  53745 Avenida Juarez, La QuintaDetails
                    78585 Villeta Drive, La Quinta
                    $670,000
                    MLS# 219143755PSSingle Family
                    2,307 Sq. Ft.
                    4 BEDS2 BATHS
                    Request Info
                    Delete
                    78585 Villeta Drive, La QuintaDetails
                      81802 Via Barranca, La Quinta
                      $669,957
                      MLS# SW25282237Single Family
                      2,348 Sq. Ft.
                      3 BEDS4 BATHS
                      Request Info
                      Delete
                      81802 Via Barranca, La QuintaDetails
                        79835 Parkway Esplanade N, La Quinta
                        $664,900
                        MLS# 219139591DASingle Family
                        2,436 Sq. Ft.
                        5 BEDS3 BATHS
                        Request Info
                        Delete
                        79835 Parkway Esplanade N, La QuintaDetails
                          79859 Amora Drive, La Quinta
                          $660,000
                          MLS# 219143681DASingle Family
                          2,060 Sq. Ft.
                          4 BEDS3 BATHS
                          Request Info
                          Delete
                          79859 Amora Drive, La QuintaDetails

                          • Office

                          • 2905 E. Tahquitz Canyon Way Palm Springs CA 92262
                          • 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.