large home being sold as is -needs only tlc and some updating but great bones , features all updated windows, hardwood floors, circular driveway , 2 oil tanks, room for mom with proper permits, large shed in yard, rear yard is fenced in, cement patio, and lots of room! Be the1st!!, Additional information: Appearance:very nice,Interior Features:Guest Quarters
Single-familyProperty Type
1945Year Built
7,841 sq ftLot Size
$170Est. Price/Sq.Ft.
Listing by Amy Schuler• Your Team D&G Realty Ltd
Bought with Kevin Key• Coldwell Banker American Homes
Source:OneKey® MLS as Distributed by MLS Grid #L3374318
Redfin Estimate
$435,860
$95K since sold in August 2022$3,000 since August
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 11.9% lower than the average sale price ($495K) of 6 comparable homes.
large home being sold as is -needs only tlc and some updating but great bones , features all updated windows, hardwood floors, circular driveway , 2 oil tanks, room for mom with proper permits, large shed in yard, rear yard is fenced in, cement patio, and lots of room! Be the1st!!, Additional information: Appearance:very nice,Interior Features:Guest Quarters
Year
Property tax
Land + Additions
Assessment*
2026
$6,000
$160 + $1,190
$1,350
2025
$6,000 (+1.1%)
$160 + $1,190
$1,350
2024
$5,936 (+4.2%)
$160 + $1,190
$1,350
2023
$5,694 (−12.6%)
$160 + $1,190
$1,350
2022
$6,511
$160 + $1,190
$1,350
2021
$6,511 (+0.9%)
$160 + $1,190
$1,350
2020
$6,451 (+1.3%)
$160 + $1,190
$1,350
2019
$6,371 (+2.3%)
$160 + $1,190
$1,350
2018
$6,228 (−17.4%)
$160 + $1,190
$1,350
2017
$7,541 (+9.6%)
$160 + $1,540
$1,700
2016
$6,879
$160 + $1,540
$1,700
Tax history for 174 Neighborhood Rd
Year
Property tax
Land + Additions
Assessment*
2026
$6,000
$160 + $1,190
$1,350
2025
$6,000 (+1.1%)
$160 + $1,190
$1,350
2024
$5,936 (+4.2%)
$160 + $1,190
$1,350
2023
$5,694 (−12.6%)
$160 + $1,190
$1,350
2022
$6,511
$160 + $1,190
$1,350
2021
$6,511 (+0.9%)
$160 + $1,190
$1,350
2020
$6,451 (+1.3%)
$160 + $1,190
$1,350
2019
$6,371 (+2.3%)
$160 + $1,190
$1,350
2018
$6,228 (−17.4%)
$160 + $1,190
$1,350
2017
$7,541 (+9.6%)
$160 + $1,540
$1,700
2016
$6,879
$160 + $1,540
$1,700
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Property details
Interior
Basement Information
Basement Sq. Ft: 1,280
Basement Type: Finished
Exterior
Exterior Information
Building Style Type: Ranch
Property Information
Subdivision Name: NINTH MAP/MASTIC BCH
Ground Floor Sq. Ft: 1,280
Building Sq. Ft: 2,560
Legal Description: MASTIC BEACH 9 1259 645 TO 648 INC
Lot Information
# of Buildings: 1
Land Sq. Ft: 7,841
Legal Lot Number: 3
Legal Block Number: 0008
Municipality Name: BROOKHAVEN
Acres: 0.18
State Use Description: SINGLE FAMILY RESID
Financial
Assessor Information
Assessment Year: 2025
Public facts
Beds: —
Baths: —
Sq. Ft.: 2,560
Stories: —
Lot Size: 7,841 square feet
Style: Single Family Residential
Year Built: 1945
Year Renovated: —
County: Suffolk County
APN: 0200979001800003000
Home facts updated by county records on Aug 31, 2026
Around this home
Schools
Tangier Smith Elementary School
Public K-5 • Assigned • 0.9mi
8/10
William Paca Middle School
Public 6-8 • Assigned • 0.9mi
5/10
William Floyd High School
Public 9-12 • Assigned • 1.2mi
3/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
3/10 Fire Factor
0.31% chance of being in a wildfire in next 30 years
4/10 Heat Factor
7 days above 91° expected this year, 20 days in 30 years
8/10 Wind Factor
80% chance of strong winds in next 30 years
4/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Mastic Beach, NY • 11951
Average low and high temperatures (°F)
36
24
38
25
49
35
57
43
64
53
76
63
81
70
77
63
73
60
65
49
55
39
42
28
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.9 hours in
June and 4.6 hours in December, which is comparable to the
U.S. average for solar exposure.
8.9 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$415,000 – $502,000
Reach more buyers when you sell with Redfin. Save up to $4,359 in fees.3 minutes to get started.