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','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

4715 S Longmeadow Drive
Columbia City, IN 46725
Bradley Noll with Noll Team Real Estate, original listing - (260) 557-1334

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2898 Square Feet
Agency: Noll Team Real Estate
Agency Phone: (260) 557-1334

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: This home will absolutely take your breath away the moment you walk through the door. Built by Arbor Homes, every detail has been meticulously planned. The office is located at the front of the house and includes such details as French pocket doors, wainscoting and coffered ceilings. The family room has vaulted ceilings with wooden beams and plenty of built-ins. Enjoy the open concept as you entertain friends and family. The oversized island is a perfect gathering place and the kitchen is a chef’s dream. The gas cooktop, upgraded refrigerator, and double ovens are part of the GE Café appliances. There is even a hidden pantry for extra space in the kitchen. Plus, the home features a Kinetico K5 Pure Ultra Drinking Water System, offering the highest level of purified water right at your fingertips. The primary suite is an oasis in itself. The oversized window seats are perfect for curling up with a good book. The private bath has a freestanding tub, dual vanities, tiled walk-in shower, and a huge his and her closet. The stairs to the 2nd level are located at the back of the house where you will also find the laundry room, locker area with bench, and powder room. Upstairs are 2 additional spacious bedrooms that share a 2nd full bathroom. The walk-in attic is ideal for storage—no more walking up those pull-down stairs. The 3-car garage has a utility room and separate storage room. The home has dual climate control, water softener, reverse osmosis, and so much more. Outdoors is your own piece of paradise. Never miss a game while you relax on your outdoor patio and cozy up to the fireplace. The 5-foot deep pool with fountains is perfect for the kids or grandkids to enjoy the warm summer days, and the hot tub (staying with the home) is perfect for those cooler evenings. On nearly 2 acres, you get the best of both worlds—the comfort of a neighborhood and the serenity of the country. You really must see this one to appreciate it, so schedule a private tour today!
MlsNumber: --
ListingId: 202512929


Listing Provided By: Noll Team Real Estate, original listing
Phone: (260) 710-7744
Office Phone: (260) 557-1334
Agent Name: Bradley Noll
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