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

725 N Columbia Street
Bogalusa, LA 70427

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2885
Agency: Downtown Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1954
Notes: Introducing a rare find in a highly desirable location! This beautifully renovated 1954-built two-story home exudes charm & offers a perfect blend of classic elegance & modern comforts. Boasting a spacious layout, this residence features 4 bedrooms & 2.5 baths, ensuring ample space for relaxation & privacy. Step inside to discover a meticulously updated interior that seamlessly combines timeless character with contemporary finishes. The thoughtful renovations have enhanced the home's appeal, providing a stylish & comfortable living experience. With attention to detail evident in every corner, this residence exudes an inviting atmosphere that's sure to impress. One of the standout features of this remarkable home is its mother-in-law apartment, adding flexibility & versatility to your living arrangements. Great for multi-generational families or as an income-generating unit, this addition sets this property apart from the rest. The distinctive slate roof not only adds an air of sophistication but also ensures durability & longevity, showcasing the exceptional craftsmanship of the era. A true testament to the home's quality and history. An unexpected bonus awaits with the inclusion of an elevator, providing easy access to all levels. This convenient feature enhances the home's functionality, making it an ideal choice for those seeking a residence that accommodates all stages of life. Nestled in a highly coveted location, this property offers the best of both worlds - a peaceful, serene neighborhood while being in close proximity to amenities, schools, and city life. Enjoy the convenience of nearby shopping, dining, & entertainment options, making everyday living a breeze. Don't miss this extraordinary opportunity to own a piece of history that has been tastefully updated for modern living. Embrace the charm, elegance, & flexibility of this exceptional, Andrew M Lockett, Jr designed home that truly stands out from the crowd. Experience the timeless allure for yourself!
MlsNumber: 2429932


Listing Provided By: Downtown Realty, original listing
Name: Downtown Realty
Phone: (985) 634-6434
Office Name: Downtown Realty
Office Phone: (985) 634-6434
Agent Name: Suzanne Bourne
Disclaimer: Copyright © 2024 Gulf South Real Estate Information Network. 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