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

10899 Nathan Jordan Road
Millry, AL 36558
Shawn Harrison with Harrison and Harrison Insurance and Realty, Inc., original listing - (251) 246-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4680 Square Feet
Agency: Harrison and Harrison Insurance and Realty, Inc.
Agency Phone: (251) 246-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: The math is all adding up on this one, that is for sure! This home sits on 40 acres with timber, prime pasture land, a pool, over 4600 sq feet, and a stocked pond. The drive off of Nathan Jordan Road is a private drive with deeded access that is about 3/4ths of a mile for the perfect amount of seclusion. When you drive onto the property, you first notice the large home with 10' wrap around porches that welcome you home. Can you imagine having family gatherings on the porches, or a glass of sweet tea after a long spring day, or a cup of coffee on a cool fall morning on the swing? What a wonderful idea! When you walk inside the front door is the large great room that includes the family room and the kitchen/dining area. It is perfect for entertaining the largest of crowds and is ready for making a million memories. There is a gas fireplace in the family room and plenty of natural lighting. The kitchen is open with a double oven, cooktop on the island, tile countertops, and all appliances are to convey with the purchase, including the refrigerator and window treatments! The master bedroom has a gas fireplace and is large enough for a sitting area. The adjoining master bath has a walk-in bathtub and separate shower. There are his and her walk-in closets and separate sinks and vanities. The bedrooms upstairs are also huge and have walk-in closets and one could be used as a rec room or play room! As you walk out the back door onto the back side of the porch, you see the in-ground pool that is perfect for summer fun! There is also fenced pastures for livestock, out buildings for storage or workshops, and a stocked pond for fishing. There is so much to be seen with this property! Give Tommy Windham a call today for more information, or to make your appointment today!
MlsNumber: --
ListingId: 11470109


Listing Provided By: Harrison and Harrison Insurance and Realty, Inc., original listing
Phone: (251) 246-2400
Office Phone: (251) 246-2400
Agent Name: Shawn Harrison
Disclaimer: Copyright © 2025 My State 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