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

101 Kenmare
Tyrone, GA 30290
Philip Theriault with Keller Williams Realty Atl. Partners, original listing - (770) 632-1112

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $729,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4077 Square Feet
Agency: Keller Williams Realty Atl. Partners
Agency Phone: (770) 632-1112

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Welcome to 101 Kenmare Row - Your Dream Home in Prestigious Lake Windsong, Tyrone, GA! Call Philip Theriault for your private showing and come discover this impressive Craftsman-style residence featuring a finished basement, a spacious 3-car garage and the largest kitchen you've ever seen!! Nestled in the heart of the sought-after Lake Windsong subdivision, this magnificent residence is surrounded by nearly 3 acres of private paradise offering a plethora of areas for youthful exploration and plenty of trees to build the perfect tree-fort.. A strikingly large front porch, adorned with massive Craftsman columns, offers an unforgettable first impression, showcasing timeless elegance and commanding curb appeal. Step inside the grand foyer and immerse yourself in the finer things in life. Gleaming hardwood floors lead the way, while soaring 20-foot ceilings create an airy, light-filled ambiance. The heart of the home, a luxurious kitchen that rivals any restaurant in size, promises to spoil you with its endless space and functionality - a perfect blend for both gourmet creations and casual family gatherings alike. This is truly a must-see to believe! The main level boasts a grand Master Suite with private porch access and scenic backyard views, offering the ultimate retreat after a long day. Upstairs, you'll find four generously sized bedrooms plus a bonus study room, ideal for remote work, homeschooling, or creative endeavors. The finished basement, complete with a full bath and exterior access, opens up a world of opportunities: imagine epic game nights, cozy movie marathons, or the ultimate teen hangout spot. When it's time to enjoy the outdoors, step onto the covered patio, complete with a cozy outdoor fireplace-perfect for crisp fall evenings or summer gatherings with your favorite drink and the best of company to enjoy it with. The impressive 3-car garage is ready to house all your vehicles, tools, and toys, making organization a breeze. Living in Lake Windsong means more than just a beautiful home-it's a lifestyle. Enjoy peaceful strolls along scenic walking trails, water activities on the lake, swimming, tennis and other community amenities OR the charm of nearby downtown Tyrone with its cozy cafes, local shops, and vibrant community events. Plus, you're just a short drive from Peachtree City's golf cart paths, dining and entertainment, Fayetteville's shopping destinations, top-rated schools and an airport that will puts the world at your fingertips! Are you ready to write the best new chapter of your life? Contact Philip Theriault for a private showing to discover how you can make this dream a reality!
MlsNumber: --
ListingId: 10456476


Listing Provided By: Keller Williams Realty Atl. Partners, original listing
Phone: (770) 632-1112
Office Phone: (770) 632-1112
Agent Name: Philip Theriault
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. 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 = 446 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Yashulena Stevenson
Yashulena Stevenson
ASCIIPR Realty and Associates
Call Today!: (678) 468-2293

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App