ML# :839971   Location location location. Downtown Flushing, convenience all, public transportation, restaurant, school and supermarket, Kissena park, 18 years new brick semi detached construction, fenced yard, private driveway, balcony and more, available a s a package deal with two multi-family and office properties located at 142-05 45 Ave, Flushing NY, The first floor can be Medical office and combined with 142-05 45Ave, Flushing NY have 3000 sf parking space.

ML# :839956   Location location location. Downtown Flushing, convenience all, public transportation, restaurant, school and supermarket, Kissena park, 18 years new brick semi detached construction, fenced yard, private driveway, balcony and more, available a s a package deal with two multi-family and office properties located at 142-05 45 Ave, Flushing NY, The first floor can be Medical office and combined with 142-05 45Ave, Flushing NY have 3000 sf parking space.

ML# :3590937  

ML# :3584869   In the heart of Corona, most busy and prime location. Mixed Use property. One store (Laundramot) and three apartments (1x_3bedrooms, 2 full baths and 2X_1bedroom). Most convenient, close to everything including 10-minute walk to the 7 train on Roosevelt Ave., Building Size:26.03 ft x 38.50

ML# :922082   Large Tudor home 4-5 bedrooms 3 full bath 1 half bath with very large corner lot parking for 10 cars. A must see.

ML# :913680   Fully renovated 2023, move-in ready garden SFH with sunroom. Lush front/back landscaping, lotus pond, grape trellis, pergola, cobblestone paths. Main-level 1BR/1BA + spa-size double marble tub. Upstairs 3BR/2BA. Pristine versatile basement. As a resident of Great Neck Estates you will have access to the Waterfront Park, offering an Olympic-sized swimming pool, kiddie pool, children’s playground, indoor and outdoor tennis courts, baseball and soccer fields, basketball and handball courts, ball field, docks, mooring, community events, summer camp, and more. *CHOICE OF GREAT NECK NORTH OR GREAT NECK SOUTH.Beyond academics, Great Neck offers a vibrant and diverse community. Families here value culture, education, and growth. The area is home to renowned libraries, arts programs, community centers, and athletic clubs, providing children with opportunities for all-around development in a nurturing, multicultural environment.This elegant residence features spacious interiors with abundant natural light. Gourmet kitchen, refined living areas, and expansive outdoor space make it ideal for both family living and entertaining.Convenient LocationJust 3 minutes to the Great Neck LIRR station, with express trains to Midtown Manhattan in 30 minutes.Close to Great Neck Plaza, offering fine dining, shops, and markets.General Tax:1, 701.03 , Village Tax:6, 492.34 , School Tax:13, 739.82

ML# :920071   Set on 10 private acres with sweeping mountain views from nearly every room, 69 Cedar Pond is a five-bedroom, eight-bath estate that exemplifies expansive design and contemporary style. The striking A-frame architecture, double-height windows, and soaring ceilings create dramatic, light-filled interiors where every angle frames the surrounding landscape and sunsets.A three-story entry sets the tone, leading into an open great room anchored by a statement fireplace. Walls of glass blur the line between indoors and out, opening to an 1, 800 sq ft deck that wraps the home with extraordinary vistas and flows seamlessly to an outdoor bar, dining, and lounge area with fire pit—perfect for entertaining on a grand scale.Expansive spaces continue throughout the main level, which offers two bedrooms with luxurious en suite baths, a powder room, a chef’s kitchen, a dining area, and a breakfast nook. Upstairs, the primary suite is generously scaled, with sweeping views and a spa-like bath featuring a soaking tub, private water closet, and double vanity. This level also includes an additional bedroom and a fully renovated guest wing with its own kitchen, great room, bedroom, bathroom, private balcony, and separate exterior entrance for added privacy.The versatile lower level includes a family room, gym, two bedrooms, a wet bar, and walk-out access to the property’s outdoor amenities.Every major element has been thoughtfully upgraded—new roof (2020), mechanicals and electrical (2019), furnace (2019), luxury baths (2021), and kitchen appliances. Despite its impressive scale, energy-efficient systems keep the home comfortable and remarkably cost-effective.The 10-acre property is as versatile as the home itself: enjoy private hiking trails, host open-air gatherings, or create a resort-style retreat with a pool, tennis court, or gardens. Nearby vineyards, ski slopes, and Hudson Valley attractions complete the lifestyle.

