NOT LISTED FOR SALE

2542 Tremont Rd Columbus, OH 43221

Estimated Value: $1,558,812 - $2,028,000

4 Beds
5 Baths
5,006 Sq Ft
$369/Sq Ft Est. Value

Last Sold July 15, 2013

Last sale price $970,000 $194 Per Sq Ft

Est. 91% increase in value since last sale

Current estimated payment $12,287/month

35 Days on Market

Highlights

  • Whirlpool Bathtub
  • Screened Porch
  • Attached Garage
  • Barrington Road Elementary School Rated A
  • Balcony
  • 3-minute walk to Jack Nicklaus Park

About This Home

As of July 2013

ONE OF THE FINEST HOMES IN UPPER ARLINGTON! GORGEOUS & COMPLETELY RENOVATED WITH THE HIGHEST IN LUXURY APPOINTMENTS & FINISHES. THE EXQUISITE STYLE, ATTENTION TO DETAIL & WONDERFUL OPEN FLOOR PLAN MAKE IT IDEAL FOR ENTERTAINING & FAMILY LIVING. THE PERFECT BLEND OF MODERN AMENITIES & SOUTH OF LANE CHARM!

Last Agent to Sell the Property

Barbara Waters

RE/MAX Premier Choice Listed on: 05/29/2013

Last Buyer's Agent

Jane Stone

Coldwell Banker Realty License #0000211945

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,048

Year Built

  • Built in 1925

Lot Details

  • 0.31 Acre Lot
  • Irrigation

Home Design

  • Block Foundation
  • Stucco Exterior
  • Stone Exterior Construction

Interior Spaces

  • 5,006 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Gas Log Fireplace
  • Insulated Windows
  • Family Room
  • Screened Porch
  • Home Security System
  • Laundry on upper level

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Whirlpool Bathtub

Basement

  • Partial Basement
  • Recreation or Family Area in Basement
  • Crawl Space

Parking

  • Attached Garage
  • Side or Rear Entrance to Parking

Outdoor Features

  • Balcony
  • Patio

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 070-000729

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,048

Year Built

Built in 1925

Lot Details

0

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 1925
  • Tax Year: 2012
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 0.31
  • Co List Office Phone: 800-759-1112
  • MLS Status: Closed
  • Reso Fireplace Features: Gas Log
  • Reso Interior Features: Central Vacuum, Whirlpool/Tub, Dishwasher, Gas Range, 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 Amenities Gas Range: Yes
  • Interior Amenities Microwave: Yes
  • Rooms Rec RmBsmt: Yes
  • Foundation:Block: Yes
  • Rooms Family RmNon Bsmt: Yes
  • Windows Insulated All: Yes
  • Interior Amenities Dishwasher: Yes
  • Exterior:Stone: Yes
  • Exterior Amenities Balcony: Yes
  • Basement Description Crawl: 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

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

Exterior Features

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

Garage/Parking

  • Attached Garage: Yes
  • Attached Garage: Yes
  • Parking Features: Garage Door Opener, Attached Garage, Side Load

Utilities

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

Schools

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

Lot Info

  • Parcel Number: 070-000729
  • Lot Size Sq Ft: 13503.6

Tax Info

  • Tax Annual Amount: 21047.68

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 12, 2018
Sold by
Palmer Matthew C and Gallina Kelly A
Bought by
Palmer Matthew C and Gallina Kelly A
Total Days on Market
35
Current Estimated Value
$1,848,604

Purchase Details

Listed on
May 29, 2013
Closed on
Jul 12, 2013
Sold by
Neumeyer Daniel J and Neumeyer Patricia A
Bought by
Palmer Matthew C and Palmer Kelly A
Seller's Agent
Barbara Waters
RE/MAX Premier Choice
Buyer's Agent
Jane Stone
Coldwell Banker Realty
List Price
$995,000
Sold Price
$970,000
Premium/Discount to List
-$25,000
-2.51%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.56%
Original Mortgage
$679,000
Interest Rate
4.02%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 8, 2009
Sold by
Fried Dean W and Dean W Fried Declaration Of Tr
Bought by
Neumeyer Daniel J and Neumeyer Patricia A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$575,000
Interest Rate
5.11%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 29, 2007
Sold by
Fried Dean W
Bought by
Fried Dean W and Dean W Fried Declaration Of Tr

Purchase Details

Closed on
Sep 29, 2004
Sold by
Fried Dean W
Bought by
Fried Dean W

Purchase Details

Closed on
May 14, 2003
Sold by
Fried Dean W
Bought by
Fried Dean W

Purchase Details

Closed on
Jul 15, 1999
Sold by
American Mtg Solution
Bought by
Fried Dean W
Source: Public Records

