bungalow

Properties

Sort By:  
3 Bed Bungalow - Semi Detached 
SSTC

(SSTC) Cromer Drive, Atherton M46 0QE

Offers over £240,000

EXPRESS LET & SALES are pleased to bring this beautifully presented Freehold three bedroom bungalow to market for sale. This property is spacious, light and airy and benefits from gas central heating, double glazing, off road parking for several vehicles and with gardens to the front, side and rear. Internally the property has a porch, living room, separate dining room, large fully fitted kitchen with dining area, master bedroom with fitted wardrobes and furniture, second double bedroom with grey grain fitted wardrobes and furniture, third bedroom with contemporary wood effect bedroom/office furniture and family bathroom with white 3-piece suite with corner shower cubicle. There are two loft/attic rooms accessed via a loft hatch with pull down ladder, both rooms have apex ceilings with limited height, but are perfect as playrooms or large storage areas
Occupying a corner plot in a desirable residential area of Atherton, situated off Lovers Lane and within easy access to the M60, M61 motorways. Early Viewing is Highly Recommended

**NO ONWARD CHAIN – VACANT POSSESSION**

More Details

Search

WP_Query Object
(
    [query] => Array
        (
            [wppf_property_type] => 
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => uploaded
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
             => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [wppf_orderby] => latest
            [orderby] => date
            [order] => DESC
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => web_status
                            [value] => Array
                                (
                                    [0] => Let
                                    [1] => Sold
                                )

                            [compare] => NOT IN
                        )

                )

            [wppf_property_type_noquery] => bungalow
            [tax_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => wppf_property_type
                            [field] => ID
                            [terms] => 88
                            [include_children] => 
                        )

                )

            [posts_per_page] => 1000
            [ignore_sticky_posts] => 1
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => wppf_property_type
            [term] => bungalow-semi-detached
            [offset] => 
            [post_status] => publish
        )

    [query_vars] => Array
        (
            [wppf_property_type] => 
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => uploaded
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
             => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [wppf_orderby] => latest
            [orderby] => date
            [order] => DESC
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => web_status
                            [value] => Array
                                (
                                    [0] => Let
                                    [1] => Sold
                                )

                            [compare] => NOT IN
                        )

                )

            [wppf_property_type_noquery] => bungalow
            [tax_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => wppf_property_type
                            [field] => ID
                            [terms] => 88
                            [include_children] => 
                        )

                )

            [posts_per_page] => 1000
            [ignore_sticky_posts] => 1
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => wppf_property_type
            [term] => bungalow-semi-detached
            [offset] => 
            [post_status] => publish
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => wppf_property_type
                            [terms] => Array
                                (
                                    [0] => 88
                                )

                            [field] => ID
                            [operator] => IN
                            [include_children] => 
                        )

                    [1] => Array
                        (
                            [taxonomy] => wppf_property_type
                            [terms] => Array
                                (
                                    [0] => bungalow-semi-detached
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wphm_term_relationships
                    [1] => tt1
                )

            [queried_terms] => Array
                (
                    [wppf_property_type] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => 88
                                )

                            [field] => ID
                        )

                )

            [primary_table] => wphm_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => uploaded
                        )

                    [1] => Array
                        (
                            [0] => Array
                                (
                                    [key] => web_status
                                    [value] => Array
                                        (
                                            [0] => Let
                                            [1] => Sold
                                        )

                                    [compare] => NOT IN
                                )

                            [relation] => OR
                        )

                    [relation] => AND
                )

            [relation] => AND
            [meta_table] => wphm_postmeta
            [meta_id_column] => post_id
            [primary_table] => wphm_posts
            [primary_id_column] => ID
            [table_aliases:protected] => Array
                (
                    [0] => wphm_postmeta
                    [1] => mt1
                )

            [clauses:protected] => Array
                (
                    [wphm_postmeta] => Array
                        (
                            [key] => uploaded
                            [compare] => =
                            [compare_key] => =
                            [alias] => wphm_postmeta
                            [cast] => CHAR
                        )

                    [mt1] => Array
                        (
                            [key] => web_status
                            [value] => Array
                                (
                                    [0] => Let
                                    [1] => Sold
                                )

                            [compare] => NOT IN
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [request] => SELECT SQL_CALC_FOUND_ROWS  wphm_posts.* FROM wphm_posts  LEFT JOIN wphm_term_relationships ON (wphm_posts.ID = wphm_term_relationships.object_id)  LEFT JOIN wphm_term_relationships AS tt1 ON (wphm_posts.ID = tt1.object_id) INNER JOIN wphm_postmeta ON ( wphm_posts.ID = wphm_postmeta.post_id )  INNER JOIN wphm_postmeta AS mt1 ON ( wphm_posts.ID = mt1.post_id ) LEFT JOIN wphm_posts AS p2 ON (wphm_posts.post_parent = p2.ID)  WHERE 1=1  AND ( 
  wphm_term_relationships.term_taxonomy_id IN (88) 
  AND 
  tt1.term_taxonomy_id IN (233)
) AND ( 
  wphm_postmeta.meta_key = 'uploaded' 
  AND 
  ( 
    ( mt1.meta_key = 'web_status' AND mt1.meta_value NOT IN ('Let','Sold') )
  )
) AND wphm_posts.post_type = 'wppf_property' AND (((wphm_posts.post_status = 'publish') OR (wphm_posts.post_status = 'inherit' AND (p2.post_status = 'publish')))) GROUP BY wphm_posts.ID ORDER BY wphm_posts.post_date DESC LIMIT 0, 1000
    [posts] => Array
        (
        )

    [post_count] => 0
    [current_post] => -1
    [in_the_loop] => 
    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 0
    [max_num_pages] => 0
    [max_num_comment_pages] => 0
    [is_single] => 
    [is_preview] => 
    [is_page] => 
    [is_archive] => 1
    [is_date] => 
    [is_year] => 
    [is_month] => 
    [is_day] => 
    [is_time] => 
    [is_author] => 
    [is_category] => 
    [is_tag] => 
    [is_tax] => 1
    [is_search] => 1
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 
    [is_privacy_policy] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_favicon] => 
    [is_posts_page] => 
    [is_post_type_archive] => 
    [query_vars_hash:WP_Query:private] => b4b4c73799bc0e1bc43fa231b67d867b
    [query_vars_changed:WP_Query:private] => 
    [thumbnails_cached] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)