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