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: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: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.