Seller's Agent in 2025
Matthew Stieffel
Coldwell Banker Alfonso Realty-BSL
(228) 224-5530
78 in this area
223 Total Sales
Last list price
507 Main St Bay Saint Louis, MS 39520
3
Beds
2.5
Baths
2,742
Sq Ft
0.44
Acres
Highlights
- No HOA
- Window Unit Cooling System
- Central Heating and Cooling System
- Waveland Elementary School Rated 10
- 1-Story Property
About This Home
As of August 2025Live in the center of Bay St. Louis and have rental income also! Prime Investment Opportunity - Versatile Property with two detached rental units! Don't miss this incredible investment opportunity in the heart of town! This unique property features a 3-bedroom, 2.5-bath main house with covered parking, plus a duplex in the back—perfect for generating rental income. Situated on a large lot with a storage shed, this property offers both residential and commercial potential. With its high elevation and C-2 commercial zoning, the possibilities are endless! Use it as a primary residence with rental income, or take advantage of the zoning for a catering business, retail shop, antique store, art gallery, hair salon, and more. Conveniently located in the center of town, this property provides easy access to major roads, shopping, dining, and business hubs. Whether you're an investor, entrepreneur, or homebuyer looking for flexibility, this property is a rare find!
Last Agent to Sell the Property
Coldwell Banker Alfonso Realty-BSL License #S49640 Listed on: 02/24/2025
Property Details
Home Type
- Multi-Family
Est. Annual Taxes
- $1,549
Year Built
- Built in 1996
Lot Details
- 0.44 Acre Lot
Home Design
- Pillar, Post or Pier Foundation
- Slab Foundation
- Metal Roof
- Stucco
Interior Spaces
- 2,742 Sq Ft Home
- 1-Story Property
- Den with Fireplace
Kitchen
- Gas Range
- Dishwasher
Bedrooms and Bathrooms
- 3 Bedrooms
Parking
- 4 Parking Spaces
- 1 Carport Space
- Varies By Unit
- Driveway
Utilities
- Window Unit Cooling System
- Central Heating and Cooling System
- Natural Gas Connected
- Gas Water Heater
- Cable TV Available
Community Details
- No Home Owners Association
- Metes And Bounds Subdivision
Listing and Financial Details
- Assessor Parcel Number 149e-0-29-293.000
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Feb 24, 2025
Closed on
Aug 15, 2025
Sold by
Siekmann Susan M
Bought by
507 On Main Llc
Seller's Agent
Matthew Stieffel
Coldwell Banker Alfonso Realty-BSL
Buyer's Agent
Andrew Harwell
Trifecta Real Estate, LLC
List Price
$529,000
Views
48
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1273.59%
Original Mortgage
$1,452,388
Outstanding Balance
$1,452,388
Interest Rate
6.72%
Mortgage Type
Construction
Estimated Equity
-$1,009,315
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | -- | Pilger Title | |
| Warranty Deed | -- | Pilger Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,452,388 | Construction | |
| Closed | $1,452,388 | Construction | |
| Previous Owner | $198,200 | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 08/15/2025 08/15/25 | Sold | -- | -- | -- |
| 05/24/2025 05/24/25 | Pending | -- | -- | -- |
| 04/27/2025 04/27/25 | Price Changed | $399,000 | -16.7% | $146 / Sq Ft |
| 04/12/2025 04/12/25 | Price Changed | $479,000 | -4.0% | $175 / Sq Ft |
| 03/18/2025 03/18/25 | Price Changed | $499,000 | -5.7% | $182 / Sq Ft |
| 02/24/2025 02/24/25 | For Sale | $529,000 | -- | $193 / Sq Ft |
Source: MLS United
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $2,351 | $20,438 | $5,194 | $15,244 |
| 2023 | $2,304 | $20,035 | $5,194 | $14,841 |
| 2022 | $1,442 | $20,035 | $5,194 | $14,841 |
| 2021 | $1,426 | $20,035 | $5,194 | $14,841 |
| 2020 | $1,132 | $16,477 | $5,194 | $11,283 |
| 2019 | $1,125 | $16,477 | $5,194 | $11,283 |
| 2018 | $1,125 | $16,477 | $5,194 | $11,283 |
| 2017 | $1,118 | $16,566 | $5,194 | $11,372 |
| 2016 | $1,095 | $16,566 | $5,194 | $11,372 |
| 2015 | $943 | $15,531 | $5,194 | $10,337 |
| 2014 | $2,126 | $20,725 | $10,388 | $10,337 |
| 2013 | $1,249 | $14,229 | $4,155 | $10,074 |
Source: Public Records
Agents Affiliated with this Home
-
Matthew Stieffel
-
Kaleb Allen
Seller Co-Listing Agent in 2025
Kaleb Allen
Coldwell Banker Alfonso Realty-BSL
12 in this area
30 Total Sales
-
Andrew Harwell
A
Buyer's Agent in 2025
Andrew Harwell
Trifecta Real Estate, LLC
(601) 966-2454
2 in this area
7 Total Sales
Map
Source: MLS United
MLS Number: 4104699
APN: 149E-0-29-293.000
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information is deemed to be reliable but not guaranteed. Copyright 2025 MLS United, LLC.
Nearby Homes
- 530 Easterbrook St
- 426 Demontluzin Ave
- 434 Saint John St
- 522 Genin St
- 306 Union St
- 414 Demontluzin Ave
- 421 Carroll Ave
- 699 Dunbar Ave
- 406 Easterbrook St
- 354 Main St
- 350 State St
- 342 Main St
- 336 State St Unit A & B
- 329 Demontluzin Ave
- 310 Union St
- 405 Ulman Ave
- 633 Keller St
- 713 Union St
- 298 Union St
- 321 Saint George St