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

194 Black Cub Run Lane
Harpers Ferry, WV 25425
Brianna Goetting with Pearson Smith Realty, LLC, original listing - (571) 386-1075

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 6
Baths: Full: 3
Status: Active
SqFt: 4980 Square Feet
Agency: Pearson Smith Realty, LLC
Agency Phone: (571) 386-1075

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: Magnificent Brick Home on 2 Private Acres<br /> Prepare to be enchanted by this stunning, predominantly brick home, situated on 2 serene and private acres of land. Whether you have a large family or simply love to entertain, this property offers unparalleled comfort, space, and tranquility, with every detail meticulously crafted for you to move in and enjoy immediately. From the moment you step inside, you'll be captivated by the grandeur and quality that permeates throughout.<br /> Key Features:<br /> 6 Spacious Bedrooms: Perfect for a large family or guests.<br /> 3 Luxurious Full Baths: Featuring tiled walk-in showers for a spa-like experience.<br /> Primary Suite: Boasts a walk-in closet and a luxurious bathroom, providing a private retreat within your home.<br /> Two Fireplaces: Enjoy cozy evenings with a brick fireplace and mantle in the kitchen, and a free-standing wood stove in the two-story great room.<br /> Premium Flooring: Solid wood floors and luxury vinyl flooring add elegance and durability.<br /> Expansive Deck: Ideal for outdoor gatherings, dining, or simply relaxing while enjoying the peaceful surroundings.<br /> Completely Renovated: Everything in this home is brand new, ensuring a modern and worry-free living experience.<br /> Ample Parking: A paved driveway accommodates multiple vehicles with ease.<br /> Beautiful Landscaping: Professionally designed to enhance the natural beauty of the property.<br /> Privacy Fence: Ensures a secluded and secure environment for your family.<br /> This home is a rare find, offering the perfect blend of luxury, comfort, and privacy. Don’t miss the opportunity to make this extraordinary property your own. Minutes to the Loudoun Cty VA and Maryland Line making it an easy commuter location. No HOA, High Speed Internet. Shannondale offers a 55 Acre Lake with a Mountain Lake Club Bar and Grill offering swimming, fishing, community events and much more! 194 Black Cub Ln is a spectacular place to live. Schedule a viewing today and experience the magic for yourself!
MlsNumber: --
ListingId: WVJF2013588


Listing Provided By: Pearson Smith Realty, LLC, original listing
Phone: (571) 386-1080
Office Phone: (571) 386-1075
Agent Name: Brianna Goetting
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.


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 = 2985 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Chaz Shultz
ASCIIChaz Shultz Real Estate Team brokered by Path Realty
Call Today!: (304) 279-9008

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App