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

333 E 120th Street
Grant, MI 49327
Kevin Yoder with LPT Realty, original listing - (616) 942-2449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,900
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2252 Square Feet
Agency: LPT Realty
Agency Phone: (650) 543-2753

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Welcome to home to this premier brick estate set on nearly 2.5 acres, offering a harmonious blend of modern luxury and rural serenity. This impeccably remodeled 4-bedroom, 2.5-bath ranch home spans 2,252 sq ft of thoughtfully designed living space and is move-in ready for a life of comfort and convenience. The home features two charming wood-burning fireplaces, perfect for cozy evenings in, adding warmth and ambiance to both the living and family rooms. The heart of the home is the stunning kitchen, equipped with white shaker-style cabinetry, quartz countertops, a matching quartz backsplash, LG appliances, and a granite center island. The open-concept layout makes it ideal for both everyday living and entertaining. A walk-up attic offers the potential for additional square footage if finished, further enhancing the home's appeal.<br /> <br /> The estate includes a 644 sq ft attached garage and an impressive 2,160 sq ft detached all-brick garage, complete with an 80,000 BTU natural gas furnace, professionally done epoxy floors, and a half bath. Above the detached garage, a walk-up bonus flex room provides the option to add 1,280 sq ft of finished space, making it an ideal spot for a home business or hobby area. Whether you're a mechanic, artist, hairstylist, or entrepreneur, this versatile space offers endless possibilities.<br /> <br /> The large deck overlooks a beautiful, private backyard with mature trees and a farm bordering the north side of the property, creating a peaceful, country feel. Situated just outside of Grant, you'll enjoy the convenience of nearby city amenities while being surrounded by the beauty of rural living. Grant is known for its thriving "Farm to Table" culture, abundant fruit orchards, and farm-to-table dining experiences.<br /> <br /> Outdoor enthusiasts will love the location, as Newaygo County boasts 234 lakes, 356 miles of rivers, and over 100,000 acres of national forest to explore. Plus, you're just a short 40-minute drive from both Grand Rapids and the stunning shores of Lake Michigan. This estate is more than just a homeit's a lifestyle waiting to be embraced.
MlsNumber: --
ListingId: 24056148


Listing Provided By: LPT Realty, original listing
Phone: (616) 366-2591
Office Phone: (616) 942-2449
Agent Name: Kevin Yoder
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