NOT LISTED FOR SALE

5757 Trafalgar Ln Unit 583 Dublin, OH 43016

Estimated Value: $768,589 - $858,000

4 Beds
3.5 Baths
3,467 Sq Ft
$234/Sq Ft Est. Value

Last Sold December 29, 2015

Last sale price $510,115 $147 Per Sq Ft

Est. 59% increase in value since last sale

Current estimated payment $5,470/month

416 Days on Market

Highlights

  • Newly Remodeled
  • Wood Flooring
  • Patio
  • Washington Elementary School Rated A-
  • 3 Car Attached Garage
  • Garden Bath

About This Home

As of December 2015

New construction in beautiful Ballantrae. This home features 4BR, 3.5BA, 3 car side entry garage, full ready to finish basement with full bath rough-in, 1st floor laundry & approx 3467 sq ft of living space. The 1st flr features a 2 story foyer w/hardwood flrs, spacious family rm w/fireplace, formal dining rm w/hardwood flrs, study w/french doors & unique light-filled solarium w/picture windows. The kitchen offers a furniture island, pantry, built-in stainless steel appliances, upgraded multi height cabinetry, hardwood flrs, granite counter & bay window. The 2nd flr boasts a huge owners retreat w/designer bath featuring separate shower & soaking tub, double vanity, his & her WICs. 2 of 3 spacious secondary BRs have WICs & the 3rd BR has privat bathroom perfect for guests. Loaded w/upgrades

Last Agent to Sell the Property

Alexander Hencheck

HMS Real Estate License #0000198425 Listed on: 09/12/2014

Last Buyer's Agent

Muhammad Arifeen

Keller Williams Consultants License #2013003480

Keller Williams Consultants

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,759

Year Built

  • Built in 2014 | Newly Remodeled

Lot Details

  • 0.34

Parking

  • 3 Car Attached Garage

Home Design

  • Poured Concrete
  • Stone Exterior Construction

Interior Spaces

  • 3,467 Sq Ft Home
  • 2-Story Property
  • Gas Log Fireplace
  • Insulated Windows
  • Family Room
  • Basement Fills Entire Space Under The House
  • Laundry on main level

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Garden Bath

Utilities

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

Additional Features

  • Patio
  • 0.34 Acre Lot

Community Details

  • Property has a Home Owners Association
  • Association Phone (614) 781-0055
  • Sterling Town Prop. HOA

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 274-001509

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,759

Year Built

Built in 2014 | Newly Remodeled

Lot Details

0

Parking

3

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 2014
  • Tax Year: 2013
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 0.34
  • Co List Office Phone: 513-469-2424
  • MLS Status: Closed
  • Subdivision Name: Ballantrae
  • Reso Fireplace Features: Gas Log
  • Reso Interior Features: Dishwasher, Garden/Soak Tub, Gas Range, Microwave
  • Unit Levels: Two
  • New Construction: Yes
  • Reso Window Features: Insulated All
  • Basement Basement YN2: Yes
  • Rooms:Living Room: Yes
  • Air Conditioning Central: Yes
  • Interior Flooring Carpet: Yes
  • Interior Amenities Gas Range: Yes
  • Interior Amenities Microwave: Yes
  • Foundation:Poured: Yes
  • Interior Flooring CeramicPorcelain: Yes
  • Rooms Family RmNon Bsmt: Yes
  • Windows Insulated All: Yes
  • Interior Amenities Dishwasher: Yes
  • Exterior:Stone: Yes
  • Interior Amenities GardenSoak Tub: Yes
  • Rooms 1st Flr Laundry: Yes
  • Levels Two2: Yes
  • Common Walls No Common Walls: Yes
  • Special Features: 4098
  • Property Sub Type: Detached

