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

380 Bernard Street
Schoolcraft, MI 49087
Holly Woodhams with Chuck Jaqua, REALTOR, original listing - (269) 381-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4208 Square Feet
Agency: Chuck Jaqua, REALTOR
Agency Phone: (269) 381-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Seller is offering up to 3% of sale price to Buyer to help pay down their interest rate or put towards closing costs! Welcome to this stunning one owner home offering over 4,200 sq feet of beautifully finished living space! This 4 bedroom, 5 bath residence features an inground pool with a very private backyard complete with a cozy firepit, large patio space and an additional garage for extra storage or hobbies. Nestled on one of the most desirable streets in Schoolcraft, this home is conveniently located in the heart of the village just moments from the new schools, shopping and dining. An exceptional opportunity to own in a sought after location! Newer items include refrigerator, stove and microwave, mechanicals, pool liner, heater and pump! The main level boasts a large living room with vaulted ceilings and a cozy fireplace, while the spacious kitchen is equipped with newer appliances and a delightful eating area that opens through French doors to the beautiful patio and pool area. Please note there are wood floors under the carpet in living room and tile in dining area and kitchen! The family room is equally impressive, with its second fireplace, bamboo wood floors, wet bar with a sink and kegerator, built-in bookshelves, and a stunning wall of windows with French doors leading to the patio and pool! A separate office and 1/2 bath in this space provide flexibility with the potential to convert the office into a 5th bedroom if desired. The main floor also includes a convenient laundry room with a utility sink and an additional 1/2 bath! Upstairs, the primary suite is a serene retreat with views of the backyard and pool, vaulted ceilings, a large walk in closet, and a luxurious bath with dual sinks, a jacuzzi tub with heated jets and a stand up shower. The upstairs also includes a 2nd ensuite with vaulted ceilings, a walk in closet and an attached full bath! There are 2 additional bedrooms- one perfectly suited for a nursery as it is just off the primary suite- and an additional full bath! The finished basement is perfect for entertaining with a family room complete with a built in bar with a sink and plenty of storage. A spacious 3 car attached garage has a heater with its own power panel and a separate 3rd stall completes this incredible property! The private backyard is an oasis, with a gorgeous inground pool with a newer heater, pump and liner! The patio is spacious with a firepit area and a 2nd garage that could be used as a pool house or extra storage! The privacy in this backyard is one of a kind! There is an additional lot for sale that the buyer will have a first right of refusal to. Please check out MLS# 24047922 for more info! This is a very special property with so much to offer to the lucky new owners! Make your appointment today! You will not be disappointed!
MlsNumber: --
ListingId: 24060114


Listing Provided By: Chuck Jaqua, REALTOR, original listing
Phone: (269) 760-6690
Office Phone: (269) 381-7653
Agent Name: Holly Woodhams
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 = 1273 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 C David Howard
C David Howard
ASCIICentury 21
Call Today!: (269) 207-4228

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App