Modern amenitiesGenerously sized bedroomsExpansive living spacesElegant formal areas
RARE GREAT RIVER ESTATE OPPORTUNITY — APPROVED PLANS & PERMIT! 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!
1 day
|
340
|
13
|
Zillow last checked:
Listing updated:
Listed by:
Exit Realty Limitless516-928-7653,
Hector V. Castillo646-915-7913,
Hamza Khokhar347-822-7490,
Exit Realty Limitless
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1038672
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 4
Full bathrooms: 3
1/2 bathrooms: 1
Heating
Hot Water, Oil, Other
Cooling
None
Appliances
Included: None
Features
First Floor Bedroom, First Floor Full Bath, Entrance Foyer, Formal Dining, Open Floorplan, Other
Attic: None
Interior area
Total structure area: 4,276
Total interior livable area: 3,555 sqft
Property
Parking
Total spaces: 2
Parking features: Garage, Off Street, Private
Garage spaces: 2
Features
Has private pool: Yes
Pool features: In Ground
Lot
Size: 0.96 Acres
Details
Parcel number: 0500450000100001002
Special conditions: None
Construction
Type & style
Home type: SingleFamily
Architectural style: Exp Ranch
Property subtype: Single Family Residence, Residential
Materials
Frame, Vinyl Siding
Condition
Year built: 1974
Utilities & green energy
Sewer: Cesspool
Water: Public
Utilities for property: Electricity Available, See Remarks, Water Available
Community & HOA
HOA
Has HOA: No
Location
Region: Great River
Financial & listing details
Price per square foot: $366/sqft
Tax assessed value: $82,700
Annual tax amount: $23,120
Date on market: 8/14/2026
Cumulative days on market: 1 day
Listing agreement: Exclusive Right To Sell
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
8/14/2026
Listed for sale
$1,300,000+106.3%$366/sqft
Source: OneKey® MLS as distributed by MLS GRID #1038672Report a problem
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.