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

3699 Highway 605
Saint Joseph, LA 71366

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,595,000
Beds: 5
Baths: 7
Status: Active
SqFt: 4637
Agency: Jane Netterville Broker & Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2002
Notes: Introducing the epitome of lakefront living at Lake Bruin! This magnificent home has 5 master suites and 2 half baths. Step into luxury with an air-conditioned and heated sunporch, complemented by a heated Gunite swimming pool and an enviable outdoor kitchen for outdoor dining at its finest. The outdoor oasis continues with a pier featuring 4 slips, a covered area, a bar, and ample sun space for soaking up those breathtaking lake views. Practicality meets convenience with a backup generator, a greenhouse, a 2-car garage, and a generously sized storage building. Inside, you'll find a seamlessly flowing layout, highlighted by spectacular lake views from numerous vantage points. The den and stunning sunroom are adorned with fireplaces, creating cozy gathering spaces year-round. The expansive kitchen is a chef's dream, featuring stainless steel appliances, abundant cabinets, plenty of counter space, and a dining area that encourages socializing. The primary suite offers a private retreat on one end of the house, complete with a large office and a convenient utility room nearby. Outdoors, the screened pool area is a haven for relaxation and entertainment, featuring a half bath for added convenience. The cool decking leads you to the pier, where you'll find the perfect setup for boating and waterside enjoyment, including designated slips, a jet ski area, and a bar with a TV for game-day excitement. With 180 feet of lake frontage, this property is a "must-see to appreciate" gem, offering a lifestyle of luxury, comfort, and endless recreation. Don't miss out on the opportunity to call this stunning lakefront retreat your own!
MlsNumber: 11260870


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