SELECT Id FROM new_searchtable
where (town like 'Grantham' or Locale like 'Eastman%') and type ='T'
and subdivision like'%South Cove Heights' and subdivision like'%South Cove Heights'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Grantham Eastman NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Eastman Condo End Unit near South Cove Activity Center and walking trails to many Eastman amenities. Featuring a living area with cathedral ceiling, wood burning fireplace with a lovely brick hearth, and a slider to the back deck. Continue around the fireplace to the dining area with large windows. Then it’s on to the kitchen on the backside of the fireplace, allowing for one wall of exposed brick. A conveniently situated bedroom and bathroom complete the main level. The primary bedroom with bathroom is located on the upper level and includes a walk-in closet. The loft would make a great office or sitting area. For even more space, the finished walkout lower level has a family room/rec room with a wood stove. You’ll also find the 3rd bedroom, 3rd bathroom and laundry on the lower level. Enjoy lake activities, golf, tennis, pickleball, cross-country skiing, snowshoeing, an indoor pool, fitness center and more in the four-season Eastman Community. Easy access to I-89 for a short commute throughout the Dartmouth - Lake Sunapee Region.