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 '1000000' AND '99999999'
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:Excellent investment opportunity in a prime Enfield, NH location. This 7-unit apartment building offers recently renovated units, a strong rental history, and excellent visibility along busy US Route 4. Set well back from the road, the property provides ample on-site parking, a detached one-car garage, and easy access for tenants. Tenants enjoy convenient access to restaurants, shopping, churches, Jake's Market, Mascoma Lake beaches and other local amenities. Commuters will appreciate the property's proximity to Routes 4, 4A, and I-89, providing quick access throughout the Upper Valley. Just minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, the VA Medical Center, Lebanon Municipal Airport, local schools, and West Lebanon shopping, this well-maintained multi-family property is ideally positioned to attract and retain tenants. A turnkey opportunity for investors seeking a solid income-producing asset in one of the Upper Valley's most desirable rental markets.
Description:Former Keene Medical Complex Mixed Use, 3 Buildings, 1200 Road Frontage, 7 acres. Corporate headquarters or prime income investment property.(projected cap 10.5%- 12%) 3 buildings with Offices, display and retail showroom, service and repair area, receiving and storage. Additional land with extensive road frontage. Easy potential subdivision for house lots. Potential to subdivide or condo the commercial buildings. On 7 acres, frontage at road grade. Main building - 2 levels. Ground level 3700 sf. office and product display. Good street visibility. 3700 SF lower walk out. Mostly finished. Used for Storage and repair. Post and beam 4800 2 story barn with drive through. Good road visibility. Corner lot location. Repair/storage building 2160 sf. Multiple uses under flexible grandfather use rights. 734 feet on Rt. 120. 300 feet on Storrs Hill Rd. Ample paved parking area. Natural area backs up to Great Brook. No wetlands observed, No flood plain per town map. 2 miles south of center of town. R3 zone. All building in excellent condition and updated.