Property Id : 1029761
Price: $ 4,698,000
Property Lot Size: 1 ft2
Bedrooms: 5
Bathrooms: 6.5
TaxAnnualAmount: 24639
BathroomsThreeQuarter: 6
BathroomsFull: 2
CoListOfficeKey: 20141019170629118700000000
ListAgentKey: 20141019181347777724000000
CoListAgentMobilePhone: 917-838-0843
StreetNumberNumeric: 34
ContractStatusChangeDate: 2025-08-01
ListAgentFullName: JoAnn DellaRocca
InternetAddressDisplayYN: 1
CoListAgentKey: 20141019181219203792000000
ListAgentMobilePhone: 718-614-2676
OnMarketDate: 2025-08-01
BathroomsHalf: 0
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170640269871000000
CoListAgentFullName: Michael Gentilesco
ListAgentLastName: DellaRocca
CumulativeDaysOnMarket: 11
TaxLot: 0018
CoListOfficeEmail: mikeg@defalcorealty.com
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: August 1, 2025 at 07:48pm
ListAgentFirstName: JoAnn
CoListAgentEmail: mikeg@defalcorealty.com
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 0
CoListAgentOfficePhoneExt: 300
CoListAgentPreferredPhone: 917-838-0843
CoListOfficeName: Robert DeFalco Realty, Inc.
LotSizeSquareFeet: 23931
OwnerName: FORMICA
ListingId: 2504482
CoListAgentStateLicense: 10301206443
CoListAgentFirstName: Michael
YearBuilt: 2006
ListAgentURL: www.ConnieProfaci.com
ListAgentPreferredPhone: 718-614-2676
SourceSystemKey: 20250731171323145547000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-980-0290
StateOrProvince: NY
CoListAgentLastName: Gentilesco
ListOfficeName: Connie Profaci Realty
CoListAgentOfficePhone: 718-987-7900
CoListOfficeURL: http://www.defalcorealty.com
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250731171323145547000000
VideosCount: 0
PhotosCount: 60
CoListAgentMlsId: 4853
ListOfficeURL: http://www.connieprofaci.com
ListAgentStateLicense: 30DE0539539
PhotosChangeTimestamp: August 2, 2025 at 01:56am
BuildingAreaTotal: 11700
Stories: 4
YearBuiltEffective: 0
PoolFeatures: In Ground
OriginalListPrice: 4698000
Sewer: City
ListingContractDate: 2025-07-22
StreetSuffix: Court
CoListOfficeMlsId: o06101
OriginatingSystemID: M00000487
LotSizeDimensions: 136 x 142
StreetNumber: 34
StreetName: Claire
Electric: 220 Volts
ListAgentEmail: joanndellarocca@aol.com
ModificationTimestamp: August 2, 2025 at 05:06pm
ListOfficeMlsId: o21801
MlsStatus: Active
TaxBlock: 00619
LotSizeArea: 23931
SourceSystemID: M00000487
ParcelNumber: 00619-0018
ListOfficeEmail: cprofaci@aol.com
ListAgentMlsId: 1122
ParkingFeatures: Off Street,On Street
Zoning: R1-1
DocumentsChangeTimestamp: 2025-08-01T19:48:39Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick
ListAgentFax: 718-980-0290
MajorChangeTimestamp: August 1, 2025 at 07:48pm
Directions: GPS
CoListAgentURL: http://ISELLSI.COM
FireplaceFeatures: Living Room,Master Bedroom
MLSAreaMajor: Grymes Hill
DaysOnMarket: 11
GarageSpaces: 3
CoListOfficeFax: 718-980-9842
MLSAreaMinor: Grymes Hill
BathroomsTotalDecimal: 6.5
AddressLegal_co_Section: North Shore
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: 24639
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 136 x 142
General_sp_Property_sp_Info_co_Condition: Excellent
General_sp_Property_sp_Info_co_34_sp_Baths: 6
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: 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_Dryer: 1
Appliances_co_Freezer: 1
Appliances_co_Gas_sp_Grill: 1
Appliances_co_Refrigerator: 1
Appliances_co_Washer: 1
Dining_sp_Room_co_Formal: 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_Grill: 1
Exterior_co_Patio: 1
Exterior_co_Shed: 1
Exterior_co_Sprinkler_sp_System: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Central_sp_Vac: 1
Interior_co_Fireplace5: 1
Interior_co_Walk_hyphen_in_sp_Closet: 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
Kitchen_co_Pantry: 1
Kitchen_co_YardDeck_sp_Access: 1
Living_sp_Room_co_Fireplace3: 1
Living_sp_Room_co_Formal2: 1
Main_sp_Bath_co_Jacuzzi2: 1
Primary_sp_Bedroom_co_Dressing_sp_Room: 1
Primary_sp_Bedroom_co_Fireplace4: 1
Primary_sp_Bedroom_co_Jacuzzi: 1
Primary_sp_Bedroom_co_Suite: 1
Garage_sp_Location_co_Built_hyphen_in: 1
Siding_co_Brick: 1
Yard_co_Back: 1
Yard_co_Front: 1
Yard_co_Side: 1
Pool_co_In_sp_Ground: 1