NOT LISTED FOR SALE

5045 Squirrel Bend Columbus, OH 43220

Estimated Value: $2,363,000 - $3,270,000

4 Beds
7 Baths
11,326 Sq Ft
$240/Sq Ft Est. Value

Last Sold May 06, 2021

Last sale price $2,000,000 $177 Per Sq Ft

Est. 36% increase in value since last sale

Current estimated payment $19,271/month

39 Days on Market

Highlights

  • 1.59 Acre Lot
  • Main Floor Primary Bedroom
  • Loft
  • Greensview Elementary School Rated A
  • Whirlpool Bathtub
  • Great Room

About This Home

As of May 2021

Fabulous opportunity to purchase one of the most spectacular estates in Upper Arlington! Set on a 1.6 acre breathtaking tapestry of mature trees in an exclusive neighborhood, this residence provides the ultimate in privacy and tranquility. The interior showcases over 11,000 sq ft of timeless updates including oversized living, dining and entertaining areas and state-of-the-art amenities. Magnificent attention to detail and unsurpassed quality and craftmanship throughout. Soaring 17' ceilings on the 1st floor, walls of windows and rich hand-carved hardwood floors and woodwork. The lower level features 4,000 sq ft encompassing multiple casual living areas, kitchen, wine tasting room, play room, home gym and craft room. An opportunity to own a home of this grandeur rarely comes available!

Last Listed By

Paula Koontz Gilmour

KW Classic Properties Realty License #0000449484 Listed on: 02/27/2021

KW Classic Properties Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $41,551

Year Built

  • Built in 1989

Lot Details

  • 1.59 Acre Lot
  • Irrigation

Parking

  • 4 Car Garage

Home Design

  • Block Foundation
  • Stucco Exterior
  • Stone Exterior Construction

Interior Spaces

  • 11,326 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Wood Burning Fireplace
  • Insulated Windows
  • Great Room
  • Loft
  • Basement
  • Recreation or Family Area in Basement
  • Home Security System

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms | 1 Primary Bedroom on Main
  • In-Law or Guest Suite
  • Whirlpool Bathtub
  • Garden Bath

Laundry

  • Laundry on main level
  • Electric Dryer Hookup

Outdoor Features

  • Patio

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 070-014069

Home Details

Home Type

Single Family

Est. Annual Taxes

$41,551

Year Built

Built in 1989

Lot Details

0

Parking

4

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 1989
  • Tax Year: 2019
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 1.59
  • Co List Office Phone: 614-451-8500
  • MLS Status: Closed
  • Subdivision Name: Squirrel Bend
  • ResoBuildingAreaSource: Realist
  • Reso Fireplace Features: Wood Burning
  • Reso Interior Features: Central Vacuum, Whirlpool/Tub, Dishwasher, Electric Dryer Hookup, Electric Range, Garden/Soak Tub, Gas Water Heater, Humidifier, Microwave, Refrigerator, Security System
  • Unit Levels: Two
  • New Construction: No
  • Reso Window Features: Insulated All
  • Basement Basement YN2: Yes
  • Rooms:Living Room: Yes
  • Air Conditioning Central: Yes
  • Interior Flooring Carpet: Yes
  • Interior Amenities Gas Water Heater: Yes
  • Interior Amenities Microwave: Yes
  • Rooms Rec RmBsmt: Yes
  • Fireplace Log Woodburning: Yes
  • Foundation:Block: Yes
  • Interior Flooring CeramicPorcelain: Yes
  • Rooms Mother-In-Law Suite: Yes
  • Windows Insulated All: Yes
  • Interior Amenities Dishwasher: Yes
  • Exterior:Stone: Yes
  • Interior Amenities Electric Dryer Hookup: Yes
  • Interior Amenities Electric Range: Yes
  • Interior Amenities GardenSoak Tub: Yes
  • Interior Amenities WhirlpoolTub: Yes
  • Exterior:Stucco: Yes
  • Interior Amenities Humidifier: Yes
  • Interior Amenities Security System: Yes
  • Exterior Amenities Irrigation System: Yes
  • Interior Amenities Central Vac: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Entry Level Bedrooms: 1
  • Upstairs Bedrooms: 3
  • Downstairs 1 Full Bathrooms: 1
  • Upstairs 1 Full Bathrooms: 3
  • Entry Level Full Bathrooms: 1
  • Entry Level Half Bathrooms: 2
  • Basement: Full
  • Entry Level Dining Room: 1
  • Entry Level Eating Space: 1
  • Downstairs 1 Family Room: 1
  • Entry Level Great Room: 1
  • Entry Level Living Room: 1
  • Recreation Room (Downstairs 1): 1
  • Utility Space (Entry Level): 1
  • Basement YN: Yes
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Flooring: Wood, Stone, Carpet, Ceramic/Porcelain
  • Main Level Bedrooms: 1
  • Other Rooms:Dining Room: Yes
  • Basement Description:Full: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Loft: Yes

Exterior Features

  • Common Walls: No Common Walls
  • Exterior Features: Irrigation System
  • Foundation Details: Block
  • Patio And Porch Features: Patio

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 4.0
  • Attached Garage: Yes
  • Parking Features: Garage Door Opener, Attached Garage, Detached Garage

