Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$555,000

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 1 Full Bath
  • 2 Partial Baths
  • 1,920 Sq. Ft.
  • 2 Car Garage
  • Updated 9 days ago

Next open house:

Open House: 11:00 AM - 2:00 PM

Saturday 2/21 11:00 AM - 2:00 PM

47870 Rosemary Street,La Quinta, CA 92253

47870 Rosemary StreetLa QuintaCA92253

Get directions
See This Home
Save This Home
See This Home
Save This Home
AFFORDABLE LQ Home 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!

Full Property Details for 47870 Rosemary St

General

  • Price: $555,000
  • HOA FEE: $324/month
  • Status: Active
  • Type: Single Family
  • Source: Desert_Area_Palm_Springs
  • MLS ID: 219143054
  • Updated: 2/11/2026
  • Added to Site: 10 day(s) ago

Interior

  • Rooms/Areas: Den - Study, Dining Area, Family Room
  • Interior Features: High Ceilings (9 Ft+), Open Floorplan
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Family Room, Gas Log, Gas, Tile, Glass Doors
  • Eating Areas: Breakfast Counter/Bar, Formal Dining Room
  • Appliances: Dryer, Gas Cooktop, Microwave Oven, Convection Oven, Electric Oven, Exhaust Fan, Water Line to Refrigerator, Washer, Refrigerator, Disposal, Dishwasher
  • Furnishings: Unfurnished
  • Flooring: Carpet, Laminate, Ceramic Tile
  • Windows/Treatment: Drapes, Shutters

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 1
  • 3/4 Bathrooms: 1
  • Half Bathrooms: 1
  • Bathroom Features: Double Vanity(s), Shower Stall, Shower over Tub

Bedrooms

  • Total Bedrooms: 3
  • Main Level Bedroom: Yes
  • Bedroom Features: Main Floor Primary Bedroom, Walk-In Closet

Other Rooms

  • Kitchen: Granite Counters
  • Laundry: Individual Room

Additional Information

  • Shared Amenities: Greenbelt/Park, Pet Rules
  • Pool: Yes
  • Pool Description: Heated, Community, In Ground, Heated, Community, In Ground, Community
  • Spa: Yes
  • Spa Description: In Ground, Community
  • Security/Safety: Automatic Gate, Gated Community, Community

Exterior

  • Deck/Patio: Concrete Slab

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Covered Spaces: 2
  • Total Spaces: 4
  • Parking: On Street, Driveway, Garage Door Opener, Direct Entrance, Side By Side
  • Garage Description: Attached

Location

  • Area: 313 -La Quinta South of HWY 111
  • County: Riverside
  • Subdivision: Mira Flores
  • Cross Streets: Cassia Street
  • Direction Faces: Front Door Faces South

School Information

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

Community

  • Gated community: Yes
  • Association: Yes
  • Pet Restrictions: Association Pet Rules

Heating & Cooling

  • Cooling Type: Air Conditioning, Central Air, Ceiling Fan(s)
  • Heating Type: Central, Forced Air, Fireplace(s)
  • Heating Fuel: Natural Gas
  • Water Heater: Gas

Utilities

  • Sewer: In, Connected and Paid
  • Water District: CVWD
  • Water: Water District

Structural Information

  • Architectural Style: Spanish
  • Exterior Const.: Stucco
  • Foundation: Slab
  • Roof: Clay Tile
  • Doors: Sliding Doors
  • Sprinklers: Yes
  • Entry Location: Ground Level - No Steps
  • Stories/Levels: 1
  • Square Feet: 1,920
  • Sq. Ft. Source: Assessor
  • Year Built: 2001
  • Year Built Source: Assessor

Lot Features

  • Lot Size (Sq. Ft.): 5,663
  • Lot Size Source: Assessor
  • Irrigation System: Drip System, Sprinkler Timer, Sprinkler System
  • Zoning: R-1
  • Lot Description: Level, Yard
  • Fencing (Description): Stucco Wall, Wood

Financial Considerations

  • Price Per Sq. Ft.: $289
  • Association Fee: Yes
  • Assoc Fee Freq.: Monthly
  • Assoc Fee /Month: $324
  • Terms: Conventional, FHA, Cash to New Loan, Cash

Disclosures and Reports

  • APN: 600320017

Listed by Cool Digs, T.J. McCaa and Cool Digs, Mia Blair

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agents

— 47870 Rosemary St —

  • T.J. McCaa

    Cool Digs

  • Mia Blair

    Cool Digs

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 47870 Rosemary St

