Save to Favorites
Print
Share
PRICE $3,295,000 dsIDX morgage calculator
BEDS 5
BATHS 6
HOME SIZE 8,003 sqft
LOT SIZE 1.56 ac

Stunning lakefront retreat offering unparalleled luxury and modern upgrades! Step into elegance with 10-foot ceilings, Marfil Marble floors accented by Emerald Pearl granite, and custom built-in cabinets throughout. The freshly painted main floor features a new double front door, upscale lighting, and an office with custom cabinetry. The primary suite impresses with a trey ceiling, crystal chandelier, surround sound, complemented by a fully remodeled bath showcasing a 5-foot ceramic shower with rain and handheld features, a large freestanding soaker tub, quartz countertops, and new ceramic tile. Entertain effortlessly with a salt pool with new vacuum and filter system, and an oversized 3-car garage boasting 24-foot ceilings, commercial gym lighting, and basketball goal. The 2nd-floor primary suite offers a kitchenette, two walk-in closets, new hardwood floors, and breathtaking views. Pool house with half bath. A true masterpiece of design and comfort"”schedule your private tour today!

TRACT Clearview YEAR BUILT 1999
COMMUNITY Clearview GARAGE SPACES 4.0
COUNTY York STATUS Active
PROPERTY TYPE(S) Single Family

SCHOOLS
Elementary School Mount Gallant
Jr. High School Dutchman Creek
High School Northwestern


ADDITIONAL DETAILS
AIR Ceiling Fan(s), Central Air, Electric, Heat Pump, Zoned
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Double Oven, Electric Range, Microwave
BASEMENT Daylight, Finished, Walk-Out Access, Yes
CONSTRUCTION Brick
EXTERIOR Dock
GARAGE Attached Garage, Yes
HEAT Heat Pump, Natural Gas
HOA DUES 140
LOT 1.56 acre(s)
LOT DESCRIPTION Waterfront
MLS STATUS Active
PARKING Garage Faces Rear, Garage Faces Side
POOL DESCRIPTION Heated, In Ground, Outdoor Pool, Salt Water
SEWER Septic Tank
SUBDIVISION Clearview
VIEW Yes
VIEW DESCRIPTION Water
WATER Well
WATER ACCESS Lake Wylie
WATERFRONT Yes
MORTGAGE CALCULATOR
   

TOTAL MONTHLY PAYMENT

0
P
I
*Estimate only

SATELLITE VIEW



 
CONTACT US ABOUT 249 BLUE HERON DRIVE
 / 
We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Josh Fretz to contact you even if your name is on a Federal or State "Do not call List".

Listed with Carolina Dream Realty
Date last updated: 10/14/25 12:50 AM PDT

The data relating to real estate on this website derive in part from the Internet Data Exchange program. Brokers make an effort to deliver accurate information, but buyers should independently verify any information on which they will rely in a transaction. All properties are subject to prior sale, change or withdrawal. Neither Remax Metro nor any listing broker shall be responsible for any typographical errors, misinformation, or misprints, and they shall be held totally harmless from any damages arising from reliance upon this data. This data is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Properties reported may be listed or sold by various participants in the MLS
© 2025 Carolina Multiple Listing Services, Inc.

CMLS

This IDX solution is (c) Diverse Solutions 2025.