ML# :867125   riple Mint Colonial with Two Private In-Law Suites + Finished Attic in Prime Location.This fully gut-renovated four-bedroom colonial offers the ideal blend of timeless design, modern upgrades, and versatile living, featuring a spacious primary residence and two separate in-law suites, each with its own private entrance.The main home spans two beautifully finished levels and features a bright, open layout with new engineered wood flooring, a custom chef’s kitchen, designer bathrooms, and a primary suite with an oversized private balcony.Approximate Interior Square Footage:Primary living area (excluding basement & attic): 1, 678 SFFinished basement: 828 SFFinished attic: 301 SFTotal interior space with finished basement & attic: 2, 807 SFAbove-grade interior (excluding basement): 1, 979 SFIn addition to the main residence, the first in-law suite is located on the main level, offering a fully private retreat. The second in-law suite is housed in the fully finished basement, with its entrance and full living setup—ideal for extended family, guests, or rental income.Recent renovations include new structural beams, spray foam insulation (thermal and soundproof), new electric and plumbing, custom closets, new doors, designer light fixtures, and a premium Mitsubishi hyper heat system for energy-efficient heating and cooling. A built-in speaker system adds ease to entertaining and everyday living.The attic has been finished with raised ceiling height, offering exceptional additional storage space—a rare bonus in a home like this. A fully finished, landscaped backyard completes this turnkey offering, ideal for relaxation or entertaining.Located in a prime neighborhood, this is a rare opportunity to own a fully renovated home with multiple private living quarters, thoughtful upgrades throughout, and timeless appeal.

ML# :855296   This beautifully expanded Colonial, updated in 2025, offers generous living space and a functional layout perfect for today’s lifestyle. Originally expanded in 2007, when you step inside you’ll notice the home features large, light-filled rooms, including a spacious eat-in kitchen, a huge pantry, first-floor laundry, and first floor bath for for added convenience.Natural brand new hardwood floors run throughout the home. Upstairs you’ll find two large bedrooms with a shared hall bath. The primary suite is a true retreat, featuring a large walk-in closet and a stunning, brand new en-suite bathroom (renovated in 2025) with modern finishes and a spa-like walk-in shower. The full, unfinished basement with outside separate entrance offers excellent potential for storage or future living space. Step outside to a new Trex deck, overlooking a fully fenced yard with white PVC fencing and a storage shed. Located in the highly rated North Shore School District, close to schools, parks, shopping, and transportation. Move-in ready with room to grow—this is the one you’ve been waiting for!

ML# :854847   Featured Granite Flooring , Mahogany Doors, Exotic Wood Accents, SOLID Brick Construction, Luxury 2 Family Home High end Finishes, Live or Invest In Refine Comfort & Timeless Qualities In the Heart of Astoria / L.I.C, plenty Of Rare Possibilities, Water taxi, Manhattan views & River views , Rainy Park, with in the Walking Distance, Showing may 30th Friday 4pm to 6pm , please confirm by texting Listing Agent,

ML# :844689   Desirable Two-Family Brick Home! You don’t have to worry about the HPD Lead-new regulation! It was Built in 1995-1996! First time in the market! Discover this charming two-family brick house, ideally situated in a convenient location. The 2nd floor features a spacious layout with three comfortable bedrooms and two full baths, perfect for families or guests. The 1st floor boasts two additional bedrooms and a full bath, making it an excellent option for rental income or extended family. Enjoy the bonus of a fully finished basement with a private entrance, providing extra living space and versatility. This home also features two boilers for efficiency and a private driveway for your convenience.The property is close to beautiful parks, hospitals, and highly-rated schools, ensuring an outstanding lifestyle for you and your family. Plus, it comes equipped with solar panels, offering energy-saving benefits. Don’t miss out on this fantastic opportunity—schedule your viewing today!Great prospect for first time home buyers or investors!! Hurry up! Don’t miss the opportunity to own a great house at discounted Price! Reduced for quick sales! As Is

