ML# :902795   Welcome to 87 Sobro Avenue – A Home That Speaks to the Heart.Set on a sun-soaked, south-facing corner lot in North Valley Stream, this one-of-a-kind newly built colonial is where light, space, and soul come together. With 5 spacious bedrooms, 3.5 elegant baths, and over 3, 500 sq ft of beautifully finished living space, every detail invites comfort and connection. The chef’s kitchen—designed with floor-to-ceiling cabinetry and high-end appliances—is the true heart of the home. Upstairs, the tranquil primary suite offers a spa-inspired bath and custom walk-in closet—a peaceful escape from the everyday. Below it all lies a rare bonus: a fully finished, soundproof basement featuring 9-ft ceilings, hardwood floors, and a full bathroom—ideal for entertaining, extended stays, or multi-generational living. Even better, the owner is willing to add a private outside entrance, offering incredible flexibility for future use. Moments from LIRR, shopping, schools, and major highways—this is more than a house.It’s a forever home, filled with light, love, and limitless possibility.

ML# :898824   Absolutely Stunning Builder’s Own Huge Custom model! with WATER VIEW! The one you’ve been waiting for! Completely renovated Entertainer’s Delight! 5 bdrm 3 full bath, over 3300 sq ft Hi Ranch with designer touches throughout! Open Floor Plan, Huge Chef’s Eat-in Kitchen with 13’ Center Island, additional dining area and dry bar, Formal Dining Room with fireplace and water view! Living Room w/fireplace, Huge Primary Suite w/fireplace and 2 walk-in closets, 5 trey ceilings, 2 wood-burning fireplaces and 2 electric fireplaces, Crown moldings, Gorgeous Hardwood floors, Radiant heat in hall bath, Huge lower level with sitting room, Family room w/fireplace, dining area, 2 bedrooms and a full bath, sliders to paver patio and beautifully landscaped private backyard! Separate lower level Laundry room w/new slop sink and plenty of storage, 2 zone CAC, 3 zone heat, Gas heat and cooking, 200 amp electric, IGS, 2 car garage, Beautiful iron double front door, Near the Meca Pool Club and Merrick Golf course ! Won’t Last!!

ML# :897741   Welcome to 12 Griffen Ct, an extraordinary residence set within the prestigious North Harbor community of Miller Place, just minutes from the coveted sands of Cedar Beach. This grand colonial, offering over 4, 000 square feet of refined living space, has been masterfully updated with no expense spared. Featuring five generously scaled bedrooms with the option for a sixth or nursery, and three full bathrooms each brand new, meticulously curated, and finished with the finest materials this home embodies luxury at every turn. The heart of the home is its expansive chef’s kitchen, complete with a magnificent center island offering full storage and roll-out drawers, a walk-in pantry with custom glass door, lazy susans for seamless function, dual stainless-steel refrigerators and bespoke cabinetry designed with elegance and efficiency in mind. A dramatic great room with cathedral ceilings, a formal den with vaulted architecture, beautiful oak floors throughout and carefully selected new chandeliers and custom hi-hats create an atmosphere of sophistication throughout. Closets are abundant in every room, ensuring both form and functionality.Upstairs, the palatial primary suite boasts its own cathedral ceilings, a spa-like bathroom with a free-standing soaking tub, expansive walk-in shower, and a thoughtfully designed bonus space ideal for a nursery, couture dressing room, or grand closet. Every detail down to the custom fixtures and intricate finishes has been curated with intention.The fully finished lower level offers soaring ceilings, a private exterior entrance, dual upgraded electrical panels, new mechanical, and endless possibilities for recreation, extended living, or personalized design. Outdoors, nearly an acre of manicured grounds awaits, featuring a brand-new deck, fire pit, renovated shed, retractable awning, and a backyard offering boundless opportunity—including ample room for a swimming pool. Additional highlights include multi-zone central air, both propane and wood-burning fireplaces, in-ground sprinklers, an oversized two-car garage, and a meticulously landscaped, fully fenced property. A rare offering along the North Shore Do not miss the opportunity to make this yours in one of the most desirable communities on the Long Island Sound!

