Are you ready for an exciting project in Sterling Ridge? Renovate, re-imagine and expand, or re-build completely…so many possibilities exist for this property with current home perched on a 1.08 acre corner lot in prestigious Sterling Ridge. This home has the unique history of originally being built circa 1900 as a cow barn, then in the 1940’s it was transformed into an impressive colonial. A grand staircase with marble steps and a custom iron railing have stood the test of time and speak to how special the home was in its day. A generous living room with picture windows, dentil moldings and a fireplace opens to patio and is mirrored by the formal dining room with picture window and opens to the another patio. The kitchen and study also open to the outdoors. A powder room and breakfast room complete the first floor. All five bedrooms have an ensuite or adjacent bathroom…the perfect set up to update to the current day. A two car garage, spacious basement and walk up insulated attic are a bonus.
Listed by Lisa DeFonce
·
Houlihan Lawrence Inc.
·
914-967-7680
Last updated September 03, 2025
·
Source: OneKey #897818
Listing Facts
TypeSingle-family
NeighborhoodSterling Ridge - The Trails
Bedrooms5
Bathrooms6
Days on Prevu4
Taxes$46,188/year
Size4,216 sqft
Price per sqft$356
Amenities
Washer/Dryer
Parking
Location
Mortgage Calculator
Listing History
09/02/2025
Status changed to Active
$1,500,000
09/02/2025
Listed by Houlihan Lawrence Inc.
$1,500,000
Property Details for 460 Sterling Road
Exterior
Construction
Year Built: 1946
Architectural Style: Colonial
Construction Materials: Stone, Stucco
Measurements
Building Area Total: 4,216
Building Area Units: Square Feet
Lot Size Acres: 1.08
Financial
Taxes
Parcel Number: 0471.2
Tax Annual Amount: $46,188.00
Tax Year: 2025
Interior
Features
Appliances: Dryer, Gas Range, Refrigerator, Washer
Fireplace: Yes
Fireplaces Total: 2
Flooring: Hardwood
Interior Features: Entrance Foyer, Formal Dining, Original Details, Primary Bathroom
Measurements
Living Area: 4,216
Living Area Source: Public Records
Rooms
Basement: Full, Unfinished
Has Basement: Yes
Bathrooms Full: 5
Bathrooms Half: 1
Bathrooms Total Integer: 6
Bedrooms Total: 5
Rooms Total: 10
Other
Location
Tax Block: 0471
Tax Lot: 2
Parking
Parking
Garage Spaces: 2
Garage: Yes
Parking Features: Attached
Schools
Elementary School
Elementary School: Harrison Avenue Elementary School
Elementary School District: Harrison
High School
High School: Harrison High School
High School District: Harrison
Middle or Junior School
Middle Or Junior School: Louis M Klein Middle School
Middle Or Junior School District: Harrison
Utilities
Equipment
Cooling: Wall/Window Unit(s)
Heating: Hot Water
Sewer: Public Sewer
Utilities: Natural Gas Connected
Water Source: Public
The data relating to real estate for sale on this website comes in part from the IDX
Program of OneKey™ MLS. The source of the displayed data is either the property owner
or public record provided by non-governmental third parties. It is believed to be reliable
but not guaranteed. This information is provided exclusively for consumers’ personal,
non-commercial use. Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.