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.

152 Connecticut St, Staten Island, NY 10307

Listed Price: $949,900
Sold Price: $935,000
3 Bed / 1.5 Bath , 2,234 Sq Ft · Single Family

YOU CAN HAVE IT ALL! SPECTACULAR LOCATION, CONSERVATIVE EXPENSES, AND LUXURIOUS LIVING ALL AWAITS IN THIS GORGEOUS COMPLETELY REMODELED 3 BDRM, 5 BATH DETACHED COLONIAL. THIS HOME IS AN OWNER'S DREAM! FROM THE DOUBLE STORY STUNNING SWAROVSKI CRYSTAL CHANDELIER ENTRY TO THE PICTURESQUE PAVED BACKYARD COMPLETE WITH INGROUND SALT WATER POOL. HOME FEATURES INCLUDE: DEEP STAINED HARDWOOD FLOORS THROUGHOUT, GOURMET EAT IN KITCHEN WITH BOCSH APPLIANCES, BREATHTAKING BORDEAUX CUSTOM GRANITE COUNTERS, NEW 40 YEAR ROOF WITH SOLAR PANELS, RADIANT HEAT ON FIRST FLOOR AND MODERN SURROUND SOUND SPEAKERS IN EVERY ROOM INCLUDING BACKYARD. FAMILY ROOM HAS BEEN COMPLETELY REDONE FEATURING NEW FIREPLACE AND ANDERSON SLIDERS TO YOUR NEW RESORT STYLE YARD WITH CABANA. MASTER BEDROOM FEATURES: PRIVATE LUXURIOUS MODERN BATH & CALIFORNIA WALK IN CLOSET. THIS MAGNIFICENT HOME IS ON A 65' FT. WIDE PROPERTY COMPLETE WITH GARAGE AND 3 CAR NEWLY PAVED DRIVEWAY. THIS IMPRESSIVE ESTATE IS A GREAT PLACE TO RELAX, REJUVENATE AND MOST OF ALL, ENTERTAIN!

Building type: Detached

Residential Features:

  • Central Air
  • Central Vacuum
  • Fireplace
  • Garage Door Opener(s)
  • Laundry Area
  • Patio Garden
  • Pool
  • Porch
  • Terrace
{{ 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 }}