Property Id : 1054051
Price: $ 1,050,000
Property Lot Size: 0 ft2
Bedrooms: 4
Bathrooms: 3.5
TaxAnnualAmount: 9686
BathroomsThreeQuarter: 0
BathroomsFull: 3
InternetAutomatedValuationDisplayYN: 1
BuyerAgentMobilePhone: 646-673-5496
ListAgentKey: 20230628190209476065000000
StreetNumberNumeric: 4087
ContractStatusChangeDate: 2025-09-18
ListAgentFullName: Steven Sciarrino
InternetAddressDisplayYN: 1
BuyerAgentFullName: Steven Sciarrino
ListAgentMobilePhone: 646-673-5496
OnMarketDate: 2025-07-28
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170636732481000000
BuyerAgentKey: 20230628190209476065000000
BuyerOfficeKey: 20141019170636732481000000
ListAgentLastName: Sciarrino
Cooling: Central
CumulativeDaysOnMarket: 56
TaxLot: 0052
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: September 18, 2025 at 04:51pm
ListAgentFirstName: Steven
PriceChangeTimestamp: August 20, 2025 at 06:11pm
BuyerOfficeURL: http://www.sipremiereproperties.com
BuyerOfficeName: SI Premiere Properties
MajorChangeType: Status Change
OffMarketDate: 2025-09-18
BuyerOfficeEmail: gregdsells@aol.com
LotSizeUnits: Square Feet
DocumentsCount: 0
BuyerAgentMlsId: 18102
LotSizeSquareFeet: 5200
BuyerAgentLastName: Sciarrino
OwnerName: Tacetta-Danna Maria
ListingId: 2504192
YearBuilt: 2002
ListAgentPreferredPhone: 646-673-5496
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250717210348953955000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-408-1498
StateOrProvince: NY
BuyerAgentStateLicense: 10401370748
ListOfficeName: SI Premiere Properties
LotFeatures: Back
OriginatingSystemKey: 20250717210348953955000000
VideosCount: 0
BuyerOfficeFax: 718-408-1498
BuyerAgentFax: 718-408-1498
PhotosCount: 39
ContingentDate: 2025-09-04
ListOfficeURL: http://www.sipremiereproperties.com
ListAgentStateLicense: 10401370748
PhotosChangeTimestamp: July 28, 2025 at 03:09pm
BuildingAreaTotal: 2700
BuyerAgentPreferredPhone: 646-673-5496
Stories: 2
PurchaseContractDate: 2025-09-18
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 1099000
Sewer: City
ListingContractDate: 2025-07-18
StreetSuffix: Avenue
OriginatingSystemID: M00000487
LotSizeDimensions: 46x114
StreetNumber: 4087
StreetName: Richmond
Electric: 220 Volts
ListAgentEmail: emailstevensciarrino@gmail.com
ModificationTimestamp: September 18, 2025 at 04:52pm
ListOfficeMlsId: o10680x
BuyerAgentEmail: emailstevensciarrino@gmail.com
MlsStatus: Pending
TaxBlock: 05682
LotSizeArea: 5200
SourceSystemID: M00000487
ParcelNumber: 05682-0052
ListOfficeEmail: gregdsells@aol.com
BuyerAgentFirstName: Steven
ListAgentMlsId: 18102
ParkingFeatures: Off Street
Zoning: R1-2
DocumentsChangeTimestamp: 2025-07-18T19:36:11Z
Heating: Hot Water, Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick, Vinyl Siding
ListAgentFax: 718-408-1498
MajorChangeTimestamp: September 18, 2025 at 04:51pm
Directions: Sycamore to Ridgecrest Avenue to cul-de-sac House has Richmond Avenue address but entrance to home is off Ridgecrest.
4 Bedroom 4 bath Colonial situated on 46x114 property . Yard faces Richmond Avenue.
MLSAreaMajor: Eltingville
DaysOnMarket: 56
PendingTimestamp: 2025-09-18T16:51:33Z
GarageSpaces: 1
MLSAreaMinor: Eltingville
BuyerOfficeMlsId: o10680x
BathroomsTotalDecimal: 3.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: 2
General_sp_Property_sp_Info_co_Style2: Colonial
General_sp_Property_sp_Info_co_Taxes2: 9686
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 46x114
General_sp_Property_sp_Info_co_Condition: Fair
General_sp_Property_sp_Info_co_34_sp_Baths: 0
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
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_Refrigerator: 1
Dining_sp_Room_co_Formal: 1
Electric_co_220: 1
Exterior_co_Fence: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Ceiling_sp_Fan: 1
Interior_co_Fireplace5: 1
Parking_co_Off_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Living_sp_Room_co_Separate2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Main_sp_Bath_co_Jacuzzi2: 1
Primary_sp_Bedroom_co_Jacuzzi: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 1
Primary_sp_Bedroom_co_Suite: 1
Garage_sp_Location_co_Built_hyphen_in: 1
Siding_co_Brick: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Broker_sp_Load_co_Broker_sp_Load_sp_Edit: Office