Custom All-Brick Home with Resort-Style Yard on a Tranquil, Tree-Lined Street
Nestled on a quiet, tree-lined street, this expansive custom-designed home offers privacy, comfort, and room to grow—perfect for multi-generational living or a large family. Boasting approximately 5,700 square feet of living space plus a full finished basement, there’s no shortage of room to relax or entertain.
The first floor features a retro-style specialty kitchen, a spacious living room and formal dining room, den, and three generously sized bedrooms—including a separate bedroom wing with its own bath, ideal for guests or extended family.
Upstairs, vaulted ceilings enhance the sense of space, where you’ll find three additional bedrooms, a large sitting room, and a second kitchen.
The full finished basement goes forever.
Step outside to your private backyard oasis, complete with an inground pool —a true resort-like setting right at home.
Property Id : 1027552
Price: $ 2,499,888
Property Lot Size: 0 ft2
Bedrooms: 6
Bathrooms: 3.5
TaxAnnualAmount: 15000
BathroomsThreeQuarter: 0
BathroomsFull: 3
ListAgentKey: 20141019181350927836000000
StreetNumberNumeric: 74
ContractStatusChangeDate: 2025-07-30
ListAgentDesignation: Accredited Buyer's Representative / ABR,Certified Residential Specialist / CRS,Seniors Real Estate Specialist / SRES
ListAgentFullName: Francine Reali
InternetAddressDisplayYN: 1
ListAgentMobilePhone: 917-670-7068
OnMarketDate: 2025-07-30
BathroomsHalf: 1
InternetEntireListingDisplayYN: 1
ListOfficeKey: 20141019170640625641000000
ListAgentLastName: Reali
Cooling: Central
CumulativeDaysOnMarket: 15
TaxLot: 41
ListingAgreement: Exclusive Right To Sell
StatusChangeTimestamp: July 30, 2025 at 07:15am
ListAgentFirstName: Francine
MajorChangeType: New Listing
LotSizeUnits: Square Feet
DocumentsCount: 1
LotSizeSquareFeet: 10000
OwnerName: Incontro
ListAgentOfficePhone: 718-442-5200
ListingId: 2504144
YearBuilt: 1965
ListAgentURL: http://www.franreali.com
ListAgentPreferredPhone: 917-670-7068
SourceSystemName: Staten Island Multiple Listing Service
SourceSystemKey: 20250716175726507133000000
ArchitecturalStyle: Colonial
ListOfficeFax: 718-420-2323
StateOrProvince: NY
ListOfficeName: BHGRE Safari Realty
LotFeatures: Back,Front,Side
OriginatingSystemKey: 20250716175726507133000000
VideosCount: 0
PhotosCount: 51
ListOfficeURL: http://www.safarirealtyonline.com
ListAgentStateLicense: 10311202982
PhotosChangeTimestamp: August 14, 2025 at 06:52pm
BuildingAreaTotal: 5540
Stories: 2
YearBuiltEffective: 2000
OriginatingSystemName: Staten Island Multiple Listing Service
OriginalListPrice: 2499888
Sewer: City
ListingContractDate: 2025-07-16
StreetSuffix: Avenue
OriginatingSystemID: M00000487
LotSizeDimensions: 100x100
StreetNumber: 74
StreetName: Longfellow
Electric: 220 Volts
ListAgentEmail: franrealirealtor@gmail.com
ModificationTimestamp: August 14, 2025 at 06:52pm
ListOfficeMlsId: o22801
MlsStatus: Active
TaxBlock: 00838
LotSizeArea: 10000
SourceSystemID: M00000487
ParcelNumber: 00838-41
ListOfficeEmail: info@safarirealtyonline.com
ListAgentMlsId: 7821
ParkingFeatures: Off Street
Zoning: R1-1
DocumentsChangeTimestamp: 2025-07-16T18:22:11Z
Heating: Hot Water,Natural Gas
YearBuiltDetails: Approx
ConstructionMaterials: Brick
ListAgentFax: 718-420-2323
MajorChangeTimestamp: July 30, 2025 at 07:15am
Directions: Please use GPS
FireplaceFeatures: Living Room
MLSAreaMajor: Todt Hill
DaysOnMarket: 15
GarageSpaces: 2
MLSAreaMinor: Todt Hill
BathroomsTotalDecimal: 3.5
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: 15000
General_sp_Property_sp_Info_co_Tax_sp_Abated: No
General_sp_Property_sp_Info_co_Lot_sp_Dim: 100x100
General_sp_Property_sp_Info_co_Condition: Excellent
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
Sewer_co_City3: 1
Dining_sp_Room_co_Combination: 1
Dining_sp_Room_co_Formal: 1
Electric_co_220: 1
Exterior_co_Fence: 1
Exterior_co_Garage_sp_Door_sp_Opener: 1
Heat_sp_Source_co_Gas2: 1
Heat_sp_System_co_Hot_sp_Water2: 1
Interior_co_Ceiling_sp_Fan: 1
Interior_co_Walk_hyphen_in_sp_Closet: 1
Parking_co_Off_sp_Street: 1
Kitchen_co_Eat_sp_In: 1
Living_sp_Room_co_Combination2: 1
Living_sp_Room_co_Fireplace3: 1
Main_sp_Bath_co_Full_sp_Bath: 1
Primary_sp_Bedroom_co_Private_sp_Bath: 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