Walt-realtor.com Search Results

$1,149,999

Welcome to 358 Arleigh Road, a rare opportunity to own this charming home on a corner lot in the highly sought-after Douglaston Community within the prestigious Douglas Manor Association. This 3-bedroom, 2.5-bath home offers incredible potential for the right buyer looking to customize and create their dream home. Featuring a classic layout with generously sized rooms, hardwood floors, and abundant natural light, the home provides a solid foundation ready for your personal touch. The exterior boasts a beautiful yard with mature landscaping, perfect for outdoor entertaining or relaxation, along with an in-ground 6-zone sprinkler system for easy maintenance. A rear extension and enclosed porch add extra living space and versatility. Located just minutes from local transportation, major roadways, NYC access, parks, shopping, and dining, this home offers both convenience and lifestyle. As part of the exclusive Douglas Manor Association, residents enjoy access to private docks, beaches, playground, wildlife preserve, and 24-hour security—creating a true community feel unlike anywhere else in Queens. This property is being sold as-is and is an excellent opportunity for investors, builders, or buyers looking to renovate and add value in this premier location. Don’t miss your chance to own in one of Queens’ most desirable waterfront neighborhoods!

3 Beds ⋅ 3 Baths ⋅ 1029900 MLS

Welcome to 358 Arleigh Road, a rare opportunity to own this charming home on a corner lot in the highly sought-after Douglaston Community within the prestigious Douglas Manor Association. This 3-bedroom, 2.5-bath home offers incredible potential for the right buyer looking to customize and create their dream home. Featuring a classic layout with generously sized rooms, hardwood floors, and abundant natural light, the home provides a solid foundation ready for your personal touch. The exterior boasts a beautiful yard with mature landscaping, perfect for outdoor entertaining or relaxation, along with an in-ground 6-zone sprinkler system for easy maintenance. A rear extension and enclosed porch add extra living space and versatility. Located just minutes from local transportation, major roadways, NYC access, parks, shopping, and dining, this home offers both convenience and lifestyle. As part of the exclusive Douglas Manor Association, residents enjoy access to private docks, beaches, playground, wildlife preserve, and 24-hour security—creating a true community feel unlike anywhere else in Queens. This property is being sold as-is and is an excellent opportunity for investors, builders, or buyers looking to renovate and add value in this premier location. Don’t miss your chance to own in one of Queens’ most desirable waterfront neighborhoods!

358 Arleigh Road, Little Neck

$2,190,000

Welcome to a rare fusion of residential elegance and a contemporary masterpiece. Built in 2014, this 3,343 sq. ft. home is defined by its meticulous attention to detail, open-concept flow, and unexpected design touches that set it far beyond traditional new construction. Set on a sprawling 7,029 sq. ft. lot, this property offers ample outdoor space while maintaining a low-maintenance, sophisticated lifestyle. From the moment you step inside, hardwood floors run continuously throughout the main and upper levels—no carpet, no transitions—creating a seamless, warm, and visually expansive foundation. The open kitchen is both a work of art and a serious cooking space. Sleek, slab-style modern cabinetry stretches to the ceiling, offering abundant storage, while the full suite of Viking appliances—including a professional-grade gas range, stainless steel refrigerator, and vented hood—promises restaurant-quality performance. A large island anchors the space, perfect for casual dining or hosting. Adding to the home’s impressive functionality are two commercial-grade A/C units on the first floor, delivering powerful, zoned cooling and heating that ensure year-round comfort no matter the season. All bedrooms are genuinely oversized, each comfortably accommodating a king-sized bed with room left for nightstands and dressers. Two of these bedrooms feature private ensuites, finished with premium tile, floating vanities, and luxurious in-floor radiant heating. In total, three bathrooms feature heated floors, a coveted amenity that transforms cold mornings into a spa-like experience. Descend to the lower level, where a dedicated movie theatre awaits. Thoughtfully designed with plush seating, attached projector and screen, and dimmable lighting. The basement also offers flexible space for a gym or play area, while above, you’ll find living areas on both the first and second floors, giving you the rare flexibility of a formal parlor or second-floor family lounge. Step outside to enjoy two distinct outdoor escapes: a private balcony off one of the second floor, ideal for morning coffee, and a rear deck for grilling and al fresco dining. The exterior is clad in low-maintenance, ultra-durable James Hardie Fiber Cement siding, chosen for its resistance to moisture, fire, and pests. Perhaps the home’s most distinctive feature is the custom metal railing system—designed, fabricated, and installed by a welding company that typically builds roll cages and chassis components for race cars. These railings are not off-the-shelf. They feature precision welds, automotive-grade finishes, and a sleek, industrial aesthetic that complements the home’s contemporary lines. Every baluster and handrail feels engineered for strength and beauty. For total security and peace of mind, the property is monitored by a discreet network of 8 exterior security cameras, covering every approach, entrance, and blind spot. Whether you’re home or away, you remain in complete control. Location is everything, and this home delivers. You are just minutes from the Long Island Rail Road, making your commute to the city effortless and stress-free. And when it's time to unwind, enjoy proximity to nearby golf courses, perfect for weekend getaways or after-work tee times. This is not a cookie-cutter modern home. It’s a thoughtfully built, one-of-a-kind property where race-car precision meets everyday luxury.

