Active
MLS# R1685360
$1,299,000
Price
3
Beds
3
Baths
2,007
Living Area (Sq.Ft.)
0.15
Lot Area (Acres)
$1,299,000
Price
3
Beds
3
Baths
2,007
Living Area (Sq.Ft.)
0.15
Lot Area (Acres)
Exceptional custom home blending timeless craftsmanship with luxury modern upgrades. Features a Bosch 3-zone central air system with independently programmable climate control for the top floor, main level, and basement, plus a Mr. Cool heating/cooling system in the attached 2-car garage. Property includes a premium $5,000 safe, with additional hidden secure storage disclosed upon contract. Walk-up attic access provides abundant storage space. <br> <br>The fully refinished basement offers a private entrance and standard window, creating ideal potential for a 1-bedroom in-law suite or rental apartment. Main level features oak flooring throughout and two remarkable fireplaces. The dining room showcases the original wood-burning fireplace with ash dump and a stunning marble mantle valued at approximately $5,000. The living room fireplace, imported from France and purchased at auction in the 1980s, is a rare carved masterpiece from the early 1900s with gas operation and multiple flame settings, recently valued at over $50,000. <br> <br>The dining room ceiling is an extraordinary hand-plastered work of art dating to the 1920s, crafted by a master plaster artisan and considered virtually irreplaceable today. <br> <br>Designer kitchen was a finalist in the Wolf/Sub-Zero Northeast Design Competition and features Wolf range, vent hood, microwave, coffee maker, built-in cutting board, Sub-Zero refrigerator, 59-bottle wine cooler, and Bosch dishwasher. Appliance package alone valued near $80,000, with remaining warranties on major Wolf appliances. <br> <br>Outdoor amenities include a premium Trex deck with integrated lighting and a built-in 6-person hot tub. Luxurious primary bath features Carrera marble, heated towel bar, waterfall shower, and body sprays. Additional highlights include whole-lawn sprinkler system and solid core doors throughout.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1928
Parcel Number
2489-078-000-00005-000-0030-1
Unit Number
--
Lot Features
Irregular Lot, Residential Lot
Levels
Two
Lot Size Dimensions
31X139
Stories
2
Bath Rooms Full
3
Property Condition
Resale
Elementary School District
Tuckahoe Union Free
Middle Or Junior School District
Tuckahoe Union Free
High School District
Tuckahoe Union Free
Location

Listing Agent
Louis Pfaff
Listing Office
Keller Williams Upstate NY Properties
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional, F H A
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-05-28
Fire Places Total
2
Interior Features
Separate Formal Living Room, Other, See Remarks
Flooring
Ceramic Tile, Hardwood, Varies
Fire Place
true
Cooling
true
Cooling Features
CentralAir,Zoned
Heating
true
Heating Features
Gas, Forced Air
Appliances
Dishwasher, Exhaust Fan, Gas Cooktop, Gas Water Heater, Microwave, Refrigerator, Range Hood, Wine Cooler
Garage
true
Garage Spaces
2
Architectural Style
Colonial, Tudor
Exterior Features
Deck, Gravel Driveway, Hot Tub Spa
Water Source
Connected, Public
Sewer
Connected
Utilities
Electricity Connected, Sewer Connected, Water Connected
Parking Features
Detached, Garage
Foundation Details
Poured
Basement
Finished
Construction Materials
Stucco
Patio And Porch Features
Deck
Spa
true

Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.