ML# :842705   Prime Investment Opportunity – Three-Family Home for Sale in the Heart of Middle Village.All units are Separately Metered! Tenants pay their own utilities! Exceptional Location & Convenience:Situated just steps from Metropolitan Avenue, this well-maintained property offers unparalleled convenience with a supermarket, café, pizzeria, laundromat, and pharmacy all within a one-block radius. Whether you’re an investor or a homeowner looking for additional rental income, this charming home presents a fantastic opportunity.Property Features & Layou:t-1st Floor – Unit #1 Spacious 3-bedroom unit featuring a living room, eat-in kitchen, and 1 bath, with access to the finished basement and backyard.- 2nd Floor – Two separate units:Unit #2F – 1-bedroom, 1-bath with a living room and kitchen.Unit #2R – 2-bedroom, 1-bath with a living room and kitchen.- Basement – Fully finished, perfect for a duplex extension, home office, playroom, or additional storage, with direct access to the backyard and driveway.- Outdoor Space – Large backyard ideal for entertaining.- Parking – Private driveway for added convenience.- Lot Size – 32 &215; 100- Building Size – 20 &215; 50Easy Commuting & AccessibilityLocated in Middle Village, NY 11379, this property is in a prime location with seamless access to public transportation, major roadways, and all the essentials for modern city living.Featured Residential Sales.

ML# :3575552   Beautiful colonial in Merrick Woods completely updated in 2019. Spacious circular driveway with pavers in front and back. In ground pool with hot tub and waterfall plus gazebo and gas line to BBQ for entertaining. Gas fireplace in den and 4 oak flooring throughout. MBR en suite with WIC and terrace, second bedroom with terrace. Quartz countertop on huge island with Viking appliances. Security system, High end TDC steel front door. Custom window treatments will remain. Great house in a great area., Additional information: Appearance:Mint, Interior Features:Lr/Dr

ML# :3590436   Stunning Waterfront Colonial sits on a quiet Cul de Sac with spectacular views of the bay. Wrap around porch, large back yard with built in barbeque, paver patio and new bulkhead. This luxuroius home features impeccable finishes throughout, including gleaming hardwood floors, , 9ft. ceilings and crown molding. Open flow interior includes an entry foyer, spacious living room with gas fireplace, formal dining room and a custom kitchen and powder room. Upstairs, the masterbedroom suite includes a walk in closet, master bath with jetted tub and separate shower. 3 additional bedrooms and a hall bath. Central Vacuum, CAC, high hats throughout.Tons of storage, large attic. Close to train, shops, restaurants. This is truly a one of a kind!, Additional information: Appearance:Diamond The Seller is offering financing. 5% with 50% down on a 15 yr note.Also available to Rent for $8000 per month Tenant pays Utilities and Lawn maintenance.

ML# :873391   Welcome to this stately 3, 800 sq ft Colonial nestled on a shy one-acre lot in the heart of Hauppauge. Graced with a charming front porch and surrounded by mature trees and lush gardens, this home offers both privacy and scenic views of nature in every season. Step inside to a tiled entryway that leads to the kitchen featuring rich oak cabinetry, gleaming granite countertops, tiled backsplash, new fridge and range, and a separate breakfast area perfect for casual dining. Entertain effortlessly in the formal dining room, complete with custom built-in cabinetry, or host gatherings in the elegant living room, highlighted by a distinctive tray ceiling with accent lighting, gas fireplace and wet bar. Crown molding, recessed lighting and oak flooring throughout the home. With four oversized bedrooms and three beautifully renovated bathrooms, this home provides exceptional space and comfort for all who wish to call it home. The luxurious primary suite features a spa-inspired bath with a seated shower and custom finishes, The finished basement offers additional space which includes a dry bar. and drink fridge, and lots of storage. On the other side of the house is a legal accessory apartment with a kitchen, den w/gas fireplace, two more bedrooms and a full bath. Outdoors, enjoy a private oasis with a beautifully designed 20 X 40 new heated in-ground pool with an automatic pool cover. A tranquil new paved patio area, and vibrant gardens, and outdoor shower. Trex deck off kitchen great for grilling. A she-shed insulated and tastefully done, with a fenced in vegetable garden. Central AC with two units, inground sprinklers, solar with 51 panels fully owned, 200 Amp electrical service, two legal sheds, an open garage (roof over), fenced yard, huge driveway with plenty of parking. This property is surrounded by quiet, private unbuildable town owned neighboring lots on a cul-de-sac. Don’t miss your opportunity to own a truly remarkable home that blends timeless charm with modern amenities in a peaceful, sought-after area of Hauppauge!

