Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 284 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 284 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 284 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5 Majorca Drive
Rancho Mirage, CA 92270

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,500
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1650 Square Feet
Agency: Bennion Deville Homes Sunrise Country Club
Agency Phone: (760) 565-1409

Map Details Show Map | Show StreetView




House Features

Architectural Style: Spanish
Flooring: Tile
Heating: Central Furnace, Forced Air, Fireplace
Interior Features: Vaulted Ceiling(s), Open Floorplan, Granite Counters, Dry Bar
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2

Window Features

Exterior Features: Covered, Greenbelt
Parking Features: Garage, Driveway, Oversized, Side by Side
Roof: Flat, Tile, Foam
View: Park

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Sunrise Country Club

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Other-Condominium
Year Built: 1975
Notes: This fully remodeled condo is the perfect choice for your short-term or long-term stay. Experience the comfort and convenience of this exceptional property, featuring new tile flooring, spacious living room with an electric fireplace, HD TV, and high-speed Internet with Wi-Fi. The sectional sofa in the living room also doubles as a sleeper for additional guests. The updated kitchen boasts modern appliances and is fully equipped for all your culinary needs. The master bedroom offers a newly updated king-size bed, while the second bedroom features a newly updated queen-size bed. The third bedroom, currently used as a den, includes a full-size sofa bed and a bar area. With a large patio featuring a built-in barbecue grill and a backyard that resembles your own private park, outdoor entertainment options abound. Additional highlights include a huge 2-car garage with storage space.<br /> Please note the following availability and rental details:<br /> Please note the following availability and rental details:<br /> Summer Rental: From 8/1/2023 to 10/31/2023 at $3,000/month (or best offer)<br /> Seasonal Rental: From 11/1/2023 to 4/30/2024 at $5,500/month<br /> Property unavailable from November 1, 2023, to March 31 2024.<br /> Don't miss this opportunity to enjoy the luxurious amenities and comfortable living offered by this remodeled condo in Sunrise Country Club. Contact us now to secure your stay and experience the finest in resort-style living.
MlsNumber: --
ListingId: 219097383


Listing Provided By: Bennion Deville Homes Sunrise Country Club, original listing
Phone: (209) 601-9085
Office Phone: (760) 565-1409
Agent Name: David Cardoza
Disclaimer: Copyright © 2024 California Desert Association of REALTORS&#174;, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 284 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Jill Ruckman
Jill Ruckman
ASCIIHomeSmart Realty Partners
Call Today!: (970) 234-6000

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App