$267,000
PENDING

Estimated payment $1,575/month

Total Views 1,874
4 Beds
2 Baths
1,248 Sq Ft
$214 Price per Sq Ft

Highlights

  • Gourmet Kitchen
  • Wooded Lot
  • Wood Flooring
  • View of Trees or Woods
  • Ranch Style House
  • Private Yard

About This Home

OPEN HOUSE CANCELED - Retro Mid-Century modern vibes meet everyday comfort in this spacious 4-bedroom, 2-bath ranch situated on a double lot. Pristine hardwood floors, mature trees, and beautifully landscaped grounds create a warm and inviting setting. The large open kitchen offers plenty of space for cooking and gathering, while the finished lower level features a huge family room with walkout access to the fenced yard. A generous basement woodshop provides excellent space for hobbies, storage, or future customization. Enjoy abundant indoor and outdoor living space in a home filled with character and flexibility.

Listing Agent

Edward Lindenschmidt

Keller Williams Advisors License #291099 Listed on: 07/15/2026

Keller Williams Advisors

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1953

Lot Details

  • 7,750 Sq Ft Lot
  • Lot Dimensions are 238 x 100
  • Wooded Lot
  • Private Yard
  • Land Lease

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Block Foundation
  • Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 1,248 Sq Ft Home
  • Ceiling Fan
  • Recessed Lighting
  • Fireplace
  • Vinyl Clad Windows
  • Bay Window
  • Family Room
  • Living Room
  • Formal Dining Room
  • Workshop
  • Views of Woods
  • Fire and Smoke Detector

Kitchen

  • Gourmet Kitchen
  • Electric Oven
  • Electric Range
  • Dishwasher
  • Stainless Steel Appliances
  • Laminate Countertops

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 2 Full Bathrooms
  • Soaking Tub
  • Bathtub with Shower

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Laundry in Basement
  • Basement Storage

Parking

  • Driveway
  • Off-Street Parking

Outdoor Features

  • Patio
  • Shed
  • Outbuilding
  • Porch

Schools

  • Collins Elementary School
  • Jones Middle School
  • Boone County High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1953

Lot Details

7,750 Sq Ft Lot

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.1779
  • Year Built: 1953
  • Lot Size: 238 x 100
  • Ownership: Consumer
  • Directions: 42 to Grand, R on Ann, R on Burke
  • Architectural Style: Ranch
  • New Construction: No
  • Property Attached Yn: No
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • Property Ownership:Property Ownership: Consumer
  • Land Description:Land Description: Less than .5 Acre
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Ceiling Fan(s), Recessed Lighting, Laminate Counters, Soaking Tub
  • Basement: Full, Walk-Out Access, Full Finished Bath, Finished, Storage Space
  • Heating: Forced Air, Natural Gas
  • Levels: One
  • Property Type: Residential
  • Appliances: Dishwasher, Refrigerator, Stainless Steel Appliance(s), Electric Range, Electric Oven
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: See Remarks
  • Fireplace: Yes
  • Living Area: 1248.0
  • Window Features: Bay Window(s), Vinyl Frames

Exterior Features

  • View: Trees/Woods
  • Fencing: Fenced
  • Roof: Shingle
  • Lot Features: Wooded
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Private Yard
  • Foundation Details: Block, Concrete Perimeter
  • Other Structures: Shed(s), Storage, Outbuilding
  • Patio And Porch Features: Porch, Patio

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: In Basement
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Natural Gas Available

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Collins Elementary
  • Junior High Dist: Boone Co Public
  • High School: Boone County High
  • Middle Or Junior School: Jones Middle School

Lot Info

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

