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 = 54 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 = 54 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 = 54 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;

408 County Road 4418 Circle
Brundidge, AL 36010
Dallas McCain with Partners Realty, original listing - (334) 277-1077

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $745,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 2204 Square Feet
Agency: Partners Realty
Agency Phone: (334) 277-1077

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: Ponderosa Ranch sits on 37.90 acres east of Brundidge, Alabama in the rolling hills of Pike County. From the house you overlook a spectacular hay field that gently descends to the barns and other facilities that is designed to accommodate horses. The 2,204 sq/ft beautiful home sits on top of a hill which allows for great views over the ranch and surrounding properties. From the front porch you can enjoy a warm cup of coffee and overlook your horses graze in the pastures. The elegant horse stable has 9, 12' x 12' matted stalls with sliding doors and was built in 2020. Behind the stable is a loafing barn that is 40' x 84'. The 3-sided hay barn next to the house was built in 2021 and is 20' x 30'. There are two carports on property, one being by the house and the other close to the barns which makes for great trailer storage. There are 4 RV hookup spots located by the barns that are ready to use! The entire property is fenced along with internal fencing which is laid out perfectly. This is truly an unique and terrific ranch that anybody would be proud to call their own. With stunning views and endless possibilities, Ponderosa Ranch is the perfect haven for those seeking peace and connection with nature, making every day feel like a getaway. Escape the bustle of city life at the Ponderosa Ranch.
MlsNumber: --
ListingId: 566013


Listing Provided By: Partners Realty, original listing
Phone: (334) 277-1077
Office Phone: (334) 277-1077
Agent Name: Dallas McCain
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App