SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and type ='T'
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Experience the perfect blend of privacy, space, and spectacular mountain views in this exceptional freestanding condominium, beautifully situated on 90 acres of common land. Expansive windows fill the home with natural light and frame the stunning surrounding landscape. The main level is designed for both comfortable living and entertaining, featuring an inviting open-concept kitchen with a large center island, eat-in area, abundant cabinetry, and excellent storage. A formal dining room opens to a spacious living room with soaring cathedral ceilings and a fireplace, creating a warm and welcoming gathering space. The first-floor primary ensuite is a true retreat, with a beautiful bath and access to a screened porch—perfect for enjoying the peaceful setting. A bright sunroom offers another wonderful space to relax and take in the views. Upstairs, a second bedroom and full bath are complemented by a versatile loft, ideal for a home office or reading area. The finished lower level provides exceptional additional living space, including a large bedroom, family room, full bath, and extensive storage. Outdoor living is equally inviting, with a generous deck and covered porch overlooking the surrounding landscape. An attached two-car garage provides convenience and ample room for vehicles and recreational equipment. The association also offers a beautiful in-ground pool, providing a wonderful amenity for summer enjoyment. Ideally located just over 20 minutes from Dartmouth Hitchcock Medical Center, this remarkable property offers a rare combination of mountain views, privacy, generous living space, and low-maintenance condominium living.
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:Welcome to this impeccably maintained, bright, and sunny end-unit townhouse located in one of the most desirable areas within the Silent Brook community. This beautifully appointed home is just minutes by car from DHMC, Dartmouth College, and downtown Hanover. The main level features an open-concept kitchen, living area, and separate dining room. The kitchen is equipped with a recently installed Bosch dishwasher, an updated range hood with a built-in microwave that vents outside, updated tile, and granite countertops. The living area features maple hardwood floors, a gas fireplace, and access to a balcony overlooking pristine woods. Upstairs, you'll find two en-suite bedrooms, including the primary bedroom, which has a spacious walk-in shower with updated tile and a large walk-in closet. The laundry closet has new Maytag appliances installed in 2024. The third level offers versatile space; a third bedroom with an en-suite bath, or perhaps an office, den, or media room. The lower level provides additional space for a home office or gym and includes a large walk-in closet. The two-car garage features a finished epoxy floor. Additionally, a new boiler with an on-demand hot water system was installed in 2021. Bonus: a connector trail offers direct access to the Appalachian Trail just behind the home! This property presents a fantastic opportunity to enjoy a convenient “Lock and Leave” lifestyle. Open Houses begin Saturday, May 2 and Sunday, May 3.
Description:Located at sought after Berrill Farms, this beautifully remodeled high-end 4 BR, 2.5 BA condo feels both luxurious and serene. With a first floor primary suite and 2-3 more bedrooms on the lower level, the owner can live a tranquil existence on the main floor with offices and guests on a separate level. The kitchen has great storage and great counter top workspace. Separate pantry. Central air conditioning. Outstandingly pretty private outdoor patio. Attached two car garage. Fabulous! OPEN HOUSE SATURDAY, AUGUST 1, 11AM-1PM