No results found.
Try adjusting or resetting your filters.
{{ agent?.kind }}
{{ agent?.firstname }} {{ agent?.lastname }}
{{ agent?.type }}
{{ agent?.office?.officename }}
{{ agent?.office?.officeaddress }}
Office {{ formatPhoneString(agent?.office?.phone) }}
Cell. {{ formatPhoneString(agent?.cellphone) }}
Languages: {{ agent?.languagesNames }}
{{ agent?.text }}
{{ agent?.biography }}
{{agent?.rating}}
{{agent?.reviews?.length ?? 0}} Reviews
{{ review.created_at }}
{{ review.name }}
{{ agent?.firstname }} {{ agent?.lastname }} currently has no active listings.

274 S Railroad St, Staten Island, NY 10312

$1,995,000
5 Bed / 3 Bath , 4,661 Sq Ft · Single Family

SURROUNDED By Custom Homes Exquisite 5-6 bedroom, 5-bath Center Hall Colonial offering the pinnacle of luxury living approx. 4,400 square feet of living space nestled on an oversized 10,231 square feet corner lot. In addition, there is a beautiful finished basement providing another approximately 1,500+entertainment space plus a resort-style yard w/ a cabana/wet bar/half-bath.2-story foyer + 9 ft ceilings on 1st floor. Family rm features a soaring 2-story new floor-to-ceiling window, Sliders to resort yard,fireplace, surround sound,Spectacular kitchen w/ shiplap ceilings. Enjoy marble backsplash, quartz countertops, a Sub-Zero,Wolf stove w/ a 6ft island w/ seating & dinette area w/sliders to covered patio.Mudroom off kitchen & 2-car garage,walk-in pantry,Separate living & Din. Rm, 6th BDRM/office w/ a new 3/4 bath, laundry room w/ cabinet.Upstairs,hallway overlooks family Rm.Oversized MBDRM suite includes a serene sitting area & Gorg. new custom Bath,double vanity w/ RH mirrors, MTI air-jet soaking tub & large separate shower w/ built-in seating. Carrara marble floors.walk-in closet. 4 additional over-sized bedrooms offer double door large closets, 2 BDRMS have walkway to French doors to a balcony.Finished basement is an entertainer's dream,oak wet bar, cook top,2 wall ovens, beer tap refrigerator, beverage Frig/freezer,GE beverage Frig, dishwasher, trash compactor, ice maker.Playing cards, shooting pool, relaxing in the TV/Theater room w/surround sound,private gym.full bath + separate entrance to a fabulous backyard resort, Inground heated saltwater leads to the cabana bar & Bath, granite countertop, wet sink, beer tap,frig,TV,4-speakers,separate year-round hot tub.Grilling area w/ a 15-ft granite serving counter w Weber grill w/ burners.professional landscaping, pavers around home & outdoor lighting ,Sprinkle system,alarm and camera system,house generator, 3 zone Radiant heat & 2 zone hot water., 2 zone central air, central, oak floors&railings,high hats.

Building type: Detached

Residential Features:

  • Alarm
  • Central Air
  • Central Air - Split
  • Central Vacuum
  • Deck
  • Disposal
  • Dryer
  • Fireplace
  • Garage Door Opener(s)
  • Laundry Area
  • Patio Garden
  • Pool
  • Washer
  • Window Treatments
  • Other
{{ property.neighbourhood?.name }}
{{ property.borough?.name }}
{{ property.projectname }}

{{ property.address }}

MLS #{{ property.mlsnumber }}
OPEN HOUSE: {{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}

{{ property.listprice | toCurrency }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}
Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}
Days on Market: {{ property.dom }}
Expiration Date: {{ property.expireddate }}
Listed Price: {{ property.listprice | toCurrency }}
Sold Price: {{ property.closeprice | toCurrency }}
Days on Market: {{ property.dom }}
Close Date: {{ property.closedate }}
Listed Price: {{ property.listprice | toCurrency }}
Closed Price: {{ property.closeprice | toCurrency }}
Days on Market: {{ property.dom }}
Close Date: {{ property.closedate }}
Under Contract: {{ property.lastchangedate }}

{{ property.publicremarks }}

{{ property.propertyType }}
Floor: {{ property.floornumber }}
Year built: {{ property.yearbuilt }}
Period built: {{ property.periodbuilt }}
Building type: {{ property.buildingtype }}
Pets Allowed: {{ property.petsallowed }}
Style: {{ property.style }}
Assessment included
Board approval included
Building amenities:
  • {{ amenity }}
Residential Features:
  • {{ feature }}
Commercial Features Interior:
  • {{ feature }}
Utilities:
  • {{ utility }}
Parking Attributes:
  • {{ parkingattribute }}
Parking Features:
  • {{ property.parkingfeaturesingle }}
  • {{ parkingfeature }}
Basement amenities:
  • {{ basementamenity }}
Exterior:
  • {{ exteriorItem }}
All listings are subject to errors, omissions, price change, withdrawal and sale without notice.
Data source copyright: © 2026 BROOKLYNMLS USA. All rights reserved.
{{ property.propertysubtype }}
Bedrooms: {{ property.bedstotal }}
Baths Full: {{ property.bathsfull }}
Baths Half: {{ property.bathshalf }}
Rooms: {{ property.roomcount }}
Stories: {{ property.stories }}
Building Size: {{ property.buildingwidth }}' x {{ property.buildinglength }}'
Lot: {{ property.lotsizewidth }}' x {{ property.lotsizelength }}'
Finished Sq. Ft.: {{ property.sqfttotal | toLocaleFormat }}
CC/Maintenance: {{ property.maintenancecommonfee | toCurrency }}
RE Tax: {{ property.taxamount | toCurrency }}
Families #: {{ property.numberoffamilies }}
Contacts
{{ agent?.kind }}
{{ agent?.firstname }} {{ agent?.lastname }}
{{ agent?.type }}
{{ agent?.officename }}
{{ agent?.officeaddress }}
Office {{ formatPhoneString(agent?.officephone) }}
Cell. {{ formatPhoneString(agent?.cellphone) }}
Languages: {{ agent?.languages }}
{{ agent?.text }}
Mortgage Calculator

{{ calc.monthly }}

{{ property.matrix_unique_id }}