Waterfront property prime location with direct water access to gulf of mexico welcome to 518 504 riverside drive, an exceptional executive estate that spans over 2+ acres of pristine property sitting 30 feet above sea level. Enclosed by a solid concrete wall for unmatched security and privacy, this compound features two magnificent homes, perfectly situated atop the scenic kraemer bayou. With no flood zone concerns and no hoa, this property offers both peace of mind and freedom. The main residence boasts 4 bedrooms, 3 full baths, and a half bath. Enjoy breathtaking bayou views from the elegant dining room, spacious family room, and expansive office. Every detail of this home reflects sophistication and comfort. The guest house is an entertainers dream, featuring a sprawling living and entertainment area complete with a sunken wet bar and a commercial style kitchen. With 4 bedrooms, 3. 5 baths, and additional living quarters in the basement, the guest house is perfect for hosting family and friends. Recent updates include new laminate flooring and fresh paint throughout. Water enthusiasts will love the newly updated dock, complete with trex decking, a 10,000 lb lift, power, and water, providing direct access to the gulf. Enjoy inshore fishing from your dock or jump in a fishing kayak and fish the beatiful mangroves that lead right out to the gulf, or maybe enjoy some tubing with the jet skis. The resort style backyard is a true paradise, featuring an infinity pool overlooking the bayou, a newly built party gazebo equipped with natural gas and water along with a fully functional outdoor kitchen. Enjoy the detached swim spa with an air conditioned workout facility and shower stall. The meticulously re landscaped grounds include a sand volleyball court for added fun and recreation. Additional highlights include a whole property 30,000 kw generator, automatic hurricane shutters, and 6 garage spaces accessed via two remote controlled gates leading to a private courtyard. Located in the charming and world famous town of tarpon springs, featuring some of the finest greek restaurants around. This quaint town has so much to offer with antique shops and local breweries along with many art and music festivals happening on any given weekend. The world famous epiphany celebration takes place here in tarpon springs. Elementary/middle and high schools are very close by for convenience. We have 3 amazing beaches very close by along with clearwater only 15 minutes away. Within 30 minutes of tampa and st pete airports. The property is minutes away from the pinellas trail where biking and walking will connect you to several other small downtown areas such as palm harbor and dunedin. Significant price adjustment