NOT LISTED FOR SALE

5045 Squirrel Bend Columbus, OH 43220

Estimated Value: $2,500,555 - $2,760,000

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

Last Sold May 06, 2021

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

Est. 29% increase in value since last sale

Current estimated payment $18,339/month

39 Days on Market

Highlights

  • 1.59 Acre Lot
  • Main Floor Primary Bedroom
  • Loft
  • Greensview Elementary School Rated A
  • <<bathWithWhirlpoolToken>>
  • 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 Agent to Sell the Property

Paula Koontz Gilmour

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

KW Classic Properties Realty

Last Buyer's Agent

Sean Socha

RE/MAX Partners License #2019006661

RE/MAX Partners

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
  • <<bathWithWhirlpoolToken>>
  • 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
  • Rooms 1st Flr Primary Suite: Yes
  • Rooms 1st Flr Laundry: Yes
  • Levels Two2: Yes
  • Common Walls No Common Walls: 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
  • Patio and Porch Features Patio: Yes

Garage/Parking

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

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%
Current Estimated Value
$2,575,389

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$575,389
Avg. Annual Appreciation
7.09%

Purchase Details

Closed on
Apr 6, 1987
Bought by
Bates Wesley C and Bates Ann S
Source: Public Records

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

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