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;

2222 Loree Rd
Applegate, MI 48401
Malinda S. Kelly with Town & Country Realty-Lexington, original listing - (810) 622-5000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 7
Baths: Full: 4
Status: Active
SqFt: 3792 Square Feet
Agency: Town & Country Realty-Lexington
Agency Phone: (810) 359-5000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: GREAT BUSINESS OPPORTUNITY!! Charming 7 Bedroom, 4 Bath Home on 10 Acres is 3792 sqft. Discover this spacious 2-story home, offering the perfect blend of business and personal living. Currently operating as an AFC business on the main floor and is licensed for 6 clients which brings in $7,800 a month (business sale includes all equipment and furnishings on 1st floor, exclude personal items), with the upper level dedicated to private living quarters. There are 3 bedrooms and 2 full bathrooms on the main floor that includes 2 private bedrooms and one huge bedroom that included 4 client’s beds. The 2nd level has 4 bedrooms & 2 full bathrooms a huge living room has a cathedral ceiling. Primary Suite – 15x16 with a cathedral ceiling, massive 8x9 bath featuring a double sink, Jacuzzi tub, and shower, plus a walk-in closet There is an extra room that makes for a great workout. Geo-Thermal Heating – Energy-efficient and comfortable year-round. There is also a separate outdoor staircase for the 2nd level. Outdoor Living – 16x24 deck, 7x14 covered stone porch, and an inviting pool that stays plus 10 Acres of Trails – Perfect for outdoor enthusiasts. 2-Car Garage – 20x24 space for your vehicles and storage. The main floor was built in 1987 and the upper floor was added in 2008. Location is great with only 30 miles from Fort Gratiot and just 6 miles from Lake Huron! This unique property offers endless potential for those looking to run a business and enjoy a private retreat. Don’t miss the opportunity to own this one-of-a-kind home!
MlsNumber: --
ListingId: 50159440


Listing Provided By: Town & Country Realty-Lexington, original listing
Phone: (810) 837-1277
Office Phone: (810) 622-5000
Agent Name: Malinda S. Kelly
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