Welcome to a truly one of a kind property in an ideal location near Beechwood Shopping Center, a wide variety of restaurants, and just a short distance to Bear Hollow Zoo. This remarkable spot combines character, flexibility, and standout amenities rarely found in one setting. The three story main house is full of unique charm. The main level features a living room with a beautiful stone fireplace, a separate dining room highlighted by a stunning chandelier, and a sunroom overlooking the back patio and in ground pool. The kitchen is cozy with plenty of cabinetry, and offers great potential. A full bathroom completes this level. On the second level, you'll find a spacious great room with a second stone fireplace, ideal for use as a primary bedroom or additional living space. Down the hall is a full bathroom with two separate vanities that leads to a smaller adjoining room perfect for an office, craft room, or flex space. A screened-in porch runs the length of the great room, and a mudroom with a wet bar provides convenient access to the carport. The upper level includes two bedrooms that share a full bathroom, offering comfortable accommodations for family or guests. Across the deck, the guest house/studio apartment features a kitchen, living room, bedroom, and full bathroom. This private space is ideal for guests, extended family, or as a potential income producing rental opportunity. The outdoor spaces truly set this property apart. At the back of the property, you'll find a greenhouse and a dedicated separate office or fitness space, the possibilities for this are endless! There is also a fenced in garden area for those with a green thumb. A koi pond adds charm and ambiance, while the in ground pool is the perfect summer retreat with plenty of space for lounging, floats, and a grill. With multiple structures, flexible living options, and an unbeatable location, this exceptional property offers unmatched potential. Property being sold 'AS IS'.