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 subdivision like'%The Falls' and subdivision like'%The Falls'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:One of the most desirable locations in the Falls at Rivers Edge! Sited at the end of the dead end road, this well-maintained home offers comfortable living with the convenience of a primary living space on the main level and additional rooms upstairs for guests or extended family. The sun-filled living room features hardwood flooring, a propane fireplace framed by built-in bookcases, and expansive windows that bring in abundant natural light while showcasing views of the private yard and striking natural ledge. The kitchen is both functional and inviting with granite countertops and flows easily to the dining and living areas. The spacious first-floor primary suite includes a large en suite bath and two walk-in closets. A dedicated office/study and half bath complete the main level. Upstairs, guests will appreciate their own private retreat with a loft area, bedroom and bathroom. Additional features include central air conditioning, hardwood floors in the main living spaces, a propane fireplace, granite countertops in the kitchen, and a roof that is approximately five years old. Recent improvements include a Trex deck with railings and new slider to the back deck, fresh interior paint throughout, new carpet, new gutters, new storm door, updated window treatments, new dishwasher, microwave and washer, new tile in two bathrooms. Ideally located near Dartmouth Hitchcock Medical Center, Dartmouth College, Boston Lot for hiking, shopping, restaurants and major highways.