NOT LISTED FOR SALE

200 Rosa Ln Lafayette, IN 47905

Estimated Value: $692,843 - $937,000

4 Beds
3 Baths
4,104 Sq Ft
$193/Sq Ft Est. Value

Last Sold September 29, 2017

Last sale price $438,250 $107 Per Sq Ft

Est. 81% increase in value since last sale

Current estimated payment $4,597/month

214 Days on Market

Highlights

  • Fitness Center
  • In Ground Pool
  • Living Room with Fireplace
  • Hershey Elementary School Rated A-
  • Open Floorplan
  • Vaulted Ceiling

About This Home

As of September 2017

Welcome home to this stunning estate in a peaceful quiet neighborhood. Custom built walk-out ranch on 5 acres. Upon entering you will notice the gorgeous hardwood floors, fresh paint, high ceilings and open floor plan. Fabulous kitchen offers, new marble counters, undermount sink and stainless steel appliances. Kitchen opens to family room with natural daylight galore. Expect to be impressed with the breathtaking views from the wrap around porch overlooking your very own heated inground pool & pool house with all your entertaining needs right at your fingertips. This home offers two master ensuites, custom title bathrooms. 3 car garage and several out buildings. This dream home could be yours!

Last Agent to Sell the Property

Allyson Schutte

Epique Inc. Listed on: 01/24/2017

Epique Inc.

Last Buyer's Agent

Lori Morris

Indiana Integrity REALTORS

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,873

Year Built

  • Built in 1989

Lot Details

  • 5 Acre Lot
  • Backs to Open Ground
  • Wood Fence
  • Chain Link Fence
  • Landscaped
  • Irregular Lot
  • Partially Wooded Lot

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Poured Concrete
  • Shingle Roof
  • Stone Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • Open Floorplan
  • Wet Bar
  • Vaulted Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Double Pane Windows
  • Entrance Foyer
  • Living Room with Fireplace
  • 2 Fireplaces
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Solid Surface Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Double Vanity
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Electric Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Fireplace in Basement
  • 1 Bathroom in Basement
  • 2 Bedrooms in Basement

Outdoor Features

  • In Ground Pool
  • Balcony
  • Covered Deck
  • Covered Patio or Porch

Location

  • Suburban Location

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Well
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 79-08-18-226-002.000-009

Community Details

Amenities

  • Community Fire Pit

Recreation

  • Fitness Center
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,873

Year Built

Built in 1989

Lot Details

0

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 1989
  • Age: 28
  • Style: One Story
  • Architectural Style: Ranch
  • Total Number of Rooms: 10
  • Total Number of Rooms Below Grade: 4
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 2
  • Total Bathrooms: 3
  • Total Full Bathrooms: 3
  • Legal Description: PT NE SEC 18 TWP 23 R3 5.01
  • Parcel Number ID: 79-08-18-226-002.000-009
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Balcony, Cable Available, Ceiling Fan(s), Ceilings-Vaulted, Countertops-Solid Surf, Deck Covered, Detector-Smoke, Disposal, Dryer Hook Up Electric, Eat-In Kitchen, Firepit, Foyer Entry, Garage Door Opener, Landscaped, Open Floor Plan, Porch Covered, Range/Oven Hk Up Gas/Elec, Six Panel Doors, Twin Sink Vanity, Utility Sink, Wet Bar, Stand Up Shower, Tub/Shower Combination, Main Floor Laundry
  • Location: City/Town/Suburb
  • Number Below Grade Bedrooms: 2
  • Road Surface: Paved
  • Sp Lp Percent: 93.44
  • Special Features: None

Interior Features

  • Total Sq Ft: 4104
  • Total Finished Sq Ft: 4104
  • Above Grade Finished Sq Ft: 2052
  • Below Grade Finished Sq Ft: 2052
  • Basement: Yes
  • Basement Foundation: Walk-Out Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 2
  • Fireplace: Family Rm, Living/Great Rm, Gas Log, Wood Burning, Basement
  • Flooring: Hardwood Floors, Carpet, Tile
  • Living Great Room: Dimensions: 12x28, On Level: Main
  • Kitchen: Dimensions: 13x14, On Level: Main
  • Dining Room: Dimensions: 12x15, On Level: Main
  • Family Room: Dimensions: 29x29, On Level: Basement
  • Extra Room: Dimensions: 11x11, On Level: Main
  • Bedroom 1: Dimensions: 16x23, On Level: Main
  • Bedroom 2: Dimensions: 13x16, On Level: Main
  • Bedroom 3: Dimensions: 16x20, On Level: Basement
  • Bedroom 4: Dimensions: 12x15, On Level: Basement
  • Main Level Sq Ft: 2052
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 2
  • Total Below Grade Sq Ft: 2052

Exterior Features

  • Exterior: Stone, Vinyl
  • Roof Material: Shingle
  • Outbuilding1: Bath House, Dimensions: 12x20
  • Pool: Below Ground
  • Pool: Yes
  • Fence: Chain Link, Wood
  • Outbuilding2: Shed, Dimensions: 8x8, 64

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 35x24
  • Garage Sq Ft: 840

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Water Utilities: Well
  • Hvac: Ceiling Fan
  • Laundry: Dimensions: 4xMain, On Level: 6
  • Well Type: Unknown

