SELECT Id FROM new_searchtable
where town = 'Lebanon' and state='NH' and (type = 'R' or type ='O')
and (createtime >='2024-05-05 20:34:21') and (createtime >='2024-05-05 20:34:21')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Lebanon NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:A masterpiece of modern luxury, 24 Apple Blossom is sited on a picturesque neighborhood road lined with mature trees and landscaped sidewalks. The interior sparkles with sleek aesthetic, high-end finishes, and sprawling light-filled, open-concept designed to impress and to elevate your spirit. A grand stone fireplace commands attention in the main living area, with vaulted cathedral ceiling, a perfect centerpiece for gatherings or quiet fireside moments. The living and dining areas seamlessly merge with the gourmet kitchen, complete with a professional-grade range, custom island, and chic brass fixtures. A wine bar, tempered wine refrigerator, and refrigerated drawers pull the party together with ease. One-level living is complete with primary ensuite, and the lavish bathroom has marble floors, a soaking tub, and double vanity. A bonus room off the main living space offers versatility as an office, den, or fourth bedroom. The 4-season sunroom - a zen paradise - allows direct access to a new jacuzzi and back patio deck as westerly sun highlights this ideal spot for relaxation and entertaining. The upper level includes two generous bedrooms and a full bathroom. Completely renovated in 2020, updates include new plumbing, electrical, mini-splits, radiant heat, and solar panels for a more sustainable lifestyle. Located in the heart of the Upper Valley, this very special home offers a refined retreat with easy access to urban amenities.