NOT LISTED FOR SALE

2040 Tremont Rd Columbus, OH 43221

Estimated Value: $1,463,000 - $1,650,927

4 Beds
4 Baths
3,405 Sq Ft
$459/Sq Ft Est. Value

Last Sold June 29, 2023

Last sale price $1,425,000 $419 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $10,767/month

13 Days on Market

Highlights

  • Multiple Fireplaces
  • Wooded Lot
  • Great Room
  • Barrington Road Elementary School Rated A
  • Bonus Room
  • 2 Car Detached Garage

About This Home

As of June 2023

*OPEN HOUSE FRIDAY June 9th 2 - 4PM
European historical charm w/fantastic location. Short walk to Barrington & Jones schools, Scioto Country Club, Miller library &. more. 4 + Bdrms, 2 FB & 2 half baths w/addition plans available. 3rd fl. finished for a wonderful Master suite opportunity. Beautifully expanded patio & garden, totally rebuilt side porch & front porch w/custom French doors to enjoy summer evenings. Ideal location SOL between Guilford & Waltham makes this home a wonderful place for children. Architectural design elements are rare and beautifully maintained. With a vaulted ceiling morning room and sunny open kitchen this home is perfect for entertaining.
24 Hr. notice preferred for all showings.

Last Agent to Sell the Property

G. Charlene Evans

Street Sotheby's International License #2007000519 Listed on: 06/07/2023

Street Sotheby's International

Last Buyer's Agent

John Houk

The Brokerage House License #2013002344

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $24,027

Year Built

  • Built in 1918

Lot Details

  • 0.25 Acre Lot
  • Wooded Lot

Parking

  • 2 Car Detached Garage

Home Design

  • Brick Exterior Construction
  • Stone Foundation
  • Wood Siding

Interior Spaces

  • 3,405 Sq Ft Home
  • 3-Story Property
  • Multiple Fireplaces
  • Gas Log Fireplace
  • Insulated Windows
  • Great Room
  • Bonus Room
  • Carpet
  • Basement
  • Recreation or Family Area in Basement
  • Home Security System
  • Laundry on lower level

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms

Outdoor Features

  • Patio

Utilities

  • Central Air
  • Heating System Uses Gas
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 070-000016-00

Home Details

Home Type

Single Family

Est. Annual Taxes

$24,027

Year Built

Built in 1918

Lot Details

0

Parking

2

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 1918
  • Tax Year: 2022
  • Property Sub-Type: Single Family Residence
  • ResoLotFeatures: Wooded
  • Lot Size Acres: 0.25
  • Co List Office Phone: 614-538-8895
  • MLS Status: Closed
  • ResoBuildingAreaSource: Auditor
  • Reso Fireplace Features: Four or More, Gas Log
  • Reso Interior Features: Dishwasher, Gas Range, Gas Water Heater, Microwave, Refrigerator, Security System
  • Unit Levels: Three
  • New Construction: No
  • Reso Window Features: Insulated Part
  • Sewer:Public Sewer: Yes
  • Basement Basement YN2: Yes
  • Foundation Stone2: Yes
  • Rooms LL Laundry: Yes
  • Rooms:Living Room: Yes
  • Air Conditioning Central: Yes
  • Interior Flooring Carpet: Yes
  • Interior Amenities Gas Range: Yes
  • Interior Amenities Gas Water Heater: Yes
  • Interior Amenities Microwave: Yes
  • Lot Characteristics Wooded: Yes
  • Rooms Rec RmBsmt: Yes
  • Water Source Public Water Source: Yes
  • Fireplace Four or More: Yes
  • Interior Amenities Dishwasher: Yes
  • Windows Insulated Part: Yes
  • Exterior Brick: Yes
  • Exterior:Wood Siding: Yes
  • Interior Amenities Security System: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Upstairs Bedrooms: 3
  • Upstairs 2 Bedrooms: 1
  • Upstairs 1 Full Bathrooms: 1
  • Upstairs 2 Full Bathrooms: 1
  • Downstairs 1 Half Bathrooms: 1
  • Entry Level Half Bathrooms: 1
  • Entry Level Dining Room: 1
  • Entry Level Eating Space: 1
  • Entry Level Living Room: 1
  • Recreation Room (Downstairs 1): 1
  • Utility Space (Downstairs 1): 1
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Flooring: Wood, Carpet
  • Other Rooms:Dining Room: Yes
  • Other Rooms:Great Room: Yes
  • Fireplace:Gas Log: Yes
  • Other Rooms:Bonus Room: Yes

Exterior Features

  • Common Walls: No Common Walls
  • Foundation Details: Stone
  • Patio And Porch Features: Patio

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Water Source: Public
  • Heating:Gas2: Yes

