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
$252,600 Zestimate®
$201/sqft
$1,496 Estimated rent
Home value
$252,600
$230,000 - $278,000
$1,496/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$1,496/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$1,496/mo
Rent Zestimate®
Refinance and save
$1,234/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$1,234/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
Zillow last checked: 7 hours ago
Listing updated: September 16, 2025 at 10:25pm
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 & neighborhood
Location
- Region: Erlanger
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 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2023 | $455 -62.4% | $35,000 -58.1% |
| 2022 | $1,209 -1.5% | $83,600 |
| 2021 | $1,227 -21% | $83,600 |
Find assessor info on the county website
Neighborhood: 41018
Nearby schools
GreatSchools rating
- 5/10Lindeman Elementary SchoolGrades: K-5Distance: 0.4 mi
- 4/10Tichenor Middle SchoolGrades: 6-8Distance: 0.3 mi
- 7/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
$252,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
$252,600
- Kentucky
- Kenton County
- Erlanger
- 41018
- 404 Locust St