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

366 Lago Avenue
Opelousas, LA 70570
Rachel Hebert with EXP Realty, LLC, original listing - (337) 522-7554

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $660,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2850 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (337) 522-7554

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Wow! This home is a rare find and simply put, has it all! Nestled in Woodside subdivision in the quiet cul-de-sac, this stunning home sits on just over an acre of serene property backing up to Jack Fox Road. As you approach the house you will notice the exquisite large front porch flanked by antique hand hewn pine beams, which elevate this Acadian style home. Inside you will find beautiful antique pine wood floors, old St. Louis brick and another giant antique hand hewn pine beam separating the kitchen from the living area. Boasting a split floor plan, the master suite and laundry room are on one side and the other bedrooms and office are on the other side, creating nice privacy for each space. The master suite is a great size and has a reading nook as well. The en suite is also ample size and features a jetted tub and oversized master shower. The bedrooms are large, which is a rare find these days and one of the bedrooms features a wall of built in bookshelves should you need an office space. One of the most beautiful touches in this home are the large custom windows in the kitchen and living area with views of the porches, the pool and beautiful Jack Fox Road. The impeccable millwork, custom touches, timeless finishes and excellent floor plan create such a welcoming place to call home. The backyard is also an oasis all on its own! With a giant back patio, it is perfect for entertaining or for sipping your morning coffee. The pool and fire pit are only four years old and feature so many little alcoves and options within the pool for entertaining or even lap swimming! The pool overlooks the rest of the yard and is truly a place of tranquility and beauty. Another item to note is that the home has a Generac whole home generator, which may come in handy during the stormy months. Once you step foot on this property, you will not want to leave, as 366 Lago feels like home and has so much to love and adore! Pictures don't do it justice, you must see for yourself!
MlsNumber: --
ListingId: 24008844


Listing Provided By: EXP Realty, LLC, original listing
Phone: (337) 522-7554
Office Phone: (337) 522-7554
Agent Name: Rachel Hebert
Disclaimer: Copyright © 2024 Realtor Association of Acadiana. 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