NOT LISTED FOR SALE

1054 N Celestine Rd N Celestine, IN 47521

Estimated Value: $317,000 - $391,000

5 Beds
2 Baths
3,115 Sq Ft
$118/Sq Ft Est. Value

Last Sold June 14, 2024

Last sale price $389,000 $125 Per Sq Ft

Est. 5% decrease in value since last sale

Current estimated payment $2,222/month

39 Days on Market

Highlights

  • Primary Bedroom Suite
  • Ranch Style House
  • Backs to Open Ground
  • Open Floorplan
  • Partially Wooded Lot
  • Wood Flooring

About This Home

As of June 2024

Still accepting offers with a 48 hour right of rescission! Beautiful country ranch home offering 3,115 finished square foot, 3 bedrooms, 2 bath, finished basement with 2 detached garages on 2.75 acres. You are immediately drawn to the meticulous upkeep with the newly painted siding, new exterior doors and garage doors and lighting with extensive new landscaping. As you enter the front door from the covered porch this upkeep extends to the inside with newer flooring, paint and lighting throughout. The centerpiece of the home is the see through fireplace that adds ambiance to two spaces at once. The living room is accented with a whitewashed stone facade with brick in the dining room. An expansive panoramic room speaks rustic charm showcasing dining, living and a well-equipped kitchen with island looking out a picture window. Off the kitchen you walk thru a full bath to laundry and a pantry. The other wing is three nice size bedrooms with a bath with entrance from the master or hallway. Entertaining is easy in this home with a partial basement revamped with attractive flooring and wood walls. It has an outside entrance with 2 extra finished rooms to be used as needed. Outside the kitchen is a vast patio extending to a firepit. Two detached garages give you wonderful space for all your hobbies, toys and dreams. There is a conditioned work office with storage and bathroom in one and 3 bays w/9' door in the other. Your land extends on the right with a level grassy space, concrete outlines the space between the sheds, and a wooded area past the house providing country living at it's best! Celestine is a quaint town located 20 minutes to Jasper or French Lick, an hour from Evansville, Louisville or Bloomington and minutes from Patoka Lake.

Last Agent to Sell the Property

Tama Stemle

RE/MAX Local Brokerage Phone: 812-631-2782 Listed on: 04/04/2024

RE/MAX Local

Last Buyer's Agent

Tama Stemle

RE/MAX Local Brokerage Phone: 812-631-2782 Listed on: 04/04/2024

RE/MAX Local

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,060

Year Built

  • Built in 1980

Lot Details

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

Parking

  • 2 Car Attached Garage
  • Heated Garage
  • Garage Door Opener
  • Gravel Driveway
  • Off-Street Parking

Home Design

  • Ranch Style House
  • Shingle Roof
  • Limestone

Interior Spaces

  • Open Floorplan
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Insulated Doors
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • Workshop
  • Utility Room in Garage
  • Pull Down Stairs to Attic
  • Fire and Smoke Detector

Kitchen

  • Walk-In Pantry
  • Electric Oven or Range
  • Kitchen Island
  • Laminate Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • 2 Full Bathrooms
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Washer and Electric Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Block Basement Construction
  • 2 Bedrooms in Basement
  • Crawl Space

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • High-Efficiency Furnace
  • Heating System Uses Gas

Additional Features

  • Solar Heating System
  • Covered Patio or Porch

Community Details

  • Community Fire Pit

Listing and Financial Details

  • Assessor Parcel Number 19-08-31-101-118.000-009

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,060

Year Built

Built in 1980

Lot Details

0

Parking

2

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 1980
  • Age: 44
  • Style: One Story
  • Architectural Style: Ranch
  • Total Number of Rooms: 11
  • Total Number of Rooms Below Grade: 3
  • Bedrooms: 5
  • Number Above Grade Bedrooms: 3
  • Total Bathrooms: 2
  • Total Full Bathrooms: 2
  • Legal Description: 006-02380-01 PT E 1/2 NE 31-1-3 2A, 006-02380-02 PT S 1/2 NE 31-1-3 .75A
  • Parcel Number ID: 19-08-31-101-118.000-009
  • Platted: Yes
  • Amenities: Attic Pull Down Stairs, Ceiling Fan(s), Countertops-Laminate, Deck Open, Detector-Smoke, Disposal, Dryer Hook Up Electric, Firepit, Garage Door Opener, Kitchen Island, Landscaped, Open Floor Plan, Pantry-Walk In, Porch Covered, Range/Oven Hook Up Elec, Stand Up Shower, Tub/Shower Combination, Workshop, Main Level Bedroom Suite, Garage-Heated, Main Floor Laundry, Washer Hook-Up, Garage Utilities
  • Location: Rural
  • Number Below Grade Bedrooms: 2
  • Sp Lp Percent: 98.48
  • Year Taxes Payable: 2024
  • Special Features: None
  • Stories: 1

