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

55459 M Toney Road
Franklinton, LA 70438

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 4
Baths: 4
Status: Active
SqFt: 4333
Agency: Keller Williams Realty Services

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: --
Notes: On the outskirts of Franklinton, nested at the end of a gravel road on 20 beautiful acres is this breathtaking haven. Boosting of 4 bedrooms, 3.5 baths, amazing brick front and back porch, gourmet kit w/walk in pantry, coffee bar, office, great room with built-ins and gas fireplace, walls of windows offering amazing views of the stunning bricked patio, outdoor kitchen with grill, small fridge, and microwave, stocked pond, and 20' x 50' in-ground gunite pool with tanning ledge, 8' deep with waterfall, water shooters, bubblers, and lights. Luxury wood floors throughout kitchen and living areas. Primary suite is absolute luxury from the wood ceilings to the amazing custom tile work, multi head shower, free standing soaking tub, extra coffee bar, wine/beverage fridge, exercise room, MUST-SEE closet. Mudroom entry from carport to large laundry room. Guest suite downstairs with private bathroom. Upstairs you will find two bedrooms with large bathroom with separate vanity rooms, large den/gameroom, and two separate walk-in attic spaces. 30' x 50' metal shed on slab with electricity. Irrigation system, professional landscaping, magnolia trees, pecan trees, oak trees and so much more. Flood zone X. Owner/Agent.
MlsNumber: 2440681


Listing Provided By: Keller Williams Realty Services, original listing
Name: Keller Williams Realty Services
Phone: (985) 727-7000
Office Name: Keller Williams Realty Services
Office Phone: (985) 727-7000
Agent Name: Sondra Wilson
Disclaimer: Copyright © 2024 Gulf South Real Estate Information Network. 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