Buy
  • Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7897548
MLS #2603766
Listing photo

Experience exceptional waterfront living in this one-of-a-kind

125 Mansion Ave, Staten Island, NY 10308
$849,000
4Beds
4Baths
1,600Sqft
0.05Acres

About this property

Experience exceptional waterfront living in this one-of-a-kind semi-attached single-family home overlooking Great Kills Harbor. With breathtaking, unobstructed views and thoughtfully designed interiors, this residence offers both luxury and flexibility in one of Staten Island's most desirable coastal settings. This spacious home features 4 bedrooms and 3.5 bathrooms, complemented by beautiful hardwood floors throughout. The custom modern kitchen is designed for both functionality and style, flowing seamlessly into the dining area and opening through sliders to a private deck and yard-perfect for entertaining or relaxing by the water. The primary suite is a true retreat, complete with a brand-new spa-like bathroom, a large closet with built-in furniture, and a private balcony showcasing stunning harbor views. The top floor also includes two additional generously sized bedrooms and a custom bathroom featuring a jacuzzi tub. On the main level, enjoy a bright living room with direct access to a front patio facing the harbor, a brand-new half bath, and an open dining area ideal for gatherings. The ground-level basement offers incredible versatility and is perfect for featuring a private room ideal for a home office, a new full bath, and a large family/living area-providing comfort and privacy for extended guests. A built-in garage adds convenience to this already impressive home. NEW ROOF offers peace of mind and added value for years to come. A rare opportunity to own a waterfront gem in Great Kills-this is coastal living at its finest.

Property Features

4 Beds
4 Baths
1,600 Sqft
Built in 1998
0.05 Acres
3 Stories
Beachview
Off Street, Garage, Driveway
Siding: Vinyl Siding
Has Fireplace
Natural Gas, Forced Air
$6,004 / yr property tax
Richmond County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Christine DeHart

Real Broker, LLC

917-417-9450

Location

Map
Listing Agent: Christine DeHart 917-417-9450
Broker: Real Broker, LLC 631-721-9468 Listing Site
Copyright © 2026 Staten Island Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Aug 12, 2026

Photo Gallery

Experience exceptional waterfront living in this one-of-a-kind - photo 1
Experience exceptional waterfront living in this one-of-a-kind - photo 2
Experience exceptional waterfront living in this one-of-a-kind - photo 3
Experience exceptional waterfront living in this one-of-a-kind - photo 4
Experience exceptional waterfront living in this one-of-a-kind - photo 5
Experience exceptional waterfront living in this one-of-a-kind - photo 6
Experience exceptional waterfront living in this one-of-a-kind - photo 7
Experience exceptional waterfront living in this one-of-a-kind - photo 8
Experience exceptional waterfront living in this one-of-a-kind - photo 9
Experience exceptional waterfront living in this one-of-a-kind - photo 10
Experience exceptional waterfront living in this one-of-a-kind - photo 11
Experience exceptional waterfront living in this one-of-a-kind - photo 12
Experience exceptional waterfront living in this one-of-a-kind - photo 13
Experience exceptional waterfront living in this one-of-a-kind - photo 14
Experience exceptional waterfront living in this one-of-a-kind - photo 15
Experience exceptional waterfront living in this one-of-a-kind - photo 16
Experience exceptional waterfront living in this one-of-a-kind - photo 17
Experience exceptional waterfront living in this one-of-a-kind - photo 18
Experience exceptional waterfront living in this one-of-a-kind - photo 19
Experience exceptional waterfront living in this one-of-a-kind - photo 20
Experience exceptional waterfront living in this one-of-a-kind - photo 21
Experience exceptional waterfront living in this one-of-a-kind - photo 22
Experience exceptional waterfront living in this one-of-a-kind - photo 23
Experience exceptional waterfront living in this one-of-a-kind - photo 24
Experience exceptional waterfront living in this one-of-a-kind - photo 25
Experience exceptional waterfront living in this one-of-a-kind - photo 26
Experience exceptional waterfront living in this one-of-a-kind - photo 27
Experience exceptional waterfront living in this one-of-a-kind - photo 28
Experience exceptional waterfront living in this one-of-a-kind - photo 29

