$725,000
PENDING $25K PRICE DROP

5591 Squirrel Run Cincinnati, OH 45247

Estimated payment $4,619/month

Total Views 5,350
4 Beds
6 Baths
4,224 Sq Ft
$172 Price per Sq Ft

Highlights

  • 1.02 Acre Lot
  • Cathedral Ceiling
  • Wood Flooring
  • Great Room with Fireplace
  • Traditional Architecture
  • Main Floor Bedroom

About This Home

Now's your chance to own this stunning custom-built two-story house located on a cul-de-sac in White Oak. It is more than just a place to live-it is a canvas for your dreams, a sanctuary for your family, and a showcase of timeless design and modern convenience. Whether you are seeking a cozy refuge or an inspiring backdrop for entertaining guests, this remarkable property offers the perfect blend of style, comfort, and functionality. It has been meticulously maintained and has exceptional features and upgrades. First floor primary suite with 3 additional bedrooms on the 2nd floor. Situated on just over an acre, there is plenty of room to enjoy the outdoors. Relax on the stamped concrete patio or shoot some hoops on the 40' x 50' basketball court. There's even a gas line for your grill so no more running out of gas in the middle of your grilling. Chores are made easier by the central vac system inside and a sprinkler system outside. Agent is related to seller.

Listing Agent

Mary Morgan

Coldwell Banker Realty License #2016002145 Listed on: 07/24/2025

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,294

Year Built

  • Built in 1987

Lot Details

  • 1.02 Acre Lot
  • Lot Dimensions are 102x335
  • Cul-De-Sac

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Asbestos Shingle Roof

Interior Spaces

  • 4,224 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Woodwork
  • Crown Molding
  • Cathedral Ceiling
  • Skylights
  • Gas Fireplace
  • Double Pane Windows
  • Vinyl Clad Windows
  • Panel Doors
  • Great Room with Fireplace
  • 3 Fireplaces
  • Game Room
  • Wood Flooring

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Convection Oven
  • Gas Cooktop
  • Warming Drawer
  • Dishwasher
  • Solid Wood Cabinet
  • Trash Compactor
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump

Home Security

  • Smart Security System
  • Smart Thermostat

Outdoor Features

  • Patio
  • Exterior Lighting

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater
  • Septic Tank

Community Details

  • Association fees include landscapingcommunity

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,294

Year Built

Built in 1987

Lot Details

0

HOA Fees

$8 per month

Parking

3

Listing Details

  • Suburb: White Oak
  • Land Description: 1 to 4.9 Acres
  • Access: City Street
  • Broker Approved: Yes
  • Basement Sq Ft: 2466
  • Census Tract Realist: 207.07
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 44431.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00.000-05:00
  • Suburb S I C: White Oak
  • Taxes Annual: 8294
  • Price Per Acre: 710784.31
  • Zoning: Residential
  • Basement Features: Finished, Walkout, WW Carpet
  • Bathroom 4: Partial
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Full, Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Chandelier, Formal, WW Carpet
  • Entry Area: 243
  • Entry Foyer: Marble/Slate, Closet, Open Foyer, Transom/Sidelit, Other
  • Family Room Feat: Bookcases, Wall-to-Wall Carpet, Wet Bar
  • Great Room Feat: Walkout, Wall-to-Wall Carpet, Wet Bar, Window Treatment, Fireplace, Skylight
  • Living Great Rm Area: 272
  • Living Great Rm Dim: 17 x 16
  • Living Great Rm Len: 17
  • Living Great Rm Wid: 16
  • Living Room Feat: Bookcases, Wall-to-Wall Carpet, Window Treatment
  • Mechanical Systems: Central Vacuum, Garage Door Opener, Humidifier, Security System, Sump Pump
  • Single Family Desc: Single Family
  • Smart Technology: Doors/Locks, Garage Door Opener, Security, Thermostat
  • Study Lib Den: 12x15 Level: 1
  • Study Lib Den Area: 180
  • Study Lib Den Dim: 12 x 15
  • Study Lib Den Len: 12
  • Water Heating: Gas
  • Year Built: 1987
  • Architecture: Traditional
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Bedrooms: 4
  • Directions: Hanley Road to Squirrel Creek to Right on Squirrel Run
  • Lot Measurement: Acres
  • Status: Pending
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 1058
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Cathedral Ceiling, Crown Molding, French Doors, Multi Panel Doors, Natural Woodwork, Skylight, Vaulted Ceiling
  • Bedroom 2: 12x13 Level: 2
  • Bedroom 3: 12x13 Level: 2
  • Bedroom 4: 12x13 Level: 2
  • Dining Room: 13x16 Level: 1
  • Living Room: 17x16 Level: 1
  • Recreation Room: 28x14 Level: Lower
  • Flex Rooms: Exercise Room, Game Room
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $4147
  • Appliances: Convection Oven, Dishwasher, Dryer, Garbage Disposal, Gas Cooktop, Refrigerator, Trash Compactor, Warming Drawer, Washer
  • Kitchen Features: Planning Desk, Counter Bar, Skylight, Eat-In, Window Treatment, Wood Cabinets, Wood Floor, Marble/Granite/Slate
  • Bedroom 2 Area: 156
  • Basement: Full
  • Bedroom 3 Area: 156
  • Study Features: Bookcases, Wall-to-Wall Carpet, Fireplace, Window Treatment
  • Bedroom 4 Area: 156
  • Entry: 27x9 Level: 1
  • Bathrooms: 6.00
  • Great Room: 22x16 Level: 1
  • Kitchen Area: 312
  • Kitchen Dim: 26 x 12
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Diningroom Area: 208
  • Family Room Area: 560
  • Laundry Room: 8x7 Level: 1
  • Laundry Room Area: 56
  • Laundryroom Dim: 8 x 7
  • Recreation Room Area: 392
  • Recreation Room Dim: 28 x 14
  • Fireplace: Gas
  • Fireplaces: 3
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 4224.00
  • Total Rooms: 12
  • Windows: Bay/Bow, Casement, Double Pane, Vinyl, Wood
  • First Floor Family Room: 40x14 Level: Lower
  • PrimaryBedroomArea: 210
  • PrimaryBedroomDim: 14 x 15
  • PrimaryBedroomLen: 14
  • Primary Bathrooms: Built-In Shower Seat, Shower, Tile Floor, Double Vanity, Window Treatment
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet, Walkout, Wall-to-Wall Carpet, Fireplace, Window Treatment
  • P R I M A R Y B E D R O O M: 14x15 Level: 1

