Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Advisor Realty
Property view
Listing view 2
Listing view 3

460 Sterling Road, 
Harrison, NY 10528

$1,500,000


5

Beds


6

Baths


4,216

Sq Ft


Single Family

Active

Listed by

Lisa Defonce

Houlihan Lawrence Inc.

Last updated:

September 9, 2025, 04:56 PM

MLS#

897818

Source:

OneKey MLS

About This Home

460 Sterling Road

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. Please submit best and final offers by Tuesday, Sept 9 at 5:00pm

Home Facts

Single Family

6 Baths

5 Bedrooms

Built in 1946

Price Summary

1,500,000

$355 per Sq. Ft.

MLS #:

897818

Last Updated:

September 9, 2025, 04:56 PM

Added:

19 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

6

Full Bathrooms:

5

Interior

Living Area:

4,216 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial

Building Area:

4,216 Sq. Ft.

Year Built:

1946


Lot

Lot Size (Sq. Ft):

47,044


Finances & Disclosures

Finances

Price:

$1,500,000

Price per Sq. Ft:

$355 per Sq. Ft.

Source:OneKey MLS
Copyright 2025 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID. OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.