house

Properties

Search

WP_Query Object
(
    [query] => Array
        (
            [wppf_property_type] => 
            [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
                (
                )

            [search_columns] => Array
                (
                )

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

                            [compare] => NOT IN
                        )

                )

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

                )

            [nopaging] => 1
            [ignore_sticky_posts] => 1
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [update_menu_item_cache] => 
            [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_type
            [term] => house
            [offset] => 
            [post_status] => publish
        )

    [query_vars] => Array
        (
            [wppf_property_type] => 
            [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
                (
                )

            [search_columns] => Array
                (
                )

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

                            [compare] => NOT IN
                        )

                )

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

                )

            [nopaging] => 1
            [ignore_sticky_posts] => 1
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [update_menu_item_cache] => 
            [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_type
            [term] => house
            [offset] => 
            [post_status] => publish
        )

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

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

                    [1] => Array
                        (
                            [taxonomy] => wppf_property_type
                            [terms] => Array
                                (
                                    [0] => house
                                )

                            [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] => 225
                                )

                            [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
                                            [2] => Exchanged
                                        )

                                    [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
                                    [2] => Exchanged
                                )

                            [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) 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 (225) 
  AND 
  tt1.term_taxonomy_id IN (225)
) AND ( 
  wphm_postmeta.meta_key = 'latitude' 
  AND 
  ( 
    ( mt1.meta_key = 'web_status' AND mt1.meta_value NOT IN ('Let','Sold','Exchanged') )
  )
) 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] => 370362
                    [post_author] => 0
                    [post_date] => 2023-08-02 00:00:00
                    [post_date_gmt] => 2023-08-02 00:00:00
                    [post_content] => **OFFERED WITH NO ONWARD CHAIN** we are delighted to welcome to the market for sale, this two bedroom garden fronted terraced house. The property benefits from gas central heating and double glazing, it has a fully fitted kitchen, with integrated oven and hob and a living room with feature fireplace.  To the first floor there is a spacious master bedroom,  a second bedroom and bathroom with white 3-piece suite and shower over the bath.  To the rear of the property there is a fully enclosed private yard area, with secure gated alleyway

Located close to local amenities, schools and shops, with great commuter and transport links, viewing is highly recommended [post_title] => May Street, Golborne, Warrington WA3 3TU [post_excerpt] => **OFFERED WITH NO ONWARD CHAIN** we are delighted to welcome to the market for sale, this two bedroom garden fronted terraced house. The property benefits from gas central heating and double glazing, it has a fully fitted kitchen, with integrated oven and hob and a living room with feature fireplace. To the first floor there is a spacious master bedroom, a second bedroom and bathroom with white 3-piece suite and shower over the bath. To the rear of the property there is a fully enclosed private yard area, with secure gated alleyway