ML# :917019   Discover Serenity at a Sunnyside Gardens SanctuaryWelcome to a magnificent escape: a three-level, five-bedroom, three-bathroom townhouse perfectly situated in the historic Sunnyside Gardens landmark district. Set on a generous 25’ x 100’ lot, this home isn’t just a residence; it’s a tranquil, green sanctuary, offering a peaceful refuge from the city’s intensity.Versatile Living and Private RetreatsThis exceptionally spacious home is configured for maximum flexibility across its distinct levels:First Floor: Features a welcoming foyer, a formal living room and dining room, a kitchen, and two full bedrooms. The Master Bedroom provides a lovely direct flow to a private patio to enjoy the courtyard, an ideal spot for outdoor entertaining and quiet relaxation.Second Floor: Accessible via a vestibule, this level includes a second formal living room, an eat-in kitchen, a full bathroom, and two more bedrooms.Third Level Potential: The second floor offers access to a high-ceiling attic—a space ripe with potential for development into a luxurious master bedroom suite.Walk-in Basement: This fully usable, high-ceiling level is currently configured with a recreation room, a bathroom, bedroom facilities, a separate laundry area, storage, and a utility room. It includes a convenient private rear exit connecting directly to the main courtyard.The home features a gas heating system with two boilers and two hot water heaters. Each floor has its own thermostat , giving the occupiers full control over the temperature on every level.Unbeatable Location and Exclusive AmenitiesThis property effortlessly combines quiet living with ultimate city convenience:Exceptional Tranquility: Enjoy an astonishing level of peace on 45th Street (between 39th and 43rd Avenues). This block is specifically designed with little to no through traffic, ensuring the home remains extremely quiet and silent inside, creating a truly serene, suburban-like living experience.Effortless Commute: Despite the quiet setting, the city is within easy reach. You’re just a short 15-minute ride to Midtown Manhattan and the United Nations via the #7 train. Excellent connectivity is further provided by the Q-32 & Q-60 bus lines on Queens Boulevard, offering simple access to Brooklyn and other boroughs.Vibrant Community: The surrounding area boasts a lively neighborhood vibe, with international restaurants, charming pubs, cafes, 24-hour supermarkets, and houses of worship all nearby.Exclusive Park Access: As a future owner, you gain membership to the private Sunnyside Gardens Park, granting access to unique amenities like bicycle tracks, skate ramps, tennis courts, and picnic areas.Don’t let this unique opportunity pass you by! Embrace the joy of living in a historically rich, convenient, and wonderfully tranquil home. This isn’t just a house; it’s your escape.

ML# :910967   Spacious and beautifully designed, this 4-bedroom, 3.5-bath home offers comfort, style, and convenience throughout. The main floor features a bright and open layout, seamlessly connecting the living and dining area with an open kitchen adorned with beautiful countertops and modern finishes. A convenient half bath is located on the first level for guests.Upstairs, you’ll find a luxurious master suite along with two additional full bathrooms, providing comfort and privacy for the whole family. The finished basement includes another full bath, offering versatility for use as a recreation space, guest suite, or home office.Additional features include a 1-car attached garage for added convenience and storage. With its thoughtful layout and premium finishes, this home is move-in ready and perfect for modern living.

ML# :909841   Set against the backdrop of the stunning North Fork, this brand-new luxury home in Cutchogue offers the perfect mix of sophisticated design and laid-back coastal living. Just minutes from renowned wineries, farm-to-table restaurants, and some of Long Island’s most beautiful beaches, this 5-bedroom, 4-bathroom gem invites you to enjoy the best of both worlds.The heart of the home is the expansive great room, where large windows flood the space with natural light, creating a warm and inviting atmosphere. This open layout flows seamlessly into a spacious dining area and a chef’s kitchen—a true focal point of the home. With a large center island, custom cabinetry, and quartz countertops, it’s a perfect place for both everyday meals and entertaining guests.The first-floor primary suite offers a serene retreat, with a spa-inspired bathroom that includes a soaking tub and a rain shower, as well as ample closet space for ultimate convenience. The thoughtful design and attention to detail are evident throughout, from the elegant oak hardwood floors to the custom tile work in the bathrooms.Outside, the home is beautifully surrounded by lush, manicured landscaping, offering the ideal setting for outdoor entertaining or simply relaxing on the front or back porch. Whether you’re enjoying the local wine country or unwinding in your private sanctuary, this home provides the perfect space to do it all.With its perfect blend of luxury, location, and lifestyle, this Cutchogue beauty is ready to welcome its new owner. Don’t miss the chance to experience a new level of comfort and sophistication on the North Fork.Whether you’re hosting guests or seeking a peaceful escape, this home delivers timeless design, high-end craftsmanship, and unbeatable access to all that makes the North Fork a premier destination.Pool permit document available upon request.By appointment only. This is new construction - Tax Rates are still being formulated for 2026. 2026 taxes are estimated to be 10, 500.All info is deemed reliable but not guaranteed and should be independently verified by the buyer.