NOT LISTED FOR SALE

347 Glengarry Dr Aurora, OH 44202

Estimated Value: $1,168,387 - $1,242,000

4 Beds
7 Baths
4,632 Sq Ft
$262/Sq Ft Est. Value

Last Sold January 17, 2014

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

Est. 77% increase in value since last sale

Current estimated payment $7,906/month

162 Days on Market

Highlights

  • On Golf Course
  • Fitness Center
  • 0.97 Acre Lot
  • Miller 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
  • Irregular Lot
  • Wooded Lot

HOA Fees

  • $191 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Garage Door Opener

Property Views

  • Golf Course
  • Trees
  • Park or Greenbelt

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Fiberglass Roof
  • Asphalt Roof

Interior Spaces

  • 2-Story Property
  • Central Vacuum
  • Wired For Sound
  • 5 Fireplaces
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Spa
  • Deck
  • Patio

Utilities

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

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 030160000191000

Community Details

Overview

  • Association fees include management, insurance, ground maintenance, reserve fund, snow removal, security
  • Barrington Master Assoc. Association
  • Barrington Subdivision

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

Parking

4

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family Residence
  • Year Built: 1997
  • Road Frontage Type: Golf Course
  • ResoLotFeatures: Cul-De-Sac, Dead End, Irregular Lot, On Golf Course, Wooded
  • ResoPoolFeatures: Community
  • Reso View: Park/Greenbelt, Golf Course, Trees/Woods
  • ResoSecurityFeatures: Security System, Smoke Detector(s)
  • Reso Association Fee Includes: Association Management, Insurance, Maintenance Grounds, Reserve Fund, Snow Removal, Security
  • Subdivision Name: Barrington
  • Reso Accessibility Features: None
  • Architectural Style: Colonial
  • Carport Y N: No
  • Garage Yn: Yes
  • Reso Interior Features: Central Vacuum, Wired for Sound
  • Unit Levels: Two
  • Property Attached Yn: No
  • Property Sub Type Additional: Single Family Residence
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Fireplaces: 5
  • Basement: Full, Partially Finished, Walk-Out Access
  • Basement: Yes
  • Spa Features: Hot Tub
  • Private Spa: Yes
  • Appliances: Cooktop, Dishwasher, Disposal, Microwave, Oven, Refrigerator
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Stories: 2

Exterior Features

  • Roof: Asphalt, Fiberglass
  • Acres: 0.97
  • View: Yes
  • Home Warranty: Yes
  • Construction Type: Brick
  • Patio And Porch Features: Deck, Patio

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 4.0
  • Parking Features: Attached, Drain, Electricity, Garage, Garage Door Opener, Paved

Utilities

  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Forced Air, Gas, Zoned
  • HeatingYN: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Fitness, Golf, Playground, Pool, Shopping, Tennis Court(s)
  • Association Fee: 572.5
  • Association Fee Frequency: Quarterly
  • Association Name: Barrington Master Assoc.
  • Association: Yes

Schools

  • Junior High Dist: Aurora CSD - 6701

Lot Info

  • Lot Size Units: Acres
  • Parcel Number: 030160000191000
  • Lot Dimensions: 295x111
  • Lot Size Sq Ft: 42253.0
  • Additional Parcels: No

Tax Info

  • Tax Annual Amount: 11433.0

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,213,462

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$528,462
Avg. Annual Appreciation
4.87%
Original Mortgage
$542,600
Outstanding Balance
$406,502
Interest Rate
4.5%
Mortgage Type
New Conventional
Estimated Equity
$806,960

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:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 N $542,600
Previous Owner Rausch Carl G $400,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/17/2014 01/17/14 Sold $685,000 -7.7% $148 / Sq Ft
01/17/2014 01/17/14 Pending -- -- --
08/08/2013 08/08/13 For Sale $742,000 -- $160 / Sq Ft
Source: MLS Now

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

  • R

    Seller's Agent in 2014

    Randi Grodin

    Deleted Agent

    Section Image
  • Elaine Beck

    Buyer's Agent in 2014

    Elaine Beck

    Howard Hanna

    (330) 256-1003

    1 in this area

    24 Total Sales

    Elaine Beck
    Section Image
See All Agents

Map

Source: MLS Now

MLS Number: 3434490

MLS Now

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

Ohio Portage County Aurora 44202

347 Glengarry Dr, Aurora, OH

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLS Now IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes