Rare and magnificent fully detached brick residence on an expansive 10,000 square foot lot, offering 5,068 square feet of living space in prestigious Sunset Hill. This exceptional home features 5 spacious bedrooms and 4 bathrooms, designed for grand entertaining and everyday living. The first floor features two generous bedrooms with balcony or terrace access, a grand formal dining room accommodating 24 guests, and an elegant formal living room with a fireplace. The huge kitchen includes a walk-in dining area and a full bathroom. The layout is filled with skylights and southeast-facing exposure, keeping the home bright and airy. The second floor offers a true retreat, featuring a tremendous primary bedroom suite with a separate sitting room, luxurious jacuzzi bath, private terrace, and a cozy fireplace. This level includes another full bathroom and two additional spacious bedrooms with tons of closet space. The fully finished basement is an entertainer's dream with a restaurant-style layout and bar, perfect for hosting 40 to 50 guests. Includes a built-in garage and carport for four vehicles. Outside, the beautifully maintained backyard features a gorgeous 20 by 40 swimming pool, offering privacy and tranquility. This extraordinary gem rarely becomes available. You must see it to believe it.

Property Details of 15 Herkimer Street, Sunset Hill

Property Details

Interior Features

Community

Other Details

Map Location

Listed by RE/MAX Edge / Thanh H. Cantone (718-288-3835)

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of June 20, 2026 6:20 PM 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.