Andrea M. LeFevre
Licensed Real Estate Salesperson
REALTOR®
Niskayuna, NY
social icon social icon 
New
View Full Photo Gallery

Property Description

Incredible live-work or investment opportunity situated on a high-utility 1.6-acre lot within the Starpoint School District! This highly unique, mixed-use property is a dream setup for business owners, contractors, or investors looking to maximize their rental yield by leasing both the residential and commercial components. The premier feature of this property is the massive detached garage setup consisting of 2 HUGE, high-capacity garages. With outstanding storage capability and workspace, this layout is an absolute match for an automotive shop, landscaping company, contracting business, hobby car enthusiast, or anyone requiring extensive equipment storage. The front garage includes 2 office spaces, and each garage has its own bathroom and heat and electric. With town approval and variance potential, these structures offer endless commercial possibilities. Complementing the workspace is an updated, turn-key 2-story residential home (1,537 sq ft) featuring cherry hardwood floors in the kitchen, living room, and upstairs bath. The layout offers a highly functional 1st-floor laundry, a 1.5-bath setup, a primary bedroom with a massive closet, and a 2-bedroom configuration that can easily be adapted into 3 bedrooms. Excellent mechanical updates provide peace of mind: brand-new windows (2025), a new hot water tank (2025), a sump pump with water backup, and a roof approximately 5 years old. The full basement offers additional dry storage. Outdoors, the 1.6 acres feature a beautiful above-ground pool with surrounding decks and a peaceful koi pond-perfect for relaxing after a workday. Live on-site and run your business, or rent out the home for steady passive income while utilizing the massive garages for your commercial operations. Don't miss this versatile, high-potential property!

4015 Mapleton Road | MLS# B1697630

This commercial property located at 4015 Mapleton Road, North Tonawanda, NY 14120 is currently listed for sale with an asking price of $499,900. Mapleton Road is located within the Starpoint school district. Search North Tonawanda real estate on andrea-lefevre.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Saturday July 18th, 1:00am - 3:00pm

Gallery

Property Features

Property Type: Commercial - Business
Basement: Full
Heating: Gas, Forced Air
Lot Size: 1.60 Acres
Roof Type: Metal, Shingle
Stories: 2.0
Taxes: $4,805
Year Built: 1945

Feature Descriptions

Building Features: Private Restrooms
Days on Site: 2
Exterior: Block, Concrete
Flooring: Carpet, Concrete, Hardwood, Varies
Lot: Rectangular, Rectangular Lot
Lot Dimensions: 155X451
Parcel#: 294000-135-003-0001-031-001
Parking: Common
Parking Notes: Common
Utilities: Electricity Connected, Water Connected
Water: Public

Local Schools

School District: Starpoint

Demographics

Listed By / Shown By

Listing By

Agency Name: eXp Realty
Agency Phone: 888-276-0630

Shown By

Agent Name: Andrea M. LeFevre
Agent Phone: (518) 810-5262 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 07/17/2026. The listing information on this page last changed on 07/17/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 07/17/2026 12:27:13 AM EST) or Global MLS (last updated Fri 07/17/2026 12:22:34 AM EST) or New York State Alliance MLS (last updated Fri 07/17/2026 12:23:04 AM EST) or Hudson Valley Catskill Region MLS (last updated Fri 07/17/2026 12:11:19 AM EST) or Berkshire MLS (last updated Thu 07/16/2026 8:13:11 PM EST) or OneKey MLS (last updated Fri 07/17/2026 12:21:29 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel

THANK YOU FOR
YOUR INTEREST!

Complete the fields below to receive additional details.

Add to Calendar

Reserve A Time

Cancel Your Appointment?

Registration Successful

You are now registered to view virtual open houses for the listings.