SELECT Id FROM new_searchtable
where town = 'New London' and state='NH' and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
New London NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to The Seasons - Premiere home with a magnificent setting and private location at the top of a hill overlooking the community. This 4,000sf home features 4 bedrooms, 4 1/2 baths, and finished 2 car garage with storage above. The kitchen includes a breakfast nook, granite counter tops and access to a spacious screen porch. The first floor consists of the primary bedroom suite, living room with vaulted ceiling and propane fireplace, dining room having access to a deck and study w/built-in shelving. The 2nd floor has 2 guest bedrooms each with a bath, loft over looking the living room and storage room. The walkout lower level has a family room, office, guest bedroom, bath, exercise area, laundry room and mechanical/storage area. There are gorgeous wood floors on the 1st & 2nd floor and central AC. This home has a private driveway and golf cart & portable generator are included. The Buy-in fee is 1% of sales price. Enjoy the conveniences of condominium living, The Seasons is located adjacent to the lush fairways of Lake Sunapee Country Club, a private, Donald Ross designed course. Walk to golf, pool, tennis (by LSCC membership) and dine at Henry's restaurant at the club. Close to Pleasant Lake, Mt. Sunapee, Colby Sawyer College, NL Hospital, shopping, restaurants and easy access to I 89.
Description:Sited on 7.7 acres in New London NH, this stunning "one-of-a-kind" 6 bed, 5 bath contemporary boasts 5000 sq ft of living space. Enjoy breathtaking views from every inch of your private oasis featuring an "in-ground" pool, a hot tub for 8, a large deck for grilling and a romantic fire-pit for gazing at the stars. The interior of the home is a marvel with a clean yet sensuous, modern design. Sold furnished, each room has been meticulously designed with specific contemporary pieces. Ash flooring throughout, warm radiant heat, 2 sensational propane fireplaces, white quartz countertops, multiple cooking spaces, LED lighting, central air-conditioning... the home is efficient and comfortable year round. The dramatic entry foyer offers a majestic 30 foot vaulted space with a catwalk and floor to ceiling glass windows. Off the foyer is the sleek living room, perfect for movie night. The fireplaced formal dining room has unobstructed views of the Vermont mountains. A first floor bedroom/office has an adjacent bath. Upstairs are five gorgeous bedrooms, most with western views of Mount Sunapee. The primary is phenomenal with panoramic views, an en-suite bath with soaking tub and a private sitting area. The third floor features a playroom for the kids. The lower level, with direct access to the three car garage has an infrared sauna, multiple washers and dryers, a kitchenette and game room. A large separate barn is perfect for storage and toys. Delayed Showings until December 9th.