How to query the content of a specific custom post type?

On your custom post type’s single page, you want to treat it similar to your standard post single template. For the most part, you should wrap everything in your single template in one loop like so:

<? get_header(); ?>
    <? if(have_posts()): while(have_posts()): the_post(); ?>

    <!--Your content goes here-->

    <? endwhile; endif; ?>
<? get_footer(); ?>

As far as custom taxonomies are concerned, you may want to look into custom taxonomy page templates: http://codex.wordpress.org/Template_Hierarchy#Custom_Taxonomies_display

You can make a template like taxonomy-neighborhood.php, and then include the loop and all functions necessary to display all your listings in each neighborhood. This template will then automatically display whatever neighborhood was queried, allowing you to link directly to pages like yoursite.com/compton or yoursite.com/brooklyn. This functionality is very similar to how your single page is used to display any house.