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 1174 Sapphire Drive, Union, NY 13760
IN ESCROW
0
$645,000

1174 Sapphire DriveUnion, NY, 13760

4 Beds3 Baths3,610 SqFt0.29 Acres
A pristine contemporary residence offering over 3,600 square feet of thoughtfully curated living space, where elevated design meets effortless comfort. Impeccably maintained and extensively upgraded, this exceptional home presents a truly turnkey opportunity with no detail overlooked. A dramatic two-story foyer sets the tone, leading to a beautifully appointed interior featuring a formal dining room and an extraordinary chef’s kitchen outfitted with high-end appliances, quartz countertops, and refined finishes throughout. Designed for both everyday living and elegant entertaining, the home flows seamlessly from room to room. The upper level reveals four spacious bedrooms, including an impressive primary suite complete with an expansive five-piece bath and a luxurious walk-in dressing room. A second-floor laundry adds everyday convenience. The finished walkout lower level offers a dreamy extension of living space - providing and additional, approximately 1,000 square feet - ideal for recreation, relaxation, or entertaining on a grand scale. Outdoors, the property continues to impress with brand-new Trex decking, a covered porch, patio, fire pit, and a fully equipped outdoor kitchen with granite countertops—perfect for hosting in every season. The indoor entertaining is enhanced by two gas fireplaces and a long list of meticulous upgrades inside and out, this home reflects a level of care and investment rarely found. Simply move in and enjoy—nothing left to improve.
1 / 50

Est. Monthly

$3,057/MO

$645,000

1174 Sapphire Drive, Union, NY

4 Beds3 Baths3,610 SqFt0.29 Acres

A pristine contemporary residence offering over 3,600 square feet of thoughtfully curated living space, where elevated design meets effortless comfort. Impeccably maintained and extensively upgraded, this exceptional home presents a truly turnkey opportunity with no detail overlooked. A dramatic two-story foyer sets the tone, leading to a beautifully appointed interior featuring a formal dining room and an extraordinary chef’s kitchen outfitted with high-end appliances, quartz countertops, and refined finishes throughout. Designed for both everyday living and elegant entertaining, the home flows seamlessly from room to room. The upper level reveals four spacious bedrooms, including an impressive primary suite complete with an expansive five-piece bath and a luxurious walk-in dressing room. A second-floor laundry adds everyday convenience. The finished walkout lower level offers a dreamy extension of living space - providing and additional, approximately 1,000 square feet - ideal for recreation, relaxation, or entertaining on a grand scale. Outdoors, the property continues to impress with brand-new Trex decking, a covered porch, patio, fire pit, and a fully equipped outdoor kitchen with granite countertops—perfect for hosting in every season. The indoor entertaining is enhanced by two gas fireplaces and a long list of meticulous upgrades inside and out, this home reflects a level of care and investment rarely found. Simply move in and enjoy—nothing left to improve.

StatusIn Escrow
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built2006
Total Rooms14 rooms
Days on Market34 days

Est. Monthly Payment

$3,057.28

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

1174 Sapphire Drive

Union, NY 13760 • Broome
4
Beds
3
Baths
3,610
SqFt
0.29
Acres
Status
In Escrow
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
200620 years ago
Total Rooms
14 rooms
Days on Market
34 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $17,628
Property History
  • Listed for sale
    Apr 28, 2026 • NYSAMLS • R1676962
    $645,000
Mortgage Calculator
Estimated monthly payment for this property
$3,057.28
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#
    R1676962
  • Listing Office
    Signature Properties
  • Last Updated
    29 days ago

Appliances

  • Appliances
    • Convection Oven
    • Dishwasher
    • Exhaust Fan
    • Disposal
    • Gas Oven
    • Gas Range
    • Gas Water Heater
    • Indoor Grill
    • Microwave
    • Refrigerator
    • Range Hood

Climate & Systems

  • Heating
    • Gas
    • Forced Air

