Active
MLS# B1710114
$799,900
Price
4
Beds
4
Baths
2,413
Living Area (Sq.Ft.)
0.33
Lot Area (Acres)
$799,900
Price
4
Beds
4
Baths
2,413
Living Area (Sq.Ft.)
0.33
Lot Area (Acres)
This extraordinary transitional home showcases hundreds of thousands in restorations & top-tier upgrades over the last decade. This turn-key residence offers an exceptional blend of architectural elegance, modern luxury, & total peace of mind. From the moment you arrive, the magnificent stone facade, grand illuminated columns, & custom exterior lighting set an enchanting tone, beautifully framing meticulously designed landscaping, upgraded concrete driveway, & sidewalk. This fabulous residence flaunts gorgeous custom stone siding wrapping seamlessly around all three sides for unmatched luxury, durability, & curb appeal. Framed by majestic, illuminated columns, the inviting front covered porch creates a grand welcoming entrance. Designed for seamless outdoor living, a gazebo, sprinkler system, powered storage shed, & spectacular yard. Step inside to an atmosphere of refined comfort, a premium whole-house sound system elevates every moment. Stunning marble foyer leads to a quaint formal living area/study w/ French doors. Gourmet kitchen boasts updated high-end appliances, oversized island granite countertops, perfectly complementing white custom cabinetry, & gleaming wide plank hardwood floors carried throughout the 1st fl. Panoramic eating area overlooks yard. The family room features a unique updated stone fireplace wall. The 2nd story features 4 spacious bedrooms. The primary suite a spacious walk-in closet, an updated bath w/ heated flooring as well as the updated main bath. The upstairs hall & bedrooms have original hardwood under carpet. A partially finished lower level offers versatile space tailored to your lifestyle; garage features a high-durability Apollo-coated floor. Beneath its captivating beauty lies premium infrastructures, including a durable metal roof, Pella windows, full-house backup generator, tankless hot water system, integrated security camera systems, a Krystal Klear water filtration system & highly coveted Williamsville Central School District, this home stands as a truly magnificent property, where no expense has been spared & every detail reflects perfection. Heated eaves by gutters. Attached list. Offers taken September 1, 2026 5PM.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1962
Parcel Number
142289-056-180-0012-001-000
Unit Number
--
Lot Features
Corner Lot, Near Public Transit, Rectangular, Rectangular Lot, Residential Lot
Levels
Two
Building Area Source
PublicRecords
Lot Size Dimensions
88X162
Stories
2
Bath Rooms Full
2
Bath Rooms Half
2
Main Level Bathrooms
2
Property Condition
Resale
Elementary School District
Williamsville
Middle Or Junior School District
Williamsville
High School District
Williamsville
Location

Listing Agent
Sharon A Frisicaro
Listing Office
HUNT Real Estate ERA
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-08-26
Fire Places Total
1
Interior Features
Ceiling Fans, Entrance Foyer, Eat In Kitchen, Separate Formal Living Room, Kitchen Island, Other, See Remarks, Bath In Primary Bedroom
Flooring
Carpet, Ceramic Tile, Hardwood, Marble, Tile, Varies
Laundry Features
Main Level
Other Equipment
Generator
Fire Place
true
Cooling
true
Cooling Features
CentralAir
Heating
true
Heating Features
Gas, Baseboard, Hot Water, Radiant Floor
Appliances
Built In Range, Built In Oven, Convection Oven, Double Oven, Dishwasher, Electric Cooktop, Electric Oven, Electric Range, Disposal, Gas Water Heater, Microwave, Refrigerator, Water Purifier Owned
Security Features
SecuritySystemOwned
Electric
Circuit Breakers
Window Features
ThermalWindows
Garage
true
Garage Spaces
2
Architectural Style
Two Story, Transitional
Exterior Features
Concrete Driveway, Fence, Sprinkler Irrigation, Patio
Water Source
Connected, Public
Sewer
Connected
Roof
Metal
Other Structures
Gazebo,Sheds,Storage
Utilities
Cable Available, Electricity Connected, Sewer Connected, Water Connected
Parking Features
Attached, Garage, Garage Door Opener
Attached Garage
true
Foundation Details
Poured
Basement
Full, Partially Finished, Sump Pump
Construction Materials
Stone, Stucco, Synthetic Stucco, Vinyl Siding, Copper Plumbing
Fencing
Partial
Patio And Porch Features
Covered, Patio, Porch
Room Type
Room Area
Bedroom1
19.00 x 11.00
Bedroom2
16.00 x 11.00
Bedroom3
15.00 x 12.00
Bedroom4
13.00 x 12.00
DiningRoom
16.00 x 13.00
FamilyRoom
19.00 x 15.00
Kitchen
32.00 x 15.00
LivingRoom
15.00 x 12.00

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.