Property Id : 1045712
Price: $ 839,999
Property Lot Size: 0 ft2
Rooms: 10
Bedrooms: 3
Bathrooms: 1.75
TaxAnnualAmount: 8162
BathroomsThreeQuarter: 1
BathroomsFull: 1
InternetAutomatedValuationDisplayYN: 1
BuyerAgentMobilePhone: 917-821-1966
ListAgentKey: 20141019181251154692000000
StreetNumberNumeric: 400
ContractStatusChangeDate: 2025-09-03
ListAgentDesignation: Seniors Real Estate Specialist / SRES
ListAgentFullName: Laura L Volsario
InternetAddressDisplayYN: 1
BuyerAgentFullName: Mingqin Sun
ListAgentMobilePhone: 917-685-5555
OnMarketDate: 2025-07-29
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170631545324000000
BuyerAgentKey: 20190726164707489124000000
BuyerOfficeKey: 20180507231702379035000000
ListAgentLastName: Volsario
Cooling: Central
CumulativeDaysOnMarket: 82
TaxLot: 0027
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: September 3, 2025 at 04:55pm
ListAgentFirstName: Laura
PriceChangeTimestamp: June 25, 2025 at 05:16pm
BuyerOfficeURL: http://www.ehouseusa.com
BuyerOfficeName: E-House Realty of Avenue U Inc
MajorChangeType: Status Change
OffMarketDate: 2025-09-02
BuyerOfficeEmail: ehouserealtyusa@gmail.com
LotSizeUnits: Square Feet
DocumentsCount: 1
BuyerAgentMlsId: 16513
LotSizeSquareFeet: 4410
BuyerAgentLastName: Sun
OwnerName: Confidential
ListingId: 2503437
BuyerAgentOfficePhone: 917-821-1966
YearBuilt: 1976
ListAgentURL: http://gatewayarmsrealty.com
ListAgentPreferredPhone: 917-685-5555
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250602173313322997000000
ArchitecturalStyle: Hi Ranch
ListOfficeFax: 718-981-3176
StateOrProvince: NY
BuyerAgentStateLicense: 10401318098
ListOfficeName: Gateway Arms Realty Corp.
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250602173313322997000000
VideosCount: 0
BuyerOfficeFax: 917-621-3033
BuyerAgentFax: 917-621-3033
PhotosCount: 27
ContingentDate: 2025-08-14
ListOfficeURL: http://www.gatewayarmsrealty.com/
ListAgentStateLicense: 10301213299
PhotosChangeTimestamp: June 13, 2025 at 02:22pm
BuildingAreaTotal: 2087
BuyerAgentPreferredPhone: 917-821-1966
Stories: 2
PurchaseContractDate: 2025-09-02
OriginatingSystemName: Staten Island Multiple Listing Service
PoolFeatures: Above Ground
OriginalListPrice: 875000
Sewer: City
ListingContractDate: 2025-06-12
StreetSuffix: Avenue
OriginatingSystemID: M00000487
LotSizeDimensions: 42 x 105
StreetNumber: 400
StreetName: Ramona
Electric: 220 Volts
ListAgentEmail: laurav@gatewayarmsrealty.com
ModificationTimestamp: September 3, 2025 at 04:55pm
ListOfficeMlsId: o10301
BuyerAgentEmail: phoebesunrealestate@gmail.com
MlsStatus: Pending
TaxBlock: 06839
LotSizeArea: 4410
SourceSystemID: M00000487
ParcelNumber: 06839-0027
ListOfficeEmail: laurav@gatewayarmsrealty.com
BuyerAgentFirstName: Mingqin
ListAgentMlsId: 1013
ParkingFeatures: Off Street,On Street
Zoning: R3X
DocumentsChangeTimestamp: 2025-06-13T14:22:40Z
Heating: Forced Air,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick,Vinyl Siding
ListAgentFax: 718-981-3176
MajorChangeTimestamp: September 3, 2025 at 04:55pm
ListAgentMiddleName: L
Directions: Huguenot Avenue to Ramona
MLSAreaMajor: Huguenot
DaysOnMarket: 82
PendingTimestamp: 2025-09-03T16:55:29Z
GarageSpaces: 1
MLSAreaMinor: Huguenot
BuyerOfficeMlsId: o11267
BathroomsTotalDecimal: 1.75
FloorPlansChangeTimestamp: 2025-06-13T14:22:40Z
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: Hi Ranch
General_sp_Property_sp_Info_co_Taxes2: 8162
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 42 x 105
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: 0
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_Fence: 1
Exterior_co_Garage_sp_Door_sp_Opener: 1
Exterior_co_Patio: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Forced_sp_Air: 1
Interior_co_Ceiling_sp_Fan: 1
Interior_co_Wet_sp_Bar: 1
Parking_co_Off_sp_Street: 1
Parking_co_On_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Living_sp_Room_co_Combination2: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Shared_sp_Bath: 1
Garage_sp_Location_co_Built_hyphen_in: 1
Siding_co_Brick: 1
Siding_co_Vinyl_sp_Siding: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Pool_co_Above_sp_Ground: 1
Broker_sp_Load_co_Broker_sp_Load_sp_Edit: Office