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

34566 Maple Ln Drive
Sterling Heights, MI 48312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $259,900
Beds: 2
Baths: 3
Status: Pending
SqFt: 1330
Agency: Century 21 Curran & Oberski

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1990
Notes: Welcome Home to this spacious Two-Bedroom Ranch condominium features a well-designed two-bedroom 1st floor plan, providing ample space for comfortable living.Luxurious three full bathrooms each tastefully designed with modern fixtures and finishes.Finished Basement: The finished basement adds value with two potential bedrooms, offering flexibility for use as an office, guest room, or entertainment space.Contemporary kitchen with marble countertops elevating both the aesthetic appeal and functionality of the space. A perfect blend of style and practicality.Open Concept Great Room: The great room, seamlessly integrated with the kitchen, creates a spacious and inviting living area. Ideal for entertaining guests or relaxing by the fireplace.Cozy Fireplace. of the fireplace, creating a cozy atmosphere for those chilly evenings.Elevated Deck: Step outside onto the elevated deck and enjoy picturesque views. Whether it's morning coffee or evening gatherings, the deck provides an ideal outdoor space.Modern Finishes Throughout: From the kitchen to the bathrooms, this condominium showcases modern finishes that enhance the overall aesthetic and functionality of the living spaces.Abundant Natural Light: Large windows in key areas allow plenty of natural light to flood the interiors, creating a bright and airy atmosphere.Convenient Location: Situated in a desirable location, this condominium offers easy access to amenities, shopping, and recreational areas, ensuring a convenient and enjoyable lifestyle.Thoughtful Storage Solutions: Well-planned storage options throughout the condominium, including closets and cabinets, contribute to a clutter-free and organized living space.Efficient Heating and Cooling: Enjoy year-round comfort with an efficient heating and cooling system, ensuring a pleasant living environment regardless of the season.2 car Garage
MlsNumber: 24000775


Listing Provided By: Century 21 Curran & Oberski, original listing
Name: Century 21 Curran & Oberski
Phone: (734) 464-6400
Office Name: Century 21 Curran & Oberski
Office Phone: (248) 264-1700
Agent Name: Raid Shaba
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App