Experience a year-round Entertainer's Dream on the water in Trant Berkshire! Enjoy the ultimate indoor-outdoor lifestyle of this one-of-a-kind waterfront home nestled on a generous 3/4 acre lot in the heart of Great Neck. The expansive sunroom is the centerpiece of the home -featuring soaring ceilings, walls of windows and… Read More a built-in entertaining kitchen for gatherings. Outside is your backyard oasis with an inground pool, boat lift, and deep water access - for boating, swimming and summer fun. Inside, the flexible layout offers a first floor primary suite with updated bath & private deck, plus multiple living areas, a home office, large FROG with private entry, perfect for guests or multi-generational living. Updated kitchen with granite counters, gas range & stainless appliances. Vaulted family room with gas fireplace and plenty of storage throughout. A rare opportunity for waterfront living with standout spaces for entertaining inside & out! Read Less
Courtesy of Susie Edmunds, Howard Hanna Real Estate Svcs.. Office contact: 757-481-3710
Listing Snapshot
Days Online
3
Last Updated
Property Type
Single Family Residence
Beds
5
Full Baths
4
Square Ft.
5,377
Year Built
1974
MLS Number
10623819
30 Days Snapshot Of 23454
$460k
-12%
(avg) sold price
58
+38%
homes sold
32
-11%
(avg) days on market
Snapshot
Area Map
Additional Details
Appliances & Equipment
Dishwasher, Disposal, Dryer, Microwave, Gas Range, Refrigerator, Washer, Cable Hookup, Ceiling Fan, Gar Door Opener
Building
5,377 sqft, 2 stories, Built around 1974, Transitional
Cooling
Central Air, Heat Pump
Disclosures
Disclosure Statement
Accessibility Features
Hallways 42 IN plus, Level Flooring
Exterior Features
Deck, Patio, Brick, Vinyl
Fence
Fenced, Back Fenced
Fireplaces
1 fireplace
Floors
Carpet, Ceramic, Wood
Foundation
Crawl
Garage
Has garage, 700 sqft
Water Features
Waterfront, Boat Lift, Bulkhead, Canal, Deep Water Access, River
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.
UNDER FEDERAL LAW. REIN updates its listings on a daily basis. Data last updated: .
Some listings may be duplicated in the search results due to the co-mingling of listings from more than one multiple listing service. Should there be different listing information between the duplicated listings; user is advised to verify the accuracy of the listing information before making any financial decisions. UNDER FEDERAL LAW. REIN updates its listings on a daily basis. Data last updated:
Confirm your time
Fill in your details and we will contact you to confirm a time.
