Experience a year-round Entertainer's Dream on Waterfront Lot 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 a… Read More built-in entertaining kitchen perfect for gatherings. Step outside to your backyard oasis with an in-ground pool, boat lift and deep water access-ideal for boating, swimming and summer fun. Inside, the flexible layout offers a spacious first floor primary suite with update bath and 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, stainless appliances and gas range. Vaulted family room with gas fireplace and plenty of storage throughout. A rare opportunity for waterfront living with standout spaces for entertaining both inside & out! Read Less
Courtesy of Susie Edmunds, Howard Hanna Real Estate Services. Office contact: 757-481-3710
Listing Snapshot
Days Online
9
Last Updated
Property Type
Single Family Residence
Beds
5
Full Baths
4
Square Ft.
5,377
Year Built
1974
MLS Number
10603398
30 Days Snapshot Of 23454
$652k
+22%
(avg) sold price
61
-1%
homes sold
29
+3%
(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
Disclosures
Disclosure Statement
Accessibility Features
Hallways 42 IN plus, Level Flooring, Main Floor Laundry, Pocket Doors
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, Canal, Deep Water Access, Dock, 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.
