Silva Babaian  Realtor, Real Estate Agent, Granada Hills, CA

Quick Search

    874 Mesquite Avenue, Palm Springs, CA 92264
    Image Gallery
    Property Photos
    874 Mesquite Avenue
    1. Image 0 of 63 For 874 Mesquite Avenue
    2. Image 1 of 63 For 874 Mesquite Avenue
    3. Image 2 of 63 For 874 Mesquite Avenue
    4. Image 3 of 63 For 874 Mesquite Avenue
    5. Image 4 of 63 For 874 Mesquite Avenue
    6. Image 5 of 63 For 874 Mesquite Avenue
    7. Image 6 of 63 For 874 Mesquite Avenue
    8. Image 7 of 63 For 874 Mesquite Avenue
    9. Image 8 of 63 For 874 Mesquite Avenue
    10. Image 9 of 63 For 874 Mesquite Avenue
    11. Image 10 of 63 For 874 Mesquite Avenue
    12. Image 11 of 63 For 874 Mesquite Avenue
    13. Image 12 of 63 For 874 Mesquite Avenue
    14. Image 13 of 63 For 874 Mesquite Avenue
    15. Image 14 of 63 For 874 Mesquite Avenue
    16. Image 15 of 63 For 874 Mesquite Avenue
    17. Image 16 of 63 For 874 Mesquite Avenue
    18. Image 17 of 63 For 874 Mesquite Avenue
    19. Image 18 of 63 For 874 Mesquite Avenue
    20. Image 19 of 63 For 874 Mesquite Avenue
    21. Image 20 of 63 For 874 Mesquite Avenue
    22. Image 21 of 63 For 874 Mesquite Avenue
    23. Image 22 of 63 For 874 Mesquite Avenue
    24. Image 23 of 63 For 874 Mesquite Avenue
    25. Image 24 of 63 For 874 Mesquite Avenue
    26. Image 25 of 63 For 874 Mesquite Avenue
    27. Image 26 of 63 For 874 Mesquite Avenue
    28. Image 27 of 63 For 874 Mesquite Avenue
    29. Image 28 of 63 For 874 Mesquite Avenue
    30. Image 29 of 63 For 874 Mesquite Avenue
    31. Image 30 of 63 For 874 Mesquite Avenue
    32. Image 31 of 63 For 874 Mesquite Avenue
    33. Image 32 of 63 For 874 Mesquite Avenue
    34. Image 33 of 63 For 874 Mesquite Avenue
    35. Image 34 of 63 For 874 Mesquite Avenue
    36. Image 35 of 63 For 874 Mesquite Avenue
    37. Image 36 of 63 For 874 Mesquite Avenue
    38. Image 37 of 63 For 874 Mesquite Avenue
    39. Image 38 of 63 For 874 Mesquite Avenue
    40. Image 39 of 63 For 874 Mesquite Avenue
    41. Image 40 of 63 For 874 Mesquite Avenue
    42. Image 41 of 63 For 874 Mesquite Avenue
    43. Image 42 of 63 For 874 Mesquite Avenue
    44. Image 43 of 63 For 874 Mesquite Avenue
    45. Image 44 of 63 For 874 Mesquite Avenue
    46. Image 45 of 63 For 874 Mesquite Avenue
    47. Image 46 of 63 For 874 Mesquite Avenue
    48. Image 47 of 63 For 874 Mesquite Avenue
    49. Image 48 of 63 For 874 Mesquite Avenue
    50. Image 49 of 63 For 874 Mesquite Avenue
    51. Image 50 of 63 For 874 Mesquite Avenue
    52. Image 51 of 63 For 874 Mesquite Avenue
    53. Image 52 of 63 For 874 Mesquite Avenue
    54. Image 53 of 63 For 874 Mesquite Avenue
    55. Image 54 of 63 For 874 Mesquite Avenue
    56. Image 55 of 63 For 874 Mesquite Avenue
    57. Image 56 of 63 For 874 Mesquite Avenue
    58. Image 57 of 63 For 874 Mesquite Avenue
    59. Image 58 of 63 For 874 Mesquite Avenue
    60. Image 59 of 63 For 874 Mesquite Avenue
    61. Image 60 of 63 For 874 Mesquite Avenue
    62. Image 61 of 63 For 874 Mesquite Avenue
    63. Image 62 of 63 For 874 Mesquite Avenue
    Contact Silva Babaian
    Contacting Silva Babaian
    • All fields are required.
    Schedule A Showing
    Schedule a Showing.
    • All fields are required.
    Check this box to Register with us:
    Request more information
    • MLS#: 24469343 ( Single Family Residence )
    • Street Address: 874 Mesquite Avenue
    • Viewed: 4
    • Price: $1,980,000
    • Price sqft: $815
    • Waterfront: No
    • Year Built: 1957
    • Bldg sqft: 2430
    • Bedrooms: 4
    • Total Baths: 4
    • Full Baths: 3
    • 1/2 Baths: 1
    • Garage / Parking Spaces: 1
    • Days On Market: 13
    • Additional Information
    • County: RIVERSIDE
    • City: Palm Springs
    • Zipcode: 92264
    • Subdivision: Tahquitz River Estates
    • Provided by: Desert Sotheby's International Realty
    • Contact: Jason Jason
    • California Regional MLS IDX
    • DMCA Notice
    • Description
      Step into this meticulously designed 4 bedroom, 3.5 bathroom home with a brand new 430 sq. ft. ADU, offering a combined 2,430 sq. ft. of unparalleled style and luxury. From the moment you walk through the door, this home takes you on a visual journey, where every room has been thoughtfully crafted to showcase exquisite design, vibrant colors, rich textures, and the essence of quintessential Palm Springs living. The 2,000 sq. ft. main house boasts an open floor plan with luxury vinyl plank flooring, a modern kitchen featuring quartz countertops and high end appliances, and three spacious bedrooms. Two of these bedrooms have accordion style doors that open fully to the breathtaking resort like grounds. Outside, you'll find a new pool with a tanning shelf, a raised spa with a cascading waterfall, and a sunken seating area surrounding a fire pit. Desert landscaping and a serene ambiance complete this private oasis. The newly constructed ADU is a modern masterpiece, seamlessly blending indoor and outdoor living with its wall of disappearing pocket sliders. This space includes a well equipped kitchenette, a spa like bathroom, an outdoor shower, and a covered patio offering flawless views of the pool and unobstructed mountain vistas. For even more tranquility, the side yard serves as a private sanctuary with a swinging platform bed and a cozy conversation area surrounded by desert landscaping. Additional upgrades include a NEW paid for solar system, HVAC, gas lines, water heater, electrical system, roof, windows, and doors throughout. Located in the highly sought after Tahquitz River Estates, this property is also a fantastic investment opportunity, with the neighborhood currently at just 15% of its 20% short term rental cap (as of 12/07/24). This home is not just a place to live but a testament to extraordinary design and luxurious Palm Springs living. Whether as a private retreat or a lucrative vacation rental, this property promises to captivate and inspire.
    Request More Information
    • All fields are required.
    Features
    Appliances
    1. Barbecue
    2. Dishwasher
    3. Disposal
    4. Microwave
    5. Refrigerator
    Architectural Style
    1. Modern
    Common Walls
    1. No Common Walls
    Cooling
    1. Central Air
    Country
    1. US
    Fireplace Features
    1. Electric
    2. Fire Pit
    Flooring
    1. Vinyl
    Heating
    1. Central
    Interior Features
    1. Ceiling Fan(s)
    Laundry Features
    1. Washer Included
    2. Dryer Included
    Levels
    1. One
    Living Area Source
    1. Assessor
    Other Structures
    1. Guest House
    Parcel Number
    1. 508202008
    Parking Features
    1. Garage - Two Door
    Pool Features
    1. Private
    Postalcodeplus4
    1. 8415
    Property Type
    1. Single Family Residence
    Spa Features
    1. Private
    Subdivision Name Other
    1. Tahquitz River Estates
    View
    1. Pool
    2. Mountain(s)
    Virtual Tour Url
    1. https://youtu.be/4zwN1_eVXrg
    Year Built
    1. 1957
    Year Built Source
    1. Other
    Zoning
    1. R1C
    Headshot for Associate Silva Babaian
    1. Silva Babaian / Realtor
    2. Coldwell Banker Exclusive
    3. CalBRE Lic # 01365805
    4. Mobile: 818.414.6744
    5. Fax: 818.338.5836