NOT LISTED FOR SALE

5587 E 300 N Urbana, IN 46990

Estimated Value: $1,034,000 - $1,073,083

6 Beds
4.5 Baths
6,050 Sq Ft
$174/Sq Ft Est. Value

Last Sold September 17, 2020

Last sale price $829,000 $137 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $6,294/month

75 Days on Market

Highlights

  • Lake Front
  • Private Beach
  • Primary Bedroom Suite
  • Pier or Dock
  • RV Parking in Community
  • 18.58 Acre Lot

About This Home

As of September 2020

Want your own Retreat!! This gorgeous, custom built craftsman style home defines country living at its finest. With over 6,000 sq. ft., 6 bedrooms , 4 1/2 baths on 13.582 acres. Purchaser can also purchase an additional 36.418 acres to make a total of 50 acres including 25 acres of woods & about 13 acres cropland at $960,000. Large open foyer with stacked stone columns and slate flooring. Chef's kitchen with Amish built, custom cherry cabinets and granite counter tops throughout. Brazilian Acacia hardwood floors in most of the main level. Slate tile floors in the foyer & all full baths. Stacked stone gas log fireplace in living room and master bedroom. Formal dining. Den with custom bookcase and spiral stairway up to music room. Master suite with gas log fireplace and wood beamed tray ceiling. Lower level Bedroom and full bath, theater room with all theater equipment and seating. Huge family room with a freestanding wood stove, extra custom cabinets, refrigerator and range. There is also a huge storage room with lots of shelving. There is around 905 sq ft of floor attic above the garage that could be finished into additional living space or a bonus room. 3 car attached garage. Newer 48' x 64' pole building for your adult toys. There is also a very nice 1,249 sq ft Guest cottage located right on the lake, drive your boat right in to the basement garage. The cottage is a very successful updated airbnb rental so you can generate income from the cottage and cropland rental. Newer asphalt drive. Some of the furnishing, mower, etc are negotiable and can stay with the home. Buyers purchased an additional 5 ac at $6,000/ac making the total 18.582 ac for $829,000.

Last Agent to Sell the Property

Robert Lundquist

Lundquist Appraisals & Real Estate Listed on: 06/10/2020

Last Buyer's Agent

Robert Lundquist

Lundquist Appraisals & Real Estate Listed on: 06/10/2020

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,652

Year Built

  • Built in 2011

Lot Details

  • 18.58 Acre Lot
  • Lake Front
  • Private Beach
  • Rural Setting
  • Landscaped
  • Lot Has A Rolling Slope
  • Property is zoned A1

Parking

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

Home Design

  • Craftsman Architecture
  • Poured Concrete
  • Shingle Roof
  • Asphalt Roof
  • Stone Exterior Construction
  • Cement Board or Planked

Interior Spaces

  • 2-Story Property
  • Built-in Bookshelves
  • Built-In Features
  • Bar
  • Beamed Ceilings
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Insulated Doors
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • Formal Dining Room
  • Storage In Attic
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Walk-In Pantry
  • Kitchen Island
  • Stone Countertops
  • Built-In or Custom Kitchen Cabinets

Flooring

  • Wood
  • Carpet
  • Slate Flooring

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Bedroom
  • Primary Bedroom Suite
  • Double Vanity
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry on main level
  • Electric Dryer Hookup

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Walk-Up Access
  • Sump Pump
  • 1 Bathroom in Basement
  • 1 Bedroom in Basement

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Insulation

Outdoor Features

  • Sun Deck
  • Lake Property
  • Lake, Pond or Stream
  • Covered Patio or Porch

Schools

  • Metro North/Sharp Creek Elementary School
  • Northfield Middle School
  • Northfield High School

Utilities

  • Zoned Heating and Cooling System
  • High-Efficiency Furnace
  • Heat Pump System
  • Heating System Powered By Owned Propane
  • Private Company Owned Well
  • Well
  • ENERGY STAR Qualified Water Heater
  • Septic System

Listing and Financial Details

  • Assessor Parcel Number 85-11-24-200-008.000-003

Community Details

Recreation

  • Pier or Dock

Additional Features

  • RV Parking in Community
  • Community Fire Pit

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,652

Year Built

Built in 2011

Lot Details

