NOT LISTED FOR SALE

5871 Bartel Cir Brewerton, NY 13029

Estimated Value: $933,000 - $1,731,707

4 Beds
4.5 Baths
5,843 Sq Ft
$206/Sq Ft Est. Value

Last Sold January 11, 2019

Last sale price $950,000 $163 Per Sq Ft

Est. 26% increase in value since last sale

Current estimated payment $8,782/month

8 Days on Market

Highlights

  • 268 Feet of Waterfront
  • Built-In Refrigerator
  • Colonial Architecture
  • Property is near a lake
  • 2.2 Acre Lot
  • Deck

About This Home

As of January 2019

This luxury custom built home makes a statement from the moment you first arrive. This estate is situated on over 2 acres, is beautifully landscaped, & has 268' of lake frontage on the south shore of Oneida Lake. The interior is warm & inviting w/many high end touches. As you enter the grand foyer you'll experience elegant marble flooring leading to a stunning 2-story living room w/a gas fireplace, 20'-high coffered ceiling, recessed lighting, multi-tier paned windows, & French doors leading to a patio & 2 tier deck overlooking a breathtaking view of the 20.51 mile lake stretching to the east. Exceeding all expectations from the gourmet kitchen, underground sprinkler system, Smart Home for heat, security & lights, central vacuum system, heated epoxy garage floor, & fully finished basement.

Last Agent to Sell the Property

Ann Russo

Listing by Hunt Real Estate ERA License #10401208827 Listed on: 11/05/2018

Hunt Real Estate ERA

Last Buyer's Agent

Nicole Bronner

Listing by Scripa Group, LLC License #10401247718

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $28,234

Year Built

  • Built in 1992

Lot Details

  • 2.2 Acre Lot
  • Lot Dimensions are 275 x 273
  • 268 Feet of Waterfront
  • Sprinkler System
  • Private Yard

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Partial Copper Plumbing
  • Cedar

Interior Spaces

  • 5,843 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Woodwork
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • 3 Fireplaces
  • Gas Fireplace
  • ENERGY STAR Qualified Windows
  • Entrance Foyer
  • Great Room
  • Family Room
  • Formal Dining Room
  • Home Office
  • Bonus Room
  • Heated Sun or Florida Room
  • Water Views
  • Security System Owned
  • Laundry on upper level

Kitchen

  • Eat-In Kitchen
  • Convection Oven
  • Gas Cooktop
  • Free-Standing Range
  • Range Hood
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Wall to Wall Carpet
  • Marble
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Cedar Closet
  • In-Law or Guest Suite
  • Whirlpool Bathtub

Finished Basement

  • Basement Fills Entire Space Under The House
  • Laundry in Basement
  • Crawl Space

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Circular Driveway

Eco-Friendly Details

  • Energy-Efficient Lighting
  • ENERGY STAR Qualified Equipment for Heating

Outdoor Features

  • Property is near a lake
  • Deck
  • Patio
  • Porch

Schools

  • Brewerton Elementary School
  • Central Square Middle School
  • Paul V Moore High School

Utilities

  • Forced Air Cooling System
  • ENERGY STAR Qualified Air Conditioning
  • Heating System Uses Gas
  • Whole House Permanent Generator
  • Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 1
  • Assessor Parcel Number 312289-110-000-0004-001-001-0000

Home Details

Home Type

Single Family

Est. Annual Taxes

$28,234

Year Built

Built in 1992

Lot Details

0

Listing Details

  • NY Swis Code: Cicero-312289
  • Total Assessed Value: 890000
  • Foundation Description: Block
  • Listing Type: Exclusive Right To Sell
  • Lot Dimension Depth: 275
  • Lot Dimension Front: 273
  • Lot Information: Water View
  • Lot Number: 1
  • Nearest Cross Street: Bartel Road
  • Number of Stories: 2.0000
  • Property Type: Single Family Residential
  • Ratio Close Price By Acres: 431818.18
  • Ratio Close Price By Sq Ft: 162.59
  • Ratio List Price By Acres: 534090.91
  • Ratio List Price By Sq Ft: 201.10
  • Regional Board Code: Syracuse
  • School Tax: 16842
  • Styles of Residence: Colonial
  • Sub Board Code: Syracuse
  • Type of Sale: Normal
  • Year Built Description: Existing
  • Age of Building: 30
  • Year Built: 1992
  • Directions To Property: From Route 81 take the Brewerton Exit and take a left on Bartel Road. Continue on Bartel Road until you get to the bend, then vier left on Bartel Circle. The Estate is on the left.
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 1992

