Title Page Background
DEBUG FN args: Array ( [0] => 2353 [1] => [2] => [3] => agent ) BEFORE: Site: 2353 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2353 Igate: njhud LocID: 2353 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2353 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2353 [1] => [2] => [3] => lender ) BEFORE: Site: 2353 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2353 Igate: njhud LocID: 2353 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2353 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2353 [1] => [2] => [3] => other ) BEFORE: Site: 2353 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2353 Igate: njhud LocID: 2353 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2353 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

228 Riggs Drive
Clemson, SC 29631

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: Allen Tate - Lake Keowee Seneca

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Oven - Gas
Architectural Style: Ranch
Construction Materials: Stone
Flooring: Tile, Vinyl, Hardwood
Heating: Central Furnace
Interior Features: Walk-in Shower, Ceiling Fan, Blinds, Built-in Bookcases, Smoke Detector, Cable Tv Available, Walk-in Closet, Washer Connection, Gas Logs, Dryer Connection-electric, Countertops-Other, Laundry Room Sink, Alarm System-owned, Ceilings-Smooth, Attic Stairs-Disappearing, Fireplace - Double Sided
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Laundry
Utilities: Cable Available, Electricity Available

Window Features

Exterior Features: Patio, Outdoor Kitchen, Fenced Yard, Porch-front, Grill - Gas, Driveway - Asphalt, Glass Door
Fencing: Fenced
Other Features: Outdoor Kitchen
Patio and Porch Features: Patio, Porch

Neighborhood/Schools

Elementary School/District: Clemson Elem
Middle/Junior High School/District:
High School/District: D.W. Daniel High
Subvidision Name: Cold Springs

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: 228 Riggs Dr. presents a rare opportunity to purchase a fully renovated home in Downtown Clemson on a huge lot! This 3 bedroom, 2 full bath home is approximately 2300 square feet and all on one level. The current owners have done extensive renovations and updates so that you can move right in and enjoy day one. Upon entry, you'll appreciate how open and bright the interior is. The formal dining and living areas flank the stone fireplace (one side gas and the other wood burning). The kitchen is beautifully appointed with custom cabinetry, marble countertops, a 6-burner Viking gas range/oven, a Viking dishwasher, and stainless appliances to match. The high bar in the kitchen can provide an easy way to serve guests when casually entertaining, and everything flows well inside and out via the slider in the den. Speaking of outside, you may end up doing all your tailgating at home when you see the 24'X19' covered porch/patio, outdoor kitchen (stainless grill included), huge back yard, and fire pit. The entire back yard is fenced in and nearly level, so it is all usable space for playing, pets running, or would make the perfect setting for your pool and pool house one day! The outdoor living space is really special and great for year-round entertainment. Most homes built in this era didn't have a split bedroom floor plan, but this home does, which gives the owner ample privacy while family and guests enjoy the same on the other side of the home. The owner's suite is beautifully updated with his and her walk in closets and an added large bathroom with a tile shower. The 2 guest bedrooms share a beautifully updated full bath. The current owners also added a huge (16'8x9'4) laundry/mud room with great built-in storage. Some "not so obvious" features you may appreciate: The location of this home on Riggs has very little car or foot traffic. The rear of the home faces east, so the afternoons are cool, and the home or covered patio provides shade and allows for watching TV outside without glares. The home is on sewer, so adding a pool, pool house, garage, etc. isn't impacted by septic tank or drain lines. The list of updates is extensive and noted on a feature sheet in supplement documents on MLS...All work was permitted and performed by high level contractors.  <br /> Some additional notes:Roof replaced Aug 2023, transferable warranty with Four Seasons roofing. Transferable Termite and moisture bond with Macs Exterminating and home is also sprayed quarterly for bugs. Driveway paved 2023. Crawl space encapsulated and windows replaced in 2022. Owners currently use AT&T internet, Vyve is available.
MlsNumber: --


Listing Provided By: Allen Tate - Lake Keowee Seneca, original listing
Phone: (864) 230-5911
Office Phone: (864) 882-1166
Agent Name: Gregory Coutu
Disclaimer: Copyright © 2024 Western Upstate Association of REALTORS&#174;. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => pickens [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: pickens State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: pickens State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2353 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for C. Michael Burgess
C. Michael Burgess
ASCIINorth Group Real Estate
Call Today!: (864) 918-5793

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App