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;

6000 W 9th Street
Cushing, OK 74023
Sharyl Pickens with Metro First Realty Unlimited, original listing - (405) 385-1872

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2803 Square Feet
Agency: Metro First Realty Unlimited
Agency Phone: (405) 385-1872

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: CUSTOM BUILT HOME - spared no detail or expense. This property has it all. Inside and out, it's perfect. Quality finishes, custom cabinetry, engineered wood and tile flooring throughout. 20 seer heat pump will withstand these Oklahoma summers. Spray foam in all exterior walls -energy efficiency at its best. Cable lock foundation - rock solid. GENERAC whole house generator - those ice storms and surges don't have a chance here. Tankless water heater. Salt water pool with new liner is the icing on top. The beauty inside is exquisite - top of the line. Kitchen boasts all granite counters and a center island. Wine fridge, gas stove, breakfast bar, gorgeous cabinet. Makes me want to do a cooking video. Open living room features a fireplace with gas logs and tray ceiling. French doors take you to your outside oasis. Office/study/toy room/gym located near living and entry. Extra area for either formal living or dining. TWO PANTRIES. Yes...you need that much storage. Powder room for your guests. The primary bedroom is a show stopper. An exit door and plenty of room for your favorite furniture. The primary bath and closet area is unmatched. A changing area, vanity, and built in dresser are just the beginning. Soaker tub and walk in shower, double vanities, and plenty of storage make this home a no-brainer. Additional bedrooms are carpeted and share a Jack and Jill bath. Utility room is large with granite counters, ironing board, and a sink. You'll enjoy doing laundry. Ceiling fans throughout. Outside - more than you can imagine. The small20x30 metal shop is great for a business venture or extra storage. The 30x50 metal shop has 600 sq ft living space inside - bedroom, bath, kitchen. Overhead door plus pedestrian entrance to living quarters. Aerobic septic, outside under eave lighting, 50-year impact resistant shingles, a flag pole, security system, child's play house, circle drive. SAFE ROOM in garage...do I really need to keep going? Get yourself an appointment ASAP.
MlsNumber: --
ListingId: 1133546


Listing Provided By: Metro First Realty Unlimited, original listing
Phone: (405) 385-1872
Office Phone: (405) 385-1872
Agent Name: Sharyl Pickens
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 = 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