Peter Westwood

This plugin allows you to run loops within your WordPress templates where you query for children of the current page.
The plugin extra arguments to the list of arguments supported by query_posts().
The query argument <code>child_of</code> is used to add a WHERE to the database query to limit the pages returned to those with a post_page equal to the argument provided.
The query argument <code>child_limit</code> is used to limit the number of pages returned.
The query argument <code>child_offset</code> is used to offset the limiting to allow for pagination if required.

PJW Query Child Of

This plugin allows you to run loops within your WordPress templates where you query for children of the current page.

wlindley

Two widgets are provided, for displaying a vastly condensed 
hierarchial list either of pages, or of categories and custom 
taxonomies. Designed for large sites with hundreds of pages, or when 
using custom post types or custom hierarchical taxonomies.
With Pages: Always displays the current page, the pages above it back 
to the home page, and the current page’s children. Detects nested 
categories and custom taxonomies, and likewise displays the categories 
or taxonomies above and below the currently displayed one.
The behavior of the widget is all configurable through its 
configuration screen, as follows:
<ul>
<li>The Categories widget will also display custom taxonomies. 
The admin screen includes a list of the defined ones; 
leave the field blank to use the built-in post categories.</li>
<li>The title is optional (blank will emit no heading); with 
a blank heading and top-level entries (pages/categories/ 
taxonomies) disabled, you can have the widget only display 
when the user is “currently inside” a page/post that matches 
what the widget is set to display.</li>
<li>Pages may be sorted in Menu Order or alphabetically. 
To sort pages in menu order, with pages of the same order 
alphabetical, set the Sort Field parameter to: 
menu_order,post_title … some sites have reported issues 
and seem to require that only menu_order be specified.</li>
<li>Categories and custom taxonomies may be sorted by name, 
slug, or other fields displayed on the admin form.</li>
<li>Sort order can be ASC or DESC</li>
<li>Siblings to the current page, if enabled, means that child 
pages of the current page’s parent will be displayed. 
Disabling this makes for shorter page lists but the user 
might not be able to move “sideways” in the site.</li>
<li>If there are many top-level pages (pages with no Parent set), 
you can disable their listing.</li>
<li>If your site has an Introduction or splash page, as a static home 
page, you might want to disable showing it (presumably it is 
accessible through an icon link). However, if the homepage has 
children, it will always be displayed (otherwise you could never 
navigate to those pages).</li>
<li>For Pages, you may optionally specify a meta-key and value 
which must be matched for pages to be listed in the widget.</li>
<li>Also for Pages, you may select posts that match a given 
Author or post status. Leave these blank for “all authors” 
and “publish” status.</li>
<li>Empty categories/taxonomies may be hidden.</li>
<li>Both plugins permit specifying either an include list or 
an exclude list. These are comma-delimited lists of 
ID numbers. You may specify either include or exclude, not both.</li>
</ul>
Spanish translation provided courtesy Andrew Kurtis of WebHostingHub.com 
Thanks, Andrew!

Hierarchical Pages Widget

Two widgets are provided, for displaying a vastly condensed

PJW Query Child Of vs Hierarchical Pages Widget