$229,900

404 Locust St Erlanger, KY 41018

Estimated payment $1,329/month

Total Views 645
2 Beds
1.5 Baths
1,218 Sq Ft
$189 Price per Sq Ft

Highlights

  • Cape Cod Architecture
  • Formal Dining Room
  • Bathtub
  • No HOA
  • Stainless Steel Appliances
  • 3-minute walk to Locust Street Park

About This Home

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.

Last Listed By

Matt Brock

Resource Realty Partners License #223022 Listed on: 05/30/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $467

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

Home Details

Home Type

Single Family

Est. Annual Taxes

$467

Year Built

Built in 1929

Lot Details

0

Listing Details

  • Cooling: Ductless, Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.37
  • Year Built: 1929
  • Lot Size: 95x167
  • Ownership: LLC
  • Directions: Erlanger exit - left - left on locust.
  • Architectural Style: Cape Cod
  • New Construction: No
  • Property Attached Yn: No
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: AJ Lindeman Elementary
  • Location Tax Legal Info:Middle or Junior School: Tichenor Middle School
  • Location Tax Legal Info:High School: Lloyd High
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: 95x167
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Duke
  • Utilities Gas Company: Duke
  • Water Company: NKY Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: No
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.3653
  • General Property Description:Living Area: 1218.0
  • General Property Description:Lot Size Square Feet: 15913.0
  • Location Tax Legal Info:Tax ID: 003-30-14-066.01
  • Appliances Refrigerators: Yes
  • Foundation:Block4: Yes
  • General Property Description:Fireplaces Total: 1
  • Laundry Features:In Basement: Yes
  • Architecture:Cape Cod: Yes
  • Levels:One and One Half: Yes
  • Cooling:Ductless: Yes
  • Special Features: None

Interior Features

  • Basement: Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: One and One Half
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Electric Range, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Total Bedrooms: 2
  • Fireplace Features: Inoperable
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 1218.0
  • Window Features: Vinyl Frames
  • Appliances Dishwasher: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Basement:Walk-Out Access7: Yes
  • Appliances:Electric Range: Yes
  • Fireplace Features:Inoperable: Yes
  • Basement:Concrete Flooring: Yes

Exterior Features

  • Roof: Shingle
  • Lot Features: Cleared
  • Construction Type: Vinyl Siding
  • Foundation Details: Block
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Vinyl Frames: Yes
  • Lot Features:Cleared: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway
  • Parking Features:Driveway: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: In Basement
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: 220 Volts
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: AJ Lindeman Elementary
  • Junior High Dist: Erlanger/Elsmere
  • High School: Lloyd High
  • Middle Or Junior School: Tichenor Middle School

Lot Info

  • Lot Size Sq Ft: 15913.0
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

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
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

Property History

Date Event Price Change Sq Ft Price
05/30/2025 05/30/25 For Sale $229,900 -- $189 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
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
Previous Owner $85,000 Construction
Previous Owner $50,000 Credit Line Revolving
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

