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

28647 Jefferson Rd.
Alva, OK 73717
Ky Pfleider with Great Plains Land Co., original listing - (405) 623-1591

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,937
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2300 Square Feet
Agency: Great Plains Land Co.
Agency Phone: (405) 623-1591

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Welcome to this stunning 2,300 sq. ft. home with four bedrooms, two bathrooms, and two living areas, all nestled on 160 acres in Northwest Oklahoma, now being offered with the option to purchase 25+/- acres. This one-year-old house has all the modern touches, including block skirting, guttering, front and back porches, and a powerful 26 KW Generac generator. The home also features a 30x30 carport-style breezeway that connects to a spacious 30x40 shed with two large garage doors, a walk-through door, and two windows. Inside the shed, there's a handy 10x15 walk-in room for extra storage. The property is perfect for those who love the outdoors. There are three outbuildings, a top-notch domestic water well, three cross-fenced pastures, a sturdy corral near the county road, and quality gates, plus an automatic cattle waterer. A highlight of the property is the beautiful pond just below the house, ideal for fishing and relaxation. This area is rich with wildlife, including deer, turkey, and quail, making it a hunter's paradise. The rolling terrain includes three hayfields and canyon breaks, providing excellent conditions for livestock to thrive. Whether you're looking for a place to live, hunt, fish, or invest in agriculture, this property has it all. Located just 14 miles west, north 3, and back west 1 mile of Alva, Oklahoma, it's a must-see! no minerals Check LandID map for 360 viewing below 2,300 sqft Gorgeous Home 4 Bed, 2 Bath 30X30 Breezeway / Carport 30X40 Shed Generac Generator 25+/- acres Water well Automatic Cattle Waterer Cross Fencing Beautiful Pond Hunting Fishing Grazing
MlsNumber: --
ListingId: 11381041


Listing Provided By: Great Plains Land Co., original listing
Phone: (405) 623-1591
Office Phone: (405) 623-1591
Agent Name: Ky Pfleider
Disclaimer: Copyright © 2024 My State MLS. 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