3 Beds ⋅ 5 Baths ⋅ 1023335 MLS

Welcome to a rare fusion of residential elegance and a contemporary masterpiece. Built in 2014, this 3,343 sq. ft. home is defined by its meticulous attention to detail, open-concept flow, and unexpected design touches that set it far beyond traditional new construction. Set on a sprawling 7,029 sq. ft. lot, this property offers ample outdoor space while maintaining a low-maintenance, sophisticated lifestyle. From the moment you step inside, hardwood floors run continuously throughout the main and upper levels—no carpet, no transitions—creating a seamless, warm, and visually expansive foundation. The open kitchen is both a work of art and a serious cooking space. Sleek, slab-style modern cabinetry stretches to the ceiling, offering abundant storage, while the full suite of Viking appliances—including a professional-grade gas range, stainless steel refrigerator, and vented hood—promises restaurant-quality performance. A large island anchors the space, perfect for casual dining or hosting. Adding to the home’s impressive functionality are two commercial-grade A/C units on the first floor, delivering powerful, zoned cooling and heating that ensure year-round comfort no matter the season. All bedrooms are genuinely oversized, each comfortably accommodating a king-sized bed with room left for nightstands and dressers. Two of these bedrooms feature private ensuites, finished with premium tile, floating vanities, and luxurious in-floor radiant heating. In total, three bathrooms feature heated floors, a coveted amenity that transforms cold mornings into a spa-like experience. Descend to the lower level, where a dedicated movie theatre awaits. Thoughtfully designed with plush seating, attached projector and screen, and dimmable lighting. The basement also offers flexible space for a gym or play area, while above, you’ll find living areas on both the first and second floors, giving you the rare flexibility of a formal parlor or second-floor family lounge. Step outside to enjoy two distinct outdoor escapes: a private balcony off one of the second floor, ideal for morning coffee, and a rear deck for grilling and al fresco dining. The exterior is clad in low-maintenance, ultra-durable James Hardie Fiber Cement siding, chosen for its resistance to moisture, fire, and pests. Perhaps the home’s most distinctive feature is the custom metal railing system—designed, fabricated, and installed by a welding company that typically builds roll cages and chassis components for race cars. These railings are not off-the-shelf. They feature precision welds, automotive-grade finishes, and a sleek, industrial aesthetic that complements the home’s contemporary lines. Every baluster and handrail feels engineered for strength and beauty. For total security and peace of mind, the property is monitored by a discreet network of 8 exterior security cameras, covering every approach, entrance, and blind spot. Whether you’re home or away, you remain in complete control. Location is everything, and this home delivers. You are just minutes from the Long Island Rail Road, making your commute to the city effortless and stress-free. And when it's time to unwind, enjoy proximity to nearby golf courses, perfect for weekend getaways or after-work tee times. This is not a cookie-cutter modern home. It’s a thoughtfully built, one-of-a-kind property where race-car precision meets everyday luxury.

66-06 Marathon Parkway, Little Neck

$1,725,000

