Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 96 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 96 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 96 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

112 Shea Street
Summerville, SC 29485

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,000
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: Keller Williams Realty Charleston West Ashley

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2016
Notes: Conveniently located 5 minutes from historic downtown Summerville and convenient shopping near Azalea square. Within the coveted Dorchester county II school district it offers children a award wining education. This charming community is tucked right beside Gahagan Park featuring many baseball diamonds, an extensive play park, a football field and track. Town of Summerville events regularly occur including outdoor movie nights, firework display on the 4th of July and many others. The floorpan is an innovative and open floorplan with the master suite downstairs. Family room, eating area are open to the gourmet kitchen with granite counter tops, white cabinets and stainless steel built in appliances with gas cooktop. Wood floors throughout downstairs living, primary suite, and on stairs.For added convenience, the TV wiring over the mantel for those seeking an option for alternative location. <br /> The 4th bedroom can also serve as a large bonus room, home office, home school area, workout room, flex space of any kind. It does have a closet. <br /> <br /> Step out back for a courtyard oasis and discover the quality of outdoor living that Summerville is known for. The meticulously designed paver system adorning the patio and the side of the home exudes elegance while providing durability and low maintenance. Whether you're hosting a summer barbecue or enjoying a quiet evening under the stars, the expansive patio with a 16' custom awning offers the perfect setting for every occasion. And with a gas fire pit outside, you can cozy up with loved ones and create unforgettable memories year-round.<br /> <br /> Unwind in the comfort of the master suite, conveniently located on the main level. No detail has been overlooked, from the absence of carpet in the master bedroom to the custom closet system that maximizes storage and organization. <br /> <br /> Experience luxury living at its finest with modern upgrades throughout the home. The HVAC system has been upgraded with an advanced air filter system, ensuring optimal indoor air quality and comfort year-round. The garage storage shelves convey, providing ample space for all your storage needs. Additionally, the zoned irrigation system makes lawn maintenance a breeze, while the gutter system with leaf filter ensures hassle-free upkeep.<br /> <br /> Say goodbye to the hassle of appliance shopping, as the fridge, washer, and dryer all convey with the home. Enjoy the convenience of a termite bond for added peace of mind, knowing your investment is protected. Whether you're relaxing indoors or entertaining outdoors, every detail of 112 Shea has been thoughtfully curated to enhance your lifestyle and provide you with the ultimate in comfort and convenience.
MlsNumber: 24009384


Listing Provided By: Keller Williams Realty Charleston West Ashley, original listing
Name: Keller Williams Realty Charleston West Ashley
Phone: (843) 737-6780
Office Name: Keller Williams Key
Office Phone: (843) 737-6780
Agent Name: Roni Haskell
Disclaimer: Copyright © 2024 Charleston Trident Association of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 96 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Neil Blindauer
Neil Blindauer
ASCIIOak Realty
Mobile: (480) 797-1824

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App