Condo/Co-op/Association

  • Association: No

Schools

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

Lot Info

  • Parcel Number: 070-000016-00
  • Lot Size Sq Ft: 10890.0
  • Additional Parcels: No

Tax Info

  • Tax Annual Amount: 24027.28

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 3, 2015
Closed on
Sep 3, 2015
Sold by
Dirkse Jon F and Davis Jill M
Bought by
Garaca Mancini Peter Robert and Garaca Mancini Maria Do Carmo
Seller's Agent
Diane Marie Koontz
Coldwell Banker Realty
Buyer's Agent
Roma Papania
RE/MAX Premier Choice
List Price
$925,000
Sold Price
$900,000
Premium/Discount to List
-$25,000
-2.7%
Current Estimated Value
$1,562,732

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$662,732
Avg. Annual Appreciation
5.65%
Original Mortgage
$540,000
Interest Rate
2.5%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jul 28, 2006
Sold by
Byam Kennedy Jr Thomas J and Byam Kennedy Jodi
Bought by
Dirkse Jon F and Davis Jill M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$320,000
Interest Rate
6.82%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 29, 1997
Sold by
Dorpalen Rose Marie
Bought by
Byam Kennedy Jr Thomas J and Byam Kennedy Jodi

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$135,000
Interest Rate
8.27%

Purchase Details

Closed on
Jan 1, 1984
Source: Public Records

