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','usahud','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 = 'usahud', 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','usahud','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 = 'usahud', 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','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
North Carolina (NC) Foreclosure Listings
|
Henderson (County)
| Zirconia, North Carolina
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Zirconia, Henderson (County), North Carolina
Displaying 1 to 10 of 30 Properties (0 foreclosures)
Keller Williams Realty Mountain Partners
$95,000
--
bd /
0
ba /
--
sqft
242 Black Bear Ridge Trail
Zirconia
,
North Carolina
28790
Cliffs Realty Sales SC, LLC
$899,000
3
bd /
2
ba /
--
sqft
107 Spruce Lane
Zirconia
,
North Carolina
28790
Carolina Mountain Sales
$89,000
--
bd /
0
ba /
--
sqft
135 Corbin Mountain Road
Zirconia
,
North Carolina
28790
Mountain Oak Properties
$799,900
3
bd /
2
ba /
2,000
sqft
1 North Pointe Drive
Zirconia
,
North Carolina
28790
Cliffs Realty Sales SC, LLC
$795,000
--
bd /
0
ba /
--
sqft
Peaceful Night Trail
Zirconia
,
North Carolina
28790
RE/MAX Executive
$75,000
--
bd /
0
ba /
--
sqft
(lot 92) Corbin Mountain Road
Zirconia
,
North Carolina
28790
Cliffs Realty Sales SC, LLC
$749,000
--
bd /
0
ba /
--
sqft
246 Bella Vista Court
Zirconia
,
North Carolina
28790
Mark White And Associates
$69,600
--
bd /
0
ba /
--
sqft
0 Angel View Lane
Zirconia
,
North Carolina
28790
Cliffs Realty Sales SC, LLC
$695,000
--
bd /
0
ba /
--
sqft
260 Bella Vista Court
Zirconia
,
North Carolina
28790
Cliffs Realty Sales SC, LLC
$69,000
--
bd /
0
ba /
--
sqft
Lot 18 Panther Mountain Road
Zirconia
,
North Carolina
28790
«
‹
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
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','usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Cameron Kennedy
ASCII
The Ambition Group Realty - Brokered by eXp
work
Call Today!
:
(828) 338-8606
I'm interested in properties in HENDERSON (COUNTY), NC
1840497
1840497
0
Contact Me
USHUD.com on the Go!