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 = 'R' or type ='O')
and (bedrooms='2') and (bedrooms='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Bright, modern ranch-style condo in The Falls at Rivers Edge. This single-level home features an open-concept living, dining and kitchen area perfect for everyday living and entertaining, two comfortable bedrooms, two full bathrooms, a private office for remote work, and a handy storage room. Gleaming, contemporary finishes and a fresh décor create a stylish, move-in-ready atmosphere. An attached two-car garage offers generous storage and convenience. The PUD community includes an in-ground pool and quiet, well-maintained grounds, with easy access to Lebanon, Hanover and White River Junction. Perfect for downsizers, professionals, or anyone seeking streamlined, modern living in a desirable setting.
Description:Welcome to this beautifully situated 2 bedroom, 1.5 bath Raised Ranch set on over 3 acres of open lawn and wooded privacy in a peaceful country setting with seasonal views to Mascoma Lake. Offering over 1,800 square feet of comfortable living space, this home combines easy living, natural beauty and plenty of room to enjoy the outdoors. Step inside to a bright, open concept living area filled with natural sunlight. The nicely appointed kitchen offers plenty of workspace with island and flows effortlessly into the dining and living areas, creating an inviting space for everyday living and entertaining. Just outside, the front deck overlooks the front yard providing a wonderful place to enjoy your morning coffee, entertain guests, or simply take in the surrounding landscape. From the deck you can enjoy a seasonal view of Mascoma Lake or travel to the back yard for an extended view of the lake or as part of the Mascoma Height Association enjoy the private access to the lake. All of this and close to the Town of Enfield, Downtown Lebanon and DHMC.
Description:Super location! 2.87 acres of land and a huge barn. This farmhouse has been updated and is ready to welcome it's new owner. Spacious rooms throughout the first floor. Lots of natural light with convenient rooms for office space, first floor laundry, a 3/4 bath, large kitchen, dining and living rooms. The heated front porch makes an awesome Den. Beautiful hardwood floors and a curved wall for some of the old fashion features. Upstairs has 2 bedrooms plus a nursery/office room with a full bath. Also a walk in attic space. The full walkout basement under the home has granite and stone with a concrete floor. The boiler has been updated and newer oil tank. This property has a large yard and plenty of paved parking. There's an oversized detached 2 car garage, an attached garage with direct access to the home and a major plus is the large barn! Do you have a home business or hobbies? This opportunity awaits. Country feel, just outside of downtown and 15-minute commute to DHMC.
Description:This exceptional newly constructed home is ready for a September closing in the Upper Valley's Premier Neighborhood. This Della Style home blends sophisticated design offering 1,600 square feet of beautifully appointed living space in a peaceful setting with local views. Designed for both comfort and elegance, the open floor plan offers hardwood flooring throughout the main level with an abundance of natural light. The kitchen showcases hard marble countertops, soft-close cabinetry with premium finishes, creating a space that's as functional as it is beautiful. Off the kitchen enjoy the gas insert fireplace, vaulted ceiling and morning sun. This home offers 2 bedrooms and 2.5 baths with tiled primary bath and tiled floors as well as quartz counters. Three high-efficiency mini-split systems provide personalized year-round comfort located on the living area and primary bedroom on the main level. The lower level has another mini split with over 1,000sf of finished space with 1/2 bath and sliders to back yard. The 12x12 composite deck off the kitchen has local views west and the covered front porch are both composite for low maintenance and offers additional space to gather. The Rock Ridge Community" offers 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. All interior pictures are from recently built homes.
Description:Rustic Charm, Exceptional Outbuildings & Breathtaking Views! Discover the perfect blend of country living and modern comfort in this inviting 2-bedroom, 2-bath log home. Step inside and be welcomed by a stunning floor-to-ceiling stone fireplace, creating a warm and inviting centerpiece for the spacious living area. The home offers a functional kitchen with ample workspace, a formal dining room ideal for entertaining, and a finished walk-out lower level complete with a dry bar, providing the perfect space for gatherings, recreation, or relaxing. Outside, the possibilities are endless! An impressive 50' x 32' garage with a convenient half bath offers exceptional space for vehicles, equipment, hobbies, or a workshop. Need even more storage? The property also includes a 24' x 40' pole barn, perfect for recreational vehicles, tractors, equipment, or additional storage. Animal enthusiasts will appreciate the small barn with power and water, making it ideal for horses, livestock, or a hobby farm. Whether you're enjoying your morning coffee or unwinding at the end of the day, you'll be captivated by the beautiful mountain views from the covered porch that surround this remarkable property. Offering privacy, versatility, and the charm of log home living, this is a property you'll be proud to call home. MLS#5100878 can be offered as a package
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2 bedrooms plus a bonus room, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts. This is the ideal year-round lakefront paradise.
Description:Experience year-round recreation and lakefront living at this stunning log home on the shores of Crystal Lake. Built in 2014 and set on a level .74-acre lot with 401 feet of private waterfront, this exceptional property offers the perfect blend of rustic elegance, comfort lake living with unforgettable outdoor enjoyment. The spacious main level features a desirable first-floor primary suite with a private bath, creating an ideal retreat after a day on the water. Upstairs, you’ll find an additional bedroom, a dedicated exercise room with deck access and lake views, a stylish full bath, providing comfortable accommodations for family and guests. A detached, heated barn with a half bath offers outstanding flexibility for a studio, hobbies, storage, workshop space, or recreational equipment. Whether you’re boating, swimming, snowmobiling, or simply relaxing by the water, this remarkable Crystal Lake property delivers the ultimate four-season lifestyle.