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

9794 La Hwy 965
St Francisville, LA 70775
Theresa Thibodeaux with Dawson Grey Real Estate, original listing - (225) 325-5555

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 6
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4728 Square Feet
Agency: Dawson Grey Real Estate
Agency Phone: (225) 325-5555

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 55 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: This property is an amazing hunter’s paradise! Located on 50 plus acres with creek frontage, this stunning property used to be a part of the Troy plantation. The first/main custom built home features 4 bedrooms and 3.5 baths, spacious open floor plan, sitting area, breakfast room, kitchen with gas stove located on an Island over looking the family room, granite countertops, wall oven, formal dining room, lovely foyer, fireplace in family room, a large primary bedroom on one wing of home with a sitting area overlooking the beautiful backyard, primary bath with separate shower, clawfoot tub, double vanity, walk in closet, Two additional bedrooms with a Jack & Jill bath on a second wing & a fourth bedroom and bath on a third wing of the home and a big bonus room upstairs. There is a storage building in the back of the property; as well as a boat port connected to the two car garage! There is also a separate 266 sq. ft. office attached to a second 2 bedroom/1 bath home built in 2023 and features an open floor plan, kitchen with granite countertops, family room, breakfast nook, pantry and walk in laundry room. Do not hesitate!!! Schedule a private showing today!!! Original listing was land only. Seller is now selling all approximate 55.1 acres with two homes.
MlsNumber: --
ListingId: 2024020833


Listing Provided By: Dawson Grey Real Estate, original listing
Phone: (225) 315-3453
Office Phone: (225) 325-5555
Agent Name: Theresa Thibodeaux
Disclaimer: Copyright © 2024 Greater Baton Rouge Association of REALTORS. 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