787 Locust Avenue

Bohemia, NY 11716

$1,100,000
Last Sold Price
4
Beds
2
Baths
1
1/2 Bath
3,000 Sq. Ft.
$367 / Sq. Ft.
3,000
Sq. Ft.
$367
per Sq. Ft.

Description

This modern farmhouse style residence boasts four spacious bedrooms, two and a half spa-like baths, each adorned with exquisite finishes and fixtures. The residence is meticulously crafted to seamlessly blend traditional elements with contemporary design and features, resulting in a perfect synthesis of old-world charm and modern sophistication. Upon entry, a grand foyer ushers you into an expansive open-concept living area, brimming with abundant natural light that dances off the plush surfaces...This modern farmhouse style residence boasts four spacious bedrooms, two and a half spa-like baths, each adorned with exquisite finishes and fixtures. The residence is meticulously crafted to seamlessly blend traditional elements with contemporary design and features, resulting in a perfect synthesis of old-world charm and modern sophistication. Upon entry, a grand foyer ushers you into an expansive open-concept living area, brimming with abundant natural light that dances off the plush surfaces throughout. The gourmet kitchen showcases top-of-the-line stainless steel appliances, striking quartz countertops, and an expansive island - the ideal stage for culinary masterpieces and memorable gatherings. The kitchen effortlessly flows into a comfortable family room, complete with an elegant fireplace that sets the perfect ambiance for cozy nights spent in good company. The primary suite is a serene sanctuary, designed with every detail in mind. The en-suite spa-like bathroom features a lavish soaking tub, a luxurious glass-enclosed dual showerheads, and a double vanity, creating the perfect retreat to indulge in moments of tranquility. The three additional bedrooms are equally generous, offering ample space for guests or family to retreat to and unwind. The exterior of the home is equally impressive, with manicured grounds framing the property, and the front facade, adorned with quintessential farmhouse-inspired accents, exudes charm and sophistication. The backyard provides an idyllic oasis for alfresco living and entertaining, offering ample space for creating unforgettable moments with loved ones. In summary, this magnificent modern farmhouse colonial in Bohemia, NY, is a sublime union of style, function, and luxury, providing comfortable living spaces, state-of-the-art amenities, and a coveted location. Buyer will be responsible for water tap, gas connect, electric hookup, survey and transfer tax fees (exact number to be confirmed).
  1. Listed by Paul A Musso • Realty Connect USA L I Inc
    P: 631-881-5160 C: 631-865-7745 info@teammusso.com
  2. Listed by Maureen Murino • Realty Connect USA L I Inc
    P: 631-881-5160 C: 516-480-0524 reenie@reenie.us

Property Details for 787 Locust Avenue

Township
Islip
Architectural Style
Farmhouse
Community Features
Park
Garage Spaces
2.00
Section Area
Brooktree Court
Offer Presentation
Cannot be Present

Location

Listing Courtesy of Realty Connect USA L I Inc, Paul A Musso; Realty Connect USA L I Inc, Maureen Murino

Sold By Signature Premier Properties, Nicholas Santillo

Add your commute
LISTING UPDATED: 11/14/2023 12:14 AM

Property Details for 787 Locust Avenue

StatusClosed
MLS #3472778
Days on Market110
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeSingle Family
Year Built2023
Lot Size0.46 AC / 20,078 SF
CountySuffolk County

Location

Listing Courtesy of Realty Connect USA L I Inc, Paul A Musso; Realty Connect USA L I Inc, Maureen Murino

Sold By Signature Premier Properties, Nicholas Santillo

Add your commute

Virtual Tour

Building Information for 787 Locust Avenue

Stories-Year Built2023Building Size-Lot Size0.46 AC / 20,078 SF

Payment Calculator

$6,003 per month

30 year fixed, 7.25% Interest

Principal and Interest

$6,003

Property Taxes

$0

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 787 Locust Avenue

Summary
Location and General Information
  • Senior Community YN: No
  • MLS Area Minor: 25
  • MLS District Code: 500
  • Directions: Sunrise Highway to Locust Avenue [Head North] go to house #787 [East side of the road]
  • Tax Block: 0002
  • Tax Lot: 55
  • Year Built Source: Owner
  • Property Attached: No
  • Structure Type: false
  • Levels: Two
  • New Construction YN: Yes
  • Flood Zone Report: 0
  • Square Footage Source: Blue Print
  • Lot Size Source: Other
  • State Or Province: NY
School Information
  • School District: Connetquot
  • Elementary School District: Connetquot
  • Elementary School: Sycamore Avenue Elementary School
  • Middle Or Junior School District: Connetquot
  • Middle Or Junior School: Oakdale-Bohemia Middle School
  • High School District: Connetquot
  • High School: Connetquot High School
