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

107 Old Camp Road
Mc Henry, MD 21541

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,500
Beds: 5
Baths: 5
Status: Active
SqFt: 3416
Agency: Railey Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Nestled within North Camp, this remarkable 5-bedroom, 4 1/2 bath log home offers the ideal escape for those who seek the perfect combination of rustic charm and modern luxury. As you step inside, the grandeur of the space is immediately evident, with cathedral log beamed ceilings in the Great Room that create an ambiance of warmth and spaciousness. Spread across three levels, this home provides ample room for relaxation and entertainment. The Lower Level is a haven for leisure, featuring a Recreation and Game Room complete with a full-size granite countertop bar area and billiards. It's the ultimate destination for indoor entertainment, whether it's a friendly game night or a cozy evening at the bar. Two Primary Bedroom suites provide the utmost in comfort and privacy, ensuring that every member of your party can unwind in style. The well-appointed kitchen and bar areas boast elegant granite countertops, adding a touch of sophistication to the heart of the home. The gleaming hardwood flooring throughout adds a sense of opulence to the entire space.For those who relish the great outdoors, this property truly excels. An oversized patio on the Lower Level beckons with a hot tub, perfect for soothing tired muscles after a day on the slopes, and a fire pit where you can gather around for stories and stargazing. The main-level covered deck area expands the outdoor living experience, providing an inviting space for open-air dining and relaxation. Notably, this property has a strong rental history with Railey Vacations, making it an attractive option for investors. Its location at the end of a tranquil cul-de-sac ensures privacy and serenity. Plus, the convenience of being just a short walk to the ski slope and minutes away from the renowned ASCI whitewater course adds to the appeal of this exceptional mountain retreat.Experience the best of all worlds in this North Camp log home—a harmonious blend of natural beauty, modern comfort, and an abundance of entertainment options. It's a place where memories are made and shared, whether you're seeking a personal haven or an income-generating investment.
MlsNumber: MDGA2006058


Listing Provided By: Railey Realty, Inc., original listing
Name: Railey Realty, Inc.
Phone: (301) 387-2000
Office Name: Railey Realty, Inc.
Office Phone: (301) 387-2000
Agent Name: Rich Orr
Disclaimer: Copyright © 2024 Bright 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