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='Goffstown' ) 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='Goffstown' ) 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='Goffstown' ) 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='Goffstown' ) 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='Goffstown' ) AND state='NH' AND (status='Active' OR status='Under Agreement') order by mod_date_time asc Goffstown NH Waterfront Properties . Goffstown New Hampshire Waterfront Properties . Goffstown Homes // Summerview Real Estate
RETAIL LAND AT SIGNALIZED INTERSECTION ACROSS FROM IRVING GAS & CONVENIENCE STORE. SINGLE FAMILY 2 STORY HOUSE WITH 1.5 ACRES, GOOD CONDITION, MIXED USE ZONE [COMMERCIAL/ INDUSTRIAL/ FLEX ZONE], COULD BE USED FOR OFFICE, REAL ESTATE, INSURANCE, DOCTOR, BANK, FAST FOOD, DAY CARE, ETC. MAST ROAD IS A HEAVILY TRAVELED STATE ROAD WITH 19K CARS DAILY. ENGINEERING AVAILABLE , SURVEY,TOPO, WETLANDS DELIN...Read More About This Goffstown NH Real Estate!
MLS # 4696482
Goffstown NH $340,000.00 03045 Real Estate
RETAIL LAND AT SIGNALIZED INTERSECTION ACROSS FROM IRVING GAS / CONVENIENCE STORE. SINGLE FAMILY 2 STORY HOUSE WITH 1.5 ACRES, GOOD CONDITION, MIXED USE ZONE [COMMERCIAL/INDUSTRIAL/FLEX ZONE] CAN BE USED FOR REAL ESTATE,INSURANCE, DOCTOR, BANK, FAST FOOD,DAY CARE, ETC. MAST ROAD IS A HEAVILY TRAVELED STATE ROAD WITH 19K CARS DAILY, ENGINEERING SURVEY TOPO, WETLANDS DELINEATED GREAT OPPORTUNITY...Read More About This Goffstown NH Real Estate!
MLS # 4723677
Goffstown NH $1,250.00 03045 Real Estate
Bel-Air Senior Living Apartments are individual, private, independent living apartments located in a separate building that abuts the rehab and nursing home facility. All utilities are included with the monthly rent; all but a landline phone. Apartments have a secured & separate front entrance with intercom that is provided to each apartment. Unit 22 is on the second floor but there is an elevator...Read More About This Goffstown NH Real Estate!
MLS # 4725030
Goffstown NH $1,650.00 03045 Real Estate
Beautiful duplex townhouse on wooded lot. Sit on the rear deck and enjoy the babbling brook. Granite kitchen, 2 1/2 baths, master bedroom with high ceilings, jacuzzi, large his & hers closets. Rare 2-car garage under, deck. SHORT TERM ONLY (UNTIL END OF MARCH) - OWNER INTENDS TO SELL AT END OF TENANCY - NO PETS OF ANY KIND PERMITTED....Read More About This Goffstown NH Real Estate!
MLS # 4727025
Goffstown NH $2,200.00 03045 Real Estate
Three-bedroom unit in a private location. your choice to having first floor or second floor master bedroom. Living room with Cathedral ceiling and fireplace, slider to deck. New flooring all over and freshly painted. Finished walkout basement with washer and dryer, one car garage. absolutely NO DOGS OR CATS. Credit check and income verification is a must. Application fee apply...Read More About This Goffstown NH Real Estate!
MLS # 4726906
Goffstown NH $1,200.00 03102 Real Estate
Great second floor unit in a meticulous two family in the town of Goffstown!! This home is in a great location, close to shopping and highway access. Eat in kitchen with washer and dryer hookup. Heat and hot water included in rent!! Separate entrance in back of home with shared patio for outside enjoyment. Storage shed in yard that you can share with the first floor tenants as well. Storage in bas...Read More About This Goffstown NH Real Estate!
MLS # 4727156
Goffstown NH $1,600.00 03045 Real Estate
Beautifully updated 2 bedroom townhouse in Morgan Estates. Newly updated master bath, stainless steel appliances, finished lower level, new light fixtures with a modern flair and a deck that you can enjoy the sounds of the babbling brook in your backyard. Owner will consider small dog for additional $50/mo. Credit and background check...Read More About This Goffstown NH Real Estate!
MLS # 4684394
Goffstown NH $425,000.00 03045 Real Estate
Amazing opportunity on this 9,500 sq. ft. mixed use space!!! Property consists of 3 Residential units, 2 rented garage bays and a 4,600+ sq.ft owner unit that is waiting for additional income or for someone new to run their business out of!!! Perfect set up for any of the contracting or trade businesses, including, landscaping, plumbing, electrical, drywall, or any other allowed use in this commer...Read More About This Goffstown NH Real Estate!
MLS # 4650805
Goffstown NH $399,000.00 03045 Real Estate
A vacant commercial/industrial flex-zoned development parcel for sale having curb cut access along busy Mast Road (NH Route 114). This land is part of a currently developing commercial/industrial subdivision off Tatro Drive. Topography of site is level to upwardly sloping and lot is serviced by municipal water and sewer. Site estimated to support up to a 10,000+/-SF building. With owner being a co...Read More About This Goffstown NH Real Estate!
MLS # 4685611
Goffstown NH $125,000.00 03045 Real Estate
BEAUTIFUL 6 ACRE WOODED LOT WITH 4 BEDROOM SEPTIC DESIGN READY FOR YOUR HOME PLANS TO START BUILDING. NO WAITING FOR SUBDIVISION APPROVAL. LOTS THIS LARGE AND THIS NICE DON'T LAST...Read More About This Goffstown NH Real Estate!
