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 = 3218 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 3218 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 3218 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

150 S Windsor Rd
Mesa, AZ 85204

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $62,500
Beds: 2
Baths: 1
Status: Active
SqFt: 860
Agency: Dragonfly Homes By Mindy LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1968
Notes: Excellent updated 2 bedrooms with walk in closets! Chef's Kitchen! Escape to a vibrant 55+ community, nestled amidst a picturesque landscape of majestic palm trees and mature citrus trees. Introducing our meticulously maintained 20x43 doublewide mobile home, the epitome of comfort and style. This gated oasis offers a tranquil retreat for those seeking the perfect retirement haven. Impeccable Features: Step inside and be captivated by the luxurious upgrades that await you. The brand new central AC and gas water heater (2019) ensure year-round comfort, while the newly installed front windows flood the home with natural light. The laminate flooring throughout adds a touch of elegance, complementing the freshly painted walls. ️ Culinary Delights: Indulge your inner chef in the fully equipped kitchen, boasting all-new custom cabinets in maple and hickory, adorned with sleek laminate countertops. Prepare delicious meals effortlessly with the help of the brand new appliances, making cooking a breeze. Relaxation at Its Finest: Unwind in the spacious living areas, perfect for entertaining friends and family. Both bedrooms feature deep walk-in closets, providing ample storage space for your belongings. The convenience of having a washer and dryer inside the home is an added bonus, making laundry a hassle-free task. Outdoor Oasis: Step outside and discover your own personal paradise. The enclosed patio offers a serene space to enjoy your morning coffee or bask in the warm Arizona sun. With three large sheds, you'll have plenty of room for storage and hobbies. The lush surroundings of mature citrus trees create a refreshing ambiance, transporting you to a tropical paradise. Prime Location & Affordability: Conveniently located in a highly sought-after area, this mobile home offers easy access to all the amenities you desire. Enjoy the perks of a low lot rent at just $658 base rent, ensuring an affordable and stress-free lifestyle. Don't miss out on this incredible opportunity to own your dream retirement home! Call now to schedule a private tour and make this tranquil oasis your own. #RetirementHaven #MobileHomeForSale #55PlusCommunity #ParadiseLiving #LuxuryLiving #AffordableRetirement #FloridaLiving #DreamHome #TranquilOasis #SereneLiving #Mesa #mindyknowsmobiles #Mesamobileestates
MlsNumber: 11236150


Listing Provided By: Dragonfly Homes By Mindy LLC, original listing
Name: Dragonfly Homes By Mindy LLC
Phone: (701) 306-1327
Office Name: Dragonfly Homes By Mindy LLC
Office Phone: (701) 306-1327
Agent Name: Mindy Willert
Disclaimer: Copyright © 2024 My State MLS. 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 = 3218 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;
Amanda Blake
ASCIIKeller Williams Integrity First Realty
Call Today!: (480) 862-4914

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App