Skip to Main Content
Contact Kim Barron
Contacting Kim Barron
  • All fields are required.
Schedule A Showing
Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Request more information
  1. Home
  2. Property Search
  3. Search results
  4. 47870 Rosemary Street, La Quinta, CA 92253
Active
Property Photos
47870 Rosemary Street
  1. Image 0 of 45 For 47870 Rosemary Street
  2. Image 1 of 45 For 47870 Rosemary Street
  3. Image 2 of 45 For 47870 Rosemary Street
  4. Image 3 of 45 For 47870 Rosemary Street
  5. Image 4 of 45 For 47870 Rosemary Street
  6. Image 5 of 45 For 47870 Rosemary Street
  7. Image 6 of 45 For 47870 Rosemary Street
  8. Image 7 of 45 For 47870 Rosemary Street
  9. Image 8 of 45 For 47870 Rosemary Street
  10. Image 9 of 45 For 47870 Rosemary Street
  11. Image 10 of 45 For 47870 Rosemary Street
  12. Image 11 of 45 For 47870 Rosemary Street
  13. Image 12 of 45 For 47870 Rosemary Street
  14. Image 13 of 45 For 47870 Rosemary Street
  15. Image 14 of 45 For 47870 Rosemary Street
  16. Image 15 of 45 For 47870 Rosemary Street
  17. Image 16 of 45 For 47870 Rosemary Street
  18. Image 17 of 45 For 47870 Rosemary Street
  19. Image 18 of 45 For 47870 Rosemary Street
  20. Image 19 of 45 For 47870 Rosemary Street
  21. Image 20 of 45 For 47870 Rosemary Street
  22. Image 21 of 45 For 47870 Rosemary Street
  23. Image 22 of 45 For 47870 Rosemary Street
  24. Image 23 of 45 For 47870 Rosemary Street
  25. Image 24 of 45 For 47870 Rosemary Street
  26. Image 25 of 45 For 47870 Rosemary Street
  27. Image 26 of 45 For 47870 Rosemary Street
  28. Image 27 of 45 For 47870 Rosemary Street
  29. Image 28 of 45 For 47870 Rosemary Street
  30. Image 29 of 45 For 47870 Rosemary Street
  31. Image 30 of 45 For 47870 Rosemary Street
  32. Image 31 of 45 For 47870 Rosemary Street
  33. Image 32 of 45 For 47870 Rosemary Street
  34. Image 33 of 45 For 47870 Rosemary Street
  35. Image 34 of 45 For 47870 Rosemary Street
  36. Image 35 of 45 For 47870 Rosemary Street
  37. Image 36 of 45 For 47870 Rosemary Street
  38. Image 37 of 45 For 47870 Rosemary Street
  39. Image 38 of 45 For 47870 Rosemary Street
  40. Image 39 of 45 For 47870 Rosemary Street
  41. Image 40 of 45 For 47870 Rosemary Street
  42. Image 41 of 45 For 47870 Rosemary Street
  43. Image 42 of 45 For 47870 Rosemary Street
  44. Image 43 of 45 For 47870 Rosemary Street
  45. Image 44 of 45 For 47870 Rosemary Street
View all images
  1. Image 0 of 45 For 47870 Rosemary Street
  2. Image 1 of 45 For 47870 Rosemary Street
  3. Image 2 of 45 For 47870 Rosemary Street
  4. Image 3 of 45 For 47870 Rosemary Street
  5. Image 4 of 45 For 47870 Rosemary Street
  6. Image 5 of 45 For 47870 Rosemary Street
  7. Image 6 of 45 For 47870 Rosemary Street
  8. Image 7 of 45 For 47870 Rosemary Street
  9. Image 8 of 45 For 47870 Rosemary Street
  10. Image 9 of 45 For 47870 Rosemary Street
  11. Image 10 of 45 For 47870 Rosemary Street
  12. Image 11 of 45 For 47870 Rosemary Street
  13. Image 12 of 45 For 47870 Rosemary Street
  14. Image 13 of 45 For 47870 Rosemary Street
  15. Image 14 of 45 For 47870 Rosemary Street
  16. Image 15 of 45 For 47870 Rosemary Street
  17. Image 16 of 45 For 47870 Rosemary Street
  18. Image 17 of 45 For 47870 Rosemary Street
  19. Image 18 of 45 For 47870 Rosemary Street
  20. Image 19 of 45 For 47870 Rosemary Street
  21. Image 20 of 45 For 47870 Rosemary Street
  22. Image 21 of 45 For 47870 Rosemary Street
  23. Image 22 of 45 For 47870 Rosemary Street
  24. Image 23 of 45 For 47870 Rosemary Street
  25. Image 24 of 45 For 47870 Rosemary Street
  26. Image 25 of 45 For 47870 Rosemary Street
  27. Image 26 of 45 For 47870 Rosemary Street
  28. Image 27 of 45 For 47870 Rosemary Street
  29. Image 28 of 45 For 47870 Rosemary Street
  30. Image 29 of 45 For 47870 Rosemary Street
  31. Image 30 of 45 For 47870 Rosemary Street
  32. Image 31 of 45 For 47870 Rosemary Street
  33. Image 32 of 45 For 47870 Rosemary Street
  34. Image 33 of 45 For 47870 Rosemary Street
  35. Image 34 of 45 For 47870 Rosemary Street
  36. Image 35 of 45 For 47870 Rosemary Street
  37. Image 36 of 45 For 47870 Rosemary Street
  38. Image 37 of 45 For 47870 Rosemary Street
  39. Image 38 of 45 For 47870 Rosemary Street
  40. Image 39 of 45 For 47870 Rosemary Street
  41. Image 40 of 45 For 47870 Rosemary Street
  42. Image 41 of 45 For 47870 Rosemary Street
  43. Image 42 of 45 For 47870 Rosemary Street
  44. Image 43 of 45 For 47870 Rosemary Street
  45. Image 44 of 45 For 47870 Rosemary Street
