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 = 2351 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 2351 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 2351 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

195 Poplar Springs Road
Walhalla, SC 29691
Julie Johnson with RE/MAX Realty Prof Lake Keowee, original listing - (864) 944-5559

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $419,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: RE/MAX Realty Prof Lake Keowee
Agency Phone: (864) 944-5559

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Welcome home to 195 Poplar Springs Rd! This beautiful, nearly-new home sits on a large lot and has all the room you need at 3020 sq ft, with 4 bedrooms, 3.5 baths and a two-car garage. The main level open-concept family room, dining room and kitchen is perfect for everyone to gather. The kitchen is the heart of the home with lots of cabinet space, granite counter tops, dining nook and walk-in pantry. The main living area has lovely windows that look out over a beautiful flagstone patio, firepit and landscaped fenced yard. Enjoy not one, but two owner's suites - one on each level. The main level primary suite measures 19 x 15 with an on-suite bath, double vanities, lighted mirrors, 5-foot walk-in shower and a large walk-in closet. Upstairs find the secondary owner’s Suite which measures 20 x 20, has 2 spacious walk-in closets, a master bath with double vanity, and a 5ft tub/shower combo. Also, upstairs a bonus room, 2 additional bedrooms adjoined by a Jack and Jill bath and the laundry room. Other highlights of this amazing home include custom-built backyard patio, landscaping and 6 ft wooden privacy fence. There is an attached 2-car garage and large concrete driveway for extra parking. Additional Features include full house blinds, granite countertops throughout, LED lighting, tilt-out windows, Smart Home System Alarm, UV air and surface treatment for HVAC, electric fireplace & garage door openers. The HOA is affordable at only $530 per year and there are no land use restrictions! In other words, park your boat, RV or business vehicle in the garage or driveway. The HOA covenants were established to maintain Storm Water Management Basin and Easement area maintenance only! This subdivision is on the border of Seneca and Walhalla, just 5-20 minutes to restaurants, shops, Prisma Hospital, Clemson University, Lake Keowee and Lake Hartwell. So much home for the money. Hurry on this one! Video & drone Tour: https://sites.rerpics.com/vd/166905781. Disclaimer: <br /> Video is a rendering and may not exactly match the features of the house. Sq Footage obtained from tax records. Buyers agent to verify any details important to their client. Information deemed reliable but not guaranteed.
MlsNumber: --
ListingId: 20280335


Listing Provided By: RE/MAX Realty Prof Lake Keowee, original listing
Phone: (843) 826-0088
Office Phone: (864) 944-5559
Agent Name: Julie Johnson
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

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 = 2351 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 Distinguished Realty of South Carolina
Distinguished Realty of South Carolina
Call Today!: (864) 818-7653

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App