NOT LISTED FOR SALE

575 Herrogate Square Unit 290 Pickerington, OH 43147

Estimated Value: $490,770 - $538,000

4 Beds
2.5 Baths
4,200 Sq Ft
$123/Sq Ft Est. Value

Last Sold November 01, 2013

Last sale price $250,000 $60 Per Sq Ft

Est. 106% increase in value since last sale

Current estimated payment $3,404/month

38 Days on Market

Highlights

  • Newly Remodeled
  • Heated Sun or Florida Room
  • Forced Air Heating and Cooling System
  • Sycamore Creek Elementary School Rated A-
  • Attached Garage
  • Family Room

About This Home

As of November 2013

New construction in beautiful Preston Trails. This home features colonial style brick front, full finished basement with bath rough-in. Sunroom, owners suite with deluxe bathroom, double bowl sink in hall bathroom, 9ft ceilings, gourmet kitchen with upgraded 42in cabinets, kitchen island, upgraded lighting, upgraded carpet, wroght iron railing throughout.

Last Agent to Sell the Property

Alexander Hencheck

HMS Real Estate License #198425 Listed on: 08/27/2013

Last Buyer's Agent

Robb Harpster

Howard Hanna RealCom Realty License #2002014414

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $712

Year Built

  • Built in 2013 | Newly Remodeled

Lot Details

  • 8,276 Sq Ft Lot

Parking

  • Attached Garage

Home Design

  • Brick Exterior Construction
  • Vinyl Siding

Interior Spaces

  • 4,200 Sq Ft Home
  • 2-Story Property
  • Insulated Windows
  • Family Room
  • Heated Sun or Florida Room
  • Carpet
  • Dishwasher
  • Laundry on main level
  • Basement

Bedrooms and Bathrooms

  • 4 Bedrooms

Utilities

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

Community Details

  • Property has a Home Owners Association

Listing and Financial Details

  • Builder Warranty
  • Assessor Parcel Number 0410750400

Home Details

Home Type

Single Family

Est. Annual Taxes

$712

Year Built

Built in 2013 | Newly Remodeled

Lot Details

0

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 2013
  • Tax Year: 2012
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 0.19
  • Co List Office Phone: 513-469-2424
  • MLS Status: Closed
  • Subdivision Name: Preston Trails
  • Reso Interior Features: Dishwasher
  • 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
  • Foundation:Poured: Yes
  • Exterior Vinyl Siding: Yes
  • Rooms Family RmNon Bsmt: Yes
  • Windows Insulated All: Yes
  • Interior Amenities Dishwasher: Yes
  • Exterior Brick: Yes
  • Warranty Building: Yes
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Upstairs Bedrooms: 4
  • Upstairs 1 Full Bathrooms: 2
  • 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
  • Recreation Room (Downstairs 1): 1
  • Utility Space (Entry Level): 1
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Flooring: Wood, Carpet
  • Other Rooms:Dining Room: Yes
  • Basement Description:Full: Yes

Exterior Features

  • Common Walls: No Common Walls
  • Foundation Details: Poured

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

  • Association Fee: 130.0
  • Association: Yes

Schools

  • Junior High Dist: PICKERINGTON LSD 2307 FAI CO.

Lot Info

  • Parcel Number: 0410750400
  • Lot Size Sq Ft: 8276.4
  • Additional Parcels: No

Tax Info

  • Tax Annual Amount: 711.58

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 27, 2013
Closed on
Nov 1, 2013
Sold by
Westport Homes Inc
Bought by
Chukwu Clement C
Seller's Agent
Alexander Hencheck
HMS Real Estate
Buyer's Agent
Robb Harpster
Howard Hanna RealCom Realty
List Price
$259,990
Sold Price
$250,000
Premium/Discount to List
-$9,990
-3.84%
Total Days on Market
38
Current Estimated Value
$514,693

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$264,693
Avg. Annual Appreciation
6.42%
Original Mortgage
$241,537
Interest Rate
4.33%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 31, 2008
Sold by
Westport Property Group Llc
Bought by
Westport Homes Of Ohio Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$31,000,000
Interest Rate
5.08%
Mortgage Type
Construction
Source: Public Records

