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

1420 Apple Alley St.
Bartlesville, OK 74003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $451,250
Beds: 5
Baths: 4
Status: Active
SqFt: 5131
Agency: American Homes

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1980
Notes: Welcome to this exclusive custom-built home in the Grove Subdivision of Bartlesville. This exquisite property was built and designed to last. Starting with a full concrete basement of 3,585sqft (per appraiser) with full bath, laundry, rec room, utility, safe room, dumbwaiter, workshop and elevator motor room. As you enter the home you will be taken back at how grand the size and height of the rooms on the first floor are. The first floor consists of a grand living area, formal dining, library, kitchen, 2 bedrooms and 2 1/2 baths and laundry room. The second floor boasts 2 bedrooms and 1 bath while the third floor has an amazingly large bedroom with private bath. From the first floor exit out the living room into a beautiful sunroom that takes you out to a large deck with stairs leading down to a private covered patio. This home is comprised of high-end materials and details that will leave you breathless. Not including the basement, this home has a living space area of 5,131sqft (per appraiser). The back yard is a private retreat surrounded by a brick privacy wall while overlooking beautiful undeveloped prairie land. Guidelines to make an offer will be provided at point of interest. "Property sold "As-Is" Buyer and/or buyer's agent responsible for verifying all pertinent information deemed relevant by the prospective buyer, including but not limited to square footage, acreage, utilities, taxes, zoning, permitting condition, school zones, HOA's, etc."
MlsNumber: 48267


Listing Provided By: American Homes, original listing
Name: American Homes
Phone: (620) 251-4663
Office Name: American Homes Realty
Office Phone: (620) 251-4663
Agent Name: Rhonda Sutherland
Disclaimer: Copyright © 2024 Southeast Kansas Multiple Listing System. 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