Thomas Tarantola
BEDS2
BATHS2 full 1 partial
SQUARE FEET1,320
MLS#1015088
STATUSActive
PROPERTY TYPEResidential - Condominium
SCHOOLGreat Neck
Property Description
Welcome to Sterling Plaza! This sun-drenched, south-facing, extra-large 2-bedroom, 2.5-bathroom condominium offers an unparalleled upscale lifestyle. Elegant entry foyer opens to an expansive, sun-filled living and dining area with rich hardwood floors. Chef's Kitchen: Premium granite countertops, classic maple cabinetry & updated stainless steel appliances. Massive main suite featuring a spa-inspired marble bath, dual vanity, jacuzzi tub, and separate shower. Generous second bedroom complete with its own private, full en-suite bathroom. Powder Room: Stylish, well-located half-bath near the entryway for guests. In-Unit Laundry: Full-size washer and dryer. Central air conditioning (CAC). Abundant closets spaces and one dedicated indoor parking. 24-hour elite concierge and doorman service. Fully equipped, state-of-the art fitness center. Location Ideally situated within the moments from the LIRR, parks, shopping, the public library and major highways-delivering convenience.
Property Features
Property Type: Residential - Condominium
Cooling: Central Air
Garage: 1
Heating: Forced Air, Natural Gas
Home Style: Other
Taxes: $10,916
Year Built: 2008
Amenities
First Floor Bedroom
Elevator
Formal Dining
Marble Counters
Primary Bathroom
Master Downstairs
Storage
Walk-In Closet(s)
Feature Descriptions
Appliances: Dishwasher, Dryer, Freezer, Oven, Range, Refrigerator, Stainless Steel Appliance(s), Trash Compactor, Washer
Association Fee Includes: Common Area Maintenance, Exterior Maintenance, Sewer, Snow Removal, Trash, Water
Elevator: Y
Exterior: Brick
Flooring: Hardwood
Formal Dining: Yes
GarageY/N: Yes
Laundry: Laundry Room
Lot Features: Sprinklers In Front
On Market Date: 2026-06-24
Parking Features: Assigned, Garage, Private
Parking Fee: 56
Parking Total: 1
Pets Allowed: No
Rental Term: Monthly
Rooms Total: 5
Security: yes
Security Features: Fire Alarm, Fire Sprinkler System, Security System
Sewer: Public Sewer
Utilities: Trash Collection Private
Water: Public
Window Features: Blinds, Drapes
Local Schools
High School: Great Neck North High School
Middle School: Great Neck South Middle School
Elementary School: Lakeville Elementary School
School District: Great Neck
Estimate Your Payment
Estimated Payment
$ 7,327.52 per month $6,067.85 Principal & Interest $909.67 Property Tax $350.00 Homeowner's InsuranceChange Payment Information
Listed By / Shown By
Listing By
Agency Name: Greene Realty Group
Agency Contact: 888-278-5840
Shown By
Agent Name: Thomas Tarantola
Agent Phone: (516) 805-2528
Agency Title: Coldwell Banker American Homes
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. 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.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
171 Great Neck Road | MLS# 1015088
This condo located at 171 Great Neck Road , Great Neck, NY 11023 is currently listed for sale with an asking price of $1,200,000. This property was built in 2008 and has 2 bedrooms and 2 full and 1 partial baths with 1320 sq. ft. Great Neck Road is located within the Great Neck school district. Search Great Neck real estate on thomastarantola.cbamhomes.com today.