Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
517 Charmony Frontage Rd, Sterling, CO 80751
About this home
Public Remarks: Unlimited potential on a great investment property located on the outskirts of Sterling. Close to shopping, restaurants and Northeastern Junior College most of these 54 units have fresh paint and the owner is replacing flooring and updating as units come available. New management is working feverishly to make this multi-unit the best in the Sterling area.
Redfin Estimate
Market trends in 80751, CO
Last updated September 2026
Buyer's Market
Seller's Market
Buyer's market
See all
Provided by Redfin
Sale history for 517 Charmony Frontage Rd
$23/sq ft
$29/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Property details
Parking
- Parking Features
- Other Parking: Parking Per Unit(1 Space/Unit)
Interior
- Heating & Cooling
- Heating: Yes
- Hot Water, Baseboard
- Interior Features
- Electric Range/Oven, Refrigerator
- Laundry Features: Common Area
- Multi-Unit Information
- Number of Units Total: 54
- Multi-Family Financial Information
- Cap Rate: 20.86
- Net Operating Income: 240000
- Tenant Pays: Deposit
Exterior
- Exterior Features
- Roof: Composition
- Land Information
- Road Surface Type: Asphalt
- Lot Information
- Horse(s): No
- Road Frontage Type: City Street
- Zoning: Multi-Fam
- Property Information
- Property Type: Residential Income
- Waterfront: No
- Subdivision Information
- Subdivision Name: Long Berg
- MLS Area Major: Logan
- Building Information
- Construction Materials: Brick/Brick Veneer
Financial
- Tax Information
- Tax Year: 2010
- Lease Information
- Gross Income: 240000
- Income Includes: Lease/Rents
- Operating Expense: 0
- Financial Information
- Listing Terms: Cash, Conventional
Utilities
- Utility Information
- Utilities: Natural Gas Available, Electricity Available
- Electric: Electric,Xcel
- Gas: Natural Gas,Xcel
- Sewer: City Sewer
Location
- HOA Information
- Association: No
- Association Fee: 0
- School Information
- High School District: Valley RE 1
- Elementary School: Other
- Middle or Junior School: Sterling
- High School: Sterling
- Location Information
- Directions: Property is located off of Hwy 138 on the Northeast outskirts of Sterling past Northeastern Junior College
- Unparsed Address: 517 Charmony Frontage Rd Sterling CO 80751
- Street Number: 517
- Street Name: Charmony Frontage
- Street Suffix: Rd
- City: Sterling
- State or Province: CO
- County or Parish: Logan
- Country: US
- Postal Code: 80751
- Coordinates: -103.190593,40.645347
- Latitude: 40.645347
- Longitude: -103.190593
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Multi-Family (5+ Unit)
- Year Built: —
- Year Renovated: —
- County: Logan County
- APN: —
Other
- Listing Information
- Attribution Contact: 9705939002
- Close Price: $900,000
- Photos Count: 1
- Possible Use: Multi-Family
- Special Listing Conditions: Private Owner
- Standard Status: Closed
- Listing Date Information
- Close Date: Wednesday, November 23, 2011
- Cumulative Days on Market: 97
- Days on Market: 97
- Listing Contract Date: Friday, August 19, 2011
- Modification Timestamp: Saturday, July 27, 2024 7:27 AM
- Home Information
- Levels: Two
- Year Built: 1965
Around this home
Schools
Public 3-5 • Assigned • 2.0mi
Public 6-8 • Assigned • 1.6mi
Public 9-12 • Assigned • 1.6mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
1% chance of being in a wildfire in next 30 years
7 days above 96° expected this year, 19 days in 30 years
Minor risk of severe winds over next 30 years
1 unhealthy days expected this year, 1 days in 30 years
Sun exposure
In this area, properties receive around 10.5 hours in June and 5.5 hours in December, placing it above the U.S. average for solar exposure.
Is this your home?
Track this home’s value and nearby sales activity
Nearby similar homes
New listings for sale in 80751
Home values near 517 Charmony Frontage Rd
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | 39383 Sq. Ft. | — |
5 Beds | 1.5 Baths | 2511 Sq. Ft. | $291,624 |
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | 8820 Sq. Ft. | — |
3 Beds | 1 Baths | 1250 Sq. Ft. | $296,481 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 1388 Sq. Ft. | $262,047 |
4 Beds | 2 Baths | 1908 Sq. Ft. | $273,496 |
More real estate resources
- Zip Codes
- Cities
- Popular Searches
| 80741 homes for sale | |||
| 80751 homes for sale |
| Merino homes for sale | |||
| Iliff homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.






















United States
Canada