NOT LISTED FOR SALE

18916 Roselle Cove Auburn, IN 46706

Estimated Value: $538,000 - $724,000

4 Beds
2.5 Baths
2,630 Sq Ft
$239/Sq Ft Est. Value

Last Sold March 02, 2018

Last sale price $355,900 $135 Per Sq Ft

Est. 77% increase in value since last sale

Current estimated payment $3,697/month

9 Days on Market

Highlights

  • Primary Bedroom Suite
  • Stone Countertops
  • Formal Dining Room
  • Cedarville Elementary School Rated A-
  • Covered Patio or Porch
  • Utility Sink

About This Home

As of March 2018

Unique new floor plan The Willowbrook III built by Majestic Homes. Large Great Room, Breakfast Nook and Kitchen with a large covered porch off the Breakfast Room. Master suite on the first floor with a very large closet and bath that has a walk in tile shower and separate tub. Great winding stairs up to the second floor loft. Granite Kitchen Counter Tops, tile Flooring in Kitchen, Nook, and oversized Laundry which has a utility sink. 3 generous sized Bedrooms up all with Walk-In Closets. Carrier 92% high efficiency furnace and all exterior walls are spray foam insulated. Truss floor joist so there are no dropped ceiling area's on the first floor or basement. Sod and irrigation system in front yard with a very large rear yard!

Last Agent to Sell the Property

David Dehaven

Mike Thomas Assoc., Inc Listed on: 01/18/2018

Mike Thomas Assoc., Inc

Co-Listed By

Joe Shipley

Mike Thomas Assoc., Inc

Last Buyer's Agent

Charlotte Suntken

Mike Thomas Associates, Inc.

Mike Thomas Associates, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,935

Year Built

  • Built in 2016

Lot Details

  • 0.68 Acre Lot
  • Lot Dimensions are 104 x 186x 182 x 267
  • Rural Setting
  • Landscaped
  • Level Lot

HOA Fees

  • $33 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Home Design

  • Poured Concrete
  • Shingle Roof
  • Stone Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • Gas Log Fireplace
  • Entrance Foyer
  • Living Room with Fireplace
  • Formal Dining Room

Kitchen

  • Breakfast Bar
  • Kitchen Island
  • Stone Countertops
  • Utility Sink
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite

Attic

  • Storage In Attic
  • Pull Down Stairs to Attic

Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Natural lighting in basement

Outdoor Features

  • Covered Patio or Porch

Utilities

  • Forced Air Heating and Cooling System
  • SEER Rated 13+ Air Conditioning Units
  • High-Efficiency Furnace
  • Heating System Uses Gas
  • Private Company Owned Well
  • Well

Listing and Financial Details

  • Assessor Parcel Number 02-03-06-251-017.000-042

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,935

Year Built

Built in 2016

Lot Details

0

HOA Fees

$33 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2016
  • Age: 2
  • Style: Two Story
  • Total Number of Rooms: 9
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 4
  • Total Bathrooms: 3
  • Total Full Bathrooms: 2
  • Total Number of Half Bathrooms: 1
  • Legal Description: Lot 54 Deer Hollow |
  • Parcel Number ID: 02-03-06-251-017.000-042
  • Platted: Yes
  • Amenities: Attic Pull Down Stairs, Attic Storage, Breakfast Bar, Countertops-Stone, Disposal, Foyer Entry, Garage Door Opener, Kitchen Island, Landscaped, Porch Covered, Rough-In Bath, Utility Sink, Main Level Bedroom Suite, Formal Dining Room, Sump Pump
  • Location: Rural Subdivision
  • Road Surface: Paved
  • Sp Lp Percent: 94.93
  • Special Features: None

Interior Features

  • Total Sq Ft: 4346
  • Total Finished Sq Ft: 2630
  • Above Grade Finished Sq Ft: 2630
  • Below Grade Sq Ft: 1716
  • Price Per Sq Ft: 135.32
  • Basement: Yes
  • Basement Foundation: Daylight, Full Basement
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Log
  • Fireplace: Yes
  • Living Great Room: Dimensions: 33x14, On Level: Main
  • Kitchen: Dimensions: 16x8, On Level: Main
  • Breakfast Room: Dimensions: 11x11, On Level: Main
  • Dining Room: Dimensions: 13x11, On Level: Main
  • Family Room: On Level: N/A
  • Den: On Level: N/A
  • Recreation Room: On Level: N/A
  • Extra Room: On Level: N/A
  • Bedroom 1: Dimensions: 17x14, On Level: Main
  • Bedroom 2: Dimensions: 14x12, On Level: Upper
  • Bedroom 3: Dimensions: 13x12, On Level: Upper
  • Bedroom 4: Dimensions: 16x11, On Level: Upper
  • Bedroom 5: On Level: N/A
  • Loft: Dimensions: 11x9, On Level: Upper
  • Main Level Sq Ft: 1716
  • Number of Main Level Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 1716

Exterior Features

  • Exterior: Stone, Vinyl
  • Roof Material: Shingle
  • Outbuilding1: None

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 32x22
  • Garage Sq Ft: 704
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: City
  • Water Utilities: Well
  • Hvac: High Efficiency Furnace, HVAC (13 Seer)
  • Laundry: Dimensions: Mainx10, On Level: 12
  • Well Type: Private

Condo/Co-op/Association

  • Association Restrictions: Yes
  • Association Fees: 400
  • Association Fees Frequency: Annually

Schools

  • School District: East Allen County
  • Elementary School: Leo
  • Middle School: Leo
  • High School: Leo

Lot Info

  • Lot Description: Level
  • Lot Dimensions: 104 x 186x 182 x 267
  • Estimated Lot Sq Ft: 30038
  • Estimated Lot Size Acres: 0.68
  • Lot Number: 54

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 18, 2018
Closed on
Mar 2, 2018
Sold by
Majestic Custom Homes Of Lafayette Inc
Bought by
Kelley Stephen L
Seller's Agent
David Dehaven
Mike Thomas Assoc., Inc
Buyer's Agent
Charlotte Suntken
Mike Thomas Associates, Inc.
List Price
$374,900
Sold Price
$355,900
Premium/Discount to List
-$19,000
-5.07%
Current Estimated Value
$629,271

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$273,371
Avg. Annual Appreciation
7.34%
Original Mortgage
$333,200
Interest Rate
4.04%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 1, 2016
Sold by
Wedgewood Development Corporation
Bought by
Majestic Homes Of Fort Wayne
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
Kelley Stephen L -- Metropolitan Title Of In
Majestic Homes Of Fort Wayne -- Renaissance Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Kelley Stephen L $333,200
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/02/2018 03/02/18 Sold $355,900 -5.1% $135 / Sq Ft
01/27/2018 01/27/18 Pending -- -- --
01/18/2018 01/18/18 For Sale $374,900 -- $143 / Sq Ft
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,935 $515,300 $71,500 $443,800
2022 $3,447 $425,700 $71,500 $354,200
2021 $3,445 $398,000 $71,500 $326,500
2020 $3,300 $396,700 $84,100 $312,600
2019 $2,777 $354,500 $84,100 $270,400
2018 $2,909 $354,600 $84,100 $270,500
2017 $6,593 $394,600 $84,100 $310,500
2016 $82 $1,600 $1,600 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 201802007

Indiana Regional MLS

APN: 02-03-06-251-017.000-042