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 823 Skylane Terrace, Union, NY 13760
CLOSED
$100,000
$889,000

823 Skylane TerraceUnion, NY, 13760

5 Beds5 Baths6,488 SqFt0.5601 Acres
Welcome to this truly unique home, w nearly an acre nestled on a cul-de-sac in the hills of Endwell NY. From the moment you enter the foyer, you’ll be captivated by soaring ceilings, walls of windows, & natural light that seamlessly brings the outdoors in. Designed with both elegance and comfort in mind, the main-level primary suite is a private retreat featuring two separate full bathrooms & a giant walk in closer. The cozy family room opens to both a serene screened porch & a spacious open deck — perfect for enjoying the tranquil setting or entertaining guests. The expansive lower level includes a wine cellar w/ cold storage, a kitchenette, & ample space for hosting gatherings or enjoying quiet evenings at home. An oversized three-car garage & a private driveway has room for extra parking or outdoor activities. This property is not only a home — it's an exceptional lifestyle opportunity. Don’t miss the chance to own this architecturally stunning & entertainment-ready gem.

Est. Monthly

$4,214/MO

$889,000
$100,000

823 Skylane Terrace, Union, NY

5 Beds5 Baths6,488 SqFt0.5601 Acres

Welcome to this truly unique home, w nearly an acre nestled on a cul-de-sac in the hills of Endwell NY. From the moment you enter the foyer, you’ll be captivated by soaring ceilings, walls of windows, & natural light that seamlessly brings the outdoors in. Designed with both elegance and comfort in mind, the main-level primary suite is a private retreat featuring two separate full bathrooms & a giant walk in closer. The cozy family room opens to both a serene screened porch & a spacious open deck — perfect for enjoying the tranquil setting or entertaining guests. The expansive lower level includes a wine cellar w/ cold storage, a kitchenette, & ample space for hosting gatherings or enjoying quiet evenings at home. An oversized three-car garage & a private driveway has room for extra parking or outdoor activities. This property is not only a home — it's an exceptional lifestyle opportunity. Don’t miss the chance to own this architecturally stunning & entertainment-ready gem.

StatusClosed
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1987
Total Rooms22 rooms
Days on Market160 days

Est. Monthly Payment

$4,213.84

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

823 Skylane Terrace

Union, NY 13760 • Broome
5
Beds
5
Baths
6,488
SqFt
0.5601
Acres
Status
Closed
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
198739 years ago
Total Rooms
22 rooms
Days on Market
160 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $18,967
Property History
  • Closed
    Dec 16, 2025 • NYSAMLS • R1616326
    $889,000
  • Price reduced
    Jul 31, 2025 • NYSAMLS • R1616326
    $989,000 → $889,000
  • Listed for sale
    Jul 9, 2025 • NYSAMLS • R1616326
    $989,000
Mortgage Calculator
Estimated monthly payment for this property
$4,213.84
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#
    R1616326
  • Listing Office
    Warren Real Estate
  • Last Updated
    52 days ago

Appliances

  • Appliances
    • Built In Range
    • Built In Oven
    • Double Oven
    • Dryer
    • Dishwasher
    • Gas Cooktop
    • Gas Water Heater
    • Refrigerator
    • Washer

Climate & Systems

  • Heating
    • Gas
    • Forced Air

Interior Features

  • Flooring
    • Carpet
    • Hardwood
    • Tile
    • Varies
  • Doors
    Sliding Doors
  • Basement
    Full
  • Windows
    Skylights
  • Interior Features
    • Breakfast Bar
    • Cedar Closets
    • Cathedral Ceilings
    • Den
    • Entrance Foyer
    • Separate Formal Living Room
    • Guest Accommodations
    • Granite Counters
    • Home Office
    • Jetted Tub
    • Kitchen Island
    • Pantry
    • Sliding Glass Doors
    • Storage
    • Skylights
    • Bath In Primary Bedroom
    • Main Level Primary
    • Primary Suite
    • Workshop

Parking

  • Parking Features
    • Attached
    • Garage
    • Driveway
    • Garage Door Opener
  • Garage Spaces
    3

Lot & Grounds

  • Lot Size
    0.5601 acres
  • Lot Features
    • Cul De Sac
    • Irregular Lot
  • Fencing
    Full
  • Patio & Porch
    • Deck
    • Porch
    • Screened
  • Exterior Features
    • Blacktop Driveway
    • Deck
    • Fully Fenced
    • Porch
    • Private Yard
    • See Remarks

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    Contemporary

Structure

  • Construction
    • Attic Crawl Hatchways Insulated
    • Cedar
  • Roof
    • Architectural
    • Shingle
  • Foundation
    Poured

Condition

  • Year Built
    1987
  • Condition
    Resale
  • Days on Market
    160 days
  • Water
    Connected
  • Sewer
    Connected
  • Utilities
    • Cable Available
    • Electricity Connected
    • 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 →
  • 5136 Thompson Road, Clarence, NY 14031ACTIVE$802,500

    5136 Thompson Road, Clarence, NY 14031

    3 Beds2.5 Baths2,530 SqFt0.53 Acres

    LISTING BY FORBES CAPRETTO HOMES

  • 7 Stone Creek Drive, East Greenbush, NY 12061ACTIVE$806,900

    7 Stone Creek Drive, East Greenbush, NY 12061

    3 Beds3.5 Baths2,568 SqFt0.61 Acres

    LISTING BY AMEDORE HOMES

  • 39 Partridge Walk, Lancaster, NY 14086ACTIVE$809,900OPEN 6/20

    39 Partridge Walk, Lancaster, NY 14086

    5 Beds3.5 Baths3,165 SqFt0.41 Acres

    LISTING BY HOWARD HANNA WNY INC.

  • 103 Sand Hill Road, Greenfield, NY 12833ACTIVE$811,732

    103 Sand Hill Road, Greenfield, NY 12833

    3 Beds2.5 Baths2,023 SqFt2.95 Acres

    LISTING BY CARTIER REAL ESTATE GROUP LLC

  • 5 Mapleton Court, Clifton Park, NY 12065ACTIVE$814,695

    5 Mapleton Court, Clifton Park, NY 12065

    3 Beds2.5 Baths2,686 SqFt2.22 Acres

    LISTING BY STERLING REAL ESTATE GROUP

  • 546 Castle Street, Geneva City, NY 14456ACTIVE$814,900

    546 Castle Street, Geneva City, NY 14456

    7 Beds3.5 Baths4,779 SqFt2 Acres

    LISTING BY CENTURY 21 STEVE DAVOLI RE

  • 37 East Street, Skaneateles, NY 13152ACTIVE$815,000

    37 East Street, Skaneateles, NY 13152

    4 Beds2.5 Baths2,676 SqFt0.82 Acres

    LISTING BY HOWARD HANNA REAL ESTATE

  • 3941 Wheatfield Crossing, Wheatfield, NY 14120ACTIVE$815,900

    3941 Wheatfield Crossing, Wheatfield, NY 14120

    4 Beds2.5 Baths3,164 SqFt0.75 Acres

    LISTING BY FORBES CAPRETTO HOMES

  • L10 Corona Court, Ballston, NY 12019ACTIVE$815,900

    L10 Corona Court, Ballston, NY 12019

    4 Beds2.5 Baths2,814 SqFt0.5 Acres

    LISTING BY SIGNATURE ONE REALTY GROUP LLC

  • 41 River Oak Lane, Amherst, NY 14051ACTIVE$818,900

    41 River Oak Lane, Amherst, NY 14051

    2 Beds2 Baths2,238 SqFt0.1982 Acres

    LISTING BY NATALE BUILDING CORP