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 = 754 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 = 754 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 = 754 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;

3746 E Commodore Trail
Bloomington, IN 47408
Gigi Larmour-Goldin with RE/MAX Acclaimed Properties, original listing - (812) 332-3001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 11303 Square Feet
Agency: RE/MAX Acclaimed Properties
Agency Phone: (812) 332-3001

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Nestled on 5.7 acres of lush, partially wooded land in Lanam Ridgeview Estates this extraordinary one of a kind limestone home epitomizes luxury living at its finest. This six bedroom, five and a half bath home boasts over 11,300 square feet of meticulously designed interior space and over 2,500 square feet of balconies, patios, and porches. This residence offers a secluded retreat with unparalleled amenities. Step inside and be greeted by a grand foyer that sets the tone for the exquisite features that await. Floor-to-ceiling windows flood the home with natural light, illuminating the elegant spaces designed for seamless entertaining. Heated Italian marble floors grace the main level and master bath, while a floating marble staircase serves as a striking centerpiece. The heart of the home is the gourmet kitchen, equipped with a commercial range/hood, double-wide Thermador refrigerator, quartz countertops, breakfast bar and is open to the family room and breakfast nook creating an inviting atmosphere for gatherings. A spacious Butler's Pantry connects the kitchen to the dining room, offering ample storage and a wet bar/coffee station for effortless hosting. Retreat to the primary suite, complete with hardwood floors, fireplace, a luxurious bathroom, balcony and a dream custom luxury closet. Additional highlights include a separate office with intricate wainscot moldings and a spiral staircase leading to a library with coffered ceilings. The lower level is an entertainer's dream, boasting a large bar with appliances and kegerator, adjacent to a game room and a state-of-the-art theater. Unwind in the full-size gym or relax in the sauna before retiring to the guest bedroom with a steam shower. Other features include a cozy den, a main level ensuite, five fireplaces, a plethora of storage and a Control 4 system throughout the home. A circular driveway and a three-car garage provide ample parking, while an exterior sound and music system ensures seamless automation and security. Indulge in resort-style living with the newly installed in-ground saltwater pool or unwind under the shade of the pergola, where you can enjoy alfresco dining or simply bask in the serenity of nature. The meticulously manicured grounds, complete with irrigation system, provide the perfect backdrop for outdoor entertainment. Experience the epitome of luxury living in this unparalleled retreat, where every detail has been thoughtfully crafted to elevate your lifestyle.
MlsNumber: --
ListingId: 202412901


Listing Provided By: RE/MAX Acclaimed Properties, original listing
Phone: (812) 327-5608
Office Phone: (812) 332-3001
Agent Name: Gigi Larmour-Goldin
Disclaimer: Copyright © 2024 Bloomington MLS, Inc. 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 = 754 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;
Real Estate Expert Photo for Ruth Morton
Ruth Morton
ASCIIRe/MAX Acclaimed Properties
Call Today!: (812) 327-5648

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App