523 E College St, Broken Arrow, OK, 74012
About This Home
FANTASTIC LOCATION!! A luxury primary residence with a rare, fully self-contained private apartment, perfectly positioned in the heart of the Historic Rose District. This custom home offers walkability to Main Street dining, festivals, and farmer’s markets while providing exceptional privacy on a prominent corner lot. The property blends a showstopping main residence w/an INDEPENDENT APARTMENT ideal for multi-generational living, an in-law suite, guest quarters, or income producing rental. The main home is designed to entertain, featuring a jaw-dropping 20x40 great room with 20’ vaulted ceilings, exposed beams, solid white-oak floors, and a stone fireplace with a hand-milled pecan mantle. The chef’s kitchen includes quartz countertops, a six-burner gas range, a built-in Frigidaire integrated column refrigerator/freezer, and two walk-in pantries. The main-floor primary suite offers a spa-like bath with a soaker tub, walk-in shower, dual vanities, and a large closet connected to the utility room, which includes a dog wash wet area, pet door, and under-counter kennel space. Additional spaces include a private office w/ bath, theater room, game room with a private deck, an interior workshop, and a laundry chute. The backyard features stone walkways, a firepit, and a gas outdoor fireplace with future pool potential. The fully self-contained private apartment lives as a true second home with a zero-entry (curbless) entrance, full kitchen with granite, in-unit laundry, a main-level accessible suite, upstairs loft w/ second bed and bath, and its own garage. Sound-insulated walls and separate mechanicals ensure privacy. Together, the property provides 5 bedrooms, 5 full baths, dual primary suites, dual kitchens, dual laundries, abundant storage throughout, two tankless water heaters, three high efficiency Trane HVAC systems, CAT6A wiring, HUGE unfinished walk-out attic, and garage parking for three vehicles. A rare combination of luxury, versatility, and location.
Getting Around
Schools
Construction
Condition
- Year built: 2021
Materials
- Foundation: Slab
- Roof: Asphalt,Fiberglass
- Construction materials: Brick,Wood Frame
Type & Style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Dryer,Dishwasher,Disposal,Microwave,Oven,Range,Refrigerator,Stove,Tankless Water Heater,Washer,Plumbed For Ice Maker
- Laundry features: Washer Hookup,Electric Dryer Hookup
Basement
- Basement: None
Bathroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 5
Bonus Room
- Level: First
Bonus Room
- Level: Second
Den
- Level: Second
Dining Room
- Level: First
Features
- Granite Counters,High Ceilings,Quartz Counters,Stone Counters,Ceiling Fan(s),Gas Range Connection,Gas Oven Connection
- Door features: Insulated Doors
- Window features: Vinyl,Insulated Windows
- Flooring: Carpet,Hardwood,Tile
- Number of fireplaces: 4
- Fireplace features: Blower Fan,Gas Log,Wood Burning
- Fireplace: Yes
Game Room
- Level: Second
Great Room
- Level: First
Heating & Cooling
- Heating features: Central,Electric,Gas,Multiple Heating Units
- Cooling features: Central Air,3+ Units
Interior Area
- Total structure area: 5,715
- Total interior livable area: 5,715 sqft
Kitchen
- Level: First
Living Room
- Level: First
Office
- Level: First
Primary Bathroom
- Level: First
Primary Bedroom
- Level: First
Utility Room
- Level: First
Property
Accessibility
- Accessibility features: Low Threshold Shower,Other
Details
- Parcel number: 78810841109180
Features
- Levels: Two
- Stories: 2
- Pool features: None
- Patio & porch: Covered,Deck,Patio,Porch
- Exterior features: Concrete Driveway,Landscaping,Lighting,Rain Gutters
- Fencing: Privacy
- Living area range: 5750-6000 SqFt
Lot
- Lot size: 0.29 Acres
- Features: Corner Lot
Parking
- Total spaces: 3
- Parking features: Attached,Garage,Garage Faces Rear
- Has garage: Yes
- Attached garage spaces: 3
- Covered spaces: 3
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Heat Wave
- Ice Storm
- Strong Wind
- Cold Wave
- Hail
- Tornado
How This Home’s Risks Compare
FEMA Declared Disasters in Tulsa County and Oklahoma
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $5,056 | $60,672 |
| Home Insurance | $879 | $10,548 |
| Property Taxes | $816 | $9,792 |
| Electricity | $425 | $5,101 |
| Total | $7,176 | $86,112 |
Income You'd Need if You Spent...
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-05-10 | Listed for sale | $1,125,000 |
| 2026-02-24 | Listing removed | $1,125,000 |
| 2025-10-16 | Listed for sale | $1,125,000 |
| 2025-10-16 | Listing removed | -- |
| 2025-09-26 | Listed for sale | $1,175,000 |
| 2020-07-02 | Sold | $95,000 |
| 2020-05-22 | Pending sale | $95,000 |
| 2020-05-22 | Listed for sale | $95,000 |
| 2018-12-04 | Sold | $88,000 |
| 2018-10-02 | Sold | $45,000 |
