Welcome to 963 Sycamore Avenue in Bohemia! This spacious 4 bedroom/3 bath home is set on a shy half-acre and offers an ideal combination of flexible living space, thoughtful updates, and an incredible backyard. The inviting entry foyer leads to a bright formal living room featuring a wood-burning stove with brick hearth. The eat-in kitchen is equipped with stainless steel appliances, granite countertops, a breakfast bar, wall oven and an additional range oven, offering exceptional versatility for everyday living and entertaining. The kitchen and formal dining area flow seamlessly into an oversized great room with plantation shutters and french doors leading to spacious yard, creating a perfect layout for gatherings with a blend of indoor/outdoor living. A newly renovated full bath and laundry room complete the first floor of the main house. Upstairs, you'll find three bedrooms, including a spacious king-size primary bedroom with a private balcony overlooking the beautiful backyard, hall reading nook and main hall bath. Brand-new carpeting throughout adds a fresh, move-in-ready feel. A separate entrance leads to in-law suite featuring living area, kitchen, storage/office space, laundry, full bath and second-floor bedroom offering flexibility for extended living, guests, a home office, or additional space to suit your needs. Step outside and discover an expansive brand new, maintenance-free Trex deck overlooking the beautiful manicured yard. Enjoy summer days around the semi-inground pool or simply relax and take in the privacy and tranquility of this generous backyard. Additional features include in-ground sprinklers and a recently repaved six car driveway, upgraded heating system. With its spacious layout, flexible living arrangements, recent updates, and exceptional outdoor space, this home is truly a must-see! For nature enthusiasts, enjoy close proximity to Connetquot River State Park Preserve.