Yuliana Guerrero
eXp Realty
(331) 321-4774
98 Total Sales
1 in Columbia
$147,000 Price
5537 24th Ave Kenosha, WI 53140
Columbia NeighborhoodEstimated Value: $230,000 - $254,021
3
Beds
1.5
Baths
1,600
Sq Ft
$152/Sq Ft
Est. Value
Highlights
- Property is near public transit
- Fenced Yard
- High Speed Internet
- Gazebo
- Forced Air Heating System
- Electric Fireplace
About This Home
As of January 2026Fall in love with this fully remodeled home in a prime Kenosha location! 3 bedrooms, 1.5 bath home in a convenient Kenosha location near shops, parks, and dining. Inside, enjoy updated flooring, newer windows, newer water heater, newer furnace, stainless steel appliances, and a stunning built-in electric fireplace! Sitting on a spacious lot with a pergola and patio, this home offers the perfect blend of comfort, updates, and outdoor enjoyment! Don't miss out on this one!
Last Agent to Sell the Property
Realty Executives Integrity~Brookfield Brokerage Email: brookfieldfrontdesk@realtyexecutives.com License #89098-94 Listed on: 12/15/2025
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $2,966
Lot Details
- 6,970 Sq Ft Lot
- Fenced Yard
Parking
- No Garage
Home Design
- Vinyl Siding
Interior Spaces
- 1,600 Sq Ft Home
- 2-Story Property
- Electric Fireplace
- Basement Fills Entire Space Under The House
Kitchen
- Oven
- Range
- Microwave
Bedrooms and Bathrooms
- 3 Bedrooms
Laundry
- Dryer
- Washer
Schools
- Edward Bain Sch Dual Language Elementary School
- Bullen Middle School
- Bradford High School
Utilities
- Forced Air Heating System
- Heating System Uses Natural Gas
- High Speed Internet
Additional Features
- Gazebo
- Property is near public transit
Listing and Financial Details
- Exclusions: Sellers Personal Property
- Assessor Parcel Number 0922236477007
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Jun 29, 2023
Sold by
Bought by
Current Estimated Value
Purchase Details
Listed on
May 19, 2022
Closed on
May 25, 2022
Sold by
Bought by
Seller's Agent
James Rondon
Rondon Real Estate LLC
Buyer's Agent
Shannyn Franklin
Sensibl Realty
List Price
$75,000
Sold Price
$75,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
32.45%
Purchase Details
Listed on
May 19, 2022
Closed on
May 13, 2022
Sold by
Bought by
Seller's Agent
James Rondon
Rondon Real Estate LLC
Buyer's Agent
Shannyn Franklin
Sensibl Realty
List Price
$75,000
Sold Price
$75,000
Purchase Details
Listed on
May 19, 2022
Closed on
Apr 28, 2022
Sold by
Bought by
Seller's Agent
James Rondon
Rondon Real Estate LLC
Buyer's Agent
Shannyn Franklin
Sensibl Realty
List Price
$75,000
Sold Price
$75,000
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Columbia, WI
-
Yuliana Guerrero
-
Ben Gentile
Ben Gentile
Epique Realty Inc
(262) 300-7348
128 Total Sales
1 in Columbia
$170,000 Price
-
Alissa Traughber
Alissa Traughber
Keller Williams Thrive-Kenosha
(262) 383-3044
152 Total Sales
2 in Columbia
$205K - $225K Price Range
-
Rebecca Taylor
Rebecca Taylor
Century 21 Affiliated
(224) 505-1778
69 Total Sales
3 in Columbia
$107K - $290K Price Range
-
Lou Ann Pitts
Lou Ann Pitts
Bear Realty Of Burlington
(262) 300-5680
74 Total Sales
2 in Columbia
$30K - $105K Price Range
-
Susan Fellows
Susan Fellows
The Real Estate Edge, LLC
(262) 361-1586
73 Total Sales
2 in Columbia
$117K - $226K Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $219,000 | Landmark Title Kenosha, A Divi | ||
| $75,000 | Yesenia Garduno | ||
| $50,000 | Jeffrey P Milkie | ||
| $35,000 | Landmark Title Kenosha |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 01/16/2026 01/16/26 | Sold | $240,000 | 0.0% | $150 / Sq Ft | |
| 12/15/2025 12/15/25 | For Sale | $240,000 | +9.6% | $150 / Sq Ft | |
| 07/02/2023 07/02/23 | Off Market | $219,000 | -- | -- | |
| 04/28/2023 04/28/23 | For Sale | $219,000 | +192.0% | $137 / Sq Ft | |
| 05/27/2022 05/27/22 | Sold | $75,000 | 0.0% | $47 / Sq Ft | View Prior Sale |
| 05/20/2022 05/20/22 | Pending | -- | -- | -- | |
| 05/19/2022 05/19/22 | For Sale | $75,000 | -- | $47 / Sq Ft |
Source: Metro MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2025 | $2,966 | $177,100 | $22,000 | $155,100 |
| 2024 | $1,585 | $65,800 | $15,500 | $50,300 |
| 2023 | $1,585 | $65,800 | $15,500 | $50,300 |
| 2022 | $1,753 | $65,800 | $15,500 | $50,300 |
| 2021 | $1,652 | $65,800 | $15,500 | $50,300 |
| 2020 | $1,525 | $65,800 | $15,500 | $50,300 |
| 2019 | $1,768 | $65,800 | $15,500 | $50,300 |
| 2018 | $1,746 | $60,300 | $15,500 | $44,800 |
| 2017 | $1,864 | $60,300 | $15,500 | $44,800 |
| 2016 | $1,435 | $60,300 | $15,500 | $44,800 |
| 2015 | $1,404 | $56,600 | $16,500 | $40,100 |
| 2014 | $1,386 | $56,600 | $16,500 | $40,100 |
Source: Public Records
Agents Affiliated with this Home
-
One Roof RE Group*
Seller's Agent in 2026
One Roof RE Group*
Realty Executives Integrity~Brookfield
(262) 527-5817
1 in this area
137 Total Sales
-
James Loftus
J
Buyer's Agent in 2026
James Loftus
Vantage Realty
(773) 573-9053
1 in this area
28 Total Sales
-
Shannyn Franklin
Buyer's Agent in 2023
Shannyn Franklin
RE/MAX
(262) 960-5182
1 in this area
59 Total Sales
-
James Rondon
J
Seller's Agent in 2022
James Rondon
Rondon Real Estate LLC
(262) 308-8700
8 in this area
85 Total Sales
Map
Source: Metro MLS
MLS Number: 1944858
APN: 09-222-36-477-007
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.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
IDX listing data provided by Multiple Listing Service, Inc. Information is supplied by seller and other third parties and has not been verified.
Copyright 2026 – Multiple Listing Service, Inc. – All Rights Reserved.
Nearby Homes
- 5529 24th Ave
- 5541 24th Ave
- 5525 24th Ave
- 2306 56th St
- 5530 23rd Ave
- 5519 24th Ave
- 5526 23rd Ave
- 2300 56th St
- 5522 23rd Ave
- 5513 24th Ave
- 5514 23rd Ave
- 5518 24th Ave
- 5507 24th Ave
- 5510 23rd Ave
- 5512 24th Ave
- 5506 23rd Ave
- 5506 23rd Ave Unit 1 - Lower
- 5506 23rd Ave Unit 2 - Upper
- 2222 56th St
- 5506 24th Ave
Your Personal Tour Guide
Ask me questions while you tour the home.