SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Immaculately maintained, this charming 3-bedroom colonial boasts meticulous landscaping including a brick patio, rock walls, split-rail fencing, a tranquil waterfall, and breathtaking perennial gardens. Situated in a serene setting, the property is adorned with delightful arbors, butterfly bushes, apple trees, and blueberry bushes visible from the kitchen window. Adding character and utility, two outbuildings offer ample storage space. The inviting great room features a cozy gas fireplace and French doors leading to a secluded deck. The open-concept kitchen, complete with counter seating, seamlessly connects to the spacious dining room overlooking the great room. A convenient first-floor office/den enhances the home's functionality. The luxurious Primary Bedroom includes a walk-in closet, while the second-floor laundry and modern bathrooms with granite countertops provide additional convenience. Newly finished, the 370-square-foot basement boasts a half bath and abundant storage. Nestled in a desirable family neighborhood, this impeccably maintained property offers a tranquil retreat. Schedule your showing today!
Description:Welcome to your dream home! Nestled in the heart of North Manchester, this exquisite Vien's Built 3 Bedroom Home is a testament to modern luxury and comfort. Step into a world of unparalleled elegance, where every detail has been carefully crafted to meet your daily needs. Experience the convenience of one-level living with a spacious 1st Floor Primary Bedroom boasting a luxurious Walk-in Closet. Cathedral Ceilings soar above, creating an airy ambiance that invites relaxation and tranquility. Entertain in style with a generously sized Dining Room, perfect for hosting gatherings and creating lasting memories. Prepare gourmet meals in the chef-inspired kitchen featuring an Oversized Kitchen Island, where culinary creations come to life with ease. Embrace the art of entertaining with an additional finished Bonus Room above the garage, providing ample space for family, friends, and visitors to feel right at home. A convenient bar sink adds a touch of sophistication, ensuring every gathering is a memorable affair. Outside, revel in the beauty of an Easy Maintenance Yard, offering the perfect blend of beauty and simplicity. Don't miss your chance to call this magnificent residence your own. Discover the epitome of luxury living and make it yours today!