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] => 1848 [1] => LIVINGSTON [2] => NY [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1848 LocID: LIVINGSTON Region: NY State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1848 Igate: njhud LocID: 1848 Region: LIVINGSTON 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 = 1848 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1848 [1] => LIVINGSTON [2] => NY [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1848 LocID: LIVINGSTON Region: NY State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1848 Igate: njhud LocID: 1848 Region: LIVINGSTON 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 = 1848 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1848 [1] => LIVINGSTON [2] => NY [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1848 LocID: LIVINGSTON Region: NY State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1848 Igate: njhud LocID: 1848 Region: LIVINGSTON 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 = 1848 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New York (NY) Foreclosure Listings
|
Livingston
| Geneseo, New York
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Geneseo, Livingston, New York
Displaying 1 to 10 of 14 Properties (0 foreclosures)
RE/MAX Plus
$1,125,000
--
bd /
0
ba /
45,415
sqft
112 Riverside Drive
Geneseo
,
New York
14454
AB Cole Real Estate, Inc.
$1,000,000
3
bd /
2
ba /
--
sqft
4583 Lima Road
Geneseo
,
New York
14454
AB Cole Real Estate, Inc.
$750,900
10
bd /
5
ba /
9,411
sqft
34 Main Street
Geneseo
,
New York
14454
NextHome Brixwood
$545,000
8
bd /
0
ba /
8,856
sqft
72 2nd Street
Geneseo
,
New York
14454
AB Cole Real Estate, Inc.
$449,900
3
bd /
2
ba /
3,123
sqft
43 Westview Crescent
Geneseo
,
New York
14454
AB Cole Real Estate, Inc.
$429,900
7
bd /
3
ba /
2,990
sqft
33 Main Street
Geneseo
,
New York
14454
AB Cole Real Estate, Inc.
$299,000
2
bd /
1
ba /
1,437
sqft
13 Hawthorn Circle
Geneseo
,
New York
14454
NextHome Brixwood
$274,900
7
bd /
2
ba /
2,575
sqft
32 North Street
Geneseo
,
New York
14454
Keller Williams Realty Greater Rochester
$210,000
3
bd /
2
ba /
1,539
sqft
3452 Thorpe Drive
Geneseo
,
New York
14454
AB Cole Real Estate, Inc.
$119,900
4
bd /
2
ba /
2,592
sqft
4525 Lima Road
Geneseo
,
New York
14454
«
‹
1
2
›
»
Cities In LIVINGSTON, NY
Avon
Caledonia
Conesus
Dalton
Dansville
Geneseo
Groveland
Hemlock
Hunt
Lakeville
Leicester
Lima
Livonia
Livonia Center
Mount Morris
Nunda
Piffard
Retsof
Scottsburg
Sonyea
South Lima
Springwater
York
geneseo
USHUD.com on the Go!