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

2525 Spring Lake Court
Jones, OK 73049
Bill Wilson with McGraw REALTORS (BO), original listing - (405) 348-4422

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,800,000
Beds: 5
Baths: Full: 5, ½: 2
Status: Active
SqFt: 6496 Square Feet
Agency: McGraw REALTORS (BO)
Agency Phone: (405) 348-4422

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Nestled in the prestigious gated community of Sweetwater, this exquisite estate offers an unparalleled living experience, blending modern luxury with natural beauty. Situated on a sprawling 2.91-acre lot adorned with mature trees and positioned on the serene pond near Lake Arcadia, this property is conveniently located to I-35. Inspired by the rustic elegance of the Worman House at Big Cedar Lodge, the home was custom-designed by Jaggers Home Design in 2019. It features vaulted ceilings in the master and guest suites, and formal dining room. Extensive landscape lighting and highend finishes, including Pella windows and exterior doors. The heart of the home is the gourmet kitchen, equipped with a LaCanche range imported from France and two dishwashers, ideal for entertaining. The residence includes three laundry rooms, four interior fireplaces, and a state-of-the-art Sonos sound system for an immersive audio experience throughout. Entertainment is redefined in the large game room with a bar and HD golf simulator. Outdoors, the property boasts a twotier swimming pool and spa by Aquascape. Extensive landscape lighting highlights an outdoor kitchen complete with a grill, pellet smoker, refrigerator, and an outdoor golf green with a bunker. Additional luxuries include a four-car attached garage, dual driveways, and a fully enclosed back porch with Phantom Screens. Technology includes a Ring camera system, Ubiquiti Wi-Fi network, and AT&T Fiber internet, ensuring convenience and security. This exceptional home offers a blend of tranquility and sophistication, making it a perfect sanctuary for those who seek a luxurious, active lifestyle combined with the charm of a natural setting. Schedule your private viewing today to experienc e this home's unique blend of elegance, functionality, and serene living. Don't miss the opportunity to make this dream home your reality.<br /> Contact us now to secure your future in this exquisite estate.
MlsNumber: --
ListingId: 1146132


Listing Provided By: McGraw REALTORS (BO), original listing
Phone: (405) 348-4422
Office Phone: (405) 348-4422
Agent Name: Bill Wilson
Disclaimer: Copyright © 2024 MLSOK, 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 = 2180 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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 Alyxus Nerio
Alyxus Nerio
ASCIILRE Realty
Call Today!: (405) 315-7261

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App