BuySellBlogBrowse Listings

460 Sterling RoadHarrison, NY 10528

For Sale

$1,500,000

Smart Buyer Rebate $15,000

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.

Full MLS Disclaimers

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.