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 ='M'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Multi Family Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located in the heart of Lebanon, walking distance to public transportation, shopping, schools, restaurants and next to the rail trail for walking running and biking. Great income generating opportunity with two apartments on the second floor and an established business on the main floor. Only 10 minutes to Dartmouth. Close proximity to interstate 89.
Description:Embrace the vibrant heart of Hanover with this newly renovated duplex on Lebanon St, offering the ultimate in downtown living within walking distance to the CoOp and the bus line. Perfectly situated between Dartmouth College and DHMC, this property boasts a walk-out basement providing extra storage. The first floor unit showcases a contemporary touch with brand new hardwood floors, a renovated kitchen and 3 bedrooms, one with a 3/4 bath. Upstairs, the second floor introduces an additional 2 bedroom apartment with hardwood floors, new kitchen, 2 bedrooms and a bath with private washer and dryer. Take advantage of the prime location and the properties surrounding walking trails and Mink Brook. Welcome to Hanover!