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 = 3005 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 = 3005 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 = 3005 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;

115 Wildrose Lane
Terra Alta, WV 26764
AMANDA TRUSLER with BEL-CROSS PROPERTIES, original listing - (304) 296-7930

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $377,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2640 Square Feet
Agency: BEL-CROSS PROPERTIES
Agency Phone: (304) 296-7930

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1984
Notes: Welcome home to 'Logging Inn', the escape you've been waiting for tucked inside the gated community of ALPINE LAKE RESORT.  Nothing better signals that it's time to unwind than life in a LOG CABIN. Make yourself comfortable in the inviting living room and cozy up to the wood burning stove with natural stone hearth.  Relax on the generous covered front porch and enjoy seasonal views of the lake and striking sunsets.  Share a memorable meal or your favorite board game with those you hold dear in the sunny dining area or the freshly stained rear deck.   With 4 spacious bedrooms and a massive, freshly renovated lower level REC ROOM, you won't need to leave anyone out of the fun on your new adventure in the mountains.  Invite them all!  Swap stories around the fire pit and make unforgettable memories while the embers warm you from toes to nose.  Watch the mature ferns in the forest transform your mountain home into a verdant retreat this spring and summer.  Stroll down the street and find yourself at the lake's edge where you can cast your line into the water or relish in a cool and shady midday hike on Seven Bridges Trail.  Launch your kayak from the boat launch and bask in a tranquil morning on the mirror-like water.  Spend the day on the 18-hole GOLF COURSE.  Have a swim in the resort's heated INDOOR POOL or break a sweat in the fitness center overlooking crystal-clear lake!  Rejuvenate and socialize on a sunny day at the resort's SANDY BEACH.  Wrap up the day with a delicious dinner and drinks at the Evergreen Dining Room, Laker's Lounge, or savor in the simplicity of a picnic at one of the community gazebos.  Working from home is a breeze with HIGH SPEED INTERNET and up to a GIG available. Beautiful white winters and cool, breezy summers await you in the mountains of WV.  Resort amenities include a 150 acre STOCKED LAKE for kayaking and fishing, 24/7 SECURITY, mini golf, tennis and PICKLEBALL courts, golf course, BEACH with swimming area, dog park, HIKING TRAILS, bocce court, indoor pool, shuffleboard, Clubhouse with RESTAURANT & BAR, & on-site hotel. Located just 30 minutes from DEEP CREEK LAKE and WISP RESORT in McHenry, MD.  Two hours from Pittsburgh, PA.  Call today to meet your happy place!
MlsNumber: --
ListingId: 10153617


Listing Provided By: BEL-CROSS PROPERTIES, original listing
Phone: (304) 296-7930
Office Phone: (304) 296-7930
Agent Name: AMANDA TRUSLER
Disclaimer: Copyright © 2024 North Central West Virginia Real Estate Information Network. 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 = 3005 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;
Real Estate Expert Photo for Nikki Moon & Laurie Casarano
Nikki Moon & Laurie Casarano
ASCIIAppalachian Country Real Estate LLC
Call Today!: (304) 288-9641

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App