NOT LISTED FOR SALE

118 N Front St Syracuse, IN 46567

Estimated Value: $1,375,000 - $1,523,425

3 Beds
3 Baths
4,525 Sq Ft
$321/Sq Ft Est. Value

Last Sold January 26, 2024

Last sale price $1,425,000 $315 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $9,537/month

4 Days on Market

Highlights

  • 55 Feet of Waterfront
  • Primary Bedroom Suite
  • Lake Property
  • Pier or Dock
  • Open Floorplan
  • Cape Cod Architecture

About This Home

As of January 2024

Welcome to Syracuse Lake! This stunning home offers 55’ Syracuse Lake frontage and spanning views of the all-sports lake. From the beamed ceilings, to the open concept floor plan, to the cozy living room and the covered front porch – this is one you’re sure to love! Upon walking in the front door, you’ll be greeted by the large foyer area, detailed with hardwood floors and white craftsman trim. Just down the hallway is the open-concept kitchen and living room – an entertainer’s dream. The kitchen offers stone countertops, tiled backsplash, stainless steel appliances and a large eat-in island. A butler’s pantry sits just behind the kitchen and offers plenty of space for all of your staging and storage needs. Just on the other side of the kitchen is the sizable family room, where you can cozy up by the gas-log fireplace, which is traced with beautiful stonework. Floor to ceiling windows line the family room, dining area and kitchen with gorgeous Syracuse Lake views. The master en suite can also be found on the main level and offers an oversized, custom twin vanity sink, tiled shower and large walk-in closet. The main-level laundry room is complete with terra cotta tile, a utility sink, extra counter space and shelving for all of your storage needs. Just upstairs, you’ll find two additional bedrooms – both with impressive views of Syracuse Lake. An oversized bonus room sits just down the hallway, which could easily be used as a bunk room or game room. Another full bathroom is located on the upper level, complete with a tiled shower and garden tub. This home offers a great deal of storage and is complete with an attached 3-car garage. Enjoy sunrises and sunsets from the covered front porch and plenty of space for yard games on the level front yard. Located in the heart of town, this home is within walking distance of local shops, restaurants and walking trails. Let the lake fun begin!

Last Listed By

Michael Conrad

Coldwell Banker Real Estate Group Brokerage Phone: 574-328-0776 Listed on: 01/03/2024

Coldwell Banker Real Estate Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $16,388

Year Built

  • Built in 2005

Lot Details

  • 7,405 Sq Ft Lot
  • Lot Dimensions are 55x130
  • 55 Feet of Waterfront
  • Lake Front
  • Backs to Open Ground
  • Level Lot

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Cape Cod Architecture
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 4,525 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Beamed Ceilings
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Gas Log Fireplace
  • Entrance Foyer
  • Living Room with Fireplace
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Gas Oven or Range
  • Kitchen Island
  • Stone Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Double Vanity
  • Bathtub With Separate Shower Stall
  • Garden Bath

Laundry

  • Laundry on main level
  • Electric Dryer Hookup

Basement

  • Block Basement Construction
  • Crawl Space

Outdoor Features

  • Waterski or Wakeboard
  • Seawall
  • Lake Property
  • Lake, Pond or Stream
  • Covered Deck

Schools

  • Syracuse Elementary School
  • Wawasee Middle School
  • Wawasee High School

Additional Features

  • Suburban Location
  • Forced Air Heating and Cooling System

Community Details

  • Pier or Dock

Listing and Financial Details

  • Assessor Parcel Number 43-04-05-300-500.000-026

Home Details

Home Type

Single Family

Est. Annual Taxes

$16,388

Year Built

Built in 2005

Lot Details

