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 list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Such a charming top floor, end unit with pretty views! Come see this fully renovated 2 bed, 1 full bath condo in popular Lakeview Condo Association perfectly situated with Mascoma Lake beach access on one side and beautiful hiking trails on the other. Tennis, pickleball and an in ground pool make for an active lifestyle right outside your doorstep. Inside, we have an open floor plan with a new open kitchen with granite counters, stainless appliances flows seamlessly into the light filled living room with stunning hand hewn beams which add charm and interest. Also, there is an oversized bedroom, a full bath and stackable washer/dryer. Just off the living room we have a new slider to a new deck to enjoy your morning coffee and take in the views of Mascoma Lake and the local hillside. Lastly we have a huge loft space featuring the second bedroom with plenty of room for an office and good storage in the eaves. Beautiful vinyl plank floors throughtout this unti and a tiled bath. This won't last long - just move right in and enjoy this turnkey space or purchase as an investment - moonthly rentals allowed. Please join me at the Open House on Friday, Oct. 24 from 3-5.
Description:Lake View Condo with beach access just in time for summer. Comfortable, easy living in this 2-3 bedroom condo. Breakfast bar separates the open concept Kitchen/Living room where a sliding door opens up to the patio. Charming loft area could be a third bedroom or office. This unit has upgraded windows and flooring. Lakeview amenities include in-ground pool, tennis courts, gazebo, and a sandy beach on the lake with picnic tables and charcoal grills. Close proximity to I-89. Two hours to Logan airport. Hiking trails in the woodlands behind. Close to town shopping and restaurants. Recent price improvement. Open House Saturday, July 12th 10 am till Noon
Description:Step into a lifestyle of charm and tranquility with this historic 2nd-floor condo, perfectly perched on the picturesque Lyme Common. Imagine sipping your morning coffee on one of two private decks, gazing out over an expansive backyard where wildlife pass by. With wide-plank pine floors, this home whispers stories of a simpler time while offering a thoughtful and functional floor plan. The open living room, generous kitchen, and spacious bedrooms, each with their own deck, provide serene views of nature, while generous closet space and ample wall space for your art collection make it uniquely yours. Imagine not having to get in your car and drive to have a meal in a restaurant (3 local restaurants), or do some banking (2 banks), pick up some last minute items for your meal, or get that ice cream cone (Lyme General Store). You can even pick up some items for that home project (Ace Hardware), or get a book to read at the library. All of this, including the Lyme K-8 school, is within close walking distance. This home offers timeless character and modern livability. From the moment you step inside, you’ll feel the pull of Lyme’s unique magic, a rare opportunity to own a piece of history and craft a peaceful, inspired lifestyle. Select photography has been virtually staged.
Description:A rare find in the Upper Valley: an urban contemporary style condo with one bedroom, one bathroom, and a beautiful view. The building provides an exercise room, a lounge, covered parking, a bike room, elevators and an expansive roof deck. Highly insulated for both noise and energy efficiency, the building has a state of the art ventilation system. Only minutes from the hospital and college. A great one!
Description:Terrific two bedroom, one bathroom condo with an additional library/study, in the coveted The Village at 85 Dartmouth College Highway complex. The setting of this association is a 24 acre parcel with gorgeous landscaping and renovated historical buildings. This second floor unit boasts tons of privacy in a treehouse like setting with sounds of a babbling brook below. Lovely floor plan, natural light, open concept living and dining, new windows, brand new boiler, one car garage. A charming spot conveniently located close to Hanover and Lyme!