Welcome to 249-25 Cullman Avenue, a beautifully maintained brick home in Little Neck offering classic curb appeal, refined interior finishes, and flexible living space across multiple levels. A gated entry opens to a dramatic double-height foyer, setting the tone for the home’s light-filled layout, hardwood floors, crown molding, recessed lighting, and polished marble tile details. The main level features a formal living room with a gas fireplace, a formal dining room framed by bay windows, and a chef’s kitchen with an oversized center island, granite countertops, stainless steel appliances, custom cabinetry, and a detailed tile backsplash. Designed with an easy flow for everyday living and entertaining, this level is completed by a convenient powder room. Upstairs, the second level offers three versatile rooms, including a spacious primary suite with an en-suite full bathroom. The finished lower level provides additional flexible living space with a full bathroom and walk-out access. Outside, enjoy a private backyard with a deck, patio, pergola, and manicured landscaping. Additional highlights include central air conditioning, multi-zone European-style baseboard heating, Anderson windows, instant hot water, clay tile roof, private driveway, attached garage, and all-brick construction. Conveniently located near shopping, dining, parks, transportation, and the LIRR, this Little Neck home offers a polished blend of comfort, function, and accessibility in a desirable Queens location.

3 Beds ⋅ 3 Baths ⋅ 992485 MLS

Welcome to 249-25 Cullman Avenue, a beautifully maintained brick home in Little Neck offering classic curb appeal, refined interior finishes, and flexible living space across multiple levels. A gated entry opens to a dramatic double-height foyer, setting the tone for the home’s light-filled layout, hardwood floors, crown molding, recessed lighting, and polished marble tile details. The main level features a formal living room with a gas fireplace, a formal dining room framed by bay windows, and a chef’s kitchen with an oversized center island, granite countertops, stainless steel appliances, custom cabinetry, and a detailed tile backsplash. Designed with an easy flow for everyday living and entertaining, this level is completed by a convenient powder room. Upstairs, the second level offers three versatile rooms, including a spacious primary suite with an en-suite full bathroom. The finished lower level provides additional flexible living space with a full bathroom and walk-out access. Outside, enjoy a private backyard with a deck, patio, pergola, and manicured landscaping. Additional highlights include central air conditioning, multi-zone European-style baseboard heating, Anderson windows, instant hot water, clay tile roof, private driveway, attached garage, and all-brick construction. Conveniently located near shopping, dining, parks, transportation, and the LIRR, this Little Neck home offers a polished blend of comfort, function, and accessibility in a desirable Queens location.

249-25 Cullman Avenue, Little Neck

$1,990,000

Brand New Construction 2020 In The Heart Of Little Neck,This Custom Designed Contemporary 4 Bedrooms 5 Bathrooms. The Home Features A Modern Layout With Spacious Living Areas, Chef Inspired Kitchen With Custom Cabinetry And Stainless Steel Appliances, Hardwood Floor, Gas Cooking & Central AC & Heat System. This First Floor Open Concept Home Offers A Large Living room, Formal Dinning Room,Bathroom, Eat-In Kitchen with Breakfast Area, And Access To The Well-Maintained Backyard & Pavers Patio, The Added Space Of A Full Finished Basement Offering Endless Potential. All With Beautiful Hardwood Floors And Crown Molding As Well As To The Second Floor. Hand Crafted Custom Stairways & Motorized Chandelier Lead To Upstairs. On The Second Floor, You Will Find A Huge Primary Room With En Suite, A Second Bedroom With Full Bath, Two Additional Bedrooms, And A Third Bathroom. This Home Combines Styles, Comfort, And Functionality. Conveniently Located Near Parks, Schools, Shopping, And Transportations! Don't Miss The Opportunity To Make This Beautiful Home Yours.

4 Beds ⋅ 5 Baths ⋅ 990066 MLS

Brand New Construction 2020 In The Heart Of Little Neck,This Custom Designed Contemporary 4 Bedrooms 5 Bathrooms. The Home Features A Modern Layout With Spacious Living Areas, Chef Inspired Kitchen With Custom Cabinetry And Stainless Steel Appliances, Hardwood Floor, Gas Cooking & Central AC & Heat System. This First Floor Open Concept Home Offers A Large Living room, Formal Dinning Room,Bathroom, Eat-In Kitchen with Breakfast Area, And Access To The Well-Maintained Backyard & Pavers Patio, The Added Space Of A Full Finished Basement Offering Endless Potential. All With Beautiful Hardwood Floors And Crown Molding As Well As To The Second Floor. Hand Crafted Custom Stairways & Motorized Chandelier Lead To Upstairs. On The Second Floor, You Will Find A Huge Primary Room With En Suite, A Second Bedroom With Full Bath, Two Additional Bedrooms, And A Third Bathroom. This Home Combines Styles, Comfort, And Functionality. Conveniently Located Near Parks, Schools, Shopping, And Transportations! Don't Miss The Opportunity To Make This Beautiful Home Yours.

