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] => rome
)
)
)
[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] => rome
)
)
[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
(
)
[search_columns] => Array
(
)
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => property_city
[term] => rome
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => property_city
[terms] => Array
(
[0] => rome
)
[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] => rome
)
[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 (250)
) 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 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_agent','estate_property' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','estate_agent','estate_property' ) )
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] => 41947
[post_author] => 2
[post_date] => 2023-02-14 15:47:11
[post_date_gmt] => 2023-02-14 14:47:11
[post_content] => This luxurious apartment is in a prestigious Condominium, a residential area in the old city. The context consists of buildings dating back to the 1950s, whose redevelopment has been entrusted to internationally recognized architecture and interior design studios.
The apartment for sale is now totally new. It has the highest architectural quality, with technologically advanced Home Automation and energy-saving systems.
The result is a combination of contemporary style and comfort inserted in a truly unique historical context.
The sale is from a private owner.
An apartment with modern comfort immersed in the millennial history of Rome.
The apartment is on the fourth floor (served by a lift) and consists of 123 square meters, distributed as follows:
.large entrance;
.large living room with a dining area with a prestigious Dada Molteni kitchen of the highest Italian design;
.3 bedrooms (with an option that one of them can be a study);
.2 bathrooms (one of which is ensuite, equipped with a Turkish bath/hammam cabin ;
.laundry;
.large terrace overlooking the elegant gardens surrounding Piazza Albania.
The apartment is of a unique kind in the Condominium, as it has been totally customized. The basic finishes have been replaced with original materials by Top Italian Brands, maximum expressions of the quality and functionality of interior designing:
- marble coverings and furnishings of the Baths of Antonio Lupi;
- parquet in natural wood (herringbone) by the Cadorin Group;
- Garofoli Branddoors;
- thermal insulating wooden windows;
- Brise Soleil System, sunscreens applied to the external facade to reduce the entry of UV rays and consequently reduce the use of air conditioning, without interfering with the entry of sunlight inside the apartment.
And then:
- a hyper-functional Dada Molteni kitchen, top brand of the Italian design worldwide, with the most up-to-date models of Miele appliances and including:
. a functional island,
. two large refrigerators,
. a grill oven,
. a microwave,
. two freezers,
. a wine cellar.
An Apartment with comfort and technological features in the Old City of Rome.
The apartment is equipped with a personalized Home Automation System, "My Home, the Smart Home", the maximum comfort and safety. It works in a simple and intuitive way to live in the apartment in total relaxation and with full control of :
.remote control of lights of all features;
.regulation of temperature (heating and cooling) and humidity levels in each room;.
.electronic opening and closing system for doors, windows, and rolling shutters;
.control of energy overloads;
.consumption monitoring.
The property also includes,
. a private parking area of 13 square meters ;
. a cellar of 3 square meters.
both into the bright and well-kept basement.
The apartment enjoys the advantages of an avant-garde Condominium of comfort, safety, and well-being.
The apartment enjoysthe free services offered to the residents of the Condominium:
.private gym;
.concierge and surveillance service, active 24 hours a day with permanent video controls;
.multipurpose room for organizing meetings and events;
.common garden ;
.re-charging point for electric cars;
.direct access to an amazing archeological area hidden in the basement.
The Condominium keeps some treasures of the history of ancient Rome. How is it possible?
Archaeological excavations carried out during the redevelopment of the condominium site have brought to light some incredible mosaics from the Imperial Age of Rome!
This area is right in the basement of the Condominium and is indeed something never seen before, possible only in a City like Rome.
Given its delicacy and prestige, the place can only be visited by small groups of visitors and with a particular privilege for the owners of the condominium apartments.
Location
Living in the Aventino area means immersing yourself in an oasis of peace, in the heart of the Eternal City. This condominium dialogues harmoniously with the green spaces and gardens surrounding the neighborhood and is very close to the monuments and masterpieces of Rome's millenary history.
Short walking routes in the green streets of the Aventino district take you towards the immense area of the Circo Massimo and, a little further on, the Giardino degli Aranci. In the same area, you will find yourself in front of the majestic Colosseo. Still moving comfortably on foot, the Terme di Caracalla can be reached through paths dotted with medieval churches and basilicas. Excellent logistics and services of all kinds embellish the area, which is full of delicious cafes and elegant restaurants. They are the meeting place for the international public who chose this area as their residence.
Distances.
Circo Massimo: 650 meters
Giardino degli Aranci: 750 meters
Bocca delle Verità: 1 km
Colosseo: 1.2 km
Terme di Caracalla: 1.3 km
Piazza Venezia: 1.9 km
Termini Railway Station: 3.2km
Vatican City: 4.6 km
[post_title] => A Luxury Apartment on The Aventino Hill, One of the Most Exclusive Districts of Rome.
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => a-luxury-apartment-on-the-aventino-hill-one-of-the-most-exclusive-districts-of-rome
[to_ping] =>
[pinged] =>
[post_modified] => 2023-08-27 11:15:56
[post_modified_gmt] => 2023-08-27 09:15:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://victoria-house.it/?post_type=estate_property&p=41947
[menu_order] => 0
[post_type] => estate_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 1
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 41947
[post_author] => 2
[post_date] => 2023-02-14 15:47:11
[post_date_gmt] => 2023-02-14 14:47:11
[post_content] => This luxurious apartment is in a prestigious Condominium, a residential area in the old city. The context consists of buildings dating back to the 1950s, whose redevelopment has been entrusted to internationally recognized architecture and interior design studios.
The apartment for sale is now totally new. It has the highest architectural quality, with technologically advanced Home Automation and energy-saving systems.
The result is a combination of contemporary style and comfort inserted in a truly unique historical context.
The sale is from a private owner.
An apartment with modern comfort immersed in the millennial history of Rome.
The apartment is on the fourth floor (served by a lift) and consists of 123 square meters, distributed as follows:
.large entrance;
.large living room with a dining area with a prestigious Dada Molteni kitchen of the highest Italian design;
.3 bedrooms (with an option that one of them can be a study);
.2 bathrooms (one of which is ensuite, equipped with a Turkish bath/hammam cabin ;
.laundry;
.large terrace overlooking the elegant gardens surrounding Piazza Albania.
The apartment is of a unique kind in the Condominium, as it has been totally customized. The basic finishes have been replaced with original materials by Top Italian Brands, maximum expressions of the quality and functionality of interior designing:
- marble coverings and furnishings of the Baths of Antonio Lupi;
- parquet in natural wood (herringbone) by the Cadorin Group;
- Garofoli Branddoors;
- thermal insulating wooden windows;
- Brise Soleil System, sunscreens applied to the external facade to reduce the entry of UV rays and consequently reduce the use of air conditioning, without interfering with the entry of sunlight inside the apartment.
And then:
- a hyper-functional Dada Molteni kitchen, top brand of the Italian design worldwide, with the most up-to-date models of Miele appliances and including:
. a functional island,
. two large refrigerators,
. a grill oven,
. a microwave,
. two freezers,
. a wine cellar.
An Apartment with comfort and technological features in the Old City of Rome.
The apartment is equipped with a personalized Home Automation System, "My Home, the Smart Home", the maximum comfort and safety. It works in a simple and intuitive way to live in the apartment in total relaxation and with full control of :
.remote control of lights of all features;
.regulation of temperature (heating and cooling) and humidity levels in each room;.
.electronic opening and closing system for doors, windows, and rolling shutters;
.control of energy overloads;
.consumption monitoring.
The property also includes,
. a private parking area of 13 square meters ;
. a cellar of 3 square meters.
both into the bright and well-kept basement.
The apartment enjoys the advantages of an avant-garde Condominium of comfort, safety, and well-being.
The apartment enjoysthe free services offered to the residents of the Condominium:
.private gym;
.concierge and surveillance service, active 24 hours a day with permanent video controls;
.multipurpose room for organizing meetings and events;
.common garden ;
.re-charging point for electric cars;
.direct access to an amazing archeological area hidden in the basement.
The Condominium keeps some treasures of the history of ancient Rome. How is it possible?
Archaeological excavations carried out during the redevelopment of the condominium site have brought to light some incredible mosaics from the Imperial Age of Rome!
This area is right in the basement of the Condominium and is indeed something never seen before, possible only in a City like Rome.
Given its delicacy and prestige, the place can only be visited by small groups of visitors and with a particular privilege for the owners of the condominium apartments.
Location
Living in the Aventino area means immersing yourself in an oasis of peace, in the heart of the Eternal City. This condominium dialogues harmoniously with the green spaces and gardens surrounding the neighborhood and is very close to the monuments and masterpieces of Rome's millenary history.
Short walking routes in the green streets of the Aventino district take you towards the immense area of the Circo Massimo and, a little further on, the Giardino degli Aranci. In the same area, you will find yourself in front of the majestic Colosseo. Still moving comfortably on foot, the Terme di Caracalla can be reached through paths dotted with medieval churches and basilicas. Excellent logistics and services of all kinds embellish the area, which is full of delicious cafes and elegant restaurants. They are the meeting place for the international public who chose this area as their residence.
Distances.
Circo Massimo: 650 meters
Giardino degli Aranci: 750 meters
Bocca delle Verità: 1 km
Colosseo: 1.2 km
Terme di Caracalla: 1.3 km
Piazza Venezia: 1.9 km
Termini Railway Station: 3.2km
Vatican City: 4.6 km
[post_title] => A Luxury Apartment on The Aventino Hill, One of the Most Exclusive Districts of Rome.
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => a-luxury-apartment-on-the-aventino-hill-one-of-the-most-exclusive-districts-of-rome
[to_ping] =>
[pinged] =>
[post_modified] => 2023-08-27 11:15:56
[post_modified_gmt] => 2023-08-27 09:15:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://victoria-house.it/?post_type=estate_property&p=41947
[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] => b094e428fb02279bb403ab4b4ebf883e
[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
)
)
Use the form below to contact us!
