HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 1 28th Avenue, Vienna, NY 13157
ACTIVE
0
$799,000

1 28th AvenueVienna, NY, 13157

4 Beds2.5 Baths2,082 SqFt0.14 Acres
Some homes are simply owned, Others become part of a bigger story- Welcome to one of Sylvan Beach’s most extraordinary waterfront offerings—a rare opportunity to own 100 ft of privately owned frontage on Oneida Lake, 1 of 7 within the Village. From the moment you arrive, there is a feeling that life moves differently here. Sunrise coffee overlooking the water. Summer afternoons spent boating and swimming. Long dinners that stretch into sunset. Quiet winter mornings wrapped in warmth and lake views. This is the kind of home that becomes the destination—the place everyone wants to gather. Thoughtfully maintained and beautifully improved, the home offers 2,000+ square feet designed to feel both refined and effortlessly comfortable. With 4 bedrooms, 2.5 baths, and a desirable first-floor primary suite, the layout balances elegant entertaining with everyday ease. Inside, architectural details create warmth and character at every turn. Cathedral ceilings, 3 fireplaces, and thoughtfully connected living spaces bring in natural light while keeping the focus on the water and the experience of being here. At the center of the home, the kitchen features granite surfaces, breakfast seating, and seamless flow into gathering spaces designed for conversation, celebration, and quiet moments alike. The primary suite offers a private retreat, where the ensuite bath introduces a touch of unexpected luxury with radiant heated flooring. One of the home’s most treasured spaces is the heated sunroom—a year-round sanctuary for reading, hosting, morning coffee, or simply watching the changing light dance across the lake. Step outside and the lifestyle continues. Private waterfront access invites endless days on the Lake—whether launching the boat, enjoying a swim, entertaining, or taking in spectacular sunsets from your own shoreline. Modern comforts blend seamlessly into the home’s timeless lakefront character. Beautifully positioned, meticulously cared for, and impossible to replicate, this is more than a waterfront property. It is a place to celebrate life, create traditions, and write the next chapter surrounded by water, beauty, and unforgettable moments.
1 / 50

Est. Monthly

$3,787/MO

$799,000

1 28th Avenue, Vienna, NY

4 Beds2.5 Baths2,082 SqFt0.14 Acres

Some homes are simply owned, Others become part of a bigger story- Welcome to one of Sylvan Beach’s most extraordinary waterfront offerings—a rare opportunity to own 100 ft of privately owned frontage on Oneida Lake, 1 of 7 within the Village. From the moment you arrive, there is a feeling that life moves differently here. Sunrise coffee overlooking the water. Summer afternoons spent boating and swimming. Long dinners that stretch into sunset. Quiet winter mornings wrapped in warmth and lake views. This is the kind of home that becomes the destination—the place everyone wants to gather. Thoughtfully maintained and beautifully improved, the home offers 2,000+ square feet designed to feel both refined and effortlessly comfortable. With 4 bedrooms, 2.5 baths, and a desirable first-floor primary suite, the layout balances elegant entertaining with everyday ease. Inside, architectural details create warmth and character at every turn. Cathedral ceilings, 3 fireplaces, and thoughtfully connected living spaces bring in natural light while keeping the focus on the water and the experience of being here. At the center of the home, the kitchen features granite surfaces, breakfast seating, and seamless flow into gathering spaces designed for conversation, celebration, and quiet moments alike. The primary suite offers a private retreat, where the ensuite bath introduces a touch of unexpected luxury with radiant heated flooring. One of the home’s most treasured spaces is the heated sunroom—a year-round sanctuary for reading, hosting, morning coffee, or simply watching the changing light dance across the lake. Step outside and the lifestyle continues. Private waterfront access invites endless days on the Lake—whether launching the boat, enjoying a swim, entertaining, or taking in spectacular sunsets from your own shoreline. Modern comforts blend seamlessly into the home’s timeless lakefront character. Beautifully positioned, meticulously cared for, and impossible to replicate, this is more than a waterfront property. It is a place to celebrate life, create traditions, and write the next chapter surrounded by water, beauty, and unforgettable moments.

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1900
Total Rooms9 rooms
Days on Market1 day

Est. Monthly Payment

$3,787.24

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

1 28th Avenue

Vienna, NY 13157 • Oneida
4
Beds
2.5
Baths
2,082
SqFt
0.14
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
1900126 years ago
Total Rooms
9 rooms
Days on Market
1 day
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $8,752
Property History
  • Listed for sale
    Jun 4, 2026 • NYSAMLS • S1687941
    $799,000
Mortgage Calculator
Estimated monthly payment for this property
$3,787.24
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    NYSAMLS
  • MLS#
    S1687941
  • Listing Office
    Real Broker NY LLC
  • Last Updated
    4 hours ago

