Title Page Background
DEBUG FN args: Array ( [0] => 2351 [1] => [2] => [3] => agent ) BEFORE: Site: 2351 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2351 Igate: njhud LocID: 2351 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 = 2351 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2351 [1] => [2] => [3] => lender ) BEFORE: Site: 2351 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2351 Igate: njhud LocID: 2351 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 = 2351 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2351 [1] => [2] => [3] => other ) BEFORE: Site: 2351 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2351 Igate: njhud LocID: 2351 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 = 2351 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

607 Longview Court
Seneca, SC 29672
David Hurst with Coldwell Banker Caine/Williams, original listing - (864) 250-2850

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,390,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: --
Agency: Coldwell Banker Caine/Williams
Agency Phone: (864) 250-2850

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Deep, rich exterior hues set the tone for this exceptional lakefront home. You’ll immediately experience its modern aesthetic as you walk over the bridge to the front entrance. Inside, your first impression will likely be the striking vaulted ceilings with beautifully crafted, solid wood architectural beams. Contemporary comfort is an apt description for this standout dwelling designed by Scott Crichton of Architecture 224, decorated by In Site Designs, and landscaped by Graham Kimak Landscape Designs. Every detail from light fixtures to faucets exudes style, seamlessly blending everyday extravagance with aminimalist vibe. Touches of midcentury modern and Scandinavian sophistication characterize the perfect place to experience life on the lake, as the home showcases the water via its many sizeable windows. Another focal point is a striking stone accent that punctuates the airy living area with a built-in fireplace. Wide-plank smoked European oak floors imported from Italy contribute to the understated refinement of the main areas. In the kitchen, you’ll find a large sleek island, a Subzero refrigerator, a Thermador coffee system, a Wolf double oven—convection and steam—and natural wood cabinets. Both the kitchen and the downstairs den feature Absolute Black honed granite countertops. Additionally, there are two ice machines downstairs, along with a wet bar. The home has four bedrooms (two on each floor), four full baths, and two half baths. The master bedroom, with its chevron-patterned flooring, delicate palette, and vaulted ceiling gives the feel of a peaceful vacation place, but you’ll be right at home there. A cork floored room off the primary bedroom could be used for exercise or as an office. There are two laundry areas, and the bathrooms are appointed with TOTO toilets and Cambria countertops. Spanning the back of the home, the vast patio brings new meaning to the great outdoors; it’s resort-worthy, and there is plenty of covered space for entertaining. The pool has a lock-in cover, and there’s also a spa for the ultimate in relaxation. The property has a gentle grade to the lake where you’ll enjoy 337feet of riprap waterfrontage with Oconee Prime rock and a Zuri decking dock by Kroeger Marine. There’s also a HydroHoist lift and a Touchless Boat Cover®. Constructed with solid wood timbers and doors, the home also has Hunter Douglas motorized blinds, exterior uplighting, tankless water heaters, a whole-house generator, and full-yard irrigation, which translates to convenience, energy efficiency, and worry-free maintenance. This homesite on a private cul de sac is located mid-Lake Keowee, allowing easy access to Clemson and Seneca. Make an appointment today to see this modern, lakeside treasure.
MlsNumber: --
ListingId: 1553848


Listing Provided By: Coldwell Banker Caine/Williams, original listing
Phone: (864) 313-3079
Office Phone: (864) 250-2850
Agent Name: David Hurst
Disclaimer: Copyright © 2025 Greater Greenville 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => oconee [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: oconee State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: oconee 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 = 2351 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Delane Graham
Delane Graham
ASCIIRE/MAX Realty Professionals
Call Today!: (864) 324-1217

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App