Interior Features

  • Flooring
    • Carpet
    • Ceramic Tile
    • Hardwood
    • Luxury Vinyl
    • Varies
  • Doors
    Sliding Doors
  • Basement
    • Full
    • Finished
  • Windows
    Thermal Windows
  • Interior Features
    • Cathedral Ceilings
    • Separate Formal Dining Room
    • Entrance Foyer
    • Eat In Kitchen
    • Separate Formal Living Room
    • Home Office
    • Kitchen Island
    • Pantry
    • Quartz Counters
    • Sliding Glass Doors
    • Storage
    • Bath In Primary Bedroom

Parking

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

Lot & Grounds

  • Lot Size
    0.29 acres
  • Lot Features
    • Cul De Sac
    • Rectangular
    • Rectangular Lot
    • Residential Lot
  • Fencing
    Full
  • Patio & Porch
    • Covered
    • Deck
    • Patio
    • Porch
  • Exterior Features
    • Blacktop Driveway
    • Barbecue
    • Deck
    • Fully Fenced
    • Patio

Type

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

Structure

  • Construction
    • Stone
    • Vinyl Siding
  • Roof
    • Asphalt
    • Shingle
  • Foundation
    Poured

Condition

  • Year Built
    2006
  • Condition
    Resale
  • Days on Market
    34 days
  • Water
    Connected
  • Sewer
    Connected
  • Electric
    Circuit Breakers
  • Utilities
    • 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 →
  • 14 Seville Way, Bethlehem, NY 12158ACTIVE$580,900

    14 Seville Way, Bethlehem, NY 12158

    3 Beds2 Baths1,513 SqFt0.4 Acres

    LISTING BY AMEDORE HOMES

  • 4 Noahs Bluff, Perinton, NY 14450ACTIVE$581,700

    4 Noahs Bluff, Perinton, NY 14450

    3 Beds2 Baths1,939 SqFt0.3 Acres

    LISTING BY EMPIRE REALTY GROUP

  • 61 Lakepointe Way, Stillwater, NY 12866ACTIVE$583,500

    61 Lakepointe Way, Stillwater, NY 12866

    3 Beds2 Baths1,710 SqFt0.17 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • 29 Kenzie Court, Ballston, NY 12020ACTIVE$584,800

    29 Kenzie Court, Ballston, NY 12020

    2 Beds2 Baths1,410 SqFt0.51 Acres

    LISTING BY KW PLATFORM

  • 74 Chase Meadow Trail Lot 98, Mendon, NY 14472ACTIVE$584,900

    74 Chase Meadow Trail Lot 98, Mendon, NY 14472

    4 Beds2.5 Baths2,338 SqFt

    LISTING BY HOWARD HANNA

  • 727 Irish Hill Road, Berne, NY 12023ACTIVE$584,900

    727 Irish Hill Road, Berne, NY 12023

    3 Beds2 Baths1,800 SqFt32.05 Acres

    LISTING BY CRYSTAL COLEMAN REALTY LLC

  • 1013 Eagle Drive, Great Valley, NY 14741ACTIVE$584,900

    1013 Eagle Drive, Great Valley, NY 14741

    3 Beds3 Baths1,736 SqFt1 Acres

    LISTING BY KELLER WILLIAMS REALTY WNY

  • 3349 County Rd 21, Tyrone, NY 14891ACTIVE$585,000

    3349 County Rd 21, Tyrone, NY 14891

    3 Beds2 Baths1,700 SqFt69.85 Acres

    LISTING BY KELLER WILLIAMS REALTY GREATER ROCHESTER

  • 49 Hall Road, Pittstown, NY 12094ACTIVE$585,000

    49 Hall Road, Pittstown, NY 12094

    3 Beds2 Baths1,600 SqFt2.17 Acres

    LISTING BY NEUDECKER REALTY

  • 265 Nine Mile Tree Road, Mayfield, NY 12078ACTIVE$585,000

    265 Nine Mile Tree Road, Mayfield, NY 12078

    3 Beds2 Baths1,700 SqFt1.16 Acres

    LISTING BY ROOHAN REALTY