Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 1929 [1] => HENDERSON (COUNTY) [2] => NC [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1929 LocID: HENDERSON (COUNTY) Region: NC State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1929 Igate: njhud LocID: 1929 Region: HENDERSON (COUNTY) State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
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 = 1929 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1929 [1] => HENDERSON (COUNTY) [2] => NC [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1929 LocID: HENDERSON (COUNTY) Region: NC State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1929 Igate: njhud LocID: 1929 Region: HENDERSON (COUNTY) State: NC Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
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 = 1929 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1929 [1] => HENDERSON (COUNTY) [2] => NC [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1929 LocID: HENDERSON (COUNTY) Region: NC State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1929 Igate: njhud LocID: 1929 Region: HENDERSON (COUNTY) State: NC Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
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 = 1929 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
North Carolina (NC) Foreclosure Listings
|
Henderson (County)
| Hendersonville, North Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hendersonville, Henderson (County), North Carolina
Displaying 1 to 10 of 150 Properties (0 foreclosures)
EXP REALTY LLC
$3,900,000
12
bd /
10
ba /
9,654
sqft
108 S Justice Street
Hendersonville
,
North Carolina
28792
Carolina Cottages
$3,250,000
4
bd /
5
ba /
4,289
sqft
231 N Main Street
Hendersonville
,
North Carolina
28792
Carolina Cottages
$2,499,500
4
bd /
6
ba /
7,248
sqft
58 Ashley Bend Trail
Hendersonville
,
North Carolina
28792
Mosaic Community Lifestyle Realty
$1,690,000
3
bd /
4
ba /
2,848
sqft
23 Thunder Mountain Road
Hendersonville
,
North Carolina
28792
All-Better Properties, Inc. dba RE/MAX Mountain Li
$1,500,000
6
bd /
6
ba /
7,792
sqft
2399 Pleasant Grove Road
Hendersonville
,
North Carolina
28739
Keller Williams Realty Mountain Partners
$1,350,000
4
bd /
3
ba /
3,232
sqft
163 Northview Drive
Hendersonville
,
North Carolina
28791
Keller Williams Realty Mountain Partners
$1,350,000
5
bd /
4
ba /
4,187
sqft
201 Didrikson Way
Hendersonville
,
North Carolina
28739
Keller Williams Realty Mountain Partners
$1,345,000
5
bd /
6
ba /
5,600
sqft
117 Little Cherokee Ridge
Hendersonville
,
North Carolina
28739
Pinnacle Lifestyle Realty
$1,250,000
3
bd /
4
ba /
2,563
sqft
3146 Hebron Road
Hendersonville
,
North Carolina
28739
Apple Country Realty LLC
$1,089,000
3
bd /
3
ba /
3,048
sqft
119 Lucky Dog Lane
Hendersonville
,
North Carolina
28792
«
‹
1
2
3
›
»
Cities In HENDERSON (COUNTY), NC
Bat Cave
Dana
East Flat Rock
Edneyville
Etowah
Flat Rock
Fletcher
Gerton
Hendersonville
Horse Shoe
Mills River
Mountain Home
Naples
Tuxedo
Zirconia
hendersonville
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => henderson-county [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: henderson-county State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: henderson-county State: NC 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 = 1929 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Ann Ferguson
ASCII
Ferguson Real Estate & Associates
work
Call Today!
:
(828) 290-6676
I'm interested in properties in HENDERSON (COUNTY), NC
1842025
1842025
0
Contact Me
USHUD.com on the Go!