NOT LISTED FOR SALE

18892 Roselle Cove Auburn, IN 46706

Estimated Value: $648,000 - $729,000

5 Beds
3 Baths
3,451 Sq Ft
$197/Sq Ft Est. Value

Last Sold July 14, 2023

Last sale price $615,000 $178 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $4,022/month

11 Days on Market

Highlights

  • Open Floorplan
  • Backs to Open Ground
  • Covered Patio or Porch
  • Cedarville Elementary School Rated A-
  • Great Room
  • Formal Dining Room

About This Home

As of July 2023

Welcome to Deer Hollow! This stunning home has been meticulously maintained and is ready for its new owner! From the moment you enter into the home you will be amazed by the stunning trim work, vaulted ceilings, granite countertops and abundant custom built-ins this home has to offer! The storage in this home is endless! Open floor plan on the main level includes a large living room, formal dining room, flex/family room, den or possible 5th bedroom, huge laundry room complete with cabinetry, a large mudroom with built in lockers and the gorgeous kitchen boasting stainless steel appliances, subway tile backsplash, reverse osmosis system and an oversized 7ft island with storage on both sides! Oversized living room with gas fireplace, vaulted ceilings, custom built ins and abundant natural light! The large 14x18 flex/family room is the perfect secondary entertaining space or playroom. Large master suite is complete with tray ceilings and an ensuite with large walk-in tile shower and large walk-in closet. Two additional bedrooms and a full bath complete the main floor. Upstairs you will find a large loft, two additional bedrooms a full bath and walk-in access to attic storage. The private backyard is complete with an oversized covered patio, black aluminum fence and a gorgeous view. This home is located inside Leo Schools and nestled on a quiet street. It is truly a must see!

Last Agent to Sell the Property

Brandon Schueler

Mike Thomas Assoc., Inc Listed on: 05/30/2023

Mike Thomas Assoc., Inc

Last Buyer's Agent

Katie Brown

Mike Thomas Assoc., Inc

Mike Thomas Assoc., Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,043

Year Built

  • Built in 2017

Lot Details

  • 0.51 Acre Lot
  • Lot Dimensions are 186x150x173x150
  • Backs to Open Ground
  • Rural Setting
  • Aluminum or Metal Fence
  • Landscaped
  • Level Lot

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Slab Foundation
  • Asphalt Roof
  • Stone Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • 3,451 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Built-in Bookshelves
  • Crown Molding
  • Tray Ceiling
  • Ceiling Fan
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • Formal Dining Room
  • Storage In Attic

Kitchen

  • Electric Oven or Range
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Washer and Gas Dryer Hookup

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Covered Patio or Porch

Schools

  • Leo Elementary And Middle School
  • Leo High School

Utilities

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

Community Details

  • Deer Hollow Subdivision

Listing and Financial Details

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

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,043

Year Built

Built in 2017

Lot Details

0

HOA Fees

$38 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2017
  • Age: 6
  • Style: Two Story
  • Total Number of Rooms: 8
  • Bedrooms: 5
  • Number Above Grade Bedrooms: 5
  • Total Bathrooms: 3
  • Total Full Bathrooms: 3
  • Legal Description: Deer Hollow SEC 2 Lot 55
  • Parcel Number ID: 02-03-06-251-018.000-042
  • Platted: Yes
  • Amenities: Attic Storage, Built-In Bookcase, Cable Available, Cable Ready, Ceiling-Tray, Ceiling Fan(s), Closet(s) Walk-in, Crown Molding, Detector-Carbon Monoxide, Detector-Smoke, Disposal, Dryer Hook Up Gas, Foyer Entry, Garage Door Opener, Landscaped, Open Floor Plan, Patio Covered, Range/Oven Hook Up Elec, Stand Up Shower, Tub/Shower Combination, Formal Dining Room, Great Room, Main Floor Laundry, Washer Hook-Up, Custom Cabinetry
  • Location: Rural Subdivision
  • Sp Lp Percent: 99.21
  • Year Taxes Payable: 2022
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 3451
  • Total Finished Sq Ft: 3451
  • Above Grade Finished Sq Ft: 3451
  • Price Per Sq Ft: 178.21
  • Basement Foundation: Slab
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm
  • Fireplace: Yes
  • Flooring: Carpet, Vinyl, Ceramic Tile
  • Living Great Room: Dimensions: 19x16, On Level: Main
  • Kitchen: Dimensions: 16x14, On Level: Main
  • Breakfast Room: Dimensions: 14x9, On Level: Main
  • Dining Room: Dimensions: 12x12, On Level: Main
  • Family Room: Dimensions: 18x14, On Level: Main
  • Bedroom 1: Dimensions: 17x14, On Level: Main
  • Bedroom 2: Dimensions: 12x12, On Level: Main
  • Bedroom 3: Dimensions: 12x11, On Level: Main
  • Bedroom 4: Dimensions: 13x12, On Level: Upper
  • Bedroom 5: Dimensions: 13x12, On Level: Upper
  • Loft: Dimensions: 31x14, On Level: Upper
  • Number of Main Level Full Bathrooms: 2

