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
Breckenridge is the premier retail plaza on the busy North Broadway strip of Route 28. Situated in North Salem close to the Windham line, this area sees over 20,000 vehicles per day.With a mix of local and regional tenants (including the well respected Coliseum Restaurant), it is an excellent location for your retail, service or office operation.Unit 207/208 is a second floor office unit with exce...Read More About This Salem NH Real Estate!
MLS # 246573
Londonderry NH $895,000.00 03053 Real Estate
10 acres of residentially zoned land. Abuts industrial zone, thus might be able to be rezoned or variance approved for commercial development. Located on Water line and near sewer lines. Great location in Growing Londonderry, NH. Conceptuals available....Read More About This Londonderry NH Real Estate!
MLS # 4341879
Concord NH $235,000.00 03301 Real Estate
Development site located close to I 93. Keewaydin Industrial Park is almost completely built out. This parcel has 4 +/- acres useable. Previous plan shows approximately 30,000sf building....Read More About This Concord NH Real Estate!
MLS # 4498945
Concord NH $599,000.00 03301 Real Estate
Two contiguous lots with 630' total frontage. Surveyor estimates 4 +/- acres are useable. The remainder is steep bluff to the river. Flat, sandy soils, lightly wooded. Third lot available at 262 Sheep Davis. This lot has 200', 0.9+/- acres, water & sewer and lines up with Triangle Park Dr. For Sale at $250,000.Prime Development site across from Target driveway and Steeplegate Mall. RETAIL - OFFICE...Read More About This Concord NH Real Estate!
MLS # 4655114
Canterbury NH $150,000.00 03224 Real Estate
Here is a building lot that will provide privacy yet is only 5 minutes from Rte 93! Wooded with excellent frontage (not further sub-dividable) and offering several good home sites. Take advantage of this opportunity to own a large lot in a wonderful community! Provision against further subdivision. Provision against all-night lighting....Read More About This Canterbury NH Real Estate!
MLS # 4701983
Manchester NH $3,995.00 03102 Real Estate
Large 3500 sq foot home on North Coolidge Ave. 4 bedrooms and 3 baths. Beautiful views of downtown Manchester and the river. Easy access to highways. Available immediately...Read More About This Manchester NH Real Estate!
MLS # 4311374
Canterbury NH $275,000.00 03224 Real Estate
5.10 acre building lot immediately at Exit 18 off Route 93. Engineering has been completed for a 50,000 SF manufacturing building. Outstanding visibility from 93 South. Broker has an interest in this property....Read More About This Canterbury NH Real Estate!
MLS # 4447868
Nashua NH $1,200,000.00 03063 Real Estate
Now Available! 2.027 acres of prime development land on busy Rt 101A/Amherst St. in one of Nashua's busiest retail/commercial routes. Just 2 miles off the highway, this location offers daily traffic counts of 38,000+/- vehicles. With lots of development happening in the area, this is the chance to join in on the growth! Owner is open to potentially sub-dividing the property....Read More About This Nashua NH Real Estate!
MLS # 4509652
Hooksett NH $325,000.00 03106 Real Estate
Two contiguous parcels are included in this offering totaling 1.28 acres of commercial zoned property located on busy Hooksett Turnpike. Each parcel consists of land and single family residence. Both houses need rehab or could be demolished to make room for a larger structure. There are several adjacent mixed use parcels that are available to make for a larger parcel to accomodate a business or re...Read More About This Hooksett NH Real Estate!
MLS # 4455048
Londonderry NH $2,150,000.00 03053 Real Estate
This is a 9.651 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 $210,000 per acre. Subdivision into a smaller parcel is possible at ...Read More About This Londonderry NH Real Estate!
