$2,142,500
SOLD JUL 15, 2025

1518 Sunsetview Rd Brainerd, MN 56401

3 Beds
5 Baths
3,956 Sq Ft
2.76 Acres

Recently Sold

$542 Per Sq Ft

11% Below List Price

37 Days on Market

Highlights

  • 120 Feet of Waterfront
  • Multiple Garages
  • Main Floor Primary Bedroom
  • Guest House
  • Family Room with Fireplace
  • Bonus Room

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

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
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Bonus Room
  • Storage Room

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • The kitchen features windows

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main

Laundry

  • Dryer
  • Washer

Finished Basement

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

Additional Homes

  • Guest House

Utilities

  • Forced Air Heating and Cooling System
  • 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

0

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
  • FoundationDimensions: 54x38
  • 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 Acres: 10010
  • 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
  • Garage Square Feet: 1114

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
  • SchoolDistrictNumber: 181
  • 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
45

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
193.54%
Original Mortgage
$1,606,875
Outstanding Balance
$1,606,875
Interest Rate
6.85%
Mortgage Type
New Conventional
Estimated Equity
$703,366

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

Similar Homes in Brainerd, MN

  • 1569 Floan Point Rd, Brainerd, MN 56401

    $2,125,000

    • 5 Beds
    • 3 Baths
    • 4,000 Sq Ft
    • 1569 Floan Point Rd
    • Brainerd, MN

    Discover Lakeside Luxury: A Stunning Gull Lake Retreat, Nestled on the picturesque south end of historic Gull Lake, this extraordinary custom-built home offers an unparalleled living experience. Situated on a gorgeous lot with 100ft of pristine waterfront, this meticulously maintained 5-BR, 3-BA residence is a true masterpiece of design and natural beauty. As you approach, mature trees and a

    Matthew Pecarich Kurilla Real Estate LTD

    Section Image
  • 10960 Pine Beach Peninsula Rd, Brainerd, MN 56401

    $1,895,000

    • 5 Beds
    • 3 Baths
    • 2,970 Sq Ft
    • 10960 Pine Beach Peninsula Rd
    • Brainerd, MN

    Introducing a rare offering on the highly sought-after Pine Beach Peninsula in East Gull Lake—this impeccably maintained Gull Lake residence presents timeless elegance, modern luxury, and breathtaking panoramic views. Set on a premier stretch of shoreline, the home showcases like-new condition throughout, reflecting meticulous care and pride of ownership. Featuring 5 spacious bedrooms and 3

    Adam Kalenberg Northland Sotheby's International Realty

    Section Image
  • 1924 Norway Pine Rd, Brainerd, MN 56401

    $1,750,000

    • 5 Beds
    • 3.5 Baths
    • 3,714 Sq Ft
    • 1924 Norway Pine Rd
    • Brainerd, MN

    Inviting Gull Lake executive home with stunning views of Wilson bay and Crane Island. This home has it all including five bedrooms, four baths, office, gourmet kitchen with custom cabinets, built-ins throughout, gas fireplace, massive new lakeside deck, main floor laundry and mud room certain to satisfy the most discerning taste, primary suite with spa quality bath and huge walk in closets, full

    Adam Kalenberg Northland Sotheby's International Realty

    Section Image
  • 19522 Love Lake Rd, Brainerd, MN 56401

    $2,395,000

    • 4 Beds
    • 4.5 Baths
    • 4,114 Sq Ft
    • 19522 Love Lake Rd
    • Brainerd, MN

    Experience luxury lakeside living at its finest in this exceptional custom-built 2020 retreat on the pristine shores of Love Lake (Gull Chain of Lakes), nestled in the heart of Minnesota’s premier vacation destination. Thoughtfully designed with timeless elegance and modern sophistication, this residence offers four distinctive bedrooms, five luxurious baths, and a gourmet kitchen crafted for

    Adam Kalenberg Northland Sotheby's International Realty

    Section Image
  • 19923 See Gull Rd, Brainerd, MN 56401

    $1,845,000

    • 4 Beds
    • 3 Baths
    • 3,048 Sq Ft
    • 19923 See Gull Rd
    • Brainerd, MN

    GULL LAKE CHAIN! Distinctive & contemporary sophistication are tailored in this brand new 4BR-3BA custom built home on Love Lake. Located in the Heart of the Lakes Area and situated on 100ft of natural shoreline with level elevation and absolute STUNNING sunsets / flag stone walkway / HUGE wall of lakeside windows / gorgeous maple hardwood flooring / stylish modern lighting and decor / open

    James Christensen Kurilla Real Estate LTD

    Section Image
  • 22277 E Lake Hubert Dr, Brainerd, MN 56401

    $1,695,000

    • 3 Beds
    • 4.5 Baths
    • 3,068 Sq Ft
    • 22277 E Lake Hubert Dr
    • Brainerd, MN

    Lake living at its finest here with a picturesque setting on the water's edge of Hubert Lake! This one-of-a-kind custom-built home with attention to detail throughout features a modern design and has an abundance of character and charm! From the moment you walk in you will be greeted with amazing lake views and a wall of 8' tall sliding doors that lead to the lakeside deck! Gourmet kitchen with

    Brad Wadsten Edina Realty, Inc.

    Section Image
  • xxx Ojibwa Rd, Brainerd, MN 56401

    $2,046,000

    • 5 Beds
    • 4 Baths
    • 4,730 Sq Ft
    • xxx Ojibwa Rd
    • Brainerd, MN

    Gorgeous new construction home on the scenic Round Lake, part of the desirable Gull Lake Chain! Enjoy breathtaking sunsets from your professionally landscaped backyard! With a total of 4,910 square feet, you'll have plenty of room to entertain friends and family. Inside the main home, floor-to-ceiling windows provide stunning views of the lake for you to enjoy daily. The home also includes a gas

    Chad Piepho Counselor Realty Brainerd Lakes

    Section Image
  • 23001 Clearwater Point Rd NE, Brainerd, MN 56401

    $2,500,000

    • 13 Beds
    • 9 Baths
    • 7,683 Sq Ft
    • 23001 Clearwater Point Rd NE
    • Brainerd, MN

    Introducing Cobble Crest, an unparalleled family estate nestled on 25 acres of pristine land on the crystal clear waters of Clearwater Lake. This first ever offering for sale includes 1,651 feet between two separate sections of peninsula lakeshore. The developed 6 acres of south-facing lakeshore (974 feet of shore) includes 3 year-round single family homes (“Court House” 5 bed, 4 bath approx.

    Rose Lorsung Recreate Real Estate LLC

    Section Image

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 Type Sale Price Title Company
Warranty Deed $2,142,500 Elite Title
Quit Claim Deed $3,000 None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,606,875 New Conventional
Previous Owner $300,000 New Conventional
Previous Owner $50,000 Credit Line Revolving
Previous Owner $228,150 New Conventional
Previous Owner $227,785 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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
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 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 $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

  • Section Image
  • Section Image
See All Agents

Map

Source: NorthstarMLS

MLS Number: 6706341

NorthstarMLS

APN: 87-020-3116