Technical
Financial
Distress signals
Property profile

415 Columbia St Lafayette, IN 47901

FOR LEASE
Office buildings
Property ID
US31-0737721
45,496 SF Built 1999
Entity Owned ~ Est. High Equity
Saved · see the list in your Dashboard

Property summary

AI-generated overview

The property is a multi-tenant office condominium building being converted into office condo units configured as two commercial condos per floor. The west portion of the first floor and the entire second floor have been occupied historically by long-standing businesses, while the east-side first-floor space includes exterior signage rights. The building also includes two third-floor condo units, identified as 3A and 3B, which are part of the condo structure and can be owned individually; unit 3A has operated with multiple tenants under a leased configuration, and unit 3B is provided as unoccupied space within the same floor plan. The property is located at 415 Columbia Street in Lafayette’s central business district, approximately one mile from Purdue University, within an area characterized by a mix of retail and professional service businesses and a residential population. The condo structure is designed for independent ownership of units across floors.

Property profile

Verified
Property type Office buildings
Use group OFFICE BUILDING (MULTI-STORY)
Year built 1999
Total area 45,496 SF
APN 79-07-20-072-004.300-004
UPID US31-0737721

Cap rate & NOI

Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors

Current use

Occupant on record · Public records
  • Physician Medical Clinic
  • Insurance Agency
  • Financial Advisor
  • Law Firm
  • Financial Advisor

Location

415 Columbia St Lafayette, IN 47901
Lafayette metro Census 11100 LAFAYETTE-WEST LAFAYETTE, IN METROPOLITAN STATISTICAL AREA
Google Maps

Value estimations

Realmo proprietary · 4 methods
AI Approach AI
by Request
CAP Approach CAP
by Request
Comparable Approach Comparable
by Request
Blend (final) Blend
$4.78M

Owner & transaction history

since 2026
2 recorded transactions
2026
Price N/A
2026
Price N/A

Comparables

6 recent transactions · within 1.5 mi
Comparable in this city
6 recent transactions
Recent comparable sales
Sale price & price/SF · Sale date & distance · Adjustments & confidence
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message