SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='T'
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to this beautifully maintained 3-bedroom, 2.5-bath condo in the sought-after Quail Hollow community, offering convenience, comfort, and a great location. Thoughtfully designed for easy living, this home features a first-floor primary bedroom with an en-suite bath and first-floor laundry, making single-level living a breeze. Step into the spacious living room, where a cozy propane fireplace and built-in shelves create a warm and inviting space. Enjoy direct access to your private deck, perfect for relaxing or tending to your garden. Freshly painted and featuring brand-new carpets throughout, this home is truly move-in ready. Ample closet space provides excellent storage, and the one-car garage adds to the convenience. Upstairs, you’ll find two generously sized bedrooms and a full bath, offering flexibility for guests, a home office, or hobbies. Just minutes from downtown Hanover, Dartmouth College, DHMC, and convenient shopping with easy access to public transportation on N Main Street. Enjoy the benefits of a welcoming 55+ community with well-maintained grounds, walking paths, and a vibrant neighborhood atmosphere. One time buy in fee at time of closing, 3/4 of 1% of purchase price. Delayed Showings until Open House Saturday, February 8th 10-12pm Sunday, February 9th 11 - 1pm
Description:Showings begin Saturday 1/18. Open House Sunday 11 am - 2 pm. Located in the conveniently situated Gile Hill community, this spacious, sustainable LEED-certified townhouse is just minutes away from downtown Hanover, Dartmouth Hitchcock Medical Center, and the extensive trails at Boston Lot and Mink Brook Preserve. Offering the largest interior of any design in the development, this three-bedroom, three-bath townhouse blends modern style with unmatched convenience and efficiency. The lowest level features an oversized one-car garage along with a versatile mudroom, gym, playroom, or office space. The main level includes an open-concept kitchen, living, and dining area with bamboo floors, a raised hearth gas fireplace, and access to a private terrace. A bedroom and full bath complete this floor. A skylight-lit stairway leads up to the en-suite primary bedroom, a third bedroom, and a full hall bath. With its clean, modern aesthetic and low-maintenance condominium ownership structure, this home is ideal for any lifestyle. Close to Hanover Schools, the hospital, and Dartmouth College, 19 Granite Lane represents an exceptional opportunity in an incredible location. Showings begin Saturday 1/18. Open House Sunday 11 am - 2 pm
Description:Located in the sought-after Willow Springs community, 1 Willow Spring Circle is a beautifully updated end-unit condo just minutes from downtown Hanover. This two-bedroom, two-bathroom unit features a bright and open layout with gleaming hardwood floors and newer windows for improved energy efficiency. The cozy fireplace in the spacious living room creates a warm and inviting space for relaxation or entertaining. The updated kitchen has sleek countertops, stainless steel appliances, and ample cabinet space, making meal prep easy and enjoyable. The adjoining dining area provides a comfortable setting for everyday meals or hosting guests. Both bathrooms have been tastefully renovated enhancing the home’s overall appeal. The unit has a large, locked storage unit in the lower level that is heated and dry. It is great space for bikes, skis, or any other overflow storage needs. The primary suite includes a private bath, while the large second bedroom is ideal for guests or a home office. A one-car covered parking space adds convenience for parking and storage with plenty of addition parking spaces. Set in a peaceful location with easy access to shopping, dining, and outdoor recreation, this property offers modern updates, comfort, and a prime Hanover location.
Description:An opportunity to purchase a most tastefully renovated home, all with understated elegance!!! From the moment you step into the unit you will appreciate the light, flow of rooms, the many details throughout and the ability for one level living. The efficient kitchen and openness to the dining area welcomes hosts and guests to gather and be filled with joie de vivre!! A lovely, welcoming living room with fireplace flanked by well-crafted built-ins sets the stage to enjoy the rest of the evening. Once again, the primary bedroom was well thought out and the ensuite bathroom is special with double sinks, oversized shower, radiant floor and even a heated towel rack. An additional advantage on this level is a three-quarter bathroom, a laundry area that includes a folding table and hidden ironing board and an office/study at the end of the hallway. The upper level affords a bedroom with ensuite bathroom, privacy and quiet space for your guests. Not finished yet!! The spacious and nicely renovated lower level features a large family room, bedroom with ensuite bathroom and office. Other features: the former screened porch off the dining area has been remodeled into a den/study/reading area with cool wallpaper; the lower level is walk out where there is an area to dine in the summer, newer boiler, AC throughout, storage, cedar closet and a one car garage with ample space for shelves or bikes. This 55 and over community is central to all the amenities in the Upper Valley.