404 Hazen Street

—Sq. Ft.
— / Sq. Ft.
—
Sq. Ft.
—
per Sq. Ft.

Description

What if your next home felt completely brand new without the wait? Welcome to this fully renovated all-brick 3 bed, 2 full bath ranch in the heart of Covington/Ludlow area, where every detail has already been thoughtfully upgraded for you. From the moment you arrive, the curb appeal sets the tone--freshly painted brick, modern shutters, and a sleek full-pane glass front door with built-in blinds. Step inside and you're greeted by gorgeous refinished hardwood floors, recessed lighting, ceiling fans,...What if your next home felt completely brand new without the wait? Welcome to this fully renovated all-brick 3 bed, 2 full bath ranch in the heart of Covington/Ludlow area, where every detail has already been thoughtfully upgraded for you. From the moment you arrive, the curb appeal sets the tone--freshly painted brick, modern shutters, and a sleek full-pane glass front door with built-in blinds. Step inside and you're greeted by gorgeous refinished hardwood floors, recessed lighting, ceiling fans, custom built-ins, and a bright, modern flow that just feels right. The kitchen is a true standout--crisp white soft-close cabinetry, a pantry with pull-out drawers, butcher block countertops, matte black fixtures, and all new stainless steel appliances. It's the perfect blend of style and function. Both full bathrooms have been beautifully updated, including a tiled shower on the main level and a second full bath in the newly finished lower level. And speaking of the lower level--this is where the flexibility really shines. With brand new wall-to-wall carpeting, this space can easily function as a private bedroom suite, guest retreat, or additional living area...or all of the above. Behind the walls, the peace of mind continues with all new electric, plumbing, furnace, A/C, and water heater--big-ticket items already handled. Outside, enjoy private 2-car off-street parking and a seasonal view of downtown Cincinnati. Location? It's tough to beat--just minutes to all things Covington, Newport, Bellevue, and all the dining, entertainment, and energy of downtown Cincinnati! Don't wait - come check it out!
  1. Listed by Jarret Iseral • Re/Max United Associates
    P: (859)-462-5762 C: (859)-462-5762 jarret.iseral@remax.net

Property Details for 404 Hazen Street

Architectural Style
Ranch
LISTING CLOSED: 04/30/2026 12:00 AM

Property Details for 404 Hazen Street

StatusSold
MLS #640913
Days on Market3
Taxes-
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built-
Lot Size0.15 AC / 6,534 SF
CountyKenton County

Location

Listing Courtesy of Re/Max United Associates

Sold By Epique Realty

Add your commute

Building Information for 404 Hazen Street

Stories-Year Built-Building Size-Lot Size0.15 AC / 6,534 SF

Payment Calculator

$1,509 per month

30 year fixed, 6.36% Interest

Principal and Interest

$1,395

Property Taxes

$114

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 404 Hazen Street

Summary
Location and General Information
  • Longitude: -84.540691
  • Latitude: 39.089542
  • Directions: Highway Avenue to LEFT on River's Breeze Drive LEFT on Hazen (property driveway is off of River's Breeze Drive)
  • MLSArea Major: K02 - Bromley/Ludlow Area
  • MLSArea Minor: K02 - Bromley/Ludlow Area
  • Year Built Known: No
  • Property Condition Disclosure: Yes
  • SIC: LU - Ludlow
Taxes and HOA
  • Association: No
  • Parcel Number: 040-12-02-018.00
  • Tax Rate: 17.99
School Information
  • High School District: Ludlow Indep
  • Elementary School: Mary A. Goetz Elementary
  • Middle Or Junior School: Ludlow Middle School
  • High School: Ludlow High
Parking
  • Parking Features: Driveway, Off Street
  • Attached Garage: No
Property
Lot Information
  • Lot Size Units: Acres
  • Lot Size Square Feet: 6600.0
  • Lot Features: Rolling Slope
  • Lot Size Acres: 0.1515
  • Lot Size Dimensions: Irreg
  • Lot Size Area: 0.15
  • Lot Features: Rolling Slope
Property and Assessments
  • New Construction: No
  • Property Condition: Existing Structure
  • Land Lease: Yes
  • Property Attached: No
  • Land Description: Less than .5 Acre
Building Features
  • Levels: One
  • Foundation Details: Block
  • Construction Materials: Brick
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
  • Gas Company: Duke Energy
  • Electric Company: Duke Energy