Appliances

  • Appliances
    • Dishwasher
    • Electric Oven
    • Electric Range
    • Microwave
    • Refrigerator
    • Tankless Water Heater

Climate & Systems

  • Heating
    • Propane
    • Forced Air
    • Radiant

Interior Features

  • Flooring
    • Ceramic Tile
    • Hardwood
    • Luxury Vinyl
    • Varies
  • Basement
    Crawl Space
  • Windows
    Skylights
  • Interior Features
    • Breakfast Bar
    • Ceiling Fans
    • Cathedral Ceilings
    • Dining Area
    • Dry Bar
    • Den
    • Separate Formal Dining Room
    • Entrance Foyer
    • Separate Formal Living Room
    • Granite Counters
    • Kitchen Family Room Combo
    • Pull Down Attic Stairs
    • Skylights
    • Bedroom On Main Level
    • Bath In Primary Bedroom
    • Main Level Primary
    • Primary Suite

Parking

  • Parking Features
    • Attached
    • Garage
    • Garage Door Opener
  • Garage Spaces
    1

Lot & Grounds

  • Lot Size
    0.14 acres
  • Lot Features
    • Cul De Sac
    • Irregular Lot
    • Residential Lot
  • Patio & Porch
    • Deck
    • Patio
  • Exterior Features
    • Deck
    • Enclosed Porch
    • Porch
    • Patio
    • Private Yard
    • Stamped Concrete Driveway
    • See Remarks
    • Propane Tank Owned

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    Two Story

Structure

  • Construction
    • Attic Crawl Hatchways Insulated
    • Spray Foam Insulation
    • Wood Siding
  • Roof
    Asphalt
  • Foundation
    Block

Condition

  • Year Built
    1900
  • Condition
    Resale
  • Days on Market
    1 day
  • Water
    Connected
  • Sewer
    Connected
  • Electric
    Circuit Breakers
  • Utilities
    • Cable Available
    • High Speed Internet Available
    • Sewer Connected
    • Water Connected

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 51 Hillcrest Road, Lansing, NY 14850ACTIVE$719,500

    51 Hillcrest Road, Lansing, NY 14850

    4 Beds3.5 Baths3,247 SqFt1.21 Acres

    LISTING BY HOWARD HANNA S TIER INC

  • 11 Brook Trout Circle, Milton, NY 12863ACTIVE$719,700

    11 Brook Trout Circle, Milton, NY 12863

    3 Beds2.5 Baths2,400 SqFt1.28 Acres

    LISTING BY KW PLATFORM

  • 237 Rachel Vincent, Buffalo, NY 14216ACTIVE$719,900

    237 Rachel Vincent, Buffalo, NY 14216

    3 Beds2.5 Baths2,078 SqFt0.0946 Acres

    LISTING BY REALTY ONE GROUP EMPOWER

  • Lot 6 Bishop Brook Cir. (The Reserve@Bishop Brook), Manlius, NY 13104ACTIVE$719,900

    Lot 6 Bishop Brook Cir. (The Reserve@Bishop Brook), Manlius, NY 13104

    3 Beds2.5 Baths2,269 SqFt0.23 Acres

    LISTING BY COLDWELL BANKER PRIME PROP,INC

  • 1C Mackenna Court, Ballston, NY 12019ACTIVE$719,900

    1C Mackenna Court, Ballston, NY 12019

    4 Beds2.5 Baths2,663 SqFt0.4 Acres

    LISTING BY EXP REALTY

  • 10 Balsam Court, Ballston, NY 12019ACTIVE$719,980OPEN 6/7

    10 Balsam Court, Ballston, NY 12019

    4 Beds2.5 Baths2,350 SqFt0.16 Acres

    LISTING BY TAILORED REAL ESTATE GROUP

  • 11 Balsam Court, Ballston, NY 12019ACTIVE$719,980

    11 Balsam Court, Ballston, NY 12019

    3 Beds2 Baths2,200 SqFt0.2 Acres

    LISTING BY TAILORED REAL ESTATE GROUP

  • 2440 Shadyside Road, Mina, NY 14736ACTIVE$720,000

    2440 Shadyside Road, Mina, NY 14736

    Unit • B5 Beds3 Baths2,237 SqFt0.3554 Acres

    LISTING BY HOWARD & ASSOCIATES RE-APP-AUCT

  • 50 West Street, Lake George, NY 12845ACTIVE$720,000

    50 West Street, Lake George, NY 12845

    3 Beds3 Baths2,398 SqFt0.17 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 30 Saddlebrook Boulevard, Ballston, NY 12019ACTIVE$721,900

    30 Saddlebrook Boulevard, Ballston, NY 12019

    3 Beds2.5 Baths2,707 SqFt0.77 Acres

    LISTING BY HOWARD HANNA CAPITAL INC