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 list_price BETWEEN '150000' AND '250000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome home to this inviting property in the beautiful village of Meriden. Close to KUA and short drive to Lebanon or Claremont for shopping, entertainment, or hospitals. This 924 square feet mobile home has 2 bedrooms, 2 bathrooms, and a dedicated office space, perfect for working from home, hobbies, or guest accommodations, as well as an open concept living room and kitchen. Enjoy year-round comfort with central air conditioning throughout the home. Situated on a desirable corner lot, the property offers added privacy and outdoor space. A peaceful bubbling brook enhances the setting, creating a relaxing backdrop to everyday life. The yard also includes a convenient storage shed, providing extra room for tools, equipment, and seasonal items. Combining comfort, functionality, and natural charm, this property is a wonderful place to call home.
Description:Brand-new 2-bedroom, 2-bath manufactured home located in desirable Currier Park with easy access to Upper Valley amenities. Open-concept layout featuring a modern kitchen with stainless steel appliances, farmhouse sink, and washer/dryer hookups. Located minutes from Lebanon’s amenities, including Dartmouth Health, highway access, restaurants, and shopping. Listing agent is related to Seller.
Description:Welcome home to this brand-new, 2-bedroom, 2-bath manufactured home overlooking Mascoma Lake. The open-concept layout features a modern kitchen with stainless steel appliances, a spacious farmhouse sink, and convenient washer/dryer hookups. Enjoy peaceful lakeside living surrounded by nature, just steps from the scenic rail trail. Located minutes from Lebanon’s amenities, including Dartmouth Health, highway access, restaurants, and shopping.
Description:Immaculately well-kept 3 Bedrooms, 2 Bathrooms home located at Lakeside Cooperative Park in Enfield NH. This beautiful home was purchased brand new in January 2024 and offers the quintessential affordable housing opportunity. A wonderfully designed 3-bedroom, 2 full bathroom home is a very rare fine in today's housing market. All appliances are relatively new and included. The central air condition was added in June of 2024 to keep the home comfortably cool in the summer... The yard of the home is large, fenced in for privacy and on a corner lot. The home is secured to a concrete slab with industry standard tiedowns. A large 20' x 20' deck for gatherings, high efficiency skirting helping to keep under the home warm in winter, cool in summer and a 2-story barn/workshop is included. Conveniently located with easy access to I 89, Dartmouth Hitchcock hospital, Dartmouth College, shopping and other amenities. This Redman home with its unique combination of state-of-the-art manufacturing and high-quality building materials, provides the highest value in housing. They have earned their reputation by constantly delivering more than customers might expect. Make your appointment today.
Description:THE CABIN IN THE WOODS! THIS IS AN ADORABLE COTTAGE SETTING IN THE MOST PEACEFUL LOCATION WITH 440 FEET ON MILL BROOK. THE HOME OVERLOOKS THE BROOK WHICH GIVES IT THE MOST SOOTHING SOUNDS AND THE FEEL OF TOTAL SERENITY. THE HOME HAS ONLY BEEN USED AS A VACATION HOME FOR THE SUMMER MONTHS AND HAS BEEN VERY WELL CARED FOR. I AM CALLING IT A ONE BEDROOM HOME BUT IT DOES HAVE A SEMI FINISHED ATTIC WHICH IS ACCESSED BY A PULL DOWN LADDER. THIS ROOM HAS BEEN USED AS THE GUEST QUARTERS. THERE IS EVEN A HANDY WORKSHOP TO ENJOY. SO, IF YOU ARE LOOKING FOR A LITTLE GET-AWAY PLACE....THIS COULD BE IT. THIS SPECIAL HOME IS REALLY A LITTLE PIECE OF HEAVEN! SELLERS WILL SELL IT FURNISHED OR COMPLETLEY EMPTY.