Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 509662
[post_author] => 1
[ListingKey] => MFR814721646
[ListingId] => PR9125166
[PropertyType] => For Sale
[PropertySubType] => Condominium
[StandardStatus] => Active
[ModificationTimestamp] => 2026-10-23T14:46:13Z
[RFModificationTimestamp] => 2026-10-23T15:02:12Z
[ListPrice] => 2000000
[BathroomsTotalInteger] => 4
[BathroomsHalf] => 1
[BedroomsTotal] => 3
[LotSizeArea] => 0
[LivingArea] => 2111
[BuildingAreaTotal] => 4004.2
[City] => San Juan
[PostalCode] => 00907
[UnparsedAddress] => 613 Constitucion Ave #1203, San Juan, Puerto Rico 00907
[Coordinates] => Array
(
[0] => -66.085296
[1] => 18.40858
)
[Latitude] => 18.40858
[Longitude] => -66.085296
[YearBuilt] => 1993
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Maria Garcia
[ListOfficeName] => LUXURY COLLECTION REAL ESTATE
[ListAgentMlsId] => 743511817
[ListOfficeMlsId] => 743574375
[OriginatingSystemName] => Stellar
[PublicRemarks] => Miramar Waterview Mansions Penthouse | Spectacular Lagoon and Ocean Views
Experience elevated living in this exceptional penthouse at Waterview Mansions, featuring 3 bedrooms, 3.5 bathrooms, and 2 parking spaces. Enjoy breathtaking views of the Condado Lagoon and the Atlantic Ocean, creating a stunning backdrop for urban living.
This spacious residence offers a unique opportunity to enjoy the beauty of waterfront/city living in one of San Juan’s desirable residential areas. Ideally located near Miramar’s renowned restaurants, boutiques, and lifestyle attractions, it combines spectacular water views with convenient access to the best of the city.
A distinctive penthouse opportunity in the heart of Miramar, Puerto Rico.
[Appliances] => Built-In Oven,Dishwasher,Dryer,Electric Cooktop,Electric Water Heater,Microwave,Range Hood,Refrigerator,Washer
[AssociationFee] => 2405.32
[AssociationFeeFrequency] => Monthly
[AssociationFeeIncludes] => Array
(
[0] => Guard - 24 Hour
[1] => Escrow Reserves Fund
[2] => Management
)
[AssociationName] => ASSOCIATION MANAGER
[AssociationName2] => WATERVIEW MANSIONS
[AssociationPhone] => TBD
[AssociationYN] => 1
[BathroomsFull] => 3
[BuildingAreaSource] => Owner
[BuildingAreaUnits] => Square Feet
[CommunityFeatures] => None
[ConstructionMaterials] => Array
(
[0] => Concrete
)
[Cooling] => Central Air,Mini-Split Unit(s)
[Country] => US
[CountyOrParish] => San Juan
[CreationDate] => 2026-10-23T14:19:32.015496+00:00
[DirectionFaces] => North
[Directions] => Driving through Ponce de Leon Avenue in Miramar at the very end of the Avenue will see Condominium Waterview Mansdions 613 Avenida de la Constitucion.
[ExteriorFeatures] => Awning(s),Balcony
[Flooring] => Marble,Tile
[FoundationDetails] => Array
(
[0] => Concrete Perimeter
)
[Furnished] => Unfurnished
[Heating] => None
[InteriorFeatures] => High Ceilings,Walk-In Closet(s)
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Array
(
[0] => Laundry Room
)
[Levels] => Array
(
[0] => Two
)
[ListAOR] => Puerto Rico
[ListAgentAOR] => Puerto Rico
[ListAgentDirectPhone] => 787-547-3900
[ListAgentEmail] => [email protected]
[ListAgentKey] => 689955761
[ListOfficeKey] => 572452653
[ListOfficePhone] => 787-420-6303
[ListOfficeURL] => https://luxurycollectionrealestate.com/
[ListingAgreement] => Exclusive Agency
[ListingContractDate] => 2026-10-20
[ListingTerms] => Cash,Conventional
[LivingAreaSource] => Owner
[LotFeatures] => Array
(
[0] => Corner Lot
)
[LotSizeAcres] => 0.49
[LotSizeSquareFeet] => 2111
[MLSAreaMajor] => 00907 - San Juan
[MlgCanUse] => Array
(
[0] => IDX
)
[MlgCanView] => 1
[MlsStatus] => Active
[OccupantType] => Vacant
[OnMarketDate] => 2026-10-23
[OriginalEntryTimestamp] => 2026-10-23T14:12:24Z
[OriginalListPrice] => 2000000
[OriginatingSystemKey] => 814721646
[OtherEquipment] => Array
(
[0] => Generator
)
[Ownership] => Condominium
[ParcelNumber] => 040-037-051-11-038
[ParkingFeatures] => Assigned,Covered
[PetsAllowed] => Array
(
[0] => Number Limit
[1] => Size Limit
[2] => Yes
)
[PhotosChangeTimestamp] => 2026-10-23T14:15:15Z
[PhotosCount] => 11
[PropertyCondition] => Array
(
[0] => Completed
)
[RoadResponsibility] => Array
(
[0] => Private Maintained Road
)
[RoadSurfaceType] => Array
(
[0] => Asphalt
)
[Roof] => Concrete
[SecurityFeatures] => Array
(
[0] => Gated Community
[1] => Secured Garage/Parking
)
[Sewer] => Public Sewer
[ShowingRequirements] => Array
(
[0] => Call Before Showing
)
[SpaFeatures] => Array
(
[0] => Above Ground
[1] => Heated
)
[SpaYN] => 1
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => PR
[StatusChangeTimestamp] => 2026-10-23T14:12:24Z
[StoriesTotal] => 12
[StreetName] => CONSTITUCION
[StreetNumber] => 613
[StreetSuffix] => AVENUE
[SubdivisionName] => MIRAMAR WATERVIEW MANSIONS
[TaxAnnualAmount] => 6400.09
[TaxYear] => 2026
[UnitNumber] => 1203
[UniversalPropertyId] => US-72127-N-04003705111038-S-1203
[Utilities] => Cable Available,Electricity Available,Water Available
[View] => Array
(
[0] => City
[1] => Water
[2] => Gulf/Ocean - Partial
)
[WaterBodyName] => CONDADO LAGOON
[WaterSource] => Array
(
[0] => Public
)
[WindowFeatures] => Array
(
[0] => Shades
)
[Zoning] => A
[MFR_DockYN] => 0
[MFR_SDEOYN] => 0
[MFR_PetSize] => Small (16-35 Lbs.)
[MFR_CondoFees] => 2405
[MFR_RoomCount] => 3
[MFR_WaterView] => Gulf/Ocean - Partial,Lagoon
[MFR_EscrowState] => FL
[MFR_FloorNumber] => 12
[MFR_WaterViewYN] => 1
[MFR_CurrentPrice] => 2000000.00
[MFR_InLawSuiteYN] => 0
[MFR_MinimumLease] => 1-2 Years
[MFR_NumberOfPets] => 2
[MFR_TotalAcreage] => 1/4 to less than 1/2
[MFR_UnitNumberYN] => 0
[MFR_CondoFeesTerm] => Monthly
[MFR_FloodZoneCode] => A
[MFR_WaterAccessYN] => 0
[MFR_WaterExtrasYN] => 0
[MFR_Association2YN] => 1
[MFR_TotalAnnualFees] => 57723.84
[MFR_AssociationEmail] => TBD
[MFR_ExistLseTenantYN] => 0
[MFR_LivingAreaMeters] => 196.12
[MFR_MonthlyHOAAmount] => 2405.32
[MFR_TotalMonthlyFees] => 4810.32
[MFR_AttributionContact] => 787-420-6303
[MFR_BuildingElevatorYN] => 1
[MFR_BuildingNameNumber] => WATERVIEW MANSIONS
[MFR_ListingExclusionYN] => 0
[MFR_PublicRemarksAgent] => Miramar Waterview Mansions Penthouse | Spectacular Lagoon and Ocean Views
Experience elevated living in this exceptional penthouse at Waterview Mansions, featuring 3 bedrooms, 3.5 bathrooms, and 2 parking spaces. Enjoy breathtaking views of the Condado Lagoon and the Atlantic Ocean, creating a stunning backdrop for urban living.
This spacious residence offers a unique opportunity to enjoy the beauty of waterfront/city living in one of San Juan’s desirable residential areas. Ideally located near Miramar’s renowned restaurants, boutiques, and lifestyle attractions, it combines spectacular water views with convenient access to the best of the city.
A distinctive penthouse opportunity in the heart of Miramar, Puerto Rico.
[MFR_AvailableForLeaseYN] => 1
[MFR_CondoLandIncludedYN] => 1
[MFR_LeaseRestrictionsYN] => 0
[MFR_LotSizeSquareMeters] => 196
[MFR_PropertyDescription] => Corner Unit,Penthouse
[MFR_WaterfrontFeetTotal] => 0
[MFR_MonthlyCondoFeeAmount] => 2405
[MFR_GreenVerificationCount] => 0
[MFR_OriginatingSystemName_] => Stellar MLS
[MFR_GreenEnergyGenerationYN] => 0
[MFR_BuildingAreaTotalSrchSqM] => 372.00
[MFR_NumAssignedParkingSpaces] => 2
[MFR_AssociationFeeRequirement] => Required
[MFR_PublicRemarksAgentSpanish] => Penthouse en Waterview Mansions | Espectaculares Vistas a la Laguna y al Océano
Disfrute de un estilo de vida exclusivo en este excepcional penthouse en Waterview Mansions, con 3 habitaciones, 3.5 baños y 2 espacios de estacionamiento. La propiedad ofrece impresionantes vistas a la Laguna del Condado y al océano Atlántico, creando un entorno privilegiado para disfrutar de la belleza del paisaje y la vida urbana.
Esta espaciosa residencia representa una excelente oportunidad para vivir en Miramar en una de las zonas residenciales más atractivas de San Juan. Su ubicación privilegiada permite disfrutar de la cercanía a los reconocidos restaurantes, boutiques y diversas atracciones que distinguen a Miramar.
Una oportunidad excepcional para disfrutar de las vistas y el estilo de vida que ofrece Miramar, Puerto Rico.
[MFR_AdditionalWaterInformation] => PENTHOUSE SECOND FLOOR TERRACE WITH VIEWS TO THE CONDADO LAGOON AND OCEAN
[MFR_ListOfficeContactPreferred] => 787-420-6303
[MFR_MontlyMaintAmtAdditionToHOA] => 0
[MFR_AssociationApprovalRequiredYN] => 0
[MFR_YrsOfOwnerPriorToLeasingReqYN] => 0
[MFR_ListOfficeHeadOfficeKeyNumeric] => 572452653
[MFR_CalculatedListPriceByCalculatedSqFt] => 947.42
[MFR_RATIO_CurrentPrice_By_CalculatedSqFt] => 947.42
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('MFR814721646')
[provider_name] => Stellar
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6adb6bda4aa1f0adeed4ab5e
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/ea0494cf627884aa7a38f640988901a0.webp
[MediaSize] => 311673
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-ea0494cf627884aa7a38f640988901a0.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 899
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x899
[MediaModificationTimestamp] => 2026-10-23T14:14:50.787Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6adb6bda4aa1f0adeed4ab5f
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/03e1446e4717c9b1c55f59d7a4f53b18.webp
[MediaSize] => 242617
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-03e1446e4717c9b1c55f59d7a4f53b18.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.746Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6adb6bda4aa1f0adeed4ab60
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/90e3f9774db3f81570b4ad97952a84de.webp
[MediaSize] => 178018
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-90e3f9774db3f81570b4ad97952a84de.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.746Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6adb6bda4aa1f0adeed4ab61
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/b074d4758efeb1728526fffc026a74d8.webp
[MediaSize] => 176428
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-b074d4758efeb1728526fffc026a74d8.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.746Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6adb6bda4aa1f0adeed4ab62
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/2fc35de27129cb729b426eb845979a87.webp
[MediaSize] => 167581
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-2fc35de27129cb729b426eb845979a87.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.737Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6adb6bda4aa1f0adeed4ab63
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/3612d1c29f4702e352ef098a1eac5aba.webp
[MediaSize] => 132720
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-3612d1c29f4702e352ef098a1eac5aba.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.741Z
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6adb6bda4aa1f0adeed4ab64
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/0c22376fca68767b88fa4219a0689bf2.webp
[MediaSize] => 118997
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-0c22376fca68767b88fa4219a0689bf2.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.732Z
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6adb6bda4aa1f0adeed4ab65
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/0ba2fcb01a7b924d388809f58ca9fbaf.webp
[MediaSize] => 106541
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-0ba2fcb01a7b924d388809f58ca9fbaf.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.763Z
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6adb6bda4aa1f0adeed4ab66
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/428559ef1c01bdcf27ac548ab45f7d95.webp
[MediaSize] => 165563
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-428559ef1c01bdcf27ac548ab45f7d95.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.742Z
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6adb6bda4aa1f0adeed4ab67
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/9ee36dacf95ab7ae7bd07f1deaab739f.webp
[MediaSize] => 194965
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-9ee36dacf95ab7ae7bd07f1deaab739f.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.742Z
)
[10] => Array
(
[Order] => 10
[MediaKey] => 6adb6bda4aa1f0adeed4ab68
[MediaURL] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/dbab4b9a17a70063e15ebb7a68a01ee8.webp
[MediaSize] => 217653
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/15/MFR814721646/thumbnail-dbab4b9a17a70063e15ebb7a68a01ee8.webp
[ImageWidth] => 1600
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1066
[MediaCategory] =>
[ResourceRecordKey] => MFR814721646
[ImageSizeDescription] => 1600x1066
[MediaModificationTimestamp] => 2026-10-23T14:14:50.745Z
)
)
[DaysOnMarket] => 3
[ID] => 509662
)
Description
STUDIO apartment for sale in Condado 890, located at 890 Ashford Ave., Apt. 7D, Condado, San Juan, PR 00907, right across from the Condado Plaza. The property features approximately 1, 360 square feet (126.4 m²), distributed into a bedroom area, 1 bathroom, living room, kitchen, and a balcony overlooking the Condado Lagoon and the ocean. It includes 1 parking space and is sold fully furnished and equipped, ready for immediate occupancy. Excellent location right on Ashford Avenue, close to the beach, hotels, restaurants, shops, and the main attractions of Condado.
Details
Property ID
PR9124694
PR9124694
Bedroom
1
1
Bathroom
1
1
Property Size
1360 Square Feet
1360 Square Feet
Year Built
1980
1980
MLS#
PR9124694
PR9124694
Address
- Address 890 Ashvrod Ave. CONDADO 890 CONDO
- City San Juan
- State/county PR
- Zip/Postal Code 00907
- Area CONDADO
- Country US
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI
- Monthly HOA Fees