SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Homes page 45
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Check out this stunning home in a prime North End neighborhood! It's practically brand new, with exceptional craftsmanship you'll notice at every turn. As soon as you step into the foyer, you're greeted by beautiful Hardwood floors that extend throughout the house, even up the staircase! After a long day, you can kick back and relax by the cozy gas fireplace. You'll absolutely love the gourmet kitchen with its quartz countertops and sleek cabinets. It's perfect for anyone who enjoys cooking, with plenty of space to eat in. The kitchen features stainless steel appliances, tons of cabinets, ample counter space, and a center island. The spacious master suite has a walk-in closet and a tiled shower. The second floor also has two large guest bedrooms. Out back, there's a large concrete patio and a completely fenced-in yard, which is perfect for hosting parties or having a private barbecue. This home is designed for easy living and entertaining. The basement is fully finished and includes an IN-LAW SUITE, ideal for extended family stays or visiting guests. This home is energy-efficient, which means you'll save on utility costs. Located in a fantastic spot, this house is near Derryfield School, Southern New Hampshire University, shopping centers, restaurants, highways, and Livingston Park. Don't miss out on this amazing opportunity!
Description:Amazing opportunity awaits in the highly desirable Woodland Pond neighborhood within the Highland Homes area! This detached condo boasts 5 bedrooms and 4 bathrooms, nestled perfectly on a private corner lot with ample play space and additional room to spare. Adjacent to a blocked-off fire road, it offers excellent biking opportunities and backs up to a serene wooded area. The well-designed floor plan features a spacious Primary suite secluded on the first floor, ideally situated near a versatile room perfect for an office or guest bedroom. Step from the porch into a stunning open-concept living area with a captivating see-through double-sided gas fireplace connecting the living and family rooms. Vaulted ceilings, wood floors, crown moldings, granite countertops, and charming details add character to the one-level living experience. Completing the first floor are 2 more bedrooms, a family bath, laundry, a half bath, an eat-in kitchen, and a dining area. There is over 2000 sq ft of additional living space in the walkout lower level, featuring a newly added large outdoor tiled patio and fenced-in area. This level includes 2 generously sized bedrooms, a full bath, a living room, and a versatile area perfect for a mudroom or office space. This home is bathed in natural light throughout and situated in a fantastic walking neighborhood. Residents can also enjoy the clubhouse amenities, seasonal in-ground pool, theater room, tennis courts, and exercise room.
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.