Interior Features

  • Upstairs Bedrooms: 4
  • Upstairs 1 Full Bathrooms: 3
  • Entry Level Half Bathrooms: 1
  • Basement: Full
  • Entry Level Dining Room: 1
  • Entry Level Eating Space: 1
  • Entry Level Family Room: 1
  • Entry Level Living Room: 1
  • Utility Space (Entry Level): 1
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Flooring: Wood, Carpet, Ceramic/Porcelain
  • Other Rooms:Dining Room: Yes
  • Basement Description:Full: Yes
  • Fireplace:Gas Log: Yes

Exterior Features

  • Home Warranty: Yes
  • Common Walls: No Common Walls
  • Exterior Features: Other
  • Foundation Details: Poured
  • Patio And Porch Features: Patio
  • Patio and Porch Features Patio: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Attached Garage: Yes
  • Parking Features: Attached Garage
  • Parking Features Attached Garage: Yes
  • Parking Features 3 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

  • Contact Name: Sterling Town Prop.
  • Association Fee: 200.0
  • Phone: 614-781-0055
  • Association: Yes

Schools

  • Junior High Dist: HILLIARD CSD 2510 FRA CO.

Lot Info

  • Parcel Number: 274-001509
  • Lot Size Sq Ft: 14810.4
  • Additional Parcels: No

Tax Info

  • Tax Annual Amount: 2759.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 7, 2022
Sold by
Al Mustafa and Al Sondos
Bought by
Mccauley Aldina and Mccauley Patrick
Current Estimated Value
$811,397

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$661,500
Outstanding Balance
$625,819
Interest Rate
3.75%
Mortgage Type
New Conventional
Estimated Equity
$170,824

Purchase Details

Closed on
May 27, 2022
Sold by
Al Mustafa and Al Sondos
Bought by
Mccauley Aldina and Mccauley Patrick

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$661,500
Outstanding Balance
$625,819
Interest Rate
3.75%
Mortgage Type
New Conventional
Estimated Equity
$170,824

Purchase Details

Listed on
Sep 12, 2014
Closed on
Dec 22, 2015
Sold by
Fischer Homes Columbu Lp
Bought by
Mustafa Nowwar and Sad Sondos Al
Seller's Agent
Alexander Hencheck
HMS Real Estate
Buyer's Agent
Muhammad Arifeen
Keller Williams Consultants
List Price
$535,990
Sold Price
$510,115
Premium/Discount to List
-$25,875
-4.83%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.68%
Original Mortgage
$407,272
Interest Rate
3.96%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jan 16, 2015
Sold by
Edwards Golf Communities Llc
Bought by
Fischer Homes Columbus Lp
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
Mccauley Aldina $735,000 Northwest Title
Mccauley Aldina $735,000 Northwest Title
Mustafa Nowwar $510,200 Independent Title Svcs Inc
Fischer Homes Columbus Lp $107,500 Talon Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mccauley Aldina $661,500
Closed Mccauley Aldina $661,500
Previous Owner Mustafa Nowwar $407,272
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/27/2025 03/27/25 Off Market $510,115 -- --
12/29/2015 12/29/15 Sold $510,115 -4.8% $147 / Sq Ft
11/29/2015 11/29/15 Pending -- -- --
09/12/2014 09/12/14 For Sale $535,990 -- $155 / 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 $14,017 $229,920 $58,800 $171,120
2023 $12,270 $229,915 $58,800 $171,115
2022 $11,503 $171,610 $46,200 $125,410
2021 $11,343 $171,610 $46,200 $125,410
2020 $11,606 $171,610 $46,200 $125,410
2019 $12,326 $156,070 $42,000 $114,070
2018 $6,161 $156,070 $42,000 $114,070
2017 $12,289 $156,070 $42,000 $114,070
2016 $13,336 $157,120 $38,780 $118,340
2015 $1,501 $34,860 $34,860 $0
2014 $2,850 $34,860 $34,860 $0
2013 $1,442 $33,215 $33,215 $0
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: 214039510

Columbus and Central Ohio Regional MLS

APN: 274-001509