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

1130 N Edgar Road
Mason, MI 48854

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5170 Square Feet
Agency: Berkshire Hathaway HomeServices Tomie Raines
Agency Phone: (517) 351-3617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: This custom-built 4-5 bedroom, 3.5-bath ranch has a delightfully bright and open floor plan. Its subtle modern finishes work in harmony with the tranquil 5.9 acres, a stocked pond, 8x8 gazebo, 16 x11 handy barn, and 24 x 36 pole barn. Step inside to a welcoming foyer with a study or 5th bedroom through French doors. An extra special king-size primary suite offers dual walk-in closets, spa tub and euro-style tiled shower. Enjoy your favorite beverage and unwind on the deck off your private space to enjoy peaceful views of the pond and woods. The second bedroom on this floor is quite generous in size, has great storage and accesses a hallway bath with granite vanity and tub/shower enclosure. Breathe in the incredible views from the main living areas especially through the Andersen windows. The kitchen was designed to bring everyone together. Beautiful hickory cabinets and quartz counters/space! Perfect gathering space to enjoy time with friends and family. Newer refrigerator with water filtration system, and dishwasher in 2022. A 7x8 walk-in pantry with shelving is sure to catch your eye and store all your gadgets and cookware. All of this opens to the dining space that accesses the deck and steps down to the great room with fireplace and built-in shelves. The back hall offers 10x10 laundry service hookup, utility closet and a refreshed ½ bath. The oversized 2-car garage has an epoxy sealed coated floor, 50 AMP level 2 EV plug, which can also be used for a portable generator, water, floor drain, and stairway access to the basement. The finished walk-out lower level has in-floor heat and newer laminate floors and was designed for comfort and enjoyment! The Red Wing themed space brings game! Sit up at the bar area to enjoy some food and beverages and then settle in and warm up by the fireplace in the family room. Step out to the lower covered patio for BBQs, then spend some time on the pond... hint - you might even catch a Bass or Bluegill. The recreation space is an ideal space for games or for your home gym set up. Bedrooms 3 and 4 are generous in size, have great closets and have access to the third full bath. Additional features include Pole barn has a 1.5 car garage space, has 10 ft ceiling, 120 volt, and 60-amp power with 3 circuits, the other 1/2 of pole barn finished and insulated as a workshop. The outdoor space is utterly amazing, the pond is approximately 12 ft deep. The lovely 8x8 gazebo draped with trumpet flowers and wisteria has a shaded view of the pond and is adjacent to a large perennial flower garden. An exceptional location, close and convenient to downtown Mason and Schools, as well as expressways. County Roads please bring me Home!
MlsNumber: --
ListingId: 284833


Listing Provided By: Berkshire Hathaway HomeServices Tomie Raines, original listing
Phone: (517) 449-6100
Office Phone: (517) 351-3617
Agent Name: Lisa Fletcher
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.


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 = 3328 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 Rebecca Dunne
Rebecca Dunne
ASCIIHoward Hanna Real Estate Executives Lansing Office
Call Today!: (517) 416-8663

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App