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

238 Kinchafoonee Creek Road
Leesburg, GA 31763
Valerie Mixon with PARKER REAL ESTATE GROUP, original listing - (229) 438-9019

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 4175 Square Feet
Agency: PARKER REAL ESTATE GROUP
Agency Phone: (229) 438-9019

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Other
Year Built: 1990
Notes: Welcome to this huge home In Leesburg that keeps on giving. This beautiful 4,175 sf home sits on 2 acres in lee county with 5 bedrooms and 5.5 baths (3 of which are en-suite) 2 of the primary bedrooms on each end of the house have separate showers and soaker tubs. There are 2 fully functioning kitchens, 3 laundry rooms ( 2 are enclosed and can be used for extra storage closets if desired and just use the large laundry downstairs with a laundry sink that is centrally located for both sides. There is a large living room and sunken den in the main house and another living room upstairs in the other wing of the home. The kitchen cabinets are all hardwood with custom countertops and custom built interior doors on the main level of the home. Outside there is ample parking and a large fenced in court that was used as a tennis and basketball court in the past (the owners may be painting the court blue and green in the near future) There is a saltwater in ground pool with a new hayward variable speed pump so you can enjoy the quietness while sitting outside by the pool or relaxing in the brand new hot tub that seats 5. There is also a balcony with double French doors on one side of the home that overlooks the pool and tennis court in the backyard. This home is a must see to appreciate all of the space and it is located near a local coffee shop, gas station and grocery. Call your agent today for an appointment for a showing.
MlsNumber: --
ListingId: 164565


Listing Provided By: PARKER REAL ESTATE GROUP, original listing
Phone: (229) 364-8536
Office Phone: (229) 438-9019
Agent Name: Valerie Mixon
Disclaimer: Copyright © 2025 Albany Board of Realtors and Southwest Georgia MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App