Rarely does a residence of this magnitude come to market. Conceived without compromise and executed with meticulous craftsmanship, every inch of this all-brick manor reflects the vision of an owner who demanded nothing less than perfection. Arrival sets the tone immediately. A sweeping, oversized front porch welcomes you with the kind of gracious presence rarely found in the borough - an architectural statement as much as a functional space, perfectly suited for morning coffee, evening gatherings, or simply enjoying the quiet prestige of the neighborhood. Step through the front door and you are met by a grand entry foyer crowned with soaring cathedral ceilings, where the scale and quality of the home announce themselves instantly. Spanning four breathtaking levels connected by a private four-stop elevator, the residence commands its surroundings with dramatic 11-foot ceilings that lend every room an air of grandeur and openness. The principal floor is designed for living and entertaining at the highest level. A large, sun-filled living room anchored by an elegant fireplace creates an atmosphere of warmth and sophistication - the natural gathering place of the home, equally suited to intimate evenings and grand receptions. The formal dining room is a room of genuine distinction. Generously proportioned and finished to an exacting standard, it is a space designed to impress - ideal for formal dinner parties, holiday celebrations, and the kind of entertaining that creates lasting memories. Adjacent, a sunlit breakfast room offers a more relaxed counterpart for everyday dining, while the large eat-in kitchen opens directly onto a spacious rear porch - extending the living space seamlessly to the outdoors and creating an effortless flow between cooking, dining, and entertaining. Six large, beautifully appointed bedrooms provide an abundance of space for rest, privacy, and personal retreat. Each bedroom is generously sized with thoughtful layouts, premium finishes, and exceptional natural light. The primary suite is a sanctuary of its own - expansive in scale, refined in detail, and designed to provide the ultimate in comfort and privacy. The remaining five bedrooms are equally well-considered, offering versatility for guests, family, or dedicated home office use. he fully finished lower level is a destination in its own right - a private world of wellness, recreation, and comfort that sets this property apart from anything else on the market. Designed for those who expect the extraordinary, it encompasses dedicated maid's quarters, a professional-caliber gym, a generous entertainment area, a dry sauna, and a private hot tub - all finished to the same exacting standard as the floors above. The in-ground Gunite heated pool anchors the private rear grounds - a resort-caliber amenity that transforms the backyard into a personal oasis. This is resort living, without ever leaving home.

Property Details of 18710 Aberdeen Road

Property Details

Interior Features

Community

Other Details

Map Location

Listed by Exit Realty First Choice / Solomon Davydov (718-380-2500)

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of June 20, 2026 6:51 AM UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers’ personal noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. The use of the MLS GRID Data may be subject to an end user license agreement.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from The Agency. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.