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;

1511 S Ashton Avenue
Stillwater, OK 74074

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: This stunning Greg Avery built home located in Stillwater’s sought after Berry Creek neighborhood is situated on a premium lot. A rare find with serene green space views, providing a sense of tranquility and privacy. The captivating exterior features a refined combination of brick, stucco, and rock. The quality craftsmanship is evident throughout, as you step inside hardwood floors expand the entry to the open living area, you will notice the soaring ceilings, and tall windows that create an inviting sun filled space. The living room, centered around a cozy fireplace, flows seamlessly into the heart of the home. The kitchen is equipped with center island, stunning granite countertops, beautiful tile backsplash, and top-of-the-line stainless steel appliances, perfect for culinary enthusiasts and entertainers alike. Enjoy the large, covered patio accessible from the living area, equipped with canned lighting, ceiling fan, and gas grill hook-up, an ideal spot for outdoor entertaining and relaxation. The private master suite is a true retreat, featuring a spacious bedroom, a large walk-in closet, and an adjoining master bath with luxurious finishes. For added convenience, the master closet connects directly to the laundry room, streamlining your daily routine. Adjacent to the laundry is a convenient built-in desk alcove, offering a hidden workspace just off the entry, a nice addition for those who work from home or need a dedicated study area. All bedrooms are thoughtfully situated on the first floor, ensuring easy access and comfort. The secondary bedrooms share a stylish Pullman bath, with separate sinks allowing for both functionality and privacy. Upstairs, you will find a versatile bonus room with a half bath, ideal for a home theater, playroom, or additional guest space. Wood, tile, and hard-surface flooring run throughout the entire first floor, adding elegance and durability. The property also includes a 3-car garage with a newly added storm shelter, for peace of mind. Meticulously maintained, this thoughtful layout includes ample storage, and offers a blend of luxury, comfort, and functionality, perfect for modern living. Schedule your own private tour today!
MlsNumber: --
ListingId: 129881


Listing Provided By: KW Local, Keller Williams Realty, original listing
Phone: (405) 332-5553
Office Phone: (405) 332-5553
Agent Name: Lori Liston
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