School District:Desert Sands Unified School District
NameGradesDistance
Harry S. Truman Elementary School
78-870 Ave. 50, La Quinta, CA 92253
K-51.3 mi
La Quinta Middle School
78-900 Ave. 50, La Quinta, CA 92253
6-81.2 mi
La Quinta High School, La Quinta, CA
79-255 Blackhawk Way, La Quinta, CA 92253
9-121 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 47870 Rosemary St Get Price Alerts and Save Property

Date
Details
Price
Change
Source
2/11/2026
Listed
$555,000
101.82%
MLS
6/24/2015
Sold
$275,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 47870 Rosemary St

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,705
3%
$325,535
2%
2024
$4,577
3%
$319,153
2%
2023
$4,440
4%
$312,896
2%
2022
$4,285
3%
$306,762
2%
2021
$4,175
2%
$300,748
1%
2020
$4,101
2%
$297,666
2%
2019
$4,018
2%
$291,830
2%
2018
$3,930
2%
$286,109
2%
2017
$3,871
2%
$280,500
2%
2016
$3,800
15%
$275,000
23%
2015
$3,318
2%
$223,857
2%
2014
$3,268
10%
$219,474
11%
2013
$2,982
—
$197,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 47870 Rosemary St

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Cool Digs, T.J. McCaa and Cool Digs, Mia Blair

Similar Properties near 47870 Rosemary St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

39313 Camino Las Hoyes, Indio, CA 92203 - Photo 1
$559,000
Open House

39313 Camino Las Hoyes  Indio, CA 92203

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,331
    Sq. Ft.
78184 Arbor Glen Rd, Palm Desert, CA 92211 - Photo 1
$559,000

78184 Arbor Glen Rd  Palm Desert, CA 92211

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,352
    Sq. Ft.
82810 Odlum Dr, Indio, CA 92201 - Photo 1
$549,999

82810 Odlum Dr  Indio, CA 92201

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,005
    Sq. Ft.
78559 Platinum Dr, Palm Desert, CA 92211 - Photo 1
$549,900

78559 Platinum Dr  Palm Desert, CA 92211

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 1,888
    Sq. Ft.

Just Listed near 47870 Rosemary St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

75476 Augusta Dr, Indian Wells, CA 92210 - Photo 1 Just Listed
$1,249,999

75476 Augusta Dr  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,773
    Sq. Ft.
75762 Valle Vista, Indian Wells, CA 92210 - Photo 1 Just Listed
$825,000

75762 Valle Vista  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,600
    Sq. Ft.
75982 Via Allegre, Indian Wells, CA 92210 - Photo 1 Just Listed
$1,200,000

75982 Via Allegre  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,604
    Sq. Ft.
75320 Skylark Trail, Indian Wells, CA 92210 - Photo 1 Just Listed
$1,099,000
Open House

75320 Skylark Trail  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,674
    Sq. Ft.

Price Reduced near 47870 Rosemary St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

45705 Pawnee Rd, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$74,000 (-4.72%)
$1,495,000

45705 Pawnee Rd  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,900
    Sq. Ft.
46330 Dove Rd, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$50,000 (-4.26%)
$1,125,000

46330 Dove Rd  Indian Wells, CA 92210

  • Condo
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,306
    Sq. Ft.
45595 Apache Rd, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$95,000 (-4.33%)
$2,100,000

45595 Apache Rd  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 6
    Total Baths
  • 3,897
    Sq. Ft.
44839 Winged Foot Dr, Indian Wells, CA 92210 - Photo 1 Price Reduced
-$5,000 (-0.48%)
$1,045,000

44839 Winged Foot Dr  Indian Wells, CA 92210

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,855
    Sq. Ft.

Recent Sales near 47870 Rosemary St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

47875 Silverberry St, La Quinta, CA 92253 - Photo 1 Sold
$545,000

47875 Silverberry St  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 1,760
    Sq. Ft.
79756 Cassia St, La Quinta, CA 92253 - Photo 1 Sold
$525,000

79756 Cassia St  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 1,760
    Sq. Ft.
79770 Mira Flores Blvd, La Quinta, CA 92253 - Photo 1 Sold
$527,500

79770 Mira Flores Blvd  La Quinta, CA 92253

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,100
    Sq. Ft.
48631 Via Carisma, Indio, CA 92201 - Photo 1 Sold
$625,000

48631 Via Carisma  Indio, CA 92201

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,866
    Sq. Ft.

47870 Rosemary Street, La Quinta, CA 92253 (MLS# 219143054) is a Single Family property with 3 bedrooms, 1 full bathroom and 2 partial bathrooms. 47870 Rosemary Street is currently listed for $555,000 and was received on February 11, 2026. Want to learn more about 47870 Rosemary Street? Do you have questions about finding other Single Family real estate for sale in La Quinta? You can browse all La Quinta real estate or contact a Coldwell Banker agent to request more information.

Tour this property