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.
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
- 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#: 945828
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
| Date | Event | Price |
|---|---|---|
| 1/28/2026 | Price change | $1,450,000-3.3%$936/sqft |
Source: | ||
| 12/22/2025 | Listed for sale | $1,500,000+39900%$968/sqft |
Source: | ||
| 10/6/2024 | Listing removed | $5,500$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 9/6/2024 | Listed for rent | $5,500$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 7/30/2024 | Listing removed | $5,500$4/sqft |
Source: Zillow Rentals Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax 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
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
- 8/10Lakeville Elementary SchoolGrades: 1-5Distance: 0.7 mi
- 8/10Great Neck South Middle SchoolGrades: 6-8Distance: 0.7 mi
- 10/10Great Neck South High SchoolGrades: 9-12Distance: 0.7 mi
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.
- Loading
- Loading