24814 Van Zandt Avenue, Little Neck

$1,990,000

Discover this rare and beautifully maintained detached 2-family home in the heart of Little Neck, offering a generous 52x 28.5 building size and a layout ideal for both end-users and investors. The first floor features 3 bedrooms, a full bathroom, dining room, and a bright living room. The 2nd floor offers 3 bedrooms and 2 full bathrooms, along with a spacious living room, kitchen, and a rear deck that leads down to the backyard. The basement has a separate entrance, offering flexible space ideal for storage, a recreation room and home office. The backyard provides abundant outdoor space, perfect for family gatherings, gardening, excellent setting for relaxation or entertaining. This property is close to buses, parks, district 26 schools, golf club, supermarkets, major highway like Long Island expressway, easy commute to both Flushing and Long Island. There are express buses direct to manhattan and City Hall.

6 Beds ⋅ 3 Baths ⋅ 988006 MLS

Discover this rare and beautifully maintained detached 2-family home in the heart of Little Neck, offering a generous 52x 28.5 building size and a layout ideal for both end-users and investors. The first floor features 3 bedrooms, a full bathroom, dining room, and a bright living room. The 2nd floor offers 3 bedrooms and 2 full bathrooms, along with a spacious living room, kitchen, and a rear deck that leads down to the backyard. The basement has a separate entrance, offering flexible space ideal for storage, a recreation room and home office. The backyard provides abundant outdoor space, perfect for family gatherings, gardening, excellent setting for relaxation or entertaining. This property is close to buses, parks, district 26 schools, golf club, supermarkets, major highway like Long Island expressway, easy commute to both Flushing and Long Island. There are express buses direct to manhattan and City Hall.

251-43 57th Avenue, Little Neck

$269,000

Welcome to the stunning Valerie Arms Building, located in the desirable Little Neck area. This updated one-bedroom apartment, situated on the top floor, offers breathtaking bay and bridge views. This apartment features a spacious living room, bedroom, bathroom, and a kitchen equipped with a dishwasher, and a separate dining area. It offers plenty of natural light and ample closet space. The well-maintained building provides excellent amenities including elevator access, 24-hour security, a gym, two laundry rooms, a pool, a deck, courtyard, and easy parking for residents and guests. Conveniently located nearby shopping at Little Neck Plaza, transportation, places of worship, restaurants and hospitals. This CO-OP is also close to Manhattan, Long Island, and local airports.

1 Beds ⋅ 1 Baths ⋅ 956137 MLS

Welcome to the stunning Valerie Arms Building, located in the desirable Little Neck area. This updated one-bedroom apartment, situated on the top floor, offers breathtaking bay and bridge views. This apartment features a spacious living room, bedroom, bathroom, and a kitchen equipped with a dishwasher, and a separate dining area. It offers plenty of natural light and ample closet space. The well-maintained building provides excellent amenities including elevator access, 24-hour security, a gym, two laundry rooms, a pool, a deck, courtyard, and easy parking for residents and guests. Conveniently located nearby shopping at Little Neck Plaza, transportation, places of worship, restaurants and hospitals. This CO-OP is also close to Manhattan, Long Island, and local airports.

54-40 Little Neck Parkway Unit #6M, Little Neck

$4,280,000

