Map Location

Listed by Sterling Bond of Keller Williams Signature

Listing Sold by Coldwell Banker Realty - Heights
TURN KEY!!! NEW RENOVATION!!! Discover this Delightful Seaside Hideaway in Midtown. Spacious & Charming inside. Quartz countertops, handcrafted cabinetry, and hardwood floors made of reclaimed oak. Soak away the day in a clawfoot tub! Decorative light fixtures in the house. Hardy Siding, Low-E Windows, Updated Electricity, and a New Pex Plumbing. Recently Constructed Hot Tub Refuge in the Backyard. It is also a successful Vacation Rental right now. Situated in Flood Zone X is Undoubtedly Desirable! Schedule your showing today!

    Property Details of 5217 Avenue Q 1/2

    Property Details

    Interior Features

    Exterior Features

    Utilities and Appliances

    Community

    Based on information submitted to HAR MLS as of June 4, 2026 10:10 AM EDT . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

    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 Phyllis Browning Company Msg/data rates may apply. Msg frequency varies. Reply STOP to unsubscribe. Privacy Policy & Terms.

    Do not fill in this field:

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