404 N Tidewater Trail, Inman, SC 29349

$765,000
4
BD
3
BA
3,272
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Sold Price
$765,000
List Price
$779,900
Closing Date
Jul 18, 2025
MLS
1558520
Status
CLOSED
Beds
4
Full-baths
3
Style
Traditional, Craftsman
County
Spartanburg
Neighborhood
Other
Type
Single Family Residential
Year Built
2006
Stories
2

Property Description

Stately and Elegant this custom All-Brick home boasts one owner (never occupied by pets) situated on a .83 acre prime lot in one of the Upstate's premier golf communities, Woodfin Ridge Golf Community, ON THE GOLF COURSE, ON LAKE BOWEN RESERVOIR, with HEATED SWIMMING POOL and JACUZZI with 2 TREX DECKS, SCREENED-IN TREX PORCH, unfinished space in basement and PATIO SPACE GALOREE! What more could you ask for? Welcome to "The Clairemont" designed by Donald Gardener (nationally renowned architect) and constructed by the reputable Kip Josey. This home boasts an open concept living flanked mostly with hardwood flooring. The main living space opens to the living room, kitchen, dining and breakfast room. This allows for optimal flow for everyday living and entertaining.  There is an expansive dining room that opens to the massive living room that has wall-to-wall windows with transoms that draw you to the outdoor deck, and a screened-in porch that gives additional entertaining space to sit and enjoy the golfers on hole #8 and bask at the scenic water views. The living room has vaulted ceilings, built-in surround sound, and one of the 2 flagstone gas fireplaces with blowers! The vaulted ceilings extend to the kitchen with a massive island that will allow you never to miss a moment while entertaining from the living room. It has bar seating from every angle and also has a huge breakfast room with a vaulted ceiling that has wall-to-wall windows and access to the 3rd balcony to overlook the pool below! The kitchen has Corian countertops and custom maple cabinets, and it gives plenty of space for meal prep, and storage, and there is a cabinet for the pantry. Down the hall is the Master Suite and there will be no need for sharing with its separate closets and separate vanities! The master suite also has a wall of windows, a vaulted ceiling, access to the 3rd balcony, a walk-in tiled shower, a soaker jetted tub, and a separate water closet. Further down the hall is the impressive walk-in laundry with a gas dryer (which has an electric hook up as well)  and washing machine that will convey, sink, and cabinets galore. There is also access to the two-car garage. The second bedroom on the main floor could be used as a second Master Suite and is located on the other side of the home offering lots of privacy.  It has hardwood flooring and a walk-in closet. There is a full-tiled bathroom with a separate tub/shower combo as well. Downstairs has 10-foot ceilings and has a second den with flagstone gas log fireplace and is flanked with windows and access to the patio. There is a covered area under the screened-in porch that is a perfect grilling spot (gas line could be run from the unfinished basement to patio for grill hook up) or could be used for golf cart parking. Down the hall are two massive bedrooms, one of which could be used as a 3rd Master suite option with its massive walk-in closet. They both share a full-tiled bathroom with double vanities and a separate walk-in shower. Don’t miss the AWESOME storage space found in the unfinished part of the basement that has the potential to become a home gym, office space, workshop, or Flex space and it offers access to two options to the outside. Outside the walk-out basement is a 2019 hot tub installed by Pool and Spa Connection that will convey and have lots of privacy with mature landscaping. The retaining wall offers lots of privacy to the HEATED 36x18 swimming pool installed by Hot Springs with a newer liner and LED-colored pool light for festive parties. The almost acre offers plenty of flat usable yard space and the best part is the stairs down to access the water at Lake Bowen Reservoir. The new buyer can add a cantilever dock if desired. Woodfin Ridge is in the AWARD WINNING DIST 2 school area with amenities that include CLUB HOUSE with active neighborhood functions, GOLF MEMBERSHIP, POOL, AND TENNIS.

Additional Information

Acres
0.83
Amenities
Clubhouse, Common Areas, Golf, Street Lights, Pool, Tennis Court(s), Neighborhood Lake/Pond
Appliances
Dishwasher, Disposal, Dryer, Refrigerator, Washer, Electric Oven, Free-Standing Electric Range, Range, Microwave, Gas Water Heater
Basement
Partially Finished, Full, Walk-Out Access, Interior Entry
Elementary School
Oakland
Exterior
Brick Veneer
Exterior Features
Balcony, Water Feature, Under Ground Irrigation
Fireplace
Yes
Foundation
Basement
Heating
Forced Air, Multi-Units
High School
Boiling Springs
Interior Features
High Ceilings, Ceiling Fan(s), Ceiling Cathedral/Vaulted, Ceiling Smooth, Tray Ceiling(s), Countertops-Solid Surface, Open Floorplan, Tub Garden, Walk-In Closet(s), Second Living Quarters, Split Floor Plan, Pantry
Lot Description
1/2 - Acre, Cul-De-Sac, On Golf Course, Sloped, Few Trees, Wooded, Sprklr In Grnd-Full Yard, Interior Lot
Lot Dimensions
155 x 270 x 89 x 80 x 116 x 129
Master Bedroom Features
Double Sink, Full Bath, Primary on Main Lvl, Shower-Separate, Tub-Garden, Tub-Separate, Walk-in Closet, Multiple Closets
Middle School
Boiling Springs
Model Name
Clairemont
Region
033
Roof
Architectural
Sewer
Septic Tank
Stories
2
Style
Traditional, Craftsman
Subdivision
Other
Taxes
$2,699
Water
Public, inman/camp
Year Built
2006

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Listing courtesy of Ellison Real Estate Company, LLC. Selling Office: Non MLS.

The Listings data contained on this website comes from various participants of The Multiple Listing Service of Greenville, SC, Inc. Internet Data Exchange. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The properties displayed may not be all the properties available. All information provided is deemed reliable but is not guaranteed. © 2026 Greater Greenville Association of REALTORS®. All Rights Reserved. Last Updated