Interior and Exterior Features
Interior Features
  • Bathrooms: 2
  • Appliances: Dishwasher, Microwave, Refrigerator, Stainless Steel Appliance(s), Electric Range
  • Cooling: Central Air
  • Fireplace: No
  • Window Features: Insulated Windows, Vinyl Frames
  • Has Heating: Yes
  • Has Cooling: Yes
  • Basement: Full, Walk-Out Access, Full Finished Bath, Finished, Storage Space
  • Interior Features: Ceiling Fan(s), Recessed Lighting, Built-in Features, Pantry
  • Rooms Total: 9
  • Heating: Natural Gas
Exterior Features
  • Patio And Porch Features: Porch, Patio
  • Roof: Shingle
Room Information
Room 1
  • Room Features: Ceiling Fan(s), Recessed Lighting, Hardwood Floors
  • Room Type: Living Room
  • Room Length: 15.0
  • Room Level: First
  • Room Width: 13.0
  • Room Dimensions: 15 x 13
Room 2
  • Room Features: Chandelier, Built-in Features, Hardwood Floors
  • Room Type: Dining Room
  • Room Length: 10.0
  • Room Level: First
  • Room Width: 9.0
  • Room Dimensions: 10 x 9
Room 3
  • Room Features: Galley Kitchen, Luxury Vinyl Flooring
  • Room Type: Kitchen
  • Room Length: 10.0
  • Room Level: First
  • Room Width: 8.0
  • Room Dimensions: 10 x 8
Room 4
  • Room Features: Walk-Out Access, Carpet Flooring, Bath Adjoins, Recessed Lighting
  • Room Type: Primary Bedroom
  • Room Length: 22.0
  • Room Level: Lower
  • Room Width: 18.0
  • Room Dimensions: 22 x 18
Room 5
  • Room Features: Ceiling Fan(s), Hardwood Floors
  • Room Type: Bedroom 2
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 11.0
  • Room Dimensions: 13 x 11
Room 6
  • Room Features: Ceiling Fan(s), Hardwood Floors
  • Room Type: Bedroom 3
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 11.0
  • Room Dimensions: 13 x 11
Room 7
  • Room Features: Tub With Shower, Luxury Vinyl Flooring
  • Room Type: Primary Bath
  • Room Length: 9.0
  • Room Level: Lower
  • Room Width: 5.0
  • Room Dimensions: 9 x 5
Room 8
  • Room Features: Full Finished Bath, Shower, Luxury Vinyl Flooring
  • Room Type: Bathroom 2
  • Room Length: 7.0
  • Room Level: First
  • Room Width: 5.0
  • Room Dimensions: 7 x 5
Room 9
  • Room Features: Concrete Flooring
  • Room Type: Laundry
  • Room Length: 8.0
  • Room Level: Lower
  • Room Width: 8.0
  • Room Dimensions: 8 x 8

Property History for 404 Hazen Street

DateEvent & SourcePriceAppreciation
Apr 30, 2026

Sold (Public Record)

Public Record #1939807812

$279,900—
Apr 30, 2026

Sold

Northern Kentucky Multiple Listing Service #640913

$279,900—
Mar 29, 2026

Contract Signed

Northern Kentucky Multiple Listing Service #640913

—
DateEvent & SourcePrice
04/30/2026

Sold (Public Record)

Public Record #1939807812

$279,900
04/30/2026

Sold

Northern Kentucky Multiple Listing Service #640913

$279,900
03/29/2026

Contract Signed

Northern Kentucky Multiple Listing Service #640913

—

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 404 Hazen Street

Taxable ValueLand$10,000Additions$95,000Total$105,000
Tax Record2025$1,371 ($114 / month)
Home Facts
Beds2Baths1Total Finished SqFt986 SqFtAbove Grade Finished SqFt986 SqFtStories1Lot Size5,227 SqFtStyleSingle Family ResidenceYear Built1940CountyKENTONAPN040-12-02-018.00

Schools near 404 Hazen Street

This home is within Ludlow Independent School District.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 7 to 12
Private - K to 11
Rating
School
Distance
Mary A. Goetz Elementary School
PublicPK to 6

Ludlow High School
Public7 to 12

Gospel Light Academy
PrivateK to 11

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Re/Max United Associates

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 Compass and its related brokerages 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.