Title Page Background
HFQUERY 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 = 2818 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2818 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2818 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

523 Campbell Street
Hartford, VT 05001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $478,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1842
Agency: keller williams coastal realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1979
Notes: Memorial Day price change! Gorgeous views from this wonderfully updated home on the hill! Set on 1.12 gently rolling acres of woods and open fields looking SW to the White River Valley and Mt Ascutney. Located five minutes from White River Junction restaurants, shops and Amtrak station, ten minutes to Dartmouth College and West Lebanon box stores and 15 minutes to DHMC. Convenient Boston/airport access through the Dartmouth Coach. Extensive upgrades, including; owned solar rooftop array ($335 in electric costs for the last year!), new architectural shingle roof, (13) Marvin windows, beautiful high quality kitchen with all new appliances, ext/int paint, three mini splits and much more. Large primary bedroom was a 2003 addition. Three bedrooms, full bath, living room and kitchen on the main level and a nice finished room, ¾ bath/laundry, a neat one car garage and abundant unfinished full height space in the lower level. The large open concept living room and kitchen have cherry hardwood floors and a large wood stove to keep your gathering space warm and inviting. The hardwood continues into the spacious primary bedroom, with its large walk in closet. The exterior space has a well-sized covered porch, a rear patio with a large pergola (that can be open or closed to keep you dry while grilling!) and a spacious raised front patio to take in the views from the front entry. Easy to show. Do not miss seeing this elegant upgraded home, it will not last at the new price!
MlsNumber: 4992750


Listing Provided By: keller williams coastal realty, original listing
Name: keller williams coastal realty
Phone: (603) 610-8500
Office Name: KW Coastal and Lakes & Mountains Realty/Hanov
Office Phone: (603) 610-8500
Agent Name: Mark Roden
Disclaimer: Copyright © 2024 PrimeMLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App