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 = 3120 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 3120 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 3120 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;

260 Milan Hill Road
Milan, NH 03588
Matthew Martel with RE/MAX Northern Edge Realty LLC, original listing - (603) 752-0003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $480,000
Beds: 3
Baths: Full: 1, ½: 2
Status: Active
SqFt: 3672 Square Feet
Agency: RE/MAX Northern Edge Realty LLC
Agency Phone: (603) 752-0003

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1955
Notes: Welcome to this wonderful 12.5-acre property featuring a spacious 3-bedroom, 3-bath home perfect for both relaxation and adventure. This inviting residence includes one full bath and two half baths, ensuring ample convenience for family and guests. As you approach the home, you'll be greeted by a lovely front porch, ideal for enjoying your morning coffee or evening sunsets. Step inside to discover a bright sunroom that fills the space with natural light, along with a functional mudroom that adds practicality to your daily routine. The newly remodeled kitchen is a chef's dream, complete with all appliances included, making it ready for culinary delights. The spacious living room boasts a warm gas fireplace, perfect for cozy gatherings, while the separate dining room provides an elegant setting for meals. Throughout the home, you'll find beautiful hardwood and parquet floors, along with plenty of storage and closet space to accommodate all your needs. The property features a full basement that includes two extra bonus rooms, providing versatile space for a home office, gym, or playroom. A wood stove in the basement adds warmth and charm, along with even more storage options. Enjoy the convenience of an attached garage and a detached two-car garage with a loft above, offering additional storage or workspace. The property also includes outbuildings, ideal for hobbies or extra storage. With its expansive grounds, this property would make a great horse or animal property.
MlsNumber: --
ListingId: 5016947


Listing Provided By: RE/MAX Northern Edge Realty LLC, original listing
Phone: (603) 723-0521
Office Phone: (603) 752-0003
Agent Name: Matthew Martel
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