Property Id : 1049658
Price: $ 789,999
Property Lot Size: 0 ft2
Bedrooms: 3
Bathrooms: 3.25
TaxAnnualAmount: 6215
BathroomsThreeQuarter: 1
BathroomsFull: 2
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20141019181222809193000000
StreetNumberNumeric: 236
ContractStatusChangeDate: 2025-09-09
ListAgentDesignation: Accredited Buyer's Representative / ABR, Seniors Real Estate Specialist / SRES
ListAgentFullName: Eileen M Pinto
InternetAddressDisplayYN: 1
ListAgentMobilePhone: 718-619-1938
OnMarketDate: 2025-09-09
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170629118700000000
ListAgentLastName: Pinto
Cooling: Central
CumulativeDaysOnMarket: 1
TaxLot: 0017
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: September 9, 2025 at 04:51pm
ListAgentFirstName: Eileen
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 1
LotSizeSquareFeet: 2476
OwnerName: Foppiano
ListingId: 2505287
YearBuilt: 1997
ListAgentURL: http://www.defalcorealty.com/
ListAgentPreferredPhone: 718-619-1938
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250909161322091583000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-980-9842
StateOrProvince: NY
ListOfficeName: Robert DeFalco Realty, Inc.
LotFeatures: Back, Front, Side
OriginatingSystemKey: 20250909161322091583000000
VideosCount: 1
PhotosCount: 39
ListOfficeURL: http://www.defalcorealty.com
ListAgentStateLicense: 10301206954
PhotosChangeTimestamp: September 9, 2025 at 05:16pm
BuildingAreaTotal: 1396
Stories: 2
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 789999
Sewer: City
ListingContractDate: 2025-09-08
StreetSuffix: Street
OriginatingSystemID: M00000487
LotSizeDimensions: 23x106
StreetNumber: 236
StreetName: Queen
Electric: 220 Volts
ListAgentEmail: eileenpinto1@gmail.com
ModificationTimestamp: September 9, 2025 at 05:48pm
ListOfficeMlsId: o06101
MlsStatus: Active
VideosChangeTimestamp: 2025-09-09T16:49:02Z
TaxBlock: 00812
LotSizeArea: 2476
SourceSystemID: M00000487
ParcelNumber: 00812-0017
ListOfficeEmail: mikeg@defalcorealty.com
ListAgentMlsId: 12260
ParkingFeatures: Off Street, On Street
Zoning: R3-2
DocumentsChangeTimestamp: 2025-09-09T16:51:53Z
Heating: Forced Air, Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick, Vinyl Siding
MajorChangeTimestamp: September 9, 2025 at 04:49pm
ListAgentMiddleName: M
Directions: Willowbrook Rd to Bradley Ave to Holden to Queens (located between Holden Blvd & Harold St)
MLSAreaMajor: Manor Heights
DaysOnMarket: 1
GarageSpaces: 0
MLSAreaMinor: Manor Heights
BathroomsTotalDecimal: 3.25
AddressLegal_co_Section: Mid-Island
ContractLocation_sp_Information_co_CofO: Yes
ContractLocation_sp_Information_co_REO: No
General_sp_Property_sp_Info_co_Stories2: 2
General_sp_Property_sp_Info_co_Style2: Colonial
General_sp_Property_sp_Info_co_Taxes2: 6215
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 23x106
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 1
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: No
General_sp_Property_sp_Info_co_Cooling: Yes
Sewer_co_City3: 1
Appliances_co_Dishwasher: 1
Appliances_co_Dryer: 1
Appliances_co_Microwave: 1
Appliances_co_Refrigerator: 1
Appliances_co_Washer: 1
Dining_sp_Room_co_Combination: 1
Electric_co_220: 1
Exterior_co_Deck: 1
Exterior_co_Fence: 1
Exterior_co_Shed: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Forced_sp_Air: 1
Interior_co_Ceiling_sp_Fan: 1
Parking_co_Off_sp_Street: 1
Parking_co_On_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Living_sp_Room_co_Formal2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 1
Garage_sp_Location_co_None4: 1
Siding_co_Brick: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1