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

250 West Laurel Avenue
Mcminnville, TN 37110
Edward Perman with J.P. King Auction, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 7
Baths: Full: 7, ½: 1
Status: Active
SqFt: 11000 Square Feet
Agency: J.P. King Auction
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Online Real Estate Auction! Hickory Glen Estate: A Timeless Tennessee Retreat Nestled on 5 +/- Acres 250 West Laurel Avenue, McMinnville, TN LUXURY ONLINE AUCTION: BID ENDS May 20. Originally Listed for $2.7M. Starting Bids Expected Between $1.2M-$1.6M Nestled amidst 5 +/- acres of pristine Tennessee landscape, Hickory Glen Estate is more than just a home-it's an experience. As you approach this magnificent residence, a driveway winds gracefully toward the grand cobblestone entrance, where a stately fountain welcomes you with a touch of European elegance. The home's exterior, adorned with stone accents and rich architectural details, exudes a sense of permanence and sophistication, standing as a testament to impeccable craftsmanship. Towering trees provide a natural canopy, and at the edge of the property, the gentle murmur of Hickory Creek offers a tranquil retreat from the everyday world. Step through the grand entryway, and your eyes are immediately drawn to the exquisite herringbone-patterned hardwood floors-a detail that speaks to the home's thoughtful design. Soaring ceilings, sophisticated moldings, and an abundance of natural light set the stage for refined yet inviting living spaces. The heart of the home, an awe-inspiring chef's kitchen, is outfitted with Bertazzoni appliances, Taj Mahal quartzite countertops, and a stylish bar area featuring a dual-zone wine cooler-perfect for entertaining in style. The primary suite is a sanctuary of luxury, featuring a private Juliet balcony, spa-like bath, and two expansive closets designed to accommodate the most discerning homeowner. Upstairs, four additional bedrooms each boast en-suite baths and spacious walk-in closets, ensuring comfort and privacy for family and guests alike. 12% Buyer's Premium.
MlsNumber: --
ListingId: 11477253


Listing Provided By: J.P. King Auction, original listing
Agent Name: Edward Perman
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2515 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;
Real Estate Expert Photo for Sara Beth Bryant
Sara Beth Bryant
ASCIITree City Realty
Call Today!: (931) 205-4015

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App