A Rare Find in Upper Ditmars East Elmhurst
This is not your average home for the area. Newly constructed and fully detached, this single-family residence offers over 3,300 sq ft of luxury living in one of Queens’ most desirable neighborhoods. What truly sets it apart? Ultra-low taxes — just $5,226 annually — nearly unheard of for a property of this size and caliber.
From the moment you enter inside, you’re greeted by a stunning glass wine cellar entry and an open layout flooded with natural light. The designer kitchen is equipped with Wolf and Subzero appliances, quartz countertops, pot filler, warming drawer, and Cove dishwasher with water softener. Additional highlights include porcelain floors, Mitsubishi heating/cooling, Sonos surround sound, Pella windows, gas fireplace, and coffered ceiling in the primary suite.
Enjoy spa-inspired bathrooms with LED mirrors featuring dimmers, clocks, defoggers, USB outlets, and built-in cosmetic lighting. A finished basement with private entrance, full laundry room, attic space, and custom closets add convenience and versatility.
Step outside to your private 12x32 heated saltwater pool with waterfall, surrounded by professional landscaping and outdoor lighting — a true backyard oasis.
Close to Ditmars Blvd, shopping, parks, schools, and transit. Zoned R4. This is a rare, turnkey opportunity that blends elevated design with unbeatable value.
Listing Courtesy of BROOKLYN / Century 21 Awaye Realty / Bute Mehaj
$1,485,000
Astoria Area
Active
2138 29th Street Astoria, NY 11105
4 Bed
4 Baths
1728 sqft
MLS# 491052
Exceptional investment opportunity in the heart of Astoria’s sought-after Ditmars neighborhood. This two-family home features two spacious units, each offering private outdoor space— a patio for the first-floor unit and a balcony for the second.
The property will be delivered fully occupied and is being sold as is, with buyers expected to assume the current tenancies. With rental income already in place, it’s an ideal option for investors seeking immediate cash flow in one of Queens’ most competitive markets. Zoned R5B, the property also presents potential for future redevelopment or expansion, subject to zoning regulations.
Just moments from Astoria Park, the waterfront, and the lively dining and shopping scene along Ditmars Boulevard. Enjoy seamless access to the N and W subway lines for an easy commute into Manhattan.
Showings by appointment only.
Listing Courtesy of BROOKLYN / Century 21 Awaye Realty / Bute Mehaj
$965,000
Rossville Area Singe Family Home
Active
24 Harris Lane Staten Island, NY 10309
4 Bed
4 Baths
3485 sqft
MLS# NMLEBCVFTJXLS
Builder's Special - New Construction!
Welcome to your brand-new home in the heart of Rossville! This semi-detached, 2-story residence is part of an exclusive collection of 12 newly developed homes, designed for modern living with a touch of luxury.
Upon arrival, you'll be welcomed by a charming covered porch that opens into a spacious dining room, conveniently located next to a powder room. The open-concept design connects the dining area with a stylish kitchen and a cozy living room—ideal for gatherings or daily relaxation. The kitchen is crafted for the culinary enthusiast, featuring custom cabinetry, premium appliances, and upscale finishes. High ceilings and wood-look tile floors with radiant heating ensure warmth and comfort on the main floor. The light-filled living room opens to a wooden deck with stairs leading to your private backyard—perfect for outdoor enjoyment.
Upstairs, the second level offers three spacious bedrooms, including a primary suite at the back of the home with vaulted ceilings, dual walk-in closets, and a luxurious en-suite bathroom. Two additional bedrooms share a well-appointed full bathroom, and a dedicated laundry room completes this level. Elegant hardwood flooring adds a touch of refinement throughout.
A full-height finished attic provides additional storage, while the expansive lower level features a full bathroom, a second washer/dryer, and 8-foot ceilings, ideal for a recreation room or an in-law suite. Radiant heating and matching tile from the first floor add a seamless look and feel. A separate entrance offers direct access to the outdoors.
Outside, enjoy the convenience of a two-car parking pad, private driveway, and an expansive landscaped yard (28×50), perfect for outdoor activities and gatherings. Each home in this community boasts vibrant siding with stone accents, offering curb appeal with a unique touch. Conveniently l
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$27,500 / mo
Grand Tier 3 Bedroom
Active
Address Not Disclosed Manhattan, NY 10023
3 Bed
4 Baths
sqft
MLS# NMLIKHMYXXHFL
Enjoy your own private 1,200 sq. ft. terrace, a spacious living and dining area, and all the features that make this the ideal family home. Outfitted with GE Monogram stainless steel appliances, a built-in bar, and numerous custom details, this residence boasts a luxurious primary suite with a four-piece marble bathroom. Located in a full-service building, you’ll have access to a 55' pool, fitness center, and a lounge with an additional terrace. The building also offers 24-hour garage access with electric vehicle charging stations and is pet-friendly.
#175342
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$14,950 / mo
The Pierrepont Luxury Rental
Active
Address Not Disclosed Brooklyn, NY 11201
3 Bed
2 Baths
sqft
MLS# NMLUDINYFOSHY
#1859618
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$14,656 / mo
West Wharf Luxury Rental
Active
Address Not Disclosed Brooklyn, NY 11222
3 Bed
3 Baths
sqft
MLS# NMLXLUQQBLUOH
Move in by 11/15 and get 6 weeks free!
This stunning corner 3-bed, 2.5-bath penthouse features panoramic East River and Manhattan views, a balcony, and luxury finishes throughout—including 10-foot floor-to-ceiling windows, chevron oak floors, and a spa-like primary bathroom with custom double-vanity, soaking tub, and walk-in shower. Enjoy a design-forward kitchen with a waterfall island and spacious living areas with abundant natural light.
Building Perks:
Residences: Studio to 3-bed layouts, private balconies (select units), keyless entry, in-unit washer/dryer, and premium appliances.
Harbor House Amenities: Indoor and outdoor pools, fitness center, yoga studio, basketball court, golf simulators, bowling alley, kids’ playrooms, spa, pet grooming, co-working hub, and more.
Outdoor Spaces: Rooftop pool, BBQ area, esplanade park, and stunning Manhattan skyline views.
Conveniences: 24/7 concierge, bike storage, valet, parking with EV stations, and easy public transit access to G, L, buses, and NY Ferry.
Experience premier waterfront living at West Wharf in the heart of Brooklyn’s vibrant Greenpoint and Williamsburg neighborhoods.
#2103196
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$7,985 / mo
Beautiful 3 BDR Unit in LIC
Active
Address Not Disclosed Long Island City, NY 11109
3 Bed
2 Baths
sqft
MLS# NMLDVUNECLSKB
#1321390
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$7,642 / mo
Long Island City's newest luxury rental
Active
Address Not Disclosed Long Island City, NY 11101
3 Bed
2 Baths
sqft
MLS# NMLJUSAUUTLJS
#2101262
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$6,787 / mo
Court Square Stunning Rental
Active
Address Not Disclosed Queens, NY 11101
2 Bed
2 Baths
sqft
MLS# NMLZWDNCLBBAX
Be the first to enjoy this beautiful 2-bedroom apartment with a private balcony! Featuring premium finishes throughout, the apartment includes expansive floor-to-ceiling windows, natural oak wood floors, and a gourmet kitchen with full-sized stainless steel appliances, a gas range, and an eat-in bar. The primary bedroom offers a walk-in closet and en-suite bath, plus the convenience of an in-unit washer/dryer. Thoughtful details include a recessed quartz shower niche, oversized medicine cabinet, individually controlled heating and cooling, and keyless entry.
#2102062
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$6,738 / mo
44th Road and 43rd Avenue, Long Island City, Queens, 11101
Active
44th Road And 43rd Avenue, Long Island City, Queens, 11101 Queens, NY 11101
2 Bed
2 Baths
sqft
MLS# NMLGMQBRTOOMY
Introducing Residence 1002, your gateway to luxurious living! This exquisite home boasts a sprawling, private wrap-around terrace, perfectly positioned at the building's south/west corner, offering an exclusive outdoor retreat. The residence is defined by its soaring ceilings and oversized windows, flooding the space with natural light. The heart of this home is its island kitchen, set against the backdrop of stunning open views.
Nestled in the vibrant Court Square neighborhood, The Cove is a pinnacle of modern living. Residents enjoy access to a cutting-edge fitness center, multiple outdoor areas complete with grills for entertaining, a variety of indoor lounges for relaxation, and convenient storage solutions. Each home in The Cove, including Residence 1002, features contemporary wide plank flooring, top-tier stainless steel appliances, in-home laundry facilities, and abundant storage space, ensuring both comfort and style.
Experience the epitome of urban elegance in Residence 1002. Contact us to discover more about this exceptional living space.
#2005910
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$6,712 / mo
Hunters Point Stunning New Unit
Active
Address Not Disclosed Queens, NY 11102
2 Bed
2 Baths
sqft
MLS# NMLMLMATHUVNL
Stunning corner 2-bedroom, 2-bath apartment with a private terrace, a flexible corner alcove with windows, a windowed kitchen, king-size bedroom, in-home washer/dryer, and breathtaking views of The Creek.
#2107902
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj
$6,709 / mo
42nd Road and Queens Plaza South
Active
42nd Road And Queens Plaza South Queens, NY 11101
2 Bed
2 Baths
sqft
MLS# NMLWYJNVSRCOG
Elevate your living experience with this high-floor, corner two-bedroom apartment, adorned with floor-to-ceiling windows. Enjoy the awe-inspiring dual vistas of the bustling city skyline and the serene river. This residence boasts condominium-quality finishes, an in-unit washer/dryer, a generously sized master bedroom complete with an en-suite bathroom, and a spacious walk-in closet.
At Stonehenge Access, we prioritize your convenience and comfort. Choose from agent-led, self-guided, or virtual tours to explore our offerings at your own pace.
OLR ID: 1804496
Listing Courtesy of Awaye Realty / Century 21 Awaye Realty / Bute Mehaj