Located close to local amenities, schools and shops, with great commuter and transport links, viewing is highly recommended [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => may-street-golborne-warrington-wa3-3tu [to_ping] => [pinged] => [post_modified] => 2024-02-20 21:13:11 [post_modified_gmt] => 2024-02-20 21:13:11 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=370362 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 370376 [post_author] => 0 [post_date] => 2023-08-02 00:00:00 [post_date_gmt] => 2023-08-02 00:00:00 [post_content] => Express Sales are pleased to bring to the market this ideal first time buyer, or investor property. This mid garden fronted terraced house benefits from gas central heating and double glazing. To the ground floor there is a reception room, fitted kitchen, inner vestibule, downstairs family bathroom with white bath and sink/pedestal and WC. To the first floor there are 2 good sized double bedrooms and to the rear of the property is a private enclosed garden area with storage outbuilding and access to the rear alleyway
Conveniently located close to rural areas and Lowton sailing club and local amenities, but also only a few minutes drive to retail parks, supermarkets, children's parks and Leigh sports village 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] => Sandy Lane, Lowton, Warrington WA3 1DH [post_excerpt] => Express Sales are pleased to bring to the market this ideal first time buyer, or investor property. This mid garden fronted terraced house benefits from gas central heating and double glazing. To the ground floor there is a reception room, fitted kitchen, inner vestibule, downstairs family bathroom with white bath and sink/pedestal and WC. To the first floor there are 2 good sized double bedrooms and to the rear of the property is a private enclosed garden area with storage outbuilding and access to the rear alleyway
Conveniently located close to rural areas and Lowton sailing club and local amenities, but also only a few minutes drive to retail parks, supermarkets, children's parks and Leigh sports village 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] => sandy-lane-lowton-warrington-wa3-1dh [to_ping] => [pinged] => [post_modified] => 2024-02-20 21:13:12 [post_modified_gmt] => 2024-02-20 21:13:12 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=370376 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 370395 [post_author] => 0 [post_date] => 2023-08-02 00:00:00 [post_date_gmt] => 2023-08-02 00:00:00 [post_content] => Offered for sale this stunning Freehold character property has retained many of its original features and is located opposite St John the Baptist Church. With no onward chain and vacant possession and although modernisation/renovation is required, this is a fabulous opportunity to purchase a substantial family home occupying a large plot, with many options to extend onto the original property. In its present format the property briefly comprises of three reception rooms, two family bathrooms, four bedrooms (three king sized), dining room and fitted kitchen

To the front of the property are paved and tarmac driveways for several vehicles and mature flowerbed and at the rear is a spacious paved patio area, detached brick garage, extensive garden with mature trees, shrubs and flowerbeds and set over 3 levels

Viewing is highly recommended in order to appreciate the opportunities this character home has to offer [post_title] => Liverpool Road, Irlam M44 6DA [post_excerpt] => Offered for sale this stunning Freehold character property has retained many of its original features and is located opposite St John the Baptist Church. With no onward chain and vacant possession and although modernisation/renovation is required, this is a fabulous opportunity to purchase a substantial family home occupying a large plot, with many options to extend onto the original property. In its present format the property briefly comprises of three reception rooms, two family bathrooms, four bedrooms (three king sized), dining room and fitted kitchen

To the front of the property are paved and tarmac driveways for several vehicles and mature flowerbed and at the rear is a spacious paved patio area, detached brick garage, extensive garden with mature trees, shrubs and flowerbeds and set over 3 levels

Viewing is highly recommended in order to appreciate the opportunities this character home has to offer [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => liverpool-road-irlam-m44-6da [to_ping] => [pinged] => [post_modified] => 2024-02-20 21:13:12 [post_modified_gmt] => 2024-02-20 21:13:12 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=370395 [menu_order] => 0 [post_type] => wppf_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 3 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 370362 [post_author] => 0 [post_date] => 2023-08-02 00:00:00 [post_date_gmt] => 2023-08-02 00:00:00 [post_content] => **OFFERED WITH NO ONWARD CHAIN** we are delighted to welcome to the market for sale, this two bedroom garden fronted terraced house. The property benefits from gas central heating and double glazing, it has a fully fitted kitchen, with integrated oven and hob and a living room with feature fireplace. To the first floor there is a spacious master bedroom, a second bedroom and bathroom with white 3-piece suite and shower over the bath. To the rear of the property there is a fully enclosed private yard area, with secure gated alleyway

Located close to local amenities, schools and shops, with great commuter and transport links, viewing is highly recommended [post_title] => May Street, Golborne, Warrington WA3 3TU [post_excerpt] => **OFFERED WITH NO ONWARD CHAIN** we are delighted to welcome to the market for sale, this two bedroom garden fronted terraced house. The property benefits from gas central heating and double glazing, it has a fully fitted kitchen, with integrated oven and hob and a living room with feature fireplace. To the first floor there is a spacious master bedroom, a second bedroom and bathroom with white 3-piece suite and shower over the bath. To the rear of the property there is a fully enclosed private yard area, with secure gated alleyway

Located close to local amenities, schools and shops, with great commuter and transport links, viewing is highly recommended [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => may-street-golborne-warrington-wa3-3tu [to_ping] => [pinged] => [post_modified] => 2024-02-20 21:13:11 [post_modified_gmt] => 2024-02-20 21:13:11 [post_content_filtered] => [post_parent] => 0 [guid] => https://express-let-sales.com/?post_type=wppf_property&p=370362 [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] => b5e04f49633733a273cb19d71a35493e [query_vars_changed:WP_Query:private] => [thumbnails_cached] => [allow_query_attachment_by_filename:protected] => [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 ) )