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 = 1972 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1972 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1972 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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;

Across 675 Kayla West Drive
Pisgah Forest, NC 28768
Joe Hope with Keller Williams Realty Mountain Partners, original listing - (828) 595-9071

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Keller Williams Realty Mountain Partners
Agency Phone: (828) 290-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Commercial Sale-Manufactured Home
Year Built: 1957
Notes: The Original "PISGAH TRAILER PARK", historic, CIRCA 1957 ... GIS, use: 27 KAYLA WEST DRIVE, from 911 'naming' COMMERCIAL BUSINESS, MOBILE HOME PARK, MONEY MAKER, ZONED; GR4 ... OWNER FINANCING, W/ DETAILS WITH ATTORNEY ... INSTALLED 'SEE CITY WATER AND SEWER AND NATURAL GAS, maybe ENGINEER CAN GET increase DENSITY OR CHANGE UP TO TINY HOMES, I do not know.<br /> ACROSS FROM (675 HVL HWY) TRANS. BAPTIST ASSN. ON US HWY 64W IN THE "NEW" CORRIDOR AREA OF NEW BRIDGE AND ROUND-ABOUTS, THE HISTORICAL ENTRY FOR PISGAH FOREST ... NEW SHOPS, NEW EATS, many businesses all around.<br /> What is maybe the BEST THING???? To an INVESTOR =$$$$$$$ AND ""OWNER FINANCING"", CASH/MONTH.<br /> MAYBE: ???? CHECK THE RATES (LOT RENTS: $700-900/SITE), PRICED OVER $175K, 200K AND MORE FOR TINY HOMES. VERIFY EVERYTHING FIRST. CALL FOR TOUR WITH ME ... ACTUALLY YOU CAN ELECT TO BUY, LEAVE AS IS, COLLECT FROM THE NICEST PEOPLE, SOME FAMILIES HAVE BEEN THERE FOR OVER 25 YEARS. SEE IF THIS IS YOUR OPPORTUNITY.
MlsNumber: --
ListingId: 4223658


Listing Provided By: Keller Williams Realty Mountain Partners, original listing
Phone: (828) 691-4673
Office Phone: (828) 595-9071
Agent Name: Joe Hope
Disclaimer: Copyright © 2025 Canopy 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