Advanced Search
Advanced Search

€ 0 to € 10.000.000

we found 0 results
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_category
                            [field] => slug
                            [terms] => commercial-re
                        )

                )

        )

    [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_category
                            [field] => slug
                            [terms] => commercial-re
                        )

                )

            [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] => 
            [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_category
            [term] => commercial-re
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => property_category
                            [terms] => Array
                                (
                                    [0] => commercial-re
                                )

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

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wp_term_relationships
                )

            [queried_terms] => Array
                (
                    [property_category] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => commercial-re
                                )

                            [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 (138)
) 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] => 33816
                    [post_author] => 2
                    [post_date] => 2021-04-11 16:37:30
                    [post_date_gmt] => 2021-04-11 14:37:30
                    [post_content] => This charming elegant Hotel for sale is in a strategic location at the edge of the old town, far less than 10 minutes walking distance.
It is located in a renovated Liberty style building of the early 20th century, when Florence was already a city of  national and international interest.

All the accommodations are mostly at the back of the structure or in the dependance. Here there is also a very useful in-house parking. Quietness and privacy are guaranteed.

 

It comprises 20 bedrooms,
  • single,
  • double,
  • triple rooms.
The spacious rooms feature traditional Florentine style furnishings, all equipped with bathrooms, air conditioning, safe, free Wi-fi, TV, minibar. Bedrooms are suitable for handicapped people, too.   External area. The main  entrance faces one the main streets leading to the center. However the accommodations enjoy the tranquillity of the back of the Hotel which is nestled in an elegant and quiet residential area. Here there is also a very useful private  in-house parking.   Reasons why's. Its excellent conditions, services and location make this Hotel very competitive, compared with similar downtown hotels.  For clients who arrive to Florence on business or on holiday, alone or with friends and Families, this Hotel can be  comfortable choice. Operators who work in the hotel and accommodation sector, Investing  in a small-medium hotel like this in a city like Florence, one of the Italian cities with highest flow of tourism, is a good value for money choice for a promising  profitable business.   Logistic. This Hotel for sale is strategically located in central Florence, but outside of the  old town pedestrian area. It is a few minutes walking distance to:
  • Santa Maria Novella Railway Station and the newest Tram Station,
  • main places of cultural interest, such Museo dell’ Accademia where the original David of Michelangelo,Piazza del Duomo,Piazza della Signoria,Piazza della Repubblica and via Tornabuoni, where the most celebrated Italian fashion brands are located,
  • Fortezza Exhibition Center.
