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;

506 Flynn
Alva, OK 73717
Jessica Smith with Real Broker LLC, original listing - (855) 450-0442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $385,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: --
Agency: Real Broker LLC
Agency Phone: (855) 450-0442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: *Historic Downtown Alva Retail Gem for Sale!* A rare opportunity awaits to own a piece of Alva's history! This iconic commercial building, home to a thriving retail store since 1970, is now available for purchase. Located in the heart of downtown Alva, Oklahoma, this property offers a unique chance to own a beloved local retail business with a beautifully renovated apartment upstairs. *The Business:* The retail store has been a staple in the community for over 50 years, providing a consistent and loyal customer base. The current owner has built a thriving business with loyal and online clientele. The store will sell with everything you see in it. Walk in and begin work right away. The owner is committed to ensuring a seamless transition, offering a limited time of support and guidance to the new owner. The business will continue to operate as normal until the sale is complete, providing a turn-key opportunity for the buyer. *The Building:* The commercial building has been meticulously maintained and renovated to preserve its historic charm. The fully renovated store boasts modern amenities while retaining its original character. The property also features a large detached carport in the back with alley access. *The Apartment:* Located upstairs, the fully renovated two-bedroom, one-bathroom apartment is a stunning addition to the property. Complete with modern furnishings, this apartment is perfect for an owner-operator or as a potential rental income source. The patio, fully furnished and equipped for entertaining, has been a popular gathering spot for showers, parties, and more. *Key Features:* - Historic commercial building in downtown Alva, OK - Thriving retail store with loyal walk-in and online customer base - Fully renovated store and apartment upstairs - Two-bedroom, one-bathroom apartment with modern furnishings - Furnished patio perfect for entertaining - Large Detached Carport with Alley Access - Support and guidance from current owner during transition - Turn-key opportunity for buyer *Don't miss this chance to own a piece of Alva's history!* Call today to schedule a viewing and make this incredible property yours!
MlsNumber: --
ListingId: 20250135


Listing Provided By: Real Broker LLC, original listing
Phone: (580) 327-7915
Office Phone: (855) 450-0442
Agent Name: Jessica Smith
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