Seller's Agent in 2025
Matt Brock
Resource Realty Partners
(859) 445-8331
13 in this area
123 Total Sales
404 Locust St Erlanger, KY 41018
2
Beds
1.5
Baths
1,218
Sq Ft
16,117
Sq Ft Lot
Highlights
- Cape Cod Architecture
- Formal Dining Room
- Bathtub
- No HOA
- Stainless Steel Appliances
- 3-minute walk to Locust Street Park
About This Home
As of July 2025Welcome 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.
Last Agent to Sell the Property
Resource Realty Partners License #223022 Listed on: 05/30/2025
Home Details
Home Type
- Single Family
Year Built
- Built in 1929
Lot Details
- 0.37 Acre Lot
- Lot Dimensions are 95x167
- Cleared Lot
Parking
- Driveway
Home Design
- Cape Cod Architecture
- Block Foundation
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 1,218 Sq Ft Home
- 1.5-Story Property
- Ceiling Fan
- Non-Functioning Fireplace
- Vinyl Clad Windows
- Living Room
- Formal Dining Room
Kitchen
- Electric Range
- Microwave
- Dishwasher
- Stainless Steel Appliances
Flooring
- Concrete
- Luxury Vinyl Tile
Bedrooms and Bathrooms
- 2 Bedrooms
- En-Suite Bathroom
- Bathtub
Basement
- Walk-Out Basement
- Laundry in Basement
Schools
- Aj Lindeman Elementary School
- Tichenor Middle School
- Lloyd High School
Utilities
- Ductless Heating Or Cooling System
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- 220 Volts
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 003-30-14-066.01
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 30, 2025
Closed on
Jul 1, 2025
Sold by
Resolve Properties Llc
Bought by
Garrett Charlene R
Seller's Agent
Matt Brock
Resource Realty Partners
Buyer's Agent
Alexander Willet
Sibcy Cline, REALTORS-CC
List Price
$229,900
Sold Price
$245,000
Premium/Discount to List
$15,100
6.57%
Views
48
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$3,506
Avg. Annual Appreciation
-1.96%
Original Mortgage
$171,500
Outstanding Balance
$171,210
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
$70,284
Purchase Details
Closed on
Mar 27, 2025
Sold by
Cuthbertson Investments Llc
Bought by
Resolve Properties Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$161,120
Interest Rate
6.04%
Mortgage Type
Construction
Purchase Details
Closed on
Aug 18, 2021
Sold by
Foster Matthew R and Foster Charlene
Bought by
Cuthbertson Investments Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$85,000
Interest Rate
2.8%
Mortgage Type
Construction
Purchase Details
Closed on
Feb 2, 2010
Sold by
The Bank Of New York Mellon
Bought by
Foster Matthew R
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$67,155
Interest Rate
5.5%
Mortgage Type
FHA
Purchase Details
Closed on
Jul 6, 2009
Sold by
Clark Kathleen M
Bought by
The Bank Of New York Mellon
Purchase Details
Closed on
Jun 20, 2006
Sold by
Jones Kristina M and Jones Larry Michael
Bought by
Clark Kathleen M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$29,000
Interest Rate
6.55%
Mortgage Type
Stand Alone Second
Purchase Details
Closed on
Mar 15, 2002
Sold by
Eicher Mark E
Bought by
Jones Kristina M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$80,000
Interest Rate
6.98%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 4, 1997
Sold by
Mann James M
Bought by
Eicher Mark E and Eicher Kimberly A
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$72,955
Interest Rate
7.91%
Mortgage Type
FHA
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 | $245,000 | Springs Title | |
| Warranty Deed | $110,000 | None Listed On Document | |
| Warranty Deed | $110,000 | None Listed On Document | |
| Warranty Deed | $35,000 | None Available | |
| Special Warranty Deed | $76,000 | Thoroughbred Title Agency | |
| Commissioners Deed | $73,335 | None Available | |
| Deed | $116,000 | Heritage Title Services Llc | |
| Deed | $100,000 | -- | |
| Deed | $73,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $171,500 | New Conventional | |
| Previous Owner | $161,120 | Construction | |
| Previous Owner | $85,000 | Construction | |
| Previous Owner | $67,155 | FHA | |
| Previous Owner | $29,000 | Stand Alone Second | |
| Previous Owner | $87,000 | Purchase Money Mortgage | |
| Previous Owner | $80,000 | New Conventional | |
| Previous Owner | $72,955 | FHA |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 07/01/2025 07/01/25 | Sold | $245,000 | +6.6% | $201 / Sq Ft |
| 06/01/2025 06/01/25 | Pending | -- | -- | -- |
| 05/30/2025 05/30/25 | For Sale | $229,900 | -- | $189 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
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 |
|---|---|---|---|---|
| 2025 | $462 | $35,000 | $25,000 | $10,000 |
| 2024 | $467 | $35,000 | $25,000 | $10,000 |
| 2023 | $455 | $35,000 | $25,000 | $10,000 |
| 2022 | $1,260 | $83,600 | $20,000 | $63,600 |
| 2021 | $1,277 | $83,600 | $20,000 | $63,600 |
| 2020 | $1,269 | $83,600 | $20,000 | $63,600 |
| 2019 | $1,250 | $83,600 | $20,000 | $63,600 |
| 2018 | $1,166 | $76,000 | $15,000 | $61,000 |
| 2017 | $1,062 | $76,000 | $15,000 | $61,000 |
| 2015 | $1,010 | $76,000 | $15,000 | $61,000 |
| 2014 | $981 | $76,000 | $15,000 | $61,000 |
Source: Public Records
Agents Affiliated with this Home
-
Matt Brock
-
Alexander Willet
Buyer's Agent in 2025
Alexander Willet
Sibcy Cline
(859) 628-8045
1 in this area
38 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 632940
APN: 003-30-14-066.01
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.
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Ten-X are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers.
Listing information is deemed reliable, but not guaranteed.
Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 3506 Home St
- 314 Mcalpin Ave
- 444 Mcalpin Ave
- 3314 Elizabeth St
- 11 May St
- 4112 Lloyd Ave
- 328 Sunset Ave
- 334 Stevenson Rd
- 4120 Dixie Hwy
- 417 Timberlake Ave
- 4215 Lafayette Ct
- 617 Bedinger St
- 215 Cave Run Dr Unit 2
- 841 Virginiabradford Ct
- 505 Stevenson Rd
- 129 Barren River Dr Unit 9
- 4117-4127 Dixie Hwy
- 25 Beech Dr
- 130 Buckhorn Ct Unit 8
- 712 Bedinger St
Your Personal Tour Guide
Ask me questions while you tour the home.