Map

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 $1,497 $154,100 $15,000 $139,100
2024 $1,467 $154,100 $15,000 $139,100
2023 $1,528 $154,100 $15,000 $139,100
2022 $1,460 $154,100 $15,000 $139,100
2021 $1,918 $154,100 $15,000 $139,100
2020 $1,173 $121,000 $15,000 $106,000
2019 $1,184 $121,000 $15,000 $106,000
2018 $1,238 $121,000 $15,000 $106,000
2017 $1,171 $121,000 $15,000 $106,000
2015 $1,162 $121,000 $15,000 $106,000
2013 -- $121,000 $15,000 $106,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
07/18/2026 07/18/26 Pending -- -- --
07/15/2026 07/15/26 For Sale $267,000 -- $214 / 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
Interfamily Deed Transfer -- Prominent Title Agency Llc
Deed $73,000 --
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 $101,600 New Conventional
Closed $108,000 Future Advance Clause Open End Mortgage
Closed $110,800 Future Advance Clause Open End Mortgage
Closed $112,000 New Conventional
Source: Public Records

About the Listing Agent

Edward Lindenschmidt

Keller Williams Advisors

(859) 651-7334

Section Image

Edward Lindenschmidt | Cincinnati & Northern Kentucky Real Estate Expert

Cincinnati native and longtime Westside resident, Edward Lindenschmidt is a top-performing real estate agent helping buyers and sellers navigate the Cincinnati and Northern Kentucky markets with confidence.

Since 2017, Edward has built a reputation for delivering results, closing over 300 transactions and consistently ranking in the top 4% of Cincinnati-area Realtors. He has also been recognized with Cincy

