Welcome to this exceptional mini-estate offering approximately 3,860 sq. ft. of living space plus an additional 800 sq. ft. finished basement. ares. Set on ¾ acre of beautifully landscaped property, this unique home is designed for both everyday living and unforgettable entertaining. The private backyard is truly an entertainer’s paradise, featuring a completely rebuilt gunite inground pool, full-size basketball court, and plenty of open space for family, friends, and outdoor enjoyment. A picturesque professionally landscaped yard provides a beautiful backdrop in every season. Inside, the oversized family room is a standout gathering space, complete with a built-in wet bar and wood-burning stove—perfect for relaxing after a day outdoors or hosting guests. The modern kitchen features Corian countertops and two stoves, one electric and one gas, providing exceptional flexibility for everyday cooking and entertaining. The home offers four bedrooms and 2½ baths, along with a heated garage for added comfort and convenience. The finished basement Great Room provides an impressive bonus space for recreation, a home theater, game room, gym, or large-scale gatherings. Additional amenities include two detached outbuildings: a 12' x 20' barn with loft and electric, plus a former pool cabana with changing rooms, offering versatile storage and recreational possibilities. Notable updates include a 2016 roof and refinished basement in 2017. With its combination of generous living space, resort-style backyard amenities, flexible bonus areas, and distinctive character, this property offers an exceptional opportunity to enjoy privacy, recreation, and entertaining all in one remarkable setting. No showings until 8/30 at 1:00pm open house. Offers considered after 1:00pm 8/30.
Single-familyProperty Type
1961Year Built
0.75 acresLot Size
$174Price/Sq.Ft.
2 car garageParking
Listing by Kenneth Greulich• Dan & Lucy Wilson Realty
MUST SEE! Mini estate with 3,860 square feet, which holds an additional 800 sq. feet Great Room in the basement! Private yard consisting of a gunite built in pool with solar heat, full basketball court and well over 1 acre for entertainment and your family’s enjoyment. This gem has an Oversized family-room with built in wet bar and wood burning stove. No matter what season, you can relax while enjoying a picturesque view of your professional landscaped yard. Bonus 2 out building with electric 12x20 barn with loft, and three season room with Hot Tub to stay, Roof 2016, refinished basement 2017, and heated garage. ( Corian counter Tops)
Public Records
Nov 3, 2000
Sold
$180,000
$47/sq ft
Public Records
Mar 7, 1995
Sold
$200,000
$52/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$9,729
$18,400 + $156,800
$175,200
2025
$9,729 (+4.7%)
$18,400 + $156,800
$175,200
2024
$9,296 (+1.4%)
$18,400 + $156,800
$175,200
2023
$9,167 (+1.9%)
$18,400 + $156,800
$175,200
2022
$8,998 (−3.4%)
$18,400 + $156,800
$175,200
2021
$9,318 (+2.1%)
$18,400 + $156,800
$175,200
2020
$9,123 (+14.6%)
$18,400 + $156,800
$175,200
2019
$7,958 (+9.3%)
$18,400 + $156,800
$175,200
2018
$7,280 (+0.5%)
$18,400 + $156,800
$175,200
2017
$7,242 (+2.6%)
$18,400 + $156,800
$175,200
2016
$7,056 (+6.0%)
$18,400 + $156,800
$175,200
2015
$6,658 (+3.6%)
$18,400 + $156,800
$175,200
2014
$6,429
$18,400 + $156,800
$175,200
Public record
Beds
4
Baths
2.5
Stories
1
Lot width
105 ft.
Lot depth
354 ft.
Lot size
0.75 Acres
Year renovated
1980
Finished Sq. Ft.
3,860
Unfinished Sq. Ft.
—
Total Sq. Ft.
3,860
Year built
1961
Style
Single Family Residential
County
Niagara County
APN
292489A1310060001009000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 10, 2026.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 94° expected this year, 14 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
Lewiston, NY • 14092
Average low and high temperatures (°F)
30
20
32
21
47
31
57
39
66
49
78
61
84
67
80
62
75
57
64
48
49
37
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
93/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 27% for direct sun exposure in the zip code. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.4 hrs
6.5 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 987 N Hewitt Dr
$663,069
$6,931 under list price of $670K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $237K to $610K.