SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='T'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Convenient, private and stand alone, this is a delightful unit at the end of the road at Pinewood Village. The inviting entry vestibule leads to a warm and cozy living room and dining room. Abundant windows and skylights provide great light throughout the unit. This level is completed by a spacious kitchen, a ground-floor primary bedroom with an attached bathroom, and a really cool den which backs up to the woods. A gas fireplace in both the living room and den adds to the warmth and coziness of these spaces. And you have a deck, accessible from the living room which also backs up to the woods- and is completely private. Upstairs you have another bathroom and a second very spacious bedroom. Downstairs there is plenty of storage and another bathroom. The unit has a one car garage with a second parking space outside if needed.
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:This spacious four-bedroom, 3.5-bathroom Berrill Farms townhouse condominium features a versatile layout overlooking the pond. The main floor offers sun-filled spaces with hardwood floors, an open-concept living and dining area, a primary bedroom suite, a dedicated office, laundry, and a half bath. Upstairs, the second floor provides two additional bedrooms, a full bathroom, and a cozy socializing/TV area ideal for family or guests. Exceptional bonus space is found on the lower level, which includes a large multipurpose family room with a wood stove, a fourth bedroom, and another full bath. An attached two-car garage completes the property, which is conveniently located close to downtown Hanover, Dartmouth Hitchcock Medical Center, and local trail systems.
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
Description:Nestled in the historic heart of Lyme, NH, the iconic "Barn" (Unit #5) at 14 On the Common is a masterfully reimagined architectural treasure blending 1810s heritage with modern luxury. Conceived as a personal residence and built with a "slow art" philosophy, this one-of-a-kind home showcases uncompromising craftsmanship. Stepping through the glass doors from the Village-side patio crafted of red brick and Bluestone you enter a ground floor where the gourmet kitchen is anchored by a striking VT Verde Antique® Serpentine Stone countertop. Throughout the open concept home, structural timber framing by artisan Adam Miller adapts the historic building into a modern sanctuary. History comes alive through repurposed doors, hardware, and built-in bathroom cabinets saved from the original Judge Churchill estate and beautifully paired with custom bathroom vanities topped with wide-pine boards from Lake Morey. Adjacent to the ground floor's three-quarter bath, a study off the dining room provides flexibility for main-level living. The walls boast an unpainted, highly abrasion-resistant veneer plaster finish, offering a rugged yet sophisticated aesthetic. A true centerpiece, the grand staircase features a custom Greek Revival and Prairie-style railing hand-welded by artist Julian McMillan, complete with symbolic coins embedded in each newel leading to the second level primary ensuite bedroom with dressing room, natural wool carpeting and beautiful wooden floors adding rich texture and warmth throughout. The lower level is designed for maximum functionality, featuring an integrated garage flanked by a welcoming entry foyer on one side and a self-contained studio suite with a three-quarter bath on the other. Outside, an expansive cedar deck with tempered glass railings overlooks the serene beginnings of a private Japanese garden. This is a rare, irreplaceable legacy property designed for distinctive living.