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.
Tottenville
152 Connecticut St, Staten Island, NY 10307
Welcome to this stunning detached colonial residence located in the desirable Tottenville area of Staten Island. This beautifully remodeled home offers a perfect blend of sophisticated design and modern amenities. As you enter, you are greeted by a grand entry featuring a breathtaking double-story Swarovski crystal chandelier that sets the tone for luxury. The property boasts expansive outdoor living space, including a picturesque paved backyard with a serene inground saltwater pool and a stylish cabana, ideal for entertaining and relaxation. The interior is adorned with deep stained hardwood floors, enhancing the home's elegant aesthetic. A gourmet eat-in kitchen showcases top-of-the-line Bosch appliances and exquisite Bordeaux custom granite counters, making it a chef's delight. With thoughtful features such as radiant heat on the first floor and modern surround sound speakers throughout, this residence is designed for comfort and convenience. Complete with a spacious driveway and garage, this impressive estate is a sanctuary for rejuvenation and leisure.
Total Units: 1
For Sale: 0
For Rent: 0
Building type: Detached
Style: Colonial
Residential Features:
  • Central Air
  • Central Vacuum
  • Fireplace
  • Garage Door Opener(s)
  • Laundry Area
  • Patio Garden
  • Pool
  • Porch
  • Terrace
Parking Attributes:
  • 3 Spaces
{{ 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 }}