Save This Property to Your Favorites
Create a free account to save properties, track market updates, and schedule showings.
Features & Amenities
Your Live Oak Contact
Ask us about this home or schedule a private showing.

Jonathan Goldman
Principal Broker / Owner
Schedule a Showing
Similar Properties
Property Details
- Property Type
- Residential
- Sub Type
- Detached
- Style
- Transitional
- Stories
- 2.0000
- Rooms
- 12
- Fireplaces
- 1
- New Construction
- No
- Year Built (approx.)
- 1996
- Exterior
- Brick
- Foundation
- Crawl
- Roof
- Asphalt Shingle
- Flooring
- Ceramic, Wood
- Heating
- Nat Gas, Programmable Thermostat
- Cooling
- Central Air
- Water Heater
- Gas
- Water
- City/County
- Sewer
- City/County
- Parking
- Garage Att 2 Car, Covered, Multi Car, Driveway Spc
- Garage
- Yes
- Pool
- In Ground Pool
- Fenced
- Yes
- Fence
- Partial
- Waterfront
- Yes
- Waterfront Type
- Boat Lift, Deep Water, River
- View
- Bay, River
- Acres (approx.)
- 3.1600
- Zoning
- R40
- HOA
- No
- POA Fee (monthly)
- $0
- Condo Fee
- $0
- Management Co.
- N/A
- Taxes (approx.)
- $23,701
- Ownership
- Simple
- Possession
- SETTLEMENT
- Disclosures
- Disclosure Statement
- AICUZ Noise Zone
- -65
- AICUZ Crash Zone
- None
Schools
Elementary
Trantwood Elementary
Middle
Great Neck Middle
High
Frank W. Cox
School assignments as reported by the listing broker to REIN. Verify with the school district.
Listing Information Disclosure
The listings data displayed on this medium comes in part from the Real Estate Information Network Inc. (REIN) and has been authorized by participating listing Broker Members of REIN for display. REIN's listings are based upon Data submitted by its Broker Members, and REIN therefore makes no representation or warranty regarding the accuracy of the Data. All users of REIN's listings database should confirm the accuracy of the listing information directly with the listing agent.
© 2026 REIN. REIN's listings Data and information is protected under federal copyright laws. Federal law prohibits, among other acts, the unauthorized copying or alteration of, or preparation of derivative works from, all or any part of copyrighted materials, including certain compilations of Data and information. COPYRIGHT VIOLATORS MAY BE SUBJECT TO SEVERE FINES AND PENALTIES UNDER FEDERAL LAW.
REIN updates its listings on a daily basis. Data last updated: 11/13/2026.
Some or all of the listings represented in this application have been enhanced with Data not provided by REIN. The enhancements are as follows: estimated monthly mortgage payments and similar-property suggestions. The source of these enhancements is: Live Oak Real Estate.
$5,800,000
TRANT BERKSHIRE
About This Property
WATERFRONT LUXURY REDEFINED! Set on 3+ private, meticulously maintained acres, this property offers breathtaking, unobstructed views across to the Lesner Bridge. Positioned well behind neighboring homes, the property enjoys a rare sense of privacy, open space, and exclusivity seldom found on the waterfront. Completely transformed through extensive redesign, the home blends timeless elegance with modern luxury. Soaring ceilings, vast water views, a chef's kitchen with Thermador appliances, a butler's pantry with sink and commercial refrigerator, and a spectacular great room with an 85-inch retractable TV and surround sound create an exceptional living and entertaining experience. The primary suite offers a spa-inspired retreat. Outside, enjoy expansive patios, a sprawling lawn to the water's edge, the longest dock on the point, deep-water access at low tide, a 10,000-lb boat lift, dual jet ski lifts, 240V dock power, and a certified, fortified roof. A truly rare waterfront estate!
Est. Monthly Payment
$30,870/mo
20% down · 7% rate · 30yr term · Estimate by Live Oak, not REIN data
Use full calculator →