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.
Sold for $245,000
$245,000
404 Locust St, Erlanger, KY 41018
2beds
1,218sqft
Single Family Residence, Residential
Built in 1929
0.37 Acres Lot
$256,600 Zestimate®
$201/sqft
$1,775 Estimated rent
Home value
$256,600
$231,000 - $287,000
$1,775/mo
Zestimate® history
Owner options
List your home for rent
$1,775/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$1,775/mo
Rent Zestimate®
Refinance and save
$1,604/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$1,604/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Partially finished basementStylish tiled tub surroundInviting front porchSleek stainless steel appliancesWhite shaker soft-close cabinetsExpansive deckGranite countertops
Zillow last checked:
Listing updated:
Listed by:
Matthew Brock 859-445-8331,
Resource Realty Partners
Bought with:
Alexander Willet, 277844
Sibcy Cline, REALTORS-CC
Source: NKMLS,MLS#: 632940
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Primary bedroom
- Features: Ceiling Fan(s)
- Level: First
- Area: 121
- Dimensions: 11 x 11
Bedroom 2
- Features: Bath Adjoins
- Level: Second
- Area: 225
- Dimensions: 15 x 15
Bathroom 2
- Features: Full Finished Half Bath
- Level: Second
- Area: 16
- Dimensions: 4 x 4
Dining room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 121
- Dimensions: 11 x 11
Kitchen
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 180
- Dimensions: 18 x 10
Living room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 220
- Dimensions: 20 x 11
Primary bath
- Features: Tub
- Level: First
- Area: 45
- Dimensions: 5 x 9
Heating
- Forced Air
Cooling
- Ductless, Central Air
Appliances
- Included: Stainless Steel Appliance(s), Electric Range, Dishwasher, Microwave, Refrigerator
- Laundry: In Basement
Features
- Windows: Vinyl Frames
- Number of fireplaces: 1
- Fireplace features: Inoperable
Interior area
- Total structure area: 1,218
- Total interior livable area: 1,218 sqft
Property
Parking
- Parking features: Driveway
- Has uncovered spaces: Yes
Features
- Levels: Multi/Split
- Stories: 1
Lot
- Size: 0.37 Acres
- Dimensions: 95 x 167
- Features: Cleared
Details
- Parcel number: 0033014066.01
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Shingle
Condition
- New construction: No
- Year built: 1929
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Erlanger
Financial & listing details
- Price per square foot: $201/sqft
- Tax assessed value: $35,000
- Annual tax amount: $467
- Date on market: 10/19/2025
- Cumulative days on market: 2 days
Price history
| Date | Event | Price |
|---|---|---|
| 7/1/2025 | Sold | $245,000+6.6%$201/sqft |
Source:  NKMLS #632940 Report a problem | ||
| 6/1/2025 | Pending sale | $229,900$189/sqft |
Source: NKMLS #632940 Report a problem | ||
| 5/30/2025 | Listed for sale | $229,900+109%$189/sqft |
Source: NKMLS #632940 Report a problem | ||
| 4/3/2025 | Sold | $110,000+44.7%$90/sqft |
Source: Public Record Report a problem | ||
| 3/3/2010 | Sold | $76,000-12.4%$62/sqft |
Source: Public Record Report a problem | ||
| 12/9/2009 | Listed for sale | $86,800+18.4%$71/sqft |
Source: CENTURY 21 Garner Properties #379532 Report a problem | ||
| 7/20/2009 | Sold | $73,335-36.8%$60/sqft |
Source: Public Record Report a problem | ||
| 7/5/2006 | Sold | $116,000+16%$95/sqft |
Source: Public Record Report a problem | ||
| 3/15/2002 | Sold | $100,000+37%$82/sqft |
Source: Public Record Report a problem | ||
| 3/4/1997 | Sold | $73,000$60/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $467 +2.8% | $35,000 |
| 2023 | $455 -62.4% | $35,000 -58.1% |
| 2022 | $1,209 -1.5% | $83,600 |
| 2021 | $1,227 -21% | $83,600 |
| 2020 | $1,553 | $83,600 |
| 2019 | $1,553 +10% | $83,600 +10% |
| 2018 | $1,412 | $76,000 |
| 2017 | $1,412 +39.7% | $76,000 |
| 2015 | $1,010 | $76,000 |
| 2014 | $1,010 +3% | $76,000 |
| 2013 | $981 | $76,000 |
| 2012 | -- | $76,000 |
| 2011 | -- | $76,000 |
| 2010 | -- | $76,000 -34.5% |
| 2009 | -- | $116,000 |
| 2008 | -- | $116,000 |
| 2007 | -- | $116,000 +16% |
| 2006 | -- | $100,000 |
| 2005 | -- | $100,000 |
| 2004 | -- | $100,000 |
| 2003 | -- | $100,000 +33% |
| 2002 | -- | $75,200 +3% |
| 2001 | -- | $73,000 |
| 2000 | -- | $73,000 |
Find assessor info on the county website
Neighborhood: 41018
Nearby homes
- $221,6003 bd2 ba999 sqft406 Locust St, Erlanger, KY 41018Off Market
- $164,1002 bd1 ba936 sqft3310 Hulbert Ave, Erlanger, KY 41018Off Market
- $136,0002 bd1 ba1.1k sqft3306 Hulbert Ave, Erlanger, KY 41018For Sale
- $170,0003 bd1 ba1.4k sqft402 Locust St, Erlanger, KY 41018Sold
- $143,4002 bd1 ba1.1k sqft407 Center St, Erlanger, KY 41018Off Market
- $217,2003 bd2 ba1.2k sqft409 Center St, Erlanger, KY 41018Off Market
- $229,4003 bd2 ba1.5k sqft410 Locust St, Erlanger, KY 41018Off Market
- $225,0004 bd2 ba1.2k sqft403 Locust St, Erlanger, KY 41018Sold
Nearby schools
GreatSchools rating
- 7/10Lindeman Elementary SchoolGrades: K-5Distance: 0.4 mi
- 5/10Tichenor Middle SchoolGrades: 6-8Distance: 0.4 mi
- 4/10Lloyd High SchoolGrades: 9-12Distance: 0.3 mi
Schools provided by the listing agent
- Elementary: AJ Lindeman Elementary
- Middle: Tichenor Middle School
- High: Lloyd High
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$256,600
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$256,600
- Kentucky
- Kenton County
- Erlanger
- 41018
- 404 Locust St
Nearby cities
Nearby zip codes
Other Erlanger Topics
