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

334 Arbra Mountain Way
Bostic, NC 28018
Trish Luzzi with Engel & Völkers Foothills Longtown, original listing - (828) 232-4030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,800
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1560 Square Feet
Agency: Engel & Völkers Foothills Longtown
Agency Phone: (828) 584-9999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Other-Single Family Residence
Year Built: 2017
Notes: Your Private Log Cabin Escape Awaits! Welcome to your dream mountain getaway nestled in the heart of Bostic, NC! This stunning 2 Master Suites, 2.5-bathroom, log cabin that sits at the base of YTM with no steep or winding roads on a 1.93 peaceful lot, level, wooded and boasts year-round mountain views. Whether you are looking for a F/T residence, vacation home, or STR investment property, this cabin delivers the charm, space & seclusion you've been searching for. Home solar/battery backup system for green energy & emergency. Insulated throughout to give you all the comfort in a cabin setting. Beautiful gourmet kitchen, built in wine/bar & open concept great for entertaining. Oversized 2 door garage for all your toys. Relax with your coffee on the deck or by the outdoor fire pit to watch the frequent deer sightings which just add to the natural charm. Easy access to Lake Lure, Chimney Rock, Forest City, Tryon, etc. Enjoy the tranquility of nature without sacrificing comfort or style.
MlsNumber: --
ListingId: 4262772


Listing Provided By: Engel & Völkers Foothills Longtown, original listing
Phone: (828) 232-4030
Office Phone: (828) 232-4030
Agent Name: Trish Luzzi
Disclaimer: Copyright © 2025 Engel & Völkers. 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