This gorgeous, Grand Mansion on the water is a RARE one-of-a-kind home. Located in the very desirable Indigo Island neighborhood, its charm and beautiful views of the water will instantly have you falling in love! It was once featured in Charleston Home + Design magazine and a television miniseries. The best aspects of this elegant home are the views, the peace and quiet, and the opportunity to walk out of the back door and in a few steps be on your boat enjoying the water. With attention to detail at every step, this home will WOW you! You will love the main and lower level porches, upper level balconies, and sunrooms that all have wide open views of the water. This highly customized home has an excellent open layout with water views from almost every room. In fact, the moment youopen the front door, you can see the gorgeous views of the water. Watching the full moon rise over the water will take your breath away, but is nothing compared to the beautiful sunrise every morning as you enjoy breakfast on your secluded back porch watching bald eagles, pelicans, osprey, blue heron and endless wildlife. Each day you can see boats going by, out for pleasure riding or fishing, kayakers paddling by, jet-skis, even a sailboat zigzagging across the water. On the Fourth of July and New Years Eve, the fireworks display across the water and on all sides is unbelievable! Every inch of this amazing home is packed with so much beauty and countless intricate details that you will feel truly blessed to live here. The home is less than 5 minutes away from I-26, restaurants, a theater, banks, shopping, Roper diagnostics and Emergency Care etc. It is located just less than 9 miles from the Charleston International Airport, 25 miles away from Folly Beach and 23 miles away from Isle of Palms, and just minutes from Historic Downtown Charleston. There is a boat landing located just minutes away (about 3 miles away behind Trident Technical College).Here are just a few of the many unique qualities of the home-Semicircular concrete driveway with inlaid stonework-Grand curved front porch and third floor balcony overlooks the island and the small pond in front of the home- Breathtaking water views from four back porches, a French balcony and four sunrooms- Large beautiful backyard on the water- Custom wooden front entry doors with glass and iron scrollwork- Wide curved exterior front entry concrete staircase- Grand foyer with a gorgeous curved staircase made of wide plank quarter sawn oak and custom wrought iron rails- Wrought iron spiral staircase leading from the kitchen down to the backyard-A Custom two story red onyx marble water feature in the foyer- Custom designed tile floors on all three levels of the home- Custom Inlaid wood flooring in several rooms- Heavy Crown Molding, and custom trim throughout the entire home-Separate front entry on the ground floor-Elevator that goes to all three floors- Sea wall that extends the width of the property- Master bath has a TV and double sink vanity with wall to wall mirror above- Built in cabinets in both master bath walk in closets- one has double glass inserts with beveled glass- Huge Air Jet bath tub in the master bath surrounded by Red Onyx Marble that extends to oversized walk-in shower- Heated tile floors and a heat lamp in the master bathroom- Huge Whirlpool tub in the 3rd floor Beach bathroom that has custom handmade tiles- Massive kitchen with custom granite countertops, and custom cabinets- Custom kitchen 11ft island with double layer granite countertops and unique storage- Massive sliding glass doors in the main living room- Custom Coffered ceilings in the main living room and the 3rd floor living room- Double tray ceilings in the master bedroom with elegant crown molding- Double Barrel Vaulted ceiling right off of the main foyer leading to the study- Custom study that has Brazilian cherry wood floors, rounded walls, massive windows, and custom built in cabinets with glass doors- Tray ceilings with elegant crown molding in the ground floor living room, kitchen, and sunroom- Wide plank quarter sawn oak flooring throughout kitchen, living room, master bedroom and sunroom off of the master bedroom- Many unique hand blown glass lights signed by the artist throughout the home- 19 Custom hand made leaded glass transoms- each one unique with an inscription etched into the glass- Several custom handmade Stained glass windows throughout the home- The kitchen has a built in large window seat with lighted stained glass windows above and two custom built-in hoods above the stove and window- The kitchen also has a custom built-in laundry center that looks like an elegant furniture hutch- Two convection ovens- Induction stovetop- Two farm-style stone sinks in the kitchen and impressive custom granite countertops and granite behind the stove- huge center island has a stone prep sink and locking wine cooler- Six custom vanities with marble tops in the bathrooms throughout the home- Two gorgeous custom designed concrete gas fireplaces- One intricately carved white marble gas fireplace- Custom inlaid tile and custom vanities in all of the six bathrooms- Six large bedrooms and another room that could be a 7th bedroom, office, craft room etc.- Ground floor has a kitchen, craft-room, sunroom, bedroom, inlaid tile floors, and heavy trim and moldings and a living room that opens to a back porch- Custom built in cabinets with glass doors in the main living room, master closet, upstairs bedroom and the home office- Kitchen sunroom and Master bedroom sunroom have double French doors that open onto the back balcony- Independent HVAC on all three floors- The ground floor and third floor also have plumbing hookups for a washer and dryer, so that it would be possible to have a laundry room on all three floors- Gas connection on the main level back porch for a grill and two gas tankless water heaters- Metal roof- Blown-in foam insulation- Central vacuum throughout and in the garage- Garage has built in cabinets and large closets for extra storage- Garage has front and back garage doors for possible drive through to the back yard- Sound system throughout the home- ADT security system- Option to share a dock with the neighbor- Hydrangeas, dogwoods, roses, tea olives, elephant ears, agapanthus, azaleas, blueberry bushes, plum trees and a peach tree- Stone edging around flower beds- Hanahan schools