• 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:
  • May 14, 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-05-14
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-05-14T18:56:04Z
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
ClosePrice: 1800000
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-05-14T18:57:14Z
ListOfficeMlsId: o10681
BuyerAgentEmail: goethalrealty@gmail.com
MlsStatus: Closed
TaxBlock: 00895
LotSizeArea: 11850
SourceSystemID: M00000487
ParcelNumber: 00895-0038
ListOfficeEmail: info@tomcrimminsrealty.com
BuyerAgentFirstName: Ramankant
ListAgentMlsId: 16121
ParkingFeatures: Off Street,On Street
CloseDate: 2025-05-13
Zoning: R1-2
DocumentsChangeTimestamp: 2023-03-17T21:02:52Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick,Stucco
ListAgentFax: 718-370-3222
MajorChangeTimestamp: 2025-05-14T18:56:08Z
Directions: As per GPS
FireplaceFeatures: Living Room
MLSAreaMajor: Todt Hill
DaysOnMarket: 702
ConcessionsAmount: 0
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
Status_sp_Change_sp_Info_co_Sold_sp_Terms: Conventional
Status_sp_Change_sp_Info_co_Sold_sp_PriceSqFt: 321.43
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 15 May
Fri 16 May
Sat 17 May
Sun 18 May
Mon 19 May
Tue 20 May
Wed 21 May
Thu 22 May
Fri 23 May
Sat 24 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 May 14, 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

103 Monroe Avenue, Staten Island, NY 10301

$ 749,000
Move-in-ready all bricks single family. 4 large bedrooms with 1.5 bathrooms. House was ful ...
4 1.5details
Residential
Pending

185 Jules Drive, Staten Island, NY 10314

$ 549,000
This 2 beds 2 bath home is ultra-wide with a built-in garage. New floors throughout. No HO ...
2 1.5details
Residential
Pending

19 Luna Circle, Staten Island, NY 10312

$ 1,950,000
Welcome to 19 Luna Circle in the prestigious area of SE Annadale situated all by itself on ...
5 4.25details

Schedule a tour

Thu 15 May
Fri 16 May
Sat 17 May
Sun 18 May
Mon 19 May
Tue 20 May
Wed 21 May
Thu 22 May
Fri 23 May
Sat 24 May
In Person
Video Chat
Your information
  • Advanced Search

    More Search Options
  • Our Listings

  • Mortgage Calculator

  • Reset Password

Compare Listings