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 = 'R' or type ='O')
and subdivision like'%Quarry Hill' and subdivision like'%Quarry Hill'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Come see this amazing Quarry Hill unit that stands apart from the rest of the townhomes in the community. This desirable south-facing end unit overlooks a spacious side lawn accented gardens, creating a private and welcoming setting with more windows and natural light! The home features thoughtful upgrades and custom finishes, resulting in a warm and distinctive living space. The sun-filled main level stretches from east to west and showcases hardwood floors, custom Crown Point cabinetry, and a beautifully designed kitchen. An open-concept layout seamlessly connects the kitchen, dining, and living areas, while large windows invite abundant natural light throughout the day. Just off the living room, a private east-facing deck provides the perfect spot to enjoy morning coffee or relax outdoors. Upstairs, the second-floor primary suite offers comfort and privacy, while the top floor includes a second bedroom and full bath. The finished lower level adds exceptional flexibility with a laundry area, a three-quarter bathroom, and additional finished space ideal for a media room, home office, gym, recreation area, or guest overflow. Conveniently located just minutes from DHMC, Centerra Marketplace, the RVC, and downtown Hanover and Lebanon, Quarry Hill combines low-maintenance condominium living with one of the Upper Valley’s most accessible locations. Additional highlights include two assigned parking spaces, nearby Advance Transit access, a multi-use path connecting directly to the DHMC campus, and immediate access to extensive hiking and mountain biking trails.