query
RESULTSET
query
  ADDRESS ADTYPE AGENTID BANNER BATHS BEDROOMS BROKERID CITY CITYID COUNTYID DATEADDED DESCRIPTION DISPLAY FIREPLACES GARAGE GRABBER GRABBER2 IDENTIFIER LASTUPDATE LINK LISTINGID LOFT LOTSIZEUNIT LOT_SIZE L_STATE MLSID MLS_NUMBER NEWPHOTO OPENHOUSE OVERSIZED PAGENAME PRICE SCHOOLDIST SORTID SPECIALID SQ_FEET SQ_FEET_UNFIN SUBDIVISION TYPEID UNITNUM VTOUR YEARBUILT ZIP ZONEID ZONING
1 601 E Main Street 0 89535 [empty string] 7.00 6 42164 DILLON [empty string] 0 2025-05-02 07:01:46.0 — A True Southern Unicorn of Timeless Grace. Prepare to be utterly captivated by this breathtaking Neo-Classical Greek Revival Antebellum estate, a crown jewel of Southern architecture lovingly crafted in 1903. Painstakingly restored with a reverence for its storied past, this rare beauty is the embodiment of Southern grandeur, offering a lifestyle steeped in elegance, charm, and distinction. Set on a generous and gracefully flowing floor plan, this 6-bedroom, 7-bathroom mansion is adorned with 10 fireplaces, original Heart Pine floors, and intricate period details that whisper of a bygone era. From the moment you step onto the sweeping wrap-around porch, framed by 24 towering columns, you know youve arrived somewhere truly extraordinary. Inside, the grand foyer welcomes you like a warm Southern embrace. The main level features two refined parlor rooms, a stately formal dining room with a butler’s pantry, a spacious kitchen, a well-appointed laundry room, and an owner’s suite with a private bath. A graceful front staircase leads you upstairs, where youll find five additional bedrooms, five full bathrooms, a charming office nook, and a second-floor balcony that invites you to linger with a glass of sweet tea and the scent of magnolias in the air. Every room showcases craftsmanship rarely seen today—clawfoot tubs, beadboard ceilings, wainscoting, crown molding, pocket doors, and a striking Tiger Oak fireplace. A secondary staircase leads to the vast third-floor attic, brimming with potential. Step outdoors into your own garden paradise, where Magnolias, Dogwoods, Camellias, and Azaleas bloom across the lush landscape. Enjoy summer days by the private in-ground pool or unwind under the stars. Two outbuildings, ample garden space, and a large fenced area complete the idyllic grounds. Just 63 miles from the pristine South Carolina coast and minutes from I-95, this home offers not just a residence, but a legacy. Properties like this don’t come along often — this is a true Southern unicorn, one-of-a-kind and waiting to be loved by its next discerning steward. Call your REALTOR today to step back in time and experience the timeless soul of The Columns. 1 [empty string] [empty string] INTRODUCING “THE COLUMNS” DILLON $599,900 [empty string] 2025-05-18 07:01:03.0 SeanAustinRealEstate@Gmail.com 535267 0 acres 0.750 SC 935 20251618 [empty string] [empty string] 0 599900.0000 0 0 5505 0 [empty string] 2 [empty string] https://vault01.hd.pics/admin/view.aspx?nBucketID=1&nMediaID=35739056&nDownload=1&sFileName=601 1903 29536 0
CACHED false
EXECUTIONTIME 1
SQL SELECT * from listing_info where listingid='535267'
THERE IS A PROBLEM WITH THIS LISTING AND THE WEBMASTER HAS BEEN NOTIFIED