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 23 Sycamore Drive, Queensbury, NY 12804
OPEN 6/20
ACTIVE
0
$579,900

23 Sycamore DriveQueensbury, NY, 12804

4 Beds2.5 Baths3,100 SqFt0.51 Acres
Wow! This beautiful, spacious 4-bedroom Colonial is a rare find. From the moment you step inside, you'll appreciate the generous living space and thoughtful layout. The impressive great room provides the perfect gathering place for family and friends, while the convenient laundry room features a sink and ample cabinetry, offering the potential to serve as a second kitchen or prep area. The home also features a large walk-in pantry, a formal dining room ideal for entertaining, and spacious bedrooms that provide comfort and flexibility for the whole family. The finished basement offers additional living space and makes a perfect game room, media room, or recreation area. Step outside to enjoy the huge deck overlooking a private, fenced-in backyard--an ideal setting for outdoor dining, relaxing, and entertaining. With its combination of charm, functionality, and abundant space both inside and out, this exceptional property is one you won't want to miss. The front steps are new and the railings will be put on when cement cures. the railings are in garage. there is a gate for front of fence in shed, seller wanted it to be open.
1 / 75

Est. Monthly

$2,749/MO

$579,900

23 Sycamore Drive, Queensbury, NY

4 Beds2.5 Baths3,100 SqFt0.51 Acres

Wow! This beautiful, spacious 4-bedroom Colonial is a rare find. From the moment you step inside, you'll appreciate the generous living space and thoughtful layout. The impressive great room provides the perfect gathering place for family and friends, while the convenient laundry room features a sink and ample cabinetry, offering the potential to serve as a second kitchen or prep area. The home also features a large walk-in pantry, a formal dining room ideal for entertaining, and spacious bedrooms that provide comfort and flexibility for the whole family. The finished basement offers additional living space and makes a perfect game room, media room, or recreation area. Step outside to enjoy the huge deck overlooking a private, fenced-in backyard--an ideal setting for outdoor dining, relaxing, and entertaining. With its combination of charm, functionality, and abundant space both inside and out, this exceptional property is one you won't want to miss. The front steps are new and the railings will be put on when cement cures. the railings are in garage. there is a gate for front of fence in shed, seller wanted it to be open.

Upcoming
June 20, 2026

1:00 PM - 3:00 PM

Add to Calendar
StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1985
Total Rooms11 rooms

Est. Monthly Payment

$2,748.71

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

23 Sycamore Drive

Queensbury, NY 12804 • Warren
4
Beds
2.5
Baths
3,100
SqFt
0.51
Acres

Open House

Upcoming Open House

June 20, 2026

1:00 PM - 3:00 PM
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
198541 years ago
Total Rooms
11 rooms
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $7,688
  • School Taxes
    $4,663
  • Town/County Taxes
    $2,022
Property History
  • Listed for sale
    Jun 17, 2026 • GLOBAL MLS • 202619878
    $579,900
Mortgage Calculator
Estimated monthly payment for this property
$2,748.71
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
    Global MLS
  • MLS#
    202619878
  • Listing Office
    Coldwell Banker Prime Properties
  • Last Updated
    6 hours ago

Kitchen & Laundry

  • Kitchen
    Gourmet Kitchen

Appliances

  • Appliances
    • Range
    • Refrigerator
    • Washer
    • Dishwasher
    • Dryer
    • Microwave

Climate & Systems

  • Heating
    • Natural Gas
    • Baseboard
  • Fireplace
    • Electric
    • Other
    • Dining Room

Interior Features

  • Flooring
    • Ceramic Tile
    • Hardwood
    • Vinyl
  • Doors
    • Atrium Door
    • Sliding Doors
  • Basement
    • Finished
    • Heated

Parking

  • Parking Features
    • Garage Door Opener
    • Paved
    • Garage
  • Parking Spaces
    6
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    0.51 acres
  • Lot Features
    • Landscaped
    • Level
    • Sprinklers In Front
    • Sprinklers In Rear
  • Fencing
    • Fenced
    • Back Yard
  • Patio & Porch
    • Deck
    • Front Porch
  • Exterior Features
    Drive-Paved

Type

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

Structure

  • Construction
    Clapboard
  • Roof
    Composition

Condition

  • Year Built
    1985
  • Condition
    Updated or Remodeled
  • Water
    Public
  • Sewer
    Septic Tank
  • Electric
    • 200+ Amp Service
    • Circuit Breakers
  • Utilities
    • Cable Available
    • Cable 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 →
  • 27 Kirby Road, Saratoga Springs, NY 12866ACTIVE$524,555

    27 Kirby Road, Saratoga Springs, NY 12866

    3 Beds2 Baths1,959 SqFt0.29 Acres

    LISTING BY WARREN PRIME PROPERTIES

  • 4947 Route 32, Catskill, NY 12414ACTIVE$524,777

    4947 Route 32, Catskill, NY 12414

    3 Beds3 Baths3,240 SqFt1.3 Acres

    LISTING BY RE/MAX CAPITAL

  • 1033 Old Schaghticoke Road, Schaghticoke, NY 12154ACTIVE$524,900

    1033 Old Schaghticoke Road, Schaghticoke, NY 12154

    5 Beds2.5 Baths2,416 SqFt7.36 Acres

    LISTING BY NEWCOMB REALTY GROUP LLC

  • 105 Northington Drive, Amherst, NY 14051ACTIVE$524,900OPEN 6/20

    105 Northington Drive, Amherst, NY 14051

    4 Beds2.5 Baths2,724 SqFt0.355 Acres

    LISTING BY KELLER WILLIAMS REALTY WNY

  • 140 North Avenue, Parma, NY 14468ACTIVE$524,900

    140 North Avenue, Parma, NY 14468

    4 Beds3 Baths1,958 SqFt5.24 Acres

    LISTING BY HOWARD HANNA

  • 364 Island Cottage Road, Greece, NY 14612ACTIVE$524,900

    364 Island Cottage Road, Greece, NY 14612

    4 Beds2 Baths2,140 SqFt11.55 Acres

    LISTING BY KELLER WILLIAMS REALTY GREATER ROCHESTER

  • 5 White Pine Lane, Wilton, NY 12866ACTIVE$524,900

    5 White Pine Lane, Wilton, NY 12866

    3 Beds2 Baths1,428 SqFt0.24 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 53 William Kidder Road, Lancaster, NY 14086ACTIVE$524,900

    53 William Kidder Road, Lancaster, NY 14086

    3 Beds2 Baths1,624 SqFt8.33 Acres

    LISTING BY KELLER WILLIAMS REALTY LANCASTER

  • 749 State Route 9N, Ticonderoga, NY 12883ACTIVE$524,900

    749 State Route 9N, Ticonderoga, NY 12883

    3 Beds2 Baths1,300 SqFt34.3 Acres

    LISTING BY CENTURY 21 - ADIRONDACKS

  • 161 Meade Road, Summit, NY 12036ACTIVE$524,900

    161 Meade Road, Summit, NY 12036

    3 Beds4 Baths1,872 SqFt15.28 Acres

    LISTING BY COUNTRY BOY REALTY