SELECT Id FROM new_searchtable
where town = 'Cornish' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Cornish NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:IN THE VILLAGE OF CORNISH FLAT! THIS IS A SPACIOUS FARMHOUSE WITH A COMBINATION OF THE OLD CHARACTER AND THE CONVENIENCE OF THE NEW! WAIT UNTIL YOU SEE THIS INCREDIBLE BRAND NEW DREAM KITCHEN. IT WAS DESIGNED FOR A CHEF WITH ITS QUARTZ COUNTER TOPS, WALK-IN PANTRY, PORCELAIN FLOOR WITH RADIANT HEAT AND LOTS OF MODERN CONVENIENCES. THE RADIANT HEAT IS ALSO IN THE PANTRY AND MUDROOM FLOORS AS WELL AS THE NEW HALF BATH ON THE FIRST FLOOR. THE ATTACHED BARN HAS BEEN NEWLY CONVERTED TO A 2 CAR GARAGE WITH FULL STAIRS TO THE ABOVE STORAGE AREA. THE 7 ROOM FLOOR PLAN CAN BE FLEXIBLE DEPENDING ON YOUR NEEDS. THE LARGE LEVEL LOT HAS A LARGE GARDEN AREA WITH RICH GROWING SOIL AND EVEN INCLUDES THE CHICKEN COOP. THE METAL STANDING SEAM ROOF IS ALSO A BONUS TO APPRECIATE. THESE SELLERS HAVE GIVEN THIS SPECIAL HOME A NEW FACE-LIFT, BUT HAVE LEFT SOME ROOM FOR THE NEW OWNERS TO DO THE FINISHING TOUCHES. THIS IS A SPECIAL HOME IN THE VERY SPECIAL CORNISH COMMUNITY AND FOR THE HIGH SCHOOLERS, YOU EVEN HAVE A CHOICE OF HIGH SCHOOLS. COME QUICK....OR IT WILL BE GONE.