Similar Homes in Columbus, OH

  • 3839 Woodbridge Rd, Columbus, OH 43220

    $1,495,000

    • 5 Beds
    • 6 Baths
    • 5,902 Sq Ft
    • 3839 Woodbridge Rd
    • Columbus, OH

    3839 Woodbridge Rd | Over 5,900 Sq Ft of Refined Living + Indoor Pool Oasis. This extraordinary 5-bedroom, 6-bath Upper Arlington home offers 5,901 sq ft of finished living space (3,178 main level + 1,557 second floor + 1,048 basement), plus an impressive 1,600+ sq ft indoor pool room—a true year-round retreat for relaxation, entertaining, and wellness.While expansive in square footage,

    Nick Vlasidis Howard Hanna Real Estate Svcs

    Section Image
  • 2015 Arlington Ave, Columbus, OH 43212

    $1,295,000

    • 4 Beds
    • 3.5 Baths
    • 2,680 Sq Ft
    • 2015 Arlington Ave
    • Columbus, OH

    Ideally situated just a stone's throw away from historic UA Mallway, this home beautifully blends timeless charm with modern luxury. This fully renovated home features two expansive additions, seamlessly integrated to enhance both functionality and square footage while preserving the home's original character. First-floor mudroom and second-floor laundry offer practical, modern living. The

    Katherine Davis Spence The Brokerage House

    Section Image
  • 2145 Waltham Rd, Columbus, OH 43221

    $1,495,000

    • 5 Beds
    • 3 Baths
    • 4,278 Sq Ft
    • 2145 Waltham Rd
    • Columbus, OH

    Situated on a large corner lot this home has the traditional UA feel but large open spaces great for everyday living or entertaining. The floorplan offers an abundance of options to suit all needs. 1st floor bedroom, full bath or an office/den. 2nd floor offers a 5th bedroom or a bonus room off of the 4th bedroom. Exceptionally large kitchen with island/breakfast bar open to a sitting room w/

    Jeff Alvis Wagenbrenner Prof. Real Estate

    Section Image
  • 2399 Brandon Rd, Columbus, OH 43221

    $1,300,000

    • 4 Beds
    • 3 Baths
    • 3,523 Sq Ft
    • 2399 Brandon Rd
    • Columbus, OH

    Rare Double Lot Home South of Lane with Pool Ideal for Remodel or New Construction. .41 Acres TotalHouse - 070-001922 is .19 Acres, Yard - 070-001923 is .22 AcresSale is ''As Is''

    John DeLibera Street Sotheby's International

    Section Image
  • 1346 Lincoln Rd, Columbus, OH 43212

    $1,225,000

    • 4 Beds
    • 3.5 Baths
    • 3,112 Sq Ft
    • 1346 Lincoln Rd
    • Columbus, OH

    Welcome to your dream home in the heart of Grandview! This stunning, completely renovated residence offers 4 spacious bedrooms, 3.5 baths and over 3,100 square feet of thoughtfully designed living space. The property features a seamless blend of modern amenities and classic charm. The expansive layout includes a bright and inviting living area, perfect for entertaining, and a chef's kitchen

    Danielle Carman MDC Realty Limited

    Section Image
  • 2727 Westmont Blvd, Columbus, OH 43221

    $1,749,000

    • 5 Beds
    • 4.5 Baths
    • 4,598 Sq Ft
    • 2727 Westmont Blvd
    • Columbus, OH

    This beautifully remodeled ranch-style home, nestled in the heart of Upper Arlington, seamlessly blends modern elegance with functional design. Boasting an open-concept layout with soaring 15-foot ceilings and high-end finishes, the residence offers 5 spacious bedrooms and 4.5 luxurious bathrooms, providing ample space for both relaxation and entertaining. The chef-inspired kitchen features sleek

    Shellil Yohannes Red 1 Realty

    Section Image
  • 3012 Oldham Rd, Columbus, OH 43221

    $1,875,000

    • 6 Beds
    • 5 Baths
    • 4,670 Sq Ft
    • 3012 Oldham Rd
    • Columbus, OH

    Brand-new, custom home that blends luxurious finishes, lighting, and craftsmanship with functional design. This home boasts a dramatic chef's kitchen with custom Amish-built cabinetry, quartz countertops, Bosch appliances, and a tucked-away Messy Kitchen with warming drawer and walk-in pantry. XL Primary Suite with Over-sized shower with dual plumbing fixtures. Private ensuite baths and walk-in

    Tim Reil Keller Williams Consultants

    Section Image
  • 2841 Doncaster Rd, Columbus, OH 43221

    $1,695,000

    • 5 Beds
    • 4.5 Baths
    • 4,190 Sq Ft
    • 2841 Doncaster Rd
    • Columbus, OH

    Tucked away on a quiet, tree-lined street in the Canterbury neighborhood of Upper Arlington, this fully reimagined ranch delivers effortless luxury and standout style. With 4,190 square feet of thoughtfully curated living space, every inch of this home has been elevated. Refinished hardwood floors flow through the open layout, where a spacious living room with a cozy fireplace leads to a casual

    Paula Koontz Gilmour KW Classic Properties Realty

    Section Image
  • 3445 Redding Rd, Columbus, OH 43221

    $1,525,000

    • 5 Beds
    • 4.5 Baths
    • 4,686 Sq Ft
    • 3445 Redding Rd
    • Columbus, OH

    New Construction to be complete this summer. This 5 bedroom 4.5 Bath home is on more than 1/3 of an Acre. with 4 beds upstairs as well as a bonus space this home lives large. The home has a three-car attached garage an 18' x 30' finished rec room downstairs as well as an additional bedroom and full bath. All bedrooms feature walk-in closets. 3 large sliders on the back of the home open to your

    Lisa Theado Theado & Company, LLC

    Section Image

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
Garaca Mancini Peter Robert $900,000 Attorney
Dirkse Jon F $752,000 Talon Group
Byam Kennedy Jr Thomas J $328,500 Connor Title Co
-- -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Germain John $1,190,000
Closed Mancini Peter Robert $150,000
Closed Mancini Peter Robert $535,000
Closed Garaca Mancini Peter Robert $540,000
Previous Owner Dirkse Jon F $375,000
Previous Owner Dirske Jon F $350,000
Previous Owner Dirkse Jon F $320,000
Previous Owner Dirkse Jon F $250,000
Previous Owner Kennedy Thomas J $417,000
Previous Owner Kennedy Thomas J $112,000
Previous Owner Byam Kennedy Jr Thomas J $135,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/31/2025 03/31/25 Off Market $1,425,000 -- --
03/27/2025 03/27/25 Off Market $900,000 -- --
06/29/2023 06/29/23 Sold $1,425,000 +7.5% $419 / Sq Ft
06/20/2023 06/20/23 Pending -- -- --
06/07/2023 06/07/23 For Sale $1,325,000 +47.2% $389 / Sq Ft
09/08/2015 09/08/15 Sold $900,000 -2.7% $300 / Sq Ft
08/09/2015 08/09/15 Pending -- -- --
08/03/2015 08/03/15 For Sale $925,000 -- $308 / 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 $25,140 $434,250 $135,140 $299,110
2023 $24,953 $433,130 $135,140 $297,990
2022 $24,196 $343,850 $85,090 $258,760
2021 $21,438 $343,850 $85,090 $258,760
2020 $21,250 $343,850 $85,090 $258,760
2019 $20,836 $300,480 $85,090 $215,390
2018 $19,143 $300,480 $85,090 $215,390
2017 $20,676 $300,480 $85,090 $215,390
2016 $17,583 $265,930 $79,520 $186,410
2015 $17,568 $265,930 $79,520 $186,410
2014 $17,587 $265,930 $79,520 $186,410
2013 $8,398 $241,745 $72,275 $169,470
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: 223017237

Columbus and Central Ohio Regional MLS

APN: 070-000016