Nestled in the heart of Andover and set on a picturesque property with mature landscaping and multiple outbuildings, this one-of-a-kind home is ideal for those seeking space to pursue hobbies, creative endeavors, or a home-based business. The inviting residence is filled with warmth and character, showcasing artistic details and unique design touches that create a welcoming, inspiring atmosphere. Outside, the property's workshop and accessory building provide endless possibilities for artisans, makers, collectors, entrepreneurs, or anyone needing flexible work and storage space. Enjoy the peaceful feel of country living while remaining conveniently located in the center of Andover Borough, with easy access to shopping, dining, schools, and commuter routes. Whether you're dreaming of a live-work lifestyle, a creative retreat, or simply a property with unmatched charm and versatility, 87 Main Street is a truly special place to call home. NEW ROOF, NEW HOT WATER, SEPTIC inspected and updated 2026!