SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Privately situated on 6 peaceful acres near Crystal Lake, this spacious Ranch offers the perfect blend of comfort, privacy, and versatility with a separate in-law/accessory apartment. The open-concept main living area features gorgeous hardwood floors and a seamless flow from the kitchen to the dining area and expansive living room. Step outside to the impressive 40' x 12' deck overlooking the private backyard—an ideal setting for entertaining or relaxing while enjoying the natural surroundings. The oversized living room is anchored by a cozy wood stove with a classic brick chimney, providing warmth and ambiance during the colder months. Down the hall, you'll find the main full bath and three bedrooms, including a spacious primary suite with a recently updated tiled bath. The accessory apartment offers excellent flexibility for extended family, guests, or potential rental income. It was rented for $1,750 per month! It features an open-concept kitchen and living area, a full bath, and a loft bedroom with closet space as well as access to the attic for additional storage. The walkout lower level offers endless possibilities for future expansion, with plenty of room for a family room, gym or workshop. The public boat launch is close by with plenty of parking space for your truck & trailer while you enjoy all that Crystal Lake has to offer; fishing, boating, kayaking and swimming at the sand bar. Enjoy snowmobiling, hiking and bike riding throughout the nearby trails.
Description:Your opportunity to live where you work! This 2-bedroom home features a two-car garage and sits on 8 acres, complete with a fully functional indoor kennel (built in 2003) and additional outdoor kennel space. Plenty of open area for running and exercise. Take advantage of nearby scenic Smith Pond trail for a true recreational delight!. Located just off of exit 15 off I-89, close to skiing and the Upper Valley!
Description:Post Pond Possibilities!! One of a few number of lots that have pond access. Don't miss the opportunity to be a Post Pond resident. 11 Acres and a Camp/Cottage with rustic character overlooks the pond in a wooded setting. Most of the land already in current use and building envelope is ready for your personal touches. Septic installed new in 2007 with power and a drilled well onsite. Outbuildings for boat storage and more. Come and imagine life on the pond minutes from Hanover, Dartmouth College, and DHMC. All the amenities of the Upper Valley minutes away from your quiet access to nature and wooded serenity.
Description:Own a piece of Plainfield's history with this picturesque 1870 brick cape on almost 10 acres. Enjoy the large, open fields with lovely river frontage, walking trails, mountain views, and a forest grove for a true outdoor sanctuary. Once inside the home, you'll love the flexible floor plan with 3 bedrooms, an office/study, living room, and cozy den. The renovated kitchen opens to the spacious dining area for ease of entertaining. Updated tiled bath. Plenty of natural light, original wide pine & hardwood floors, and delightful details in every room. Automatic generator for peace of mind. With the warmer weather, bask in the serenity of the screened porch. Two-car detached garage and storage/gardening shed. Beautiful stone patio and lush perennials, fruit trees, and berry bushes. This lovely home offers loads of charm and character balanced with tasteful updates and outstanding owner care.
Description:A rare opportunity to create an extraordinary lakefront retreat at the coveted "head of the beach" location. Set on .3 acres with a prized sandy-bottom shoreline and breathtaking panoramic water views, this exceptional waterfront parcel offers the foundation for a truly special legacy property. The existing cottage is a tear-down, allowing a seamless path toward new construction with many key approvals already secured, including Shoreland Impact Permit, state dock approval, and new home plans designed in conformance with shoreland requirements, including proposed site plan and septic design. An increasingly rare offering combining spectacular views, coveted waterfront frontage, and the convenience of significant pre-development work already completed.
Description:This charming saltbox style home has 3 bedrooms and 3 bathrooms, plus a finished office or play space above the spacious garage. With a redone kitchen and updated bathrooms there is a 1.5+/-ac yard with plenty of room for playing or gardening. A full basement provides a family room as well as ample space for storage. And the oversized heated garage currently houses 2 cars and a gym. A great house in a delightful community.
Description:Set back from the road and with 11+/- acres, this updated historic home has 3 bedrooms and 3 baths. An original part of the Cornish Art Colony, built in 1886, the home has an apartment which can easily become a guest wing or rental if you wish. Light and bright with a lovely open floor plan there are views of Mt. Ascutney and the Connecticut River. Updated kitchen, baths, floors and heating system. Close to St. Gaudens National Park and the Cornish State Wildlife Management area. Really charming! OPEN HOUSE Sunday, June 28th, 1-3.
Description:Charming 1949 lakeside ranch offers a rare blend of classic character just steps from Crystal Lake—known for its clear waters, recreation, and year-round beauty. Set directly across the street from the lake, the home is paired with an additional attached parcel on the water. Inside, the home features three bedrooms and two baths, with a warm, functional layout that reflects its mid-century roots. A partially finished basement adds valuable flexible space—ideal for a family room, home office, or guest overflow. Large windows invite in natural light, while the setting provides stunning lake views and a peaceful atmosphere.
Description:Timeless 1820 Brick Colonial on 15 Stunning Acres. Step back in time while enjoying modern comfort in this beautifully maintained 1820 classic brick Colonial set on 15 picturesque acres of open fields. Rich with historic charm and character, this exceptional property features wood floors, elegant crown molding, and multiple fireplaces that create warmth and sophistication throughout. The spacious main home offers gracious living areas filled with natural light and period details, perfect for gathering and entertaining. A separate in-law apartment provides flexibility for extended family, guests, rental income, or a private home office. Outside, the possibilities are endless with a large traditional barn, two separate garages, and expansive open land ideal for gardening, horses, farming, recreation, or simply enjoying the beauty and privacy of the countryside. This rare offering combines historic craftsmanship, versatile living space, and breathtaking acreage—a property with endless potential and timeless appeal.
Description:Experience the timeless charm of this classic 1903 Victorian with a beautiful carriage shed, ideally situated on a generous half-acre lot just minutes from the heart of Enfield and a short drive to Mascoma Lake. Rich in character and architectural detail, this four-bedroom, one-and-a-half-bath home has beautiful wood floors throughout, soaring ceilings, an elegant staircase with a stunning stained-glass window, a living room with fireplace and a formal dining room perfect for entertaining. The third floor offers unique additional space featuring beautiful wainscoted ceiling and walls and period charm. Outside, a carriage shed provides endless possibilities for storage, hobbies, or workshop space or convert into living space! Conveniently located walking distance to town for coffee or dinner or hop on the rail trail just a block away! Don't miss the grand home! Super location just 20 mins to Dartmouth Health! Showings by appointment.