$849,000

4
Beds
4
Baths
1,600
Sqft

125 Mansion Ave, Staten Island, NY 10308

By contacting this agent you agree to these Terms and Conditions.
Home New York Staten Island
Experience exceptional waterfront living in this one-of-a-kind - photo 1
Experience exceptional waterfront living in this one-of-a-kind - photo 2
Experience exceptional waterfront living in this one-of-a-kind - photo 3
Experience exceptional waterfront living in this one-of-a-kind - photo 4
Experience exceptional waterfront living in this one-of-a-kind - photo 5
MLS# 2603766
Home For Sale

Experience exceptional waterfront living in this one-of-a-kind

$849,000

125 Mansion Ave, Staten Island, NY 10308

4
Beds
4
Baths
1,600
Sqft
0.05
Acres
$849,000
125 Mansion Ave, Staten Island, NY 10308
4 Beds
4 Baths
1,600 Sqft
0.05 Acres
Experience exceptional waterfront living in this one-of-a-kind semi-attached single-family home overlooking Great Kills Harbor. With breathtaking, unobstructed views and thoughtfully designed interiors, this residence offers both luxury and flexibility in one of Staten Island's most desirable coastal settings. This spacious home features 4 bedrooms and 3.5 bathrooms, complemented by beautiful hardwood floors throughout. The custom modern kitchen is designed for both functionality and style, flowing seamlessly into the dining area and opening through sliders to a private deck and yard-perfect for entertaining or relaxing by the water. The primary suite is a true retreat, complete with a brand-new spa-like bathroom, a large closet with built-in furniture, and a private balcony showcasing stunning harbor views. The top floor also includes two additional generously sized bedrooms and a custom bathroom featuring a jacuzzi tub. On the main level, enjoy a bright living room with direct access to a front patio facing the harbor, a brand-new half bath, and an open dining area ideal for gatherings. The ground-level basement offers incredible versatility and is perfect for featuring a private room ideal for a home office, a new full bath, and a large family/living area-providing comfort and privacy for extended guests. A built-in garage adds convenience to this already impressive home. NEW ROOF offers peace of mind and added value for years to come. A rare opportunity to own a waterfront gem in Great Kills-this is coastal living at its finest.
36 days
on BeachHouse.com
49
views
0
saves

Property Details

HOME DETAILS

4 Beds
4 Baths
1,600 Sqft
Built in 1998
0.05 Acres
3 Stories

BEACH & VIEW

Beachview

EXTERIOR

Off Street, Garage, Driveway
Siding: Vinyl Siding

INTERIOR

Has Fireplace
Natural Gas, Forced Air

FINANCIAL & COMMUNITY

$6,004 / yr property tax
Richmond County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7897548
Viewed
49 times
Listing Status
Active
Added
Jul 06, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
Staten Island Board of Realtors
Source Property ID
2603766
Listing Agent: Christine DeHart 917-417-9450
Broker: Real Broker, LLC 631-721-9468 Listing Site
Copyright © 2026 Staten Island Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
This Arden Heights center hall colonial will sell via auction on - photo 1
This Arden Heights center hall colonial will sell via auction on - photo 2
This Arden Heights center hall colonial will sell via auction on - photo 3
This Arden Heights center hall colonial will sell via auction on - photo 4
This Arden Heights center hall colonial will sell via auction on - photo 5
This Arden Heights center hall colonial will sell via auction on - photo 6
This Arden Heights center hall colonial will sell via auction on - photo 7
This Arden Heights center hall colonial will sell via auction on - photo 8
This Arden Heights center hall colonial will sell via auction on - photo 9
This Arden Heights center hall colonial will sell via auction on - photo 10
This Arden Heights center hall colonial will sell via auction on - photo 11

$1,000,000

5 Beds | 5.0 Baths | 3,600 Sqft

146 Halpin Ave, Staten Island, NY 10312

