$279,900

415 Locust St Erlanger, KY 41018

Estimated payment $1,769/month

3 Beds
1 Bath
1,064 Sq Ft
$263 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • Vaulted Ceiling
  • Wood Flooring
  • City View
  • Ranch Style House
  • 4-minute walk to Locust Street Park

About This Home

Successful Short Term Rental in Erlanger being sold turn key with most furnishings! This 3 bed 2 full bath charming ranch with built in garage earned over $62,000 in gross rental income in the past year. Continue to use as a rental or make it your family's new home! The house was completely updated in 2021 and everything was replaced. HVAC, hardwood floors, kitchen, appliances, vaulted ceiling in Living Area, Marble countertops with tile backsplash, tile shower in basement, this home is basically all 5 years old. Great neighborhood and dead end street so very little traffic. Listing agent is the owner of the property.

Listing Agent

Travis Arnold

Coldwell Banker Realty FM License #294565 Listed on: 07/03/2026

Coldwell Banker Realty FM

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1967

Lot Details

  • 6,580 Sq Ft Lot
  • Lot Dimensions are 49 x 150
  • Cul-De-Sac
  • Land Lease

Parking

  • Driveway
  • Off-Street Parking

Property Views

  • City
  • Neighborhood

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Metal Roof

Interior Spaces

  • 1,064 Sq Ft Home
  • Vaulted Ceiling
  • Ceiling Fan
  • Fireplace
  • Vinyl Clad Windows
  • Family Room
  • Living Room
  • Smart Thermostat

Kitchen

  • Eat-In Gourmet Kitchen
  • Gas Range
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Concrete
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 1 Full Bathroom
  • Bathtub with Shower
  • Shower Only

Laundry

  • Laundry Room
  • 220 Volts In Laundry
  • Washer and Electric Dryer Hookup

Basement

  • Walk-Out Basement
  • Laundry in Basement

Outdoor Features

  • Patio
  • Fire Pit
  • Exterior Lighting
  • Shed

Schools

  • Aj Lindeman Elementary School
  • Tichenor Middle School
  • Lloyd High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1967

Lot Details

6,580 Sq Ft Lot

Parking

1

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.1511
  • Year Built: 1967
  • Lot Size: 49 x 150
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Agent/Owner
  • Directions: Erlanger exit, go east, turn left on Holman, then left on Locust St.
  • Architectural Style: Ranch
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Utilities Electric Company: Duke
  • Utilities Gas Company: Duke
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: No
  • Property Ownership:Property Ownership: Agent/Owner
  • Land Description:Land Description: Less than .5 Acre
  • Special Features: None

Interior Features

  • Interior Amenities: Ceiling Fan(s), Vaulted Ceiling(s), Eat-in Kitchen, Granite Counters, High Speed Internet, Smart Thermostat
  • Basement: Walk-Out Access, Full Finished Bath
  • Heating: Forced Air, Natural Gas
  • Levels: One
  • Property Type: Residential
  • Appliances: Disposal, Dishwasher, Refrigerator, Gas Range
  • Full Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace: No
  • Living Area: 1064.0
  • Window Features: Insulated Windows, Vinyl Clad Window(s)

Exterior Features

  • View: Neighborhood, City
  • Roof: Metal
  • Lot Features: Cul-De-Sac
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Lighting, Fire Pit
  • Foundation Details: Poured Concrete
  • Other Structures: Shed(s)
  • Patio And Porch Features: Patio

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Off Street

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Electric Dryer Hookup, Washer Hookup, Laundry Room, Lower Level, In Basement
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: 200+ Amp Service, 220 Volts in Laundry
  • Utilities: Cable Available, Natural Gas Available, Sewer Available

Condo/Co-op/Association

  • Association: 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

  • Land Lease: Yes
  • Lot Size Sq Ft: 6580.0

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $3,192 $242,000 $25,000 $217,000
2024 $3,231 $242,000 $25,000 $217,000
2023 $2,598 $200,000 $25,000 $175,000
2022 $2,909 $200,000 $20,000 $180,000
2021 $406 $23,000 $20,000 $3,000
2020 $404 $23,000 $20,000 $3,000
2019 $1,663 $113,000 $20,000 $93,000
2018 $1,697 $113,000 $15,000 $98,000
2017 $1,578 $113,000 $15,000 $98,000
2015 $1,502 $113,000 $15,000 $98,000
2014 $1,458 $113,000 $15,000 $98,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/03/2026 07/03/26 For Sale $279,900 +15.7% $263 / Sq Ft
02/21/2023 02/21/23 Sold $242,000 +0.8% $227 / Sq Ft View Prior Sale
01/14/2023 01/14/23 Pending -- -- --
01/10/2023 01/10/23 For Sale $240,000 -- $226 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed -- Northwest Title
Warranty Deed $200,000 None Available
Warranty Deed $23,000 Lawyers Ttl Of Cincinnati In
Special Warranty Deed $8,620 None Available
Deed $113,000 Kentucky Land Title Agency
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $181,500 New Conventional
Previous Owner $194,000 New Conventional
Previous Owner $113,000 New Conventional
Source: Public Records

Source: Northern Kentucky Multiple Listing Service

MLS Number: 644315

Northern Kentucky Multiple Listing Service

APN: 003-30-14-086.00

Your Personal Tour Guide

Ask me questions while you tour the home.