HomeAboutServicesSearchAI ToursListingsMarket ActivityBlogContact
Sheldon Barnes, Carmel Realtor

Is this your home?

Sheldon Barnes can help you list 2710 W State Road 38

Sheldon Barnes is a Carmel realtor and licensed real estate agent serving Sheridan, Indiana and the rest of Hamilton County. Whether you're ready to sell 2710 W State Road 38 in Hoffman or just curious what your home is worth in today's Sheridan market, he can put together a no-pressure valuation.

Follow

ABOUT THIS HOME

Exciting Chance to Own and Develop a Commercial Building near the bustling 38 in Northern Hamilton County. A rare opportunity awaits in Sheridan with high traffic and immense potential. The property, which would ideally be used for commercial purposes, requires repairs if the home is not torn down. The pricing accounts for the prime location and traffic for a commercial project. Rezoning would be necessary for the property, with neighboring lots zoned C-2. Details on the rezoning process and C-2 zoning are in attached docs. The buyer will be responsible for the property's rezoning and conducting all necessary assessments on the home/lot.

Listed by Isabella Clark· Weichert Realtors EPG· MLS# 22042350
Off Market353 days on market

$175,000

2Beds
1Baths
720Sq Ft

Exciting Chance to Own and Develop a Commercial Building near the bustling 38 in Northern Hamilton County. A rare opportunity awaits in Sheridan with high traffic and immense potential. The property, which would ideally be used for commercial purposes, requires repairs if the home is not torn down. ...

Listed by Isabella Clark· Weichert Realtors EPG· MLS# MBR22042350

720

Sq Ft

1948

Year Built

Off Market

Status

$92,100

Assessed Value

2

Bedrooms

Key things to know

  • High-traffic state road 38 frontage
  • Adjacent c-2 commercial zoning
  • 0.27 acre lot
  • Development/redevelopment opportunity

Browse by room

1 room · 5 photos

Price history

  1. Off market

    May 18, 2026

  2. Listedat $175,000

    May 31, 2025

Recent comparable sales

Estimated values and comparable-sales ranges shown here are for informational purposes only. They are derived from public records and recent MLS sales, are not an appraisal or formal Comparative Market Analysis (CMA), and should not be used as the sole basis for any pricing, purchase, sale, or financing decision. For an accurate market value of a specific property, contact Sheldon Barnes for a personalized CMA.

Sheldon Barnes

Sheldon Barnes

Real Estate Agent · Carmel Realty LLC

License No. RB21000235

AI-curated highlights

INSIDE THIS HOME

FEATURES & AMENITIES

Climate

Heat: OtherCool: Window Unit(s)

AI-detected from photos

Vibe:farmhouseoriginal

THE FACTS

Pricing trajectory, room-by-room layout, schools, and what's nearby.

Price history

  • $175,000Listed· May 31, 2025

353 days on market

Layout

Main
211 rooms720 sq ft

Primary suite

See Remarks

Schools

Sheridan Community Schools

    Neighborhood

    • Westfield High School7.4 mi
    • Clay Terrace10.3 mi
    • Carmel Arts & Design District11.5 mi
    • Carmel Central Park11.6 mi
    • Zionsville Community HS11.8 mi
    • Carmel High School12.1 mi

    OFF-MARKET PROPERTY DETAILS

    Living Area

    720 sq ft

    Year Built

    1948

    Stories

    One

    Subdivision

    Hoffman

    Bedrooms

    2

    Bathrooms

    1 full

    School District

    Sheridan Community Schools

    TAX ASSESSMENT

    Hamilton County assessed values for current year

    Total Assessed Value

    $92,100

    Land Value

    $31,200

    Land$31,200

    34% of total

    Improvement Value

    $60,900

    Improvements$60,900

    66% of total

    Annual tax · 2024
    $616

    PARCEL & LEGAL

    Powered by Ackee.ai