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:Custom Built Home With Amazing Finish! Remodeled on the interior and exterior. Prime location for nature enthusiasts who still want to be close to the community. Spectacular site with frontage on the Indian River, private pond, woodlands, & 450' frontage on US Route 4. As you walk into the 48x16 open area with vaulted tongue and groove wood beamed ceilings, you will be awed by the rustic yet contemporary look and feel. For the ease of maintenance, you will find vinyl plank flooring throughout the kitchen/living room. In this space you will find an amazing new kitchen, all new appliances & granite counter top island. The pellet stove warms the home and heart in the expansive area. This home has 2 bdrms and new full bath with laundry on the first floor. Leading to the second floor master bedroom and full bathroom is a bold yet simple design staircase. The master bathroom is equipped with double sink vanity, walk in tile shower overlooking the serene Indian River, plus soaker tub for some luxury and relaxation. This home gives you the feeling of being one with nature but allows you to be only 16 miles to DHMC, steps from the Northern Rail Trail, eateries, modern library, Advance Transit, Health Center, lakes with public access, public recreation parks, and hiking trails. Don't miss out on this totally remodeled home! You will love it! OPEN HOUSE: Saturday, April 5th from 10:30am to 12:30pm and 1pm to 3pm.
Description:19.67 surveyed acres of amazing high land with 1/2 open field, the remainder in unspoiled woods with 2046' road frontage. Custom built 2005 log home that has been owned & loved by the original owners. Beautiful natural wood beamed ceilings, walls, flooring, and 6 panel doors with quality fixtures, loads of kitchen cabinets, granite counters, island, and stainless steel appliances. Kitchen/dining/living area with a woodstove to cozy up to, patio doors for the summer to the new deck, and side door to the garden. First floor bedroom & bath, foyer to the amazing 3 season room for relaxation.2 bedrooms and full bath on the second floor as well as a great room with cathedral ceilings and amazing views. Finished walk out basement would make a great space for an apartment. Buderus multi zone FHW heating system. 2 car garage with storage room above, carport, automatic generator, 20x20 Barn. One of a kind property that will not last long. Move in condition.