Similar Homes in Erlanger, KY

  • 102 Stevenson Rd, Erlanger, KY 41018

    $225,000

    • 4 Beds
    • 1 Bath
    • 102 Stevenson Rd
    • Erlanger, KY

    100 percent Financing Available Through KY Housing! This true 4-bedroom home features a remodeled kitchen with granite countertops, stainless steel appliances, & tiled flooring, along with a renovated bathroom offering a custom tiled shower/tub & stylish finishes. Enjoy ample natural light, neutral decor, arched doorways, & maintenance-free vinyl plank flooring throughout. The home includes an

    Bradley Treas Huff Realty - Florence

    Section Image
  • 3408 Cowie Ave, Erlanger, KY 41018

    $259,900

    • 2 Beds
    • 2.5 Baths
    • 3408 Cowie Ave
    • Erlanger, KY

    Welcome to this beautiful, charming 2 bedroom, 2 1/2 bath home. With an open concept this home perfectly blends comfort and style. Imagine cooking in your updated kitchen and entertaining. SS appliances, granite counter tops and tile flooring. Enjoy the upstairs loft which can be used as a 3rd bedroom too. Huge fenced in yard, perfect for entertaining. Close to the highways and blocks away from

    Adam Kincer Keller Williams Realty Services

    Section Image
  • 136 Center St, Erlanger, KY 41018

    $255,000

    • 3 Beds
    • 2.5 Baths
    • 1,695 Sq Ft
    • 136 Center St
    • Erlanger, KY

    Adorable Cape Code 3 bed + 2.5 baths w/ OVERSIZED 2-car detached garage!!! 1695sqft living space! Home features wood & tile floors, large private owner's ensuite on 1st floor w/ tongue & groove wood ceilings, wood fireplace, front porch loads of parking. Water Heater ('21), Dishwasher ('23), microwave ('25), NEW 200 amp electric service & breaker panel (May '25). Bright, clean unfinished

    Traci Browne eXp Realty, LLC

    Section Image
  • 3506 Cowie Ave, Erlanger, KY 41018

    $214,900

    • 2 Beds
    • 1 Bath
    • 930 Sq Ft
    • 3506 Cowie Ave
    • Erlanger, KY

    Delightful all brick ranch w/relaxing front porch conveniently located right off I-75 & within 5 minutes of Crestview Hills Town Center! Oak laminate floors flow throughout this lovely home! Open floor plan welcomes you from the minute you step into a spacious living room w/brick fireplace which flows into a combined spacious kitchen/breakfast room. Lots of windows make this a home full of LIGHT,

    Frank Schmitt Huff Realty - CC

    Section Image
  • 3156 Hulbert Ave, Erlanger, KY 41018

    $175,000

    • 4 Beds
    • 1 Bath
    • 3156 Hulbert Ave
    • Erlanger, KY

    To be Sold As Is - Needs some TLC - This conveniently located Erlanger home has 4 bedrooms & 1 bath - Surprisingly bigger than it appears - Nice size level yard - Extended driveway for multiple vehicles - Hardwood floors on main level - Storm doors - Tile floor - Jack-n-Jill walk in closet - Little character niche's - Built-ins - Sump pump - Attic fan - A pleasant & easy walk to the Erlanger

    Pamela Brownfield Pulse Property Management, LLC

    Section Image
  • 3157 Woodward St, Erlanger, KY 41018

    $247,900

    • 3 Beds
    • 1.5 Baths
    • 3157 Woodward St
    • Erlanger, KY

    Minutes to CVG and minutes to I75/275. 3 bedroom ranch on nice deep lot. Lots of parking as well as a garage. Don't get caught with no place to park. Beautifully updated throughout. Luxury Vinyl Flooring in every room. Kitchen is redone with plenty of room for your cooking pleasure.Basement is unfinished but does have a half bath with room to add shower. NEW HVAC, Central Air, Hot Water Heater.

    Sue Ann Collins Teamwork Real Estate

    Section Image
  • 107 Timberlake Ave, Erlanger, KY 41018

    $269,900

    • 3 Beds
    • 2 Baths
    • 1,163 Sq Ft
    • 107 Timberlake Ave
    • Erlanger, KY

    Well-Maintained & Updated Capecod Style Home on Lovely Street*Beautifully Updated Kitchen*New Carpet 2025*New Roof 2024*Freshly Painted Interior*3 Bedrooms*2 Full Bathrooms*Carport*3 Seasons Room*Finsihed Basement*HVAC 2019*Gas Fireplace*Vinyl Replacement Windows*Awesome Backyard*Nice Landscaping*Large Covered Front Porch*A Great Place to Call Home

    Denise McCoy RE/MAX Victory + Affiliates

    Section Image
  • 420 James Ave, Erlanger, KY 41018

    $260,000

    • 3 Beds
    • 2 Baths
    • 1,054 Sq Ft
    • 420 James Ave
    • Erlanger, KY

    Charming all brick ranch in the heart of Erlanger! Welcome home to this beautifully maintained 3-bedrrom, 2 full bath home. Featuring gleaming hardwood floors throughout, can lighting, insulated vinyl windows, and 1 car garage. This home offers updated features but much of the original character of the home remains. enjoy cooking in the updated kitchen that connects to your spacious yard. The

    Aimee Pelletier Sibcy Cline, REALTORS-Florence

    Section Image
  • 176 Mcarthur Ln, Erlanger, KY 41018

    $224,000

    • 3 Beds
    • 1.5 Baths
    • 1,275 Sq Ft
    • 176 Mcarthur Ln
    • Erlanger, KY

    Charming 3 bedroom home in the heart of Erlanger. This cozy residence features a welcoming front porch, perfect for relaxing, and a spacious covered deck for outdoor entertainment. The fenced in back yard provides privacy and a great space for pets or entertaining. Don't miss out on this inviting home with the perfect blend of comfort and convenience.

    Blue Line Property Group Keller Williams Realty Services

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 632940

Northern Kentucky Multiple Listing Service

APN: 003-30-14-066.01