array (
'listed' => '9 days ago',
'broker_license' => '2461',
'zone_name' => 'Hadaeq Sheikh Mohammed Bin Rashid',
'DLD_P_number' => '65550379040',
'agent_license' => '61647',
'property_regulatory_agent_license' => '65550379040',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=xpsvy114pz0cvo87d8j6egdpsdieb2jci2dghmehvyottdztx',
'broker_name' => 'Robin Emmanuel',
'broker_company_name' => 'Aeon & Trisl Real Estate Brokers',
'agent_link' => '/en/agent/robin-emmanuel-205198',
'page_title' => 'Sale in Park Gate: Spacious | Stand Alone Villa | Premium Living | Property Finder',
'property_price' => '13,500,000',
'bathrooms' => '5 Bathrooms',
'bedrooms' => '4 Bedrooms + Maid',
'property_description' => 'Aeon Trisl Real Estate Real Estate is delighted to present this stunning 4-bedroom Contemporary Villa, complete with a maid\'s room in Park Gate, Dubai Hills Estate.
- 4 bedrooms + maids
- Corner Plot Villa
- 5091 sq.ft BUA
- 4,994 sq ft Plot
- Single Row
- Contemporary design
- Payment Plan
- Ready in 2027
- Prime Location
- Close proximity to Dubai Hills
Park Gate offers a serene retreat amidst Dubai Hills Estate\'s bustling urban landscape. Set within lush green surroundings, these residences feature contemporary architecture and elegant design, providing residents with luxurious comfort. With spacious apartments boasting stunning views of the parklands and easy access to amenities like parks, retail outlets, and recreational facilities, Park Gate promises a vibrant lifestyle in a peaceful setting.
Conveniently situated near Downtown Dubai and other major landmarks, Park Gate provides easy access to the city\'s key destinations. Residents can unwind in beautifully landscaped gardens, explore scenic pathways, or indulge in various recreational activities. With its prime location, luxurious amenities, and serene ambiance, Park Gate Residences redefine modern living in the heart of Dubai Hills Estate.
Aeon Trisl was founded to provide a boutique approach to the Dubai Real Estate market, which caters way beyond beautiful properties, as our exceptional agents source a lifestyle to compliment you. Our purpose is to provide an unrivalled service in the market, whether you are buying, selling, or renting, and our approach allows us to walk alongside our clients at every stage of their journey. For Aeon Trisl, maintaining long-lasting relationships is at the core of our agency..',
'surface' => '5,091 sqft / 473 sqm',
'propertytype' => 'Villa',
'image_folder' => 'ps_nCs3FQzavmstCw_674d94b95b33f',
)
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '2461',
'zone_name' => 'Al Barsha South Fourth',
'DLD_P_number' => '71521095266',
'agent_license' => '62853',
'property_regulatory_agent_license' => '71521095266',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=dtkwn21373ntjjah2whf1xfsqyiqsqwfp4jgvnkdqdfmehxdc',
'broker_name' => 'Laiba Arshad',
'broker_company_name' => 'Aeon & Trisl Real Estate Brokers',
'agent_link' => '/en/agent/laiba-arshad-246963',
'page_title' => 'Sale in Binghatti Venus: High Floor | Brand new | Best Layout | Vacant | Property Finder',
'property_price' => '1,000,000',
'bathrooms' => '2 Bathrooms',
'bedrooms' => '1 Bedroom',
'property_description' => 'Binghatti Venus, Jumeirah Village Circle. Featuring an open-plan living space, sleek kitchen, and spacious bedroom with built-in wardrobes, A perfect blend of comfort and elegance. This Long private balcony provides Beautiful open Views that add an extra touch at night when the city shines so does the famous Five Hotel in JVC.
Apartment Features :
- Spacious Bedroom: Enjoy a serene sanctuary with ample natural light and stunning views.
- Full Bathroom: Well-designed with contemporary fixtures and finishes.
- Powder Room: Convenient for guests, ensuring privacy and comfort.
- Open Living Space: An inviting ambiance that seamlessly connects the living and dining areas, perfect for hosting or unwinding after a busy day.
- Breathtaking Views: Experience the beauty of open views that enhance the living experience and fill your home with light.
- Brand New
- Vacant
- 1 Bedroom
- 2 Bathrooms
- 666.82 SQFT
- Fully built in Kitchen appliances
- Unfurnished
- Best layout
- Balcony with open views
- Lounge with Full Windows
- Built-in Wardrobe
- Modern Finishing
- 1 Covered Parking Space
Building Features :
- Smart design
- High ROI potential
- Shared swimming pool
- Shared Gym
- BBQ and Play area
- Mesmerising City and Five Hotel views
Community and Area Development:
Jumeirah Village Circle (JVC) is a vibrant and rapidly developing community known for its family-friendly environment and a wealth of amenities. Residents enjoy close proximity to parks, schools, supermarkets, and a variety of dining options. The area is characterized by beautifully landscaped gardens and well-planned neighborhoods, offering a peaceful oasis in the bustling city.
Don’t miss out on the opportunity to make this charming apartment your new home! Contact Me today for more details and to schedule a viewing. Laiba Arshad 00971 56 126 2056',
'surface' => '667 sqft / 62 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_mXG4Ojo3~UYlDQ_674d94ca037e4',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '18715',
'zone_name' => 'Madinat Hind 4',
'DLD_P_number' => '65489569293',
'agent_license' => '72731',
'property_regulatory_agent_license' => '65489569293',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=zfniuihrnm4pcvkq5k1zfivapddqoyn5qz3ruabvtcqdmcjim',
'broker_name' => 'Maher Sharrouf',
'broker_company_name' => 'Classic Properties Real Estate',
'agent_link' => '/en/agent/maher-sharrouf-260246',
'page_title' => 'Sale in Aurum Villas: Single Row | 6BED Maid | Exclusive | Rented | Property Finder',
'property_price' => '3,500,000',
'bathrooms' => '6 Bathrooms',
'bedrooms' => '6 Bedrooms',
'property_description' => 'Classic Properties is excited to present this beautiful Independent 6-Bedroom Villa for Sale in Sycamore, Damac Hills 2.
Property Features:
- 6 Bedrooms + Maid\'s Room
- 6 Bathrooms
- 2 Parking Spaces
- Layout Type: V2
- Landscaped Garden – Perfect for outdoor relaxation
- Very Good Condition – Well-maintained and ready for move-in
- Single Row – Privacy and quiet surroundings
- Plot Area: 3,017.21 Sqft.
- Built-Up Area: 3809.24 Sqft.
This villa offers spacious living in a premium location, ideal for family living. Don\'t miss out on this fantastic opportunity!
Here are the key amenities at Sycamore, Damac Hills 2:
- 18-Hole Golf Course
- Swimming Pools
- Fitness Center (Gym)
- Tennis Courts
- Cycling & Jogging Tracks
- Retail Outlets
- Dining Options (Restaurants & Cafes)
- Parks & Play Areas
- 24/7 Security
- Community Center
- Healthcare Facilities
- Landscaped Gardens
For more information, to schedule a viewing, and to explore all available layouts in this community, contact our Area Specialist, Mr. Maher Sharrouf, at 042711116. He will assist you in finding the perfect property.
BRN: 72731
ORN: 18715
Community View:
Sycamore, Damac Hills 2 offers a serene and family-friendly community with lush landscapes, spacious parks, and vibrant green spaces. The development is designed for modern living, featuring upscale villas, recreational facilities like golf courses, tennis courts, and cycling tracks. Residents enjoy a peaceful, private environment with excellent connectivity, making it an ideal place to relax, socialize, and live a balanced lifestyle surrounded by nature.',
'surface' => '3,809 sqft / 354 sqm',
'propertytype' => 'Villa',
'image_folder' => 'ps_FgApRBX3UaOE7w_674d94d4e0e62',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '35459',
'zone_name' => 'Jabal Ali First',
'DLD_P_number' => '65367959420',
'agent_license' => '47327',
'property_regulatory_agent_license' => '65367959420',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=d7bjaj9m3j9jk9w4e1crcyzj0it0kkh1o8bltmawxdgrpjpng',
'broker_name' => 'Mehulkumar Mistry',
'broker_company_name' => 'HAUS&GRACE PROPERTIES',
'agent_link' => '/en/agent/mehulkumar-mistry-269366',
'page_title' => 'Sale in Murooj Al Furjan: VACANT TYPE-A BIGGER PLOT VASTU COMPLIENCE | Property Finder',
'property_price' => '4,500,000',
'bathrooms' => '4 Bathrooms',
'bedrooms' => '3 Bedrooms + Maid',
'property_description' => 'We at Haus&Grace delighted to offer this extravagant 3Bedroom Townhouse Type-A at Murooj Al Furjan (West Phase-1) a long waited brand new beautiful Community.
PRICE IS NEGOTIABLE AND MORTGAGE IS POSSIBLE.
Handover is expected by 30th November 2024.
Unit Features:-
- 3Bedroom+Maid
- Handing over soon
- Type-A
- Vastu Compliance
- Bigger layout & Plot
Murooj Al Furjan:-
Close to Ibn Battuta Mall and Sheikh Zayed Road is a flourishing community within a sought-after neighborhood\'s rich foundations of Nakheel’s Al Furjan master development have continued to help the neighborhood grow since its launch in 2007. Now home to top schools, popular community centers, leisure facilities including a community club, and its very own metro station, Al Furjan has it all.
Every outdoor space within Murooj Al Furjan has been designed to invite families out into the open. Shared community spaces offer three large pools with kid’s pools, tennis and basketball court, shaded play areas, family picnic areas and barbeque spots, all connected by pedestrian walkways and cycle lanes. The outcome is a lifestyle that transforms wellness from an activity into a way of life.
About us:
Haus&Grace Properties is an independent real estate company, specializes in residential and commercial sales and rental properties. One of the fastest growing real estate company in Dubai.
Our focus is to attain 100% customer satisfaction. Our major dealings are spread across Dubai region. Our vision is to be the leader in the real estate market by delivering excellent customer service through our reliable and exceptional certified team.
Mehul Mistry,
Haus&Grace Properties,
For more details call +971544012239 or +971589077281
BRN: 47327
ORN:35459',
'surface' => '3,202 sqft / 297 sqm',
'propertytype' => 'Townhouse',
'image_folder' => 'ps_M74eJrM38Ibknw_674d94e848282',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '29989',
'zone_name' => 'Jabal Ali Industrial Second',
'DLD_P_number' => '71592012285',
'agent_license' => '54092',
'property_regulatory_agent_license' => '71592012285',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=c0ckobynw8odgnhgs9h1q0tz9r4jidm5tx66lrbxqliusgxeq',
'broker_name' => 'Hani Alholaibi',
'broker_company_name' => 'ORAA Home Real Estate',
'agent_link' => '/en/agent/hani-alholaibi-230712',
'page_title' => 'Sale in Eleve by Deyaar: Secondary Off-plan, Handover 2027, PHPP 30 Months | Property Finder',
'property_price' => '655,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => 'Studio',
'property_description' => 'Oraa home real estate offering you this amazing studio in the most important area. Discover modern living at Eleve by Deyaar, a newly built residential tower in the heart of bustling Downtown Jebel Ali, Dubai.
Prime Location: Located within the 6.5 million square meter Downtown Area, Eleve offers more than just a home; it’s a gateway to a vibrant community. Surrounded by a mix of residential and commercial buildings along Sheikh Zayed Road, this area boasts parks, plazas, and shaded sidewalks. With Expo City Dubai just a few kilometers away, residents will have easy access to world-class exhibitions and entertainment.
Exceptional Amenities & Lifestyle: Eleve by Deyaar features a luxury design with a host of amenities aimed at enhancing your daily experience:
Modern architecture with high-quality finishes
Over 20 curated amenities, including a large pool, modern fitness center, sauna, steam room, and outdoor cinema
Private balconies offering stunning views of the port and neighborhood
Sustainable living features, focusing on eco-friendly materials and technologies
Urban retail options and easy access to major corporations and shopping centers, including Ibn Battuta Mall
Charming courtyards in the lobby offering a peaceful escape from city life
"The ORAA HOME Real Estate team is made up of passion, self-motivated and loyal professionals who live and breathe the communities they operate within. We value local knowledge and make sure each of our Dubai property agents is an expert on their specialist area, which helps us deliver the professional services to our clients. We’re easy to deal with and assure you that you have made the correct choice."',
'surface' => '409 sqft / 38 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_cFdC2:PbDnn8Ag_674d9502599d8',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '31847',
'zone_name' => 'Marsa Dubai',
'DLD_P_number' => '71216004347',
'agent_license' => '56959',
'property_regulatory_agent_license' => '71216004347',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=mdyoiea62bsrdt43v4g0mkdbf4qyen67r0o6aprmjuovvzrdg',
'broker_name' => 'Yunus Khan',
'broker_company_name' => 'BAIT ALRAIHAN REAL ESTATE BROKERS L.L.C',
'agent_link' => '/en/agent/yunus-khan-214411',
'page_title' => 'Sale in Ciel Tower: Investor Deal | Icon Hotel | 25% share | Premium | Property Finder',
'property_price' => '500,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'Invest in the Pinnacle of Luxury: The World\'s Tallest Hotel in Dubai Marina
Welcome to the Future of Hospitality
Imagine being part of an iconic structure that redefines luxury and sophistication. The world\'s tallest hotel in Dubai Marina offers a blend of elegance, comfort, and breathtaking views, setting a new global standard in hospitality.
Unmatched Luxury
Exquisitely designed rooms and suites offer panoramic vistas of the Marina skyline and the Arabian Gulf. Lavish interiors, state-of-the-art amenities, and impeccable service ensure every stay is extraordinary, attracting high-net-worth individuals worldwide.
Exceptional Amenities
Relax and rejuvenate at our luxurious spa, enjoy a dip in the infinity pool, or stay fit in our fully equipped fitness center. Our premium meeting and event spaces make us the premier choice for business and social gatherings.
Prime Location
Situated in the heart of Dubai Marina, this hotel offers easy access to the city’s major attractions, high-end shopping districts, and vibrant nightlife. This prime location ensures a continuous influx of tourists and business travelers.
Why Invest?
Robust Return Potential
High occupancy rates and premium pricing ensure robust returns. The continuous demand for luxury accommodations in Dubai Marina makes this a lucrative investment.
Prestige and Recognition
Being part of an architectural marvel boosts your investment\'s prestige and recognition, enhancing your portfolio’s value and reputation.
Sustainable Growth
Dubai’s status as a leading global destination ensures continuous demand. Our strategic partnerships and marketing initiatives maximize returns.
Secure Your Investment Today
Join us in redefining luxury. Invest in the world\'s tallest hotel in Dubai Marina and be part of an extraordinary legacy. Call Yaz +971585191880',
'surface' => '100 sqft / 9 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_cUpay15YUPYI8w_674d951657090',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '21514',
'zone_name' => 'Al Thanyah Fifth',
'DLD_P_number' => '7130903700',
'agent_license' => '37247',
'property_regulatory_agent_license' => '7130903700',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=6y3bgq4qp3rrox0i7k4ax16rmzm3u0f7thx5ngbeftyxubqsb',
'broker_name' => 'Mohammad Farah',
'broker_company_name' => 'Tamani Properties',
'agent_link' => '/en/agent/mohammad-farah-147226',
'page_title' => 'Sale in Goldcrest Executive: High Floor Prime Location Vacant | Property Finder',
'property_price' => '1,150,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'Tamani Real Estate presents this stunning one-bedroom apartment in the Dubai, Jumeirah Lake Towers, Goldcrest Executive
The building is in a prime location, with easy access to Sheikh Zayed Road and the Jumeirah Lakes Towers metro station nearby. From a commanding high floor, the apartment itself offers lovely views of the surrounding community, lakes, and golf course. Tenant has the usage of one parking space that is available.
Built around three lakes, Lake Zafeer, the fourth lake in the complex is now a stunning park. The complex is referred to as Jumeirah Lakes Towers, or JLT for short. The walking and jogging trails around the lakes, kid-friendly play areas, basketball courts, restaurants, and other retail amenities built into and around the residential buildings—such as dry cleaners, beauty salons, supermarkets, shops, and restaurants—all contribute to the feeling of community that families, couples, and singles find at JLT.',
'surface' => '639 sqft / 59 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_dXqA5Ei0aOMAXA_674d9521a8d0f',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '33139',
'DLD_P_number' => '0454836356',
'agent_license' => '65726',
'property_regulatory_agent_license' => '0454836356',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=s3fshw19go09e4fnkf3qa15pjp2o5qveovd0kcmijjnbigmty',
'broker_name' => 'Mohnish Ramesh Manghnani',
'broker_company_name' => 'Sky View Real Estate Brokers - Hessa Branch',
'agent_link' => '/en/agent/mohnish-ramesh-manghnani-257137',
'page_title' => 'Sale in Terra Heights: Amazing Investment | Near Metro | High Floor | Property Finder',
'property_price' => '1,400,000',
'bathrooms' => '2 Bathrooms',
'bedrooms' => '1 Bedroom + Maid',
'property_description' => 'Terra Heights, in the heart of Expo Living. Stylish apartments, green courtyards, and world-class amenities blend work, leisure, and relaxation seamlessly.
Spacious 1-bedroom apartment at Terra Heights, starting from 728 sq. ft.
The open-plan layout features:
* The master bedroom includes an en-suite bathroom and walk-in closet
* Modern kitchen.
* Enjoy serene courtyard views and a private balcony.
* Bright living area with
* Floor-to-ceiling windows,
* Dining space,
Terra Heights, offering a lifestyle rich with amenities like:
* Retail mall
* Gym
* Yoga deck
* Pools
* Kids play areas
* Mini golf
* Sports courts
* Barbecue spots
Surrounded by serene courtyards and green parks, it’s a haven for relaxation and socializing. Its proximity to Expo City connects residents to global events, while its thoughtful design fosters a tranquil yet connected living experience, making it ideal for families and professionals.
For an experiential tour and to know more,
Call Mohnish Manghnani
BRN No: 65726
Sky View Real Estate Brokers
800-SKYVIEW/ 044370431
1108 / 1109, Clover Bay, Business Bay, Dubai (Main Office)
Sky View Sales Center, Shop 1, Hessa Street, Al Barsha Third (Branch)
Office No: 043452253',
'surface' => '728 sqft / 68 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_tHGiMeflhgm~6A_674d9532c37d7',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '21514',
'zone_name' => 'Marsa Dubai',
'DLD_P_number' => '7125347800',
'agent_license' => '37247',
'property_regulatory_agent_license' => '7125347800',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=0v9hdymw7rwj025057qhfhmg5m64ty1jnmhgraqduzeksyswz',
'broker_name' => 'Mohammad Farah',
'broker_company_name' => 'Tamani Properties',
'agent_link' => '/en/agent/mohammad-farah-147226',
'page_title' => 'Sale in Marina Quays West: Prime Location Marina View Vacant | Property Finder',
'property_price' => '1,800,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'Tamani Real Estate presents this stunning one-bedroom apartment in the heart of Dubai Marina, in Marina Quays.
One of the three structures that make up the Marina Quays residential complex is Marina Quays West. The flats in this residential tower, which is tall, have one, two, and three bedrooms. The tower\'s apartments give inhabitants views of the shoreline and the man-made harbor. Marina Quays West Tower was created by Emaar and was designed by renowned Dubai architectural company Arif & Bintoak. After this skyscraper was turned over in 2010, Dubai residents now have freehold ownership in one of the city\'s most well-known neighborhoods, Dubai Marina.
One of the biggest artificial waterfront complexes, Dubai Marina is well-known for its stunning architecture. Numerous tall skyscrapers, five-star hotels, retail malls, hip nightclubs, and elegant cafes and restaurants can be found there. The main Sheikh Zayed Road is directly adjacent to it, making it easy for locals to go around the city.',
'surface' => '775 sqft / 72 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_wOIZ9x5r37jU6w_674d953d3fcec',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '42580',
'zone_name' => 'Hadaeq Sheikh Mohammed Bin Rashid',
'DLD_P_number' => '71525262731',
'agent_license' => '59295',
'property_regulatory_agent_license' => '71525262731',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=pfa6nfdpsqxgic69vscyvzqwvne57odjwlxcfoaonvbznlbvn',
'broker_name' => 'Nosayr Redjemi',
'broker_company_name' => 'REDJEMI PROPERTIES L.L.C',
'agent_link' => '/en/agent/nosayr-redjemi-268882',
'page_title' => 'Sale in Parkside Views: HIGH ROI | FULL PARK VIEW| MODERN FINISHES | Property Finder',
'property_price' => '3,500,000',
'bathrooms' => '3 Bathrooms',
'bedrooms' => '3 Bedrooms',
'property_description' => 'Redjemi Properties is proud to exclusively present this three (3) bedrooms apartment in Parkside Views, the desired community; Dubai Hills, with full park view from the Apartment. Located on a low floor this-three bedrooms apartment will be handed over Q3 2027,
PROPERTY DETAILS;
-3 Bedrooms
-3 Bathrooms
-2 Parking
-Close to Dubai Hills Mall
-Nearby Dubai Hills Golf Club
-Nearby to Schools and Healthcare centers
-Walk-in Wardrobe
-Full park and pool view
-Handover Q3 2027
-Kids play area
-Swimming Pool & Gym
-Fully Equipped kitchens
-BBQ Area
Nestled against the backdrop of the Burj Khalifa, Parkside Views is a 15-storey development by Emaar Properties in Dubai Hills Estate. It offers an array of 1-3 bedroom apartments in addition to 14 duplexes and 6 spacious townhouses in 3-bedroom configurations.
Residents of Parkside Views will appreciate that range of high-class amenities that aim to boost well-being and health. Among these are indoor and outdoor gym facilities, a BBQ area with park access, and swimming pools for children and adults. Not forgetting a multi-functional room, shared spaces, and a children’s play area, which are perfect for communal interaction.
“REDJEMI PROPERTIES LLC
RERA ORN: 42580
Address: 2006, 20th Floor, Damac Business Tower, Business Bay, Dubai
Office phone no: 045578046
Email: contact@redjemi.com
Website: [link not available]”.',
'surface' => '1,504 sqft / 140 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_66vUfAB0YhuMmg_674d9551e1424',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '42580',
'zone_name' => 'Hadaeq Sheikh Mohammed Bin Rashid',
'DLD_P_number' => '71525267879',
'agent_license' => '59295',
'property_regulatory_agent_license' => '71525267879',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=7vbf6rq6vh3wqipqxx428ejb5tgaros6brrwpmeguztpetrjf',
'broker_name' => 'Nosayr Redjemi',
'broker_company_name' => 'REDJEMI PROPERTIES L.L.C',
'agent_link' => '/en/agent/nosayr-redjemi-268882',
'page_title' => 'Sale in Parkside Views: HIGH ROI | FULL PARK VIEW| MODERN FINISHES | Property Finder',
'property_price' => '1,600,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'Redjemi Properties is proud to exclusively present this one (1) bedrooms apartment in Parkside Views, the desired community; Dubai Hills, with full park view from the Apartment.
PROPERTY DETAILS;
-1 Bedrooms
-1 Bathrooms
-2 Parking
-Close to Dubai Hills Mall
-Nearby Dubai Hills Golf Club
-Nearby to Schools and Healthcare centers
-Walk-in Wardrobe
-Full park and pool view
-Handover Q3 2027
-Kids play area
-Swimming Pool & Gym
-Fully Equipped kitchens
-BBQ Area
Nestled against the backdrop of the Burj Khalifa, Parkside Views is a 15-storey development by Emaar Properties in Dubai Hills Estate. It offers an array of 1-3 bedroom apartments in addition to 14 duplexes and 6 spacious townhouses in 3-bedroom configurations.
Residents of Parkside Views will appreciate that range of high-class amenities that aim to boost well-being and health. Among these are indoor and outdoor gym facilities, a BBQ area with park access, and swimming pools for children and adults. Not forgetting a multi-functional room, shared spaces, and a children’s play area, which are perfect for communal interaction.
“REDJEMI PROPERTIES LLC
RERA ORN: 42580
Address: 2006, 20th Floor, Damac Business Tower, Business Bay, Dubai
Office phone no: 045578046
Email: contact@redjemi.com
Website: [link not available]”.',
'surface' => '704 sqft / 65 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_l5SWkIdBlwX9Ww_674d955cce3bc',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '2497',
'DLD_P_number' => '2109707272',
'agent_license' => '26515',
'property_regulatory_agent_license' => '2109707272',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=gn9tl7ag9588q92jk4fxiu8tz5wjdcqzfh48uwkppmugguaxo',
'broker_name' => 'Muntaz Abdul Satar Ossumane Bacai',
'broker_company_name' => 'Mahel Real Estate',
'agent_link' => '/en/agent/muntaz-abdul-satar-ossumane-bacai-170115',
'page_title' => 'Sale in Marriott Executive Apartments: Ready to Move in | Fully Furnished | Has Payment Plan | Property Finder',
'property_price' => '2,050,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'Mahel Real Estate is excited to present this luxurious 1-bedroom apartment for sale at The Marriott Residence, Al Barsha South
Property Details:
- 1 Bedroom
- 1 Bathroom
- Size:1,257 sq ft
- Powder Room
- Laundry Room
- Built-In Wardrobe
- Terrace
Amenities/Services:
- Conference Room
- Running Tracks
- Retails
- Restaurant
- Club & Spa
- Fitness Zone
- Gymnasium
- Swimming Pool
- Parks and Gardens
Marriott Executive Apartments provides an upgraded serviced apartment experience with a selection of beautiful one, two and three-bedroom apartments. This project highlights an appealing blend of comfort and style, aimed at addressing the housing demands of corporate visitors and discerning residents, and is conveniently located in the heart of business, shopping, and entertainment districts.
About us:
We are a family of world-class professionals, dedicated agents who combine real estate expertise with unrivaled market knowledge. We are perfectly placed to advise you on your property move because we have done it too. We aim to make the real estate process in Dubai as smooth as possible.
Call today to schedule a viewing!
+971 50 115 9597
Ask us about:
* Mortgage Advisory
* Property Management
* Holiday Homes
* Interior Design
Call today to schedule a viewing!
+971 50 115 9597
Ground Floor, Building Burj Khalifa, Downtown Dubai, Dubai.',
'surface' => '1,257 sqft / 117 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_oPG3rXtZSobi:g_674d9564e9490',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '33139',
'DLD_P_number' => '0454836356',
'agent_license' => '65726',
'property_regulatory_agent_license' => '0454836356',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=s3fshw19go09e4fnkf3qa15pjp2o5qveovd0kcmijjnbigmty',
'broker_name' => 'Mohnish Ramesh Manghnani',
'broker_company_name' => 'Sky View Real Estate Brokers - Hessa Branch',
'agent_link' => '/en/agent/mohnish-ramesh-manghnani-257137',
'page_title' => 'Sale in Terra Heights: Amazing ROI | Close to Everything | Call Now | Property Finder',
'property_price' => '2,335,890',
'bathrooms' => '2 Bathrooms',
'bedrooms' => '2 Bedrooms',
'property_description' => 'Experience modern living at Terra Heights, nestled in the heart of Expo Living. Stylish apartments, green courtyards, and world-class amenities blend work, leisure, and relaxation seamlessly.
Step into a spacious 2-Bedroom apartment at Terra Heights, the open-plan layout features:
* Bright living area
* Floor-to-ceiling windows
* Dining space
* Modern kitchen
* The master bedroom includes an en-suite bathroom and walk-in closet
* The second bedroom is ideal for guests or family.
* Enjoy serene courtyard views and a private balcony.
Terra Heights is part of the vibrant Expo Living community, offering a lifestyle rich with amenities like:
* Retail mall
* Gym
* Yoga deck
* Pools
* Children\'s play areas
* Mini golf
* Sports courts
* Barbecue spots
Surrounded by serene courtyards and green parks, it’s a haven for relaxation and socializing. Its proximity to Expo City connects residents to global events, while its thoughtful design fosters a tranquil yet connected living experience, making it ideal for families and professionals.
For an experiential tour and to know more,
Call Mohnish Manghnani
BRN No: 65726
Sky View Real Estate Brokers
800-SKYVIEW/ 044370431
1108 / 1109, Clover Bay, Business Bay, Dubai (Main Office)
Sky View Sales Center, Shop 1, Hessa Street, Al Barsha Third (Branch)
Office No: 043452253',
'surface' => '1,096 sqft / 102 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_15MX~WN82FFm6A_674d956f55f23',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '31659',
'DLD_P_number' => '0345139763',
'agent_license' => '52476',
'property_regulatory_agent_license' => '0345139763',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=uitvxhd9fvrgut1vd8tc4wzmt982qwlgm80kqmuyzsdgaojuz',
'broker_name' => 'Mohd Arham Nazim',
'broker_company_name' => 'SANDCASTLE PROPERTIES LLC',
'agent_link' => '/en/agent/mohd-arham-nazim-239271',
'page_title' => 'Sale in Terra Heights: 10% DP | 1BR Apt | New Launch | Property Finder',
'property_price' => '1,550,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'Sandcastle Properties offers this 1 Bedroom Apartment for sale in Terra Heights, Expo City, Dubai.
Property Details :
* 1 Bedroom
* 1 Bathroom
* Living Area
* Kitchen + Dining Area
* Laundry Area
* Balcony
Terra Heights at Expo Living is the new residential Icon of luxury living by Emaar Properties lined with premium selection of 1 and 2-bedroom luxury apartments. Discover this dynamic high-rise L-shaped four sleek towers featuring extraordinary living blending urban energy and serene lifestyle.
Key Highlights:
* Choose from well-designed 1 and 2-bedroom apartments, with spacious layouts, smart designs, and plenty of natural light.
* Ideally situated in Expo Living at crossroads of Mohammed Bin Zayed Road and Expo Road, offering easy access to key landmarks like Dubai Expo Mall and such.
* The development features four mid-rise towers arranged in an L-shape, creating two tranquil courtyards surrounded by lush greenery, making it the perfect address.
* As part of the Expo Living community, the facade fosters a dynamic environment where residents can connect with nature, enjoy green spaces.
* The development is surrounded by beautifully landscaped gardens, and spacious courtyards, offering a peaceful retreat of urban life.
* Enjoy a range of on-site amenities, including adult and kids\' pools, multipurpose sports courts, a well-equipped gym and many such.
About us:
Welcome to Sandcastle Properties, your trusted partner in real estate solutions in the vibrant city of Dubai. As a premier real estate agency, we specialize in assisting clients with their diverse property needs, whether they are buying, selling, renting, or investing in Dubai\'s dynamic real estate market.
Our experienced team is dedicated to providing exceptional service and personalized guidance for a smooth and rewarding real estate journey.
So get in touch with us now to experience ease in your property hunt.
Mr. Owais Mehboob - +971 52 245 2795
Thank You',
'surface' => '756 sqft / 70 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_l4ETFjhzweTuVg_674d957918c73',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '31659',
'DLD_P_number' => '0345139763',
'agent_license' => '38752',
'property_regulatory_agent_license' => '0345139763',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=uitvxhd9fvrgut1vd8tc4wzmt982qwlgm80kqmuyzsdgaojuz',
'broker_name' => 'Owais Mehboob Mehboob Hussain Dar',
'broker_company_name' => 'SANDCASTLE PROPERTIES LLC',
'agent_link' => '/en/agent/owais-mehboob-mehboob-hussain-dar-238244',
'page_title' => 'Sale in Terra Heights: 10% DP | 2BR Apt | New Launch | Property Finder',
'property_price' => '2,340,000',
'bathrooms' => '2 Bathrooms',
'bedrooms' => '2 Bedrooms',
'property_description' => 'Sandcastle Properties offers this 2 Bedrooms Apartment for sale in Terra Heights, Expo City, Dubai.
Property Details :
* 2 Bedrooms
* 2 Bathrooms
* Living Area
* Kitchen + Dining Area
* Laundry Area
* Store Area
* Balcony
Emaar Terra Heights offers an extensive range of amenities designed to cater to every aspect of modern living. Residents can enjoy a fully equipped gymnasium, a luxurious swimming pool, and dedicated kids’ play areas. The development also features serene parks, gardens, and BBQ areas, perfect for family gatherings. Health care centers, ample parking spaces, and retail outlets ensure daily convenience.
Key Facilities:
* Gymnasium
* Swimming Pool
* Kids Play Area
* Health Care Centers
* Ample Parking Spaces
* Retail Outlets
* BBQ Area
* Parks and Gardens
* Jacuzzi
* Bicycle & Running Tracks
About us:
Welcome to Sandcastle Properties, your trusted partner in real estate solutions in the vibrant city of Dubai. As a premier real estate agency, we specialize in assisting clients with their diverse property needs, whether they are buying, selling, renting, or investing in Dubai\'s dynamic real estate market.
Our experienced team is dedicated to providing exceptional service and personalized guidance for a smooth and rewarding real estate journey.
So get in touch with us now to experience ease in your property hunt.
Mr. Owais Mehboob - +971 52 245 2795
Thank You',
'surface' => '1,124 sqft / 104 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_N6M3EcKhy5s:4Q_674d9582d8684',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '2456',
'zone_name' => 'Al Barshaa South Third',
'DLD_P_number' => '7114938373',
'agent_license' => '49798',
'property_regulatory_agent_license' => '7114938373',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=p7xqlr3a84qpeuw1tuqjoie0o0c6mhky5yk1nnwctdbocttya',
'broker_name' => 'Nisar Khan',
'broker_company_name' => 'Atomic Properties',
'agent_link' => '/en/agent/nisar-khan-196263',
'page_title' => 'Sale in Lincoln Park - West Side: Vacant | Well Maintained | 2BHK In Arjan | for 900K | Property Finder',
'property_price' => '900,000',
'bathrooms' => '2 Bathrooms',
'bedrooms' => '2 Bedrooms',
'property_description' => 'Atomic properties is pleased to offer you the Modern Style 2 Bedroom apartment in Arjan Lincoln park Damac The apartment is fully furnished and vacant
PRICE :900K
SIZE: 1000 sqft
STATUS: Vacant
PROPERTY DETAILS AND AMENITIES:
■Furnished 2 Bedroom apartment
■2 bathroom
■1 parking space
■Retail outlets
■Shopping Mall
■Gymnasium
■Ample Parking Spaces
■Shopping Mall
■Gardens and Parks
■Round the clock security
■Ample Parking Spaces
Amenities
Built in Wardrobes
Covered Parking
Gym
POOL
CONTACT DETAILS : 0527172304 ask for more details to our agent Nisar ul haq BR ID:49798
Lincoln Park is a mixed-use development project comprising of 5 low rise buildings with dedicated, commercial, and residential buildings. It is primarily located in Dubai Land which is an innovative, awe-inspiring entertainment and leisure development that represents an integral part of Dubai\'s bold vision to become the top tourism destination in the world.
Lincoln Park by Damac Properties, a prestigiou ACs 21st-century development offering a mix of 1, 2 & 3-bedroom apartments located at Arjan, Dubailand. This 5-towers development is inspired by the Chicago school of architecture, and the influence is expressed through well-articulated and ornamented front entrance,',
'surface' => '1,000 sqft / 93 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_rMPV8J:aH2K~tA_674d958bb47dc',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '2443',
'DLD_P_number' => '1259997473',
'agent_license' => '31179',
'property_regulatory_agent_license' => '1259997473',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=00vqebmxg3smg34w04bct3qv6vd8oc9yfbkzlhlmzsstmnaqw',
'broker_name' => 'Hitesh Babani',
'broker_company_name' => 'Union Square House Real Estate',
'agent_link' => '/en/agent/hitesh-babani-136947',
'page_title' => 'Sale in Greenway 2: Payment Plan | Golf course Community | 3BR | Property Finder',
'property_price' => '3,300,000',
'bathrooms' => '4 Bathrooms',
'bedrooms' => '4 Bedrooms + Maid',
'property_description' => 'Introducing Greenway Townhouses in Emaar South by Union Square House!
We are excited to unveil the stunning Greenway Townhouses, offering a refined living experience with spacious 3 and 4-bedroom layouts that exceed the size of other townhouses in the area.
Townhouse specifications:
- 3-Bedroom Units: 2,448 sq. ft. of built-up space, starting from 2,200 sq. ft. plots.
- 4-Bedroom Units: 2,755 sq. ft. of built-up area, with plot sizes beginning at 2,800 sq. ft.
Exceptional features:
- Master bedrooms with ensuite bathrooms
- Expansive floor-to-ceiling windows, maximizing natural light
Prime location advantages:
- Just 5 minutes to Al Maktoum Airport
- Only 10 minutes to Expo City Dubai
- 20 minutes to Dubai Marina
Flexible payment plan:
- 10% at Booking
- 60% During Construction
- 20% at Handover
Available amenities:
- Community Centre
- Linear Park
- Swimming Pools for both adults and children
- Children\'s Play Area
- Multi-purpose Room
- State-of-the-Art Gym
- Jogging Path
- 18-hole Championship Golf Course
Emaar South is a prestigious golf course community, ideally situated next to Expo City Dubai. With convenient access to Al Maktoum International Airport and easy connectivity to Dubai\'s top attractions and business hubs, this location is perfect for modern living.
Don’t miss your chance to secure your new home in this vibrant community and experience luxury living at its finest in Dubai!',
'surface' => '2,900 sqft / 269 sqm',
'propertytype' => 'Townhouse',
'image_folder' => 'ps_4x4tk1EKKP217Q_674d9598a9d49',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '44033',
'zone_name' => 'Al Merkadh',
'DLD_P_number' => '71258698851',
'agent_license' => '57532',
'property_regulatory_agent_license' => '71258698851',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=bdy6edoyxh90pqs8n0svn4e3nrr2lv6z4xasvxsybobksifpe',
'broker_name' => 'Dilmurod Davlatov',
'broker_company_name' => 'IMZA PREMIUM PROPERTIES L.L.C',
'agent_link' => '/en/agent/dilmurod-davlatov-277989',
'page_title' => 'Sale in One Park Avenue: Prime location | Green Spaces | Smart Living | Property Finder',
'property_price' => '3,600,000',
'bathrooms' => '3 Bathrooms',
'bedrooms' => '3 Bedrooms',
'property_description' => 'One Park Avenue, a prestigious development by Sobha Group, offers 1, 2, 3, and 4-bedroom apartments located in Sobha Hartland, Dubai. This 24-story tower features an innovative sky garden and smart home technology, making it a unique offering in Dubai\'s real estate market. The development is surrounded by lush green spaces and a vibrant boulevard, ensuring a luxurious living experience. Security is enhanced with smart technology, providing residents with both comfort and peace of mind. Enjoy extensive outdoor green areas, creating an environment of relaxation and joy.
Its prime location offers easy access to major landmarks such as Burj Khalifa, Dubai Mall, Meydan Racecourse, and Ras Al Khor Wildlife Sanctuary.
Unit details:
3BR
Prime location
1606.73 sqft
Imza Premium Properties is a leading real estate firm in Dubai, specializing in the sale and rental of high-quality residential properties. With a deep understanding of the dynamic Dubai market, we are committed to delivering smooth, seamless transactions that prioritize our clients\' unique needs and goals.
Our approach is rooted in professionalism, market expertise, and a client-focused approach. We strive to offer personalized solutions, ensuring every client receives the highest level of service',
'surface' => '1,606 sqft / 149 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_BWRvGy9XNZlaTw_674d95a619b5f',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '31840',
'zone_name' => 'Marsa Dubai',
'DLD_P_number' => '7126082368',
'agent_license' => '76207',
'property_regulatory_agent_license' => '7126082368',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=q3ded7jo0si8d368a2vx5b0hhbdsr0ncr7vkxyfehxqtxtasf',
'broker_name' => 'Anastasiia Belova',
'broker_company_name' => 'Intrust agency',
'agent_link' => '/en/agent/anastasiia-belova-286149',
'page_title' => 'Sale in Stella Maris: BEST MARKET PRICE I FULLY FURNISHED I MID HIGH FLOOR | Property Finder',
'property_price' => '2,240,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => '1 Bedroom',
'property_description' => 'ORN 31840
BRN 76207
1br apartment 740 sqft on middle high floor for sale!
Bloom Holding presents one a magnificent apartment tower and one of the most stunning waterfront developments in the city Stella Maris Tower.
The position of the residences is perfectly situated in the forefront of Dubai Marina’s existing and future amusement amenities including the biggest Ferris wheel in the world.
Main Features:
- Concierge Service
- Club House
- Day care
- Private Cinema
- Spa, Gym, Pools
- Running Track
- Lounge area
- Valet Parking
- Visitors parking
- Multipurpose hall
- Boardwalk
- Proximity to major routes and Highways
- Walking distance to all Dubai Marina district amenities
Connectivity:
- 05 minutes - RRA Radel Dubai Sports Center and Emirates Golf Club
The City Village theme park is a 20-25 minute drive away. There are attractions and entertainment venues for all tastes.
- 05 minuted walk - Marina Beach, Dubai Marina Mall, as well as restaurants, clubs and other facilities on the waterfront Dubai Marina Promenade.
- 10 minutes - Nurseries and educational centers, the nearest of them is Willow Children’s Nursery, British Orchard Nursery
- 10 minutes walk - DMCC Metro Station
- 15 minutes - Public schools
- 20 minutes drive - The Burj Khalifa skyscraper, the Dubai Opera House and the Dubai Fountain show
- 30 minutes - Dubai International Airport and Al Maktoum International Airport 30 minutes
Contact us for more information!',
'surface' => '740 sqft / 69 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_Wy3UvXE83EgqHA_674d95af9d935',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '29385',
'DLD_P_number' => '0256509932',
'agent_license' => '67567',
'property_regulatory_agent_license' => '0256509932',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=waku3h3cfnqy45m7xb01kjw6gbf3h0bbynqsixyruxnoxbuin',
'broker_name' => 'Sajjad Asghar',
'broker_company_name' => 'Blue Crown Real Estate',
'agent_link' => '/en/agent/sajjad-asghar-250939',
'page_title' => 'Sale in Beach Walk III by Imtiaz: WATER FRONT LIVING | FULLY FURNISHED | HIGH ROI | | Property Finder',
'property_price' => '1,997,750',
'bathrooms' => '2 Bathrooms',
'bedrooms' => '1 Bedroom',
'property_description' => 'Blue Crown Real Estate.
Presents 1 BEDROOM apartment in Beach Walk 3 by Imtiaz, offering luxury living amidst contemporary conveniences and serene surroundings.
Beach Walk 3 by Imtiaz Development at Dubai Islands offers 1 & 2-bedroom apartments and 3-bedroom penthouses, blending modern convenience with coastal tranquility. With luxurious design, world-class amenities, and prime connectivity to Downtown Dubai, the airport, and leisure spots, it sets a new standard for luxury waterfront living.
Payment Plan:
Down Payment: 20%
During Construction: 40%
On Handover : 40%
Handover (Q2 2026)
Starting Prices:
1BR: AED 1.9M
2BR: AED 2.7M
3BR: AED 5.5M
Key Features:
1-4 bedroom units with sea views
Fully furnished units with Miele kitchen
appliances
Private pools on balconies for selected units
Smart home system
Prime location near Dubai Islands\' first waterfront
Golf course
Unit Details:
Fully Furnished and Signature Designed
Spacious Hall with Sunny Window
1 Bright Capacious bedrooms
2 Bathrooms
Big Size Kitchen
Fixed Cabinet
Central AC
Bright Dining Area
Spacious Living Areas
Storage Areas
Huhe balconi
Building Features
Family Swimming Pool
Zen Garden
Adult-Only Rooftop Infinity Pool
BBQ Area
Outdoor Yoga Retreat
Extra Visitor Parking
Kids Play Area
Rooftop Garden
Club Room
Fully Equipped Gym
Points of Interest
15 Minutes. Burj Khalifa
15 Minutes. Dubai Mall
10 Minutes. Dubai International Airport
08. Minutes. Al Mamzar Beach
15 Minutes. Jumeirah Beach
15 Minutes. La Mer Beach
ABOUT US:
Blue Crown Real Estate is an authorized
licensed and experienced property agency in Dubai, with years of excellent service that continues to offer commendable services to the growing number of our most valued clients. Our main focus
is on building long-term relationships in buying selling, and leasing a wide range of premium properties in UAE.
For further particulars plus inquiries, please give us a call;
Property Consultant:
Sajjad Asghar
Mobile: +971566231442 (Call & WhatsApp)
Email: sajjad.bluecrown@gmail.com
We will give you the best one according to your desires.',
'surface' => '937 sqft / 87 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_X15zUTFHtBrJBg_674d95bd96c62',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'property_regulatory_agent_license' => NULL,
'styles_desktop_value' => NULL,
'dubailand_url' => NULL,
'broker_name' => NULL,
'broker_company_name' => NULL,
'agent_link' => NULL,
'page_title' => 'Apartments for sale in Downtown Dubai - 4324 Flats for sale | Property Finder UAE',
'property_price' => NULL,
'bathrooms' => NULL,
'bedrooms' => NULL,
'property_description' => NULL,
'surface' => NULL,
'propertytype' => NULL,
'image_folder' => NULL,
)array (
'property_regulatory_agent_license' => NULL,
'styles_desktop_value' => NULL,
'dubailand_url' => NULL,
'broker_name' => NULL,
'broker_company_name' => NULL,
'agent_link' => NULL,
'page_title' => 'Apartments for sale in Downtown Dubai - 4324 Flats for sale | Property Finder UAE',
'property_price' => NULL,
'bathrooms' => NULL,
'bedrooms' => NULL,
'property_description' => NULL,
'surface' => NULL,
'propertytype' => NULL,
'image_folder' => NULL,
)array (
'property_regulatory_agent_license' => NULL,
'styles_desktop_value' => NULL,
'dubailand_url' => NULL,
'broker_name' => NULL,
'broker_company_name' => NULL,
'agent_link' => NULL,
'page_title' => 'Apartments for sale in Downtown Dubai - 4324 Flats for sale | Property Finder UAE',
'property_price' => NULL,
'bathrooms' => NULL,
'bedrooms' => NULL,
'property_description' => NULL,
'surface' => NULL,
'propertytype' => NULL,
'image_folder' => NULL,
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
Warning: pg_execute(): Query failed: ERROR: invalid input syntax for type bigint: ""
CONTEXT: unnamed portal parameter $1 = '' in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 815
array (
'listed' => '9 days ago',
'broker_license' => '39955',
'zone_name' => 'Al Barsha South Fourth',
'DLD_P_number' => '71527705977',
'agent_license' => '65807',
'property_regulatory_agent_license' => '71527705977',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=jqwbdcva6rv03oc0n5j59hv3g5zkiqub0ppbecgtxyfffbvuw',
'broker_name' => 'Rahul Paitka Sutanta Kumar',
'broker_company_name' => 'RIGHTEOUS PROPERTIES L.L.C',
'agent_link' => '/en/agent/rahul-paitka-sutanta-kumar-282330',
'page_title' => 'Sale in Binghatti Orchid: Near to Handover | Stunning Views | High-End Finishing | Property Finder',
'property_price' => '1,850,000',
'bathrooms' => '3 Bathrooms',
'bedrooms' => '2 Bedrooms',
'property_description' => 'Righteous Properties is proud to introduce an exceptional 2-bedroom apartment at Binghatti Orchid. This brand-new, spacious corner unit offers both luxury and functionality, with expansive living areas, premium finishes, and stunning views. Ideally located in the sought-after Jumeirah Village Circle (JVC), this property promises a fantastic investment opportunity with high return potential.
Property Overview:
• Location: Binghatti Orchid, Jumeirah Village Circle (JVC), Dubai
• Type: 2-Bedroom
• Floor: High Floor
• View: Park View
• Bathrooms: 2
• Parking: 1 Dedicated Space
• Furnishing: Unfurnished
• Balconies: Large, with expansive city views
Key Features:
• Luxury Finishes: High-end fixtures and fittings throughout
• Open-Plan Layout: Bright and spacious interiors with floor-to-ceiling windows
• Fully Fitted Kitchen: With integrated modern appliances
Community Facilities:
• Private & Shared Swimming Pools
• Fully Equipped Gymnasium
• BBQ Area for outdoor dining and relaxation
• Children\'s Play Area
• Public Parks and Mosque
Connectivity:
• 10 minutes from Dubai Marina
• 7 minutes from Mall of the Emirates
• 12 minutes from Downtown Dubai
• Pet-Friendly Community
• Broadband Ready: High-speed internet connection
• Built-in Wardrobes: Ample storage space
• Basement Parking: Secure parking spaces
• Selling Price: AED 1,850,000
• Size: 1,811.35 sq. ft
• Handover Date: November 2024
For more information or to schedule a viewing, please contact: Mr. Ameer - +971 50 101 5052
About Binghatti Orchid:
Binghatti Orchid represents the pinnacle of luxury living in Dubai, combining architectural brilliance with thoughtful design. Inspired by the delicate elegance of the orchid flower, this development boasts flowing organic lines that integrate seamlessly with its surroundings. From the meticulously crafted interiors to the modern technology embedded in every detail, Binghatti Orchid is not just a residence, but a sanctuary of comfort and opulence.
With expansive windows framing spectacular views, the property exudes warmth and tranquility, offering residents the perfect balance of serene living and modern urban convenience.',
'surface' => '1,811 sqft / 168 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_NboChGJH9RQHXQ_674d95cf53a6a',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831
array (
'listed' => '9 days ago',
'broker_license' => '33189',
'zone_name' => 'Al Barsha South Fifth',
'DLD_P_number' => '71585711555',
'property_regulatory_agent_license' => '71585711555',
'styles_desktop_value' => '9 days ago',
'dubailand_url' => '/rev/madmoun/listing/validation?khevJujtDig=7g88tosupo976r7rc3csx6pjdpo2dinb0intytgtumwktmika',
'broker_name' => 'Alex Bygraves',
'broker_company_name' => 'TYRON ASH REAL ESTATE',
'agent_link' => '/en/agent/alex-bygraves-279418',
'page_title' => 'Sale in Red Square Tower: High Floor | Corner Unit | Fully Furnished | Property Finder',
'property_price' => '695,000',
'bathrooms' => '1 Bathroom',
'bedrooms' => 'Studio',
'property_description' => 'Tyron Ash International Real Estate is proud to present to you this exceptional fully furnished studio apartment located in Red Square Tower, the brand new luxury development in Jumeirah Village Triangle.
With its sleek, contemporary design, great location, and breathtaking panoramic city views, Red Square Twin Towers presents luxury in every way. Offering an unmatched level of comfort and elegance in your everyday lifestyle in Dubai.
Unit Details:
*1 Bed
*1 Bathroom
*High Floor
*354 sqft
*Fully Furnished
*Elegant Interior
*1 Car Parking Space
*Private Balcony
*Corner Unit
Located in Jumeirah Village Triangle, a remarkable place in Dubai, known for its exceptional architecture and unique natural sceneries. JVT offers a wide range of amenities to meet the needs of every individual, such as sports fields, parks and playgrounds.
*13 Minutes from JBR
*17 Minutes from Mall of Emirates
*19 Minutes from Palm Jumeirah
*20 Minutes from Global Village
*23 Minutes from Dubai Mall
Red Square Tower Amenities:
*Swimming Pool
*Basketball Court
*Running Track
*Fully Equipped Gym
*BBQ Area
*Tennis Court
For anymore information please contact Alex at Tyron Ash and he will be happy to answer any questions.
+971585220680
alex.bygraves@tyronash.com',
'surface' => '354 sqft / 33 sqm',
'propertytype' => 'Apartment',
'image_folder' => 'ps_6nmf2KtP6E0kXg_674d95d8d9a6e',
)
Warning: pg_prepare(): Query failed: ERROR: prepared statement "updateListing" already exists in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 776
Warning: Undefined array key "maid" in /var/www/html/weav3/crons/PropertyFinderURL_scrapp_st2/index3.php on line 831