0

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 2005
  • Age: 19
  • Style: Two Story
  • Architectural Style: Cape Cod
  • Total Number of Rooms: 12
  • Bedrooms: 3
  • Number Above Grade Bedrooms: 3
  • Total Bathrooms: 3
  • Total Full Bathrooms: 3
  • Legal Description: 008-019-058 S 55' LOT 122 S & W 2ND ADD
  • Parcel Number ID: 43-04-05-300-500.000-026
  • Platted: Yes
  • Amenities: Alarm System-Security, Breakfast Bar, Ceiling-9+, Ceiling Fan(s), Ceilings-Beamed, Closet(s) Walk-in, Countertops-Stone, Deck Covered, Deck Open, Disposal, Dryer Hook Up Electric, Eat-In Kitchen, Foyer Entry, Garage Door Opener, Garden Tub, Kitchen Island, Near Walking Trail, Open Floor Plan, Pantry-Walk In, Range/Oven Hook Up Gas, Six Panel Doors, Twin Sink Vanity, Utility Sink, Stand Up Shower, Tub and Separate Shower, Main Level Bedroom Suite, Main Floor Laundry
  • Grid: 55 - N.E. Kosc. Water
  • Location: City/Town/Suburb, Lake
  • Sp Lp Percent: 98.28
  • Year Taxes Payable: 2024
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 4525
  • Total Finished Sq Ft: 4525
  • Above Grade Finished Sq Ft: 4525
  • Price Per Sq Ft: 314.92
  • Basement Foundation: Crawl
  • Basement Material: Block
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Log
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Tile
  • Living Great Room: Dimensions: 19x20, On Level: Main
  • Kitchen: Dimensions: 20x14, On Level: Main
  • Dining Room: Dimensions: 14x7, On Level: Main
  • Recreation Room: Dimensions: 31x46, On Level: Upper
  • Bedroom 1: Dimensions: 16x13, On Level: Main
  • Bedroom 2: Dimensions: 22x14, On Level: Upper
  • Bedroom 3: Dimensions: 15x24, On Level: Upper
  • Other Room1: Butler's Pantry, Dimensions: 6x11
  • Number of Main Level Full Bathrooms: 2

Exterior Features

  • Exterior: Vinyl
  • Roof Material: Asphalt
  • Outbuilding1: None
  • Lake Type: Ski Lake
  • Sea Wall Type: Concrete
  • Water Features: Pier/Dock
  • Water Frontage: 55
  • Water Name: Syracuse Lake

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 26x30
  • Garage Sq Ft: 780
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Forced Air
  • Sewer: City
  • Water Utilities: City
  • Gas Company: NIPSCO
  • Hvac: Ceiling Fan
  • Laundry: Dimensions: Mainx8, On Level: 11
  • Water Type: Lake

Schools

  • School District: Wawasee
  • Elementary School: Syracuse
  • Middle School: Wawasee
  • High School: Wawasee
  • Elementary School: Syracuse

Lot Info

  • Lot Description: Level, Waterfront, 0-2.9999, Lake
  • Lot Dimensions: 55x130
  • Estimated Lot Sq Ft: 7405
  • Estimated Lot Size Acres: 0.17

Tax Info

  • Annual Taxes: 16388

Multi Family

  • Water Access: Lakefront

MLS Schools

  • High School: Wawasee
  • Middle School: Wawasee
  • School District: Wawasee

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 3, 2024
Closed on
Jan 23, 2024
Sold by
Hentza Living Trust
Bought by
Michael James Mulroy Revocable Living Trust and Deborah Bucher Mulroy Revocable Living Trust
Seller's Agent
Michael Conrad
Coldwell Banker Real Estate Group
Buyer's Agent
Deb Paton-Showley
Coldwell Banker Real Estate Group
List Price
$1,450,000
Sold Price
$1,425,000
Premium/Discount to List
-$25,000
-1.72%
Total Days on Market
4
Views
26
Current Estimated Value
$1,453,142

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$28,142
Avg. Annual Appreciation
1.55%

Purchase Details

Listed on
Jan 3, 2024
Closed on
Dec 6, 2023
Sold by
Owens Elizabeth A and Hentze Joseph M
Bought by
Hentze Living Trust and Hentze
Seller's Agent
Michael Conrad
Coldwell Banker Real Estate Group
Buyer's Agent
Deb Paton-Showley
Coldwell Banker Real Estate Group
List Price
$1,450,000
Sold Price
$1,425,000
Premium/Discount to List
-$25,000
-1.72%
Views
26

