SPECTACULAR WATERFRONT OASIS....custom-built in 2009 and is a Mediterranean Villa with elevator and a fantastic spiral wrought-iron staircase along with a magnificent crystal chandelier in the soaring marbled 20 ft. FOYER! Formal Entertaining Living Room with a beautiful Dining Room with built-in mahogany cabinetry for china and glass display/storage. Interior Home has 7 bedrooms with 8 bathrooms and a lower-level Studio Apartment for a Housekeeper OR Mother In-Law SUITE (has full kitchen!). Enormous main-level GREAT ROOM has a galley kitchen with wet-bar along with an enclosed Florida Room. ANOTHER top floor spacious Living Space has a Fire Place and Kitchenette for causal lifestyles.... 3 LOWER LEVELS of this HOME includes a 6-Car Garage, Sauna, Wine Cellar, GYM Space, Home Office, Mechanical/Security ROOMS, tons of STORAGE and Commercial PREP Kitchen with steel-door exits to the Backyard OASIS! THE Outdoor Spaces include a well-equipped kitchen, substantial Grill AND Large Rotisserie with plenty of sitting around the Bar or Dining/Lounging on the Terrace. The PRIVATE Backyard also includes a kidney-shaped heated Pool and Hot Tub with plenty of space for Deck Chairs...a green lawn includes a lovely Gazebo. AND FINALLY....there is a 100ft Dock that has a LIFT SYSTEM for at least a 60ft. Boat AND Lifts for 2 Jet Skies!! THE Waterfront Property includes stunning views of the Throgs Neck AND Whitestone BRIDGES!!