Listing by:

Visit our professional directory to find an agent in your area that can help with your home search.

Contact Agent

variant

zpid

mlsCode

onlyPreapprovalContact

showNameField

showPhoneField

suppressAccountCreation

submitId

showPhoneMandatoryField

leaderboardZuids

isSelectListingAgent

zuid

ccListingAgent

palZuids

pixelId

message

name

phone

email

Welcome to 552-54 Columbus Avenue — a classic two-family residence with strong rental potential, ideally situated just a short walk from the vibrant Westcott neighborhood and a variety of local shops, restaurants, and entertainment. This highly desirable location consistently attracts Syracuse University students, young professionals, and long-term tenants alike. Current tenants requested no interior photos taken.

The property features two spacious units: one offering two bedrooms and one full bathroom, and the other with three bedrooms and one full bathroom. Both units offer flexible living spaces with excellent natural light and charming architectural details.

While the home provides a solid foundation and excellent location, it does present an opportunity for renovation and updating. With the right improvements, this property could quickly become a high-demand rental or a valuable addition to your investment portfolio in one of Syracuse’s most sought-after rental markets.

Whether you're looking to expand your investment holdings or create updated, income-producing residences in a prime neighborhood, 552-54 Columbus Avenue offers the potential and location to make it happen. There are tenants currently living there and home is being sold occupied. Home is being sold as-is.

Wescott

By pressing Contact an agent, you agree that Zillow Group and its affiliates, and real estate professionals may call/text you about your inquiry, which may involve use of automated means and prerecorded/artificial voices. You don’t need to consent as a condition of buying any property, goods or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you’re looking for in a home.

Contact a Buyer's Agent

apple-mobile-web-app-capable

apple-mobile-web-app-status-bar-style

format-detection

google-signin-clientid

google-signin-cookiepolicy

google-signin-scope

691f1bfccade71b5-c065751219a379dd-g64cedb67f5ea020a-a

google-translate-customization

msapplication-config

msapplication-TileColor

https://www.zillowstatic.com/static/images/logos/zillow-logo-win8-tile.png

msapplication-TileImage

referrer

width=device-width, height=device-height, user-scalable=yes, initial-scale=1.0, minimum-scale=1.0

