Search Results

150-07 Northern Boulevard Flushing, NY 11354

$3,800,000

10 Bedrooms 8 Full Baths

Multi Family For Sale ML# 3536132

2005-built, prime location mixed-use building situated in the bustling neighborhood of Flushing, NY along busy main throughway Northern Blvd. This well-maintained property consists of a ground-floor retail space occupied by a long standing pharmacy with long term lease in place. Basement is an internet cafe w lease till 2026. Four upper floor residential free-market rental apartments: two 3-bedroom, 2-bathroom units and two duplex 2-bedroom, 2-bathroom units. The property has a strong and long-term tenant base, with good-paying tenants and almost never had any vacancy. Rents can go up at next renew. The building is easy to manage and well-maintained, providing a hassle-free investment opportunity for potential buyers. Flushing is a rapidly growing neighborhood, known for its diverse culture and thriving business district. This mixed-use property presents a significant appreciation potential, as the area continues to develop and attract new businesses and residents.

Presented By: Fultonex Realty LLC 718-395-8266

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

2

93 Gatsby Lane Great Neck, NY 11024

$3,800,000

Single Family For Sale ML# 3507806

An Expansive acre of prime property, located on one of the most sought after streets in the Village of Kings Point. Perfect opportunity to build on Gatsby Lane.

Presented By: Daniel Gale Sothebys Intl Rlty 516-466-4036

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

36

465 Ripple Water Lane Southold, NY 11971

$3,799,999

4 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 6366.00:# Square Feet

Single Family For Sale ML# 3555160

Welcome to your bespoke farmhouse retreat nestled in the serene beauty of the North Fork of Long Island. This custom-crafted home offers an unparalleled blend of luxury, comfort, and tranquility, enveloped by a meticulously designed landscape that creates a secluded oasis. Approaching the property, you’re greeted by a custom landscape package featuring Belgian block pathways, crushed pea gravel, and towering 20-ft established trees and shrubs, evoking a sense of timeless elegance and privacy. Exterior lighting gracefully illuminates the walkways and architectural details, while wall wash cove lighting on the masonry-covered porch casts a gentle glow over the pool area, inviting you to unwind in its serene ambiance. Step into the enclosed backyard to discover a sanctuary of relaxation and entertainment, complete with elegant blue stone paths, a spacious entertaining patio, and an in-pool lounge deck with dual umbrella stands. A mesmerizing masonry water feature adds a touch of sophistication, while the in-pool beverage bench ensures refreshments are always close at hand. The rear of the house has been thoughtfully designed with architectural elements that tell a captivating story from every angle, creating a visual masterpiece that complements the surrounding landscape. Approach the double entry wood doors to find an oversized masonry sitting porch, perfect for indulging in weekend morning coffee conversations or simply soaking in the tranquil surroundings. Inside, the home boasts luxurious amenities at every turn. Off the foyer, a large den with custom cabinetry provides a peaceful retreat, while the two-story living room serves as the heart of the home, anchored by a granite fireplace and bathed in natural light. The professional kitchen is a chef’s dream, featuring a Kohler pre-rinse faucet, a 45 inch workstation sink with sound deadening technology, and custom lighting that highlights the island and cabinet details. The open floor plan seamlessly flows into the dining space, offering stunning views of the yard, pool, and covered porch. A mudroom with slate plank floors and shoe lockers in the custom designed cabinetry leads to the laundry room, complete with a deep stainless steel sink, slide out laundry baskets for each of the four bedrooms and a pet washing station. The main floor suite boasts an elegant walk-in closet and a luxury bath fitted with a Toto washlet toilet, a freestanding soaking tub, and a roll-in shower. Upstairs, each bedroom offers ceiling details and attached bathrooms, while the custom open staircase leads to a finished basement featuring a movie theater, a home office space, and a beverage center. The walk-out basement opens to a covered cocktail patio and bluestone path leading to the pool deck. Located in a waterfront community with direct access to Goose Creek sandy beach, this home offers the ultimate retreat for those seeking luxury and tranquility on the North Fork. Don’t miss your chance to experience the epitome of North Fork living.

Presented By: Century 21 Albertson Realty 631-765-3800

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

23

90 Soundview Drive Montauk, NY 11954

$3,799,500

2 Bedrooms 2 Full Baths Sq. Ft. 1150.00:# Square Feet

Single Family For Sale ML# 3570443

Presented By: Douglas Elliman Real Estate 631-668-6565

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

36

6 Summit Place Malba, NY 11357

$3,799,000

6 Bedrooms 6 Full Baths 1 Half Bath Sq. Ft. 5848.00:# Square Feet

Single Family For Sale ML# 3533365

Welcome to your dream home in the heart of Malba, Queens! This stunning brick colonial captures the essence of its era with timeless details and charm. Step inside and you’re greeted by a spacious entry foyer, the open concept layout ensures each room flows seamlessly into the next, making every space feel stately and inviting. Imagine cozying up in the grand formal living room, complete with a wood-burning fireplace that adds warmth and character to your gatherings. The kitchen is a chef’s delight, offering ample space for cooking and dining in a relaxed setting. Adjacent to it, the formal dining room, also featuring a wood-burning fireplace, is perfect for memorable dinners with friends and family. Upstairs, the master bedroom is a true retreat, boasting an en-suite bathroom and French doors that open to a spacious balcony. It’s the perfect spot to enjoy your morning coffee or unwind after a long day. Three additional bedrooms, each complete with a full bathroom and walk-in closet. The home’s architectural centerpiece is the grand double-height staircase, crowned with a skylight that bathes the space in natural light, highlighting the elegant one-piece design and leading to the expansive lower level. The walk-out lower level unveils a haven for relaxation and entertainment. With its own separate entrance-featuring a spa with a steam room, sauna, and hot tub, alongside a huge recreation room and an additional sitting area - ideal for hosting or accommodating extended family. Every detail has been thoughtfully considered, including new Pella windows throughout that ensure comfort and efficiency. Step outside to the beautifully landscaped backyard with an in-ground pool. Whether you opt for a cabana or a 4-car garage, the outdoor space promises a blend of luxury, functionality, and tranquility for relaxation and fun. This home isn’t just a place to live; it’s a lifestyle waiting to be embraced. This Malba gem is the perfect backdrop for your family’s next chapter.

