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

193 Anderson Avenue
Saint Joseph, LA 71357
Jane M. Netterville with Jane Netterville Broker & Associates, original listing - (318) 766-4585

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1200 Square Feet
Agency: Jane Netterville Broker & Associates
Agency Phone: (318) 766-4585

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Cabin
Year Built: 2012
Notes: This cabin was designed and built with love of nature in mind. From the moment you step on this property your first impression is "Wow". Built over the waters of Lake Bruin and nestled among the cypress trees with the bald eagles and family of minks, this cabin has a gorgeous panoramic view of the lake from the large screened front porch that covers the thirty foot width of the cabin. Once inside you can appreciate the owners attention to detail with the high rustic tin ceilings and solid rough wood walls. An antique mantel and stone gas fireplace located in the center of the living area is the focal point of the cabin. The kitchen is open to the living area, and has tile countertops, with a nice ice maker and plenty of cabinet space for this small 1200 sq foot cabin. The Master bedroom is located downstairs, with solid cedar walls. The master bath with solid barn-wood walls, and rustic tin ceilings, has a stone walk-in shower, built in dressing table, and vintage soaker tub that sits in the middle of the room. A hallway leads to the back covered porch with views of the massive cypress tree covered lake, which can be lit up at night by a spot light mounted on the dock. Rough cedar railings lead to the upstairs bedroom and bath with its barn-wood walls and tin ceilings, which has a shabby chic vibe with its chandelier. Outside your covered pontoon boat slip, large sun deck, covered cooking area awaits you for a day of entertaining on the water. This cabin has a beautiful gravel walkway from the lot with a circle driveway that is lined with crepe myrtles and fenced with rough post. An extra lot comes with the purchase giving you 200 feet of frontage.
MlsNumber: --
ListingId: 11333104


Listing Provided By: Jane Netterville Broker & Associates, original listing
Phone: (318) 766-4585
Office Phone: (318) 766-4585
Agent Name: Jane M. Netterville
Disclaimer: Copyright © 2024 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