Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (224)
    Mexico Listings (15)
    Advanced Search
Sell Find an Agent
BarrierFreeHome.com BarrierFreeHome.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 BarrierFreeHome.com logo
Share
BarrierFreeHome.com logo
Ad #7692706
MLS #1024362
Listing photo

Nestled on a quiet cul-de-sac in the exclusive hamlet of Great

15 Teal Crescent, Great River, NY 11739
$2,199,000
5Beds
5Baths
5,465Sqft
0.640Acres

About this property

Nestled on a quiet cul-de-sac in the exclusive hamlet of Great River, this stunning brick Colonial offers 5,500 square feet of beautifully designed living space. Featuring 5 bedrooms and 4 .5 baths, this exceptional residence combines timeless elegance with modern amenities. The first floor boasts a spacious primary en suite with a full bath, formal dining room, living room with soaring cathedral ceilings and fireplace, inviting den, powder room, laundry room, and private guest quarters complete with a bedroom, full bath, and separate side entrance. An elevator provides convenient access throughout the home. The second level offers three generously sized bedrooms, two additional flex rooms perfect for a home office or gym, and a bonus room with dramatic vaulted ceilings, rustic wood beams, and a private full bath featuring radiant heat offering the flexibility to serve as a luxurious second primary suite. A massive walk-up attic with soaring ceilings provides endless possibilities for future expansion, recreation, or storage. Additional highlights include three new central air conditioning units, a brand-new roof, new oil burner, elevator, full basement, and numerous recent upgrades. Step outside to your private backyard retreat featuring a heated saltwater pool, permanent outdoor lighting, nine security cameras, and professionally landscaped grounds with 30 Green Giant arborvitaes creating exceptional privacy. Close to golf, boating and the scenic Connetquot River, this is a rare opportunity to enjoy the very best of Great River living.

Property Features

5 Beds
5 Baths
5,465 Sqft
Built in 1995
0.640 Acres
Open, Garage, Driveway
Siding: Brick
Has Swimming Pool
Has Fireplace
Oil
$25,648 / yr property tax
Suffolk County

Additional Photos

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

Contact Information

Linda Kerr

Signature Premier Properties

631-848-6046

Location

Map
Listing Agent: Linda Kerr 631-848-6046
Broker: Signature Premier Properties 631-673-3700 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BarrierFreeHome.com
Printed Jul 28, 2026

Photo Gallery

Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 1
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 2
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 3
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 4
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 5
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 6
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 7
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 8
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 9
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 10
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 11
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 12
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 13
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 14
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 15
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 16
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 17
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 18
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 19
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 20
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 21
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 22
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 23
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 24
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 25
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 26
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 27
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 28
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 29
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 30
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 31
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 32
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 33
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 34
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 35
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 36
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 37

$2,199,000

5
Beds
5
Baths
5,465
Sqft

15 Teal Crescent, Great River, NY 11739

By contacting this agent you agree to these Terms and Conditions.
Home New York Great River
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 1
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 2
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 3
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 4
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great - photo 5
MLS# 1024362
Home For Sale

Nestled on a quiet cul-de-sac in the exclusive hamlet of Great

$2,199,000

15 Teal Crescent, Great River, NY 11739

5
Beds
5
Baths
5,465
Sqft
0.640
Acres
$2,199,000
15 Teal Crescent, Great River, NY 11739
5 Beds
5 Baths
5,465 Sqft
0.640 Acres

Accessibility Features

Accessible Elevator Installed
Nestled on a quiet cul-de-sac in the exclusive hamlet of Great River, this stunning brick Colonial offers 5,500 square feet of beautifully designed living space. Featuring 5 bedrooms and 4 .5 baths, this exceptional residence combines timeless elegance with modern amenities. The first floor boasts a spacious primary en suite with a full bath, formal dining room, living room with soaring cathedral ceilings and fireplace, inviting den, powder room, laundry room, and private guest quarters complete with a bedroom, full bath, and separate side entrance. An elevator provides convenient access throughout the home. The second level offers three generously sized bedrooms, two additional flex rooms perfect for a home office or gym, and a bonus room with dramatic vaulted ceilings, rustic wood beams, and a private full bath featuring radiant heat offering the flexibility to serve as a luxurious second primary suite. A massive walk-up attic with soaring ceilings provides endless possibilities for future expansion, recreation, or storage. Additional highlights include three new central air conditioning units, a brand-new roof, new oil burner, elevator, full basement, and numerous recent upgrades. Step outside to your private backyard retreat featuring a heated saltwater pool, permanent outdoor lighting, nine security cameras, and professionally landscaped grounds with 30 Green Giant arborvitaes creating exceptional privacy. Close to golf, boating and the scenic Connetquot River, this is a rare opportunity to enjoy the very best of Great River living.
17 days
on BarrierFreeHome.com
0
view
0
saves

Property Details

HOME DETAILS

5 Beds
5 Baths
5,465 Sqft
Built in 1995
0.640 Acres

EXTERIOR

Open, Garage, Driveway
Siding: Brick
Has Swimming Pool

INTERIOR

Has Fireplace
Oil

FINANCIAL & COMMUNITY

$25,648 / yr property tax
Suffolk County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7692706
Viewed
0 time
Listing Status
Active
Added
Jul 10, 2026
Last Refresh
Jul 28, 2026 08:05:58 AM

Listing Information

Data Source
OneKey MLS
Source Property ID
1024362
Listing Agent: Linda Kerr 631-848-6046
Broker: Signature Premier Properties 631-673-3700 Listing Site
Copyright © 2026 OneKey MLS. 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 BarrierFreeHome.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
Facebook 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 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.07.28
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

Great River

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

Great River Real Estate Agent Info

About Great River

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), 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.
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 Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
Facebook 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 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.07.28
Terms & Policy