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.
Midland Beach
247 Freeborn St, Staten Island, NY 10306
This impressive semi-attached home in Midland Beach boasts an expansive layout of over 1,900 square feet, designed for both comfort and functionality. Constructed in 2002, the residence features a built-in garage and an additional carport, providing ample parking options. The interior is bathed in natural light, highlighting the welcoming living and dining area that seamlessly flows into a modern kitchen. The property includes three spacious bedrooms and three well-appointed bathrooms, ensuring plenty of room for relaxation and privacy. A finished basement with high ceilings adds extra living space and includes its own full bathroom and separate entrance. The outdoor area is designed for easy maintenance, complete with PVC fencing, making it an ideal space for entertaining or enjoying quiet moments. Conveniently situated near Hylan Boulevard, residents have quick access to schools, shopping, parks, and beautiful beaches, enhancing the overall appeal of this remarkable home.
Total Units: 1
For Sale: 0
For Rent: 0
Building type: Semi-Detached
Style: Duplex
Residential Features:
  • Central Air
  • Dryer
  • Washer
Parking Attributes:
  • 2 Spaces
  • Built-In Garage
{{ 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 }}