SELECT Id FROM new_searchtable
where (lister_office_name='Granite Northland Associates' ) and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Our Listings NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:"Idlerest Farm" Amazing 47 ac+/- with mostly flat to rolling fields, woodlands, & town paved road with mature maples. Gravel driveway from the front to the back of the fields, views of Cardigan, Tug, and Moosilauke, turn again and you will see Smarts, the Pinnacle, and Moose Mountain. Cell tower with service. This property has been in the same family for over 100 years and around 2000 the 1800's farmhouse was remodeled with a metal roof, vinyl siding, replacements windows, insulation, floor joists, state approved septic, drilled well, a FHW heating system, new plumbing, wiring, and automatic generator system. Sun filled rooms with an expansive eat in kitchen, living room, music room, mudroom, and full bath on the first floor and 2 bedrooms, guest room, and a 3/4 bath on the second floor. Attached 60x17 ell section for a recreation, hobby area, and storage. Full basement with walk out door to the attached 4 bay garage. Enjoy all the community has to offer with the Northern Rail Trail, Hiking & Biking Trails, Farmer's Market, Modern Library, area lakes/ponds with public access, and Modern Health Center. Convenient travel time to Dartmouth College, VA & Dartmouth Medical Facility.
Description:180 degree views & 14 acres+/- of privacy with your own dock at the Edge of Canaan Street Lake. Stroll along the nature trails from the house to water's edge. Built in 2004 with recent updates of new roof shingles, stone patio & fire pit, full house automatic generator, refinished hardwood floors, updated kitchen with granite counter tops, rear deck with retractable awning, and re-surfaced driveway. Open area kitchen/living area with sliding door leads to the rear deck, yard firepit, and trail to the private dock, formal dining room could be a first floor bedroom, 1/2 bath/laundry, mudroom/enclosed porch with direct entry to the 2 car garage. Primary bedroom with walk in closet & full bath, 2 additional bedrooms with closets, and an office on the second floor. Separate storage shed, pull down in garage for storage above, & 12x40 Shelter Logic. Convenient travel to Dartmouth, the Medical Facility, Dartmouth Skiway, I-89,I-91 & I-93. Enjoy all Canaan has to offer with a modern Library, Farmer's market, Canaan Meeting House with summer readings, Medical Facility, restaurants, and Northern Rail Trail for recreation.