1675 Stewart Avenue
New Hyde Park, NY 11040
- 4 beds
- 4 baths
- 2,300 sqft
- 5,000 sqft lot
- $630 per sqft
- 1949 build
- – on site
This is the one you've been waiting for! Your search for the perfect home ends here. This beautifully renovated colonial is the definition of luxury, offering every detail meticulously crafted with high-end, custom finishes throughout. Your journey begins the moment you step into the spacious 200+ sq ft foyer, complete with a custom coat and shoe closet. To your left, a bright and cozy living room or study awaits, enhanced by sliding French doors that bring in natural light and fresh air. The elegant formal dining room provides the perfect space for family gatherings. At the heart of the home, the gourmet chef’s kitchen shines with stunning quartz countertops, a large center island, and premium brand stainless steel appliances. An enormous family room features soaring vaulted ceilings, a marble accent wall with a built-in electric fireplace, and sliding doors that open to a backyard oasis. The first floor is rounded out with a spacious powder room with marble tiled walls. Upstairs, you’ll find a luxurious primary suite with an ensuite bath offering a walk-in shower, soaking tub, and dual smart mirrors. Three additional generously sized bedrooms share a renovated full bath. The fully finished lower level provides even more space to enjoy—whether you're relaxing in the recreation room with a pool table, staying active in the home gym, or making use of the ample storage and convenient laundry room. This level also features a full bath with shower. Outside in the backyard you'll find your very own private oasis, with a beautiful paved patio and a hand-cultivated rose garden featuring imported European roses. A charming floral archway and privacy hedges provide an intimate, secluded atmosphere perfect for relaxation or entertaining.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Mar 1, 2025
•
MLS# 827869 —
The Building
-
Year Built:1949
-
Basement:true
-
Architectural Style:Colonial
-
Construction Materials:Stucco
-
Patio And Porch Features:Patio, Porch
-
Building Area Units:Square Feet
-
Building Area Total:2300
-
Attic:Partial
-
Direction Faces:East
Interior
-
Living Area:2300
-
Total Rooms:10
-
Interior Features:Chefs Kitchen, Eat-in Kitchen, Entertainment Cabinets, Entrance Foyer, Formal Dining, High Ceilings, High Speed Internet, Kitchen Island, Primary Bathroom, Quartz/Quartzite Counters, Recessed Lighting, Smart Thermostat, Soaking Tub, Sound System, Storage, Walk-In Closet(s)
-
Fireplace Features:Electric
-
Fireplace:true
-
Living Area Source:Public Records
Financial & Terms
-
Lease Considered:false
The Property
-
Fencing:Fenced, Vinyl
-
Lot Size Acres:0.1148
-
Parcel Number:2289-08-K-10-0007-0
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Lot Size SqFt:5,000 Sqft
-
Property Attached:false
-
Property Condition:Updated/Remodeled
-
Lot Size Dimensions:50' x 100'
-
Waterfront:false
Listing Agent
- Contact info:
- Agent phone:
- (516) 873-7100
- Office phone:
- (516) 873-7100
Taxes
-
Tax Year:2024
-
Tax Source:Municipality
-
Tax Annual Amount:18324
Beds
-
Total Bedrooms:4
Baths
-
Full Baths:3
-
Half Baths:1
-
Total Baths:4
The Listing
-
Special Listing Conditions:None
-
Virtual Tour URL Unbranded:
-
Virtual Tour URL Branded:
Heating & Cooling
-
Heating:Hot Water
-
Cooling:Central Air, Ductless
-
# of Heating Zones:2
Utilities
-
Sewer:Public Sewer
-
Utilities:Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public
-
Water Source:Public
-
Electric Company:Pseg
Appliances
-
Appliances:Dishwasher, Dryer, Gas Oven, Gas Range, Microwave, Oven, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Gas Water Heater
Schools
-
High School:Great Neck South High School
-
Elementary School:Lakeville Elementary School
-
High School District:Great Neck
-
Middle School:Great Neck South Middle School
The Community
-
Association:false
-
Senior Community:false
-
Additional Fees:No
-
Subdivision Name:Lakeville Estates
-
Pool Private:false
-
Spa:false
Parking
-
Parking Features:Driveway
-
Garage:true
-
Garage Spaces:1
-
Carport:false
Monthly cost estimate
Asking price
$1,449,000
| Expense | Monthly cost |
|---|---|
|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$7,758
|
| Taxes | $1,527 |
| Insurance | $398 |
| Utilities | $288 See report |
| Total | $9,971/mo.* |
| *This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
2/27/25
Feb 27, 2025
|
Listed / Active | ONEKEY | $1,449,000 | 26.6% (3.9% / YR) |
|
4/30/18
Apr 30, 2018
|
ONEKEY | $1,145,000 |
43% of nearby similar homes sold for over asking price
Similar homes that sold in bidding wars went $55k above asking price on average, but some went as high as $151k over asking price.
