CMS

Listing Tools

CHARACTER, SPACE & POTENTIAL! This spacious 4-bedroom, 2.5-bath stone home is loaded with possibilities and ready for someone with the vision to bring it back to life! Situated on a corner lot, this home offers timeless stone construction, hardwood floors, two fireplaces, and plenty of room to spread out. The enormous second-floor bonus room offers incredible flexibility and could serve as an oversized bedroom, family room, hobby space, home office, or whatever suits your needs! Additional features include a partially finished basement and a one-car detached garage. While the home is in need of repairs and updates, its generous size, unique character, and versatile layout offer an exciting opportunity to restore its charm and make it your own. Bring your imagination and your contractor! Property is being sold STRICTLY AS-IS, with the seller making no repairs. Due to the property's condition, FHA and VA financing are unlikely to be suitable. Cash or conventional financing recommended, subject to lender approval.

Property Details of 1900 Frederick Street

Map Location

Driving Directions

Courtesy of Coldwell Banker Premier

Copyright 2026 BRIGHT, All Rights Reserved.  Information Deemed Reliable But Not Guaranteed. The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Jeremy Cunningham participates, and is provided by BRIGHT through a licensing agreement. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.Data last updated October 31, 2026. Some properties which appear for sale on this website may no longer be available because they are under contract, have Closed or are no longer being offered for sale.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to be contacted by Jeremy Cunningham via call, email, and text for real estate services. We use SMS to confirm appointments, send reminders, and notify clients of schedule updates or important changes. You can cancel the SMS service at any time. Just text "STOP." After you send the SMS message "STOP" to us, we will send you an SMS message to confirm that you have been unsubscribed. After this, you will no longer receive SMS messages from us. If you want to join again, just sign up as you did the first time, and we will start sending SMS messages to you again. If you are experiencing issues with the messaging program, you can reply with the keyword “HELP” for more assistance, or you can get help directly at Jeremy@Railey.com. Carriers are not liable for delayed or undelivered messages. As always, message and data rates may apply for any messages sent to you from us and to us from you. Message frequency may vary. If you have any questions about your text plan or data plan, it is best to contact your wireless provider. If you have any questions regarding privacy, please read our Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.