Properties

Search

WP_Query Object
(
    [query] => Array
        (
            [wppf_property_area] => to-buy
            [wppf_view] => map
            [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] => latitude
            [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
                        )

                )

            [nopaging] => 1
            [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] => 
            [posts_per_page] => 1000
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => wppf_property_area
            [term] => to-buy
            [offset] => 
            [post_status] => publish
            [tax_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => wppf_property_area
                            [field] => ID
                            [terms] => 86
                            [include_children] => 
                        )

                )

        )

    [query_vars] => Array
        (
            [wppf_property_area] => to-buy
            [wppf_view] => map
            [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] => latitude
            [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
                        )

                )

            [nopaging] => 1
            [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] => 
            [posts_per_page] => 1000
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => wppf_property_area
            [term] => to-buy
            [offset] => 
            [post_status] => publish
            [tax_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => wppf_property_area
                            [field] => ID
                            [terms] => 86
                            [include_children] => 
                        )

                )

        )

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

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

                    [1] => Array
                        (
                            [taxonomy] => wppf_property_area
                            [terms] => Array
                                (
                                    [0] => to-buy
                                )

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

                    [2] => Array
                        (
                            [taxonomy] => wppf_property_area
                            [terms] => Array
                                (
                                    [0] => to-buy
                                )

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

                )

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

            [queried_terms] => Array
                (
                    [wppf_property_area] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => 86
                                )

                            [field] => ID
                        )

                )

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

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

                    [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] => latitude
                            [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   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)  LEFT JOIN wphm_term_relationships AS tt2 ON (wphm_posts.ID = tt2.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 (86) 
  AND 
  tt1.term_taxonomy_id IN (86) 
  AND 
  tt2.term_taxonomy_id IN (86)
) AND ( 
  wphm_postmeta.meta_key = 'latitude' 
  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 
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 348358
                    [post_author] => 0
                    [post_date] => 2022-01-17 00:00:00
                    [post_date_gmt] => 2022-01-17 00:00:00
                    [post_content] => Recently refurbished and situated on a popular residential estate and in a cul-de-sac position, Express Sales are pleased to offer for sale this Freehold semi-detached house, which has a lawned garden to the front with off-road parking for several vehicles and to the rear, which is fully fenced and private there is also a lawned area and paved patio
Internally the property has 2 good sized bedrooms, a new modern style family bathroom with shower over the bath, new fully fitted kitchen and sitting room with open plan spindle staircase
The property also benefits from new front and back external doors, a new gas central heating boiler, new RCD consumer unit, double glazing and a burglar alarm

Conveniently placed for local amenities, shops and schools, it is also in the perfect position for local bus routes, with excellent commuter links via A580 and motorway access to the M6 and M62

**OFFERED WITH NO ONWARD CHAIN, VIEWINGS HIGHLY RECOMMENDED [post_title] => Dunlin Grove, Leigh WN7 2GH [post_excerpt] => Recently refurbished and situated on a popular residential estate and in a cul-de-sac position, Express Sales are pleased to offer for sale this Freehold semi-detached house, which has a lawned garden to the front with off-road parking for several vehicles and to the rear, which is fully fenced and private there is also a lawned area and paved patio
Internally the property has 2 good sized bedrooms, a new modern style family bathroom with shower over the bath, new fully fitted kitchen and sitting room with open plan spindle staircase
The property also benefits from new front and back external doors, a new gas central heating boiler, new RCD consumer unit, double glazing and a burglar alarm

Conveniently placed for local amenities, shops and schools, it is also in the perfect position for local bus routes, with excellent commuter links via A580 and motorway access to the M6 and M62

**OFFERED WITH NO ONWARD CHAIN, VIEWINGS HIGHLY RECOMMENDED [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => dunlin-grove-leigh-wn7-2gh [to_ping] => [pinged] => [post_modified] => 2022-01-28 13:18:04 [post_modified_gmt] => 2022-01-28 13:18:04 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=348358 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 340111 [post_author] => 0 [post_date] => 2021-12-08 00:00:00 [post_date_gmt] => 2021-12-08 00:00:00 [post_content] => EXPRESS LET & SALES are delighted to offer FOR SALE this beautifully presented two bedroom end terraced property situated on a large corner plot, within a very popular location. Entry to the property is via electric wrought iron gates situated on Grafton Street. This home boasts stunning mature gardens to the side and rear , with various patio areas and with off-road parking for several vehicles. This stunning home is well presented throughout and boasts generous accommodation including fitted kitchen/dining, conservatory, sitting room, master bedroom, second bedroom, currently fitted as a dressing room, jack-and-jill shower room and spacious attic/loft room with external windows. The property benefits from gas central heating, double glazing, CCTV, security lighting, burglar alarm and an alarmed garden

Conveniently located close to local amenities, shops, Howe Bridge Sports Centre and Leigh & Atherton town centres. With excellent commuter and transport links this property is ideally placed for schools and nurseries and close to children's play areas and cycle route pathways. **VIEWINGS ARE HIGHLY RECOMMENDED** [post_title] => (SSTC) - Leigh Road, Atherton M46 0PJ [post_excerpt] => EXPRESS LET & SALES are delighted to offer FOR SALE this beautifully presented two bedroom end terraced property situated on a large corner plot, within a very popular location. Entry to the property is via electric wrought iron gates situated on Grafton Street. This home boasts stunning mature gardens to the side and rear , with various patio areas and with off-road parking for several vehicles. This stunning home is well presented throughout and boasts generous accommodation including fitted kitchen/dining, conservatory, sitting room, master bedroom, second bedroom, currently fitted as a dressing room, jack-and-jill shower room and spacious attic/loft room with external windows. The property benefits from gas central heating, double glazing, CCTV, security lighting, burglar alarm and an alarmed garden

Conveniently located close to local amenities, shops, Howe Bridge Sports Centre and Leigh & Atherton town centres. With excellent commuter and transport links this property is ideally placed for schools and nurseries and close to children's play areas and cycle route pathways. **VIEWINGS ARE HIGHLY RECOMMENDED** [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => leigh-road-atherton-m46-0pj [to_ping] => [pinged] => [post_modified] => 2022-01-28 13:18:05 [post_modified_gmt] => 2022-01-28 13:18:05 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=340111 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 345969 [post_author] => 0 [post_date] => 2021-12-07 00:00:00 [post_date_gmt] => 2021-12-07 00:00:00 [post_content] => This Freehold semi-detached house benefits from gas central heating and double glazing. To the ground floor there is a fully fitted kitchen and 2 reception rooms. To the first floor there are 3 bedrooms and a bathroom with 3-piece white suite and shower over the bath. There are lawned gardens to the front and rear with off-road parking for two vehicles

Conveniently located close to Newton-le-Willows town centre, local amenities and shops. With excellent commuter and transport links this property is ideally placed for schools and nurseries

OFFERED WITH VACANT POSSESSION AND NO ONWARD CHAIN
**VIEWINGS ARE HIGHLY RECOMMENDED** [post_title] => (SSTC) - Rushy View, Newton-le-Willows WA12 9FG [post_excerpt] => This Freehold semi-detached house benefits from gas central heating and double glazing. To the ground floor there is a fully fitted kitchen and 2 reception rooms. To the first floor there are 3 bedrooms and a bathroom with 3-piece white suite and shower over the bath. There are lawned gardens to the front and rear with off-road parking for two vehicles

Conveniently located close to Newton-le-Willows town centre, local amenities and shops. With excellent commuter and transport links this property is ideally placed for schools and nurseries

OFFERED WITH VACANT POSSESSION AND NO ONWARD CHAIN
**VIEWINGS ARE HIGHLY RECOMMENDED** [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => rushy-view-newton-le-willows-wa12-9fg [to_ping] => [pinged] => [post_modified] => 2022-01-28 13:18:04 [post_modified_gmt] => 2022-01-28 13:18:04 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=345969 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 3 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 348358 [post_author] => 0 [post_date] => 2022-01-17 00:00:00 [post_date_gmt] => 2022-01-17 00:00:00 [post_content] => Recently refurbished and situated on a popular residential estate and in a cul-de-sac position, Express Sales are pleased to offer for sale this Freehold semi-detached house, which has a lawned garden to the front with off-road parking for several vehicles and to the rear, which is fully fenced and private there is also a lawned area and paved patio
Internally the property has 2 good sized bedrooms, a new modern style family bathroom with shower over the bath, new fully fitted kitchen and sitting room with open plan spindle staircase
The property also benefits from new front and back external doors, a new gas central heating boiler, new RCD consumer unit, double glazing and a burglar alarm

Conveniently placed for local amenities, shops and schools, it is also in the perfect position for local bus routes, with excellent commuter links via A580 and motorway access to the M6 and M62

**OFFERED WITH NO ONWARD CHAIN, VIEWINGS HIGHLY RECOMMENDED [post_title] => Dunlin Grove, Leigh WN7 2GH [post_excerpt] => Recently refurbished and situated on a popular residential estate and in a cul-de-sac position, Express Sales are pleased to offer for sale this Freehold semi-detached house, which has a lawned garden to the front with off-road parking for several vehicles and to the rear, which is fully fenced and private there is also a lawned area and paved patio
Internally the property has 2 good sized bedrooms, a new modern style family bathroom with shower over the bath, new fully fitted kitchen and sitting room with open plan spindle staircase
The property also benefits from new front and back external doors, a new gas central heating boiler, new RCD consumer unit, double glazing and a burglar alarm

Conveniently placed for local amenities, shops and schools, it is also in the perfect position for local bus routes, with excellent commuter links via A580 and motorway access to the M6 and M62

**OFFERED WITH NO ONWARD CHAIN, VIEWINGS HIGHLY RECOMMENDED [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => dunlin-grove-leigh-wn7-2gh [to_ping] => [pinged] => [post_modified] => 2022-01-28 13:18:04 [post_modified_gmt] => 2022-01-28 13:18:04 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=348358 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 3 [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] => 66291688208f4090d2fb7e6d6fe89715 [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 ) )