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)
| Fletcher, North Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Fletcher, Henderson (County), North Carolina
Displaying 1 to 10 of 63 Properties (0 foreclosures)
Redfin Corporation
$974,900
3
bd /
3
ba /
3,601
sqft
353 Olivet Lane
Fletcher
,
North Carolina
28732
Redfin Corporation
$785,000
4
bd /
2
ba /
3,166
sqft
23 Meadow Brook Drive
Fletcher
,
North Carolina
28732
LPT Realty LLC
$774,740
3
bd /
3
ba /
2,576
sqft
741 Flynn Branch Road
Fletcher
,
North Carolina
28732
EXP Realty LLC
$675,000
3
bd /
3
ba /
2,742
sqft
23 White Pine Circle
Fletcher
,
North Carolina
28732
Covestar Investment Realty
$625,000
--
bd /
0
ba /
--
sqft
29 Fontaine Valley Drive
Fletcher
,
North Carolina
28732
Keller Williams Elite Realty
$610,000
4
bd /
3
ba /
2,861
sqft
197 Roanoke Road
Fletcher
,
North Carolina
28732
Keller Williams Professionals
$595,000
3
bd /
2
ba /
2,632
sqft
6 Claru Ridge None
Fletcher
,
North Carolina
28732
Redfin Corporation
$560,000
4
bd /
3
ba /
2,379
sqft
167 New River Drive
Fletcher
,
North Carolina
28732
Keller Williams Professionals
$479,900
4
bd /
2
ba /
1,922
sqft
84 Misty Valley Road
Fletcher
,
North Carolina
28732
Century 21 Hi Alta
$475,000
3
bd /
2
ba /
1,908
sqft
55 Forest Berry Road
Fletcher
,
North Carolina
28732
«
‹
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
fletcher
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!