Madliena, Finished, Semi-detached Villa

stdClass Object
(
    [ref] => 355299
    [webRef] => 355299
    [marketStatus] => OnMarket
    [expiryDateTime] => 2037-06-02 00:00:00
    [marketType] => ForSale
    [commercial] => 0
    [development] => 
    [developmentID] => 
    [locality] => 45
    [locality_details] => stdClass Object
        (
            [id] => 45
            [localityName] => Madliena
            [zoneId] => 2
            [parentLocalityId] => 
        )

    [propertyType] => 19
    [propertyType_details] => stdClass Object
        (
            [id] => 19
            [description] => Semi-detached Villa
            [sortSequence] => 
            [propertyTypeGroupId] => 8
        )

    [propertyStatus] => 5
    [propertyStatus_details] => stdClass Object
        (
            [id] => 5
            [description] => Finished
            [sortSequence] => 
        )

    [price] => 3750000.00
    [oldPrice] => 3750000.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 0
    [description] => Madliena, Finished, Semi-detached Villa
    [title] => Madliena, Finished, Semi-detached Villa
    [longDescription] => 
Nestled in the prestigious and serene area of Madliena, this contemporary VILLA offers an exclusive opportunity to craft your dream home on a generous 620 sqm plot. The property currently under construction is being offered fully finished. The villa includes a full basement with extensive space, offering the potential to create a home cinema, games room, gym, or any other leisure facilities you desire. Additionally, the basement houses a spacious 3-car garage, providing secure and convenient parking. The ground floor features a huge open-plan area, perfect for entertaining guests. This expansive space can accommodate a large living area, dining room, and kitchen, all flowing seamlessly to the outdoor areas, making it ideal for social gatherings and family living. The first floor is dedicated to the sleeping quarters, comprising three well-proportioned bedrooms, each with its own ensuite bathroom. The master bedroom is particularly impressive, featuring a massive layout with a walk-in wardrobe, offering both luxury and practicality. The villa boasts a modern and elegant architectural design, characterized by clean lines and a thoughtful layout that maximizes natural light and outdoor views. With a 6-meter side curtilage, the property enjoys ample space and privacy, further enhancing its luxurious feel. The spacious plot allows for landscaped gardens, a swimming pool, and outdoor entertaining areas, making it perfect for both relaxation and social gatherings. FREEHOLD

    [specifications] => 
    [itemsIncludedInPrice] => 
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 3
    [bathrooms] => 4
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2024-07-26 00:00:00
    [dateOffMarket] => 
    [datePriceReduced] => 2026-06-02 12:51:03
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 1.00
    [areaSqm] => 1.00
    [internalAreaSqm] => 1.00
    [externalAreaSqm] => 1.00
    [plotAreaSqm] => 603.00
    [weight] => 0
    [features] => Array
        (
        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1117635
                    [property_id] => 355299
                    [file_name] => 1_355299.jpg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => 14aee567-81d2-4e95-b179-480df8484bd0.jpg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1117636
                    [property_id] => 355299
                    [file_name] => 2_355299.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => 14aee567-81d2-4e95-b179-480df8484bd0.jpg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1117637
                    [property_id] => 355299
                    [file_name] => 3_355299.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => b28d1a6d-0e95-4ea6-858a-4493e89b91f7.jpg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1678674
                    [property_id] => 355299
                    [file_name] => 4_355299.png
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/png
                    [original_file_name] => e7a42e52-e9bc-4176-b97f-9a4fe85758d6.png
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1678675
                    [property_id] => 355299
                    [file_name] => 5_355299.png
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/png
                    [original_file_name] => 5925b0c9-ae15-4851-8a31-187b764c0216.png
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1678676
                    [property_id] => 355299
                    [file_name] => 6_355299.png
                    [file_type] => OtherImages
                    [sequence_no] => 6
                    [mime] => image/png
                    [original_file_name] => 4e2a448d-eceb-479f-852a-20d46cc58afc.png
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => MAH
            [full_name] => Mazen Hathout
            [agent_code] => MH
            [img_file_name] => mazen-hathout.jpg
            [img_name] => ff8b9ed1-ca33-4f27-9520-2d0f3be5d2e2.jpg
            [branch_id] => 17
            [branch_name] => Ibrag Branch
            [branch_email] => [email protected]
            [description] => Mazen Hathout is the Branch Manager at Ibrag Branch. Mazen comes from an extensive Sales and Marketing background in the FMCG sector with multinational companies. Real Estate has always intrigued him, so he decided to join Frank Salt Real Estate, as he believes that he could use the skills he acquired over the years, to contribute to the growth of the company. In his free time, Mazen loves to spend time with his family, and practice his favourite hobbies which are scuba diving, biking, and snowboarding.
            [designation] => 
            [contact_number] => 0035699456804
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-03-19T07:23:58.000000Z
    [updated_at] => 2026-06-02T14:50:59.000000Z
)