Title Page Background
DEBUG FN args: Array ( [0] => 1177 [1] => [2] => [3] => agent ) BEFORE: Site: 1177 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1177 Igate: njhud LocID: 1177 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1177 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1177 [1] => [2] => [3] => lender ) BEFORE: Site: 1177 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1177 Igate: njhud LocID: 1177 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1177 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1177 [1] => [2] => [3] => other ) BEFORE: Site: 1177 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1177 Igate: njhud LocID: 1177 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1177 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

304 Brushy Creek Road
Sibley, LA 71073

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $235,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 2228 Square Feet
Agency: LA State Realty, LLC

Map Details Show Map | Show StreetView




House Features

Appliances: Microwave, Range, Refrigerator, Dryer
Architectural Style: Ranch
Construction Materials: Cedar
Cooling: Window Unit(s) A/C
Flooring: Wood, Vinyl
Heating: Space Heater, Fireplace
Interior Features: Eat-in Kitchen, Cathedral Ceiling(s), Built-in Features, Open Floorplan, Natural Woodwork, Tile Counters
Rooms: Basement, Bathroom 1, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: Boat Slip, Storage, Rv/Boat Parking, Storm Cellar
Parking Features: Garage, Carport, Driveway, RV, Boat
Other Features: Storage, RV/Boat Storage
Roof: Metal
Structure Type: Dock
View: Water, Lake
Waterfront Features: Waterfront, Lake Front

Neighborhood/Schools

Elementary School/District: Webster PSB
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Evans J O Prop

Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1948
Notes: Welcome home to this stunning, well maintained 3 bedroom, 1 bath lakehouse! Situated on 1.83 acres, over 400ft of waterfront, you will enjoy relaxing on the 34ft screened back porch. The primary bedroom & dining overlook the lake with their panoramic views! This open concept home features 10ft ceilings, stone fireplace, spacious living room that allows for multi purpose spaces, great for entertaining. Filled with tons of character, this home has made wonderful memories for its' family & now it's your turn. The boathouse has 2 stalls & fishing pier. There is a basement which features a full bathroom that needs some TLC, great for fishing gear & outdoor tools. Tons of storage and additional covered parking. Located on one of Louisiana's premier fishing lakes, Lake Bistineau has over 15,500 acres to explore. Known for its' large mouth bass & white perch, over 10 miles of hiking trails, equestrian trails, disc golf & a diverse bird population including bald eagles! Updated survey attached.
MlsNumber: --


Listing Provided By: LA State Realty, LLC, original listing
Phone: (318) 268-0854
Office Phone: (318) 377-6062
Agent Name: Catherine Hunt
Disclaimer: Copyright © 2024 North Texas Real Estate Information Systems, Inc. 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