This Arden Heights center hall colonial will sell via auction on

Added: 07/05/2026 • Updated: 07/05/2026
For Sale
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 1
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 2
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 3
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 4
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 5
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 6
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 7
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 8
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 9
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 10
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 11
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 12
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 13
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 14
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 15
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 16
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 17
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 18
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 19
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 20
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 21
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 22
Welcome to 20 Bancroft Avenue - the wait is over! This - photo 23

$999,999

3 Beds | 2.0 Baths | 1,358 Sqft

20 Bancroft Ave, Staten Island, NY 10306

Welcome to 20 Bancroft Avenue - the wait is over! This

Added: 07/06/2026 • Updated: 07/09/2026
For Sale
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 1
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 2
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 3
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 4
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 5
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 6
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 7
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 8
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 9
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 10
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 11
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 12
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 13
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 14
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 15
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 16
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 17
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 18
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 19
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 20
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 21
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 22
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 23
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 24
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 25
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 26
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 27
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 28
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 29
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 30
Welcome to 44 Duncan Street - a charming 3-bedroom home nestled - photo 31

$999,999

3 Beds | 3.0 Baths | 1,440 Sqft

44 Duncan St, Staten Island, NY 10304

Welcome to 44 Duncan Street - a charming 3-bedroom home nestled

Added: 06/26/2026 • Updated: 07/09/2026
For Sale
Motivated Seller! Charming antique-style home with modern - photo 1
Motivated Seller! Charming antique-style home with modern - photo 2
Motivated Seller! Charming antique-style home with modern - photo 3
Motivated Seller! Charming antique-style home with modern - photo 4
Motivated Seller! Charming antique-style home with modern - photo 5
Motivated Seller! Charming antique-style home with modern - photo 6
Motivated Seller! Charming antique-style home with modern - photo 7
Motivated Seller! Charming antique-style home with modern - photo 8
Motivated Seller! Charming antique-style home with modern - photo 9
Motivated Seller! Charming antique-style home with modern - photo 10
Motivated Seller! Charming antique-style home with modern - photo 11
Motivated Seller! Charming antique-style home with modern - photo 12
Motivated Seller! Charming antique-style home with modern - photo 13
Motivated Seller! Charming antique-style home with modern - photo 14
Motivated Seller! Charming antique-style home with modern - photo 15
Motivated Seller! Charming antique-style home with modern - photo 16
Motivated Seller! Charming antique-style home with modern - photo 17
Motivated Seller! Charming antique-style home with modern - photo 18
Motivated Seller! Charming antique-style home with modern - photo 19
Motivated Seller! Charming antique-style home with modern - photo 20
Motivated Seller! Charming antique-style home with modern - photo 21
Motivated Seller! Charming antique-style home with modern - photo 22
Motivated Seller! Charming antique-style home with modern - photo 23
Motivated Seller! Charming antique-style home with modern - photo 24
Motivated Seller! Charming antique-style home with modern - photo 25
Motivated Seller! Charming antique-style home with modern - photo 26
Motivated Seller! Charming antique-style home with modern - photo 27
Motivated Seller! Charming antique-style home with modern - photo 28
Motivated Seller! Charming antique-style home with modern - photo 29
Motivated Seller! Charming antique-style home with modern - photo 30
Motivated Seller! Charming antique-style home with modern - photo 31
Motivated Seller! Charming antique-style home with modern - photo 32
Motivated Seller! Charming antique-style home with modern - photo 33
Motivated Seller! Charming antique-style home with modern - photo 34
Motivated Seller! Charming antique-style home with modern - photo 35
Motivated Seller! Charming antique-style home with modern - photo 36

$999,888

4 Beds | 2.0 Baths | 1,344 Sqft

175 Highland Ave, Staten Island, NY 10301

Motivated Seller! Charming antique-style home with modern

Added: 06/14/2026 • Updated: 07/09/2026
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.12
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Staten Island

Read more
Sort By:
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Staten Island Real Estate Agent Info

About Staten Island

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.12
Terms & Policy