Skip to main content
CityHomes: Homes For Sale and Homes for Rent


Located at 5874 Shetland Court, Hamilton, Ohio 45011, this Single Family is for Sale with a price of $689,900 USD. The property includes 4 bedrooms, has 2 full baths and 3 partial baths. This listing has 2,868 Sq.Ft. of interior space on a lot of .92 Acres. See all Homes for Sale in Hamilton.
Contact Agent
global settings
OhioHamilton5874 Shetland Court
ResultsBackNext

5874 Shetland Court
Hamilton, OH 45011

$689,900
for sale
Expand
1. 5874 Shetland Court
4 bd2 baSingle Family
Tools
Brochure
Size
Financial
Listing Details

Description

5874 Shetland Court,

Hamilton, OH 45011

Gorgeous new Brookstone plan by Schmidt Builders in the beautiful brand new community of Shetland Farms featuring a soaring 2 story foyer. Very open plan with an island kitchen stainless steel appliances, beautiful cabinetry with quartz counters, pantry and walk-out morning room and a formal dining room all with a view to the huge great room with gas fireplace with stone surround. A flex room and full bathroom round out the first floor. Upstairs homeowners retreat with an en suite that includes 2 separate vanities, large shower, water closet and large walk-in closet. There are 3 additional bedrooms and a centrally located hall bathroom. Full basement with full bath rough-in and a 3 bay garage.

This is an Active listing.

Broker Office Phone Number: 513-469-2424

Copyright © 2024MLS of Greater Cincinnati, Inc.. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Amenities

  • Dishwasher
  • Fireplace(s)
  • Garbage Disposal
  • Patio
  • 1 Fireplace
  • Washer / Dryer
United States Real Estate
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District Of Columbia
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
+Show More

All information is from sources deemed reliable but is subject to errors, omissions, changes in price, prior sale or withdrawal without notice. No representation is made as to the accuracy of any descriptions, measurements, square footages or acreage and should not be relied upon as such. All information herein should be confirmed by the customer. All rights to all content, including but not limited to photographs, videos and other graphics, are reserved to exclusively to the Broker who supplied such listing content. All advertising on this site is subject to the Federal Fair Housing Act.

© 2022 CityHomes.com

Powered by Gabriels Technology Solutions
Listing By: HMS Real Estate via Data Source: MLS of Greater Cincinnati, Inc. 
4
Bedrooms
2
Full Baths
3
Partial Baths
$689,900
Change Currency
$241
Price Per Sqft
Single Family
Property type
10011940
Web Id
1791651
MLS ID
344
Days Posted

Price History

datepricevariancetype
12/7/2023$689,900-Listed
listing agent: Alexander Hencheck
more info
2,868 Sq Ft.
interior
0.92 Acres
Exterior
  • Gebruiksvoorwaarden
  • Privacybeleid
  • Agent-producten
  • Makelaarsproducten
  • Toon uw vermeldingen
  • Feedback
  • Sitemap
  • Agent inloggen
    • header_bg_image
    phone_agent_image

    Inquire

    email_agent_image

    Request information

    Schedule Property Tour

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service

    CONSENT. By proceeding, you consent to receive calls and texts at the number you provided, including marketing by autodialer and prerecorded and artificial voice, and email, from Move, Inc., Move Sales, Inc., Opcity, Inc., realtor.com, and their network of service providers, about your inquiry and other home-related matters, but not as a condition of any purchase. Msg/data rates may apply. This consent applies even if you are on a corporate, state, or national Do Not Call list.

    header_bg_image
    phone_agent_image

    Inquire

    email_agent_image

    Request information

    Schedule Property Tour

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service

    CONSENT. By proceeding, you consent to receive calls and texts at the number you provided, including marketing by autodialer and prerecorded and artificial voice, and email, from Move, Inc., Move Sales, Inc., Opcity, Inc., realtor.com, and their network of service providers, about your inquiry and other home-related matters, but not as a condition of any purchase. Msg/data rates may apply. This consent applies even if you are on a corporate, state, or national Do Not Call list.

    • Sales
      • United States Homes for Sale
      • Atlanta Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Austin Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Boston Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Chicago Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Dallas Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Las Vegas Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Miami Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • New York City Apartments for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Philadelphia Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
      • Washington DC Homes for Sale
        • All Listings
        • Open Houses
        • Price Reduced
        • New Listings
    • Rentals
      • United States Homes For Rent
      • Atlanta Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Austin Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Boston Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Chicago Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Dallas Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Las Vegas Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Miami Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • New York City Apartments for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Philadelphia Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
      • Washington DC Homes for Rent
        • All Listings
        • Open Houses
        • New Listings
    • Buildings
      • All Buildings
      • New Home Communities
        • Single Family
        • Condo/Townhouse
      • Adult/Senior Communities
    • Locations
    • Agents
      • United States Real Estate Agents
      • Atlanta Real Estate Agents
      • Austin Real Estate Agents
      • Boston Real Estate Agents
      • Chicago Real Estate Agents
      • Dallas Real Estate Agents
      • Las Vegas Real Estate Agents
      • Miami Real Estate Agents
      • New York Real Estate Agents
      • Philadelphia Real Estate Agents
      • Washington DC Real Estate Agents
    • City Sites
      • CityHomes
      • Atlanta
      • Austin
      • Boston
      • Chicago
      • Dallas
      • Las Vegas
      • Miami
      • New York City
      • Philadelphia
      • Washington DC
    • Products
      • Agents
      • Brokers
      • Franchises
      • Display Your Listings