NOT LISTED FOR SALE

1518 Sunsetview Rd Brainerd, MN 56401

Estimated Value: $1,660,000 - $2,457,000

3 Beds
5 Baths
3,956 Sq Ft
$532/Sq Ft Est. Value

Sale Details

Date Sold: July 15, 2025

Last sale price $2,142,500 $542 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $12,311 / mo

37 Days on Market

Highlights

  • 120 Feet of Waterfront
  • Guest House
  • Family Room with Fireplace
  • Brainerd Senior High School Rated 9+
  • Multiple Garages
  • Main Floor Primary Bedroom

About This Home

As of July 2025

Welcome to your ultimate Gull Lake retreat! This beautifully appointed 3 bedroom, 4 bathroom lake home offers stunning lake views with 120 feet of West facing shoreline. Enjoy seamless indoor-outdoor living with an expansive deck, perfect for entertaining or relaxing lakeside. The private guest house is a standout feature, complete with 3 beds, a full bathroom, kitchenette, and a golf simulator- ideal for hosting family and friends for year-round fun. A rare combination of luxury, comfort, and recreation in a premier location.

Last Agent to Sell the Property

Karissa Haugen

RE/MAX Advantage Plus Listed on: 05/13/2025

RE/MAX Advantage Plus

Last Buyer's Agent

Karissa Haugen

RE/MAX Advantage Plus Listed on: 05/13/2025

RE/MAX Advantage Plus

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,792

Year Built

  • Built in 2001

Lot Details

  • 2.76 Acre Lot
  • Lot Dimensions are 120x1065x113x1125
  • 120 Feet of Waterfront
  • Lake Front
  • Many Trees
  • Zoning described as Shoreline,Residential-Single Family

Parking

  • 4 Car Attached Garage
  • Multiple Garages
  • Heated Garage
  • Insulated Garage
  • Garage Door Opener

Home Design

  • Pitched Roof
  • Shake Siding

Interior Spaces

  • 2-Story Property
  • Circulating Fireplace
  • Gas Fireplace
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Dining Room
  • Bonus Room
  • Storage Room

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • The kitchen features windows

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Block Basement Construction
  • Basement Storage

Additional Homes

  • Guest House

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Underground Utilities
  • 200+ Amp Service
  • Private Water Source
  • Well
  • Drilled Well

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 870203116

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,792

Year Built

Built in 2001

Lot Details

2.76 Acres

Parking

4

Listing Details

  • Type: Residential
  • Property Subtype 1: Single Family Residence
  • Cooling System: Central Air
  • Garage Spaces: 4
  • Accessibility Features: None
  • Fireplaces: 2
  • Water Source: Drilled, Private, Well
  • Year Built: 2001
  • Above Grade Finished Sq Ft: 2672
  • Water Body Name: Gull
  • Unit Levels: More Than 2 Stories
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Basement: Block, Finished, Full, Storage Space, Sump Pump, Walkout
  • Appliances: Dishwasher, Dryer, Exhaust Fan, Microwave, Range, Refrigerator, Washer
  • Fireplace Features: Circulating, Family Room, Gas, Living Room
  • Living Area: 3956
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 1284
  • Basement YN: Yes
  • Dining Room Type: Living Room, Kitchen, Dining Room, Bedroom 1, Bedroom 2, Bedroom 3, Family Room, Bonus Room, Storage, Foyer, Laundry, Guest House

Beds/Baths

  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • One Quarter Bathrooms: 1
  • Three Quarter Bathrooms: 1

Exterior Features

  • Roof: Asphalt, Pitched
  • Other Structures: Additional Garage, Bunk House, Guest House
  • ConstructionMaterialsDesc: Block,Insulating Concrete Forms
  • PatioPorchType: Awning(s),Deck,Patio,Porch
  • Lake Bottom: Rocky,Sand
  • LakeChain: Y
  • Elevation Highpoint to Waterfront Feet: 4-10
  • Waterfront Frontage: 120
  • Lake Chain Acreage: 13497
  • Lake Chain Name: Gull

Garage/Parking

  • Parking Features: Attached Garage, Asphalt, Garage Door Opener, Heated Garage, Insulated Garage, Multiple Garages, Paved

Utilities

  • Heating: Forced Air, Fireplace(s)
  • Sewer: City Sewer/Connected
  • Electric: Circuit Breakers, 200+ Amp Service
  • Fuel: Natural Gas

