Map Location

Listed by William Jenkins of Weichert Realtors – The Hatmaker Group (4095269439)
The best house on the block! From first sight, its obvious, "Blue House" is special! After being a beloved family home for nearly a century, in Spring of 2023, started as a vacation rental. The house's historic charm has been meticulously maintained while the addition of contemporary appliances & amenities make it the prefect blend of charm & function. Special carries from the uniquely fenced front yard, dreamy front porch, tall door & windows, soaring ceilings, ginormous living room and dining room, wonderful "heart of the home" kitchen with state of the art appliances, the super private primary in the back of the house with private deck & hot tub, 3 more bedrooms down, a 5th bedroom upstairs & about 900 s.f of open loft space. Blue House's 5 bedrooms and loft will sleep approx. 20 people! Furnishings, decor, supplies & appliances, except for a few pieces of sentimental value the owners will be retaining, convey with the property. Much more info on the attached IMPROVEMENTS document

    Property Details of 3806 Avenue Q

    Property Details

    Interior Features

    Exterior Features

    Utilities and Appliances

    Community

    Based on information submitted to HAR MLS as of May 31, 2026 11:38 PM 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.