Edward's Other Listings

  • 3229 Brunsman Way, North Bend, OH 45052

    $499,900 New Construction

    • 4 Beds
    • 2.5 Baths
    • 2,479 Sq Ft
    • 3229 Brunsman Way
    • North Bend, OH

    OPEN HOUSE Sunday 7/19 from Noon-2pm! Move right into this stunning new construction home offering over 2,400 sq ft of finished living space and luxury finishes throughout. The open floor plan features a dramatic 2-story great room filled with natural light, a private home office, mudroom, and chef-inspired kitchen with gas range and butler's pantry. The first-floor primary suite includes a

    Edward Lindenschmidt Keller Williams Advisors

    Section Image
  • 2716 Minot Ave, Cincinnati, OH 45209

    $475,000

    • 5 Beds
    • 2.5 Baths
    • 2,002 Sq Ft
    • 2716 Minot Ave
    • Cincinnati, OH

    SHOWINGS START THURSDAY - OPEN HOUSE Saturday 7/18 from 11-1pm. Historic character meets move-in-ready comfort in this spacious Oakley home. Offering five bedrooms plus a flexible first-floor office that has previously served as a bedroom, the versatile layout provides abundant space for working from home, hosting guests, or creating rooms tailored to your lifestyle. Nine-foot ceilings enhance

    Edward Lindenschmidt Keller Williams Advisors

    Section Image
  • 1625 Hogan Ln, Florence, KY 41042

    $315,000 Sold Aug 29, 2025

    • 4 Beds
    • 3 Baths
    • 1,830 Sq Ft
    • 1625 Hogan Ln
    • Florence, KY

    Welcome to this beautifully renovated 4-bedroom, 3-full-bath home in Oak Brook's desirable Shaker Run subdivision! Featuring a brand-new kitchen, updated flooring, fresh decking, and stylish finishes throughout, this home is move-in ready and in pristine condition. The spacious layout includes soaring ceilings, an oversized garage, and a large fenced yard—perfect for relaxing or entertaining. The

    Edward Lindenschmidt Keller Williams Advisors

  • 4961 Troubador Ct, Cincinnati, OH 45238

    $300,000 Sold Aug 29, 2025

    • 4 Beds
    • 2.5 Baths
    • 3,414 Sq Ft
    • 4961 Troubador Ct
    • Cincinnati, OH

    OPEN HOUSE Sunday 7/27 from Noon-2pm. Tucked away at the end of a peaceful cul-de-sac in the award-winning Oak Hills School District, this spacious 4-bedroom, 2.5-bath home offers the perfect blend of comfort, convenience, and outdoor living. Step inside to find a welcoming layout with a formal dining room, open concept kitchen, breakfast room, a large primary suite and plenty of room for

    Edward Lindenschmidt Keller Williams Advisors

  • 5237 Leona Dr, Cincinnati, OH 45238

    $204,000 Sold Aug 12, 2025

    • 3 Beds
    • 2 Baths
    • 2,108 Sq Ft
    • 5237 Leona Dr
    • Cincinnati, OH

    OPEN HOUSE - Friday 7/10 from 6-7:30! Welcome home to this charming 3-bedroom, 2-bath Cape Cod in the heart of Green Township! Just a short stroll to Bosken Park, local dining, and the busline, this well-maintained gem offers comfort and convenience. Enjoy summer evenings in the spacious, privacy fenced backyard complete with mature trees, a deck, and a cozy seating area perfect for relaxing or

    Edward Lindenschmidt Keller Williams Advisors

  • 433 Clark St, Cincinnati, OH 45203

    $210,000 Sold May 18, 2026

    • 1 Bed
    • 1 Bath
    • 694 Sq Ft
    • 433 Clark St
    • Cincinnati, OH

    OPEN HOUSE CANCELED - Just steps from the electric energy of TQL Stadium, you'll love being able to stroll to FC Cincinnati matches, vibrant nightlife, top-rated restaurants, and some of the city's best entertainment. Set on a picturesque, tree-lined street in the historic Betts-Longworth district, this beautifully updated and tax-abated 1-bedroom condo offers a lifestyle that's hard to match.

    Edward Lindenschmidt Keller Williams Advisors

  • 3007 Ideal Terrace, Cincinnati, OH 45238

    $190,000 Sold Oct 16, 2025

    • 2 Beds
    • 2 Baths
    • 990 Sq Ft
    • 3007 Ideal Terrace
    • Cincinnati, OH

    Immaculate 2-bedroom, 2 full bath ranch in Westwood, beautifully remodeled and FHA ready! Nestled on a quiet cul-de-sac street, this move-in ready home features gleaming hardwood floors throughout, a spacious living room, formal dining room, and updated kitchen and bath. Enjoy a large front porch perfect for relaxing, plus a private oversized backyard ideal for entertaining. The full unfinished

    Edward Lindenschmidt Keller Williams Advisors

  • 506 Center St, Newport, KY 41071

    $315,000 Sold Mar 31, 2026

    • 2 Beds
    • 1 Bath
    • 1,611 Sq Ft
    • 506 Center St
    • Newport, KY

    OPEN HOUSE Saturday 2/21 from 11-1pm! Larger than it looks at 1,600sqft this charming updated Storybook Cape Cod in the heart of the historic Cote Brilliante neighborhood, is tucked away by the iconic Wiedemann Mansion, luxury homes and minutes from the river. A recently converted attic adds over 460sqft of valuable living space and enhances the home's flexible layout, featuring two finished

    Edward Lindenschmidt Keller Williams Advisors

  • 5630 Karen Ave, Cincinnati, OH 45248

    $190,000 Sold Jul 31, 2025

    • 2 Beds
    • 2 Baths
    • 820 Sq Ft
    • 5630 Karen Ave
    • Cincinnati, OH

    Welcome to this charming 2 bed, 2 bath ranch home in the award-winning Oak Hills School District! This beautiful cozy home offers comfort, style, and convenience all in one. Step inside to find fresh paint and an updated main bathroom, adding a modern touch to the inviting interior. The spacious, fenced-in backyard features a newly stained rear deck perfect for gatherings, grilling, or relaxing

    Edward Lindenschmidt Keller Williams Advisors

Source: Northern Kentucky Multiple Listing Service

MLS Number: 644695

Northern Kentucky Multiple Listing Service

APN: 061.04-24-009.00

Your Personal Tour Guide

Ask me questions while you tour the home.