SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
and subdivision like'%The Seasons by the Chase' and subdivision like'%The Seasons by the Chase'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Exciting opportunity, this home is sure to please! North End colonial conveniently located and only minutes to highway system, downtown Manchester, dining, shopping, SNHU, and grocery stores. Features include: airy open floor plan, this home is saturated with bright natural light, great curb appeal, beautiful maple flooring throughout the first floor living space, 3 generous size bedrooms, 1 1/2 bathrooms, fully applianced kitchen, washer & dryer, 2 car garage under, walkout basement via garage, oil FHA heat, separate oil hot water, irrigation system, central vacuum system, deck off kitchen. Seller is offering $5,000.00 towards buyer's closing costs, prepaids or points at Transfer of Title as an incentive and offset for future driveway replacement and/or any future improvements/updates to home.