Title Page Background
DEBUG FN args: Array ( [0] => 2995 [1] => [2] => [3] => agent ) BEFORE: Site: 2995 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2995 Igate: njhud LocID: 2995 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2995 AND i.igate IN ('orhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2995 [1] => [2] => [3] => lender ) BEFORE: Site: 2995 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2995 Igate: njhud LocID: 2995 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2995 AND i.igate IN ('orhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2995 [1] => [2] => [3] => other ) BEFORE: Site: 2995 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2995 Igate: njhud LocID: 2995 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2995 AND i.igate IN ('orhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

299 Harmisons Bluff Point
Fort Ashby, WV 26719
Keenan Shanholtz with WEST VIRGINIA LAND & HOME REALTY, original listing - (304) 822-4488

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3271 Square Feet
Agency: WEST VIRGINIA LAND & HOME REALTY
Agency Phone: (304) 822-4488

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: COYOTE BLUFF LODGE....IMMACULATE CUSTOM CEDAR LOG HOME ON 20 ACRES ELEVATED AT1600 FT ABOVE SEA LEVEL ATOP "MIDDLE RIDGE" OFFERING JAW DROPPING VIEWS OF THE PATTERSON CREEK VALLEY AND WESTERN MOUNTAIN RANGES. BUILT IN 2009 AND METICULOUSLY CARED FOR SINCE, THIS IS A REAL DEAL LOG HOME; EXPOSED TIMBERS, MASSIVE REAL STONE FIREPLACE, WRAP AROUND PORCH AND STANDING SEAM METAL ROOF. OPEN FLOOR PLAN, PERFECT FOR ENTERTAINING AND ALL 3 BEDROOMS ARE SUITES. MATCHING 3 CAR GARAGE/WORKSHOP TO STORE YOUR OUTDOOR TOYS AND TINKER WITH PROJECTS. SAVE THOUSANDS $$$ UP FRONT, HOME CONVEYS TURNKEY, FULLY FURNISHED AND READY TO ENJOY DAY ONE.....EVEN THE CUB CADET MOWER AND KAWASAKI MULE CONVEY! THE 20 ACRES IS EASY TO NAVIGATE VIA 5 DIFFERENT OLD LOGGING ROADS THAT TRAVERSE THE PROPERTY. LOCATED IN THE PRESTIGIOUS GATED COMMUNITY OF "THE BLUFFS ON THE POTOMAC".....THE BLUFFS IS KNOWN FOR IT'S ABUNDANCE OF BIG BUCKS, BEAR & TURKEY. AS AN ADDED BONUS, THE COMMUNITY HAS IT'S OWN PRIVATE COMMON AREA ON THE SOUTH BRANCH OF THE POTOMAC RIVER FOR CANOE, KAYAK, TUBES, FISH & SWIM......A PRIVATE PARK ON THE RIVER FOR YOUR SUMMERTIME ENJOYMENT. FAIR WARNING....YOU'RE GONNA HAVE A LOT OF NEW FRIENDS IF YOU BUY THIS PLACE ...... EVERYONE IS GONNA WANT TO COME FOR A VISIT....TREAT YOURSELF TO SOMETHING SPECIAL, SOMETHING YOU CAN BE PROUD OF....A PLACE THAT YOU CAN'T WAIT TO GET TO AND HATE TO LEAVE! YOU COULDN'T START FROM SCRATCH AND REPLICATE FOR THE LIST PRICE, NOT TO MENTION THE TIME & STRESS INVOLVED WITH A PROJECT OF THIS MAGNITUDE.....HIT THE EASY BUTTON AND ENJOY THE FRUITS OF SOMEONE ELSES LABOR!
MlsNumber: --
ListingId: WVMI2003396


Listing Provided By: WEST VIRGINIA LAND & HOME REALTY, original listing
Phone: (304) 822-4488
Office Phone: (304) 822-4488
Agent Name: Keenan Shanholtz
Disclaimer: Copyright © 2025 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