NOT LISTED FOR SALE

534 S 500 E Unit 57 Avilla, IN 46710

Estimated Value: $252,000 - $2,300,000

6 Beds
7.5 Baths
9,225 Sq Ft
$174/Sq Ft Est. Value

Last Sold June 24, 2024

Last sale price $2,300,000 $249 Per Sq Ft

Est. 30% decrease in value since last sale

Current estimated payment $11,343/month

610 Days on Market

Highlights

  • In Ground Pool
  • 170 Acre Lot
  • Living Room with Fireplace
  • Waterfront
  • Heavily Wooded Lot
  • Lake, Pond or Stream

About This Home

As of June 2024

AUCTION BIDDING OPEN: Bidding ends May 30. Previously Listed $3.495M. Current High Bid $1.6M. No Reserve. Showings By Appt. Camelot Ridge Resort is an outdoorsman's oasis in the heart of Indiana. This hunter's retreat boasts an expansive estate with 170-plus acres of pristine hardwood trees, rolling hills, miles of trails, and a serene lake that give way to a majestic lodge. Experience nature's glory in every season across this six-bedroom estate built with reclaimed lumber featuring soaring ceilings, with abundant wildlife available and many established hunting rifle, bow, and tower blinds throughout the property. Use this retreat as your personal adventure retreat or for hosting large groups. The impeccable surroundings, both in the land and structures, will delight as you relax in the heated pool, enjoy ample seating around the fire pit, unwind in the 10-person hot tub, put your feet up in the theater room, or work out in the exercise room to refresh and prepare for the next day’s activities. Additional buildings include a barn, bunkhouse, professionally designed shooting range, and storage.

Last Buyer's Agent

RACI NonMember

NonMember RACI

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $42,070

Year Built

  • Built in 2011

Lot Details

  • 170 Acre Lot
  • Waterfront
  • Rural Setting
  • Heavily Wooded Lot

Parking

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

Home Design

  • Stone Exterior Construction
  • Cedar

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Woodwork
  • Cathedral Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Living Room with Fireplace
  • 2 Fireplaces
  • Home Security System
  • Electric Dryer Hookup

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Stone Countertops
  • Utility Sink
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • In-Law or Guest Suite
  • Whirlpool Bathtub
  • Garden Bath

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • 2 Bathrooms in Basement
  • 1 Bedroom in Basement

Outdoor Features

  • In Ground Pool
  • Lake, Pond or Stream
  • Patio

Schools

  • Churubusco Elementary And Middle School
  • Churubusco High School

Utilities

  • Forced Air Heating and Cooling System
  • Geothermal Heating and Cooling
  • Propane
  • Private Company Owned Well
  • Well
  • Septic System

Community Details

  • Community Pool

Listing and Financial Details

  • Assessor Parcel Number 57-20-02-200-001.000-007

Home Details

Home Type

Single Family

Est. Annual Taxes

$42,070

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
  • Age: 13
  • Style: Two Story
  • Total Number of Rooms: 17
  • Total Number of Rooms Below Grade: 4
  • Bedrooms: 6
  • Number Above Grade Bedrooms: 5
  • Total Bathrooms: 8
  • Total Full Bathrooms: 7
  • Total Number of Half Bathrooms: 1
  • Legal Description: 4 parcels total. Please see attached addendum. Parcel number 5 has been removed from listing.
  • Parcel Number ID: 57-20-02-200-001.000-007
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Alarm System-Security, Breakfast Bar, Ceiling-Cathedral, Ceiling Fan(s), Closet(s) Walk-in, Countertops-Stone, Deck Open, Disposal, Dryer Hook Up Electric, Eat-In Kitchen, Garage Door Opener, Jet Tub, Jet/Garden Tub, Guest Quarters, Natural Woodwork, Near Walking Trail, Pantry-Walk In, Patio Open, Utility Sink, Wet Bar
  • Location: Rural
  • Number Below Grade Bedrooms: 1
  • Sp Lp Percent: 100
  • Year Taxes Payable: 2021
  • Special Features: Auction
  • Stories: 2

