0 of 108

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

$958,132

Listing Price

4beds

3baths

4,431sqft

201,247sqft lot

3204 N 250 E, Fremont, IN 46737

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

For Sale

Off Market

Single Family

Home type

216.23

Price / sqft

2001

Year built

Home Details

This exceptional Dennis Spidel custom-built estate, originally designed as a personal residence, offers over 4,400 sq ft of Luxury living with 4 bedrooms and 3.5 baths on 16.5 scenic acres of rolling pastures and peaceful natural views where deer frequent the land. The chefs kitchen features quarter-sawn solid oak cabinetry, solid-surface countertops, dual porcelain farmhouse built in sinks, professional series 6 burner gas cooktop, and a generous breakfast bar seating seven, complemented by a formal dining area with cathedral ceiling and panoramic views. The living room showcases southern-facing mission-style windows, hardwood flooring, and a dramatic floor-to-ceiling stone wood-burning fireplace. Designed for entertaining, the home includes a custom tiger oak and mirrored bar in the family room with inlaid tile floor and a billiards area featuring an early-1900s antique pool table. The main-floor primary suite overlooks the equine facilities and offers a multi-head walk-in tiled shower, spacious walk-in closet, and private access to a screened patio and hot tub. A grand staircase leads to the upper level featuring three additional bedrooms. A versatile bedroom/office showcases a striking beamed ceiling and a built-in Murphy bed, perfect for accommodating guests while maintaining a refined workspace. This room shares a well-appointed Jack-and-Jill bathroom, complete with private vanities, with an adjoining bedroom. A third bedroom enjoys its own private full bath, creating p

Interior Details

Square Feet
  • 4431

Bedrooms
  • 4

Bathrooms
  • 3

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Central

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    No

  • Fuel Type:

    N/A

Basement
  • Has Basement:

    No

  • Basement Type:

    No Basement

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 201247

Water
  • No

Sewer
  • No

Parking
  • Type:

    Mixed

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    9

Deck
  • N/A

Patio
  • N/A

Fence
  • N/A

Pool
  • N/A

Porch
  • N/A

Stoop
  • N/A

Breezeway
  • N/A

Construction Details

Number of Stories
  • 2

Style
  • N/A

Exterior
  • N/A

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • Asphalt

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

2019

$3,482

$21,900

$603,400

--%

$625,300

2018

$3,063

$22,100

$636,500

--%

$658,600

2017

$2,978

$42,700

$502,500

--%

$545,200

2016

$2,340

$42,700

$488,700

--%

$531,400

2016

$2,340

$42,700

$566,200

--%

$608,900

percent-home-icon

Average Home Price in 46737

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$958,132

4 Beds

3 Baths

4,431 Sqft

201,247 Lot (sqft)

Sold 10/13/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
958,132
$
Down payment
191,626.40
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
5,748.79
$
HOA (Monthly)
0
$
PMI
0
$
$6,202
Your Payment
Total Monthly Payment:$6,202
Percent of Income:106%
Affordable:No

Details for 3204 N 250 E

Property Debt

Foreclosure Contact Details

Similar Homes Nearby