Welcome to 478 Main Street Oneida. This three unit brick beauty located in the lovely historic district of Oneida is a grand home on an oversized and well manicured corner lot complete with two story carriage barn with tons of storage space. The bottom unit is a grand two bedroom apartment with tons of original character and sprawling amounts of space and tall ceilings. This apartment is the entire first floor. Perfect for a luxury apartment or owner occupant. The other two second floor units are both one bedroom apartments with lovely hardwood floors. All on separate utilities and currently all occupied with long term tenants in month to month agreements. Plenty of parking and a full basement that can provide laundry.
Multi-familyProperty Type
1900Year Built
0.45 acresLot Size
$81Est. Price/Sq.Ft.
1 car garageParking
Listing by Ashley Howard• Hunt Real Estate ERA
•315-363-5533 (broker)
•charlie.hunt@huntrealestate.com (broker)
Bought with Abigail Nell• Hunt Real Estate ERA
•315-363-5533 (broker)
•charlie.hunt@huntrealestate.com (broker)
Source:CNYIS #S1403716
Redfin Estimate
$240,367
$5,367 since sold in November 2024$3,000 since August
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 12.3% higher than the average sale price ($214K) of 6 comparable homes.
Listing by Coldwell Banker Faith Properties, (315) 735-2222
See all
Provided by Redfin
Sale history for 478 Main St
Date
Event
Price
Public Records
Nov 12, 2024
Sold
$235,000
$79/sq ft
CNYIS #S1403716
Jul 30, 2022
Sold
$185,000
$62/sq ft
May 10, 2022
Pending
—
May 5, 2022
Listed
$189,000
$63/sq ft
Welcome to 478 Main Street Oneida. This three unit brick beauty located in the lovely historic district of Oneida is a grand home on an oversized and well manicured corner lot complete with two story carriage barn with tons of storage space. The bottom unit is a grand two bedroom apartment with tons of original character and sprawling amounts of space and tall ceilings. This apartment is the entire first floor. Perfect for a luxury apartment or owner occupant. The other two second floor units are both one bedroom apartments with lovely hardwood floors. All on separate utilities and currently all occupied with long term tenants in month to month agreements. Plenty of parking and a full basement that can provide laundry.
Public Records
May 6, 2005
Sold
$94,000
$32/sq ft
Public Records
Jul 10, 2002
Sold
$127,000
$43/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,950 (−1.3%)
$18,800 + $123,000
$141,800
2024
$7,044 (+4.1%)
$18,800 + $123,000
$141,800
2023
$6,769 (+1.3%)
$18,800 + $123,000
$141,800
2022
$6,685 (+3.0%)
$18,800 + $123,000
$141,800
2021
$6,488 (+0.5%)
$18,800 + $123,000
$141,800
2020
$6,456 (−3.1%)
$18,800 + $123,000
$141,800
2019
$6,662 (+7.6%)
$18,800 + $123,000
$141,800
2018
$6,192 (−7.6%)
$18,800 + $123,000
$141,800
2017
$6,700 (+27.2%)
$18,800 + $123,000
$141,800
2016
$5,269 (−10.5%)
$18,800 + $123,000
$141,800
2015
$5,888 (+1.5%)
$18,800 + $123,000
$141,800
2014
$5,800
$18,800 + $123,000
$141,800
Tax history for 478 Main St
Year
Property tax
Land + Additions
Assessment*
2025
$6,950 (−1.3%)
$18,800 + $123,000
$141,800
2024
$7,044 (+4.1%)
$18,800 + $123,000
$141,800
2023
$6,769 (+1.3%)
$18,800 + $123,000
$141,800
2022
$6,685 (+3.0%)
$18,800 + $123,000
$141,800
2021
$6,488 (+0.5%)
$18,800 + $123,000
$141,800
2020
$6,456 (−3.1%)
$18,800 + $123,000
$141,800
2019
$6,662 (+7.6%)
$18,800 + $123,000
$141,800
2018
$6,192 (−7.6%)
$18,800 + $123,000
$141,800
2017
$6,700 (+27.2%)
$18,800 + $123,000
$141,800
2016
$5,269 (−10.5%)
$18,800 + $123,000
$141,800
2015
$5,888 (+1.5%)
$18,800 + $123,000
$141,800
2014
$5,800
$18,800 + $123,000
$141,800
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Property details
Interior
Basement Information
Basement Type: Full
Bathroom Information
# of Full Baths: 3
Heating & Cooling
Heating Fuel Type: Oil
Heating Type: Hot Air
Exterior
Exterior Information
Physical Condition: Average
Building Style Type: Old
Exterior Wall: Brick
Property Information
Living Sq. Ft: 2,984
Ground Floor Sq. Ft: 1,594
# of Stories: 2
Lot Information
# of Buildings: 1
Land Sq. Ft: 19,602
Legal Lot Number: 12
Legal Block Number: 1
Municipality Name: ONEIDA
Acres: 0.45
Depth Footage: 197
Front Footage: 118
Zoning Code: R2
State Use Description: 3 FAMILY RESID
Utility Information
Sewer Type: Commercial
Water Service Type: Commercial
Financial
Assessor Information
Assessment Year: 2025
Public facts
Beds: 4
Baths: 3.0
Sq. Ft.: 2,984
Stories: 2.0
Lot Size: 0.45 acres
Style: Multi-Family (2-4 Unit)
Year Built: 1900
Year Renovated: —
County: Madison County
APN: 251201A03804100010120000000
Home facts updated by county records on Aug 19, 2026
Around this home
Schools
W F Prior Elementary School
Public PreK-2 • Assigned • 0.4mi
Otto L Shortell Middle School
Public 6-8 • Assigned • 3.1mi
2/10
Oneida Senior High School
Public 9-12 • Assigned • 0.5mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 94° expected this year, 17 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
2/10 Air Factor
0 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Oneida, NY • 13421
Average low and high temperatures (°F)
28
17
31
16
49
30
59
38
65
48
78
58
84
64
80
56
75
53
62
41
47
33
35
20
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.6 hours in
June and 2.4 hours in December, placing it below the
U.S. average for solar exposure.
8.6 hrs
2.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$229,000 – $277,000
Sell confidently with a local market expert in Oneida. 3 minutes to get started.