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 on 05/13/25
$1,800,000
254 Flagg Pl, Staten Island, NY 10304
6beds
5,600sqft
Single Family Residence, Residential
Built in 1980
0.27 Acres Lot
$1,827,200 Zestimate®
$321/sqft
$7,094 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: May 14, 2025 at 11:57am
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: Third
Bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: Third
Bedroom
- Level: Third
Bedroom
- Level: Third
Bathroom
- Level: Third
Bathroom
- Level: Third
Bathroom
- Level: Basement
Bathroom
- Level: Basement
Bathroom
- Level: First
Bathroom
- Level: Second
Dining room
- Level: Second
Dining room
- Level: First
Family room
- Description: Home theater
- Level: Basement
Foyer
- Level: First
Kitchen
- Level: Second
Kitchen
- Level: First
Living room
- Level: Second
Living room
- Level: First
Heating
- Hot Water, Natural Gas
Appliances
- Included: ENERGY STAR Other, ENERGY STAR Qualified Refrigerator, ENERGY STAR Qualified Dishwasher, Dishwasher, Indoor Grill, Refrigerator
Features
- Ceiling Fan(s), Central Vacuum, Fireplace, Walk-In Closet(s)
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 5,600
- Total interior livable area: 5,600 sqft
Property
Parking
- Total spaces: 2
- Parking features: Off Street, On Street, Garage Door Opener
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Stories: 4
- Patio & porch: Deck, Patio
- Exterior features: Balcony
- Pool features: In Ground
- Fencing: Fenced
Lot
- Size: 0.27 Acres
- Dimensions: 79 x 150
- Features: Back, Front, Side
Details
- Parcel number: 008950038
- Zoning: R1-2
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Stucco
Condition
- New construction: No
- Year built: 1980
Utilities & green energy
- Sewer: Public Sewer
Community & neighborhood
Security
- Security features: Security System
Location
- Region: Staten Island
Other
Other facts
- Listing agreement: Exclusive Right To Sell
Services availability
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$1,827,200
2% more+ $36,544
With Zillow Showcase(estimated)
$1,863,744