Similar Homes in Pickerington, OH

  • 163 Balderson Dr, Pickerington, OH 43147

    $489,000

    • 5 Beds
    • 3 Baths
    • 2,846 Sq Ft
    • 163 Balderson Dr
    • Pickerington, OH

    **Move-In Ready!**Discover this stunning 5-bedroom, 3-bathroom home, boasting nearly 2,900 sq. ft. of luxurious living space. Built by DR Horton, this Hampshire model features a spacious two-story design with a large second-floor loft and a front-load 3-car garage.Step inside to an inviting open floor plan highlighted by 9-foot ceilings on the first floor. You'll find a private office/flex space

    Don Shaffer Howard HannaRealEstateServices

    Section Image
  • 275 Crestview Ln, Pickerington, OH 43147

    $494,900

    • 4 Beds
    • 2.5 Baths
    • 2,628 Sq Ft
    • 275 Crestview Ln
    • Pickerington, OH

    Why build new when you can buy this stunning, move-in-ready, over 2,600 sq ft, 4-bedroom, 2.5-bath, 3-year-young two-story home with all the extras? Situated on one of the best lots in the community, this home backs to beautiful, unobstructed views of walking paths and a pond.The floor plan features a den/flex space, an expansive great room with fireplace, a formal dining area, and a fabulous,

    Don Shaffer Howard HannaRealEstateServices

    Section Image
  • 12052 Peppermill Ln, Pickerington, OH 43147

    $499,900

    • 4 Beds
    • 2.5 Baths
    • 3,300 Sq Ft
    • 12052 Peppermill Ln
    • Pickerington, OH

    Welcome to this completely renovated 4-bedroom, 2.5-bath home in Pickerington Schools! Great split level layout with 4 finished levels and 3300SF! The main floor boasts LVP flooring throughout, a bright open layout, cozy eating space, and an all-new kitchen. Off the kitchen, an incredible large sunroom feels like a cozy cabin, perfect for relaxing year-round.The huge first floor owner suite

    Chris Shea Keller Williams Consultants

    Section Image
  • 7227 Stemen Rd, Pickerington, OH 43147

    $619,900

    • 4 Beds
    • 4 Baths
    • 3,020 Sq Ft
    • 7227 Stemen Rd
    • Pickerington, OH

    Welcome to 7227 Stemen Road in Pickerington! Pride of ownership shines in every corner of this meticulously maintained 2-story home, nestled on a beautifully landscaped 0.77-acre lot with mature trees. Boasting over 3,000 sq ft of living space, this home features 4 generous bedrooms, 2 full baths, and 2 half baths—including one in the finished basement. The first floor offers a formal living and

    Sherry Looney Howard HannaRealEstateServices

    Section Image
  • 8628 N Spring Ct, Pickerington, OH 43147

    $519,900

    • 4 Beds
    • 3.5 Baths
    • 3,100 Sq Ft
    • 8628 N Spring Ct
    • Pickerington, OH

    **The Perfect Multi-Generational Home!**Featuring **two first-floor primary suites**, each with a private full bath and walk-in closet, this custom-built Hiser home offers flexibility and comfort for all stages of life. With nearly 3,100 total square feet, this 4-bedroom, 3.5-bath two-story home includes a stunning sunroom, a finished rec room in the lower level, and **two 2-car garages**—or use

    Don Shaffer Howard HannaRealEstateServices

    Section Image
  • 13743 Bainwick Dr NW, Pickerington, OH 43147

    $599,900

    • 4 Beds
    • 3.5 Baths
    • 4,200 Sq Ft
    • 13743 Bainwick Dr NW
    • Pickerington, OH

    Open House: Sunday, May 18th | 1-3 PMLove to Entertain? This Home Has It All!Welcome to nearly 4,200 sq ft of custom-crafted living designed for comfort, luxury, and entertaining. This stunning 4-bedroom, 3.5-bath home sits on an oversized 0.47-acre lot and includes a professionally finished lower level, a resort-style backyard, and a contemporary layout that will impress from the moment you walk

    Don Shaffer Howard HannaRealEstateServices

    Section Image
  • 13682 Cobblestone Ln, Pickerington, OH 43147

    $399,900

    • 4 Beds
    • 2.5 Baths
    • 2,350 Sq Ft
    • 13682 Cobblestone Ln
    • Pickerington, OH

    Welcome to 13682 Cobblestone Lane NW in New England Acres - Pickerington, OHLocated in the charming New England Acres neighborhood, this beautifully updated 4-bedroom, 2.5-bath home sits on nearly an acre of land, offering the perfect blend of comfort, style, and space, both indoors and out.Inside, you'll find fresh paint throughout, updated bathrooms, and a spacious layout ideal for both

    Don Shaffer Howard HannaRealEstateServices

    Section Image
  • 430 Sycamore Creek St, Pickerington, OH 43147

    $399,000

    • 4 Beds
    • 2.5 Baths
    • 2,004 Sq Ft
    • 430 Sycamore Creek St
    • Pickerington, OH

    Welcome to your dream home! This beautifully updated 4-bedroom, 3-bath residence offers 2,000 square feet of open, inviting living space. Situated on a generous fenced-in lot, the home boasts a spacious backyard perfect for entertaining or relaxing in privacy. Step inside to discover all-new flooring and plush carpeting throughout, complemented by a freshly painted interior and soaring cathedral

    Derek Zaffini e-Merge Real Estate

    Section Image
  • 422 Wooster St, Pickerington, OH 43147

    $449,900

    • 3 Beds
    • 2 Baths
    • 2,813 Sq Ft
    • 422 Wooster St
    • Pickerington, OH

    Looking for emaculate? You just found it! This 3 br, 2 bth one story is ''move in, sit back & enjoy'' ready. Sitting on a large lot within walking distance to the elementry school, you'll be impressed with what this 2,813 sq ft ranch has to offer and how well mantained it is. The kitchen is furnished with an island, black SS appliances plenty of counter and cabinet space as well as an eating

    Judith Casmo e-Merge Real Estate

    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