Presented By: BERKSHIRE HATHAWAY 516-741-3070

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

30

2700 Main Rd Laurel, NY 11948

$3,795,000

5 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 2380.00:# Square Feet

Single Family For Sale ML# 3575441

This property truly is a fantastic opportunity to have boutique winery or create a private estate that produces its own wine label. With its established vineyards, ample living spaces, and multiple structures, it offers a unique chance to step into the world of winemaking with a solid foundation. Whether you’re dreaming of producing your own wines or creating a serene estate surrounded by vineyards, this property is well-equipped to fulfill those ambitions. The North Fork, known for its fertile soil and favorable climate for vineyards. Nearly 13 acres of land, Large Barn - Potential for winery operations, storage, or event space, 5-Bedroom - Farmhouse Could serve as a primary residence, guest house, or rental, 4-Bedroom - House Additional living space, rental property, or guest accommodations, Multiple Outbuildings - Could be used for tasting room, equipment storage, workshops, or additional event space. Vineyard Details: Varietals Planted, Merlot-2 acres, Cabernet Franc- 2 acres, Pinot Noir-1 acre, Pinot Grin-1 acre, Sauvignon Blanc- 2 acres, Chardonnay-1 acre, Moscato- 1 acre, Irrigation, Drip irrigation system in place, ensuring efficient water use and healthy vines, Vine spacing: 4 feet, Row spacing: 8 feet. This setup is ideal for someone looking to enter the wine industry. The combination of established vineyards, residential and operational buildings, make it a unique opportunity.

Presented By: Corcoran 631-235-4675

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

31

4 North Haven Way North Haven, NY 11963

$3,795,000

4 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 5959.00:# Square Feet

Single Family For Sale ML# 3575321

Welcome to 4 NORTH HAVEN WAY (10 Sunset Beach Road), a stunning property for sale within the prestigious North Haven Point community private beach access tennis courts etc... The 2+/- acres site features a 4-bedroom, 4.5 bath, enormous bonus room second floor 5, 959+/- sf traditional home with pool, manicured landscape with mature plantings, and an attached 2-car garage. Only moments from community tennis courts, and a private beach. The inviting, open layout includes a spacious great room with a cozy fireplace, a gourmet kitchen equipped with high-end appliances, a charming breakfast nook/dining area and elegant formal living and dining spaces perfect for entertaining. The home offers two spacious primary suites with new bathrooms, one conveniently located on the main floor, along with two additional guest bedrooms. There’s also a versatile bonus room ideal as a serene office space. The lower level is a highlight, over 1, 500 sf of finished space featuring entertainment room, game room, and a full bath. Outside, the property truly shines. A relaxing screened porch overlooks the heated gunite saltwater pool, new hot tub, sprawling terrace and a firepit area-all within this private nearly 2-acre oasis. The North Haven Point waterfront community offers homeowners access to a bay beach, tennis courts, and miles of walking trails. The location is unbeatable, with easy access to Sag Harbor Village, Shelter Island, and other popular Hamptons destinations. A perfect blend of luxury, comfort, and convenience in a beautiful and luxurious community setting.

Presented By: Brown Harris Stevens Hamptons 631-537-2727

Call Today: 516-867-3508, or Email: Weichert Realtors Quality Homes

36

11 Piping Brook Lane North Castle, NY 10506

$3,795,000

5 Bedrooms 3 Full Baths 2 Half Baths Sq. Ft. 6867.00:# Square Feet

Single Family For Sale ML# H6322008

Spectacular and flawlessly renovated with all the permits & Certificates of Compliance(2024) - Exquisite ultra-modern home with unsurpassed quality and aesthetics. Foyer, living room with sleek gas fireplace & a water feature, gorgeous dining area flows from the splendid kitchen. Sliding doors and large windows add an open feeling to the home. Also on this level, find a luxurious first-floor primary suite with a gas fireplace, a spacious custom dressing room, and a sprawling spa-like bath. On the other side of the home, find a guest bedroom, with an ensuite bath, laundry, and kitchenette. THE KITCHEN: a breathtaking heart of the house, with high-end appliances, Valcucine Italian cabinetry & granite peninsula with seating, opens to a den with a fireplace & a wet bar. Multiple sliding glass doors leading a Fiberon deck stretching the length of the house, with a built-in grill & pizza oven, icemaker & refrigerator. Lounge area with an outdoor fire pit, and full-size daybed. UPPER LEVEL: loft/office, three bedrooms, & luxurious hall bath with double vanity. LOWER LEVEL: Finished & walk-out; offering a well-equipped gym, wine area, powder room, fabulous storage & full laundry. Excellent location in Byram Hills School District. Exceptional resort-like private property located in a cul de sac with a Gunite salt-water pool, children’s play-set, and flat backyard are ideal for entertaining.

Presented By: Compass Greater NY, LLC 914 2380676