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

5150 Page Avenue
Jackson, MI 49201

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $319,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2088
Agency: PRODUCTION REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1987
Notes: Welcome to your dream home! This impeccably renovated gem offers 1,882 square feet of modern luxury nestled on a spacious peaceful 1-acre level lot. With tons of natural light and 4 bedrooms, including a primary suite on the main floor, and a host of upgrades, this property offers the perfect blend of style, comfort, and functionality. The second main floor bedroom can double as a home office for the modern professional. Three full bathrooms, each have been tastefully updated with new fixtures, making your daily routines a pleasure. Step inside and enjoy a fresh start with freshly painted walls, cabinets, ceilings, baseboards, and trim. The neutral color palette provides a clean canvas for your personal style. Discover all-new carpet and wood LVP flooring throughout the home... The updated flooring not only enhances the aesthetic but also ensures durability and easy maintenance. The entire home has been adorned with new light and plumbing fixtures, elevating the ambiance and functionality of every room.<br /> <br /> The heart of the home, the kitchen, shines with brand-new Quartz countertops. These sleek surfaces offer both beauty and durability, making meal preparation a joy. Step outside from the kitchen to a privacy-fenced backyard that ensures a tranquil outdoor retreat. Whether you're entertaining or relaxing, this space offers endless opportunities for enjoyment.<br /> <br /> The home features a 2-car attached garage and an additional detached 1,174 square foot garage/workshop. There's plenty of room for your vehicles, hobbies, and storage needs. This setup is a car enthusiast's dream!<br /> And there is also a 951 square foot unfinished basement that provides limitless possibilities for customization, allowing you to create the additional space you've always dreamed of.<br /> <br /> This home has been thoughtfully updated to meet modern standards while retaining its classic charm and offers a rare opportunity to own a beautifully renovated property on a sizable lot. It's conveniently located, providing easy access to local amenities, schools, and more. Don't miss your chance to call this your forever home. Schedule a showing today and prepare to be impressed!
MlsNumber: 24022113


Listing Provided By: PRODUCTION REALTY, original listing
Name: PRODUCTION REALTY
Phone: (517) 879-4141
Office Name: PRODUCTION REALTY
Office Phone: (517) 879-4141
Agent Name: BEN LATOCKI
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.


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 = 3331 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;
Real Estate Expert Photo for Bryon Gough
Bryon Gough
ASCIIGough Property Shoppe powered by eXp Realty
Call Today!: (517) 745-5443

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App