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

04143 N Concorde Road
Boyne City, MI 49712

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $654,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1760
Agency: Berkshire Hathaway HomeServices-Boyne City

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1973
Notes: Step into modern comfort and timeless elegance in this recently renovated residence nestled in the amazing lakefront community of Villa de Charlevoix. With three bedrooms and two full bathrooms, this home combines classic charm with contemporary convenience. Experience the allure of a home thoughtfully updated throughout, blending classic design with modern amenities. The open floor plan creates a seamless flow, emphasizing natural light and providing a welcoming ambiance. The recently renovated kitchen boasts state-of-the-art appliances, sleek finishes, and ample storage, catering to both style and functionality. Ascend up to the luxurious loft-style master suite, providing a private retreat with soaring ceilings and a unique, chic ambiance. Indulge in the spacious custom closet designed to accommodate the most extensive wardrobes, adding a touch of opulence to your daily routine. The master suite includes an updated full bath featuring modern fixtures and heated floors for a spa-like experience. The two main level bedrooms were converted into a cozy sitting room and large home office but can easily be changed back to standard bedrooms. Enjoy the convenience of a dedicated main level laundry room equipped with modern appliances, sink and a designated folding area making household chores a breeze. Retreat back to the private yard offering a double lot enhanced by recent landscaping, deck and an adorable shed/"she shed", providing a tranquil space for relaxation and entertainment. Villa de Charlevoix has 600 feet of prime Lake Charlevoix frontage, offering breathtaking views and direct access to serene waters. Embrace the lake lifestyle with on-site opportunities for boating, kayaking, paddleboarding, and relaxing on your private beach with pavilion, park and restrooms. Seize the opportunity to live in luxury within the coveted Villa de Charlevoix community. Schedule a showing today to explore the unmatched elegance of 4143 N Concorde!
MlsNumber: 1917854


Listing Provided By: Berkshire Hathaway HomeServices-Boyne City, original listing
Name: Berkshire Hathaway HomeServices-Boyne City
Phone: (231) 216-1000
Office Name: Berkshire Hathaway HomeServices-Boyne City
Office Phone: (231) 216-1000
Agent Name: Brad Morton
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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