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] => 1855 [1] => ONEIDA (NORTH) [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1855 LocID: ONEIDA (NORTH) Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1855 Igate: njhud LocID: 1855 Region: ONEIDA (NORTH) State: NY 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 = 1855 AND i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1855 [1] => ONEIDA (NORTH) [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1855 LocID: ONEIDA (NORTH) Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1855 Igate: njhud LocID: 1855 Region: ONEIDA (NORTH) State: NY 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 = 1855 AND i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1855 [1] => ONEIDA (NORTH) [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1855 LocID: ONEIDA (NORTH) Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1855 Igate: njhud LocID: 1855 Region: ONEIDA (NORTH) State: NY 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 = 1855 AND i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Oneida (North)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Oneida (North), New York
Displaying 1 to 10 of 38 Properties (0 foreclosures)
CHRISTMAS AND ASSOCIATES INC
$99,995
--
bd /
0
ba /
--
sqft
1.8a Van Buren Rd
Camden
,
New York
13316
GATEWAY PROPERTIES OF UPSTATE NY INC
$98,500
--
bd /
0
ba /
--
sqft
0 Houlahan Rd 4
Florence
,
New York
13316
Gage Realty
$91,500
4
bd /
2
ba /
2,082
sqft
404 Main Street
Boonville
,
New York
13309
eXp Realty
$89,900
3
bd /
2
ba /
1,300
sqft
8681 Gore Road
Lee
,
New York
13440
518 Realty.Com Inc
$80,000
--
bd /
0
ba /
--
sqft
L13.01 County Route 17
Amboy
,
New York
13316
CHRISTMAS AND ASSOCIATES INC
$79,995
--
bd /
0
ba /
--
sqft
1.9 Van Buren Rd
Camden
,
New York
13316
Keller-Williams Mohawk Valley
$79,900
--
bd /
0
ba /
--
sqft
2 Mcclanathan Ave
Vienna
,
New York
13308
CHRISTMAS AND ASSOCIATES INC
$69,995
--
bd /
0
ba /
--
sqft
1.8 Manley Taylor Rd Ext.
Florence
,
New York
13316
KP COUNTRY REAL ESTATE LLC
$699,000
--
bd /
0
ba /
--
sqft
5841 Old Oneida Road
Rome
,
New York
13440
GATEWAY PROPERTIES OF UPSTATE NY INC
$69,900
--
bd /
0
ba /
--
sqft
0 Mackinnaw & Beaver Int
Remsen
,
New York
13438
«
‹
1
2
3
›
»
Cities In ONEIDA (NORTH), NY
Alder Creek
Ava
Barneveld
Blossvale
Boonville
Bridgewater
Camden
Cassville
Clark Mills
Deansboro
Durhamville
Forestport
Franklin Springs
Hinckley
Holland Patent
Knoxboro
Lee Center
Marcy
Mc Connellsville
New York Mills
Oriskany
Oriskany Falls
Prospect
Remsen
Rome
Sangerfield
Stittville
Taberg
Washington Mills
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => oneida-north [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: oneida-north State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: oneida-north State: NY 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 = 1855 AND i.igate IN ('njhud','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 = 'njhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Bambi Norman
ASCII
R A Wilkes Real Estate LLC
work
Call Today!
:
(315) 225-5181
I'm interested in properties in ONEIDA (NORTH), NY
1839668
1839668
0
Contact Me
USHUD.com on the Go!