Location, location, location! This location is truly an exclusive opportunity to own a home in one of Staten Island's most desirable areas. Spectacular views accompanied by an abundance of sunshine. A cliffside mansion consisting of 4 levels, including 6 bedrooms, 6 bathrooms, 3 kitchens, in-ground salted swimming pool, 2-car garage, 3 entrances, and multiple terraces with amazing bridge/ocean views.
1st floor: Enter into the foyer, marbled floor, formal living room, dining room, 2 bedrooms, full bath, kitchen, laundry room, side entrance.
2nd floor: living room, dining room, kitchen, half bathroom, 2-car garage, side entrance.
3rd floor: 4 bedrooms, 2 full bathrooms, 2 balconies.
4th floor: 2 bedrooms, 2 bathrooms, kitchen with eating area, home theater, living and side entrance. Radiant heat under all the tile floors. 4 separate zones for heat and A/C. The roof is one year old. Too many extras to list!!
Sold for $1,800,000
$1,800,000
254 Flagg Pl, Staten Island, NY 10304
6beds
5,600sqft
Single Family Residence
Built in 1980
0.27 Acres Lot
$1,903,300 Zestimate®
$321/sqft
$5,487 Estimated rent
Home value
$1,903,300
$1.71M - $2.11M
$5,487/mo
Zestimate® history
Owner options
List your home for rent
$5,487/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,487/mo
Rent Zestimate®
Refinance and save
$11,048/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$11,048/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Spectacular viewsIn-ground salted swimming poolMarbled floorDining roomHome theater
Zillow last checked:
Listing updated:
Listed by:
Noha Elashram 718-986-0530,
Tom Crimmins Realty, Ltd.
Bought with:
Ramankant Ramkrishan, 10491209030
Punjab Realty
Source: SIBOR,MLS#: 1160825
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 3
- 3/4 bathrooms: 2
- 1/2 bathrooms: 1
Bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: Third
Bedroom
- Level: Third
Bedroom
- Level: Third
Bedroom
- Level: Third
Bathroom
- Level: First
Bathroom
- Level: Second
Bathroom
- Level: Third
Bathroom
- Level: Third
Bathroom
- Level: Basement
Bathroom
- Level: Basement
Dining room
- Level: First
Dining room
- Level: Second
Family room
- Description: Home theater
- Level: Basement
Foyer
- Level: First
Kitchen
- Level: First
Kitchen
- Level: Second
Living room
- Level: First
Living room
- Level: Second
Heating
- Natural Gas, Hot Water
Cooling
- Central Air
Appliances
- Included: ENERGY STAR Qualified Appliances, ENERGY STAR Qualified Refrigerator, ENERGY STAR Qualified Dishwasher, Dishwasher, Refrigerator
Features
- Walk-In Closet(s), Central Vacuum, Ceiling Fan(s), Fireplace
- Basement: Full,Partially Finished
- Has fireplace: Yes
Interior area
- Total structure area: 5,600
- Total interior livable area: 5,600 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener, Off Street, On Street
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Stories: 4
- Patio & porch: Patio, Deck
- Exterior features: Gas Grill, Balcony
- Pool features: In Ground
- Fencing: Fenced
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 0.27 Acres
- Dimensions: 79 x 150
- Features: Front Yard, Back Yard, Side
Details
- Parcel number: 008950038
- Zoning: R1-2
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick, Stucco
Condition
- Excellent
- New construction: No
- Year built: 1980
Utilities & green energy
- Electric: 220 Volts
- Sewer: Public Sewer
Community & neighborhood
Security
- Security features: Security System
Location
- Region: Staten Island
Other
Other facts
- Listing agreement: Exclusive Right To Sell
Price history
| Date | Event | Price |
|---|---|---|
| 5/13/2025 | Sold | $1,800,000-9.5%$321/sqft |
Source:  SIBOR #1160825 Report a problem | ||
| 2/21/2025 | Pending sale | $1,990,000$355/sqft |
Source: SIBOR #1160825 Report a problem | ||
| 4/7/2024 | Price change | $1,990,000-2.9%$355/sqft |
Source: SIBOR #1160825 Report a problem | ||
| 12/5/2023 | Price change | $2,050,000-6.8%$366/sqft |
Source: SIBOR #1160825 Report a problem | ||
| 6/22/2023 | Price change | $2,200,000-2.2%$393/sqft |
Source: SIBOR #1160825 Report a problem | ||
| 3/17/2023 | Listed for sale | $2,250,000+50%$402/sqft |
Source: SIBOR #1160825 Report a problem | ||
| 5/30/2018 | Sold | $1,500,000-6.2%$268/sqft |
Source: SIBOR #1120609 Report a problem | ||
| 2/12/2018 | Listing removed | $1,599,999$286/sqft |
Source: CENTURY 21 Amiable Realty Group II #2981191 Report a problem | ||
| 10/26/2017 | Price change | $1,599,999+0.1%$286/sqft |
Source: CENTURY 21 Amiable Realty Group II #2981191 Report a problem | ||
| 5/4/2017 | Listed for sale | $1,599,000$286/sqft |
Source: DiTommaso Real Estate #1106018 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $15,560 | $92,700 +3.4% |
| 2024 | $15,560 | $89,640 +7.9% |
| 2023 | -- | $83,100 -0.9% |
| 2022 | -- | $83,820 +12% |
| 2021 | -- | $74,820 +6.8% |
| 2020 | $13,369 -3.7% | $70,080 |
| 2019 | $13,888 | $70,080 +10.9% |
| 2018 | -- | $63,218 +6% |
| 2017 | $12,158 +9.3% | $59,640 +4.3% |
| 2016 | $11,121 | $57,180 -8.2% |
| 2015 | $11,121 +1.4% | $62,264 +6% |
| 2014 | $10,968 | $58,740 -0.1% |
| 2013 | -- | $58,800 -0.4% |
| 2012 | -- | $59,040 -6.8% |
| 2011 | -- | $63,360 -1.5% |
| 2010 | -- | $64,314 +6% |
| 2009 | -- | $60,674 +6% |
| 2008 | -- | $57,240 -27.2% |
| 2007 | -- | $78,600 +3.6% |
| 2006 | -- | $75,840 +5.5% |
| 2005 | -- | $71,904 +5% |
| 2004 | -- | $68,448 |
| 2003 | -- | $68,448 +2.2% |
| 2002 | -- | $66,992 +6% |
| 2001 | -- | $63,200 +5.5% |
| 2000 | -- | $59,920 |
Find assessor info on the county website
Neighborhood: Todt Hill
Nearby schools
GreatSchools rating
- 6/10Ps 11 Thomas Dongan SchoolGrades: PK-5Distance: 0.6 mi
- 5/10Is 2 George L EgbertGrades: 6-8Distance: 0.7 mi
- 5/10New Dorp High SchoolGrades: 9-12Distance: 1.1 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,903,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,903,300
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other New York Topics
