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 ('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] => 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 ('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] => 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 ('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;
<< Go Back
|
All Foreclosures
|
North Carolina (NC) Foreclosure Listings
|
Henderson (County)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Henderson (County), North Carolina
Displaying 1 to 10 of 280 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
Ivester Jackson Distinctive Properties
$2,399,000
4
bd /
8
ba /
7,124
sqft
124 Cane Creek Ranch Drive
Fletcher
,
North Carolina
28732
The Dwell Realty Group
$2,006,450
4
bd /
4
ba /
2,946
sqft
28 Spruce Lane
Zirconia
,
North Carolina
28790
Carolina Cottages
$1,995,000
3
bd /
4
ba /
4,187
sqft
316 Silent Rise Lane
Flat Rock
,
North Carolina
28731
One Group WNC LLC
$1,800,000
4
bd /
4
ba /
2,982
sqft
344 And 346 River Loop Road
Mills River
,
North Carolina
28759
Mosaic Community Lifestyle Realty
$1,690,000
3
bd /
4
ba /
2,848
sqft
23 Thunder Mountain Road
Hendersonville
,
North Carolina
28792
EXP REALTY LLC
$1,650,000
2
bd /
2
ba /
1,392
sqft
8826 & 8874 Boylston Highway
Mills River
,
North Carolina
28759
Carolina Cottages
$1,600,000
3
bd /
4
ba /
5,754
sqft
103 Ingleside Court
Flat Rock
,
North Carolina
28731
«
‹
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
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 ('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;
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!