#629900, Adam Kincer, Listing Office: Keller Williams Realty Services
404 Locust St Erlanger, KY 41018
Property details
About 404 Locust St
Welcome to 404 Locust Street in Erlanger—a beautifully updated 2-bedroom, 1.5-bath home that blends charm and modern comfort. Step inside to discover a stunning kitchen featuring granite countertops, white shaker soft-close cabinets, and sleek stainless steel appliances. The full bathroom boasts a stylish tiled tub surround and all-new fixtures. Both bedrooms are generously sized, offering plenty of room to relax. The partially finished basement provides a flexible space that could easily serve as a third bedroom, home office, or quiet study. Enjoy quiet mornings or evening chats from your inviting front porch as the world rolls by. Out back, you'll find a massive backyard and an expansive deck that's perfect for entertaining or unwinding. Furnace/AC brand new, New roof and all new windows. With all-new concrete in the driveway and ample parking, this home checks all the boxes.
Highlights
(Pending)
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 1
- Appliances: Stainless Steel Appliance(s), Electric Range, Dishwasher, Microwave, Refrigerator
- Basement: Yes
- Fireplace: Inoperable
- Total Bedroom Count: 2
- Parking: Driveway
- Architectural Style: Cape Cod
- Heating: Natural Gas, Forced Air
- Cooling: Ductless, Central Air
- List Price: $229,900
- Price/SqFt: $188
- Annual Tax Amount: $454
- Tax Year: 2023
- Lot: Cleared
- Directions: Erlanger exit - left - left on locust.
- Year Built: 1929
- Living Area: 1,218 SqFt
- Lot Size: 0.37 Acres
- MLS Number: 632940
- MLS Name: Northern Kentucky Multiple Listing Service
- Office Name: Resource Realty Partners
- Office Phone: (859) 445-8331
- Office Email: mattb@resourcerealtypartners.com
- Listing Agent: Matthew Brock
Disclaimer: The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. (NKMLS). Real estate listings held by other brokerage firms are marked with the Broker Reciprocity Logo and detailed information about them includes the name of the listing broker. The broker providing the data believes the data to be correct, but advises interested parties to confirm the data before relying on it in a purchase decision. MLS content and images © Copyright ©2025, Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
The information on this web site is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. We are not responsible or liable for misinformation, misprints, or typographical errors. All information provided is deemed reliable but is not guaranteed and should be independently verified through personal inspection by and/or with the appropriate professionals. Properties subject to prior sale, change, withdrawal or rental.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 6/2/2025, 9:20:33 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$229,900
404 Locust St
$2,730
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
Date | Event | Price |
---|---|---|
Sep 10, 2021 | Home Sold | $35,000 |
Mar 03, 2010 | Home Sold | $76,000 |
Jul 05, 2006 | Home Sold | $116,000 |
Tax history
Year | Assessment | Property Tax |
---|---|---|
2023 | $35,000 | $454 |
2022 | $83,600 | $1,208 |
2021 | $83,600 | $1,558 |
2020 | $83,600 | $1,558 |
2019 | $83,600 | $1,166 |
2018 | $76,000 | $1,166 |
2017 | $76,000 | $1,061 |
History based on county public records data.
Nearby schools
5
Lindeman Elementary School
Public District KG-5
0.4 mi
•558 Erlanger Rd
3
Miles Elementary School
Public District KG-5
0.8 mi
•208 Sunset Ave
3
Howell Elementary School
Public District KG-5
1.2 mi
•909 Central Row Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $62,854. The majority of Erlanger, KY residents have income between $35k-100k annually. Typical family type is single, no kids. The most common level of education of people living in this area is post secondary degree.
Similar homes for sale
Frequently asked questions
About 404 Locust St
The listing price of 404 Locust St property is $229,900.
The property 404 Locust St is a house located in Erlanger, Kentucky, 41018.
Sale Pending: 404 Locust St is Sale Pending (Pending), which means that the seller has accepted an offer but the sale is not finalized.
The nearby schools for 404 Locust St are: Lindeman Elementary School (GreatSchools Rating 5/10), Miles Elementary School (GreatSchools Rating 3/10), Howell Elementary School (GreatSchools Rating 3/10), Tichenor Middle School (GreatSchools Rating 3/10), Turkey Foot Middle School (GreatSchools Rating 5/10), Rector A. Jones Middle School (GreatSchools Rating 2/10), Lloyd High School (GreatSchools Rating 6/10), Dixie Heights High School (GreatSchools Rating 6/10), Boone County High School (GreatSchools Rating 4/10).
According to the records, the last property tax for 2023 is $454 (source: MLS/based on county public records data).
The last sale was on September 10, 2021 for $35,000 (source: MLS/tax record).
The property at 404 Locust St has 2 bedrooms and 1 full and 1 half bathrooms.
The property 404 Locust St is 1,218 SqFt (source: MLS/tax record).
The year of construction for 404 Locust St is 1929.
This home is located at 404 Locust St in Erlanger, KY and zip code 41018. This 1,218 square foot home, which was built in 1929, sits on a 0.37 acre lot. Features: 2 bedrooms, 2 bathrooms. It has been listed on Rocket Homes since May 30, 2025 and is currently priced at $229,900.
The number of homes for sale in Erlanger, KY increased by 227.8% between April and May 2025. The median list price of listings available in May 2025 was $264,800, while the average time on the real estate market was 41 days.