Immaculate 3-Bedroom, 2-Bath Home in Northern KY - This beautifully remodeled home, currently set up as a successful Airbnb, offers the perfect blend of comfort, style, & convenience. Enjoy a custom tiled shower, a remodeled kitchen with quartz countertops & stainless steel appliances, & 3 finished levels of meticulously decorated living space. The home boasts ample natural light, updated lighting, & cased woodwork throughout. Relax on the covered front porch or entertain on the deck overlooking the custom patio, all while enjoying the privacy of a wooded nature reserve across the street. Located less than 5 miles from downtown Cincinnati, this home is ideal for city access with a tranquil retreat feel. Don't miss out on this unique opportunity!
Sold for $225,000 on 03/07/25
$225,000
247 Lake St, Ludlow, KY 41016
3beds
--sqft
Single Family Residence, Residential
Built in 1925
3,484.8 Square Feet Lot
$226,900 Zestimate®
$--/sqft
$1,657 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: April 06, 2025 at 10:16pm
Listed by:
The Treas Team 859-525-7900,
Huff Realty - Florence
Bought with:
The Cindy Shetterly Team, 220012
Keller Williams Realty Services
Source: NKMLS,MLS#: 628917

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Primary bedroom
- Features: Carpet Flooring, Ceiling Fan(s)
- Level: First
- Area: 156
- Dimensions: 13 x 12
Bedroom 2
- Features: Carpet Flooring
- Level: Second
- Area: 210
- Dimensions: 21 x 10
Bedroom 3
- Features: Carpet Flooring
- Level: Basement
- Area: 209
- Dimensions: 19 x 11
Other
- Features: Carpet Flooring
- Level: Second
- Area: 80
- Dimensions: 10 x 8
Dining room
- Features: Carpet Flooring
- Level: First
- Area: 132
- Dimensions: 12 x 11
Entry
- Features: Laminate Flooring, Transom
- Level: First
- Area: 77
- Dimensions: 11 x 7
Kitchen
- Features: Walk-Out Access, Laminate Flooring, Wood Cabinets, Solid Surface Counters
- Level: First
- Area: 100
- Dimensions: 10 x 10
Laundry
- Features: Concrete Flooring, Utility Sink
- Level: Basement
- Area: 100
- Dimensions: 10 x 10
Living room
- Features: Carpet Flooring
- Level: First
- Area: 143
- Dimensions: 13 x 11
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Electric Range, Dishwasher, Microwave, Refrigerator
- Laundry: In Basement
Features
- Granite Counters, Entrance Foyer, Chandelier, Ceiling Fan(s), Natural Woodwork, Master Downstairs
- Flooring: Carpet, Concrete
- Doors: Multi Panel Doors
- Windows: Vinyl Frames
Property
Parking
- Parking features: On Street
- Has uncovered spaces: Yes
Features
- Levels: Multi/Split
- Stories: 1
- Patio & porch: Deck, Patio, Porch
- Fencing: Chain Link,Privacy,Wood
Lot
- Size: 3,484 sqft
Details
- Additional structures: Shed(s)
- Parcel number: 0264111030.00
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Shingle
Condition
- Existing Structure
- New construction: No
- Year built: 1925
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available
Community & neighborhood
Location
- Region: Ludlow
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.