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

2123 Stone Pointe Court
Stillwater, OK 74074
Candy Yundt with KW Local, Keller Williams Realty, original listing - (405) 332-5553

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $840,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4530 Square Feet
Agency: KW Local, Keller Williams Realty
Agency Phone: (405) 332-5553

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: LUXURY LIVING in a quiet secluded area! This glorious, VERY LARGE custom built home has plenty of space inside and outside. From the front you will enter through the new beautiful blue 8' door with side panels by Pella. Inside, the over 4500 square feet of living space includes a very large master bedroom with an attached study & gas fireplace. The master bathroom has 3 closets, a soaker tub, walk-in shower, his & hers vanities, and a HEATED FLOOR. Entertain your friends with a formal dining room and formal living room with lots of natural light through the beautiful windows and available is convenient half bath for guests. Then enter into the butlers pantry and fully equipped gorgeous kitchen with custom cabinetry and pull out lower cabinets. The appliances are a professional Thermador gas cooktop, ultra quiet dishwasher, large stainless steel refrigerator, and extras include a warming oven, small refrigerator, and wine cooler (not warranted). The countertops were recently replaced with beautiful quartz and a new 14 gauge sink with new hardware has been installed. The kitchen eating area is open to a more casual living space with a stately rock fireplace (gas) and large built in cabinets. The laundry room has an abundance of storage and don't miss the walk-in pantry that doubles as a safe room with steel-reinforced concrete walls and ceiling. You an also feel safe because a security system is included. Nearby is the attached garage with an immaculate epoxy floor and storage cabinets. Outside the back door is a large covered patio and a second two-car garage with storage cabinets and space for more storage or additional cars. Back inside the home follow the hand-crafted and lighted stairway upstairs to 3 more bedrooms, 2 full baths, a media room (could be a bedroom), a catwalk overlooking the living areas and a completely finished 384 sq ft storage/bonus room that is heat and cooled. All the carpet in the home has been replaced and is heavy duty quality on top of a memory foam pad. Some of the interior has been painted and all 4 toilets have been upgraded to Kohler brand. Most of the sinks and toilets now have new water supply lines and the upstairs water heater has been replaced. Blown in fiberglass insulation has been added in the attic for efficient utility cost, and CREC is the electric company with Centranet for Internet. Outside you will notice professional landscaping with a sprinkler system, a private back yard and a giant patio. Also, a recently installed "trench" drain on the north side and where a glassed in porch originally existed 4 piers were recently installed. (warranty provided). Also, the aerobic septic pump is new. A sump pump under the heater plenum in the master bath closet was replaced as well. Most of the roof has 40 year Elk Prestique Level 4 hail/wind resistant shingles. METICULOUSLY KEPT, this home is one of a kind for special Buyers.
MlsNumber: --
ListingId: 131060


Listing Provided By: KW Local, Keller Williams Realty, original listing
Phone: (405) 533-3000
Office Phone: (405) 332-5553
Agent Name: Candy Yundt
Disclaimer: Copyright © 2024 Stillwater Board of Realtors. 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 = 2185 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 Marcie Howey
Marcie Howey
ASCIIThe Ponca City Real Estate Co
Call Today!: (580) 761-0416

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App