Ann Acquaviva, Real Estate Salesperson

09/12/2026

OPEN HOUSE TODAY 9/12 & 9/13
Great starter home opportunity.
Location excellent for transportation, restaurants and shopping.
Second floor. Well maintained. Make it your own!

09/09/2026

Beautiful Bayside NY. First time home buyer opportunity. One bedroom coop. Excellent transportation nearby including local bus, express bus and LIRR. Close to Bell Blvd and Francis Lewis. Restaurants and nightlife in abundance. Wood floors throughout. Laundry facilities on site. Street and private parking. Contact me for more details.

05/30/2026

Why pay rent when you can own?
Beautiful

05/14/2026

*** NEW LISTING***

One of the 𝖍𝖔𝖙𝖙𝖊𝖘𝖙 markets right now.

Unique opportunity in this development with a 3500 sq ft lot.
This beautiful property offers the benefit of larger square footage than a typical New Hyde Park home without all the maintenance.

Location is excellent. Shopping, transportation (LIRR is walkable), restaurants, highways and beautiful parks nearby.

Contact me for more details

05/01/2026

Being kind…

My fun loving crazy adventurous clients turned friends just closed on a property they inherited by being kind and caring.

Working in while in college they befriended a gentleman that would come in for coffee alone. They had many conversations and became friends. They helped him with shopping and appointments and invited him to family gatherings. He had no family. They became family.

He took sick a couple of years ago and they took over his care. Sadly he passed away last year.
He left his home to them in gratitude for the years of love they bestowed upon him.

I couldn’t be happier for these two young people who go above and beyond in charitable deeds
for humanity. Great humans 🥰

04/19/2026

04/19/2026

04/11/2026

First Open House:
For more details and info message me directly

04/09/2026

A Rare Estate Offering in Prestigious Broadway-Flushing. Introducing 28-07 157th Street—an extraordinary brick Tudor estate set on a remarkable 100 x 100 corner property in the heart of Broadway-Flushing, one of Queens’ most distinguished and sought-after enclaves. Opportunities of this caliber are exceptionally rare—this is a true generational property.

Perfectly positioned just half a block from Bowne Park, this residence offers a serene, picturesque setting with tree-lined streets, a tranquil pond, and walking paths—while remaining effortlessly connected to Manhattan via LIRR, express bus, and local transit.

Timeless Architecture & Grand Scale Living - This stately home spans 2500 square feet across 2.5 stories, showcasing classic Tudor craftsmanship paired with expansive, versatile living spaces.

From the moment you enter the foyer, you are greeted by rich original woodwork, intricate moldings, and beautifully preserved hardwood floors—details that speak to a level of quality rarely found today. The formal living room, anchored by a wood-burning fireplace, offers warmth and sophistication, while french doors create an elegant flow between rooms—ideal for both intimate living and refined entertaining. A gracious formal dining room and well-appointed kitchen seamlessly connect to one of the home’s most exceptional features—a sun-drenched 25-foot garden room wrapped in windows. This remarkable space offers endless possibilities as a luxury home office, lounge, or guest retreat, blending indoor comfort with outdoor beauty.

The second level features four spacious bedrooms, along with a substantial bonus room that can easily be transformed into a fifth bedroom, private office, or a spa-inspired primary suite expansion. The fully renovated main bath reflects a thoughtful blend of modern design and timeless style. The finished walk-up attic is a true hidden gem—offering a flexible living space enhanced by ductless A/C. Ideal for guests, extended family, or a private retreat.

The fully finished lower level—with private entrance—provides exceptional flexibility, featuring additional living space, and multiple-use areas perfect for recreation, extended living, or work-from-home needs.

Set on an extraordinary 100 x 100 lot, the outdoor space is nothing short of spectacular—an offering rarely, if ever, seen in this neighborhood. Enjoy a beautifully landscaped property complete with a heated in-ground Gunite pool, outdoor shower, greenhouse and storage shed, expansive lawn and garden areas and a detached two-car garage with additional storage. This is true estate-style living in the heart of Queens. This home offers endless potential & investment value.

Beyond its immediate beauty and functionality, this property offers significant long-term upside. With the proper approvals, the lot presents a rare opportunity for subdivision and development, further elevating its already exceptional value. Properties of this size, character, and location are nearly impossible to replicate.

Whether you are seeking a forever home, multigenerational residence, or a premier investment, 28-07 157th Street represents a once-in-a-lifetime opportunity in Broadway-Flushing.