Interior Features

  • Total Sq Ft: 9525
  • Total Finished Sq Ft: 9225
  • Above Grade Finished Sq Ft: 5984
  • Below Grade Finished Sq Ft: 3241
  • Below Grade Sq Ft: 300
  • Price Per Sq Ft: 384.36
  • Basement: Yes
  • Basement Foundation: Full Basement, Walk-Out Basement, Finished
  • Number Of Fireplaces: 2
  • Fireplace: Family Rm, Living/Great Rm, Wood Burning
  • Fireplace: Yes
  • Living Great Room: Dimensions: 22x22, On Level: Main
  • Kitchen: Dimensions: 17x16, On Level: Main
  • Breakfast Room: Dimensions: 14x14, On Level: Main
  • Dining Room: Dimensions: 15x13, On Level: Main
  • Family Room: Dimensions: 25x20, On Level: Lower
  • Den: Dimensions: 15x14, On Level: Main
  • Recreation Room: Dimensions: 18x16, On Level: Lower
  • Extra Room: Dimensions: 23x20, On Level: Lower
  • Bedroom 1: Dimensions: 20x21, On Level: Main
  • Bedroom 2: Dimensions: 13x11, On Level: Upper
  • Bedroom 3: Dimensions: 13x13, On Level: Upper
  • Bedroom 4: Dimensions: 15x12, On Level: Upper
  • Bedroom 5: Dimensions: 32x23, On Level: Upper
  • Loft: Dimensions: 14x11, On Level: Upper
  • Number Below Grade Bathrooms: 2
  • Number of Below Grade Full Bathrooms: 2
  • Number of Main Level Full Bathrooms: 3
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 3541

Exterior Features

  • Exterior: Cedar, Stone
  • Outbuilding1: Outbuilding, Dimensions: 102x40, 4000
  • Pool: Below Ground
  • Pool: Yes
  • Outbuilding2: Outbuilding, Dimensions: 45x32, 1440

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 34x24
  • Garage Sq Ft: 816
  • Garage: Yes
  • Off Street Parking: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Propane, Forced Air, Geothermal
  • Sewer: Septic
  • Water Utilities: Well
  • Laundry: Dimensions: Mainx9, On Level: 14
  • Water Type: Pond
  • Well Type: Private

Schools

  • School District: Smith-Green Community
  • Elementary School: Churubusco
  • Middle School: Churubusco
  • High School: Churubusco
  • Elementary School: Churubusco

Lot Info

  • Lot Description: Heavily Wooded, Waterfront, 15+
  • Lot Dimensions: 0 x 0
  • Estimated Lot Sq Ft: 7492320
  • Estimated Lot Size Acres: 170

Tax Info

  • Annual Taxes: 42070

MLS Schools

  • High School: Churubusco
  • Middle School: Churubusco
  • School District: Smith-Green Community

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 17, 2022
Closed on
Jun 24, 2024
Sold by
Hanlon Real Estate Holdings Llc
Bought by
Hanning & Bean Enterprises Inc
Buyer's Agent
RACI NonMember
NonMember RACI
List Price
$4,500,000
Sold Price
$2,300,000
Premium/Discount to List
-$2,200,000
-48.89%
Views
401
Current Estimated Value
$1,601,931

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 30, 2017
Sold by
Douglas Mccomb
Bought by
Hanlon Real Est Holdings 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
Hanning & Bean Enterprises Inc $2,300,000 Metropolitan Title Of Central
Hanlon Real Est Holdings Llc -- Attorney Only
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/24/2024 06/24/24 Sold $2,300,000 +43.8% $249 / Sq Ft
06/18/2024 06/18/24 Pending -- -- --
05/17/2024 05/17/24 Price Changed $1,600,000 -54.2% $173 / Sq Ft
09/26/2023 09/26/23 Price Changed $3,495,000 -2.9% $379 / Sq Ft
08/02/2023 08/02/23 Price Changed $3,600,000 -5.9% $390 / Sq Ft
02/08/2023 02/08/23 Price Changed $3,825,000 -15.0% $415 / Sq Ft
10/17/2022 10/17/22 For Sale $4,500,000 -- $488 / 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 $34,201 $2,349,300 $395,900 $1,953,400
2023 $33,856 $2,275,400 $371,300 $1,904,100
2022 $33,528 $2,216,900 $347,000 $1,869,900
2021 $36,021 $2,390,400 $346,500 $2,043,900
2020 $35,274 $2,116,400 $299,100 $1,817,300
2019 $35,390 $2,064,300 $261,400 $1,802,900
2018 $26,772 $1,498,500 $261,500 $1,237,000
2017 $14,586 $1,472,600 $254,400 $1,218,200
2016 $12,403 $1,360,900 $254,700 $1,106,200
2014 $16,237 $1,246,600 $224,200 $1,022,400
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202243110

Indiana Regional MLS

APN: 572002200001000007