JUST LISTED!! EXCEPTIONAL OPPORTUNITY in HAYMARKET's #1 GATED GOLF COURSE & AMENITY RICH COMMUNITY OF PIEDMONT! RENOVATED...DISTINCTIVE... EXQUISITE - MOVE-IN READY! PREMIUM LOT with PHENOMENAL WATER and GOLF COURSE VIEW's of Tom Fazio's Signature 4th HOLE Green from the SPACIOUS Deck or Lower-Level Stone Patio. 5BR / 4.5 Bath approximately 6,000 square feet of LUXURIOUS and UPDATED living space. NO EXPENSE was spared with the recent 2024 UPDATES! From the minute you enter the GRAND 2-STORY Foyer w/ DESIGNER LIGHTING and REFINISHED staircase and CUSTOM mill work you will SEE this opportunity is SPECIAL. The Open Concept includes an EMBASSY sized formal Dining Room w/ new CHANDELIER, Sitting Room w/ Access to Main Level Study via French Doors. The Back of the house includes the GOURMET Eat-In Kitchen w/ Spectacular large ISLAND w/ Seating and Light Filled Sunroom w/ Vaulted Ceilings. Kitchen includes, ALL NEW TOP-OF-THE-LINE stainless steel KichenAid and Whirlpool Appliances (2024), POPULAR white cabinetry and granite countertops. SPECTACULAR water and golf course views from the entire back side of the property! INVITING Family Room OPEN to Kitchen includes Gas Fireplace. Grab a coffee or cocktail from the BUTLER's PANTRY w/ Built-Ins/Wine Storage and kick back on the deck and enjoy the sunrise off the water or an early evening glass of wine from your shaded deck w/ UNBELIEVABLE views. THE UPPER LEVEL living quarters includes 4 GENEROUS Sized bedrooms featured by the GORGEOUS Primary Suite w/ Sitting Room, Dual Walk-in Closets and UPDATED Primary Bath w/ Soaking Tub and Separate shower. Bedroom 2 could be utilized as a 2nd Primary Suite based on its large size and easy ACCESS to 2nd Full Bath. Bedroom 3 is a PRINCESS suite w/ its own attached full bath. The FINISHED Walk-out basement w/ Full size windows- approx. 2,000 square feet (see list of all the furniture/accessories that convey) is the PERFECT entertainers space with NEW LVP Flooring, 5th legal bedroom and 4th Full Bath. Recreation space includes pre-wired 7.1 Surround Sound and wall of built-in shelving. Gaming Area includes Billiards Table, Dedicated Home Gym and 2nd Home Office / Hobby Space. Walk-Out to a Finished Stone patio and ENJOY the PRICELESS Views! The current owners intended on making this their forever home prior to receiving relo orders and DID NOT skimp on the recent UPDATES. BUYER PEACE-OF-MIND (Both HVAC Systems (Heating/Cooling) replaced with Top-of-the-Line Carrier Units (2024), Water Heater and Main Pressure Valve replaced (2024), Smart Thermostats Installed for Both Systems (2024), Sump Pump Replaced (2024), Hardwood Floors Refinished (2024), Shower heads replaced w/ Rain Heads (2024), New Deck Floor and Stairs Boards (2024), Smart Double oven, Cooktop, Refrigerator, Dishwasher, Built-In Microwave (All 2024), UPGRADED smart battery backup quiet garage door openers w/ outside entry pads (2024), All Outdoor Trim Painted (2024), New Landscaping (2024), All NEW DESIGNER Lighting throughout (2024), 5 new American Standard Toilets (2024), 12 Zone Irrigation System w/ new heads (2024)...so much more....THIS IS AN ABSOLUTE DIME! In ADDITION to this EXCEPTIONAL and IMPECCABLY maintained and UPGRADED PROPERTY you are buying into a LIFESTYLE. GATED Piedmont is located near major transportation options and is one of Haymarket's MOST DESIRABLE Gated Golf Course Resort Communities. Amenities include 24/7 Monitored Gated Security, 18 Hole Championship Golf Course (social and full golf membership options available), Fitness Center, Group Exercise Studio, Indoor/Outdoor Pools, Lighted Tennis/Pickleball Courts, Basketball Court, Tot Lots and Walking Paths. Home Sweet Home! 5477 Sherman Oaks Court is WAITING for you to call it HOME!