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','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 = 1193 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 = 1193 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;

Lot 12 Irwin Way
Mc Henry, MD 21541

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,085,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2283
Agency: Keller Williams Integrity

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Brand New Home To Be Built! Adjacent to the Lodestone Golf Course! The "Black Walnut" model features 1,628 finished square feet with an unfinished basement offering another 760 square feet with an option to finish with 2-3 bedrooms, 1-2 bathrooms, and a game room with a walkout to the beautiful 1/2 acre lot in the Lodestone Village subdivision, minutes from everything there is to love at Deep Creek Lake! This home is priced with high-end luxury finishes and is fully customizable with Dixon Contracting. Features include LVT flooring throughout, ceramic tile in the bathrooms and laundry room, stunning Amish-built cabinetry, a gorgeous kitchen with granite counters, stainless steel appliances, a custom island, and a walk-in pantry! Also included are wood ceilings, a primary suite with a custom bathroom, a 42 " gas fireplace, and more! Please view the pictures for the floor plan, finishes, and additional details! Construction will take 6-12 months, depending on customization! Construction to perm financing will be required, and we've got great local connections to share with you!<br /> <br /> Want a different floor plan?! Maybe something bigger, something smaller. or something really unique?! We've got tons of floorplans to choose from, or we will design a custom one with you! <br /> <br /> This lot has public water and sewer hookups! High-speed cable/internet! Propane is available for cooking or heat if you'd like! This lot is adjacent to the award-winning championship Lodestone Golf Course, too! Whether you are building a second home for your family or an income-producing investment property, this location at the lake is highly sought after! The lake offers year-round activities, including day and night skiing at Wisp, ice skating, ice fishing, snowmobiling, horse and sleigh rides, boating, water skiing, kayaking, swimming, fishing, two championship golf courses, whitewater rafting at the ASCI park and the Youghiogheny River, zip line adventures, mountain bike trails and courses, ATV rentals, scenic chairlift rides, miles of hiking trailing, Swallow Falls, shopping, dining and more!<br /> <br /> Want to use your own builder, the lot is listed for sale separately!<br /> <br /> Call today for more details and an appointment with our builder.
MlsNumber: MDGA2006484


Listing Provided By: Keller Williams Integrity, original listing
Name: Keller Williams Integrity
Phone: (443) 574-1600
Office Name: Keller Williams Integrity
Office Phone: (443) 574-1600
Agent Name: Charlotte Savoy
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