Reduced
More Like This
  • MLS#: 219143054DA ( Single Family Residence )
  • Street Address: 47870 Rosemary Street
  • Viewed: 1
  • Price: $549,000
  • Price sqft: $286
  • Waterfront: No
  • Year Built: 2001
  • Bldg sqft: 1920
  • Bedrooms: 3
  • Total Baths: 3
  • Full Baths: 1
  • 1/2 Baths: 1
  • Garage / Parking Spaces: 4
  • Days On Market: 29
  • Additional Information
  • County: RIVERSIDE
  • City: La Quinta
  • Zipcode: 92253
  • Subdivision: Mira Flores
  • District: Desert Sands Unified
  • Elementary School: TRUMAN
  • Middle School: LAQUI
  • High School: LAQUI
  • Provided by: Cool Digs
  • Contact: T.J. T.J.
  • California Regional MLS IDX
  • DMCA Notice
  • 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!
Property Location and Similar Properties
All
Similar
Request More Information
  • All fields are required.
Features
Appliances
  1. Gas Water Heater
  2. Electric Oven
  3. Convection Oven
  4. Gas Cooktop
  5. Water Line to Refrigerator
  6. Refrigerator
  7. Disposal
  8. Dishwasher
  9. Vented Exhaust Fan
  10. Microwave
Architectural Style
  1. Spanish
Association Amenities
  1. Pet Rules
Association Fee
  1. 324.00
Association Fee Frequency
  1. Monthly
Carport Spaces
  1. 0.00
Construction Materials
  1. Stucco
Cooling
  1. Central Air
Country
  1. US
Door Features
  1. Sliding Doors
Eating Area
  1. Breakfast Counter / Bar
  2. Dining Room
Elementary School
  1. TRUMAN
Elementaryschool
  1. Truman
Fencing
  1. Wood
  2. Stucco Wall
Fireplace Features
  1. Gas
  2. Masonry
  3. Family Room
  4. See Through
Flooring
  1. Tile
  2. Carpet
  3. Laminate
Foundation Details
  1. Slab
Garage Spaces
  1. 2.00
Heating
  1. Fireplace(s)
  2. Natural Gas
  3. Forced Air
  4. Central
High School
  1. LAQUI
Highschool
  1. La Quinta
Interior Features
  1. High Ceilings
  2. Open Floorplan
Laundry Features
  1. Individual Room
Levels
  1. One
Living Area Source
  1. Assessor
Lockboxtype
  1. Supra
Lot Features
  1. Level
  2. Sprinklers Timer
  3. Park Nearby
  4. Sprinklers Drip System
  5. Sprinkler System
  6. Planned Unit Development
  7. Yard
Middle School
  1. LAQUI
Middleorjuniorschool
  1. La Quinta
Parcel Number
  1. 600320017
Parking Features
  1. Direct Garage Access
  2. Driveway
  3. Side by Side
  4. Garage Door Opener
  5. Street
Patio And Porch Features
  1. Concrete
Pool Features
  1. In Ground
  2. Community
  3. Electric Heat
Postalcodeplus4
  1. 6283
Property Type
  1. Single Family Residence
Roof
  1. Clay
School District
  1. Desert Sands Unified
Security Features
  1. Gated Community
  2. Automatic Gate
Spa Features
  1. In Ground
  2. Community
Subdivision Name Other
  1. Mira Flores
Uncovered Spaces
  1. 0.00
Window Features
  1. Shutters
  2. Drapes
Year Built
  1. 2001
Year Built Source
  1. Assessor
Zoning
  1. R-1
Equal Housing Opportunity

Based on information from California Regional Multiple Listing Service, Inc. as of Mar 12, 2026. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.
Display of MLS data is usually deemed reliable but is NOT guaranteed accurate.
Datafeed Last updated on March 12, 2026 @ 12:00 am
©2006-2026 brokerIDXsites.com - https://brokerIDXsites.com
We believe in accessibility for all
Your Privacy Is Important
XML Sitemap
Manage Your Account