belairPropertyItem::
stdClass Object
(
[web_ref] => 804833
[property_ref] => 804833
[address_ref] => AD038062
[market] => 1
[commercial] => 0
[locality_id] => 53
[property_type_id] => 13
[property_sub_type_id] => 33
[property_status_id] => 107
[price] => 5500000
[rent_period] => 0
[por] => 0
[description] => A superb, newly constructed freehold, sea view, detached, hillside villa on 3 levels, being sold in advanced shell form and built on a plot of circa 1340 square metres. The top floor layout comprises a hall with large skylight, Sitting, Living, Dining, Guest toilet with skylight, Kitchen, Pantry with skylight, Bedroom, Ensuite Bathroom and Dressing room or study. The floor opens out on to a 130m2 northerly sea view terrace extending the whole glassed frontage of the building.
On the second level below also with sea views, is a Master Bedroom suite, leading out to a private garden, with Walk-in Wardrobe and Ensuite Bathroom and 2 further Bedrooms both with Ensuite Bathrooms, all leading on to an extended single balcony. There is a 4th pool side facing Bedroom/Study or Recreation room with use of the adjacent pool shower room. In addition, is a pool view summer living room and kitchen, with a dumb waiter connecting to the main kitchen. These living areas are supported by 2 storage rooms, one with skylight, a laundry room adjacent to an outside washing line area and access to and from the car garage and workshop.
The third level below comprises a live-in home help Bedsit and Ensuite Bathroom, a covered open recreation area and then a large man-cave, storeroom or gym and wine cellar (all optionally combined for a possible flatlet). The large upper-level Hall skylight brightens the winding stairwell and lobbies which connect all 3 levels, paralleled with the provision of a lift shaft.
A crazy paving driveway connects to 4 car garage and an overhead open parking area with capacity for 3 more cars.
All outdoor terraces and exteriors are completed, except for railings, the pool and its surroundings. The completed villa exterior is secured with installed double-glazed Metra apertures including extensive floor to ceiling glass to maximize the view enjoyment from the ground floor. The building incorporates eco-design features. Also, 2 high-capacity rainwater reservoirs and mains water are connected to roof tanks and the outdoor drip-irrigation network to planters and garden. A twin Zenith sewer pump and customized tank is in place connected to the government sewer system in the street above and behind the property.
[specifications] =>
[sole_agents] => 0
[bedrooms] => 4
[bathrooms] => 4
[date_available] => 1990-01-01 09:00:00
[staff_id] => 103
[date_registered] => 2023-06-02 09:00:00
[emphatheusis] => F
[is_featured] => 0
[latitude] => 35.933528900146484
[longitude] => 14.461335182189941
[tag1] =>
[tag2] =>
[tag3] =>
[last_modified] => 2024-01-17 16:40:05
[property_video_url] =>
[walk_through_url] =>
[reduced] => 0
[sqmt] => 1341
[address] => Villa , St George, Triq It-telgha Tal-Madliena, Madliena
[show_on_commercial_web_site] => 0
[sold] => 0
[locality_name] => Madliena
[zone] => Sliema, St Julians Zone
[type] => Villa
[subtype] => Fully-detached Villa
[name] => Fully-detached Villa For Sale
[rent_or_sale] => For Sale
[type_url] => villa
[locality_url] => madliena
[availability] =>
[price_narrative] => € 5,500,000
[eur_price] => 5500000
[features] => Array
(
[0] => stdClass Object
(
[feature_desc] => Lift
[narrative] => Yes
)
[1] => stdClass Object
(
[feature_desc] => No of Bedrooms
[narrative] => 4
)
[2] => stdClass Object
(
[feature_desc] => En-suite
[narrative] => 4
)
[3] => stdClass Object
(
[feature_desc] => Guest Toilet
[narrative] => 1
)
[4] => stdClass Object
(
[feature_desc] => Dining Rooms
[narrative] => 1
)
[5] => stdClass Object
(
[feature_desc] => Kitchen
[narrative] => 2
)
[6] => stdClass Object
(
[feature_desc] => Sitting Room
[narrative] => 1
)
[7] => stdClass Object
(
[feature_desc] => Living Rooms
[narrative] => 1
)
[8] => stdClass Object
(
[feature_desc] => Study
[narrative] => Yes
)
[9] => stdClass Object
(
[feature_desc] => Box Rooms
[narrative] => 1
)
[10] => stdClass Object
(
[feature_desc] => Entrance Hall
[narrative] => 1
)
[11] => stdClass Object
(
[feature_desc] => Laundry Room
[narrative] => 1
)
[12] => stdClass Object
(
[feature_desc] => Pantry
[narrative] => 1
)
[13] => stdClass Object
(
[feature_desc] => Basement
[narrative] => Yes
)
[14] => stdClass Object
(
[feature_desc] => Flatlet
[narrative] => 1
)
[15] => stdClass Object
(
[feature_desc] => Flatlet Independent Access
[narrative] => Yes
)
[16] => stdClass Object
(
[feature_desc] => Other Rooms
[narrative] => 5
)
[17] => stdClass Object
(
[feature_desc] => Inter-Connected Garage/Car Space
[narrative] => Yes
)
[18] => stdClass Object
(
[feature_desc] => Garage (Lock Up)
[narrative] => Yes
)
[19] => stdClass Object
(
[feature_desc] => Garage No of Cars
[narrative] => 4
)
[20] => stdClass Object
(
[feature_desc] => Garage Level
[narrative] => Street level
)
[21] => stdClass Object
(
[feature_desc] => Garage Type
[narrative] => Private
)
[22] => stdClass Object
(
[feature_desc] => Car Port
[narrative] => Yes
)
[23] => stdClass Object
(
[feature_desc] => Private Drive
[narrative] => Yes
)
[24] => stdClass Object
(
[feature_desc] => Gym
[narrative] => Yes
)
[25] => stdClass Object
(
[feature_desc] => Unique Selling Point (USP1)
[narrative] => Super hillside position with excellent seaviews
)
[26] => stdClass Object
(
[feature_desc] => Unique Selling Point (USP2)
[narrative] => Very carefully planned and well built
)
[27] => stdClass Object
(
[feature_desc] => Unique Selling Point (USP3)
[narrative] => Prestigious residential location
)
[28] => stdClass Object
(
[feature_desc] => Unique Selling Point (USP4)
[narrative] => Lovely grounds and outdoor entertaining spaces
)
[29] => stdClass Object
(
[feature_desc] => Internal Area
[narrative] => 830.00 sq mt
)
[30] => stdClass Object
(
[feature_desc] => External Area
[narrative] => 950.00 sq mt
)
[31] => stdClass Object
(
[feature_desc] => Plot area
[narrative] => 1341.00 sq mt
)
[32] => stdClass Object
(
[feature_desc] => Views
[narrative] => Seaviews
)
[33] => stdClass Object
(
[feature_desc] => Well
[narrative] => Yes
)
[34] => stdClass Object
(
[feature_desc] => Swimming Pool
[narrative] => Yes
)
[35] => stdClass Object
(
[feature_desc] => Swimming Pool Type
[narrative] => Private
)
[36] => stdClass Object
(
[feature_desc] => Swimming Pool (dims)
[narrative] => 10.20 x 6.30 mt
)
[37] => stdClass Object
(
[feature_desc] => Front Terrace
[narrative] => Yes
)
[38] => stdClass Object
(
[feature_desc] => Side Terrace
[narrative] => Yes
)
[39] => stdClass Object
(
[feature_desc] => Detached
[narrative] => Yes
)
[40] => stdClass Object
(
[feature_desc] => Insulation
[narrative] => Yes
)
[41] => stdClass Object
(
[feature_desc] => Building Footprint
[narrative] => 430 sq mt
)
)
[area] => 830.00
[first_image] => 'https://belair.scdn3.secure.raxcdn.com/images/properties/804833_20230613141017260802.jpg'
[first_image_file_name] => 804833_20230613141017260802.jpg
[default_image] => 'https://belair.scdn3.secure.raxcdn.com/wp-content/themes/belair/assets/images/defaultimg.jpg'
[images] => Array
(
[0] => stdClass Object
(
[web_ref] => 804833
[image_no] => 1
[file_name] => 804833_20230613141017260802.jpg
[image_type] =>
[title] => WEBSITE-1
[tag1] =>
[tag2] =>
[tag3] =>
)
[1] => stdClass Object
(
[web_ref] => 804833
[image_no] => 2
[file_name] => 804833_20230613141017244152.jpg
[image_type] =>
[title] => WEBSITE-2
[tag1] =>
[tag2] =>
[tag3] =>
)
[2] => stdClass Object
(
[web_ref] => 804833
[image_no] => 3
[file_name] => 804833_20230613141021848420.jpg
[image_type] =>
[title] => WEBSITE-4
[tag1] =>
[tag2] =>
[tag3] =>
)
[3] => stdClass Object
(
[web_ref] => 804833
[image_no] => 4
[file_name] => 804833_20230613141025361116.jpg
[image_type] =>
[title] => WEBSITE-6
[tag1] =>
[tag2] =>
[tag3] =>
)
[4] => stdClass Object
(
[web_ref] => 804833
[image_no] => 5
[file_name] => 804833_20230613141028362072.jpg
[image_type] =>
[title] => WEBSITE-7
[tag1] =>
[tag2] =>
[tag3] =>
)
[5] => stdClass Object
(
[web_ref] => 804833
[image_no] => 6
[file_name] => 804833_20230613141028545944.jpg
[image_type] =>
[title] => WEBSITE-8
[tag1] =>
[tag2] =>
[tag3] =>
)
[6] => stdClass Object
(
[web_ref] => 804833
[image_no] => 7
[file_name] => 804833_20230613141035230700.jpg
[image_type] =>
[title] => WEBSITE-12
[tag1] =>
[tag2] =>
[tag3] =>
)
[7] => stdClass Object
(
[web_ref] => 804833
[image_no] => 8
[file_name] => 804833_20230613141035169702.jpg
[image_type] =>
[title] => WEBSITE-11
[tag1] =>
[tag2] =>
[tag3] =>
)
[8] => stdClass Object
(
[web_ref] => 804833
[image_no] => 9
[file_name] => 804833_20230613141038749687.jpg
[image_type] =>
[title] => WEBSITE-13
[tag1] =>
[tag2] =>
[tag3] =>
)
[9] => stdClass Object
(
[web_ref] => 804833
[image_no] => 10
[file_name] => 804833_20230613141038857011.jpg
[image_type] =>
[title] => WEBSITE-14
[tag1] =>
[tag2] =>
[tag3] =>
)
[10] => stdClass Object
(
[web_ref] => 804833
[image_no] => 11
[file_name] => 804833_20230613141042097525.jpg
[image_type] =>
[title] => WEBSITE-15
[tag1] =>
[tag2] =>
[tag3] =>
)
[11] => stdClass Object
(
[web_ref] => 804833
[image_no] => 12
[file_name] => 804833_20230613141042204409.jpg
[image_type] =>
[title] => WEBSITE-16
[tag1] =>
[tag2] =>
[tag3] =>
)
[12] => stdClass Object
(
[web_ref] => 804833
[image_no] => 13
[file_name] => 804833_20230613141323886516.jpg
[image_type] =>
[title] => AGENT REFERENCE-2
[tag1] =>
[tag2] =>
[tag3] =>
)
[13] => stdClass Object
(
[web_ref] => 804833
[image_no] => 14
[file_name] => 804833_20230613141332961929.jpg
[image_type] =>
[title] => AGENT REFERENCE-7
[tag1] =>
[tag2] =>
[tag3] =>
)
[14] => stdClass Object
(
[web_ref] => 804833
[image_no] => 15
[file_name] => 804833_20230606151032485878.jpg
[image_type] =>
[title] => 1 - Front door entrance
[tag1] =>
[tag2] =>
[tag3] =>
)
[15] => stdClass Object
(
[web_ref] => 804833
[image_no] => 16
[file_name] => 804833_20230606151038013164.jpg
[image_type] =>
[title] => 4.2 - Pool sunbathing lounger area
[tag1] =>
[tag2] =>
[tag3] =>
)
[16] => stdClass Object
(
[web_ref] => 804833
[image_no] => 17
[file_name] => 804833_20230606151032981838.jpg
[image_type] =>
[title] => 1.2 - Front door entrance
[tag1] =>
[tag2] =>
[tag3] =>
)
[17] => stdClass Object
(
[web_ref] => 804833
[image_no] => 18
[file_name] => 804833_20230606151033391537.jpg
[image_type] =>
[title] => 1.3 - Front door entrance
[tag1] =>
[tag2] =>
[tag3] =>
)
[18] => stdClass Object
(
[web_ref] => 804833
[image_no] => 19
[file_name] => 804833_20230606151032602918.jpg
[image_type] =>
[title] => 1.1 - Front Door Entrance
[tag1] =>
[tag2] =>
[tag3] =>
)
[19] => stdClass Object
(
[web_ref] => 804833
[image_no] => 20
[file_name] => 804833_20230606151033787735.jpg
[image_type] =>
[title] => 1.4 - Ramp to front door entrance & parking
[tag1] =>
[tag2] =>
[tag3] =>
)
[20] => stdClass Object
(
[web_ref] => 804833
[image_no] => 21
[file_name] => 804833_20230606151034432601.jpg
[image_type] =>
[title] => 2.1 - Side door, steps & bin housing
[tag1] =>
[tag2] =>
[tag3] =>
)
[21] => stdClass Object
(
[web_ref] => 804833
[image_no] => 22
[file_name] => 804833_20230606151034862290.jpg
[image_type] =>
[title] => 3 - Carport option 1
[tag1] =>
[tag2] =>
[tag3] =>
)
[22] => stdClass Object
(
[web_ref] => 804833
[image_no] => 23
[file_name] => 804833_20230606151035396580.jpg
[image_type] =>
[title] => 3.1 - Carport option 1
[tag1] =>
[tag2] =>
[tag3] =>
)
[23] => stdClass Object
(
[web_ref] => 804833
[image_no] => 24
[file_name] => 804833_20230606151034409634.jpg
[image_type] =>
[title] => 2 - Side door & planter
[tag1] =>
[tag2] =>
[tag3] =>
)
[24] => stdClass Object
(
[web_ref] => 804833
[image_no] => 25
[file_name] => 804833_20230606151035910162.jpg
[image_type] =>
[title] => 3.2 - Carport option 2
[tag1] =>
[tag2] =>
[tag3] =>
)
[25] => stdClass Object
(
[web_ref] => 804833
[image_no] => 26
[file_name] => 804833_20230606151036267290.jpg
[image_type] =>
[title] => 3.3 - Carport option 2
[tag1] =>
[tag2] =>
[tag3] =>
)
[26] => stdClass Object
(
[web_ref] => 804833
[image_no] => 27
[file_name] => 804833_20230606151037464776.jpg
[image_type] =>
[title] => 4 - Pool pre-design from GF front terrace
[tag1] =>
[tag2] =>
[tag3] =>
)
)
)