0

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 2011
  • Style: Two Story
  • Architectural Style: Craftsman
  • Bedrooms: 6
  • Total Bathrooms: 5
  • Total Full Bathrooms: 4
  • Total Number of Half Bathrooms: 1
  • Legal Description: PT W1/2 NE1/4 24-28-7 18.582AC
  • Parcel Number ID: 85-11-24-200-008.000-003
  • Platted: Yes
  • Amenities: Attic Storage, Bar, Built-In Bookcase, Built-In Home Theatre, Ceiling Fan(s), Ceilings-Beamed, Countertops-Stone, Deck Open, Deck on Waterfront, Detector-Smoke, Dryer Hook Up Electric, Eat-In Kitchen, Firepit, Foyer Entry, Garage Door Opener, Kitchen Island, Landscaped, Pantry-Walk In, Porch Covered, Six Panel Doors, Twin Sink Vanity, RV Parking, Stand Up Shower, Tub and Separate Shower, Tub/Shower Combination, Main Level Bedroom Suite, Formal Dining Room, Great Room, Main Floor Laundry, Sump Pump, Custom Cabinetry
  • Cross Street: 500 East
  • Improvmnts In Last5 Yrs: Yes
  • Location: Rural
  • Number Below Grade Bedrooms: 1
  • Road Access: County
  • Road Surface: Asphalt
  • County Zoning: A1
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 7480
  • Total Finished Sq Ft: 6050
  • Above Grade Finished Sq Ft: 4385
  • Below Grade Finished Sq Ft: 1665
  • Above Grade Unfinished Sq Ft: 905
  • Below Grade Sq Ft: 525
  • Basement: Yes
  • Basement Foundation: Full Basement, Partially Finished, Walk-up, Walk-Out Basement
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 2
  • Fireplace: Living/Great Rm, 1st Bdrm, Gas Log, Wood Burning Stove
  • Fireplace: Yes
  • Flooring: Carpet, Hardwood Floors, Slate
  • Living Great Room: Dimensions: 24x18, On Level: Main
  • Kitchen: Dimensions: 16x15, On Level: Main
  • Breakfast Room: Dimensions: 16x10, On Level: Main
  • Dining Room: Dimensions: 13x12, On Level: Main
  • Family Room: Dimensions: 37x18, On Level: Lower
  • Den: Dimensions: 15x13, On Level: Main
  • Extra Room: 6th Bedroom, Dimensions: 18x12, On Level: Lower
  • Bedroom 1: Dimensions: 19x18, On Level: Main
  • Bedroom 2: Dimensions: 14x12, On Level: Upper
  • Bedroom 3: Dimensions: 12x12, On Level: Upper
  • Bedroom 4: Dimensions: 12x12, On Level: Upper
  • Bedroom 5: Dimensions: 12x12, On Level: Upper
  • Other Room1: Foyer, Dimensions: 15x10, On Level: Main
  • Other Room 2: Music room, Dimensions: 15x13, On Level: Upper
  • Other Room 3: Storage, Dimensions: 27x17, On Level: Lower
  • Loft: Dimensions: 31x16, On Level: Upper
  • Main Level Sq Ft: 2368
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 2190

Exterior Features

  • Exterior: Stone, Cement Board
  • Roof Material: Asphalt, Shingle
  • Outbuilding1: Pole/Post Building, Dimensions: 60x48
  • Outbuilding2: Studio, Dimensions: 35x31, 1085
  • Water Features: Pier/Dock, Private Beach

Garage/Parking

  • Driveway: Asphalt
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 36x24
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air, Heat Pump
  • Heating Fuel: Electric, Heat Pump, Propane Tank Owned
  • Sewer: Septic
  • Water Utilities: Well
  • Electric Company: REMC
  • Cable Company: DirectTV, Dish Network
  • Hvac: Ceiling Fan, High Efficiency Furnace, Zoned Heating
  • Laundry: Dimensions: Mainx10, On Level: 10
  • Water Type: Pond
  • Well Type: Private

Schools

  • Elementary School: Metro North/Sharp Creek

Lot Info

  • Lot Description: Rolling, Waterfront, Lake
  • Lot Dimensions: See attached plat map
  • Estimated Lot Sq Ft: 809432
  • Estimated Lot Size Acres: 18.582

Green Features

  • Energy Efficient: HVAC, Insulation, Water Heater
  • Energy Efficient Windows/Doors: Double Pane Windows, Insulated Doors

Tax Info

  • Annual Taxes: 3652.4
  • Exemptions: Homestead, Mortgage

Multi Family

  • Water Access: Lakefront

MLS Schools

  • High School: Northfield
  • Middle School: Northfield
  • School District: MSD of Wabash County Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 10, 2020
Closed on
Sep 17, 2020
Sold by
Coffman Jared S and Coffman Marie C
Bought by
Morozov Alex and Morozov Alla
Seller's Agent
Robert Lundquist
Lundquist Appraisals & Real Estate
Buyer's Agent
Robert Lundquist
Lundquist Appraisals & Real Estate
List Price
$799,000
Sold Price
$829,000
Premium/Discount to List
$30,000
3.75%
Current Estimated Value
$1,053,542

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$224,542
Avg. Annual Appreciation
4.70%
Original Mortgage
$663,000
Outstanding Balance
$587,277
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$466,265
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
Morozov Alex $829,000 Wabash Valley Abstract, Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Morozov Alex $663,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/17/2020 09/17/20 Sold $829,000 +3.8% $137 / Sq Ft
08/24/2020 08/24/20 Pending -- -- --
06/10/2020 06/10/20 For Sale $799,000 -- $132 / 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 $9,018 $1,009,100 $130,900 $878,200
2023 $8,744 $982,300 $130,900 $851,400
2022 $10,045 $872,300 $130,900 $741,400
2021 $10,037 $774,400 $109,400 $665,000
2020 $4,586 $564,500 $77,800 $486,700
2019 $3,652 $497,300 $40,100 $457,200
2018 $3,587 $493,100 $40,100 $453,000
2017 $2,991 $461,100 $40,100 $421,000
2016 $2,402 $470,200 $56,200 $414,000
2014 $2,179 $438,200 $56,200 $382,000
2013 $2,048 $433,300 $56,100 $377,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202021504

Indiana Regional MLS

APN: 85-11-24-200-008.000-003