Condo/Co-op/Association

  • Common Amenities: Exercise Room, Swimming Pool

Schools

  • School District: Tippecanoe School Corp.
  • Elementary School: Hershey
  • Middle School: East Tippecanoe
  • High School: William Henry Harrison

Lot Info

  • Lot Description: Irregular, Partially Wooded
  • Lot Dimensions: 5A
  • Estimated Lot Sq Ft: 217800
  • Estimated Lot Size Acres: 5

Green Features

  • Energy Efficient Windows/Doors: Double Pane Windows

Tax Info

  • Annual Taxes: 2872.8
  • Exemptions: Homestead, Mortgage

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jan 6, 2023
Sold by
Kosdrosky Richard A and Kosdrosky Cheryl A
Bought by
Richard A Kosdrosky Living Trust
Current Estimated Value
$791,711

Purchase Details

Listed on
Jan 24, 2017
Closed on
Sep 28, 2017
Sold by
Davis Keith B
Bought by
Kosdrosky Richard A and Kosdrosky Cheryl A
Seller's Agent
Allyson Schutte
Epique Inc.
Buyer's Agent
Lori Morris
Indiana Integrity REALTORS
List Price
$499,900
Sold Price
$438,250
Premium/Discount to List
-$61,650
-12.33%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.75%

Purchase Details

Listed on
May 13, 2015
Closed on
Jun 30, 2015
Sold by
Marshall Roger L and Marshall Janet M
Bought by
Davis Keith B
Seller's Agent
Sherry Cole
Keller Williams Lafayette
Buyer's Agent
Allyson Schutte
Epique Inc.
List Price
$465,000
Sold Price
$465,000

Home Financials for this Owner

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

Purchase Details

Listed on
Sep 24, 2012
Closed on
Aug 31, 2012
Sold by
Lods Scott L
Bought by
Marshall Roger L and Marshall Janet M
Seller's Agent
Kristy Sporre
Keller Williams Lafayette
Buyer's Agent
Kristy Sporre
Keller Williams Lafayette
List Price
$450,000
Sold Price
$450,000

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 21, 2010
Sold by
Lods Lana Lanie
Bought by
Lods Scott L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$340,000
Interest Rate
4.62%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Mar 30, 2010
Sold by
Lods Scott L
Bought by
Lods Lana Lanie

Purchase Details

Closed on
Mar 28, 2007
Sold by
Prudential Relocation Inc
Bought by
Lods Scott L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$347,500
Interest Rate
6.22%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 24, 2007
Sold by
Wall Charles G and Wall Nancy D
Bought by
Prudential Relocation Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$347,500
Interest Rate
6.22%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 1, 2005
Sold by
Jennewein Michael J and Jennewein Joan M
Bought by
Wall Charles G and Wall Nancy D

Purchase Details

Closed on
Feb 10, 2003
Sold by
Lopatka Craig W and Lopatka Kimberly J
Bought by
Jennewein Michael J and Jennewein Joan M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$324,000
Interest Rate
6.5%
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
Richard A Kosdrosky Living Trust -- --
Kosdrosky Richard A -- --
Davis Keith B -- --
Marshall Roger L -- None Available
Lods Scott L -- None Available
Lods Lana Lanie -- None Available
Lods Scott L -- None Available
Prudential Relocation Inc -- None Available
Wall Charles G -- --
Jennewein Michael J -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Davis Keith B $417,000
Previous Owner Marshall Roger L $360,000
Previous Owner Lods Scott L $340,000
Previous Owner Lods Scott L $347,500
Previous Owner Wall Charles G $100,000
Previous Owner Jennewein Michael J $324,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/29/2017 09/29/17 Sold $438,250 -12.3% $107 / Sq Ft
08/26/2017 08/26/17 Pending -- -- --
01/24/2017 01/24/17 For Sale $499,900 +7.5% $122 / Sq Ft
06/30/2015 06/30/15 Sold $465,000 0.0% $113 / Sq Ft
05/15/2015 05/15/15 Pending -- -- --
05/13/2015 05/13/15 For Sale $465,000 +3.3% $113 / Sq Ft
09/24/2012 09/24/12 For Sale $450,000 0.0% $110 / Sq Ft
08/31/2012 08/31/12 Sold $450,000 -- $110 / Sq Ft
08/22/2012 08/22/12 Pending -- -- --
Source: Indiana 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 $3,807 $524,700 $71,500 $453,200
2023 $3,684 $490,500 $71,500 $419,000
2022 $3,532 $433,400 $71,500 $361,900
2021 $3,381 $415,800 $71,500 $344,300
2020 $3,182 $403,200 $71,500 $331,700
2019 $3,229 $411,100 $71,500 $339,600
2018 $3,121 $403,400 $71,500 $331,900
2017 $2,968 $381,000 $69,000 $312,000
2016 $2,879 $373,700 $69,000 $304,700
2014 $2,824 $368,600 $69,000 $299,600
2013 $2,541 $319,600 $69,000 $250,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 201702832

Indiana Regional MLS

APN: 79-08-18-226-002.000-009