Listing Tools

Don't miss this all brick duplex in Shamrock Terrace with easy access to NoDa and Plaza Midwood. This property is not part of the HOA. Ideal opportunity for investors or live in one and rent out the other. 2 units. One side is completely remodeled with new kitchen and bath, restored wood floors and newer (2018) HVAC and tankless water heater. The other side has been kept up, but could use some TLC to get better rent potential. Both sides have a back patio/porch overlooking a spacious privacy fenced back yard. (each side seperately) Parking pad in front.
Listed by Tracy Honeycutt of Costello Real Estate and Investments LLC (tracyhoneycutt@costellorei.com)

Do not fill in this field:

I agree to receive marketing and customer service calls and text messages from USM Test Domain2. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

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

Schedule A Visit

Schedule a Visit

I agree to receive marketing and customer service calls and text messages from USM Test Domain2. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

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

Property Details

Interior Features

Utilities and Appliances

Community

Finance

Other Details

Map Location

Driving Directions

Broker Reciprocity © 2026 Listings courtesy of Canopy MLS as distributed by MLS GRID. IDX information is provided exclusively for consumers’ personal non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The IDX data is deemed reliable but is not guaranteed by MLS GRID and may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS.  Based on information submitted to the MLS GRID as of May 26, 2026 11:45 PM EDT . All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.

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 receive marketing and customer service calls and text messages from USM Test Domain2. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

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