118 N Front St Syracuse, IN 46567
3
Beds
3
Baths
4,525
Sq Ft
7,405
Sq Ft Lot
Highlights
- 55 Feet of Waterfront
- Primary Bedroom Suite
- Lake Property
- Pier or Dock
- Open Floorplan
- Cape Cod Architecture
About This Home
As of May 2025Welcome 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 Agent to Sell the Property
Coldwell Banker Real Estate Group Brokerage Phone: 574-328-0776 Listed on: 01/03/2024
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
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 19, 2025
Closed on
May 15, 2025
Sold by
Michael James Mulroy Revocable Living Tr and Deborah Bucher Revocable Living Trust
Bought by
Loucks Derek T and Loucks Olivia M
Seller's Agent
Deb Paton-Showley
Coldwell Banker Real Estate Group
Buyer's Agent
Tam Smith
Steffen Realty
List Price
$1,649,000
Sold Price
$1,625,000
Premium/Discount to List
-$24,000
-1.46%
Total Days on Market
4
Views
10
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-71.48%
Original Mortgage
$1,462,337
Outstanding Balance
$1,462,337
Interest Rate
6.62%
Mortgage Type
New Conventional
Estimated Equity
$7,507
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%
Views
26
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.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
Similar Homes in Syracuse, IN
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | -- | Fidelity National Title | |
| Deed | $1,425,000 | Fidelity National Title | |
| Quit Claim Deed | -- | None Listed On Document | |
| Deed | -- | -- | |
| Interfamily Deed Transfer | -- | None Available | |
| Deed | -- | None Available |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,462,337 | New Conventional | |
| Previous Owner | $328,500 | New Conventional | |
| Previous Owner | $338,078 | New Conventional | |
| Previous Owner | $359,650 | New Conventional | |
| Previous Owner | $50,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/19/2025 05/19/25 | Sold | $1,625,000 | -1.5% | $359 / Sq Ft |
| 05/19/2025 05/19/25 | Pending | -- | -- | -- |
| 05/19/2025 05/19/25 | For Sale | $1,649,000 | +15.7% | $364 / Sq Ft |
| 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
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 | $18,355 | $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
-
Deb Paton-Showley
Seller's Agent in 2025
Deb Paton-Showley
Coldwell Banker Real Estate Group
(574) 527-6022
515 Total Sales
-
Tam Smith
T
Buyer's Agent in 2025
Tam Smith
Steffen Realty
(800) 727-0609
36 Total Sales
-
Michael Conrad
Seller's Agent in 2024
Michael Conrad
Coldwell Banker Real Estate Group
(574) 529-4267
63 Total Sales
Map
Source: Indiana Regional MLS
MLS Number: 202400519
APN: 43-04-05-300-500.000-026
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 300 E Medusa St Unit 5D
- 506 E Medusa St
- 402&404 W Carroll St
- 101 W Main St
- 511 W Boston St
- 843 E Northshore Dr
- 202 E Pickwick Dr
- 0 TBD N Huntington St
- 312 W Hillside Dr
- 860 E Northshore Dr
- 608 Polywood Way
- TBD E Pickwick Dr
- 1158 E Northshore Dr
- tbd Huntington
- 5833 E Pickwick Dr
- 1329 E Northshore Dr
- 515 E Lake View Rd
- 6167 E Pickwick Park Dr
- 4310 Duffy Dr
- 12018 N Woodland Acres Dr