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

2349 Dunlap Road
Luthersville, GA 30251

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $380,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1800 Square Feet
Agency: Keller Williams Realty Atl. Partners

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range
Architectural Style: Ranch
Construction Materials: Vinyl Siding
Cooling: Ceiling Fan(s)
Flooring: Laminate
Heating: Central Furnace
Interior Features: High Ceilings, Walk-in Closet(s), Vaulted Ceiling(s), Separate Shower, Double Vanity, Soaking Tub, Master On Main Level
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Parking Features: Garage
Roof: Composition

Neighborhood/Schools

Elementary School/District: Unity
Middle/Junior High School/District:
High School/District: Greenville
Subvidision Name:

Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Step Inside to this IMMACULATE 4 Bedroom 2 Full Bath Farmhouse Ranch on 4.23 Acres and you are sure to fall in LOVE! Only 2 Years old!! Gorgeous Vaulted Family Room with Stone Fireplace is open to the Kitchen with HUGE Breakfast Bar, Granite Counter Tops, Stainless Steel Appliances, Pantry and Dining Room that overlooks the sprawling private backyard and extended patio. Master on Main features Walk in Closet, Double Vanity, Separate Shower, and Garden Tub. Master is tucked away from additional Secondary Bedrooms on Main for ultimate Privacy. HUGE 4th Bedroom/Bonus Room upstairs has a closet that is big enough to turn into an Office/Craft Room/Play Room..You Name It! Upgraded LVP flooring and farmhouse touches throughout entire main level. Let the kiddos and pets roam without worry on this completely fenced and gated estate with BRAND NEW 36x26 Barn with concrete floor, Chicken coop and SO Much More! This one truly is what dreams are made of!!!!**FIBER INTERNET
MlsNumber: --


Listing Provided By: Keller Williams Realty Atl. Partners, original listing
Phone: (770) 692-0888
Office Phone: (770) 692-0888
Agent Name: Kim Mills
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App