• Neuhaus Realty Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act.

Your search results

254 Flagg Place, Staten Island, NY 10304

$ 1,990,000
254 Flagg Place, Staten Island, NY 10304, ,

Overview

  • Updated On:
  • March 26, 2025
  • 6 Bedrooms
  • 5 Bathrooms
  • 2 Garage Spaces
  • 5600 Size Sft
  • 1980 Year Built

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!!

Address: 254 Flagg Place, Staten Island, NY 10304
State/County:
Zip: 10304
Country: United States
Open In Google Maps
Property Id : 44240
Price: $ 1,990,000
Property Lot Size: 0 ft2
Rooms: 20
Bedrooms: 6
Bathrooms: 5
TaxAnnualAmount: 14287
BathroomsThreeQuarter: 2
BathroomsFull: 3
InternetConsumerCommentYN: 1
InternetAutomatedValuationDisplayYN: 1
BuyerAgentMobilePhone: 347-205-4368
ListAgentKey: 20170925144713022674000000
StreetNumberNumeric: 254
ContractStatusChangeDate: 2025-02-21
ListAgentFullName: Noha Elashram
InternetAddressDisplayYN: 1
BuyerAgentFullName: Ramankant Ramkrishan
OnMarketDate: 2023-05-25
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170636746935000000
BuyerAgentKey: 20141019181214109108000000
BuyerOfficeKey: 20190325220207664604000000
ListAgentLastName: Elashram
CumulativeDaysOnMarket: 702
TaxLot: 0038
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2025-02-21T17:31:11Z
ListAgentFirstName: Noha
PriceChangeTimestamp: 2024-04-07T17:11:25Z
BuyerOfficeName: Punjab Realty
MajorChangeType: Status Change
OffMarketDate: 2025-02-21
BuyerOfficeEmail: goethalrealty@gmail.com
LotSizeUnits: Square Feet
DocumentsCount: 2
BuyerAgentMlsId: 11733
LotSizeSquareFeet: 11850
BuyerAgentLastName: Ramkrishan
OwnerName: Yasser Aly
BuyerAgentURL: http://Www.GoethalRealty.com
ListAgentOfficePhone: 718-986-0530
ListingId: 1160825
BuyerAgentOfficePhone: 347-205-4368
SubAgencyCompensationType: $
YearBuilt: 1980
ListAgentPreferredPhone: 718-986-0530
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20230315150659283852000000
ArchitecturalStyle: Colonial
DocumentsAvailable: Property Owner Information
ListOfficeFax: 718-370-3222
StateOrProvince: NY
BuyerAgentStateLicense: 10491209030
ListOfficeName: Tom Crimmins Realty, Ltd.
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20230315150659283852000000
VideosCount: 0
PhotosCount: 83
ContingentDate: 2025-02-07
ListOfficeURL: http://www.tomcrimminsrealty.com/
ListAgentStateLicense: 10401307838
BuyerOfficePhone: 347-205-4368
PhotosChangeTimestamp: 2023-03-22T21:45:07Z
BuildingAreaTotal: 5600
BuyerAgentPreferredPhone: 347-205-4368
SubAgencyCompensation: 0.00
Stories: 4
PurchaseContractDate: 2025-02-21
OriginatingSystemName: Staten Island Multiple Listing Service
PoolFeatures: In Ground
OriginalListPrice: 2250000
Sewer: City
ListingContractDate: 2023-03-17
StreetSuffix: Place
OriginatingSystemID: M00000487
LotSizeDimensions: 79x150
StreetNumber: 254
StreetName: Flagg
Electric: 220 Volts
ListAgentEmail: elashramnoha@gmail.com
ModificationTimestamp: 2025-02-21T17:31:52Z
ListOfficeMlsId: o10681
BuyerAgentEmail: goethalrealty@gmail.com
MlsStatus: Pending
TaxBlock: 00895
LotSizeArea: 11850
SourceSystemID: M00000487
ParcelNumber: 00895-0038
ListOfficeEmail: info@tomcrimminsrealty.com
BuyerAgentFirstName: Ramankant
ListAgentMlsId: 16121
ParkingFeatures: Off Street,On Street
Zoning: R1-2
DocumentsChangeTimestamp: 2023-03-15T15:16:42Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick,Stucco
ListAgentFax: 718-370-3222
MajorChangeTimestamp: 2025-02-21T17:31:12Z
Directions: As per GPS
FireplaceFeatures: Living Room
MLSAreaMajor: Todt Hill
DaysOnMarket: 702
PendingTimestamp: 2025-02-21T17:31:11Z
GarageSpaces: 2
MLSAreaMinor: Todt Hill
BuyerOfficeMlsId: o11343
CompensationDisclaimer: The listing broker's offer of compensation is made only to participants of the MLS where the listing is filed.
BathroomsTotalDecimal: 5
AddressLegal_co_Section: Mid-Island
ContractLocation_sp_Information_co_CofO: Yes
ContractLocation_sp_Information_co_REO: No
General_sp_Property_sp_Info_co_Stories2: 4
General_sp_Property_sp_Info_co_Style2: Colonial
General_sp_Property_sp_Info_co_Taxes2: 14287
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 79x150
General_sp_Property_sp_Info_co_Irregular: Yes
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 2
General_sp_Property_sp_Info_co_Half_sp_Baths: 1
General_sp_Property_sp_Info_co_Cable: Yes
General_sp_Property_sp_Info_co_Waterview: Yes
General_sp_Property_sp_Info_co_Cooling: Yes
General_sp_Property_sp_Info_co_Fireplace: Yes
General_sp_Property_sp_Info_co_HOA_sp_YN: No
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Gas_sp_Grill: 1
Appliances_co_Refrigerator: 1
Dining_sp_Room_co_Separate: 1
Electric_co_220: 1
Exterior_co_Balcony: 1
Exterior_co_Deck: 1
Exterior_co_Fence: 1
Exterior_co_Garage_sp_Door_sp_Opener: 1
Exterior_co_Patio: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Ceiling_sp_Fan: 1
Interior_co_Central_sp_Vac: 1
Interior_co_Fireplace5: 1
Interior_co_Security_sp_System: 1
Interior_co_Walk_hyphen_in_sp_Closet: 1
Parking_co_Off_sp_Street: 1
Parking_co_On_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Kitchen_co_YardDeck_sp_Access: 1
Living_sp_Room_co_Fireplace3: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Main_sp_Bath_co_Jacuzzi2: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 1
Garage_sp_Location_co_Attached: 1
Siding_co_Brick: 1
Siding_co_Stucco: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Pool_co_In_sp_Ground: 1
Broker_sp_Load_co_Broker_sp_Load_sp_Edit: Company
Outdoor Details
balcony
Other Features
Ceiling Fan
Central Vac
Deck
Dishwasher
ENERGY STAR Dishwasher
ENERGY STAR Other
ENERGY STAR Refrigerator
Fence
Fireplace
Garage Door Opener
Gas Grill
Has Fireplace
Has Garage
Has Heating System
Patio
Refrigerator
Security System
Walk-in Closet
Walk-In Closet(s)

