SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and type ='T'
and subdivision like'%Twin Towers' and subdivision like'%Twin Towers'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:**ACCEPTING BACKUP OFFERS, SHOWINGS BY APPOINTMENT**Located in an historic mill building with architectural character, this two-bedroom, one-bath apartment is sure to please those looking for features like original exposed beams, brick accents, picture windows, and high ceilings. Open concept kitchen and living room, with two separate bedrooms - use one for a home office - and a single bath. Off-street parking for two vehicles is gated and secure. Laundry in building. Condo fee includes heat, central AC, hot water, water, and sewer; owner pays electric and cable. Conveniently located near downtown Manchester, close to shopping, entertainment, I-89 and I-93.