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 = 3464 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 = 3464 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 = 3464 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;

34167 W 9 Mile Road
Farmington, MI 48335
Sam Bazzy with EXP Realty LLC, original listing - (888) 501-7085

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $379,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 1868 Square Feet
Agency: EXP Realty LLC
Agency Phone: (888) 501-7085

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1948
Notes: Charming 4-Bedroom Country-Style Home with Wraparound Porch & Heated Pool!<br /> <br /> Welcome to this beautifully maintained 4-bedroom, 3-bath country-style home, offering the perfect blend of charm, space, and modern updates. From the wraparound porch to the expansive back deck, this home is made for relaxing and entertaining.<br /> <br /> Inside, the bright and spacious family room features a granite natural fireplace, large windows for abundant natural light, and French doors leading to the deck. The eat-in country kitchen provides plenty of cabinet and pantry space, while the formal dining room with hardwood floors adds elegance. A separate sitting area, updated full bath, and a versatile fourth bedroom/home office complete the main floor.<br /> <br /> Upstairs, the primary suite boasts a private bath and walk-in closet, while two additional bedrooms share a convenient Jack-and-Jill bath. All bathrooms are updated, and every bedroom features hardwood floors and ceiling fans.<br /> <br /> The partially finished basement offers 400 sq. ft. of bonus space, perfect for a playroom, home gym, or office. Updates include electrical, plumbing, and vinyl windows? New Roof on home and garage. Brand new Furnace and AC. The oversized 2.5-car garage provides extra workshop space with heating potential.? Appliances included.<br /> <br /> Sitting on over half an acre, the park-like backyard is partially fenced and features a heated above-ground pool. A dedicated well keeps the landscaping lush. The home sits far back from 9 Mile, offering privacy while still being walkable or bikeable to Downtown Farmington and top-rated schools. With easy freeway access, this home is a must-see!? BTVAI<br /> <br /> Schedule your private showing today!
MlsNumber: --
ListingId: 20250011183


Listing Provided By: EXP Realty LLC, original listing
Phone: (313) 525-5566
Office Phone: (888) 501-7085
Agent Name: Sam Bazzy
Disclaimer: Copyright © 2025 Realcomp Limited II. 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