Similar Homes in Columbus, OH

  • 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
  • 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
  • 3130 S Dorchester Rd, Columbus, OH 43221

    $2,168,000

    • 4 Beds
    • 4.5 Baths
    • 4,661 Sq Ft
    • 3130 S Dorchester Rd
    • Columbus, OH

    Welcome to this exquisite, brand-new Mid-Century Modern masterpiece nestled in the heart of Upper Arlington. Designed for today's discerning homeowner, this home blends timeless architectural style with modern finishes, offering an open and airy living experience that seamlessly integrates with nature.Architectural Elegance: Thoughtfully designed with clean lines, a flat roof, expansive windows,

    Lisa Theado Theado & Company, LLC

    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
  • 3519 Redding Rd, Columbus, OH 43221

    $1,498,800

    • 5 Beds
    • 4.5 Baths
    • 5,189 Sq Ft
    • 3519 Redding Rd
    • Columbus, OH

    New Construction. 5-bedroom 4.5 bath home with three car side load garage. Features large, finished basement, with a Nine-foot wet bar. Vaulted great room and HUGE pantry, Primary suite boasts two large walk-in closets, walk in shower as well as free standing tub. additional en-suite bedroom as well as Jack and Jill complete the upstairs. Nearly 1/3 of an acre is unique to this area.

    Lisa Theado Theado & Company, LLC

    Section Image
  • 1226 Lincoln Rd, Columbus, OH 43212

    $1,650,000

    • 5 Beds
    • 4.5 Baths
    • 4,440 Sq Ft
    • 1226 Lincoln Rd
    • Columbus, OH

    Modern luxury meets timeless tradition in this rare opportunity to call over 4400 sqft of above-ground living space home in the heart of Grandview. Carefully preserved original details in the home, including sliding glass doors and fireplaces, join seamlessly with myriad upgrades and additions. Full kitchen and bath renovation in 2021, new backyard pergola, patio and deck in 2023, new carpeting

    Elizabeth Kitto Red 1 Realty

    Section Image
  • 3450 River Rhone Ln, Columbus, OH 43221

    $1,950,000

    • 4 Beds
    • 4.5 Baths
    • 5,927 Sq Ft
    • 3450 River Rhone Ln
    • Columbus, OH

    Sited in an incomparable setting in a gated community along the Scioto River, this 4 level residence comprises 4BR,4.5BA and extends over 7000sq.ft.of living space.Upon entry, the features are revealed to be a Magnificent dramatically designed main floor offering a Spectacular Great room w/ Custom Fireplace surround and walls of windows that frame the views and a sitting area that could also be

    Cece Miller NextHome Experience

    Section Image
  • 2777 Donna Dr, Columbus, OH 43220

    $1,890,000

    • 5 Beds
    • 5.5 Baths
    • 4,634 Sq Ft
    • 2777 Donna Dr
    • Columbus, OH

    Welcome to this exceptional, fully renovated home with a major addition, offering 4,334 sq ft of above-grade living space and approx. 4,634 total finished sq ft. This modern residence features 5 bedrooms and 5.5 bathrooms, blending luxury, space, and functionality. The open-concept main level boasts a stunning great room with a double-sided gas fireplace, and a chef's kitchen with quartz

    Kyle Edwards The Brokerage House

    Section Image
  • 884 Neil Ave, Columbus, OH 43215

    $1,383,000

    • 4 Beds
    • 5 Baths
    • 5,875 Sq Ft
    • 884 Neil Ave
    • Columbus, OH

    RARE OPPORTUNITY! Grab your chance to own a piece of history in one of Columbus' most sought after, historic neighborhoods. This stately brick Victorian boasts FOUR levels of living and entertaining space with 4 bedrooms and 5 bathrooms. It has been beautifully renovated while protecting it's original charm, this Victorian masterpiece blends old with new. Prepare to be ''wowed'' the second

    Jodee Gill Berkshire Hathaway HS Pro Rlty

    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
Palmer Matthew C -- None Available
Palmer Matthew C $970,000 Talon Title A
Neumeyer Daniel J $900,000 Title First
Fried Dean W -- Attorney
Fried Dean W -- --
Fried Dean W -- --
Fried Dean W -- --
Fried Dean W -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Palmer Matthew C $500,000
Closed Palmer Matthew C $679,000
Previous Owner Neumeyer Patricia A $560,000
Previous Owner Neumeyer Daniel J $575,000
Previous Owner Fried Dean W $750,000
Previous Owner Fried Dean W $500,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/27/2025 03/27/25 Off Market $970,000 -- --
07/15/2013 07/15/13 Sold $970,000 -2.5% $194 / Sq Ft
06/15/2013 06/15/13 Pending -- -- --
05/28/2013 05/28/13 For Sale $995,000 -- $199 / 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 $29,711 $513,210 $144,240 $368,970
2023 $29,343 $513,205 $144,235 $368,970
2022 $27,845 $398,480 $89,150 $309,330
2021 $24,818 $398,480 $89,150 $309,330
2020 $24,431 $398,480 $89,150 $309,330
2019 $24,057 $346,930 $89,150 $257,780
2018 $22,596 $346,930 $89,150 $257,780
2017 $23,314 $368,210 $89,150 $279,060
2016 $21,290 $322,000 $93,870 $228,130
2015 $21,272 $322,000 $93,870 $228,130
2014 $21,296 $322,000 $93,870 $228,130
2013 $11,186 $322,000 $93,870 $228,130
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Columbus and Central Ohio Regional MLS

MLS Number: 213019098

Columbus and Central Ohio Regional MLS

APN: 070-000729