• Price: $4,899,000

  • 123 Barrett Road
    Lawrence, NY 11559

  • MLS #: 831476

Property Details

Welcome to this exquisite contemporary colonial estate, gracefully situated on over 1.5 acres of serene, park-like grounds. Stunning water views can be enjoyed throughout the house, creating a tranquil ambiance throughout the home. The expansive kitchen seamlessly connects to the open-concept den, serving as the heart of the home—perfect for family gatherings. For more formal entertaining, the property offers an elegant dining room and a spacious living room. The home features many floor to ceiling windows allowing for bright natural light and incredible water views. The full finished basement includes a cozy den, a bedroom, and a half bath, providing extra living space. A convenient first-floor bedroom with an en-suite full bath is ideal for guests or multigenerational living. The private primary suite, located on its own level, features a luxurious full bath for ultimate privacy, with many closets for storage. Additionally, there are four generously sized bedrooms and two full baths, ensuring ample space for family and guests. This estate offers both beauty and functionality, all while benefiting from low taxes! Details Ā»

6 Bedrooms

6 Bathrooms

5400 Square Feet

Etty A. Levy

Licensed Real Estate Salesperson Berkshire Hathaway HomeServices Laffey International Realty - Woodmere
  • 950 Broadway
    Woodmere, NY 11598
  • 516-852-1439
  • 516-852-1439

Biography

Etty Levy is a licensed New York State real estate salesperson representing both buyers and sellers in residential and commercial acquisitions and dispositions across Long Island. Etty’s creative vision coupled with Berkshire Hathaway’s marketing tools and technology will ensure clients have the best opportunity for a quick sale. Previously, Etty worked as an interior designer for 20 years and has played a crucial role in numerous residential developments. Her eye for design has made her an expert in home-staging for sellers, and provides her with a unique ability to envision the potential in a home to advise purchasers. She is personable and enjoys what she does which makes for a pleasant experience in a sometimes stressful situation. She is loyal, efficient, and committed to her clients, and will not rest until her client is satisfied with their real estate transaction.  

Jordan Rosenberg

Co-Listing Agent Berkshire Hathaway HomeServices Laffey International Realty - Woodmere
  • 950 Broadway
    Woodmere, NY 11598
  • 516-459-0278
  • 5164590278

Biography

Jordan Rosenberg is a licensed New York State real estate salesperson. Jordan’s creative imagination and Market knowledge ensures that her clients, both buyers and sellers, receive the best customer service in the marketplace. Jordan works in the field of interior design which allows her to view each project from a detail-oriented perspective, and ultimately stage or present a home to achieve the greatest outcome for her clientele. Jordan’s vast market knowledge guarantees that her customers are well informed and advised properly. Her persistence and attitude paired with her extensive skillsets set her clients up for pleasant and successful transactions.

Jordan currently resides in Woodmere with her husband and 2 loving daughters. She attended Queens College, located in Queens New York, where she received her bachelor’s degree in marketing and media studies.

Loading Agent Listings

Find out your monthly payments for this listing

Mortgage Calculator

How Much Can I Borrow?

How Much Can I Afford?

To email this brochure, please fill out the appropriate fields below. When done, simply click the "SEND" button.

Email Brochure Form



By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.

Select a school from the list below to view its contact information and statistics.

Type of school

Information

Institution Name:

Phone:
Type:
NCES District ID:

Mailing Address:

District:
County:
NCES School ID:

Student/Teacher Ratio
Student/Teacher Ratio
Characteristics
Locale :
Charter :
Total Teachers (FTE) :
Total Students :
Student/Teacher Ratio :
Enrollment by Grade

Students:

Grade Students

School Data Provided By NCES
This information is provided by a third party provider and may or may not reflect all schools in this area.

Want to visit this property? Use this information to plan your trip. Check out local weather data.

High

:

Low

:

Precipitation

:

Humidity

:

Wind

:

Pressure

:

Lawrence, NY 11559

There are two ways to get directions to this property. You can print the directions from your computer or have the address texted to your phone which can then be opened in Google maps.

Please enter Cell Numbers with only 10 digits (ex. 5555555555)

By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.
123 Barrett Road Lawrence, NY 11559