Exterior Features

  • Roof: Asbestos Shingle
  • Construction: Brick
  • Outside Features: Cul de sac, Patio, Sprinklers, Yard Lights, Other
  • Foundation: Poured
  • Listing Price: 725000.00
  • Acres: 1.0200
  • New Construction: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Oversized, Side, Garage Attached
  • Parking: On Street, Driveway

Utilities

  • Gas: Natural
  • Sewer: Septic Tank
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 100.00
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service

Fee Information

  • Inc.In HOA/Condo Fee: LandscapingCommunity, Other

Schools

  • District: Northwest Local SD

Lot Info

  • Lot Dimensions: 102x335
  • Lot Size Sq Ft: 44431.00
  • Total Assessed Value: Of Record

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

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 $8,390 $155,757 $22,512 $133,245
2023 $8,435 $155,757 $22,512 $133,245
2022 $10,534 $159,142 $26,565 $132,577
2021 $10,448 $159,142 $26,565 $132,577
2020 $10,553 $159,142 $26,565 $132,577
2019 $9,583 $134,866 $22,512 $112,354
2018 $8,600 $134,866 $22,512 $112,354
2017 $8,152 $134,866 $22,512 $112,354
2016 $6,249 $101,829 $20,580 $81,249
2015 $6,310 $101,829 $20,580 $81,249
2014 $6,320 $101,829 $20,580 $81,249
2013 $7,724 $130,547 $26,383 $104,164
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/15/2025 08/15/25 Pending -- -- --
07/31/2025 07/31/25 Price Changed $725,000 -3.3% $172 / Sq Ft
07/24/2025 07/24/25 For Sale $750,000 -- $178 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Mortgage History

Date Status Loan Amount Loan Type
Closed $38,500 Credit Line Revolving
Closed $308,000 New Conventional
Closed $86,000 Credit Line Revolving
Closed $338,000 New Conventional
Closed $100,000 Credit Line Revolving
Closed $308,300 Unknown
Closed $304,000 Unknown
Closed $300,028 Stand Alone Second
Closed $275,000 Unknown
Source: Public Records

