NOT LISTED FOR SALE

1507 S 820 E Celestine, IN 47521

Estimated Value: $343,000 - $632,000

2 Beds
2.5 Baths
3,546 Sq Ft
$150/Sq Ft Est. Value

Last Sold January 27, 2022

Last sale price $525,000 $148 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,158/month

72 Days on Market

Highlights

  • Primary Bedroom Suite
  • Fireplace in Bedroom
  • Vaulted Ceiling
  • Open Floorplan
  • Contemporary Architecture
  • Partially Wooded Lot

About This Home

As of January 2022

Now is your chance to call this serene, wooded setting home on 8 acres+/- subject to survey. As you pull up the drive, you will be in awe of this magnificent custom home with panoramic views of the outdoors in every aspect of this home. The three car detached garage has radiant floor heat in 2 bays and the third heated and cooled bay was used as a workshop. The two car garage is perfect for additional parking.The Shamrock custom kitchen cabinets, neutral granite counter tops and top of the line appliances are sure to please the choosiest cook. The kitchen is open to the dining area and leads to the great room with a vaulted ceiling. The main level master bedroom suite features a private balcony with serene views of the koi pond and countryside. The master suite bathroom comes complete with a jacuzzi tub, walk-in shower, double bowl vanity sink and walk-in closet. Between the breathtaking views and the gas log fireplace, the main level office is sure to be a hit. The corner spiral staircase in the office leads to a flex room with it's own private balcony. The second and possible third bedroom or exercise room are located in the lower ground level. This level has individually zoned radiant floor heat. You are sure to love the Nordic Spruce Sauna and full bathroom. The built-in cabinetry and small snack bar area are located in the Rec Area of the lower level which leads to a stoned covered and open patio for entertaining or just enjoying the view of the waterfall and nature. You can purchase an additional 3 acres+/- subject to a survey with a one bedroom guest house with a well-equipped kitchen, laundry, dining, family room and a car garage for $549,700. Close to Patoka Lake! Be sure to view the 3D tour!

Last Agent to Sell the Property

Brenda Welsh

SELL4FREE-WELSH REALTY CORPORATION Listed on: 10/04/2021

Last Buyer's Agent

Brenda Welsh

SELL4FREE-WELSH REALTY CORPORATION Listed on: 10/04/2021

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,231

Year Built

  • Built in 2000

Lot Details

  • 8 Acre Lot
  • Backs to Open Ground
  • Rural Setting
  • Landscaped
  • Level Lot
  • Partially Wooded Lot

Parking

  • 3 Car Detached Garage
  • Heated Garage
  • Garage Door Opener
  • Off-Street Parking

Home Design

  • Contemporary Architecture
  • Shingle Roof
  • Stone Exterior Construction
  • Cement Board or Planked

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Built-in Bookshelves
  • Built-In Features
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Workshop
  • Utility Room in Garage
  • Washer and Electric Dryer Hookup
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Kitchen Island
  • Solid Surface Countertops
  • Built-In or Custom Kitchen Cabinets

Flooring

  • Carpet
  • Concrete
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Fireplace in Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • Bathtub With Separate Shower Stall

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Block Basement Construction
  • 1 Bathroom in Basement

Outdoor Features

  • Covered Patio or Porch

Schools

  • Northeast Dubois Elementary And Middle School
  • Northeast Dubois High School

Utilities

  • Central Air
  • Heating System Uses Gas
  • Radiant Heating System
  • Heating System Powered By Leased Propane
  • Propane
  • Septic System

Listing and Financial Details

  • Assessor Parcel Number 19-09-09-300-017.001-009

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,231

Year Built

Built in 2000

Lot Details

