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] => 2815 [1] => RUTLAND [2] => VT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2815 LocID: RUTLAND Region: VT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2815 Igate: njhud LocID: 2815 Region: RUTLAND State: VT 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 = 2815 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2815 [1] => RUTLAND [2] => VT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2815 LocID: RUTLAND Region: VT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2815 Igate: njhud LocID: 2815 Region: RUTLAND State: VT 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 = 2815 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2815 [1] => RUTLAND [2] => VT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2815 LocID: RUTLAND Region: VT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2815 Igate: njhud LocID: 2815 Region: RUTLAND State: VT 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 = 2815 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Vermont (VT) Foreclosure Listings
|
Rutland
| Brandon, Vermont
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Brandon, Rutland, Vermont
Displaying 1 to 10 of 16 Properties (0 foreclosures)
Blue Ridge Real Estate
$99,900
--
bd /
0
ba /
--
sqft
1247 Franklin Street
Brandon
,
Vermont
05733
Rowe Real Estate
$85,000
--
bd /
0
ba /
--
sqft
0 Wood Lane
Brandon
,
Vermont
05733
IPJ Real Estate
$795,000
4
bd /
4
ba /
3,636
sqft
49 Park Street
Brandon
,
Vermont
05733
IPJ Real Estate
$59,000
--
bd /
0
ba /
--
sqft
6 Sunset Drive
Brandon
,
Vermont
05733
Franzoni Real Estate Company
$540,000
5
bd /
3
ba /
2,517
sqft
76 Indian Springs Drive
Brandon
,
Vermont
05733
Alison McCullough Real Estate
$525,000
8
bd /
2
ba /
2,943
sqft
3 Union Street
Brandon
,
Vermont
05733
Rowe Real Estate
$495,000
--
bd /
0
ba /
--
sqft
16 Park Street
Brandon
,
Vermont
05733
Rowe Real Estate
$425,000
--
bd /
0
ba /
--
sqft
25 Rossiter Street
Brandon
,
Vermont
05733
Blue Ridge Real Estate
$39,900
--
bd /
0
ba /
--
sqft
0 Humiston Drive
Brandon
,
Vermont
05733
Rowe Real Estate
$375,000
3
bd /
1
ba /
2,784
sqft
16 River Street
Brandon
,
Vermont
05733
«
‹
1
2
›
»
Cities In RUTLAND, VT
Belmont
Benson
Bomoseen
Brandon
Castleton
Center Rutland
Chittenden
Cuttingsville
Danby
East Poultney
East Wallingford
Fair Haven
Florence
Forest Dale
Hydeville
Killington
Middletown Springs
Mount Holly
North Clarendon
Pawlet
Pittsfield
Pittsford
Poultney
Proctor
Rutland
Wallingford
Wells
West Pawlet
West Rutland
brandon
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => rutland [3] => VT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: rutland State: VT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: rutland State: VT 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 = 2815 AND i.igate IN ('txhud','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 = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Lisa Sargent
ASCII
BHHS Vermont Realty Group/Middlebury
work
Call Today!
:
(802) 349-8880
I'm interested in properties in RUTLAND, VT
1839565
1839565
0
Contact Me
USHUD.com on the Go!