SQF Realty Real Estate Management

Russian

Italian

Dutch

Irina Meidman

Netherlands

Al Raha Beach

SQF Realty is a boutique real estate agency specialised in premium waterfront properties in Abu Dhabi

Spacious 1 bed apartment with sea view and balcony

Stunning sunset and sea view 2 bed apartment

Amazing Full Sea View 3 bedroom + maids apartment

Apartments

Villas

Townhouses

Land

Residential Properties for Sale

Mortgage Calculator

Sold House Prices

Sale Price Map

Buyer Tools

Buyer's Guide

Area Insights

Community Guides

Tower & Compound Guides

Schools & University Guides

Buying Insights

See Your Mortgage Estimate

Buy Residential Properties

Buy Commercial Properties

Find a Real Estate Agent

New Projects & Off-plan

Show all properties

Studios

Residential Properties for Rent

Pay rent monthly

Rent vs Buy Calculator

Rented House Prices

Rental Price Map

Renter Tools

Renter's Guide

Renting Insights

Forget the big cheques, split your rent into 12 monthly installments

See how it works

Rent Residential Properties

Rent Commercial Properties

Short-Term Rentals

New Projects in Dubai

New Projects in Abu Dhabi

New Projects in Sharjah

New Projects in Ras Al Khaimah

New Projects in Umm Al Quwain

All New Projects

Emaar Properties

Azizi Developments

Aldar Properties

Damac Properties

Sobha Realty

Find Developers in the UAE

Investor's Guide

Areas to invest

Latest Projects

Investing Insights

Find Developers

Off-plan Properties

Show all projects

Rental Transactions

Sale Transactions

Tools

Market Reports

Renter Guides

Buyer Guides

Popular Communities

Budget-Friendly Areas

Property Blog

Insights

Dubai

Abu Dhabi 

Sharjah

Ajman

Ras Al Khaimah

Whether you’re buying, renting, or exploring off-plan, every confident property search starts here.

Explore Blog

Rent Vs Buy Calculator 

Popular Communities 

Tools & Insights

Find Agents

Mortgage Cashback

Mortgage Finder

Mortgages

Step into refined waterfront living with this amazing 1-bedroom apartment at Lamar Residences – one of Al Raha Beach’s most sought-after addresses. 

Featuring one of the best layouts in the building, with a larger living room, open kitchen and a balcony, this unit is designed to impress with full heigh panoramic height floor-to-ceiling glass windows offering breathtaking sea and community views from every room.

Vacant on Transfer

Apartment Features:

•	1 Spacious Bedroom
•	Large Open-Plan Living and Dining Area
•	Full Floor-to-Ceiling Glass Windows Throughout
•	Private Balcony with Stunning Views
•	Modern Open Kitchen
•	High-Quality Finishes and Built-in Wardrobes

Community Amenities:

•	Large Pool & Fully Equipped Gym
•	Waterfront Promenade for Walking & Cycling
•	Sky Garden, Outdoor BBQ Terraces & Leisure Deck
•	Indoor and Outdoor Kids’ Play Areas
•	Retail & Medical Center
•	Games Room

Prime Location in Al Raha Beach:

•	15 minutes to Yas Island, Yas Mall & Ferrari World
•	15 minutes to Zayed International Airport
•	20 minutes to Louvre Abu Dhabi
•	Minutes from Al Raha Mall, cafes, and restaurants

Enjoy panoramic views and spacious living in this beautifully crafted apartment – perfect for end users and investors alike.

To arrange a private viewing, contact us today.

Lamar Residences

Abu Dhabi

Al Seef

Step into refined waterfront living with this 2-bedroom apartment at Lamar Residences – one of Al Raha Beach’s most sought-after addresses. Featuring one of the best layouts in the building, on a high floor, with a larger living room, this unit is designed to impress with full-height floor-to-ceiling glass windows offering breathtaking sea and city views from every room. No Balcony

High ROI - Tenanted till July 2027 with full rent refund

Apartment Features:
-	2 Spacious Bedrooms
-	Large Open-Plan Living and Dining Area
-	Full Floor-to-Ceiling Glass Windows Throughout
-	Stunning Views – Sunset and Full Sea View
-	Modern Kitchen
-	High-Quality Finishes and Built-in Wardrobes
-	NO BALCONY

Community Amenities:

-	Large Pool & Fully Equipped Gym
-	Waterfront Promenade for Walking & Cycling
-	Sky Garden, Outdoor BBQ Terraces & Leisure Deck
-	Indoor and Outdoor Kids’ Play Areas
-	Retail & Medical Center
-	Games Room

Prime Location in Al Raha Beach:

-	15 minutes to Yas Island, Yas Mall & Ferrari World
-	10 minutes to Zayed International Airport
-	20 minutes to Louvre Abu Dhabi
-	Minutes from Al Raha Mall, cafes, and restaurants

Enjoy panoramic views and spacious living in this beautifully crafted apartment – perfect for end users and investors alike.
To arrange a private viewing, contact us today.

Amazing 3-bedroom + maids' apartment for sale with full sea view and full panoramic floor to ceiling windows.

Tenanted with rent refund until May 2027

Live the waterfront lifestyle at Lamar Residences, Al Raha Beach, Abu Dhabi! This stunning 3-bedroom apartment offers breathtaking full sea views and mesmerizing sunset views from all rooms, creating a serene and picturesque living experience.

Property Features:
-	Spacious 3 Bedrooms
-	Modern Open-plan Living & Dining Area
-	Balcony with Full Sea View
-	Full panoramic windows
-	High-end Finishes
-	Maid’s Room with Attached Bathroom
-	Built-in Wardrobes
-	2 parking spaces
Building Amenities:
- Swimming Pool & Gym
- Waterfront Promenade
- Outdoor Kids’ Play Area
- Retail & Medical Center
- Games Room & Leisure Deck
- Sky Garden & BBQ Terraces
- Supermarket

Prime Location in Al Raha Beach:
-	15 minutes to Yas Island & Ferrari World
-	20 minutes to Louvre Abu Dhabi
-	15 minutes to Zayed International Airport
-	Close to Al Raha Mall & Major Attractions
-	Close to international Schools
Experience luxury living with panoramic sea and sunset views from every room.
For inquiries and viewing, contact us today!

SQF Realty Real Estate Management