0

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2000
  • Style: Two Story
  • Architectural Style: Contemporary
  • Bedrooms: 2
  • Total Bathrooms: 3
  • Total Full Bathrooms: 2
  • Total Number of Half Bathrooms: 1
  • Legal Description: 006-01110-09 PT NW SW 9-2-3 (8 Acres +/- subject to survey).
  • Parcel Number ID: 19-09-09-300-017.001-009
  • Platted: Yes
  • Amenities: Alarm System-Security, Built-In Bookcase, Built-in Desk, Ceiling Fan(s), Ceilings-Vaulted, Central Vacuum System, Closet(s) Walk-in, Countertops-Solid Surf, Dryer Hook Up Electric, Eat-In Kitchen, Garage Door Opener, Kitchen Island, Landscaped, Open Floor Plan, Patio Covered, Range/Oven Hook Up Gas, Wet Bar, Stand Up Shower, Tub and Separate Shower, Workshop, Main Level Bedroom Suite, Garage-Heated, Washer Hook-Up, Custom Cabinetry, Garage Utilities
  • Location: Rural
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 3546
  • Total Finished Sq Ft: 3546
  • Above Grade Finished Sq Ft: 1878
  • Below Grade Finished Sq Ft: 1668
  • Basement: Yes
  • Basement Foundation: Full Basement, Walk-Out Basement, Finished
  • Basement Material: Block
  • Number Of Fireplaces: 1
  • Fireplace: Extra Rm, Gas Log
  • Fireplace: Yes
  • Flooring: Carpet, Concrete, Ceramic Tile
  • Living Great Room: Dimensions: 25x13, On Level: Main
  • Kitchen: Dimensions: 12x12, On Level: Main
  • Dining Room: Dimensions: 15x13, On Level: Main
  • Family Room: Dimensions: 17x15, On Level: Lower
  • Den: Dimensions: 14x11, On Level: Main
  • Recreation Room: Dimensions: 20x13
  • Extra Room: Flex Room, Dimensions: 13x12, On Level: Upper
  • Bedroom 1: Dimensions: 17x11, On Level: Main
  • Bedroom 2: Dimensions: 14x13, On Level: Lower
  • 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: 1668

Exterior Features

  • Exterior: Stone, Cement Board
  • Roof Material: Shingle
  • Outbuilding1: 2nd Detached Garage, Dimensions: 24x24

Garage/Parking

  • Garage Type: Detached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 30x16
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Propane, Radiant, Propane Tank Rented
  • Sewer: Septic
  • Water Utilities: Public
  • Electric Company: Dubois REC
  • Gas Company: Southern Indiana Propane
  • Water Company: Dubois Water Utilities
  • Laundry: Dimensions: Lowerx8, On Level: 9

Schools

  • Elementary School: Northeast Dubois

Lot Info

  • Lot Description: Level, Partially Wooded, Rolling
  • Estimated Lot Sq Ft: 348480
  • Estimated Lot Size Acres: 8

Tax Info

  • Annual Taxes: 4230.78
  • Exemptions: Homestead

MLS Schools

  • High School: Northeast Dubois
  • Middle School: Northeast Dubois
  • School District: Northeast Dubois County School Corp.

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 18, 2024
Sold by
Yakusheva Tatiana
Bought by
Pride Jacquelynn Marie
Current Estimated Value
$532,039

Purchase Details

Closed on
Jul 21, 2023
Sold by
Yakusheva Tatiana
Bought by
Hoffman Logan James

Purchase Details

Listed on
Oct 4, 2021
Closed on
Jan 27, 2022
Sold by
Gutgsell Tracey L
Bought by
Yakusheva Tatiana
Seller's Agent
Brenda Welsh
SELL4FREE-WELSH REALTY CORPORATION
Buyer's Agent
Brenda Welsh
SELL4FREE-WELSH REALTY CORPORATION
List Price
$549,700
Sold Price
$525,000
Premium/Discount to List
-$24,700
-4.49%

Home Financials for this Owner

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

Purchase Details

Closed on
May 19, 2008
Sold by
Wohlberg Michael A and Wohlberg Jennifer E
Bought by
Gutgsell Patrick D and Gutgsell Tracey L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$230,000
Interest Rate
5.87%
Mortgage Type
New Conventional
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
Pride Jacquelynn Marie $615,000 Foreman Watson Land Title
Hoffman Logan James $158,000 Central Land Title
Yakusheva Tatiana $525,000 Central Land Title
Gutgsell Patrick D -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Gutgsell Patrick D $230,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/27/2022 01/27/22 Sold $525,000 +16.7% $148 / Sq Ft
12/15/2021 12/15/21 Pending -- -- --
12/09/2021 12/09/21 Price Changed $450,000 -18.1% $127 / Sq Ft
10/04/2021 10/04/21 For Sale $549,700 -- $155 / 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,549 $542,100 $49,700 $492,400
2023 $4,949 $547,000 $78,500 $468,500
2022 $4,589 $478,600 $58,500 $420,100
2021 $4,227 $409,100 $58,500 $350,600
2020 $4,231 $402,700 $55,300 $347,400
2019 $3,686 $396,000 $53,800 $342,200
2018 $3,752 $396,300 $55,300 $341,000
2017 $3,764 $383,500 $55,300 $328,200
2016 $3,591 $375,000 $55,300 $319,700
2014 $3,217 $380,600 $50,300 $330,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202142150

Indiana Regional MLS

APN: 19-09-09-300-017.001-009