Sign up to get new listings emailed daily! JOIN SIGN IN
(718) 790-7277
(718) 790-7277 Email (718) 790-7277
Gurdeep Singh
Licensed Real Estate Salesperson, CBR
REALTOR®
(718) 790-7277
Facebook Icon Instagram Icon 
Refine Search

247 Barrett Road, Lawrence, NY 11559

$4,300,000
SAVE TOUR THIS HOME Get Pre-Approved
  • 247 Barrett Road, Lawrence, NY 11559 Main Photo

16 Total Photos [Click to View All]

Agent photo

Gurdeep Singh
Call: (718) 790-7277
Text: (718) 790-7277

New to the Market
BEDS5 BATHS4 full 2 partial SQUARE FEET5,048 MLS#1010707
STATUSActive PROPERTY TYPEResidential - Single Family SCHOOLLawrence
Call / Text / Map Listing / Print / Share / Email

Property Description

Sprawling Contemporary over 5,000 sf on a lot over 1 acre in Back Lawrence with Golf Course views.This home hasn't been on the market in over 40 years.

247 Barrett Road | MLS# 1010707

This single family home located at 247 Barrett Road, Lawrence, NY 11559 is currently listed for sale with an asking price of $4,300,000. This property was built in 1964 and has 5 bedrooms and 4 full and 2 partial baths with 5048 sq. ft. Barrett Road is located within the Lawrence school district. Search Lawrence real estate on gurdeepsingh.laffey.com today.

Property Features

Property Type: Residential - Single Family
Basement: Yes
Basement: Finished, Full, Storage Space, Walk-Out Access
Cooling: Central Air
Fireplaces: 1
Garage: 2
Heating: Forced Air
Home Style: Contemporary
Lot Size: 1.05 Acres
Taxes: $23,626
Year Built: 1964

Amenities

First Floor Bedroom
First Floor Full Bath
Cathedral Ceiling(s)
Eat-in Kitchen
Entrance Foyer
Formal Dining
Granite Counters
High Ceilings
Kitchen Island
Open Floorplan
Open Kitchen
Primary Bathroom
Master Downstairs
Soaking Tub
Storage

Feature Descriptions

Appliances: Cooktop, Dishwasher, Dryer, Gas Cooktop, Gas Oven, Microwave, Refrigerator, Washer, Gas Water Heater
Building Area Total: 5048
Days on Site: 5
Exterior: Stucco
Fireplace Y/N: Yes
Formal Dining: Yes
GarageY/N: Yes
Included In Taxes: Sewer, Trash
On Market Date: 2026-06-14
Parcel Number: 2023-41-092-00-0106-0
Parking Features: Driveway, Garage
Parking Total: 10
Pool Features: In Ground
Rental Term: Monthly
Rooms Total: 11
Security: yes
Security Features: Building Security, Security System, Video Cameras
Sewer: Public Sewer
Swimming Pool: Yes
Utilities: Cable Available, Electricity Connected, Natural Gas Connected, Phone Connected, Sewer Connected, Trash Collection Public, Water Connected
Water: Public

Local Schools

High School: Lawrence Senior High School
Middle School: LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS
Elementary School: Lawrence Early Childhood-#4 School
School District: Lawrence

TOUR THIS HOME

Choose a date and time to see 247 Barrett Road, Lawrence, NY 11559.
An agent will get in touch to confirm your request shortly.

Choose your video chat app
Request a Showing
  • Monday June 15
  • Tuesday June 16
  • Wednesday June 17
  • Thursday June 18
  • Friday June 19
  • Saturday June 20
  • Sunday June 21
  • Monday June 22
  • Tuesday June 23
  • Wednesday June 24
  • Thursday June 25
  • Friday June 26
  • Saturday June 27
  • Sunday June 28
  • Monday June 29
  • 7:00 AM
  • 7:30 AM
  • 8:00 AM
  • 8:30 AM
  • 9:00 AM
  • 9:30 AM
  • 10:00 AM
  • 10:30 AM
  • 11:00 AM
  • 11:30 AM
  • 12:00 PM
  • 12:30 PM
  • 1:00 PM
  • 1:30 PM
  • 2:00 PM
  • 2:30 PM
  • 3:00 PM
  • 3:30 PM
  • 4:00 PM
  • 4:30 PM
  • 5:00 PM
  • 5:30 PM
  • 6:00 PM
  • 6:30 PM
  • 7:00 PM
  • 7:30 PM
  • 8:00 PM
  • 8:30 PM
  • 9:00 PM
Preferred Communication Method

Estimate Your Payment

Estimated Payment

$ 12,792.94 per month $9,569.94 Principal & Interest $1,968.83 Property Tax $1,254.17 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Listed By / Shown By

Listing By

Agency Name: Realty Connect USA LLC
Agency Contact: Lennybobrow@gmail.com

Shown By

Agent Name: Gurdeep Singh
Agent Phone: (718) 790-7277
Agency Title: Laffey Real Estate

IDX logo

Gurdeep Singh
Gurdeep Singh Office: (516) 627-4343 Cell: (718) 790-7277 Email: gsingh@laffeyre.com
Instagram Icon
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/14/2026. The listing information on this page last changed on 06/14/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Sun 06/14/2026 12:59:54 AM EST) or OneKey MLS (last updated Sun 06/14/2026 12:56:23 AM EST). Real estate listings held by brokerage firms other than Laffey Real Estate may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.



Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register

Pixel