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

15281 Jeddo
Brown City, MI 48416

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,399,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3930
Agency: Realty Executives Home Towne

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Property Type: Residential
Year Built: 2020
Notes: Step into this exquisite 2020-built home and experience unparalleled luxury. The grand foyer, with its custom staircase and elegant crystal chandelier, sets the tone for this exceptional residence. Throughout the home, 9ft doors amplify the sense of spaciousness and elegance. The kitchen is a chef’s dream, featuring hardwood floors, granite countertops, top-of-the-line appliances, and a climate-controlled pantry with two islands. Enjoy formal dining with breathtaking views, and relax in the great room with high ceilings and a floor-to-ceiling fireplace. The primary bedroom is a true retreat, offering His and Her California Closets, room-darkening blinds, and a lavish bathroom with marble countertops & flooring, a custom marble shower, and a deep jetted tub. Step outside through an oversized door-wall onto a Trex deck, perfect for unwinding in the fresh air. Upstairs, you’ll find a second primary suite, two additional bedrooms, a full-size bathroom, and a large bonus room. The basement features 9ft ceilings and a full bathroom, providing ample space for various needs. Additional amenities include an office, a mudroom with ample storage, a laundry room with granite countertops, and a 3.5-car garage. Outdoor enthusiasts will be delighted by the equestrian facilities, including a horse barn with 7 stalls, an indoor arena with an observation room, new fencing and shelters, summer grazing and winter pastures, and 10 wooded acres. This property offers a unique opportunity to escape the hustle and bustle of the city and create your own private paradise. Schedule a showing today and make this stunning estate your forever home!
MlsNumber: 50130585


Listing Provided By: Realty Executives Home Towne, original listing
Name: Realty Executives Home Towne
Phone: (810) 300-1650
Office Name: Realty Executives Home Towne Chesterfield
Office Phone: (586) 949-8300
Agent Name: Kaylin Weil
Disclaimer: Copyright © 2024 Multiple Listing Service MiRealSource. 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