Exterior Features

  • Exterior: Stone, Vinyl
  • Roof Material: Asphalt
  • Outbuilding1: None
  • Fence: Metal

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 23x39
  • Garage Sq Ft: 897
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: City
  • Water Utilities: Well
  • Gas Company: NIPSCO
  • Well Type: Private

Condo/Co-op/Association

  • Association Fees: 450
  • Association Fees Frequency: Annually
  • Common Amenities: Sidewalks

Schools

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

Lot Info

  • Lot Description: Level
  • Lot Dimensions: 186x150x173x150
  • Estimated Lot Sq Ft: 22063
  • Estimated Lot Size Acres: 0.5065

Tax Info

  • Annual Taxes: 4042.64
  • Exemptions: Homestead, Mortgage

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 30, 2023
Closed on
Jul 14, 2023
Sold by
Cover Jeffery A and Cover Tamara S
Bought by
Gibson Lane Paul and Gibson Tara Lyn
Seller's Agent
Brandon Schueler
Mike Thomas Assoc., Inc
Buyer's Agent
Katie Brown
Mike Thomas Assoc., Inc
List Price
$619,900
Sold Price
$615,000
Premium/Discount to List
-$4,900
-0.79%
Total Days on Market
11
Views
23
Current Estimated Value
$680,344

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$65,344
Avg. Annual Appreciation
4.68%
Original Mortgage
$584,250
Interest Rate
6.71%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 30, 2023
Closed on
Jul 13, 2023
Sold by
Cover Jeffery A and Cover Tamara S
Bought by
Gibson Lane Paul and Gibson Tara Lyn
Seller's Agent
Brandon Schueler
Mike Thomas Assoc., Inc
Buyer's Agent
Katie Brown
Mike Thomas Assoc., Inc
List Price
$619,900
Sold Price
$615,000
Premium/Discount to List
-$4,900
-0.79%
Views
23

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$584,250
Interest Rate
6.71%
Mortgage Type
New Conventional

Purchase Details

Listed on
Oct 29, 2020
Closed on
Jan 12, 2021
Sold by
Willison Steve P and Willison Cindy C
Bought by
Cover Jeffrey A and Cover Tamara S
Seller's Agent
Amber Moss
Mike Thomas Assoc., Inc
Buyer's Agent
Andrea Zehr
eXp Realty, LLC
List Price
$495,000
Sold Price
$495,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
9.07%
Original Mortgage
$445,500
Interest Rate
2.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 22, 2017
Sold by
Serry Homes Llc
Bought by
Willison Steve P and Willison Cindy C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$335,100
Interest Rate
3.96%
Mortgage Type
Construction

Purchase Details

Closed on
May 30, 2017
Sold by
Wedgewood Development Corp
Bought by
Steurey Homes Llc
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
Gibson Lane Paul -- Fidelity National Title
Gibson Lane Paul $615,000 Fidelity National Title
Cover Jeffrey A -- Renaissance Title
Willison Steve P -- Renaissance Title
Steurey Homes Llc $61,655 Barrett & Mcnagny Llp
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gibson Lane Paul $584,250
Closed Gibson Lane Paul $584,250
Previous Owner Cover Jeffrey A $445,500
Previous Owner Willison Steve P $335,100
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/14/2023 07/14/23 Sold $615,000 -0.8% $178 / Sq Ft
06/16/2023 06/16/23 Pending -- -- --
06/05/2023 06/05/23 For Sale $619,900 +25.2% $180 / Sq Ft
01/12/2021 01/12/21 Sold $495,000 +1.0% $143 / Sq Ft
12/04/2020 12/04/20 Pending -- -- --
11/11/2020 11/11/20 Price Changed $489,900 -1.0% $142 / Sq Ft
10/29/2020 10/29/20 For Sale $495,000 -- $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 $4,525 $585,900 $68,600 $517,300
2023 $4,520 $548,500 $68,600 $479,900
2022 $4,038 $490,200 $68,600 $421,600
2021 $3,639 $417,600 $68,600 $349,000
2020 $3,578 $398,500 $68,600 $329,900
2019 $3,063 $385,900 $68,600 $317,300
2018 $2,975 $361,500 $68,600 $292,900
2017 $283 $68,600 $68,600 $0
2016 $82 $1,600 $1,600 $0
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: 202317943

Indiana Regional MLS

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