Property Id : 968898
Price: $ 1,299,000
Property Lot Size: 0 ft2
Rooms: 12
Bedrooms: 5
Bathrooms: 2.5
TaxAnnualAmount: 9505
BathroomsThreeQuarter: 2
BathroomsFull: 1
InternetAutomatedValuationDisplayYN: 1
ListAgentKey: 20141019181402363554000000
StreetNumberNumeric: 239
ContractStatusChangeDate: 2025-04-21
ListAgentDesignation: NAR's Green Designation / GREEN,Graduate, REALTOR Institute / GRI
ListAgentFullName: Diane Yetman
InternetAddressDisplayYN: 1
ListAgentMobilePhone: 917-763-7502
OnMarketDate: 2025-04-21
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170640800805000000
ListAgentLastName: Yetman
CumulativeDaysOnMarket: 2
TaxLot: 0001
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: 2025-04-21T19:25:17Z
ListAgentFirstName: Diane
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 0
LotSizeSquareFeet: 6000
OwnerName: Rothenberg S&M
ListingId: 2502176
YearBuilt: 1955
ListAgentPreferredPhone: 718-948-1527
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250324200432090483000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-667-8272
StateOrProvince: NY
ListOfficeName: DiTommaso Real Estate
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250324200432090483000000
VideosCount: 1
PhotosCount: 36
ListOfficeURL: http://www.ditommaso.com
ListAgentStateLicense: 40YE0981564
PhotosChangeTimestamp: 2025-04-21T19:25:18Z
BuildingAreaTotal: 2480
Stories: 3
YearBuiltEffective: 2008
OriginatingSystemName: Staten Island Multiple Listing Service
PoolFeatures: In Ground
OriginalListPrice: 1299000
Sewer: City
ListingContractDate: 2025-04-21
StreetSuffix: Street
OriginatingSystemID: M00000487
LotSizeDimensions: 60x100
StreetNumber: 239
StreetName: Sycamore
Electric: 220 Volts
ListAgentEmail: dianeyetman@aol.com
ModificationTimestamp: 2025-04-23T20:09:36Z
ListOfficeMlsId: o26101
MlsStatus: Active
VideosChangeTimestamp: 1970-01-01T00:00:00Z
TaxBlock: 05240
LotSizeArea: 6000
SourceSystemID: M00000487
ParcelNumber: 05240-0001
ListOfficeEmail: properties@ditommaso.com
ListAgentMlsId: 6276
ParkingFeatures: Off Street,On Street
Zoning: R3A
DocumentsChangeTimestamp: 2025-04-21T19:25:18Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Stone,Vinyl Siding
MajorChangeTimestamp: 2025-04-21T19:25:17Z
Directions: On Sycamore Street near Pacific Avenue
MLSAreaMajor: Eltingville
DaysOnMarket: 2
GarageSpaces: 0
MLSAreaMinor: Eltingville
BathroomsTotalDecimal: 2.5
AddressLegal_co_Section: South Shore
ContractLocation_sp_Information_co_CofO: Yes
ContractLocation_sp_Information_co_REO: No
General_sp_Property_sp_Info_co_Stories2: 3
General_sp_Property_sp_Info_co_Style2: Colonial
General_sp_Property_sp_Info_co_Taxes2: 9505
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 60x100
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: 0
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_None: 1
Electric_co_220: 1
Exterior_co_Fence: 1
Exterior_co_Patio: 1
Exterior_co_Shed: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Parking_co_Off_sp_Street: 1
Parking_co_On_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Kitchen_co_Pantry: 1
Kitchen_co_YardDeck_sp_Access: 1
Living_sp_Room_co_Formal2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Shared_sp_Bath: 1
Siding_co_Stone: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Pool_co_In_sp_Ground: 1