WP_Query Object
(
[query] => Array
(
[post_type] => estate_property
[post_status] => publish
[paged] => 1
[posts_per_page] => 6
[meta_key] => prop_featured
[orderby] => meta_value
[order] => DESC
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => property_city
[field] => slug
[terms] => reggello
)
)
)
[query_vars] => Array
(
[post_type] => estate_property
[post_status] => publish
[paged] => 1
[posts_per_page] => 6
[meta_key] => prop_featured
[orderby] => meta_value
[order] => DESC
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => property_city
[field] => slug
[terms] => reggello
)
)
[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] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[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
(
)
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => property_city
[term] => reggello
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => property_city
[terms] => Array
(
[0] => reggello
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)
[queried_terms] => Array
(
[property_city] => Array
(
[terms] => Array
(
[0] => reggello
)
[field] => slug
)
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => prop_featured
)
[relation] => OR
)
[relation] => AND
[meta_table] => wp_postmeta
[meta_id_column] => post_id
[primary_table] => wp_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wp_postmeta
)
[clauses:protected] => Array
(
[wp_postmeta] => Array
(
[key] => prop_featured
[compare] => =
[compare_key] => =
[alias] => wp_postmeta
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (234)
) AND (
wp_postmeta.meta_key = 'prop_featured'
) AND wp_posts.post_type = 'estate_property' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','estate_agent','estate_property','elementor_library' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','estate_agent','estate_property','elementor_library' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, wp_posts.ID DESC LIMIT 0, 6
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 34042
[post_author] => 2
[post_date] => 2021-04-13 18:27:35
[post_date_gmt] => 2021-04-13 16:27:35
[post_content] => A few kilometers from Florence, in the Tuscan hills of the Valdarno, you will find this enchanting country property for sale. It is in the center of a cute valley, a natural reserve of 21 hectares with centuries-old trees, olive groves and vineyards.
In the middle of it, it comes the Manor House where the owners live and the Farmhouse for the guests of the Agriturismo.
These buildings are entirely renovated for a total of about 750 square meters and keep the most typical architecture of the Tuscan countryside farms. They include 11 apartments, ranging in size from 60 to 90 square meters:
with independent entrance,
some of them are on the ground floor with convenient access for the disabled and some are on the first floor,
with kitchen and living room, 2-3 bedrooms, bathrooms, ideal solutions to accommodate 4 to 6 people,
featuring the typical Tuscan ceilings with exposed wooden beams and trusses, terracotta floors and ancient brick arches,
furnished and fully equipped.
In the common areas they are available internet, wifi connection and a laundry room with washing machine and dryer.
Outdoor spaces.
Around the central body of the complex , you will also find:
the private swimming pool of 14 mt x 6mt (lowest point at 1.20mt, highest point at 1.50mt),
in front of the swimming pool, a wide annex of 250 square meters for a versatile use, such as ceremonies, events, lunches and dinners,
the annex of 150 square meters to store agricultural tools and machines,
a horse stable of 420 square meters.
some barbecue areas and a cute lemon house.
The property is accessed through a private electric gate. A hundred meters of white dirty road leads us to the buildings. A large area is reserved for a convenient covered parking.
21 hectares of a most typical Tuscan land surrounds these country homes. Woods, arable land and
pretty gardens are all around, adorn the buildings and the swimming pool.
A vineyard and an olive grove allow a small independent production of typical Tuscan quality products, such as Chianti DOCG wine and Extra Virgin olive oil.
Nature and peace are all around. Families with children find the best here to live or to spend some holiday periods. It is possible to take long walks and come across various animal species that have found shelter within the vast area around .
This can be a perfect property where various types of courses such a yoga, pilates, meditation etc. or ceremonies and events can be organized.
The location, the landscape and the style of the buildings make this property for sale in the countryside near Florence very pleasant and original.
Reasons why's.
The worldwide contingencies are pushing investment of the Real Estate market toward safer locations, wider spaces and healthier standard of living. Buying properties in Tuscany is now a renovated opportunity.
The value-for-money of this country house for sale near Florence can be extremely interesting. Any possible private use or the management for hospitality activities, the organization of a "didactic farm" can be considered.
Logistics.
Services and transportation are very good and this is another decisive key feature for a property investment in Tuscany. The location is in a strategic position to visit Florence only 20 km far, the Chianti area and the whole region.
The area is easily reachable by car, a few kilometers from the A1 motorway (Firenze sud or Firenze Incisa exit) and is located a short distance from Incisa and Rignano sull'Arno, where all the main services, shops, bus stations and the railway station to Florence and Rome are located.
There are also a tennis court 2 km far, a riding stable 6 km away, a luxury outlet 5 km away and golf courses 15 km away.
Distance from major cities and airports.
Florence old town: 20 km
Florence railway station: 19 km
Greve in Chianti: 20 km
Arezzo: 55 km
San Gimignano: 60 km
Siena: 80 km,
Pisa: 100 km
Lucca: 100 km
Viareggio and Forte dei Marmi: 100 km.
Pienza and Val d’Orcia UNESCO sites: about 100 km
Rome: 250 km
Milan: 330 km
Florence airport: 30 km
Pisa airport: 100 km
Bologna airport: 135 km
[post_title] => Large Property with Farm, Apartments and Swimming Pool in the Countryside Near Florence.
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => large-property-with-farm-apartments-and-swimming-pool-in-the-countryside-near-florence
[to_ping] =>
[pinged] =>
[post_modified] => 2021-07-02 16:25:22
[post_modified_gmt] => 2021-07-02 14:25:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://victoria-house.it/?post_type=estate_property&p=34042
[menu_order] => 0
[post_type] => estate_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 1
[current_post] => -1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 34042
[post_author] => 2
[post_date] => 2021-04-13 18:27:35
[post_date_gmt] => 2021-04-13 16:27:35
[post_content] => A few kilometers from Florence, in the Tuscan hills of the Valdarno, you will find this enchanting country property for sale. It is in the center of a cute valley, a natural reserve of 21 hectares with centuries-old trees, olive groves and vineyards.
In the middle of it, it comes the Manor House where the owners live and the Farmhouse for the guests of the Agriturismo.
These buildings are entirely renovated for a total of about 750 square meters and keep the most typical architecture of the Tuscan countryside farms. They include 11 apartments, ranging in size from 60 to 90 square meters:
with independent entrance,
some of them are on the ground floor with convenient access for the disabled and some are on the first floor,
with kitchen and living room, 2-3 bedrooms, bathrooms, ideal solutions to accommodate 4 to 6 people,
featuring the typical Tuscan ceilings with exposed wooden beams and trusses, terracotta floors and ancient brick arches,
furnished and fully equipped.
In the common areas they are available internet, wifi connection and a laundry room with washing machine and dryer.
Outdoor spaces.
Around the central body of the complex , you will also find:
the private swimming pool of 14 mt x 6mt (lowest point at 1.20mt, highest point at 1.50mt),
in front of the swimming pool, a wide annex of 250 square meters for a versatile use, such as ceremonies, events, lunches and dinners,
the annex of 150 square meters to store agricultural tools and machines,
a horse stable of 420 square meters.
some barbecue areas and a cute lemon house.
The property is accessed through a private electric gate. A hundred meters of white dirty road leads us to the buildings. A large area is reserved for a convenient covered parking.
21 hectares of a most typical Tuscan land surrounds these country homes. Woods, arable land and
pretty gardens are all around, adorn the buildings and the swimming pool.
A vineyard and an olive grove allow a small independent production of typical Tuscan quality products, such as Chianti DOCG wine and Extra Virgin olive oil.
Nature and peace are all around. Families with children find the best here to live or to spend some holiday periods. It is possible to take long walks and come across various animal species that have found shelter within the vast area around .
This can be a perfect property where various types of courses such a yoga, pilates, meditation etc. or ceremonies and events can be organized.
The location, the landscape and the style of the buildings make this property for sale in the countryside near Florence very pleasant and original.
Reasons why's.
The worldwide contingencies are pushing investment of the Real Estate market toward safer locations, wider spaces and healthier standard of living. Buying properties in Tuscany is now a renovated opportunity.
The value-for-money of this country house for sale near Florence can be extremely interesting. Any possible private use or the management for hospitality activities, the organization of a "didactic farm" can be considered.
Logistics.
Services and transportation are very good and this is another decisive key feature for a property investment in Tuscany. The location is in a strategic position to visit Florence only 20 km far, the Chianti area and the whole region.
The area is easily reachable by car, a few kilometers from the A1 motorway (Firenze sud or Firenze Incisa exit) and is located a short distance from Incisa and Rignano sull'Arno, where all the main services, shops, bus stations and the railway station to Florence and Rome are located.
There are also a tennis court 2 km far, a riding stable 6 km away, a luxury outlet 5 km away and golf courses 15 km away.
Distance from major cities and airports.
Florence old town: 20 km
Florence railway station: 19 km
Greve in Chianti: 20 km
Arezzo: 55 km
San Gimignano: 60 km
Siena: 80 km,
Pisa: 100 km
Lucca: 100 km
Viareggio and Forte dei Marmi: 100 km.
Pienza and Val d’Orcia UNESCO sites: about 100 km
Rome: 250 km
Milan: 330 km
Florence airport: 30 km
Pisa airport: 100 km
Bologna airport: 135 km
[post_title] => Large Property with Farm, Apartments and Swimming Pool in the Countryside Near Florence.
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => large-property-with-farm-apartments-and-swimming-pool-in-the-countryside-near-florence
[to_ping] =>
[pinged] =>
[post_modified] => 2021-07-02 16:25:22
[post_modified_gmt] => 2021-07-02 14:25:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://victoria-house.it/?post_type=estate_property&p=34042
[menu_order] => 0
[post_type] => estate_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 1
[max_num_pages] => 1
[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] =>
[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] => 1
[query_vars_hash:WP_Query:private] => a50b8c748e289a1ccfe3e4303a91c3d1
[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
)
)
