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

4027 County Road 690
Meno, OK 73760
Tracy Bishop with Blevins & Co, original listing - (580) 297-5010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,900
Beds: 5
Baths: Full: 3
Status: Active
SqFt: --
Agency: Blevins & Co
Agency Phone: (580) 297-5010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Gorgeous Property on 5 acres!! Welcome to your dream home nestled on a secluded 5 acre lot, offering a perfect blend of modern amenities and natural beauty. This property is designed for those who cherish privacy and luxury in equal measure. The heart of this home is the open floor plan that seamlessly integrates the kitchen, dining, and the living room areas, creating a warm and inviting space ideal for entertaining or enjoying quiet family time. The open loft upstairs adds a touch of architectural elegance, offering a versatile space for relaxation or additional living quarters. The home features three bedrooms and one bathroom upstairs, providing ample space for family and guests. The upstairs also includes game room, perfect for recreation and fun. The downstairs area hosts an additional bedroom and bathroom, along side the primary bedroom. The primary suite is a private retreat featuring a luxurious bathroom with walk in shower ensuring easy comfort and convenience. An oversize mudroom with laundry facilities, cubbies, and plenty of storage space caters to all your organizational needs. The oversized garage includes a storm cellar, providing peace of mind during server weather. The home is equipped with a 22 kw generator, ensuring uninterrupted power supply. The lifetime replacement windows and new metal roof offer durability and energy efficiency. With 2 new HVAC units, Diamon Kote siding, and foam insulation, the home is as energy efficient as is beautiful. Additional features include 38x63 red barn perfect for storage, workshops, agriculture use, or greenhouse. This property is more than just a home, it's a lifestyle. Enjoy the peace and tranquility of rural living while being equipped with all the modern amenities you could desire. Make the stunning property your own today.
MlsNumber: --
ListingId: 20250679


Listing Provided By: Blevins & Co, original listing
Phone: (580) 227-5505
Office Phone: (580) 297-5010
Agent Name: Tracy Bishop
Disclaimer: Copyright © 2025 Northwest Oklahoma Association 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App