Interior Features

  • Total Sq Ft: 3115
  • Total Finished Sq Ft: 3115
  • Above Grade Finished Sq Ft: 2077
  • Below Grade Finished Sq Ft: 1038
  • Price Per Sq Ft: 187.29
  • Basement: Yes
  • Basement Foundation: Crawl, Partial Basement, Walk-Out Basement, Finished
  • Basement Material: Block
  • Number Of Fireplaces: 1
  • Fireplace: Dining Rm, Living/Great Rm, Gas Log
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Carpet, Tile, Vinyl
  • Living Great Room: Dimensions: 19x15, On Level: Main
  • Kitchen: Dimensions: 19x12, On Level: Main
  • Dining Room: Dimensions: 19x11, On Level: Main
  • Family Room: Dimensions: 16x17, On Level: Main
  • Recreation Room: Dimensions: 18x18, On Level: Lower
  • Extra Room: Shop office, Dimensions: 22x22, On Level: N/A
  • Bedroom 1: Dimensions: 16x15, On Level: Main
  • Bedroom 2: Dimensions: 12x12, On Level: Main
  • Bedroom 3: Dimensions: 12x12, On Level: Main
  • Bedroom 4: Dimensions: 13x12, On Level: Lower
  • Bedroom 5: Dimensions: 12x12, On Level: Lower
  • Number of Main Level Full Bathrooms: 2
  • Total Below Grade Sq Ft: 1038

Exterior Features

  • Exterior: Aluminum, Limestone
  • Roof Material: Dimensional Shingles
  • Outbuilding1: 2nd Detached Garage, Dimensions: 35x48
  • Outbuilding2: Pole/Post Building, Dimensions: 30x40, 1200

Garage/Parking

  • Driveway: Concrete, Gravel
  • Garage Type: Attached
  • Garage Number Of Cars: 2
  • Garage Size: Dimensions: 24x32
  • Garage Sq Ft: 768
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: Public
  • Water Utilities: Public
  • Electric Company: Dubois REC
  • Gas Company: Indiana Natural Gas
  • Water Company: Dubois Water Utilities
  • Hvac: Ceiling Fan, High Efficiency Furnace, Solar Heat
  • Laundry: Dimensions: Mainx7, On Level: 10

Schools

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

Lot Info

  • Lot Description: Level, Partially Wooded, 0-2.9999
  • Lot Dimensions: 0 x 0
  • Estimated Lot Sq Ft: 119790
  • Estimated Lot Size Acres: 2.75

Green Features

  • Energy Efficient Windows/Doors: Double Pane Windows, Insulated Doors

Tax Info

  • Annual Taxes: 4059.84
  • Exemptions: Mortgage

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 4, 2024
Closed on
Jun 14, 2024
Sold by
Hustedde Nicholas Victor
Bought by
Heeke Reid D
Seller's Agent
Tama Stemle
RE/MAX Local
Buyer's Agent
Tama Stemle
RE/MAX Local
List Price
$395,000
Sold Price
$389,000
Premium/Discount to List
-$6,000
-1.52%
Views
20
Current Estimated Value
$370,618

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$18,382
Avg. Annual Appreciation
-5.12%

Purchase Details

Listed on
Apr 14, 2019
Closed on
Jun 3, 2019
Sold by
Schaefer Dawn R and Schaefer Derrick J
Bought by
Hustedde Nicholas Victor and Hustedde Kimberly Ann
Seller's Agent
Tama Stemle
RE/MAX Local
Buyer's Agent
Tama Stemle
RE/MAX Local
List Price
$272,500
Sold Price
$272,500

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.32%
Original Mortgage
$192,500
Interest Rate
4.2%
Mortgage Type
New Conventional
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
Heeke Reid D $389,000 Crossroads Title & Escrow Llc
Hustedde Nicholas Victor $272,500 Dubois County Title Co., Inc.
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Hustedde Nicholas Victor $192,000
Previous Owner Hustedde Nicholas Victor $192,500
Previous Owner Schaefer Derrick J $15,000
Previous Owner Bieker Mark A $100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/14/2024 06/14/24 Sold $389,000 -1.5% $125 / Sq Ft
05/13/2024 05/13/24 Pending -- -- --
04/04/2024 04/04/24 For Sale $395,000 +45.0% $127 / Sq Ft
06/03/2019 06/03/19 Sold $272,500 0.0% $87 / Sq Ft
04/14/2019 04/14/19 Pending -- -- --
04/14/2019 04/14/19 For Sale $272,500 -- $87 / 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 $2,314 $306,600 $27,400 $279,200
2023 $3,993 $279,600 $27,400 $252,200
2022 $3,531 $245,900 $18,000 $227,900
2021 $3,263 $210,200 $18,000 $192,200
2020 $3,323 $206,800 $17,100 $189,700
2019 $1,630 $0 $0 $0
2018 $1,661 $203,000 $17,100 $185,900
2017 $1,656 $195,900 $17,100 $178,800
2016 $1,655 $196,700 $17,100 $179,600
2014 $1,394 $189,900 $15,500 $174,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202411058

Indiana Regional MLS

APN: 19-08-31-101-118.000-009