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

16966 Halso Mill Road
Greenville, AL 36037
Leanna Batrez with David Kahn Company, original listing - (334) 277-5990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $406,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1707 Square Feet
Agency: David Kahn Company
Agency Phone: (334) 277-5990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: This beautifully crafted, one-of-a-kind 3-bedroom, 2-bathroom home, built in 2024, is perfectly situated on 6.67 acres of pure country bliss. The 1-acre homesite is cleared, while the remaining 5.67 acres are densely wooded, offering complete privacy and tranquility. This stylish home blends comfort and efficiency with an open, light-filled floor plan and high-end finishes. The kitchen is an entertainer’s dream, featuring a large island with ample storage and a walk-in pantry with custom wood shelves and a deep freeze. French doors lead to a screened porch with ceiling fans, ideal for year-round outdoor enjoyment. A cozy coffee bar adds to the charm, while beautiful granite countertops complete the home’s elegant design.The home greets you with an expansive front porch, featuring custom wood accents and multiple ceiling fans. Inside, the oversized primary bedroom offers a peaceful retreat, with French doors opening to the large screened porch. The spa-like primary bath includes a spacious tiled shower, freestanding tub, and double vanity with granite countertops. On the opposite side of the home, two additional bedrooms and a guest bath provide ample space, while the laundry room offers custom cabinetry and shelving for extra storage.The property includes CHICKEN COOP & CHICKENS. For deer hunters, a DEER FEEDER & CAMERA are already set up on the property.This home features a TANKLESS WATER HEATER for endless hot water, an indoor GAS FIREPLACE. ALL APPLIANCES REMAIN with the property. Need extra space? The DETACHED storage SHED provides room for tools and equipment, while an additional storage area to the left of the carport offers a large FULL SIZED UNFINISHED ATTIC SPACE ABOVE THE CARPORT. The property also includes a LAWN MOWER, so you’re ready to enjoy your expansive outdoor space right away. The property is accessed through a SOLAR-POWERED automatic GATE with keypad entry. It’s also PREWIRED FOR A GENERAC GENERATOR (wiring and concrete pad only).
MlsNumber: --
ListingId: 574652


Listing Provided By: David Kahn Company, original listing
Phone: (334) 277-5990
Office Phone: (334) 277-5990
Agent Name: Leanna Batrez
Disclaimer: Copyright © 2025 Montgomery Area Association of Realtors 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