Rental
Rental
  • Lease Considered: No
Unit Information
Unit Information
  • Building Units Total: 1
Room Information
Room 1 Information
  • Room Level: First
  • RoomDescription 1: EF~LR~DR~EIK~Pwdr Rm~Great Rm
Room 2 Information
  • Room Level: Second
  • Room Description: BR #4~F.Bath~BR #3 ~BR #2 ~ Laundry ~ Primary Suite
Room 3 Information
  • Room Level: Basement
  • Room Description: OSE- Full Basement
Taxes and HOA Information
Taxes and HOA Information
  • Parcel Number: 0500-255-00-02-00-055-000
  • Tax Map Number: 0500-255-00-02-00-055-000
  • Included In Taxes: Trash
Interior and Exterior Features
Interior Features
  • Amenities: Cathedral/Vaulted/High Ceiling, Cook Top, Den/Family Room, Dishwasher, Door Hardware, Eat in Kitchen, Entrance Foyer, Farmhouse, Formal Dining, Garage Door Opener, Garage Remote, Granite Counters, Hardwood Floors As Seen, Home Office, Insulated Windows, Light Fixtures, Master Bath, Microwave, New Windows, Park, Porch, Powder Room, Public, Refrigerator, See Remarks, Sprinkler System, Walk In Closet, Wall Oven
  • Interior Features: Cathedral Ceiling(s), Den/Family Room, Eat-in Kitchen, Formal Dining, Entrance Foyer, Granite Counters, Home Office, Master Bath, Powder Room, Walk-In Closet(s)
  • Appliances: Cooktop,Dishwasher,Microwave,Oven,Refrigerator
  • Number Of Kitchens: 1.0
  • Total Rooms: 8
  • Living Area: 3000.0
  • Living Area Units: Square Feet
  • Basement: Full, See Remarks, Unfinished
  • Attic Description: Full,Pull Stairs,Unfinished
  • Fireplace: Yes
  • Fireplaces Total: 1
  • Location Amenities: Exposure West, Sprinkler Lawn Sys, Hardwood Floors As Seen, Cathedral/Vaulted/High Ceiling, Library Den, Eat in Kitchen, Formal Dining Room, Entry Foyer, Foyer, Granit Countertops, Home Office, Master Bath, Powder Room, Walk In Closet, Porch, New Windows
  • Common Walls: No Common Walls
  • Window Features: New Windows,Insulated Windows
  • Flooring: Hardwood
  • Inclusions: Cook Top,Dishwasher,Door Hardware,Garage Door Opener,Garage Remote,Light Fixtures,Microwave,Refrigerator,See Remarks,Wall Oven
  • Exclusions: Dryer,Generator,Washer
Exterior Features
  • Exterior Features: Sprinkler System
  • Exterior Property Features: Sprinkler System, Porch, Private, Attached, 2 Car Attached, Driveway, Garage, Other, New Windows, Insulated Windows, Park, Level
  • Elevation Certificate: No
  • Patio And Porch Features: Porch
  • Construction Materials: Cellulose Insulation,Frame,Vinyl Siding
  • Road Responsibility: Public Maintained Road
  • Direction Faces: West
Lot Information
  • Lot Features: Level
  • Lot Size Dimensions: 0.46
  • Site Features: Park, Level
  • Building Size: +/- 3,000
  • Building Area Units: Square Feet
Parking
  • Parking Features: Private, Attached, 2 Car Attached, Driveway, Garage, Other
  • Attached Garage: Yes
  • Garage: Yes
Utilities
  • Cooling: Yes
  • Cooling: Central Air
  • Heating: Natural Gas, Forced Air
  • Heat Fuel Type: Natural Gas, Forced Air
  • Number Of Heating Zones: 2
  • Hot Water: Gas Stand Alone
  • Garbage Removal: Public
  • Sewer: Cesspool
  • Water Source: Public
Green Features
  • Green Features: New Windows, Insulated Windows, Cooktop, Dishwasher, Microwave, Oven, Refrigerator, Natural Gas, Forced Air, Sprinkler System
Virtual Tour

Property History for 787 Locust Avenue

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 787 Locust Avenue

Taxable ValueLand$14,600Additions-Total$14,600
Home Facts
Beds0Lot Size51,401 SqFtStyleResidentialZoningAACountySUFFOLKAPN0500-255.00-02.00-055.000

Schools near 787 Locust Avenue

This home is within Connetquot Central School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
John Pearl Elementary School
PublicK to 5

Oakdale Bohemia Middle School
Public6 to 8

Connetquot High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Realty Connect USA L I Inc, Paul A Musso; Realty Connect USA L I Inc, Maureen Murino

The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey® MLS. Information Copyright 2024, OneKey® MLS. All Rights Reserved.