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;

11823 Fountainview Blvd
Romeo, MI 48065

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $27,500
Beds: 3
Baths: 2
Status: Active
SqFt: 1300
Agency: Dantes Manufactured Homes, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 2006
Notes: MOTIVATED SELLER! HUGE price reduction! 11823 Fountanview Blvd, Bruce, MI 48065 Located in Springbrook Estates MHC Bruce Township, Macomb County Romeo Community Schools HIGHLIGHTS: - 2006 home - 3 bed + bonus room, 2 bath - Renovated & clean! - 13x10 covered, railed porch - Off-street parking - 10x8 matching shed - Genuine oak cabinetry - 42" wide hallway - 36" bedroom doors - 6" construction - Central AC - Existing appliances included (refrigerator/freezer combo, gas range, dishwasher, microwave) Renovated & immaculate - this 2006 Skyline is move-in ready! Exterior of the home offers great curb appeal with vinyl siding in pale yellow; shutters in gray; trim and railings in white; and a matching shed in the rear of the home. The manufactured covered porch offer additional outdoor living space at the main entrance of the home and is nicely lined with arborvitaes to provide year-round green foliage. The interior of the home features an open layout with an unobstructed view of the living room, kitchen, and nook from the main door. Immediately adjacent to the kitchen/nook is a bonus room, with two walls with windows ... loads of daylight! At the opposite end of the kitchen is the large laundry/mud room with a secondary door-access to the guest bathroom. From the living room, a 42" wide hallway will lead you to the primary entrance to the guest bathroom and the three bedrooms. The PRIMARY SUITE features the PRIMARY BEDROOM (12x12) with WIC and ENSUITE BATHROOM (8x5). The bedroom is corner-set at the rear of the home and offers carpet flooring and a walk-in closet. The bathroom offers vinyl flooring, genuine oak cabinetry, countertop height vanity with single sink, and 1pc tub/shower combo. BEDROOM 2 and 3 are similarly sized at 10x9 and 12x9, respectively, and both offer carpet flooring and a standard closet. GUEST BATHROOM (8x5): enter from the hallway or from the laundry/mud room; conveniently located near living room and bedrooms; vinyl flooring, 1pc tub/shower combo, genuine oak cabinetry with single sink, tall commode. LIVING ROOM (17x13): corner-set and located at the front of the home; carpet flooring, large windows, and lighted ceiling fan EAT-IN KITCHEN WITH NOOK (13x13): vinyl flooring, loads of genuine oak cabinetry, double SS sink with sprayer; existing white appliances included (refrigerator/freezer combo, gas range, dishwasher, microwave) BONUS/DINING ROOM (12x10): carpet flooring, corner-set with four windows, and lighted ceiling fan. Perfect for a SITTING ROOM or extra DINING area. LAUNDRY/MUD ROOM (7x7): enter from the kitchen or from the guest bathroom; vinyl flooring, exit door; set up for electric dryer MECHANICALS: Furnace, central AC, water heater, 100amp electrical *All measurements are approximate *Lot-rent may differ for new resident
MlsNumber: 11276522


Listing Provided By: Dantes Manufactured Homes, LLC, original listing
Name: Dantes Manufactured Homes, LLC
Phone: (248) 278-6285
Office Name: Dantes Manufactured Homes, LLC
Office Phone: (248) 278-6285
Agent Name: Karen Dantes
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 = 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;
Dominic Shaba
ASCIIeXp Realty
Call Today!: (619) 246-7525

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App