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

2051 Robinson Pond Road
Prattville, AL 36067
Robin Davies with Realty Connection, original listing - (334) 491-0049

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $665,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2829 Square Feet
Agency: Realty Connection
Agency Phone: (334) 491-0049

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: You must click on the Feature Tab to see the 3-D tour & Floorplan of this home because all of the details just can't be captured in photos or even covered here. This amazing beautifully crafted and built home is going to blow you away with all that it has to offer, all of the extras and all that comes with the home! Let's start at the water and make our way back. The boat dock has 2 boat slips, one with an air lift system so if the river rises, you won't have to worry. There is power and water that has been brought down so the cleaning station will have fresh water to use. There is also a fish tank at the dock as well. Making your way to the home just off the dock to the right is a firepit that is an antique sugar kettle which has a custom made grill topper that will remain. Under the back deck you will find a prep station with a granite top, sink, commercial ice machine and outdoor shower. On the right side of the home is a whole house propane run Generac generator. Under the carport is a winch that will remain. Inside the garage are tons of shelving for storage and the walls for this space are Core of Engineer approved. There are two sets of stairs to bring you to the main level, but there is also a lift on the back of the home that can be used personally or just to help with the groceries. The home has Leaf Guard gutters and a metal roof. All of the doors throughout this home are antique doors, inside and out and all of the cabinetry and shelving has been custom made - no bought off the shelf items found here. The screened in porch sports a commercial ice maker, mini fridge and sink all housed in cabinets topped with leathered granite. The bar stools that line the counter will remain. The storage room behind is heated and cooled. The washer, dryer, refrigerator and buffet to left of refrigerator will remain as will all of the TV's throughout. There are motorized blinds in the primary bedroom. The bonus room is wired for surround sound. So much to see - see soon!
MlsNumber: --
ListingId: 565925


Listing Provided By: Realty Connection, original listing
Phone: (334) 491-0049
Office Phone: (334) 491-0049
Agent Name: Robin Davies
Disclaimer: Copyright © 2024 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.


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 = 3142 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 Amanda Duke
Amanda Duke
ASCIILocal Realty Montgomery
Call Today!: (334) 782-6039

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App