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

247 Daylily Court
Terra Alta, WV 26764-3114
AMANDA TRUSLER with BEL-CROSS PROPERTIES, original listing - (304) 296-7930

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $419,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1972 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: 1991
Notes: Welcome to On The Rocks! Discover this rare gem, a tastefully remodeled cabin nestled within the secluded 2,000-acre gated community of ALPINE LAKE RESORT. Sold tunrkey with an acceptable offer, this property allows you to start your adventure immediately after leaving the closing table. The home boasts gorgeous and durable hickory luxury vinyl plank flooring throughout, creating a seamless flow between rooms. The kitchen is a delight, featuring new cabinetry, a tile backsplash, granite countertops, new warrantied appliances, a charming Black Bear tile mural, and abundant natural light. The open-concept living area is perfect for entertaining, complete with a stunning natural stone floor-to-ceiling fireplace to ensure a cozy atmosphere for you and your guests on chilly mountain evenings. The dining area offers a beautiful log table and chairs and provides easy access to the rear deck. From here, enjoy views of over 30 acres of resort-owned green space and hundreds more acres of vacant land bordering Maryland. Elegant, rustic lighting ties this Great Room together. Both bathrooms feature unique custom-cut live edge wood slab countertops with sleek bowl sinks. The showers are beautifully finished with intricate tile patterns and lovely new fixtures that complement the natural mountain setting. The first floor includes three bedrooms, highlighted by your primary suite. Upstairs, overlooking the great room, is a versatile bonus loft ideal for a flex space, reading nook, or home office. Beyond the loft, you'll find a bright and airy fourth bedroom with dual closets. The finished 520 sq ft basement offers even more living space, featuring a wood-burning stove with a stone hearth. This area is spacious enough to serve as a den, game room, gym, or a combination of all three! The convenient 2-car integral garage provides ample storage for your golf cart, vehicle, and lake equipment. Imagine waking up to birdsong and enjoying your coffee with the sunrise from the covered front porch, or relaxing on the rear deck accessible from the dining room and primary bedroom. Situated at the end of a cul-de-sac at the mountain's peak, 'On the Rocks' guarantees peaceful days and nights. Adventure awaits right outside your door, with the Castle Rock trailhead offering immediate access to forest exploration. Experience tranquility while kayaking on the still lake waters in the early morning or enjoy an exhilarating afternoon of pickleball with friends. Soak up the sun at the resort's private sandy beach and swim in the crisp, clean spring-fed lake. Spend a day on the picturesque 18-hole golf course or enjoy a swim in the resort's heated indoor pool, which overlooks the crystal-clear lake. Working remotely is a breeze with high-speed internet and up to a GIG available. Experience the beauty of white winters and cool, breezy summers in the mountains of wild and wonderful WV. Resort amenities include a 150-acre stocked lake for kayaking and fishing, 24/7 security, mini golf, tennis-pickleball-basketball courts, a golf course, a beach with a swimming area, a dog park, multiple hiking trails, a bocce court, an indoor pool, shuffleboard, a Clubhouse with a restaurant and bar, and an on-site hotel. Conveniently located just 30 minutes from Deep Creek Lake and Wisp Resort in McHenry, MD, and two hours from Pittsburgh, PA. Call today to discover your happy place and your new mountain escape at Alpine Lake!
MlsNumber: --
ListingId: 10159513


Listing Provided By: BEL-CROSS PROPERTIES, original listing
Phone: (304) 296-7930
Office Phone: (304) 296-7930
Agent Name: AMANDA TRUSLER
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App