Utilities

  • Heating: Forced Air
  • Cooling: Central Air
  • Cooling Y N: Yes
  • HeatingYN: Yes
  • Heating:Forced Air: Yes
  • Heating:Gas2: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Junior High Dist: UPPER ARLINGTON CSD 2512 FRA CO.

Lot Info

  • Parcel Number: 070-014069
  • Lot Size Sq Ft: 69260.4

Tax Info

  • Tax Annual Amount: 41551.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 27, 2021
Closed on
May 3, 2021
Sold by
Bates Wesley C and Bates Ann S
Bought by
Gmdh Properties Llc
Seller's Agent
Paula Koontz Gilmour
KW Classic Properties Realty
Buyer's Agent
Sean Socha
RE/MAX Partners
List Price
$2,500,000
Sold Price
$2,000,000
Premium/Discount to List
-$500,000
-20%
Total Days on Market
39
Current Estimated Value
$2,720,551

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$720,551
Avg. Annual Appreciation
7.91%

Purchase Details

Closed on
Apr 6, 1987
Bought by
Bates Wesley C and Bates Ann S

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

Similar Homes in the area

  • 5420 Clark State Rd, Columbus, OH 43230

    $2,800,000

    • 5 Beds
    • 7 Baths
    • 9,516 Sq Ft
    • 5420 Clark State Rd
    • Columbus, OH

    5420 Clark State - a one-of-a-kind legacy estate nestled on 15+ private acres across 5 parcels, combining historic charm w/modern luxury. Boasting 9500+SF of finished living space, this stately home features 5 BRs, 5 full BAs, 2 half BAs, 4 fireplaces & a layout designed for both grand-scale entertaining & everyday living. Interior highlights include a dramatic 2-story sunken Great room w/wood

    Jamie Maze Fiv Realty Co Ohio LLC

    Section Image
  • 3084 Asbury Dr, Columbus, OH 43221

    $2,400,000

    • 5 Beds
    • 7 Baths
    • 6,718 Sq Ft
    • 3084 Asbury Dr
    • Columbus, OH

    Incredible opportunity to own a CUSTOM Contemporary Heinlen Follmer built home in a highly desirable area of Upper Arlington. You will be in the heart of everything UA has to offer in this location. No detail has been missed in this gorgeous home. Open floorplan great for entertaining! 5 Bed, 5 Full & 2 Half Bath home on fully fenced 1/2 acre lot with heated saltwater pool. High end EVERYTHING!

    Linda Wasil Cutler Real Estate

    Section Image
  • 57 Preston Rd, Columbus, OH 43209

    $2,500,000

    • 6 Beds
    • 6 Baths
    • 6,563 Sq Ft
    • 57 Preston Rd
    • Columbus, OH

    Handsome 2.5 story home with beautiful Architectural Details that have been preserved and enhanced with all the years of meticulous and prideful ownership! This home truly is an Eastside treasure on lovely Preston Road to embrace for it offers a gracious and elegant style and truly the perfect home for entertaining! Delightful decorator enhancements in every room! The most desired Center Hall

    Sheila Straub Coldwell Banker Realty

    Section Image
  • 2699 Norton Rd, Galloway, OH 43119

    $3,100,000

    • 6 Beds
    • 7 Baths
    • 7,336 Sq Ft
    • 2699 Norton Rd
    • Galloway, OH

    No expense spared in this custom-built Bob Webb estate offering over 7300 sq ft of living space on a sprawling 7 acres. This exquisite gated residence features 6 bedrooms, 5 full baths, and 2 half baths, designed for both luxury and convenience. Recreation space on every level and 1st and 2nd floor laundry rooms add to the home's functionality. The gourmet kitchen is a chef's paradise with a

    Amy Carlisle Coldwell Banker Realty

    Section Image

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Gmdh Properties Llc $2,000,000 Search 2 Close
Bates Wesley C $135,000 --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/31/2025 03/31/25 Off Market $2,000,000 -- --
05/06/2021 05/06/21 Sold $2,000,000 -20.0% $177 / Sq Ft
02/27/2021 02/27/21 For Sale $2,500,000 -- $221 / Sq Ft
Source: Columbus and Central Ohio Regional MLS

Tax History Compared to Growth

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 $49,388 $834,370 $136,150 $698,220
2023 $48,788 $834,370 $136,150 $698,220
2022 $52,058 $728,670 $90,760 $637,910
2021 $48,229 $779,210 $90,760 $688,450
2020 $47,802 $779,210 $90,760 $688,450
2019 $41,551 $598,720 $90,760 $507,960
2018 $20,658 $598,720 $90,760 $507,960
2017 $41,232 $598,720 $90,760 $507,960
2016 $43,161 $651,950 $138,810 $513,140
2015 $21,562 $651,950 $138,810 $513,140
2014 $43,172 $651,950 $138,810 $513,140
2013 $21,597 $620,900 $132,195 $488,705
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Columbus and Central Ohio Regional MLS

MLS Number: 221005491

Columbus and Central Ohio Regional MLS

APN: 070-014069