Purchase Details

Closed on
Oct 6, 2022
Sold by
Hentze Living Trust
Bought by
Owens Elizabeth A and Hentze Joseph M

Purchase Details

Closed on
Nov 9, 2019
Sold by
Hentze Gary W and Hentze Sally J
Bought by
Hentze Gary and Hentze Sally J

Purchase Details

Closed on
Sep 20, 2005
Sold by
Hentze Gary W and Hentze Sally J
Bought by
Hentze Gary W and Hentze Sally J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$359,650
Interest Rate
6.01%
Mortgage Type
New Conventional

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
Michael James Mulroy Revocable Living Trust $1,425,000 Fidelity National Title
Hentze Living Trust -- None Listed On Document
Owens Elizabeth A -- --
Hentze Gary -- None Available
Hentze Gary W -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Hentze Gary W $328,500
Previous Owner Hentze Gary W $338,078
Previous Owner Hentze Gary W $359,650
Previous Owner Hentze Gary W $50,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/26/2024 01/26/24 Sold $1,425,000 -1.7% $315 / Sq Ft
01/03/2024 01/03/24 For Sale $1,450,000 -- $320 / 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 $17,300 $1,118,300 $521,400 $596,900
2023 $17,397 $1,011,100 $473,600 $537,500
2022 $15,799 $884,700 $411,800 $472,900
2021 $12,644 $690,500 $364,300 $326,200
2020 $12,025 $658,800 $364,300 $294,500
2019 $12,046 $619,500 $340,600 $278,900
2018 $11,014 $579,700 $316,800 $262,900
2017 $10,666 $556,300 $316,800 $239,500
2016 $9,682 $559,000 $316,800 $242,200
2014 $9,668 $537,900 $316,800 $221,100
2013 $9,668 $529,700 $316,800 $212,900
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in Syracuse, IN

  • 506 E Medusa St, Syracuse, IN 46567

    $1,699,000

    • 4 Beds
    • 3.5 Baths
    • 3,684 Sq Ft
    • 506 E Medusa St
    • Syracuse, IN

    Wake up to breathtaking lake views in this stunning four-bedroom, three-and-a-half-bathroom lakefront home on Syracuse Lake. Designed for both relaxation and entertaining, the spacious open-concept layout is filled with natural light, offering seamless flow between the living, dining, and kitchen areas. The heart of the home is the beautiful kitchen, featuring a large island perfect for

    Darlene Bullock Sterk Mike Thomas Assoc., Inc

    Section Image
  • 843 E Northshore Dr, Syracuse, IN 46567

    $1,599,000

    • 3 Beds
    • 3.5 Baths
    • 3,110 Sq Ft
    • 843 E Northshore Dr
    • Syracuse, IN

    Stunning Modern Farmhouse Lake Home with Infinity Views & Luxury Upgrades Welcome to your dream lakefront retreat! This beautifully designed modern farmhouse is move in ready and offers the perfect blend of luxury, comfort, and breathtaking views of Syracuse Lake with 50 feet of lakefront living. This 3 bedroom 3.5 bath home, was updated in 2019 to include high-end kitchen appliances and

    Rex Heil Keller Williams Thrive North

    Section Image
  • 8230 N State Road 13, Syracuse, IN 46567

    $1,675,000

    • 3 Beds
    • 2.5 Baths
    • 2,436 Sq Ft
    • 8230 N State Road 13
    • Syracuse, IN

    Location. Location. Location. 14 acres that abuts the 3,600 acre Indiana DNR Tri County Fish and Wildlife area. Property is fenced and gated(close the gate for total privacy or to keep animals in). Sits atop one of the highest points in the County, no easements on 14 acres, unique cattail/wetland habitat in Northwest corner of property, very secluded, perfect for a mini farm ( bring your horses,

    Joseph Wootan List With Freedom.com LLC

    Section Image

Source: Indiana Regional MLS

MLS Number: 202400519

Indiana Regional MLS

APN: 43-04-05-300-500.000-026