Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3385 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3385 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3385 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

7 Dodge Lane
Old Field, NY 11733

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,999,999
Beds: 8
Baths: 13
Status: Pending
SqFt: 10000
Agency: Daniel Gale Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1917
Notes: Step into a world where history and contemporary luxury converge seamlessly. This meticulously restored 1917 Italian Palazzo is a masterpiece that has been thoughtfully designed to meet the demands of modern living while preserving its timeless charm. Comprising three interconnected buildings, this property is a symphony of architectural beauty and functionality. Each structure is linked by picturesque courtyards, serene fountains, and a grand belgian block driveway, creating a private and tranquil oasis that welcomes both homeowners and guests. The professionally maintained grounds are captivating. Each building offers its own private outdoor sanctuary, complete with high-end appliances, integrated speaker systems, top-tier security, and exquisitely designed bathrooms. Custom closets, designer fixtures, and upgraded lighting add a touch of sophistication throughout. This residence goes beyond the ordinary. It's not just a home; it's a lifestyle. With dedicated space for two or more offices, it perfectly balances work and leisure. Whether you're entertaining by the pool, unwinding in the rear courtyard, exploring the beach, or sharing stories by the fire pit beneath the stars, this property caters to every facet of your life. From meticulously restored painted ceilings to the warmth of seven working fireplaces, this home is an architectural treasure trove. Bronzework gates and an awe-inspiring tower with panoramic views in all directions are just some of the remarkable details that await discovery. Step into your private paradise within the stucco-walled pool area. This outdoor haven boasts elegant fountains, intricate mosaic tilework, and an inviting cabana-a space where every day feels like a vacation. Situated near the Stony Brook train station, this property has the best of both worlds, conveniently located halfway between the vibrant energy of New York City and the tranquil charm of the Hamptons. You'll enjoy proximity to shops and renowned schools, making it an ideal location for modern living. While words can paint a vivid picture, the true magic of this waterfront Italian Palazzo reveals itself when you visit in person. We invite you to schedule a private tour and experience the allure of this extraordinary estate by the water. Your dream home awaits.
MlsNumber: 3480793


Listing Provided By: Daniel Gale Sotheby's International Realty, original listing
Name: Daniel Gale Sotheby's International Realty
Phone: (631) 689-6980
Office Name: Daniel Gale Sothebys Intl Rlty
Office Phone: (631) 689-6980
Agent Name: Valerie Briston
Disclaimer: Copyright © 2024 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App