The neighborhood is quiet and safe even for those who want to return late at night. Around the corner there is Piazza della Vittoria with its centuries-old pines. A little further away there are the splendid parks of Villa Stibbert and the Giardino dell’Orticoltura, the annual meeting point of the famous “Flowers Festival”.  Lots of shops, schools, cafes, artisan shops, restaurants, bakeries make the neighborhood pleasant to live in. Being just at the edge of the old town makes  easier to reach the Hotel. Facilities are all nearby. If you come from the Airport, the newest Tram or taxis will reach the center in just 20 minutes. It's even easier and comfortable to reach the Hotel by car, as guests can have a direct free access to the private parking site. Connections with Pisa International Airport are also easy. Trains depart approximately every 15-20 minutes from the Central Railway Station of Santa Maria Novella. A regular bus service  arrives at their destination in approximately 1 hour. [post_title] => Comfortable 20 Bedrooms Hotel Close to the Old Town Florence. [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => comfortable-20-bedrooms-hotel-close-to-the-old-town-florence [to_ping] => [pinged] => [post_modified] => 2021-04-22 18:21:48 [post_modified_gmt] => 2021-04-22 16:21:48 [post_content_filtered] => [post_parent] => 0 [guid] => https://victoria-house.it/?post_type=estate_property&p=33816 [menu_order] => 0 [post_type] => estate_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 28673 [post_author] => 2 [post_date] => 2020-11-16 17:13:50 [post_date_gmt] => 2020-11-16 16:13:50 [post_content] => This Villa is a historic 19th century residence and is located in an elegant 19th-20th century neighborhood just a few minutes' walk from the historic city center of Florence. Wisely renovated, the Villa has been enhanced over the years as a high-level Bed and Breakfast and a luxury Boutique Hotel. The style retains the charm of other times and refers to late nineteenth-century atmospheres, when Florence, then the capital of the Kingdom of Italy, became a national and international point of reference. In those years foreign groups and communities grew in the city - among the most active and lively the English and Anglo-Saxons and then the Russians - which ended up settling in Florence and contributing to the flourishing of a markedly cosmopolitan culture. Arranged on three floors for around 400 square meters, the Villa has been renovated respecting the original architectural features. Its marked refinement and elegance is evident right from the entrance: high ceilings, refined stuccos, period furnishings and tapestries immerse us in the typical atmospheres and styles of late Romanticism; the large windows ensure a completely natural interior brightness. Finishes and furnishings are of great luxury: parquet floors, Empire-style furniture and furnishings and upholstery with fine fabrics. On the ground floor, in the large airy entrance - now used as a reception - the majestic stone staircase that rises to the upper levels stands out. On the ground floor there are also a kitchen, pantry, bathroom, laundry room, technical room, utility room and a first wide bedroom with a large bathroom. At this level this bedroom allows direct access to a lovely private outdoor space for the exclusive use of the room itself. On the first of the two upper floors, there is the amazing large breakfast room of 50 square meters: very high ceilings, late-romantic style furnishings and an excellent brightness, thanks to the large windows overlooking the garden. On the same floor there are the first 2 bedrooms, each with its ensuite bathroom. Another 3 bedrooms are available on the second floor. The truly unique feature is their sizes ranging from 20 up to 35 square meters, these rooms have no comparison between the accommodations in Florence (and also in many other cities). They are furnished with elegance and refinement and are equipped with functional features to enjoy a relaxing stay and maximum comfort: king size beds, large bathrooms with extra-large showers or English-style bathtubs, air conditioning, TV, minibar, safe. The size of each bathroom is consistently similar to that of the rooms and can reach up to 15 square meters: huge and bright, they shine in their pure white Carrara marble cladding, comfortable and equipped with independent heating and thermo-furnishings. Wi-Fi internet connection is guaranteed in all rooms. The Villa enjoys a private area surrounded by greenery with access to the private garden and a convenient internal parking for two vehicles. All for about 260 square meters.   Close to the historic center. The Villa is in a strategic position with respect to the main places of cultural interest in Florence: from here you can easily reach Il Museo dell' Accademia (where the original David of Michelangelo is kept), the traditional San Lorenzo market and the Santa Maria Novella Railway Station. A few more minutes and you reach Piazza del Duomo and the magnificent doors of the Baptistery and, then, again Piazza della Signoria, Piazza della Repubblica and via Tornabuoni, where the most celebrated Italian fashion brands are located. The district. The neighborhood that welcomes the Villa is quiet and safe even for those who want to return late at night. It is, in itself, interesting to explore: around the corner there is Piazza della Vittoria with its centuries-old pines and a little further away the splendid parks of Villa Stibbert and the Giardino dell'Orticoltura, the annual meeting point of the famous “Flowers Festival". Logistics is indeed efficient: shops, schools, cafes, artisan shops, restaurants, pastry shops and bakeries make the neighborhood pleasant to live in. Not far away, however, history and contemporaneity meet within the mighty walls of the Medici Fortress, where trade fairs and artistic events of the most important and avant-garde are held every year. Logistics and transport. The Central Railway Station of Santa Maria Novella is just under 2 km away. In the same area there is the Tramvia Station which leads in 20 minutes directly to the Amerigo Vespucci City-Airport. Connections with Pisa International Airport are also facilitated by trains that depart approximately every 15-20 minutes from the central station of Santa Maria Novella and by the regular bus service that arrives at their destination in approximately 1 hour. The sale does not include paintings and some pieces of furniture. [post_title] => Elegant,Luxurious Bed & Breakfast Nearest the Historic Center of Florence [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => elegantluxurious-bed-breakfast-nearest-the-historic-center-of-florence [to_ping] => [pinged] => [post_modified] => 2021-01-27 14:36:35 [post_modified_gmt] => 2021-01-27 13:36:35 [post_content_filtered] => [post_parent] => 0 [guid] => https://victoria-house.it/?post_type=estate_property&p=28673 [menu_order] => 0 [post_type] => estate_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 2 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 33816 [post_author] => 2 [post_date] => 2021-04-11 16:37:30 [post_date_gmt] => 2021-04-11 14:37:30 [post_content] => This charming elegant Hotel for sale is in a strategic location at the edge of the old town, far less than 10 minutes walking distance. It is located in a renovated Liberty style building of the early 20th century, when Florence was already a city of  national and international interest. All the accommodations are mostly at the back of the structure or in the dependance. Here there is also a very useful in-house parking. Quietness and privacy are guaranteed.   It comprises 20 bedrooms,
  • single,
  • double,
  • triple rooms.
