This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$530,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
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!
Full Property Details
Full Property Details for 47870 Rosemary St
General
- Sold For: $530,000
- HOA FEE: $324/month
- Status: Closed
- Type: Single Family
- Source: Desert_Area_Palm_Springs
- MLS ID: 219143054
- Added to Site: 105 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.: $285
- 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
Sold by Zachary A Kauffman and Melinda Wong
Get Pre-Approved Today
Schools
Schools serving 47870 Rosemary St
School District:Desert Sands Unified School District
| Name | Grades | Distance |
|---|---|---|
Harry S. Truman Elementary School 78-870 Ave. 50, La Quinta, CA 92253 | K-5 | 1.3 mi |
La Quinta Middle School 78-900 Ave. 50, La Quinta, CA 92253 | 6-8 | 1.2 mi |
La Quinta High School, La Quinta, CA 79-255 Blackhawk Way, La Quinta, CA 92253 | 9-12 | 1 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 47870 Rosemary St
Date
Details
Price
Change
Source
5/26/2026
Sold
$530,000
-3.46%
MLS
3/07/2026
Price Reduced
$549,000
-1.08%
MLS
2/11/2026
Listed
$555,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
47870 Rosemary Street, La Quinta, CA 92253 (MLS# 219143054) is a Single Family property that was sold at $530,000 on May 26, 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.

