Welcome to this beautifully updated 3-bedroom, 2-bathroom home on piers ideally situated right off Kaliste Saloom directly across from the Heart Hospital. Whether you're looking for a cozy home or a high-visibility commercial space, this property offers unmatched versatility and opportunity! Inside, you'll find charming tongue and groove ceilings throughout, rich wood flooring, and a modern kitchen with granite countertops that blends style and functionality. One of the rooms is currently income-producing, offering immediate value to investors or homeowners seeking supplemental income. This location is a dream, just minutes from everything Lafayette has to offer and perfect for a variety of uses. Already zoned residential mixed use, this property could easily be transformed into a law office, chiropractic clinic, massage therapy practice, boutique retail shop, or more with a commercial zoning upgrade.Whether you're looking for your next home, a live/work space, or a business opportunity in one of Lafayette's most high-traffic areas, this property delivers.Don't miss your chance to own a piece of prime real estate with endless possibilities!