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
This is a 11.91 acre parcel of industrial land. This entire parcel is in current use. Buyer is responsible for paying 10% current use tax to the town. There is an additional cost of $4,300/acre recovery charge for offsite improvements previously constructed for the development. Subdivision of this parcel is possible at a price of $180,000 per acre. Broker interest....Read More About This Londonderry NH Real Estate!
MLS # 4643702
Northwood NH $119,900.00 03261 Real Estate
GREAT PRIVATE 31.94 ACRE LOT. IF YOU WANT TO BE SECLUDED AND DO WHAT YOU WANT, THIS IS THE LOT FOR YOU! PLUS YOUR OWN PRIVATE 2 ACRE POND. VERY SPECIAL LOT. LOTS BOUNDARIES ARE MARKED. EASY TO WALK!...Read More About This Northwood NH Real Estate!
MLS # 4704521
Canterbury NH $1,400,000.00 03224 Real Estate
This commercial property lends itself to many possibilities. Can retain as a Pet Resort, day camp and training facility...or property can be easily converted to office space, land can be subdivided, and the bonus of this area is that you can build a residence here while running your business. A great location, only minutes off the highway!...Read More About This Canterbury NH Real Estate!
MLS # 4233034
Hudson NH $179,999.00 03051 Real Estate
Absolutely beautiful subdivision at Hudson's newest Senter Farms Estates! Many lots to choose from, all vary in price, offering large lots, open space, and great views. Stunning property, use your plans or ours. Buyer to pay current use tax....Read More About This Hudson NH Real Estate!
MLS # 4235499
Hudson NH $179,999.00 03051 Real Estate
Absolutely beautiful subdivision at Hudson's newest Senter Farms Estates! Many lots to choose from, all vary in price, offering large lots, open space, and breath taking views. Buyer to pay current use tax.Very unique property-use your plans or ours!...Read More About This Hudson NH Real Estate!
MLS # 4232468
Hudson NH $172,900.00 03051 Real Estate
Absolutely beautiful subdivision at Hudson's newest Senter Farms Estates! Many lots to choose from, all vary in price, offering large lots, open space, and great views. Stunning property, use your plans or ours. Buyer to pay current use tax....Read More About This Hudson NH Real Estate!
MLS # 4704871
Chichester NH $95,000.00 03258 Real Estate
A Rare find .... 1 + or - acres of commercial industrial lots on the very busy NH Rt 4 ( Dover Rd) Chichester NH. This commercial property is literally on one of the best east west roads in the entire state, just short a few miles from US Rt 93, US Rt 106 and US Rt 28. Traffic count is 16,500 + per day!!!! 4 lots available right on Rt 4 or just set back from Rt 4 with fantastic road exposure to t...Read More About This Chichester NH Real Estate!
MLS # 4706849
Merrimack NH $75,000.00 03054 Real Estate
Long term laundromat on busy Daniel Webster Highway for sale! Business is in leased facility. Laundromat owner will seek permission for new owner's assumption of lease. 10 washers, 5 of which are heavy duty, 20 newer dryers. all washer and dryers are coin operated. Plenty of parking in an area with many condos and apartments provide for a great business opportunity....Read More About This Merrimack NH Real Estate!
Looking for something that has water features plus improvements already in place? Unique opportunity for someone needing storage, privacy and waterfront all rolled into one! Nearly 2 acres with waterfront access on the Contoocook River and with significant improvements including 4 car garage which can be separated into storage/workshop,, driveway installed and a tennis court! Existing dock access...Read More About This Concord NH Real Estate!
