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

18005 S Sunset Avenue
Glenpool, OK 74033
Suzanne Rentz with Keller Williams Preferred, original listing - (918) 496-2252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3952 Square Feet
Agency: Keller Williams Preferred
Agency Phone: (918) 496-2252

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Enjoy a peaceful country lifestyle in this brand-new custom-built Farmhouse, just under 4,000 sq ft. Situated on a ONE ACRE lot in the desirable new Twin Ponds Community, this home boasts numerous upgrades & features that truly set it apart. Amenities include an inviting covered front porch, expansive back patio, 8-ft wood & rain-glass doors, solid maple flrs, soaring ceilings & abundant windows for natural light, and a unique, .The kitchen is a chef's dream, featuring dbl ovens, space for a dbl wide refrigerator, a lg walk-in pantry & an oversized island. Entertain in style w the prep kitchen w add'l torage, prep space/coffee bar, and 2nd dishwasher & ice maker. The 2nd dining or opti'l sitting area includes built-in bookshelves & wine fridge. Primary bedroom serves as a retreat w French doors leading to lg covered back porch, elegant ensuite bath w a soaking tub & an oversized step-in shower & a spacious dressing closet with shoe and bag shelves and a built-in dresser. Addi'l amenities on main level include a lg mudroom & an office/flex room, a 2nd full ba conveniently located near the gar/backyd—if you ever want to add a pool. Upstairs features an extra-lg game rm complete w a mini-fridge, 2 beds & a full bath w a tub on one side, & a spacious bed w a private bath on the other. The 3-car garage has an epoxy floor, side entry, LED lighting, & ample dwy parking. This home also includes open-cell foam insulation, architectural, metal roofs & broadband fiber optics. The backyard offers unlimited possibilities w ample space for a pool/shop. Conveniently located w quick access to Hwy 75, less than 4 mi to St. Francis Hospital, near new Outlet Mall, less than 8 mi to Creek Tke & only 10 mi to Tulsa Hills, this neighborhood provides easy access to amenities while offering a rural escape with wildlife views. Twin Ponds Community's future plans include walking trails and stocked ponds! Located in Glenpool school district with city water. Map as 2333 W 181st St S, Mounds.
MlsNumber: --
ListingId: 2437488


Listing Provided By: Keller Williams Preferred, original listing
Phone: (918) 232-7230
Office Phone: (918) 496-2252
Agent Name: Suzanne Rentz
Disclaimer: Copyright © 2024 MLS Technology, 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 = 2197 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;
Carolyn Blecha-McClary
ASCIISolid Rock Realtors
Call Today!: (918) 639-8875

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App