Skip main navigation
For sale
  • Price cut: $50K (1/28)
    $1,450,000

    171 GREAT NECK Road #1N, Great Neck, NY 11021

    2beds
    1,549sqft
    Condominium, Residential
    Built in 2007
    -- sqft lot
    $-- Zestimate®
    $936/sqft
    $860/mo HOA

    What's special

    Abundant natural lightExpansive primary suiteIn-unit washer and dryerX-large two-bedroom two-and-a-half-bathroom unitRich hardwood floorsDual vanityUpdated stainless steel appliances
    Welcome to Sterling Plaza! Ultra-Luxury Condo Apt Living in the Heart of Great Neck. Step into this sun-drenched, south-facing X-Large two-bedroom, two-and-a-half-bathroom unit offering refined elegance and modern convenience. Located in the prestigious Sterling Plaza, this spacious unit features: Elegant Entry Foyer leading into a generously sized open concept living and dining area, accentuated by rich hardwood floors and abundant natural light. A chef's kitchen outfitted with granite countertops, maple cabinetry, and updated stainless steel appliances, blending style and functionality. Expansive primary suite with a spa-inspired marble bathroom, featuring a dual vanity, jacuzzi soaking tub, separate stand-up shower, and luxurious golden fixtures. A well-proportioned second bedroom with its own en-suite full bath, offering comfort and privacy, also for family or guests Stylish powder room conveniently located near the entrance. Additional Highlights: Central A/C (CAC)In-unit washer and dryer Ample closet and storage space one indoor parking space. Building Amenities: 24-hour concierge and doorman Fully equipped fitness center Party/Community room. Prime Location: Within the Great Neck South School District Close to park, shops, LIRR, and houses of worship This exquisite apt is perfect for those seeking upscale comfort, convenience, and a vibrant community.
    37 days
    |
    741
    |
    8
    |

    Zillow last checked: 8 hours ago

    Listing updated: January 28, 2026 at 08:56am

    Listing by:

    Janet Etessami Realty Inc 516-482-4321,

    Janet Etessami 516-816-5080

    Source: OneKey® MLS,MLS#: 945828MLS Logo

    Tour with a local agent

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Ducts, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Cooktop, Dryer, Exhaust Fan, Freezer, Gas Cooktop, Gas Oven, Refrigerator, Stainless Steel Appliance(s), Washer
    • Laundry: In Unit
    Features
    • First Floor Bedroom, First Floor Full Bath, Breakfast Bar, Chefs Kitchen, Double Vanity, Eat-in Kitchen, Entrance Foyer
    • Flooring: Hardwood
    • Basement: Full
    • Attic: Partial
    Interior area
    • Total structure area: 1,549
    • Total interior livable area: 1,549 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage
    • Garage spaces: 2
    Details
    • Parcel number: 02376000056UCA023200111
    • Special conditions: None

    Construction

    Type & style
    • Home type: Condo
    • Architectural style: Other
    • Property subtype: Condominium, Residential
    Materials
    • Brick, Stucco
    Condition
    • Year built: 2007

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Other
    • Utilities for property: Cable Connected, Natural Gas Connected

    Community & HOA

    HOA
    • Has HOA: No
    • HOA fee: $860 monthly
    Location
    • Region: Great Neck

    Financial & listing details

    • Price per square foot: $936/sqft
    • Tax assessed value: $298,200
    • Annual tax amount: $1,174
    • Date on market: 12/22/2025
    • Cumulative days on market: 38 days
    • Listing agreement: Exclusive Right To Sell
    • Electric utility on property: Yes

    Estimated market value

    Not available

    Estimated sales range

    Not available

    Not available

    Price history

    Price history
    DateEventPrice
    1/28/2026Price change$1,450,000-3.3%$936/sqft
    Source: OneKey® MLS #945828 Report a problem
    12/22/2025Listed for sale$1,500,000+39900%$968/sqft
    Source: OneKey® MLS #945828 Report a problem
    10/6/2024Listing removed$5,500$4/sqft
    Source: Zillow Rentals Report a problem
    9/6/2024Listed for rent$5,500$4/sqft
    Source: Zillow Rentals Report a problem
    7/30/2024Listing removed$5,500$4/sqft
    Source: Zillow Rentals Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax assessment
    2024-- $2,982 +35.2%
    2023-- $2,205 -8%
    2022-- $2,396

    Find assessor info on the county website

    BuyAbility℠ payment

    Estimated monthly payment
    All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
    HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
    Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
    See how much you could borrow to make a competitive offer.

    Boost your down payment with 6% savings match

    Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.

    Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.

    Climate risks

    Neighborhood: Lake Success

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Saddle Rock School
    • Middle: Great Neck South Middle School
    • High: Great Neck South High School

    Source: OneKey® MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Similar homes

    Skip to the end of the carouselSkip to the beginning of the carousel
    • Loading
    • Loading