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'%Eagle Ridge' and subdivision like'%Eagle Ridge'
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:Nestled in the serene hills of Lebanon, within the desirable Eagle Ridge neighborhood, this stunning single-level home offers a rare blend of comfort, elegance, and thoughtful design. Step inside to discover an inviting open-concept layout that seamlessly combines everyday functionality with modern style. Refinished hardwood floors flow through the spacious living and dining area, anchored by a striking stone fireplace that adds warmth and character. Natural light pours in through large windows, framing sweeping southwesterly views that can be enjoyed from nearly every room in the house. A bright, dedicated office space is perfect for remote work or quiet study, while the living/dining area transitions beautifully into the brand-new gourmet kitchen. Granite countertops, maple cabinetry with elegant lighting, and modern finishes create a space practical and stylish. The primary suite features dual cedar-lined walk-in closets and direct access to the expansive deck, ideal for morning coffee or sunset views. On the opposite wing of the home, you'll find two additional bedrooms and a full bath, offering privacy and flexibility for family or guests. This northern wing also includes a generous laundry room, convenient half bath, and mudroom that connects to the oversized three-car garage, perfect for vehicles, hobbies, and storage. Additional highlights include radiant floor heating throughout and an immense, unfinished walkout basement that shares the home’s incredible views.