HUGE PRICE REDUCTION! WATERFRONT, PRIVATE GATE, NO HOA, and 7.27 ACRES that can be subdivided. Embrace Southern living at its finest. This stunning 6BR/5BA equestrian estate features a beautiful manor house and a charming carriage house nestled on 7.27 picturesque acres, complete with two tranquil ponds. A wrought-iron security gate grants access to the extended driveway, flanked by a classic white ranch fence that guides you to the residence. The remarkable 3461 sqft main house offers an expansive wrap-around front porch, with a fully screened portion, and an inviting sunroom. The entry foyer welcomes you into a double-height, vaulted living room adorned with real hardwood floors, a gas fireplace, and wet bar. The chef's gourmet kitchen is a culinary paradise, boasting high-end stainless steel appliances (Sub-Zero, Thermador), instant hot/cold water dispenser, a built-in ice maker, trash compactor, and more. The kitchen also features a large island with a chef's sink, elegant quartz countertops, double wall ovens, a built-in microwave, walk-in pantry with washer/dryer hookup, an eat-in kitchen area and a separate dining room. Master suite boasts a lavish walk-in closet with custom built-ins and a private, lavish ensuite bath with his/her sinks, garden tub, shower, and private toilet closet. Upstairs bedrooms 2 and 3 share a convenient Jack-and-Jill bathroom.A breezeway leads to a 1920 total sqft detached carriage house featuring a 3-car garage with workshop and half bath down and three bedrooms, a kitchen area, dining area, and full bath above. Step into the backyard oasis, where you'll discover a large brick patio with grill area with sink, a soothing two-tier fountain, several irrigated garden areas, an octagonal gazebo, a 10'x15' shed, and a 8'x10' greenhouse (both with electricity; the greenhouse is also equipped with water). A built-in jacuzzi, outdoor shower, and outdoor washer/drier are on the deck, just outside the master bedroom. Enjoy fishing in two approximate 8-acre ponds. The property is conveniently located off William Few near Columbia Road on a quiet cul-de-sac. Square footage from the county offices .