Condo/Co-op/Association

  • Association: No
  • Amenities Unit: Cable,Ceiling Fan(s),Deck,Dock,French Doors,Hardwood Floors,Hot Tub,Kitchen Center Island,Kitchen Window,Main Floor Primary Bedroom,Patio,Porch,Panoramic View,In-Ground Sprinkler,Vaulted Ceiling(s),Wet Bar,Walk-In Closet

Schools

  • Junior High Dist: Brainerd
  • SchoolDistrictPhone: 218-454-6900

Lot Info

  • Waterfront YN: Yes
  • PropertyAttachedYN: No
  • Lot Size: 120x1065x113x1125
  • Lot Size Sq Ft: 120225.6
  • Land Lease: No
  • Lot Features: Many Trees, Underground Utilities
  • Additional Parcels: No
  • Zoning Description: Shoreline,Residential-Single Family
  • AssessmentPending: Unknown
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Engineered Wood, Shake Siding

Tax Info

  • Tax Year: 2025
  • Assessor Parcel Number: 870203116
  • Tax Annual Amount: 12792
  • TaxWithAssessments: 12858.0000

Multi Family

  • WaterfrontFeatures: Lake Front

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 13, 2025
Closed on
Jul 15, 2025
Sold by
Floyd Clarence O and Clarence O Floyd Revocable Trust
Bought by
Longnecker Melissa and Longnecker Joshua A
Seller's Agent
Karissa Haugen
RE/MAX Advantage Plus
Buyer's Agent
Karissa Haugen
RE/MAX Advantage Plus
List Price
$2,400,000
Sold Price
$2,142,500
Premium/Discount to List
-$257,500
-10.73%
Views
46
Current Estimated Value
$2,105,336

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$37,164
Avg. Annual Appreciation
-2.11%
Original Mortgage
$1,606,875
Outstanding Balance
$1,604,154
Interest Rate
6.85%
Mortgage Type
New Conventional
Estimated Equity
$501,182

Purchase Details

Closed on
Aug 14, 2020
Sold by
Halliwill Harris D and Halliwill Sharon K
Bought by
Halliwill Harris D and Halliwill Sharon K
Source: Public Records
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

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
Longnecker Melissa $2,142,500 Elite Title
Halliwill Harris D $3,000 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open Longnecker Melissa $1,606,875
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/15/2025 07/15/25 Sold $2,142,500 -10.7% $542 / Sq Ft
06/19/2025 06/19/25 Pending -- -- --
05/13/2025 05/13/25 For Sale $2,400,000 +41.2% $607 / Sq Ft
09/21/2023 09/21/23 Sold $1,700,000 -12.8% $430 / Sq Ft View Prior Sale
08/07/2023 08/07/23 Pending -- -- --
07/28/2023 07/28/23 For Sale $1,950,000 -- $493 / Sq Ft
Source: NorthstarMLS

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
2025 $12,858 $1,956,400 $1,033,100 $923,300
2024 $12,858 $1,727,000 $829,200 $897,800
2023 $12,302 $1,829,600 $931,200 $898,400
2022 $10,268 $1,829,600 $931,200 $898,400
2021 $9,660 $1,089,600 $488,500 $601,100
2020 $9,320 $1,018,500 $437,500 $581,000
2019 $9,282 $950,900 $386,600 $564,300
2018 $8,308 $895,800 $394,100 $501,700
2017 $7,758 $895,800 $394,100 $501,700
2016 $7,104 $0 $0 $0
2015 $7,104 $802,000 $354,200 $447,800
2014 $6,654 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Karissa Haugen

    Seller's Agent in 2025

    Karissa Haugen

    RE/MAX Advantage Plus

    (218) 821-0292

    78 Total Sales

    Karissa Haugen
    Section Image
  • Sandy Smith

    Seller's Agent in 2023

    Sandy Smith

    Kurilla Real Estate LTD

    (218) 838-9309

    156 Total Sales

    Sandy Smith
    Section Image
See All Agents

Map

Source: NorthstarMLS

MLS Number: 6706341

NorthstarMLS

APN: 87-020-3116

Minnesota Cass County Brainerd 56401

1518 Sunsetview Rd, Brainerd, MN

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.

NorthstarMLS All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.
Listings courtesy of NorthstarMLS as distributed by MLS GRID.
Based on information submitted to the MLS GRID

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.