ML# :878372   Wake up to stunning water views every morning in this exceptional Southampton home overlooking the pristine waters of Shinnecock Bay. This captivating residence offers the quintessential Hamptons lifestyle with panoramic bay vistas that will take your breath away.Gleaming hardwood floors flow seamlessly throughout the home while the open-concept design maximizes the spectacular water views from multiple rooms, allowing you to enjoy the ever-changing beauty of Shinnecock Bay from dawn to dusk.The main level features three to four well-appointed bedrooms and 1.5 bathrooms, providing comfortable accommodations for family and guests. Efficient natural gas heat keeps utility costs manageable during cooler months.The walk-out lower level presents incredible potential, offering generous space perfect for a recreation room, media center, or additional bunk room for guests. This flexible area expands your living and entertaining options while maintaining the home’s connection to the beautiful outdoor surroundings.A convenient two-car garage provides secure parking and storage, essential for Hamptons living. The proeprtys large back deck is great for entertaining large groups or simply enjoying spectacular sunsets from your own backyard.Located in prestigious Southampton, you’ll enjoy close proximity to world-class beaches, fine dining, boutique shopping, and cultural attractions that make the Hamptons a globally renowned destination.

ML# :894885   Welcome to this exceptional Colonial, gracefully set on a quiet cul-de-sac and nestled on a full acre of beautifully maintained land on a quiet tree-lined residential oasis in Huntington. From the inviting curb appeal to the thoughtfully updated interiors, this home offers the perfect balance of comfort, style, and functionality for today’s lifestyle. Step inside and enjoy spacious living across all levels, starting with the first floor’s well-appointed layout. The elegant formal living room and cozy family room provide ideal spaces for both entertaining and everyday relaxation. The beautifully updated kitchen features quartz countertops, stainless steel appliances, and a sliding glass door that opens directly to the backyard—creating a seamless connection between indoor and outdoor living.A convenient first-floor laundry room with access to the side yard, along with a stylishly updated powder room, adds both ease and refinement to daily living.Upstairs, you’ll find four generously sized bedrooms, including a serene primary suite complete with a walk-in closet and a large en-suite bath featuring a separate water closet and linen closet. The additional bedrooms are bright and spacious, sharing a well-maintained hall bathroom. Hardwood floors run through most of the home, complemented by tile in the foyer, kitchen, and bathrooms.One of the home’s most impressive and eco-friendly features is its fully owned solar panel system, connected to a Tesla Powerwall—providing backup power (acts as home generator) and an average monthly electric bill of just $17!Key Upgrades and Features: Fully owned solar panel system with Tesla Powerwall, New roof (2021), Two-zone central air conditioning system (2022), Hot water tank (2022), Security system (2020), Attached two-car garage, Full, spacious basement.The serene backyard opens up to a spacious side yard, offering endless possibilities for outdoor entertaining, play, or even a future pool. Ideally located close to the Village, local restaurants, parks, beaches, shopping, and more—this home offers the best of Long Island living in a peaceful, private setting. A detailed features sheet is available upon request. Don’t miss this incredible opportunity to make 7 Cumberland Ct your forever home—schedule your private showing today!