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

261 Vista Drive
Jackson, MI 49203

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $363,999
Beds: 5
Baths: 3
Status: Active
SqFt: 2518
Agency: First Home Real Estate Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential
Year Built: 1973
Notes: Are you looking for land and privacy? Well, this is the perfect home for you. This impeccably renovated home offers 1,518 square feet of luxury, nestled on a spacious, peaceful 9.51 acres. Nearly everything has been renovated and is new. This home offers new gutters, windows, water heater, well pump, electric, plumbing, heating, and cooling that will provide years of worry-free living. This home is a ranch style with a walkout basement overlooking natures beauty. The house also has new drywall, paint, flooring, and all-new bathrooms. When you walk into the front door there is huge mudroom that takes you into the dining room and the kitchen. The kitchen includes granite counters, soft close cabinets, stainless steel appliances, and an island. Right off the kitchen is a laundry room with washer and dryer hookups. The living room is enormous and perfect for all your entertaining needs. The primary bedroom gives you all the privacy you need with, being on the other side of the house from the other three bedrooms. The primary bedroom features an ensuite bath with a tile shower. The three other bedrooms are great size and offers a lot of natural light. The main full bath features a beautiful tile shower. The home features a 2.5 car attached garage with a workshop under one of the garage stalls. The walkout basement has a separate entrance and a 5th bedroom, second living room, full bathroom, kitchen, and a room for an office or storage. In the back of the house there is also another 2-car garage with 1 car garage door, or it is the perfect storage area. The finished basement would be an ideal space for a mother-in-law suite, additional income, or private space for a family/friend. The 26x40 pole barn has cement floors, electricity, stubbed for a bath, new drywall, freshly painted siding, and on its own septic and well. There is plenty of room for your vehicles, hobbies, and storage needs. This setup is a car enthusiast's dream!! Not only does this home have everything you need it also is in a dream location. Located close to schools, highway, hospital, couple lakes, and the grocery store. Don't miss your chance to call this your forever home. Schedule a showing today and prepare to be impressed!
MlsNumber: 278750


Listing Provided By: First Home Real Estate Inc, original listing
Name: First Home Real Estate Inc
Phone: (517) 321-8255
Office Name: RE/MAX Real Estate Pros Dewitt
Office Phone: (517) 321-8255
Agent Name: Jamie Bates Homes
Disclaimer: Copyright © 2024 Greater Lansing Association of Realtors. 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