SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Manchester NH Homes page 55
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Looking for a .60-acre buildable lot in Manchester? Purchase this classic 1910 New Englander and subdivide your property. With 153 feet of street frontage the property owner by right can create a second buildable lot. Or simply enjoy the property as is by experiencing original flooring and millwork throughout this 4-bedroom classic. Wide pine boards, oak hardwoods and many other original features make this a hard-to-find property. There is a 1st floor bed room option and a rear private staircase for direct access from the kitchen to the primary bedroom. Other design features include a wraparound front porch, back porch, and stained-glass window on 2nd floor entry foyer. Set back significantly from Brown Ave on a 1.25-acre parcel that offers mature landscaping, a detached garage/shed combination, basketball sport court and plenty of room for additional outside amenities. Showings will begin at the open houses on Saturday 8/10 and Sunday 8/11.