Schedule a tour

Thu 24 Apr
Fri 25 Apr
Sat 26 Apr
Sun 27 Apr
Mon 28 Apr
Tue 29 Apr
Wed 30 Apr
Thu 01 May
Fri 02 May
Sat 03 May
In Person
Video Chat
Your information

Amenities and Features

Outdoor Details
balcony
Other Features
Ceiling Fan
Central Vac
Deck
Dishwasher
ENERGY STAR Dishwasher
ENERGY STAR Other
ENERGY STAR Refrigerator
Fence
Fireplace
Garage Door Opener
Gas Grill
Has Fireplace
Has Garage
Has Heating System
Patio
Refrigerator
Security System
Walk-in Closet
Walk-In Closet(s)

Listing Office Tom Crimmins Realty, Ltd.

Staten Island Board of Realtors

© 2024 Staten Island Multiple Listing Service. All rights reserved. Information deemed reliable but not guaranteed. Data last updated April 24, 2025

Map

Transport
Supermarkets
Schools
Restaurants
Pharmacies
Hospitals

Virtual Tour

Property Reviews

You need to login in order to post a review

Similar Listings

Residential
Active

235 Ada Drive, Staten Island, NY 10314

$ 849,900
2 FAMILY SEMI-ATTACHED 6/6 ON OVERSIZED 29X136 PROPERTY WITH INGROUND POOL. GHW HEAT, FINI ...
3 1.5details
Residential
Active

26 Norwalk Avenue, Staten Island, NY 10314

$ 838,888
Better than new! This beautiful semi-detached home has many upgrades—this home features (3 ...
3 3.25details
Residential
Active

166 Pinewood Avenue, Staten Island, NY 10306

$ 1,498,000
Professionally decorated with meticulous attention to detail, this modern center hall colo ...
4 3.5details

Schedule a tour

Thu 24 Apr
Fri 25 Apr
Sat 26 Apr
Sun 27 Apr
Mon 28 Apr
Tue 29 Apr
Wed 30 Apr
Thu 01 May
Fri 02 May
Sat 03 May
In Person
Video Chat
Your information
  • Advanced Search

    More Search Options
  • Our Listings

  • Mortgage Calculator

  • Reset Password

Compare Listings