Listed by Jose Martinez of SimpliHOM
Welcome to Sunnyside Estates. Whether you're looking to purchase your first home, a desert getaway or a rental investment, this home is centrally located and in a great community. Great looking/updated, near the Polo Grounds, Hospital, Shopping, dining and is move in ready! Some of the recent updates: Flooring, windows, rear slider door and entire HVAC system. Community amenities: Pool/Spa, Tennis & Basketball courts, Club house and also a section at the rear of the community to park an RV, available to residents for a fee. Contact me now to set up your private viewing.

Listing Tools (detailViewNewGen)

Property Details of 47800 Madison Street 174, Unit 174

Property Details

Interior Features

Exterior Features

Community

Other Details

Map Location

Based on information submitted to CRMLS as of May 18, 2026 1:08 AM EDT . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Seven Gables Real Estate. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.