Sign up to get new listings emailed daily! JOIN SIGN IN
(937) 478-1099 Email 937-478-1099
Sharon Geier
REALTOR®, e-Pro, SRES, DRA, LTG, ABR
(937) 478-1099
Facebook Icon LinkedIn Icon Pinterest Icon Instagram Icon Twitter Icon VCard Icon 

5280 Alert New London Road
Hamilton, OH 45013

$509,000

65 Total Photos [Click to View All]

SCHEDULE A PRIVATE TOUR Street View Call Print Email

Open House View All

Sunday, August 23rd | 12:00 pm - 2:00 pm
Add to Calendar Request a Private Showing

Listing Details

  • $509,000
  • MLS# 966412
  • Type Residential - Single Family
  • Status Active
  • 6
    Bedrooms
  • 4 full 2 partial
    Bathrooms
  • 4,766
    Square Feet
  • 2.090 acres
    Lot Size
  • 2001
    Year Built
  • Southwest
    Local Schools
MAP LISTING SHARE

Local Information

Listed By

Agency Name: Streetlight Realty LLC
Agency Phone: (937) 626-4181

Shown By

Agent Name: Sharon Geier
Agent Phone: (937) 478-1099
Agency Title: Irongate Inc., Realtors

IDX logo

Home Value Estimate

Description

RARE & VERSATILE LARGE SINGLE-FAMILY HOME ON 2.09 ACRES — WITH 3-UNIT POTENTIALUnique opportunity to own approximately 2.09 acres with a spacious, highly versatile property designed primarily as one expansive single-family residence, while offering flexibility for multigenerational living, guests, or a three-unit configuration. MAIN RESIDENCE — 4 BEDROOM / 3 BATHROOMSpacious 4-bedroom, 3-bath main residence with a long-term tenant currently in place who will vacate before closing. The home needs some cosmetic repairs and updating, offering an opportunity to add value.UPDATED 1 BEDROOM / 1 BATHROOM SUITEMassive, fully updated...read more

Features

  • Central
  • Natural Gas
  • 1.0 Story
  • $3,642 Taxes
  • Built in 2001

Upcoming Open Houses

Open House Sunday August 23rd, 12:00pm - 2:00pm
Open House Thursday August 27th, 6:00pm - 7:00pm
Print Open House Details
SUBMIT AN OFFERx

Listed By

Agency Name: Streetlight Realty LLC
Agency Phone: (937) 626-4181

Shown By

Agent Name: Sharon Geier
Agent Phone: (937) 478-1099
Agency Title: Irongate Inc., Realtors

IDX logo

Sharon Geier
Sharon Geier Office: (937) 436-2700 Cell: (937) 478-1099 Fax: (937) 535-6546 Email Me
LinkedIn IconPinterest IconInstagram IconVCard Icon
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 08/20/2026. The listing information on this page last changed on 08/20/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 Thu 08/20/2026 12:04:07 AM EST) or Dayton MLS (last updated Wed 08/19/2026 11:46:51 PM EST) or Multiple Listing Service of Greater Cincinnati (last updated Wed 08/19/2026 11:53:32 PM EST) or Wrist MLS (last updated Wed 08/19/2026 11:24:23 PM EST). Real estate listings held by brokerage firms other than Irongate Inc., Realtors 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.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register

THANK YOU FOR
YOUR INTEREST!

Complete the fields below to receive additional details.
No Thanks

Add to Calendar

Reserve A Time

Cancel Your Appointment?

Registration Successful

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