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

3526 Evans Avenue
Mannford, OK 74044
Mac McIntire with Chinowth & Cohen, original listing - (918) 419-2333

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3736 Square Feet
Agency: Chinowth & Cohen
Agency Phone: (918) 419-2333

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 43 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Welcome to this stunning, custom build on 40 acres of serene land. A full brick and stucco home<br /> guarantees you low maintenance and energy efficient living. As you enter through the custom,<br /> iron double entry doors you will be wowed by the finishes of this home. Solid wood flooring and<br /> a timeless tile shine throughout. The kitchen features Knotty Alder stained cabinets, a large<br /> island topped with exotic 6cm granite and a chiseled edge, a walk in pantry and eat in breakfast<br /> nook overlooking the pool. The formal dining boasts a vaulted ceiling with solid wood beams<br /> and provides ample space for a 10ft table. The primary suite has double entry/exit doors to the<br /> patio/pool, his and hers vanities, whirlpool tub, full tile shower and built-in dresser in large<br /> closet. A convenient feature of this home is the full utility bathroom located just inside the<br /> laundry room with an access door to/from the pool. Speaking of the pool, it's a custom gunite<br /> pool with a tanning ledge, wall seating and optional heat for year round use. Extensive decking,<br /> a cedar pergola and a brick retaining wall borders this patio making it the ultimate entertainment<br /> spot. If the oversized 3 car attached garage isn't enough space, drive on back to an additional<br /> 1200sf +/- shop with 2 overhead doors to store your weekend toys and equipment.<br /> Legal: 21-19-9 S N S NE BEG SE/C NE/4 TH N 00D00'14"E 980.22' ALONG E LINEOF SECT 21, TO A PT ON THE N LN S/2 N/2 S/2 OF THE NE/4 TH S 89D42'06"W ALONG SAID N LN 813.64' TO THE POB, TH CONT ALONG SAID N LN ON THE SAME BEARINGS (S89D42'06"W) 301.07' TH S00D0 8'01"E 327.70' TH N89D39'00"E 301.07' TH N00D08'01"W 327.44' TO POB CONT 2.26 ACRES M/L
MlsNumber: --
ListingId: 2431936


Listing Provided By: Chinowth & Cohen, original listing
Phone: (918) 694-1956
Office Phone: (918) 419-2333
Agent Name: Mac McIntire
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 = 2144 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