Title Page Background
DEBUG FN args: Array ( [0] => 3002 [1] => [2] => [3] => agent ) BEFORE: Site: 3002 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3002 Igate: njhud LocID: 3002 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 = 3002 AND i.igate IN ('mihud','usahud','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 = 'mihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3002 [1] => [2] => [3] => lender ) BEFORE: Site: 3002 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3002 Igate: njhud LocID: 3002 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 = 3002 AND i.igate IN ('mihud','usahud','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 = 'mihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3002 [1] => [2] => [3] => other ) BEFORE: Site: 3002 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3002 Igate: njhud LocID: 3002 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 = 3002 AND i.igate IN ('mihud','usahud','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 = 'mihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

158 Hideaway Lane
Upper Tract, WV 26866
Kevin Willner with Lost River Trading Post Realty, original listing - (304) 897-6971

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $939,000
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 2956 Square Feet
Agency: Lost River Trading Post Realty
Agency Phone: (304) 897-3300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 26 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: Spectacular Cedar log home and property in the Mountain Lake Retreat sub-division. This 3 bedroom , 2 full and 2 half baths home was built in 2018, and sits on three lots equaling 52 acres and used as a second home. The main level consists of a large living/dining/kitchen area with a floor to ceiling wood burning fireplace. This level has hardwood floors in the living and dining area and the gourmet kitchen has tile floors, granite counters and stainless - steel appliances. There is also a half bath and foyer on this level. There is also the primary suite with a bedroom and walk-in closet and carpeted floor. The primary bathroom has a walk-in shower with river rock, double vanities with granite counters and tile floors. <br /> The house has vaulted cathedral ceilings and huge windows to view some of the most breathtaking views in West Virginia. <br /> The upper level has a cozy loft, great for napping and reading. Bedroom 1 & 2 and a shared bathroom are also on this level. <br /> The lower level was designed to entertain. There is a huge great room with a wood burning stove. Carpet and tile floors. A beautiful 4 seat built in Ambrosia Maplewood bar with a sink, wine cooler and granite counters. There is also a huge room that is used as an exercise room and office, and half bath with tile floors and granite counter. The laundry and utility room are also on this level. The lower level screened in porch is perfect for relaxing and enjoying the mountain views.<br /> The 2 car garage is 30x30ft. and has sealed concrete floors and running water. Above the garage is a huge recreation room with carpeted floors and has a mini-split for heat & air.<br /> The 39x 36ft. 3 bay barn fits a 31ft. camper and is set up as a woodshop in the first bay The barn has sealed concrete floors and a pellet stove for heat. There is a circular driveway, hot tub with electric hook up and numerous fire pits with unbelievable mountain views. Great trout fishing is just a mile away at South Mill Creek Lake. Furniture is negotiable.
MlsNumber: --
ListingId: WVPT2000930


Listing Provided By: Lost River Trading Post Realty, original listing
Phone: (304) 897-6971
Office Phone: (304) 897-6971
Agent Name: Kevin Willner
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => pendleton [3] => WV [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: pendleton State: WV Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: pendleton State: WV 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 = 3002 AND i.igate IN ('mihud','usahud','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 = 'mihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Mobile: (241) 555-1812
Beware of the Bear - Look I am a Hooman

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App