SELECT Id FROM new_searchtable
where town = 'Orange' and state='NH' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Orange NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Tucked up over a quiet country road near Cardigan Mountain State Preserve you will find this lovingly cared for 1900 cape/farmhouse on 5 beautiful acres with a year round stream running through. Relax in the mature forest, organic gardens, under a fruit tree or on the farmers porch and watch the sun set. Plenty of storage in the beautiful barn with attached potting shed, greenhouse and chicken coop. Guest's can stay in the 3 season cottage or in one of the many rooms in the home. Host the holidays in the great room or the finished 4 season enclosed porch on the east side of the home with a beautiful Hearthstone woodstove. Privacy, peace and quiet in this wonderful farmhouse with laundry, a bedroom and a full bath all on the first floor with 3 bedrooms upstairs and a 3/4 bath.