Similar Homes in Cincinnati, OH

  • 3049 Barnbougle Dr, Cincinnati, OH 45233

    $545,900

    • 4 Beds
    • 2 Baths
    • 2,796 Sq Ft
    • 3049 Barnbougle Dr
    • Cincinnati, OH

    Gorgeous new Ivy Modern Retreat plan by Fischer Homes in beautiful Reserve at Deer Run featuring a welcoming covered front porch. Once inside you'll fall in love with the open concept design with an island kitchen with stainless steel appliances, upgraded maple cabinetry with 42 inch uppers and soft close hinges, durable quartz counters, HUGE butler's pantry and walk-out breakfast room to the

    Section Image
  • 204 Brocdorf Dr, Cincinnati, OH 45215

    $795,000

    • 6 Beds
    • 2.5 Baths
    • 5,138 Sq Ft
    • 204 Brocdorf Dr
    • Cincinnati, OH

    Welcome to 204 Brocdorf Dr, a spacious and timeless residence in the highly sought-after Wyoming community. This impressive stone home offers over 4,200 sq.ft. of thoughtfully designed living space, blending classic style with comfortable functionality. With 6 bedrooms and 2.5 bathrooms, this home provides plenty of room for daily living, entertaining, or creating dedicated spaces for work or

    Jonathan Hardy Keller Williams Seven Hills Re

    Section Image
  • 541 Ringgold St, Cincinnati, OH 45202

    $615,000

    • 3 Beds
    • 3.5 Baths
    • 541 Ringgold St
    • Cincinnati, OH

    Prospect Hill gem built in 2019. This stunning 3-bedroom, 3.5-bath attached single family home features a private rooftop deck, backyard retreat, and a 2-car garage. Enjoy sleek modern finishes, an open layout, and abundant natural lightjust minutes from Downtown, OTR, Mt. Auburn, and Walnut Hills. With tax abatement until 2034 and no HOA fees, this one-of-a-kind home is the perfect blend of

    Brittany Williams Keller Williams Advisors

    Section Image
  • 3815 Drakewood Dr, Cincinnati, OH 45209

    $739,000

    • 3 Beds
    • 3 Baths
    • 2,442 Sq Ft
    • 3815 Drakewood Dr
    • Cincinnati, OH

    Where vintage charm meets modern comfort on one of Oakley's most iconic streets! This updated Tudor seamlessly blends original character with thoughtful upgrades. A rare detached 2-car garage complete with electric, Tufco flooring, and modern finishes sets this property apart. Inside, refinished hardwood floors, stylish lighting, and pristine finishes create a warm, inviting atmosphere. The

    Anne Donnellon Comey & Shepherd

    Section Image
  • 3 Salem Rd, Cincinnati, OH 45230

    $556,000

    • 3 Beds
    • 2 Baths
    • 3 Salem Rd
    • Cincinnati, OH

    Discover a stunning selection of Ranch, Two-Story, and First-Floor Suite home designs (see attached) tailored for modern living. Nestled in a prime Anderson location, this community offers a wide range of floor plans, Forest Hills School District, and easy access to parks, shopping, and dining. Experience comfort, convenience, and style in your new home! Featured here is the Anderson! All vinyl

    Jeff Rosa eXp Realty

    Section Image
  • 2 Salem Rd, Cincinnati, OH 45230

    $560,000

    • 3 Beds
    • 2 Baths
    • 2 Salem Rd
    • Cincinnati, OH

    Discover a stunning selection of Ranch, Two-Story, and First-Floor Suite home designs (see attached) tailored for modern living. Nestled in a prime Anderson location, this community offers a wide range of floor plans, Forest Hills School District, and easy access to parks, shopping, and dining. Experience comfort, convenience, and style in your new home! Featured here is the Maia! This 3BR, 2

    Jeff Rosa eXp Realty

    Section Image
  • 11157 Snider Rd, Cincinnati, OH 45249

    $789,000

    • 4 Beds
    • 3.5 Baths
    • 3,336 Sq Ft
    • 11157 Snider Rd
    • Cincinnati, OH

    You'll find beautiful updates to this 4 BR/3.5 BA home with an unbeatable Sycamore Twp. location plus room to roam with 5500 + SF & 1/2 acre lot! Hardwoods on entire 1st floor, new carpet on 2nd floor, replacement windows throughout, HVAC replaced 2019. Kitchen renovated with white cabs, new appliances & granite tops. Finished LL w/ Rec Rm & Bonus Rooms for fitness/craft/media. Pergola & stamped

    Helena Cameron Sibcy Cline, Inc.

    Section Image
  • 7652 Clough Pike, Cincinnati, OH 45244

    $735,000

    • 4 Beds
    • 2.5 Baths
    • 7652 Clough Pike
    • Cincinnati, OH

    To be Built! Amazing First Floor Suite home with all the modern amenities. 9' Ceilings, hardwood floors, ceramic baths, gaurmet Kitchen, covered front and rear porches, and much more. This home sits on .618 acres but could be combined with the lot a 7660 for an additional cost. Perfect location and all utilities are there. Other homes and plans available through Zeilman-James Homes, Inc. or

    Jeff Rosa eXp Realty

    Section Image
  • 7660 Clough Pike, Cincinnati, OH 45244

    $725,000

    • 3 Beds
    • 2 Baths
    • 7660 Clough Pike
    • Cincinnati, OH

    Spectacular Ranch home with all the modern amenities. 9-10' Ceilings, hardwood floors, ceramic baths, gaurmet Kitchen, large rear patio and much more. This home sits on .7 acres but could be combined with the lot a 7652 for an additional cost. Perfect location and all utilities are there. Other homes and plans available through Zeilman-James Homes, Inc.

    Jeff Rosa eXp Realty

    Section Image

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1849196

MLS of Greater Cincinnati (CincyMLS)

APN: 510-0222-0119