ML# :894485   Modern Living in Desirable Red Creek RidgeSet in the sought-after Red Creek Ridge neighborhood of Hampton Bays, this stylish modern home offers an open-concept layout ideal for today’s lifestyle. Featuring four spacious bedrooms and three full bathrooms, the main level showcases a bright and airy living room, dining area, and an updated kitchen designed for both function and entertaining.The fully finished lower level provides excellent versatility with a summer kitchen, expansive great room, additional bedroom, office, and full bathroom—perfect for guests or multigenerational living.Step outside to your private backyard oasis where a heated in-ground pool with an overflow hot tub is surrounded by elegant pavers and lush, natural landscaping—creating a serene setting for summer gatherings or peaceful relaxation.With proximity to bay beaches, nature preserves, and all the amenities of the Hamptons, this home delivers the best of year-round or seasonal living.

ML# :881611   Extra large 2 family with 4 units and a GIANT 5, 704 square foot lot parking lot for 22+ cars!The property has two 3 bedroom apartments PLUS two units that can be used for office or expanded living. Highly convenient location right off of the the highway PLUS the expansion of the metro north stations at Co-Op City will add valueSeparate utilities for ALL UNITSThe parking lot has already been fitted with a automatic gate and security cameras. The entire property has been immaculately upgraded and taken care of.

ML# :891362   THREE FAMILY , LAYOUT : BASEMENT == FULL AND PARTIALLY FINISHED WITH HIGH CEILING 1ST FLOOR == 2 BEDROOM APARTMENT 2ND FLOOR === 3 BEDROOM APARTMENT3RD FLOOR === 3 BEDROOM APARTMENT

ML# :884828   4 Family Investment Opportunity Located on desirable Van Cleef Street, this semi-detached, 3-story brick building is a must-see for investors and end-users alike. Set on a 20’ x 75’ lot, the property features four income-producing units: two 1BR/1BA duplexes on the first floor, and a spacious 2BR/2BA unit with a private balcony spanning the second and third floors. Enjoy a beautiful backyard! New roof. Close proximity to Queens Center Mall, Rego Park Shopping Complex, Flushing Meadows Park, the Hall of Science, and 108th St. buses—offering excellent convenience and tenant appeal. The building measures 20’ x 40’ and offers separated utilities and meters for each unit. Zoned R6B, this is a rare opportunity in a high-demand area. Don’t miss out on this exceptional investment in one of Queens’ most vibrant neighborhoods! Property occupied. Please do not disturb the tenants.

ML# :878755   Great Large Colonial In Salisbury Area Fully Redone in 2017, New Roof, Siding, New windows , Large Eating Kitchen With Quartz Counter Tops New Stainless Steel Appliances. 3 Primary Over Size Bedrooms, 4 Full Bath, Sauna Room , Gym Room, Jacuzzi Tub , Large Pavers Patio, Fully Fenced back Yard.

ML# :865626   This exceptional three-family home presents a prime investment opportunity, offering both comfortable living spaces and income potential. Each thoughtfully designed unit provides ample natural light, inviting interiors, and a well-balanced blend of privacy and functionality. The property features dedicated outdoor space, and convenient access to shopping, dining, public transportation, and major highways, making it highly desirable for renters. Additionally, its strategic location just a short distance from major roadways and a nearby A & C train station ensures easy commuting options, further enhancing its appeal. Whether you’re looking to expand your real estate portfolio or secure a multi-family property in a sought-after area, this home is an outstanding opportunity—schedule your private showing today!

ML# :849033   Exceptional 6-Unit Investment Opportunity in Prime AstoriaPositioned on a charming, tree-lined block in one of Queens’ most desirable neighborhoods, 30-67 42nd Street presents a rare chance to own a well-maintained, rent-stabilized six-unit multifamily property in the heart of Astoria.Each floor offers two spacious 2-bedroom, 1-bathroom units, for a total of six income-generating residences. With its strong rent-stabilized tenant base and historically low vacancy rates in the area, this building is ideal for long-term investors seeking immediate cash flow and long-term upside.The roof is in excellent condition, a testament to the care and upkeep of this classic pre-war structure. The building also offers a clean and functional layout that provides both efficiency and comfort across all units.Located just minutes from Steinway Street, 30th Avenue, and the N/W subway lines, this property is surrounded by Astoria’s best dining, shopping, and neighborhood offerings—making it a consistent draw for quality tenants.Whether you’re a seasoned investor or entering the multifamily space, 30-67 42nd Street represents stability, location, and opportunity in equal measure.Seller Financing Available!