Interior Features

  • Full Bathrooms: 4
  • Additional Interior Features: Cathedral Ceiling, Cedar Closets, Ceiling Fan, Central Vacuum System, Circuit Breakers - Some, Copper Plumbing - Some, Natural Woodwork - some, Security System - Owned, Skylight, Whirlpool Tub
  • Additional Rooms: 1st Floor Bedroom, Basement / Rec Room, Bonus Room, Family Room, Florida/Sun Room- Heated, Foyer/Entry Hall, Great Room, Guest Suite, Laundry-2nd Floor, Laundry-Basement, Master Bedroom Bath, Office, Porch - Open, Possible Additional Bedroom
  • Attic Description: Crawl Space
  • Basement Description: Finished, Full
  • Floor Description: Ceramic-Some, Hardwood-Some, Marble-Some, Tile-Some, Wall To Wall Carpet-Some
  • Kitchen Appliances Included: Convection, Cooktop - Gas, Dishwasher, Disposal, Microwave, Oven/Range Freestanding, Range Hood-Exhaust Fan, Refrigerator-Built In
  • Kitchen Dining Description: Eat-In, Formal Dining Room, Granite Counter, Island, Pantry
  • Number of Bedrooms 1st Floor: 1
  • Number of Bedrooms 2nd Floor: 3
  • Number of Fireplaces Gas: 3
  • Number of Fireplaces Total Calculated: 3
  • Number of 1st Floor Full Bathrooms: 1
  • Number of 2nd Floor Full Bathrooms: 2
  • Number of Full Bathrooms in the Basement: 1
  • Number of 1st Floor Half Bathrooms: 1
  • Number of Rooms: 14
  • Half Bathrooms: 1
  • Total Bathrooms: 4.10
  • Total Bedrooms: 4
  • Total Sq Ft: 5843

Exterior Features

  • Construction: Brick, Cedar
  • Waterfront Name: Oneida Lake
  • Additional Exterior Features: Cable TV Available, Deck, Dock- see Remarks, Garage Door Opener, High Speed Internet, Lawn Sprinkler System, Patio, Private Yard - see Remarks
  • Number of Acres: 2.2000
  • Waterfront Description: Lake
  • Waterfront Frontage: 268

Garage/Parking

  • Driveway Description: Blacktop, Circular, Double Wide
  • Garage Description: Attached
  • Number of Garage Spaces: 3.0000

Utilities

  • Emergency Backup Systems: Generator - Permanent
  • Heating Fuel Description: Gas
  • Hvac Type: AC-Central, Forced Air
  • Sewer Description: Sewer Connected
  • Water Heater Fuel: Gas

Green Features

  • Energystar: Appliances, Cooling, Heating, Lighting, Windows

Lot Info

  • Parcel Number: 312289-110-000-0004-001-001-0000

Tax Info

  • Total Taxes: 28234

MLS Schools

  • Elementary School Name: Brewerton Elementary
  • High School Name: Paul V Moore High
  • Middle School Name: Central Square Middle
  • School District Name: Central Square

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 25, 2025
Sold by
Loomis Derek and Loomis Callie
Bought by
Derek B Loomis Ret and Loomis
Current Estimated Value
$1,200,902

Purchase Details

Listed on
Nov 5, 2018
Closed on
Jan 11, 2019
Sold by
Harris Blair and Harris Valerie J
Bought by
Loomis Derek and Loomis Callie
Seller's Agent
Ann Russo
Hunt Real Estate ERA
Buyer's Agent
Nicole Bronner
Scripa Group, LLC
List Price
$1,175,000
Sold Price
$950,000
Premium/Discount to List
-$225,000
-19.15%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.41%
Original Mortgage
$700,000
Interest Rate
4.6%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Listed on
Mar 13, 2013
Closed on
Aug 26, 2013
Sold by
Burdick Roger
Bought by
Harris Blair
Seller's Agent
George Tucci
Century 21 North East
Buyer's Agent
Jolene Rightmyer-Macolini
Berkshire Hathaway HomeServices Heritage Realty
List Price
$875,000
Sold Price
$865,000
Premium/Discount to List
-$10,000
-1.14%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.76%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Derek B Loomis Ret -- --
Loomis Derek -- --
Loomis Derek -- --
Harris Blair $865,000 Randall Marcus
Harris Blair $865,000 Randall Marcus
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Loomis Derek $700,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/11/2019 01/11/19 Sold $950,000 -19.1% $163 / Sq Ft
11/13/2018 11/13/18 Pending -- -- --
11/05/2018 11/05/18 For Sale $1,175,000 +35.8% $201 / Sq Ft
08/29/2013 08/29/13 Sold $865,000 -1.1% $162 / Sq Ft View Prior Sale
07/03/2013 07/03/13 Pending -- -- --
03/13/2013 03/13/13 For Sale $875,000 -- $164 / Sq Ft
Source: Central New York Information Services

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 $30,111 $920,000 $546,000 $374,000
2023 $30,122 $910,000 $546,000 $364,000
2022 $29,075 $910,000 $546,000 $364,000
2021 $28,811 $910,000 $353,000 $557,000
2020 $28,606 $890,000 $353,000 $537,000
2019 $0 $890,000 $353,000 $537,000
2015 -- $890,000 $353,000 $537,000
2014 -- $890,000 $353,000 $537,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Central New York Information Services

MLS Number: S1158338

Central New York Information Services

APN: 312289-110-000-0004-001-001-0000