Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 793 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 793 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 793 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2863 S 150 E
Columbia City, IN 46725
Brad Minear with Minear Real Estate, original listing - (260) 244-0009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4113 Square Feet
Agency: Minear Real Estate
Agency Phone: (260) 244-0009

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Nestled on 3.84 manicured acres, this exquisite residence epitomizes the perfect blend of refined luxury and everyday comfort! A stamped concrete sidewalk leads to the inviting covered front porch, setting a grand tone before entering over 4,000 square feet of thoughtfully designed living space. The split-bedroom floor plan offers ultimate privacy, with the primary suite tucked away on one side of the home and two additional main floor bedrooms, connected by a Jack and Jill bath on the other. A spacious family room adorned with a gas-log fireplace and expansive windows showcases breathtaking backyard views, while elegant details such as coffered and tray ceilings, arched doorways, and shaker-style wainscoting enhance the home’s architectural charm. The chef’s kitchen is a true centerpiece, featuring premium stainless steel appliances, custom cabinetry, and a large island, flowing into formal and informal dining areas. The luxurious primary suite includes a walk-in closet with floor-to-ceiling storage and a spa inspired ensuite with a soaking tub, double vanity, walk-in shower, and private commode. Each of the bedrooms includes a walk-in closet. A beautifully lit staircase leads to a finished basement designed for entertaining, complete with a cozy fireplace, sprawling recreation area, kitchenette and bar, guest bedroom, full bath, office (or fifth bedroom), and a state-of-the-art theater room with a sunken floor and pocket doors. Under the stairs, a charming reading nook with dedicated lighting offers a quiet retreat. The three-seasons room with its own fireplace is ideal for relaxing evenings. Additional highlights include a stylish laundry/mud room with built-ins, utility sink, and hard-surface counters, plus a pristine three-car garage with epoxy flooring and another staircase leading to the basement. A 30x40-foot pole barn adds versatile storage or workspace. Whole home Generac generator and hot tub to remain with the home as well as all appliances including washer and dryer. This property is a true showcase of timeless elegance and serene country living.
MlsNumber: --
ListingId: 202515044


Listing Provided By: Minear Real Estate, original listing
Phone: (260) 609-6001
Office Phone: (260) 244-0009
Agent Name: Brad Minear
Disclaimer: Copyright © 2025 Upstate Alliance of REALTORS® Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App