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.
Coming soon
$1,500,000
460 Sterling Road, Harrison, NY 10528
5beds
4,216sqft
Single Family Residence, Residential
Built in 1946
-- sqft lot
$-- Zestimate®
$356/sqft
$-- HOA
What's special
- 2 days
- on Zillow |
- 1,803 |
- 104 |
Zillow last checked: 7 hours ago
Listing updated: August 27, 2025 at 05:20am
Listing by:
Houlihan Lawrence Inc. 914-967-7680,
Lisa DeFonce 914-227-5045
Source: OneKey® MLS,MLS#: 897818

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Bedroom 1
- Description: Primary bedroom with fireplace, dressing area and ensuite full bath
- Level: Second
Bedroom 2
- Description: Bedroom with ensuite full bath
- Level: Second
Bedroom 3
- Description: Bedroom with ensuite full bath
- Level: Second
Bedroom 4
- Description: Bedroom with ensuite full bath
- Level: Second
Bedroom 5
- Description: Bedroom
- Level: Second
Bedroom 5
- Description: Full bath adjacent to bedroom 5
- Level: Second
Bathroom 1
- Description: Powder room
Other
- Description: Breakfast room
Dining room
- Description: Door to patio
Living room
- Description: Fireplace and door to patio
Office
- Description: Door to patio
Heating
- Hot Water
Cooling
- Wall/Window Unit(s)
Appliances
- Included: Dryer, Gas Range, Refrigerator, Washer
Features
- Entrance Foyer, Formal Dining, Original Details, Primary Bathroom
- Flooring: Hardwood
- Basement: Full,Unfinished
- Attic: Walkup
- Number of fireplaces: 2
Interior area
- Total structure area: 4,216
- Total interior livable area: 4,216 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Garage spaces: 2
Details
- Parcel number: 0471.2
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Stone, Stucco
- Foundation: Stone
Condition
- Year built: 1946
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Harrison
Financial & listing details
- Price per square foot: $356/sqft
- Tax assessed value: $29,130
- Annual tax amount: $46,188
- Date on market: 9/2/2025
- Listing agreement: Exclusive Right To Sell
- Loading