Search
Mixed-Use Property with Lodging

4966 State Route 414, Burdett, NY 14818

For Sale
$7,750,000

A commercial-zoned destination combines three guest accommodations with a gallery, tasting room, warehouse, barn, and equestrian facilities.

Property Size10,682 SF
Lot Size116.00 Acres
Price / SF$725.52
Days on Market96

Property Features for 4966 State Route 414

General Information

Standard status Active
Size 10,682 SF
Total Parking Spaces 50
Lot size 116.00 Acres
Property subtype Commercial
Zoning Comm, Commercial

Additional Details

Road Access Yes

Taxes and HOA fees

Annual Taxes $13,419

Amenities

art gallery
tasting room
commercial kitchen

Building Details

Building Size 10,682 SF
Year Built 1823
Buildings 3
Stories 2
Listing Agency: Core Agency RE INC
Listed By: Michael J Casserino · License NY #10311209677
Source: Franzese-realestate
Added: Aug 11 Changed: Nov 13 Last Checked: Nov 13 at 3:51AM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Core Agency RE INC

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

This 116-acre mixed-use property includes three vacation accommodations: a seven-bedroom farmhouse, a six-bedroom residence with an outdoor kitchen, and a two-story treehouse with a wraparound porch. Additional improvements include an art gallery, warehouse space, a tasting room with a commercial kitchen, and a barn. Equestrian features include walk-out stalls and pastures; the grounds also contain a fishing pond, open fields, and more than 30 acres of wooded land.

The property fronts State Route 414 and offers views of Seneca Lake. Its commercial zoning and mix of lodging, hospitality, gallery, and agricultural features support a range of potential operating concepts. The property size is listed as 10,682 square feet.

Key Highlights

  • 116 acres along State Route 414 with views of Seneca Lake
  • Three vacation accommodations, including a 7‑bedroom farmhouse, 6‑bedroom residence, and two‑story treehouse
  • Tasting room with commercial kitchen, art gallery, warehouse space, and barn

Property Analytics

Who owns this building? See the owner, sales and loan history
Open Analytics

Current Use

Short term rental ...

Suggested Use

Top Pick Wine and Liquor Store Real Estate Agency Restaurant Hotel & Motel Bed & Breakfast Bar & Pub

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Yes
Paved road access

Location Intelligence

Trade Area within ½ mile

20
Businesses Nearby

Demographics for 14818, NY

1,830
Population
1,171
Households
1.6
Avg Household Size
49
Median Age
36%
College-Educated
95%
High-School Grad
38.5 sq mi
ZIP Area
48
Density / Sq Mi
$84,946
Median Household Income
$48,021
Median Earnings
$1,435
Median Rent
$197,100
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Vacancy Rate% for Multifamily in Northeast region

4% 2022
4.6% 2023
5.3% 2024
5.6% 2025

Frequently Asked Questions

What type of property is this?
Mixed-use property - A commercial-zoned destination combines three guest accommodations with a gallery, tasting room, warehouse, barn, and equestrian facilities.
Where is this mixed-use property located?
The property is located at 4966 State Route 414 Burdett, NY.
What is the asking price?
The asking price for this property is $7,750,000.
What are key features of this property?
This property features: 116 acres along State Route 414 with views of Seneca Lake; Three vacation accommodations, including a 7‑bedroom farmhouse, 6‑bedroom residence, and two‑story treehouse; Tasting room with commercial kitchen, art gallery, warehouse space, and barn
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message
Why this one?
Why hide this one?