SELECT 'RESIDENTIAL' AS prop_type,id,agtname,list_price,town,state,medium_photo,mod_date_time,virt_url,remark1,lot_size_acres,zip_code,status FROM IDX_RES_QUEST WHERE (town='Allenstown' OR town='Amherst' OR town='Auburn' OR town='Bedford' OR town='Boscawen' OR town='Bow' OR town='Brookline' OR town='Candia' OR town='Canterbury' OR town='Chester' OR town='Chichester' OR town='Concord' OR town='Contoocook' OR town='Deerfield' OR town='Derry' OR town='Dunbarton' OR town='Epsom' OR town='Goffstown' OR town='Henniker' OR town='Hollis' OR town='Hooksett' OR town='Hopkinton' OR town='Hudson' OR town='Litchfield' OR town='Londonderry' OR town='Loudon' OR town='Manchester' OR town='Merrimack' OR town='Mont Vernon' OR town='Nashua' OR town='New Boston' OR town='Northwood' OR town='Nottingham' OR town='Pelham' OR town='Pembroke' OR town='Penacook' OR town='Raymond' OR town='Salem' OR town='Stratham' OR town='Suncook' OR town='Weare' OR town='Windham' ) AND (Remark1 like '%Waterfront%' OR Remark1 like '%lakefront%' OR Remark1 like '%lake front%' OR Remark1 like '%Water front%') AND state='NH' AND (status='Active' OR status='Under Agreement') UNION SELECT 'MULTI' AS prop_type,id,agtname,list_price,town,state,medium_photo,mod_date_time,virt_url,remark1,lot_size_acres,zip_code,status FROM IDX_MLT_QUEST WHERE (town='Allenstown' OR town='Amherst' OR town='Auburn' OR town='Bedford' OR town='Boscawen' OR town='Bow' OR town='Brookline' OR town='Candia' OR town='Canterbury' OR town='Chester' OR town='Chichester' OR town='Concord' OR town='Contoocook' OR town='Deerfield' OR town='Derry' OR town='Dunbarton' OR town='Epsom' OR town='Goffstown' OR town='Henniker' OR town='Hollis' OR town='Hooksett' OR town='Hopkinton' OR town='Hudson' OR town='Litchfield' OR town='Londonderry' OR town='Loudon' OR town='Manchester' OR town='Merrimack' OR town='Mont Vernon' OR town='Nashua' OR town='New Boston' OR town='Northwood' OR town='Nottingham' OR town='Pelham' OR town='Pembroke' OR town='Penacook' OR town='Raymond' OR town='Salem' OR town='Stratham' OR town='Suncook' OR town='Weare' OR town='Windham' ) AND (Remark1 like '%Waterfront%' OR Remark1 like '%lakefront%' OR Remark1 like '%lake front%' OR Remark1 like '%Water front%') AND state='NH' AND (status='Active' OR status='Under Agreement') UNION SELECT 'COM' AS prop_type,id,agtname,list_price,town,state,medium_photo,mod_date_time,virt_url,remark1,lot_size_acres,zip_code,status FROM IDX_COM_QUEST WHERE (town='Allenstown' OR town='Amherst' OR town='Auburn' OR town='Bedford' OR town='Boscawen' OR town='Bow' OR town='Brookline' OR town='Candia' OR town='Canterbury' OR town='Chester' OR town='Chichester' OR town='Concord' OR town='Contoocook' OR town='Deerfield' OR town='Derry' OR town='Dunbarton' OR town='Epsom' OR town='Goffstown' OR town='Henniker' OR town='Hollis' OR town='Hooksett' OR town='Hopkinton' OR town='Hudson' OR town='Litchfield' OR town='Londonderry' OR town='Loudon' OR town='Manchester' OR town='Merrimack' OR town='Mont Vernon' OR town='Nashua' OR town='New Boston' OR town='Northwood' OR town='Nottingham' OR town='Pelham' OR town='Pembroke' OR town='Penacook' OR town='Raymond' OR town='Salem' OR town='Stratham' OR town='Suncook' OR town='Weare' OR town='Windham' ) AND state='NH' AND (status='Active' OR status='Under Agreement') UNION SELECT 'LAND' AS prop_type,id,agtname,list_price,town,state,medium_photo,mod_date_time,virt_url,remark1,lot_size_acres,zip_code,status FROM IDX_LAND_QUEST WHERE (town='Allenstown' OR town='Amherst' OR town='Auburn' OR town='Bedford' OR town='Boscawen' OR town='Bow' OR town='Brookline' OR town='Candia' OR town='Canterbury' OR town='Chester' OR town='Chichester' OR town='Concord' OR town='Contoocook' OR town='Deerfield' OR town='Derry' OR town='Dunbarton' OR town='Epsom' OR town='Goffstown' OR town='Henniker' OR town='Hollis' OR town='Hooksett' OR town='Hopkinton' OR town='Hudson' OR town='Litchfield' OR town='Londonderry' OR town='Loudon' OR town='Manchester' OR town='Merrimack' OR town='Mont Vernon' OR town='Nashua' OR town='New Boston' OR town='Northwood' OR town='Nottingham' OR town='Pelham' OR town='Pembroke' OR town='Penacook' OR town='Raymond' OR town='Salem' OR town='Stratham' OR town='Suncook' OR town='Weare' OR town='Windham' ) AND state='NH' AND (status='Active' OR status='Under Agreement') UNION SELECT 'RENTAL' AS prop_type,id,agtname,list_price,town,state,medium_photo,mod_date_time,virt_url,remarks1,lot_size_acres,zip_code,status FROM IDX_RENTAL_QUEST WHERE (town='Allenstown' OR town='Amherst' OR town='Auburn' OR town='Bedford' OR town='Boscawen' OR town='Bow' OR town='Brookline' OR town='Candia' OR town='Canterbury' OR town='Chester' OR town='Chichester' OR town='Concord' OR town='Contoocook' OR town='Deerfield' OR town='Derry' OR town='Dunbarton' OR town='Epsom' OR town='Goffstown' OR town='Henniker' OR town='Hollis' OR town='Hooksett' OR town='Hopkinton' OR town='Hudson' OR town='Litchfield' OR town='Londonderry' OR town='Loudon' OR town='Manchester' OR town='Merrimack' OR town='Mont Vernon' OR town='Nashua' OR town='New Boston' OR town='Northwood' OR town='Nottingham' OR town='Pelham' OR town='Pembroke' OR town='Penacook' OR town='Raymond' OR town='Salem' OR town='Stratham' OR town='Suncook' OR town='Weare' OR town='Windham' ) AND state='NH' AND (status='Active' OR status='Under Agreement') order by mod_date_time asc NH Waterfront Properties . New Hampshire Waterfront Properties . Homes // Summerview Real Estate
Commercial 20.48 acre lot with 10,000 square feet of unfinished buildings. Over 2,000 feet of road frontage and the traffic count exceeds 12,000 per day....Read More About This Boscawen NH Real Estate!
MLS # 4668963
Hooksett NH $1,100,000.00 03106 Real Estate
NEAR EXIT 11 RTE 93! LAND ONLY. Ideal area for either residential or commercial uses. Commercial development in progress across the street. Located between Residential Townhouse Development and Tri-town Ice Rink to the north. (Between Bayview Terrace and Cross Rd) Previous farmhouse and out buildings have been demolished. See attached documentation in MLS tab regarding availability of Town water...Read More About This Hooksett NH Real Estate!
MLS # 4053315
Windham NH $165,000.00 03087 Real Estate
Last building lot in desirable Windham neighborhood. All wooded lot with privacy. Substantial set back from nearest neighbors. On a quiet road. Plans available for a proposed choice for what can be built on the site and a builder is available....Read More About This Windham NH Real Estate!
MLS # 4612331
Weare NH $175,000.00 03281 Real Estate
1.152 +/- Acres of Commercial Development Land (Pad Site) for Sale. Currently under development as a self storage facility, this site (Phase II) is available for a variety of retail, medical or office development. Additional land could be available depending on the proposed use as outlined in the attached site plan for additional cost of up to $100,000. The site could have its own curb cut or s...Read More About This Weare NH Real Estate!
MLS # 4671232
Amherst NH $499,000.00 03031 Real Estate
Offered for the first time ever" "Studio 101A"- a fully equipped boutique professional recording studio. With 50 microphones, 48 A/D and D/A channels, and 52 preamps, Studio 101A can easily accommodate individual artists and small groups. The studio has an assortment of diffusion and absorption panels, as well as structural treatments that support a quality recording environment. The space is also...Read More About This Amherst NH Real Estate!
MLS # 4671251
Amherst NH $249,900.00 03031 Real Estate
Two Condominium Units (A-1 and A-2) at Overlook Office Park totaling 2,634 SF. Currently combined into one space, this space can easily be converted back to two units. Currently used as a music recording studio, this space would make a great office or studio space for any business. Space consists of an office room, break room, kitchen, two half bathrooms, an equipment room, and game room. A great...Read More About This Amherst NH Real Estate!
MLS # 4653642
Henniker NH $85,000.00 03242 Real Estate
Lovely rural building site on well-maintained gravel road just 3 miles to delightful Henniker Village with schools, shops restaurants, community activities. Pat's Peak Ski area nearby, as is Mount Sunapee, Lakes, trails. 20 minutes to Concord. Contoocook River offers fishing and white water kayaking. The land parcel offers serenity! Septic with tank and leach field is in place....Read More About This Henniker NH Real Estate!
If you are looking for a private country setting in an established neighborhood of lovely homes, this may be the building site for you. A New England stone wall runs through this land and is perfect landscaping enhancement already in place. A large area of this 5 acres has been cleared for a new home site. Enjoy downhill skiing just minutes away at Pat's Peak, kayaking or fishing on the Contoocook...Read More About This Henniker NH Real Estate!
MLS # 4628485
Nottingham NH $89,900.00 03290 Real Estate
Nice lot with tons of potential.... quiet location with easy access from Boston and to Portsmouth......priced to move.......you are limited only by your imagination!...Read More About This Nottingham NH Real Estate!