A High-End Custom Resort Style Modern Mansion in Little Neck. Welcome to an extraordinary custom mansion, built in 2016, in the prestigious Little Neck area, where architectural vision meets uncompromising luxury on an expansive 11,520 sq ft lot (60x198). This 5,640 sq ft masterpiece begins with a breathtaking 20-foot grand foyer that sets the tone for unparalleled craftsmanship throughout. The coffered ceiling living room and formal dining room create sophisticated entertaining spaces, with oversized windows flooding each room with natural light. At the heart of this resort-style sanctuary lies your crown jewel—a magnificent 400 sq ft climate-controlled indoor heated pool with humidifier, delivering year-round aquatic luxury. The culinary experience reaches new heights with a custom Cambridge kitchen showcasing premium Wolf and Sub-Zero appliances, complemented by a secondary service kitchen that ensures effortless entertaining for any occasion. Comfort is elevated to an art form through ten-zone radiant floor heating, eight-zone central air, and centralized fresh air circulation with 24-hour filtration throughout every corner of this architectural marvel. Indoor and outdoor living merge seamlessly through a stunning gazebo-style sunroom that opens to your lush backyard oasis, complete with a built-in DSC BBQ set for the ultimate alfresco dining experience. Exceptional craftsmanship reveals itself in every detail—from floor-to-ceiling stonework and rich engineered hardwood to the distinctive Welsh slate roof and elegant copper gutters. Your personal wellness retreat features an authentic Canadian cedar sauna, therapeutic soaking Jacuzzi tub, and a glass-enclosed double shower with commercial-grade Hansgrohe systems, creating a spa-inspired bathroom that rivals the world's finest resorts. Entertainment reaches cinematic heights in your dedicated 7-seat home theater, where leather recliners face a commanding 120-inch screen powered by 1,240 watts of premium audio-visual technology. The formal wine cellar satisfies the most distinguished connoisseur while enhancing daily living with sophisticated storage for your finest vintages. Thoughtful luxury extends throughout with an integrated 12-zone music system, central vacuum convenience, and dual laundry rooms for seamless daily living. The grand, curved staircase, adorned with bespoke iron railings, serves as a stunning architectural focal point, while energy efficiency is maximized through the use of spray foam insulation. Quaker windows and doors frame picturesque views while flooding interiors with natural beauty. The fully finished basement expands your living possibilities with an additional 1,800+ sq ft of entertainment space, while a two-car garage provides practical luxury. This architectural masterpiece transcends ordinary luxury living, creating a private resort where every carefully crafted detail serves both beauty and function—the ultimate expression of modern sophistication and refined comfort.

5 Beds ⋅ 6 Baths ⋅ 896180 MLS

A High-End Custom Resort Style Modern Mansion in Little Neck. Welcome to an extraordinary custom mansion, built in 2016, in the prestigious Little Neck area, where architectural vision meets uncompromising luxury on an expansive 11,520 sq ft lot (60x198). This 5,640 sq ft masterpiece begins with a breathtaking 20-foot grand foyer that sets the tone for unparalleled craftsmanship throughout. The coffered ceiling living room and formal dining room create sophisticated entertaining spaces, with oversized windows flooding each room with natural light. At the heart of this resort-style sanctuary lies your crown jewel—a magnificent 400 sq ft climate-controlled indoor heated pool with humidifier, delivering year-round aquatic luxury. The culinary experience reaches new heights with a custom Cambridge kitchen showcasing premium Wolf and Sub-Zero appliances, complemented by a secondary service kitchen that ensures effortless entertaining for any occasion. Comfort is elevated to an art form through ten-zone radiant floor heating, eight-zone central air, and centralized fresh air circulation with 24-hour filtration throughout every corner of this architectural marvel. Indoor and outdoor living merge seamlessly through a stunning gazebo-style sunroom that opens to your lush backyard oasis, complete with a built-in DSC BBQ set for the ultimate alfresco dining experience. Exceptional craftsmanship reveals itself in every detail—from floor-to-ceiling stonework and rich engineered hardwood to the distinctive Welsh slate roof and elegant copper gutters. Your personal wellness retreat features an authentic Canadian cedar sauna, therapeutic soaking Jacuzzi tub, and a glass-enclosed double shower with commercial-grade Hansgrohe systems, creating a spa-inspired bathroom that rivals the world's finest resorts. Entertainment reaches cinematic heights in your dedicated 7-seat home theater, where leather recliners face a commanding 120-inch screen powered by 1,240 watts of premium audio-visual technology. The formal wine cellar satisfies the most distinguished connoisseur while enhancing daily living with sophisticated storage for your finest vintages. Thoughtful luxury extends throughout with an integrated 12-zone music system, central vacuum convenience, and dual laundry rooms for seamless daily living. The grand, curved staircase, adorned with bespoke iron railings, serves as a stunning architectural focal point, while energy efficiency is maximized through the use of spray foam insulation. Quaker windows and doors frame picturesque views while flooding interiors with natural beauty. The fully finished basement expands your living possibilities with an additional 1,800+ sq ft of entertainment space, while a two-car garage provides practical luxury. This architectural masterpiece transcends ordinary luxury living, creating a private resort where every carefully crafted detail serves both beauty and function—the ultimate expression of modern sophistication and refined comfort.

264-11 60th Avenue, Little Neck