viewport


        if (typeof Object.assign === 'function') {
            window.appInfo = Object.assign(
                typeof window.appInfo === 'object' ? window.appInfo : {},
                {"@zillow/page-frame-content":"728621ce"}
            );
        }
    


        window.CLIENT_PROFILER_CONFIG = window.CLIENT_PROFILER_CONFIG || {
            staticDimensions: {
                ABDecisionToken: "n1nyke_1752564061",
            },
        };
    


        var customDimension1 = 'b04e2b5e8f974edca496a11596174d1b';
        ua('set', 'dimension1', customDimension1);
        ga('set', 'dimension1', customDimension1);
        ua('identify', null);
        ua('set', {"dimension174":"AB_DASHBOARD_AA_TEST.CONTROL","dimension173":"ARCS_AUTH_FOR_UNRECOGNIZED.ON","dimension179":"ARCS_NO_SPAM.CONTROL","dimension47":"CIAM_AUTH_OTP_CONTACT_AGENT_FORM.CONTROL","dimension43":"CIAM_AUTH_OTP_TOUR_FORM.CONTROL","dimension58":"FSBO_MEDIASOLUTIONS_RTM.ON","dimension170":"FSHDP_OPTIMIZATION.ON","dimension59":"FoyerPhase1.CONTROL","dimension39":"HDP_SHARE_TO_ZIM.CONTROL","dimension184":"HDP_WEB_OFFER_INSIGHTS_V2.CONTROL","dimension40":"HOPS_SAFARI_APP_UPSELL_BANNER.CONTROL","dimension56":"IOS_SATELLITE_RACHEL_VIEWATTACHMENTS.CONTROL_OFF","dimension176":"LEGO_SRP_LIST_CARD_MULTIPLE_CTAS.CONTROL","dimension60":"MST_SRP_WEB_2NDAD13AND17.SLOT13","dimension178":"NBA_MHDP.CONTROL","dimension180":"ONSITE_MESSAGE_VALVE.OMP_ON","dimension164":"RC_AUTH_MIGRATION.CONTROL","dimension61":"RC_DESKTOP_CONTACT_FORM.CONTROL","dimension41":"RC_RP_RENTALS_BUYABILITY_UPSELL.BUTTON","dimension177":"RC_SIMPLE_CONTACT_FORM.TEST","dimension57":"RDP_SIGNATURE_MEDIA_V2.CONTROL","dimension165":"SAT_DYNAMIC_RANKING.CONTROL","dimension65":"SIGNATURE_MAP_SPECIAL_OFFER.CONTROL","dimension50":"SIGNATURE_MAP_V2.CONTROL","dimension185":"SRP_MEDIASOLUTIONS_STATEMACHINE.CONTROL","dimension169":"SXP_DESKTOP_MO_MAP_PILLS.TREATMENT_800","dimension37":"SXP_MWEB_MO_MAP_PILLS.CONTROL","dimension36":"VSTA_NFS_HDP_HOLLYWOOD.DUAL_CTA","dimension171":"WEB_NCHDP_BUYABILITY_CALCULATOR.CONTROL","dimension188":"ZEXP_DECISION_TOKEN_HOLD.n1nyke_1752564061"});
        ga('set', {"dimension174":"AB_DASHBOARD_AA_TEST.CONTROL","dimension173":"ARCS_AUTH_FOR_UNRECOGNIZED.ON","dimension179":"ARCS_NO_SPAM.CONTROL","dimension47":"CIAM_AUTH_OTP_CONTACT_AGENT_FORM.CONTROL","dimension43":"CIAM_AUTH_OTP_TOUR_FORM.CONTROL","dimension58":"FSBO_MEDIASOLUTIONS_RTM.ON","dimension170":"FSHDP_OPTIMIZATION.ON","dimension59":"FoyerPhase1.CONTROL","dimension39":"HDP_SHARE_TO_ZIM.CONTROL","dimension184":"HDP_WEB_OFFER_INSIGHTS_V2.CONTROL","dimension40":"HOPS_SAFARI_APP_UPSELL_BANNER.CONTROL","dimension56":"IOS_SATELLITE_RACHEL_VIEWATTACHMENTS.CONTROL_OFF","dimension176":"LEGO_SRP_LIST_CARD_MULTIPLE_CTAS.CONTROL","dimension60":"MST_SRP_WEB_2NDAD13AND17.SLOT13","dimension178":"NBA_MHDP.CONTROL","dimension180":"ONSITE_MESSAGE_VALVE.OMP_ON","dimension164":"RC_AUTH_MIGRATION.CONTROL","dimension61":"RC_DESKTOP_CONTACT_FORM.CONTROL","dimension41":"RC_RP_RENTALS_BUYABILITY_UPSELL.BUTTON","dimension177":"RC_SIMPLE_CONTACT_FORM.TEST","dimension57":"RDP_SIGNATURE_MEDIA_V2.CONTROL","dimension165":"SAT_DYNAMIC_RANKING.CONTROL","dimension65":"SIGNATURE_MAP_SPECIAL_OFFER.CONTROL","dimension50":"SIGNATURE_MAP_V2.CONTROL","dimension185":"SRP_MEDIASOLUTIONS_STATEMACHINE.CONTROL","dimension169":"SXP_DESKTOP_MO_MAP_PILLS.TREATMENT_800","dimension37":"SXP_MWEB_MO_MAP_PILLS.CONTROL","dimension36":"VSTA_NFS_HDP_HOLLYWOOD.DUAL_CTA","dimension171":"WEB_NCHDP_BUYABILITY_CALCULATOR.CONTROL","dimension188":"ZEXP_DECISION_TOKEN_HOLD.n1nyke_1752564061"});
    

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
        (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
        m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
        })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

window.__USER_SESSION_INITIAL_STATE__ = { user: { loggedIn: false } };

552-54 Columbus Ave, Syracuse, NY 13210

What's special