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

LIVE/WORK OPPORTUNITY!  HERRICKS SCHOOL DISTRICT! This property is zoned for "Business A" but is currently a one family + store mixed-use property, featuring two buildings and a garage on Lot 6. The back building is newly renovated with 3 bedrooms and 1.5 baths. Features include hardwood floors, eat in kitchen and a detached one car garage with a 3 car driveway!! The front building is a commercial space ideal for retail or professional use to earn rental income!
LIVE WHERE YOU WORK - A RARE AND FLEXIBLE INVESTMENT!! Adjacent lot 7 (50 x 80) is available as a package- inquire for pricing.  Either keep as a mixed use or convert the whole property to commercial use (please consult with your architects)

11507

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":"207d7247"}
            );
        }
    


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


        var customDimension1 = '4cef07edd8cc46e79fc24510e856d515';
        ua('set', 'dimension1', customDimension1);
        ga('set', 'dimension1', customDimension1);
        ua('identify', null);
        ua('set', {"dimension179":"AB_DASHBOARD_AA_TEST.CONTROL","dimension47":"CIAM_AUTH_OTP_CONTACT_AGENT_FORM.EMBEDDED","dimension43":"CIAM_AUTH_OTP_TOUR_FORM.CONTROL","dimension61":"CMXF_HERO_CAROUSEL_V2.ON","dimension58":"FSBO_MEDIASOLUTIONS_RTM.ON","dimension185":"FSHDP_OPTIMIZATION.ON","dimension65":"FoyerPhase2.TREATMENT","dimension39":"HDP_SHARE_TO_ZIM.ON","dimension184":"HDP_WEB_OFFER_INSIGHTS_V2.ON_ALT_COPY","dimension40":"HOPS_SAFARI_APP_UPSELL_BANNER.SAFARI_INSTALL_BANNER_AND_COLOR_THEME","dimension56":"IOS_SATELLITE_RACHEL_VIEWATTACHMENTS.ON","dimension177":"MST_SRP_WEB_2NDAD13AND17.CONTROL","dimension178":"NBA_MHDP.OMP","dimension180":"ONSITE_MESSAGE_VALVE.OMP_ON","dimension174":"RC_CONTACT_STATUS.TEST","dimension41":"RC_RP_RENTALS_BUYABILITY_UPSELL.CONTROL","dimension57":"RDP_SIGNATURE_MEDIA_V2.TEST","dimension169":"RDP_UNIT_PICKER_REFRESH_V1.CONTROL","dimension173":"SAT_DYNAMIC_RANKING.CONTROL","dimension50":"SIGNATURE_MAP_V2.CONTROL","dimension176":"SXP_BUYABILITY_FILTER.ON","dimension59":"SXP_DESKTOP_MO_MAP_PILLS.CONTROL","dimension37":"SXP_MWEB_MO_MAP_PILLS.CONTROL","dimension60":"USS_FS_PRS_MOB.MODEL_C","dimension49":"USS_FS_PRS_WEB.MODEL_C","dimension171":"WEB_NCHDP_BUYABILITY_CALCULATOR.ON","dimension188":"ZEXP_DECISION_TOKEN_HOLD.PuLap6_1754793787","dimension165":"ZE_HDP_WEB_VIDEO.CONTROL"});
        ga('set', {"dimension179":"AB_DASHBOARD_AA_TEST.CONTROL","dimension47":"CIAM_AUTH_OTP_CONTACT_AGENT_FORM.EMBEDDED","dimension43":"CIAM_AUTH_OTP_TOUR_FORM.CONTROL","dimension61":"CMXF_HERO_CAROUSEL_V2.ON","dimension58":"FSBO_MEDIASOLUTIONS_RTM.ON","dimension185":"FSHDP_OPTIMIZATION.ON","dimension65":"FoyerPhase2.TREATMENT","dimension39":"HDP_SHARE_TO_ZIM.ON","dimension184":"HDP_WEB_OFFER_INSIGHTS_V2.ON_ALT_COPY","dimension40":"HOPS_SAFARI_APP_UPSELL_BANNER.SAFARI_INSTALL_BANNER_AND_COLOR_THEME","dimension56":"IOS_SATELLITE_RACHEL_VIEWATTACHMENTS.ON","dimension177":"MST_SRP_WEB_2NDAD13AND17.CONTROL","dimension178":"NBA_MHDP.OMP","dimension180":"ONSITE_MESSAGE_VALVE.OMP_ON","dimension174":"RC_CONTACT_STATUS.TEST","dimension41":"RC_RP_RENTALS_BUYABILITY_UPSELL.CONTROL","dimension57":"RDP_SIGNATURE_MEDIA_V2.TEST","dimension169":"RDP_UNIT_PICKER_REFRESH_V1.CONTROL","dimension173":"SAT_DYNAMIC_RANKING.CONTROL","dimension50":"SIGNATURE_MAP_V2.CONTROL","dimension176":"SXP_BUYABILITY_FILTER.ON","dimension59":"SXP_DESKTOP_MO_MAP_PILLS.CONTROL","dimension37":"SXP_MWEB_MO_MAP_PILLS.CONTROL","dimension60":"USS_FS_PRS_MOB.MODEL_C","dimension49":"USS_FS_PRS_WEB.MODEL_C","dimension171":"WEB_NCHDP_BUYABILITY_CALCULATOR.ON","dimension188":"ZEXP_DECISION_TOKEN_HOLD.PuLap6_1754793787","dimension165":"ZE_HDP_WEB_VIDEO.CONTROL"});
    

(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 } };

837 Willis Avenue, Albertson, NY 11507

What's special