The spacious rooms feature traditional Florentine style furnishings, all equipped with bathrooms, air conditioning, safe, free Wi-fi, TV, minibar. Bedrooms are suitable for handicapped people, too.   External area. The main  entrance faces one the main streets leading to the center. However the accommodations enjoy the tranquillity of the back of the Hotel which is nestled in an elegant and quiet residential area. Here there is also a very useful private  in-house parking.   Reasons why's. Its excellent conditions, services and location make this Hotel very competitive, compared with similar downtown hotels.  For clients who arrive to Florence on business or on holiday, alone or with friends and Families, this Hotel can be  comfortable choice. Operators who work in the hotel and accommodation sector, Investing  in a small-medium hotel like this in a city like Florence, one of the Italian cities with highest flow of tourism, is a good value for money choice for a promising  profitable business.   Logistic. This Hotel for sale is strategically located in central Florence, but outside of the  old town pedestrian area. It is a few minutes walking distance to:
  • Santa Maria Novella Railway Station and the newest Tram Station,
  • main places of cultural interest, such Museo dell’ Accademia where the original David of Michelangelo,Piazza del Duomo,Piazza della Signoria,Piazza della Repubblica and via Tornabuoni, where the most celebrated Italian fashion brands are located,
  • Fortezza Exhibition Center.
The neighborhood is quiet and safe even for those who want to return late at night. Around the corner there is Piazza della Vittoria with its centuries-old pines. A little further away there are the splendid parks of Villa Stibbert and the Giardino dell’Orticoltura, the annual meeting point of the famous “Flowers Festival”.  Lots of shops, schools, cafes, artisan shops, restaurants, bakeries make the neighborhood pleasant to live in. Being just at the edge of the old town makes  easier to reach the Hotel. Facilities are all nearby. If you come from the Airport, the newest Tram or taxis will reach the center in just 20 minutes. It's even easier and comfortable to reach the Hotel by car, as guests can have a direct free access to the private parking site. Connections with Pisa International Airport are also easy. Trains depart approximately every 15-20 minutes from the Central Railway Station of Santa Maria Novella. A regular bus service  arrives at their destination in approximately 1 hour. [post_title] => Comfortable 20 Bedrooms Hotel Close to the Old Town Florence. [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => comfortable-20-bedrooms-hotel-close-to-the-old-town-florence [to_ping] => [pinged] => [post_modified] => 2021-04-22 18:21:48 [post_modified_gmt] => 2021-04-22 16:21:48 [post_content_filtered] => [post_parent] => 0 [guid] => https://victoria-house.it/?post_type=estate_property&p=33816 [menu_order] => 0 [post_type] => estate_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 2 [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] => 474301b050b3165dc4e7c505e3a20fcc [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 ) )

Properties in Commercial Re

Compare Listings