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!!
Property Id : 44240
Price: $ 1,990,000
Property Lot Size: 0 ft2
Rooms: 20
Bedrooms: 6
Bathrooms: 5
TaxAnnualAmount: 14287
BathroomsThreeQuarter: 2
BathroomsFull: 3
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20170925144713022674000000
StreetNumberNumeric: 254
ContractStatusChangeDate: 2023-05-25
ListAgentFullName: Noha Elashram
InternetAddressDisplayYN: 1
OnMarketDate: 2023-05-25
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170636746935000000
ListAgentLastName: Elashram
CumulativeDaysOnMarket: 552
TaxLot: 0038
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2023-05-25T18:07:36Z
ListAgentFirstName: Noha
PriceChangeTimestamp: 2024-04-07T17:11:25Z
MajorChangeType: Price Reduced
LotSizeUnits: Square Feet
DocumentsCount: 2
LotSizeSquareFeet: 11850
OwnerName: Yasser Aly
ListAgentOfficePhone: 718-986-0530
ListingId: 1160825
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
ListOfficeName: Tom Crimmins Realty, Ltd.
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20230315150659283852000000
VideosCount: 0
PhotosCount: 83
ListOfficeURL: http://www.tomcrimminsrealty.com/
ListAgentStateLicense: 10401307838
PhotosChangeTimestamp: 2023-03-22T21:45:07Z
BuildingAreaTotal: 5600
SubAgencyCompensation: 0.00
Stories: 4
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: 2024-09-24T04:11:10Z
ListOfficeMlsId: o10681
MlsStatus: Active
TaxBlock: 00895
LotSizeArea: 11850
SourceSystemID: M00000487
ParcelNumber: 00895-0038
ListOfficeEmail: info@tomcrimminsrealty.com
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: 2024-04-07T17:11:25Z
Directions: As per GPS
FireplaceFeatures: Living Room
MLSAreaMajor: Todt Hill
DaysOnMarket: 552
GarageSpaces: 2
MLSAreaMinor: Todt Hill
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_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
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