Refine Search
Sort by
$1,300,000
6 Beds 4 Baths 1038672 MLS
RARE GREAT RIVER ESTATE OPPORTUNITY — APPROVED PLANS & PERMIT! The property is being sold as is. Set on an expansive 0.96-acre property, this exceptional offering features an existing 3,555 sq. ft. expanded ranch with approved plans and permit for an approximately 6,636 sq. ft. Center Hall Colonial. Approved for a substantial transformation, the planned residence offers the scale and elegance of a true luxury estate, with expansive living spaces, generously sized bedrooms, elegant formal areas, and modern amenities—all set on nearly an acre of private grounds. Whether you're looking to create your dream home, a luxurious forever residence, or a remarkable custom estate, this property offers a rare opportunity to bring an already-approved vision to life in one of Long Island's most desirable communities. Existing residence: approximately 3,555 sq. ft. expanded ranch. Approved plans and permit for an approximately 6,636 sq. ft. Center Hall Colonial. Buyer to independently verify all plans, dimensions, permit status, zoning requirements, specifications, and construction details with the appropriate professionals and municipal authorities. An exceptional opportunity to create a magnificent estate in Great River—approved plans and permit in place!

14 New Street, Great River

$2,199,000
5 Beds 5 Baths 1024362 MLS
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, ( first floor & second story primaries)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. Room for guests...A must see!!!

15 Teal Crescent, Great River

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of . All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2026 SmartMLS, Inc.