Chukwu Clement C $250,000 Talon Title
Westport Homes Of Ohio Inc $646,000 Talon Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Chukwu Clement C $209,500
Closed Chukwu Clement C $241,537
Previous Owner Westport Homes Of Ohio Inc $31,000,000
Previous Owner Westport Homes Of Ohio Inc $2,232,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/01/2013 11/01/13 Sold $250,000 -3.8% $60 / Sq Ft
10/02/2013 10/02/13 Pending -- -- --
08/27/2013 08/27/13 For Sale $259,990 -- $62 / 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 $18,424 $149,670 $14,410 $135,260
2023 $7,056 $149,670 $14,410 $135,260
2022 $7,079 $149,670 $14,410 $135,260
2021 $6,454 $116,200 $12,530 $103,670
2020 $6,525 $116,200 $12,530 $103,670
2019 $6,565 $116,200 $12,530 $103,670
2018 $6,037 $94,760 $12,530 $82,230
2017 $6,046 $93,140 $10,910 $82,230
2016 $6,015 $93,140 $10,910 $82,230
2015 $5,897 $86,330 $10,910 $75,420
2014 $5,308 $86,330 $10,910 $75,420
2013 $5,308 $10,910 $10,910 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Columbus and Central Ohio Regional MLS

MLS Number: 213031539

Columbus and Central Ohio Regional MLS

APN: 04-10750-400