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','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

10575 Country Club Drive
Richland, MI 49083

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 3600
Agency: Jaqua Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: One of Richland's most desirable locations, in the rarely available subdivision of<br /> Tamarron (Gull Lake Schools) overlooking beautiful woods with trails and the 16th<br /> fairway of the Gull Lake Country Club. This Ranch home offers a grand foyer w/<br /> beautiful hardwood flooring, 2 fireplaces, 3+ bedrooms and 2.5 full baths, over 3600 fin.<br /> sq/ft and a large amount of storage area that could also be finished off. All rooms are<br /> spacious w/ the oversized Great Room with 12ft ceilings, wall of windows overlooking<br /> stone patio and a lush backyard with steps leading to additional green space, gas FP,<br /> FDR, office adjacent to half bath, custom kitchen with granite and quartz countertops<br /> and newer Café' appliances, opening to the eating area and double doors leading to a<br /> screened porch Completing the main floor is a large primary ensuite and convenient<br /> laundry/mud room area. Finished lower-level walkout offers a family room with gas FP,<br /> wet bar and sliders leading to the lower patio, 2 good size bedrooms, the family bath.<br /> and large storage room make this a very ''family friendly'' floor plan. The house is<br /> equipped with sprinkler system and full house Generac 22kw generator. Built by AVB<br /> with sunset views and plenty of daylight windows. Easy to show and move-in ready!!<br /> Per Owner: Roof 6/2020 (3-tab dimensional shingles), Garage Doors & Chamberlain<br /> Garage Openers 7/2020, Furnace 11/2017, Air Conditioner 7/2018, Café' refrigerator,<br /> range, microwave, dishwasher 12/2020, Generac Generator 9/2016, Sump Pump<br /> 12/2018, Water Reverse Osmosis System 12/2018, Well Pump 12/2023, Washer/Dryer<br /> 10/2022, Side Brick Patio 9/2017, Back steps to golf course 7/2020, Granite and Quartz<br /> Countertops 12/2015, Refinished wood flooring 11/2015, New wood flooring in great<br /> room 11/2018, Trim/walls painted 2019, new carpet throughout 2019
MlsNumber: 24027277


Listing Provided By: Jaqua Realtors, original listing
Name: Jaqua Realtors
Phone: (269) 381-7653
Office Name: Chuck Jaqua, REALTOR
Office Phone: (269) 381-7653
Agent Name: Matthew Hadden
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','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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