NOT LISTED FOR SALE

347 Glengarry Dr Aurora, OH 44202

Estimated Value: $1,120,000 - $1,337,000

4 Beds
7 Baths
4,935 Sq Ft
$243/Sq Ft Est. Value

Last Sold January 17, 2014

Last sale price $685,000 $139 Per Sq Ft

Est. 75% increase in value since last sale

Current estimated payment $8,225/month

162 Days on Market

Highlights

  • On Golf Course
  • Fitness Center
  • 0.97 Acre Lot
  • Leighton Elementary School Rated A
  • Spa
  • Colonial Architecture

About This Home

As of January 2014

Stately all brick home nestled on .97 acres with private view of 15th tee in Barrington's Gated Golf Community. This exquisitely designed 4 BR residence is a delight to behold. Beautiful quality with superb details. A wonderful family home. Gourmet kitchen open to cozy hearth room, lavish master suite on first, grand great room with walls of windows, fireplace & wet bar, formal living room & dining room. Beautifully detailed library. 2 staircases leading up to 3 generous bedrooms, walk in closets & in suite baths. Fabulous finished walk out lower level w/1900 square ft, exercise room, game room, wet bar with refrigerator, family room, office & full bath . A great home to entertain inside & out. Immaculate! 4 car garage. Lush landscaping. Deck, patio. You can walk to swim & tennis within minutes. A must see!

Last Agent to Sell the Property

Randi Grodin

Deleted Agent License #391906 Listed on: 08/08/2013

Last Buyer's Agent

Elaine Beck

Howard Hanna License #196144

Howard Hanna

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,433

Year Built

  • Built in 1997

Lot Details

  • 0.97 Acre Lot
  • Lot Dimensions are 295x111
  • On Golf Course
  • Cul-De-Sac
  • Street terminates at a dead end
  • Sprinkler System
  • Wooded Lot

HOA Fees

  • $191 Monthly HOA Fees

Property Views

  • Golf Course
  • Woods
  • Park or Greenbelt

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Asphalt Roof

Interior Spaces

  • 4,935 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Sound System
  • 5 Fireplaces

Kitchen

  • <<builtInOvenToken>>
  • Cooktop<<rangeHoodToken>>
  • <<microwave>>
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Home Security System
  • Fire and Smoke Detector

Parking

  • 4 Car Attached Garage
  • Garage Drain
  • Garage Door Opener

Outdoor Features

  • Spa
  • Deck
  • Patio

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 030160000191000

Community Details

Overview

  • Association fees include insurance, landscaping, property management, reserve fund, security staff, snow removal
  • Barrington Community

Amenities

  • Shops

Recreation

  • Golf Course Community
  • Tennis Courts
  • Community Playground
  • Fitness Center
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,433

Year Built

Built in 1997

Lot Details

0

HOA Fees

$191 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family
  • Dwelling Type: Detached
  • Style: Colonial
  • Price Per Square Foot: 138.80
  • Num Of Stories: 2.00
  • Total Sq Ft: 4935
  • Year Built: 1997
  • Geocode Confidence: Unknown
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances Equipment: Audio System, Central Vacuum, Cooktop, Dishwasher, Garbage Disposal, Microwave, Wall Oven, Refrigerator, Security System, Smoke Detector, Hot Tub
  • Fireplaces: 5
  • Total Bedrooms: 4
  • Total Bathrooms: 7.00
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Room Count: 23
  • Basement Detail: Full, Partially Finished, Walk-Out
  • Living Area Sq Ft: 4935
  • Estimated Total Living Area: 4935
  • Estimated Sq Ft: 4935

Exterior Features

  • View: Golf Course, Park, Wooded
  • Exterior: Brick
  • Exterior Features: Deck, Patio, Sprinkler/Irrigation
  • Roof: Asphalt/Fiberglass

Garage/Parking

  • Driveway: Paved
  • Garage Features: Attached, Door Opener, Drain, Electric
  • Garage Num Of Cars: 4

Utilities

  • Cooling Type: Central Air
  • Heating Fuel: Gas
  • Heating Type: Forced Air, Zoned
  • Water/Sewer: Public Water, Public Sewer

Association/Amenities

  • Amenities: Exercise Room, Golf Available, Playground, Pool, Shopping/Mall, Tennis Courts

Condo/Co-op/Association

  • HOA Fees: 572.50
  • HOA Fee Frequency: Quarterly
  • Hoa Name: Barrington Master Assoc.
  • Subdivision Complex: Barrington

Fee Information

  • HOA Fee Includes: Association Insurance, Landscaping, Property Management, Reserve Fund, Security Staff, Snow Removal

Schools

  • School District: Aurora CSD
  • School District: Aurora CSD

Lot Info

  • Lot Dimensions: 295x111
  • Lot Description: Cul de Sac, Dead End Street, Golf Course Frontage, Wooded/Treed
  • Lot Size Area Sq Ft: 42253.0000
  • Lot Size Units: Acres
  • Price Per Acre: 706185.57
  • Acres: 0.9700
  • Parcel Number: 030160000191000

Tax Info

  • Tax: 11433

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 8, 2013
Closed on
Jan 10, 2014
Sold by
Galvis Miguel Fernando Rangel and Guevara Alexandra Gonzalez
Bought by
Trivedi Hemant N and Trivedi Daksha
Seller's Agent
Randi Grodin
Deleted Agent
Buyer's Agent
Elaine Beck
Howard Hanna
List Price
$742,000
Sold Price
$685,000
Premium/Discount to List
-$57,000
-7.68%
Current Estimated Value
$1,201,107

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$516,107
Avg. Annual Appreciation
4.56%
Original Mortgage
$542,600
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 8, 2012
Sold by
Scharler John P
Bought by
Galvis Miguel Fernando Rangel and Guevara Alexandra Gonzalez

Purchase Details

Closed on
Nov 5, 2010
Sold by
Rausch Carl G and Rausch Valerie A
Bought by
Scharler John P

Purchase Details

Closed on
Feb 16, 1999
Sold by
Ken Payne Builders Inc
Bought by
Rausch Carl G and Rausch Valerie A

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 30, 1995
Sold by
Breezy Point Ltd
Bought by
Ken Payne Builders Inc
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
Trivedi Hemant N $678,300 None Available
Galvis Miguel Fernando Rangel $645,000 Revere Title
Scharler John P $715,000 Revere Title
Rausch Carl G $829,500 Midland Title Security Inc
Ken Payne Builders Inc $166,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Trivedi Hemant $470,000
Closed Trivedi Hemant N $540,000
Closed Trivedi Hemant N $542,600
Previous Owner Rausch Carl G $400,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/17/2014 01/17/14 Sold $685,000 -7.7% $139 / Sq Ft
01/17/2014 01/17/14 Pending -- -- --
08/08/2013 08/08/13 For Sale $742,000 -- $150 / Sq Ft
Source: MLS Now

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 $16,813 $376,120 $91,880 $284,240
2023 $16,027 $291,900 $73,500 $218,400
2022 $14,514 $291,900 $73,500 $218,400
2021 $14,596 $291,900 $73,500 $218,400
2020 $12,394 $231,420 $73,500 $157,920
2019 $12,494 $231,420 $73,500 $157,920
2018 $12,208 $205,560 $56,390 $149,170
2017 $12,208 $205,560 $56,390 $149,170
2016 $11,000 $205,560 $56,390 $149,170
2015 $11,311 $205,560 $56,390 $149,170
2014 $11,541 $205,560 $56,390 $149,170
2013 $11,469 $205,560 $56,390 $149,170
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Now

MLS Number: 3434490

MLS Now

APN: 03-016-00-00-191-000