SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to this stunning Colonial home nestled in a quiet cul-de-sac, offering the perfect blend of comfort and convenience. This spacious 4-bedroom, 3-bathroom home features an open concept layout that seamlessly connects the kitchen, living room, and dining room - ideal for both everyday living and entertaining.The master bedroom boasts a generous closet and en-suite bathroom, creating a private retreat within the home. The attached 2-car garage and driveway with space for up to 4 cars. Step outside onto the large deck, perfect for enjoying outdoor meals or simply relaxing in the fresh air. The unfinished walk-out basement offers endless possibilities for customization and additional living space. The backyard features natural shade, creating a peaceful oasis for relaxation and play. This home is conveniently located near schools, shopping malls, and plazas, making it a perfect location for families looking for both tranquility and convenience. Don't miss out on this rare opportunity to make this house your dream home! OPEN HOUSE on Sat 05/18 & Sun 05/19 10:00am - 2:00pm.
Description:THIS IS THE ONE YOU'VE BEEN WAITING FOR! Located on a quiet cul de sac in a fabulous North End location, this meticulously maintained colonial offers a floor plan that provides space for everyone and makes entertaining a breeze. With a 2 minute drive to Route 93, this 4 bed 3 bath residence is a commuters dream. The open kitchen boasts quality cabinetry, granite countertops and updated stainless steel appliances. It is also open to the family room that is bright and airy with skylight windows, a gas fireplace and built in bookshelves. A large formal living room and dining room complete the main level. Upstairs you will find a primary suite that includes a fully tiled primary bathroom with granite vanity and glass door shower stall as well as another 3 spacious bedrooms, 2nd floor laundry and tiled main bathroom. The lower level has an awesome finished space that can be used as a bonus room or gym. Outside, this home has a beautiful paver patio, and fully fenced in backyard with lush green lawn space as well as a large 2 car garage. NOTHING TO DO BUT MOVE IN!! Showings start Thursday 5/16 at NOON.
Description:A spectacular one-of-a-kind home like no other that will take your breath away! Massive contemporary colonial with a touch of ski lodge wrapped in cedar siding making this home a custom masterpiece. Superior in its design, quality, craftsmanship & floor plan, this sprawling home consists of 12 rooms, 6 bedrooms, 3 baths. Hardwood floors throughout 1st floor, stunning all new kitchen w/custom glazed maple cabinetry, imported granite countertops featuring custom chiseled edge, gorgeous copper farmhouse sink, Kohler fixtures, SS appliance. Dining room, large living room with napoleon wood stove insert, huge sunken family room, large den/multi function, 3 bedrooms complete the 1st level. 2nd level consists of the most jaw dropping, enormous primary bedroom w/soaring cathedral ceilings, post & beams, skylights, large walk-in closet, private bath & loft. 2 additional large bedrooms complete the 2nd level. Step outside to your own private park-like sanctuary with wrap around deck leading to a grand oasis with in-ground pool, massive backyard, pool house/gazebo, shed, wood shed, surrounded by cedar fence. Circular driveway, updated baths, 200 amp service, and more. The layout & design of this fantastic home can suit even the fussiest buyer with many needs for large or extended family, and everything in between. Once in a lifetime opportunity to acquire this unique MUST BE SEEN special home, that has a little bit of history. Home has been in the same family for over 45 years.
Description:LOCATION, STYLE & PRICE, THIS ONE IS NICE!! Modern Contemporary style 4 bedroom with 3 levels of finished living space. Located on the Londonderry line and only 5 minutes to exit 5 off 93. This custom home is situated on a corner lot in the Filips Glen development. Home features wrap around composite deck, vaulted ceilings, open concept, finished basement with half bath, spacious pantry, primary bedroom with sitting area and private ensuite featuring a soaking tub and double sinks. 24x24 Garage with elevated ceiling height to accommodate a lift if desired and 220 and 240 electric drop. 3 Zone heating/cooling, SOLAR and so much more...Seller will give a $5000 concession for new paint throughout. ASSUMABLE VA MORTGAGE AT 3.375% INTEREST RATE and in the Green Acre Elementary School district!
Description:Welcome to 2395 Elm Street in Manchester’s historic North End, a large, inviting, colonial home. Entering from the garage or via Lexington Avenue, find a great drop zone with coat closet and washer/dryer area. Proceed ahead into the large kitchen, adorned with cherry cabinetry and quartz countertops. The kitchen also has bar seating, a pantry closet and wall, and large eat-in area overlooking the patio and backyard. It opens to the family room where you will find large windows, built-ins and a gas fireplace, making a great, sun-drenched gathering space for everyone, a place to begin your day or to relax when it is over. The main floor also has a large living room with adjoining dining room. They are a great space for entertaining as the two are open with stately pillars to mark their separation. The first floor also has a newly tiled half bath and a dramatic two-story foyer. Climb the open staircase and be greeted with four bedrooms and two full baths. This level also leads to the large, unfinished space over the garage that can be finished as another bedroom, a playroom, a media room, office or anything else you desire. The possibilities are endless! Back towards the stairs, you find the over-sized primary suite with large walk-in closet, huge bathroom with double vanity, stand-alone shower and jetted tub. Off the master suite there is a sun-filled nook overlooking the foyer to make your very own. Showings begin at the Open House Saturday, June 1st 12:00-3:00.
Description:This unique, mid-century modern style masterpiece is over 6,000 sq. ft. and sits on over 9 lush acres with stunning views of The Piscataqua River. Enjoy peace and quiet in you own private, park like setting. The custom gourmet kitchen features leathered granite, high end SS appliances, a 14 ft. island and breakfast nook with coffee bar surrounded by walls of windows so you can watch the wildlife as you sip your morning coffee. In the center of the enormous family room sits a granite, floor to ceiling wood burning fireplace. The family room also features beautiful woodwork, custom built-ins and vaulted ceilings. Entertain family and friends with a game of pool in the living room or by playing piano. You will love working from home in the spacious office which has a wall of windows and custom granite throughout. There are 2 large en-suite bedrooms on the main level with lots of closet space. The primary bedroom suite is on the 2nd level and has a cozy gas fireplace, wet bar and spa like bathroom. There is a 4th en-suite bedroom on the 2nd level with a walk-in closet and private 3/4 bath. The basement features an amazing wine cellar with water feature, an indoor pool, sauna and bonus room. Outside enjoy the summer in the gunite pool with fountain or relax under the stars in your hot tub. The garage can fit 8+ cars and offers plenty of storage for all your toys. This house is such a unique gem! Don't delay. Private showings only start Sat. May 18th at 10am.