423 Properties
Sort by:
1365 WILSON AVENUE EAST, HAVEN THE RESIDENCES , San Juan, PR 00907
1365 WILSON AVENUE EAST, HAVEN THE RESIDENCES , San Juan, PR 00907 Details
1 year ago
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Cache Key: 5ca7cc9bb4621e62a3484b105038fb2f0bcddc5f759512ce67216f71e35d9a70" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#313 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2353 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR722276845" +"ListingId": "PR9105585" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-23T14:10:08Z" +"RFModificationTimestamp": "2024-12-23T14:11:49Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "San Juan" +"PostalCode": "00926" +"UnparsedAddress": "Camino Entrada Al Lago, San Juan, Puerto Rico 00926" +"Coordinates": array:2 [ …2] +"Latitude": 18.360405 +"Longitude": -66.077994 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "MAYTE SOTOMAYOR ALONSO" +"ListOfficeName": "MARES - MANAGEMENT REALTY EXPERT" +"ListAgentMlsId": "743575213" +"ListOfficeMlsId": "743580036" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "14 cords, 1 office and three houses, various structures and small squares, 5 electricity meters, fruit trees. Septic tank. Used for Cannabis farm/planting. Horse farm, zipline" +"BuildingAreaUnits": "Square Feet" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-04-06T04:07:53.872487+00:00" +"CumulativeDaysOnMarket": 262 +"CurrentUse": array:1 [ …1] +"DaysOnMarket": 539 +"Directions": """ Tome PR-21, Expreso Las Américas/PR-18, PR-52, Avenida Las Cumbres/PR-199 y PR-176 hasta Cam. Los Andinos en Cupey15 min (9.9 km)Continuar por Cam. Los andinos. Conduzca hasta el Paseo Las Curias.\r\n \r\n \r\n \r\n Take PR-21, Expreso Las Américas/PR-18, PR-52, Las Cumbres Ave/PR-199 and PR-176 to Cam. Los Andinos in Cupey15 min (9.9 km)Continue on Cam. The Andeans. Drive to Paseo Las Curias """ +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-782-4444" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530176" +"ListAgentPager": "787-782-4444" +"ListAgentURL": "http://[email protected]" +"ListOfficeKey": "507530016" +"ListOfficePhone": "939-287-7097" +"ListOfficeURL": "http://[email protected]" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-04-05" +"LotSizeAcres": 13.6 +"LotSizeDimensions": "55.026 mts2" +"LotSizeSquareFeet": 592295 +"MLSAreaMajor": "00926 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2024-04-05" +"OriginalEntryTimestamp": "2024-04-05T19:10:20Z" +"OriginalListPrice": 1100000 +"OriginatingSystemKey": "722276845" +"Ownership": "Fee Simple" +"ParcelNumber": "115-000-006-38-901" +"PhotosChangeTimestamp": "2024-04-05T20:22:08Z" +"PhotosCount": 83 +"RoadSurfaceType": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-04-05T19:10:20Z" +"StreetName": "CAMINO ENTRADA AL LAGO" +"UniversalPropertyId": "US-72127-N-11500000638901-R-N" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9105585" +"WaterSource": array:2 [ …2] +"Zoning": "R1" +"MFR_FrontFootage": "296148" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530016" +"MFR_LotSizeSquareMeters": "55026" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "939-287-7097" +"MFR_PricePerAcre": "80882" +"MFR_CalculatedListPriceByCalculatedSqFt": "1.86" +"MFR_WaterAccessYN": "0" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "1.86" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "14 cords, 1 office and three houses, various structures and small squares, 5 electricity meters, fruit trees. Septic tank. Used for Cannabis farm/planting. Horse farm, zipline" +"MFR_CurrentPrice": "1100000.00" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "x" +"MFR_TotalAcreage": "10 to less than 20" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "See Remarks" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ForLeaseYN": "0" +"MFR_PublicRemarksAgentSpanish": "14 cuerdas, 1 oficina y tres casas varias estructuras y plazoletas, 5 contadores de luz, arboles frutales . Pozo septico. Sirve para finca de Cannabis/ siembra . Finca de caballos, zipline" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "939-287-7097" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR722276845')" +"provider_name": "Stellar" +"Media": array:83 [ …83] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2354 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR714193587" +"ListingId": "PR9104448" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T13:28:07Z" +"RFModificationTimestamp": "2024-12-16T13:32:38Z" +"ListPrice": 1600000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "San Juan" +"PostalCode": "00907" +"UnparsedAddress": "631 Fernandez Juncos Avenue, San Juan, Florida 00907" +"Coordinates": array:2 [ …2] +"Latitude": 18.4543848 +"Longitude": -66.08726761 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brenda Nieves" +"ListOfficeName": "PUERTO RICO SOTHEBY'S INTL. REALTY" +"ListAgentMlsId": "743575381" +"ListOfficeMlsId": "743580117" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Situated within close proximity to the Convention District Area, entertainment venues, restaurants, and cultural attractions, this prime location offers unparalleled visibility and foot traffic. This lot presents an exceptional opportunity for commercial development with lucrative tourist potential. Visitors and locals alike frequent this area, making it an ideal destination for a wide range of commercial ventures. With easy access to major transportation hubs and thoroughfares, including highways and public transit systems. In summary, this empty lot offers a rare chance to capitalize on the city's dynamic energy and vibrant culture. With its unbeatable location, accessibility, and commercial potential, it's the perfect canvas for creating a landmark destination that will leave a lasting impression on visitors and locals alike. Zoning: CT-2. The Miramar Arts District offers a captivating blend of historic charm, modern sophistication, and natural beauty. Rich in history and culture, Miramar is home to a diverse array of art galleries, museums, and cultural institutions. From the iconic Puerto Rico Convention Center and Distrito TMobile entertainment complex to its historic landmarks. Miramar is a culinary hotspot, with a wide variety of restaurants, cafes, and eateries offering everything from traditional Puerto Rican cuisine to international fare. The area also boasts a vibrant nightlife scene, with trendy bars, lounges, and entertainment venues catering to every taste." +"BuildingAreaUnits": "Square Feet" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-02-06T23:03:28.877295+00:00" +"CumulativeDaysOnMarket": 314 +"CurrentUse": array:1 [ …1] +"DaysOnMarket": 598 +"Directions": "Head southeast on Av. Manuel Fernandez Juncos/PR-35 toward C. Union. Turn left at the 1st cross street onto C. Union. Turn left onto C. Roosevelt. Turn left onto Av. Miramar. Turn right at the 1st cross street onto Av. Manuel Fernández Juncos/PR-35. Destination will be on the right." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-523-6500" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507791183" +"ListOfficeKey": "507530044" +"ListOfficePhone": "787-523-6500" +"ListOfficeURL": "http://puertoricosothebysrealty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-02-06" +"LotSizeAcres": 0.44 +"LotSizeDimensions": "228 x 139" +"LotSizeSquareFeet": 19176 +"MLSAreaMajor": "00907 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2024-02-06" +"OriginalEntryTimestamp": "2024-02-06T20:55:44Z" +"OriginalListPrice": 1900000 +"OriginatingSystemKey": "714193587" +"Ownership": "Fee Simple" +"ParcelNumber": "040 037 740 02 001" +"PhotosChangeTimestamp": "2024-02-07T14:09:09Z" +"PhotosCount": 11 +"PreviousListPrice": 1900000 +"PriceChangeTimestamp": "2024-04-09T17:54:28Z" +"RoadSurfaceType": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-02-06T20:55:44Z" +"StreetName": "FERNANDEZ JUNCOS" +"StreetNumber": "631" +"StreetSuffix": "AVENUE" +"TaxAnnualAmount": "6105" +"TaxYear": "2024" +"UniversalPropertyId": "US-72127-N-04003774002001-R-N" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"Zoning": "CT-2" +"MFR_FrontFootage": "228" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530044" +"MFR_LotSizeSquareMeters": "1782" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "787-523-6500" +"MFR_PricePerAcre": "3636364" +"MFR_CalculatedListPriceByCalculatedSqFt": "83.44" +"MFR_WaterAccessYN": "0" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "83.44" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Situated within close proximity to the Convention District Area, entertainment venues, restaurants, and cultural attractions, this prime location offers unparalleled visibility and foot traffic. This lot presents an exceptional opportunity for commercial development with lucrative tourist potential. Visitors and locals alike frequent this area, making it an ideal destination for a wide range of commercial ventures. With easy access to major transportation hubs and thoroughfares, including highways and public transit systems. In summary, this empty lot offers a rare chance to capitalize on the city's dynamic energy and vibrant culture. With its unbeatable location, accessibility, and commercial potential, it's the perfect canvas for creating a landmark destination that will leave a lasting impression on visitors and locals alike. Zoning: CT-2. The Miramar Arts District offers a captivating blend of historic charm, modern sophistication, and natural beauty. Rich in history and culture, Miramar is home to a diverse array of art galleries, museums, and cultural institutions. From the iconic Puerto Rico Convention Center and Distrito TMobile entertainment complex to its historic landmarks. Miramar is a culinary hotspot, with a wide variety of restaurants, cafes, and eateries offering everything from traditional Puerto Rican cuisine to international fare. The area also boasts a vibrant nightlife scene, with trendy bars, lounges, and entertainment venues catering to every taste." +"MFR_CurrentPrice": "1600000.00" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "1/4 to less than 1/2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "See Remarks" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ForLeaseYN": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-523-6500" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR714193587')" +"provider_name": "Stellar" +"Media": array:11 [ …11] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2355 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR740255351" +"ListingId": "PR9109905" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-15T14:08:07Z" +"RFModificationTimestamp": "2024-11-15T14:23:47Z" +"ListPrice": 5590000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 4006.0 +"BuildingAreaTotal": 4006.0 +"City": "San Juan" +"PostalCode": "00911" +"UnparsedAddress": "1758 Mcleary Avenue, San Juan, Puerto Rico 00911" +"Coordinates": array:2 [ …2] +"Latitude": 18.45297 +"Longitude": -66.05968 +"YearBuilt": 1932 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Caroline Johnson" +"ListOfficeName": "CORCORAN PUERTO RICO" +"ListAgentMlsId": "743511549" +"ListOfficeMlsId": "743511482" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ A piece of art in the iconic Spanish Revival style, this villa was meticulously crafted in the 1930’s by esteemed architect Pedro Adolfo de Castro. The historic gem spans 4,006 square feet of living space, featuring 5 beds/3.5 baths over two buildings. Located just one block from the widest expanse of beach on the most desirable residential block between Ocean Park and Condado, the property sits on a massive 1099 square meter lot. The land benefits from RT3 zoning, presenting a unique development opportunity. Whether inhabiting this cultural marvel or developing a larger structure, it must be seen and experienced.\r\n \r\n A vast Moroccan garden with water feature and lush landscaping greets visitors with dramatic flourish. As you approach the main entrance - look closely - tiny shells have been incorporated into the entire facade offering a glimpse of the intricacy that awaits. \r\n \r\n Open the front door and witness the sophistication of the interiors, featuring 12-foot ceilings, grand Spanish-style arches, original Terrazzo flooring with ornate bronze seams, custom mahogany woodwork, and Spanish wrought iron. The formal entry and living room are surrounded by windows, continuing the harmonious flow of the tropical gardens outside.\r\n \r\n Behind this grand reception room, a powder room with beautiful stained-glass windows, is conveniently located for visitors. Walk down the hallway, ornamented with immense arches for an aura of grandeur, to the formal library. Adjacent you’ll find a tremendous walk-in climate-controlled wine cave.\r\n \r\n The kitchen is conveniently located nearby and harkens to colorful, classic Puerto Rican cuisine, while equipped with stainless steel and all modern appliances. Connected to the kitchen is the informal dining area and wet bar.\r\n \r\n Float to the elegant formal dining room where a massive floor to ceiling window bathes the space in light. This accent window offers a new vantage point to witness the breath-taking sculpture garden and mosaic fountains outside, making for the most exquisite dining conversation.\r\n \r\n A grand bronze staircase ascends to the second level where you will discover the home’s 3 beds/2 baths, home office, and truly unique Moroccan sitting room.\r\n \r\n The expansive primary suite is a private sanctum of elegance and sophistication. Throw open the French doors to a romantic Juliette balcony overlooking the front garden below. Soak in the jacuzzi tub, an entire spa room apart from the ensuite bathroom for the ultimate in relaxation.\r\n \r\n A distinct walking bridge from the second floor leads to an additional recently remodeled living quarter, which includes 1 bed/1 bath, an office space, and a large area currently serving as an art gallery. \r\n \r\n From this level, ascend the grand outdoor spiral staircase, itself an architectural masterpiece, to view sunsets from the roof, or descend a second spiral staircase to the grounds below. The black bottomed pool, surrounded by mature tropical landscaping, is designed as both a beautiful focal point and for use and enjoyment. \r\n \r\n This entire residence is completely gated for the utmost security, while the driveway leads to an enclosed, private three-car garage. The property is equipped with an automatic Generac-Diesel 30 KLV generator and a 600-gallon water cistern, ensuring uninterrupted convenience.\r\n \r\n This home seamlessly blends contemporary amenities with preserved original elements, situated on one of the largest and most rare lots in Condado. Contact me today. """ +"Appliances": array:9 [ …9] +"BathroomsFull": 3 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-11-06T14:20:59.841220+00:00" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 324 +"DirectionFaces": "North" +"Directions": "From highway 26 take the Calle Loiza exit. Make. right onto Ashford Avenue and find the residence on the right side of the street." +"ExteriorFeatures": array:9 [ …9] +"Flooring": array:2 [ …2] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:1 [ …1] +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-900-7636" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "577358595" +"ListOfficeKey": "571428148" +"ListOfficePhone": "939-478-6028" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-11-05" +"LivingAreaSource": "Owner" +"LotSizeAcres": 0.27 +"LotSizeSquareFeet": 11830 +"MLSAreaMajor": "00911 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2024-11-06" +"OriginalEntryTimestamp": "2024-11-06T14:15:09Z" +"OriginalListPrice": 5590000 +"OriginatingSystemKey": "740255351" +"Ownership": "Fee Simple" +"ParcelNumber": "041-041-178-04-901" +"PhotosChangeTimestamp": "2024-11-06T14:17:08Z" +"PhotosCount": 29 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"RoadSurfaceType": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-11-06T14:15:09Z" +"StreetName": "MCLEARY AVENUE" +"StreetNumber": "1758" +"SubdivisionName": "CONDADO" +"UniversalPropertyId": "US-72127-N-04104117804901-R-N" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=i Tky4in Gy4z" +"WaterSource": array:1 [ …1] +"Zoning": "RT3" +"MFR_ListOfficeHeadOfficeKeyNumeric": "571428148" +"MFR_LivingAreaMeters": "372.17" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "1099" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "787-565-8972" +"MFR_CalculatedListPriceByCalculatedSqFt": "1395.41" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109905?w=Customer" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "1395.41" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": """ A piece of art in the iconic Spanish Revival style, this villa was meticulously crafted in the 1930’s by esteemed architect Pedro Adolfo de Castro. The historic gem spans 4,006 square feet of living space, featuring 5 beds/3.5 baths over two buildings. Located just one block from the widest expanse of beach on the most desirable residential block between Ocean Park and Condado, the property sits on a massive 1099 square meter lot. The land benefits from RT3 zoning, presenting a unique development opportunity. Whether inhabiting this cultural marvel or developing a larger structure, it must be seen and experienced.\r\n \r\n A vast Moroccan garden with water feature and lush landscaping greets visitors with dramatic flourish. As you approach the main entrance - look closely - tiny shells have been incorporated into the entire facade offering a glimpse of the intricacy that awaits. \r\n \r\n Open the front door and witness the sophistication of the interiors, featuring 12-foot ceilings, grand Spanish-style arches, original Terrazzo flooring with ornate bronze seams, custom mahogany woodwork, and Spanish wrought iron. The formal entry and living room are surrounded by windows, continuing the harmonious flow of the tropical gardens outside.\r\n \r\n Behind this grand reception room, a powder room with beautiful stained-glass windows, is conveniently located for visitors. Walk down the hallway, ornamented with immense arches for an aura of grandeur, to the formal library. Adjacent you’ll find a tremendous walk-in climate-controlled wine cave.\r\n \r\n The kitchen is conveniently located nearby and harkens to colorful, classic Puerto Rican cuisine, while equipped with stainless steel and all modern appliances. Connected to the kitchen is the informal dining area and wet bar.\r\n \r\n Float to the elegant formal dining room where a massive floor to ceiling window bathes the space in light. This accent window offers a new vantage point to witness the breath-taking sculpture garden and mosaic fountains outside, making for the most exquisite dining conversation.\r\n \r\n A grand bronze staircase ascends to the second level where you will discover the home’s 3 beds/2 baths, home office, and truly unique Moroccan sitting room.\r\n \r\n The expansive primary suite is a private sanctum of elegance and sophistication. Throw open the French doors to a romantic Juliette balcony overlooking the front garden below. Soak in the jacuzzi tub, an entire spa room apart from the ensuite bathroom for the ultimate in relaxation.\r\n \r\n A distinct walking bridge from the second floor leads to an additional recently remodeled living quarter, which includes 1 bed/1 bath, an office space, and a large area currently serving as an art gallery. \r\n \r\n From this level, ascend the grand outdoor spiral staircase, itself an architectural masterpiece, to view sunsets from the roof, or descend a second spiral staircase to the grounds below. The black bottomed pool, surrounded by mature tropical landscaping, is designed as both a beautiful focal point and for use and enjoyment. \r\n \r\n This entire residence is completely gated for the utmost security, while the driveway leads to an enclosed, private three-car garage. The property is equipped with an automatic Generac-Diesel 30 KLV generator and a 600-gallon water cistern, ensuring uninterrupted convenience.\r\n \r\n This home seamlessly blends contemporary amenities with preserved original elements, situated on one of the largest and most rare lots in Condado. Contact me today. """ +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109905?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "5590000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "1/4 to less than 1/2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_RoomCount": "4" +"MFR_InLawSuiteDescription": "1 Bathroom,1 Bedroom" +"MFR_BuildingAreaTotalSrchSqM": "372.17" +"MFR_GreenVerificationCount": "0" +"MFR_MinimumLease": "1-2 Years" +"MFR_InLawSuiteYN": "1" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ExistLseTenantYN": "0" +"MFR_AvailableForLeaseYN": "1" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-565-8972" +"MFR_SellerRepresentation": "Single Agent" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR740255351')" +"provider_name": "Stellar" +"Media": array:29 [ …29] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2356 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR739382848" +"ListingId": "PR9109677" +"PropertyType": "Residential" +"PropertySubType": "Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-01T14:33:07Z" +"RFModificationTimestamp": "2024-11-01T16:56:47Z" +"ListPrice": 949000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1815.0 +"City": "San Juan" +"PostalCode": "00927" +"UnparsedAddress": "4 Calle Clavel, San Juan, Puerto Rico 00927" +"Coordinates": array:2 [ …2] +"Latitude": 18.38133 +"Longitude": -66.085548 +"YearBuilt": 1991 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Annelise Figueroa Cordero" +"ListOfficeName": "TWO20 GROUP" +"ListAgentMlsId": "743575004" +"ListOfficeMlsId": "743575087" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ - Asking Price: $949,000\r\n - Corner Unit 375m2\r\n - GLA: approx. 1,815 sq.ft\r\n - Private Gate \r\n - 3 Bedrooms (convertible to 4)\r\n - 2.5 Bathrooms\r\n - Poggenpohl Kitchen (fully equipped)\r\n - Living & Dining Area\r\n - Family Room\r\n - Extensive patio \r\n - Laundry Room\r\n - Hi’s & Her’s walk-in closets at Master Bedroom\r\n - Move in ready: furnished or unfurnished \r\n - Full Power Generator\r\n - HOA $149 \r\n - CRIM: TBA \r\n - No neighbors, private gate, fully equipped with A/C, Generator, Curtains, Etc. \r\n - Neighborhood amenities include: controlled access, gazebo, basketball & beach tennis court, playground, dog park, and walking and green areas. """ +"Appliances": array:5 [ …5] +"AssociationFee": "260" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:6 [ …6] +"AssociationName": "Parque Santa Maria" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:5 [ …5] +"ConstructionMaterials": array:3 [ …3] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-10-24T20:26:14.218604+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 337 +"DirectionFaces": "North" +"Directions": """ Luis Munoz Marin International Airport\r\n Airport Rd, Carolina, 00979\r\n \r\n ?\r\n Take Marginal Aeropuerto to Airport Rd\r\n 2 min (1.0 km)\r\n \r\n Head east on Airport Rd\r\n 100 m\r\n \r\n Slight right\r\n 99 m\r\n \r\n Turn right\r\n 400 m\r\n \r\n Sharp right onto Marginal Aeropuerto\r\n 400 m\r\n \r\n ?\r\n Follow Puente Teodoro Moscoso, Av. Jesús T. Piñero/PR-17 and Expreso Las Américas/PR-18 to C. San Alonso in Monacillo Urbano, San Juan. Exit from PR-1 S\r\n 11 min (12.2 km)\r\n \r\n Merge onto Airport Rd\r\n Toll road\r\n 3.2 km\r\n \r\n Continue onto Av. Jesús T. Piñero/PR-17\r\n ?\r\n 4.6 km\r\n \r\n Take the ramp onto Expreso Las Américas/PR-18\r\n ?\r\n 3.7 km\r\n \r\n Exit onto PR-1 S\r\n ?\r\n 500 m\r\n \r\n Take the exit toward C. San Alonso\r\n 180 m\r\n \r\n ?\r\n Take C. Reina de las Flores and C. Orquídea to Calle Begonia\r\n 3 min (1.3 km)\r\n \r\n Continue onto C. San Alonso\r\n 230 m\r\n \r\n Continue onto C. Reina de las Flores\r\n 550 m\r\n \r\n Turn right onto C. Orquídea\r\n 500 m\r\n \r\n Turn right onto Calle Begonia\r\n Destination will be on the left\r\n 88 m\r\n Parque Santa María\r\n C. Clavel, San Juan, 00927 """ +"ExteriorFeatures": array:2 [ …2] +"Flooring": array:1 [ …1] +"FoundationDetails": array:2 [ …2] +"GarageSpaces": "4" +"GarageYN": true +"Heating": array:1 [ …1] +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-235-9922" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530162" +"ListAgentPager": "787-235-9922" +"ListOfficeKey": "507530003" +"ListOfficePhone": "787-366-2221" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-10-23" +"LivingAreaSource": "Owner" +"LotSizeAcres": 0.41 +"LotSizeSquareFeet": 1815 +"MLSAreaMajor": "00927 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2024-10-24" +"OriginalEntryTimestamp": "2024-10-24T18:46:46Z" +"OriginalListPrice": 949000 +"OriginatingSystemKey": "739382848" +"Ownership": "Co-op" +"ParcelNumber": "086-077-198-07" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-10-24T19:41:09Z" +"PhotosCount": 20 +"RoadSurfaceType": array:2 [ …2] +"Roof": array:1 [ …1] +"Sewer": array:2 [ …2] +"ShowingRequirements": array:5 [ …5] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-10-24T18:46:46Z" +"StreetName": "CALLE CLAVEL" +"StreetNumber": "4" +"SubdivisionName": "ROTONDA 106" +"UniversalPropertyId": "US-72127-N-08607719807-R-N" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9109677" +"WaterSource": array:1 [ …1] +"Zoning": "R-1" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530003" +"MFR_LivingAreaMeters": "0.00" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "169" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_MonthlyHOAAmount": "260.00" +"MFR_ListOfficeContactPreferred": "787-235-9922" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109677?w=Customer" +"MFR_AssociationFeeRequirement": "Required" +"MFR_EscrowState": "FL" +"MFR_YrsOfOwnerPriorToLeasingReqYN": "0" +"MFR_AssociationApprovalRequiredYN": "0" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": """ - Asking Price: $949,000\r\n - Corner Unit 375m2\r\n - GLA: approx. 1,815 sq.ft\r\n - Private Gate \r\n - 3 Bedrooms (convertible to 4)\r\n - 2.5 Bathrooms\r\n - Poggenpohl Kitchen (fully equipped)\r\n - Living & Dining Area\r\n - Family Room\r\n - Extensive patio \r\n - Laundry Room\r\n - Hi’s & Her’s walk-in closets at Master Bedroom\r\n - Move in ready: furnished or unfurnished \r\n - Full Power Generator\r\n - HOA $149 \r\n - CRIM: TBA \r\n - No neighbors, private gate, fully equipped with A/C, Generator, Curtains, Etc. \r\n - Neighborhood amenities include: controlled access, gazebo, basketball & beach tennis court, playground, dog park, and walking and green areas. """ +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109677?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "949000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "1/4 to less than 1/2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "3120.00" +"MFR_RoomCount": "4" +"MFR_BuildingAreaTotalSrchSqM": "168.62" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "260.00" +"MFR_ExistLseTenantYN": "0" +"MFR_BuildingNameNumber": "L6" +"MFR_AvailableForLeaseYN": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-235-9922" +"MFR_SellerRepresentation": "Single Agent" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR739382848')" +"provider_name": "Stellar" +"Media": array:20 [ …20] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2357 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR737741488" +"ListingId": "PR9109167" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-10-01T05:01:13Z" +"RFModificationTimestamp": "2024-10-01T05:24:31Z" +"ListPrice": 4500000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "San Juan" +"PostalCode": "00918" +"UnparsedAddress": "#541-#559 Sergio Cuevas Bustamente, Hato Rey Ward" +"Coordinates": array:2 [ …2] +"Latitude": 18.4119214 +"Longitude": -66.0679947 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Milton Serrano Lebron" +"ListOfficeName": "REALITY REALTY" +"ListAgentMlsId": "741502978" +"ListOfficeMlsId": "742000096" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Land available in Hato Rey with a privileged location, right next to the Hospital del Maestro, the La Merced Dev., the Las Americas Expressway and Manuel Domenech Ave. It has an area of approx.4,549 sm, divided into 12 lots of approx. 400sm each, with a mostly rectangular configuration and a wide front. It is currently used as a parking lot with 135 spaces. This space is ideal for developing an urban, residential or mixed-use project. The area is characterized by a high population density and a dynamic mix of uses. Nearby there are residences, multi-family buildings, medical and health service offices, condominiums, senior living, restaurants and passive parks. This diversity contributes to the vitality and attractiveness of the area. The land is zoned R-4, which offers various development possibilities, although some potential uses could require a zoning change. This is an excellent investment opportunity in one of the few available lands of this type in Hato Rey." +"AdditionalParcelsDescription": "062-080-831-25-000" +"AdditionalParcelsYN": true +"BuildingAreaUnits": "Square Feet" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-09-30T14:53:30.184571+00:00" +"CurrentUse": array:1 [ …1] +"Directions": "Take PR-18, Las Americas Expressway, towards Hato Rey (towards the South if coming from Old San Juan or Santurce; North if coming from Caguas or Guaynabo). Take the Manuel Domenech Ave. exit towards the East, and immediately turn right on Juan José Jimenez St. Turn left on Sergio Cuevas Bustamante St, the land is on the right-hand side, beginning in the corner and up to #538-B of the same street. The land also includes adjacent lots #570 and #572 on Hermogenes Alverio St. Continue to Manuel Domenech Ave. from Sergio Cuevas Bustamante St, turn right and immediately turn right on Hermogenes Alverio St, up to #570 and #572. These are adjoining on the back with the rest of the land." +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-444-6583" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530077" +"ListAgentPager": "787-444-6583" +"ListOfficeKey": "507529944" +"ListOfficePhone": "787-745-8777" +"ListOfficeURL": "http://www.realityrealtypr.com" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-09-26" +"LotSizeAcres": 1.12 +"LotSizeDimensions": "4549" +"LotSizeSquareFeet": 48947 +"MLSAreaMajor": "00918 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfLots": "12" +"OnMarketDate": "2024-09-30" +"OriginalEntryTimestamp": "2024-09-30T14:44:35Z" +"OriginalListPrice": 4500000 +"OriginatingSystemKey": "737741488" +"Ownership": "Other" +"ParcelNumber": "062-080-831-26-000" +"PhotosChangeTimestamp": "2024-09-30T14:47:07Z" +"PhotosCount": 9 +"RoadSurfaceType": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-09-30T14:44:35Z" +"StreetName": "SERGIO CUEVAS BUSTAMENTE, HATO REY WARD" +"StreetNumber": "#541-#559" +"UniversalPropertyId": "US-72127-N-06208083126000-R-N" +"Utilities": array:3 [ …3] +"WaterSource": array:1 [ …1] +"Zoning": "R-4" +"MFR_FrontFootage": "33" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507529944" +"MFR_LotSizeSquareMeters": "4547" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "787-745-8777" +"MFR_PricePerAcre": "4017857" +"MFR_CalculatedListPriceByCalculatedSqFt": "91.94" +"MFR_WaterAccessYN": "0" +"MFR_EscrowState": "PR" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "91.94" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Land available in Hato Rey with a privileged location, right next to the Hospital del Maestro, the La Merced Dev., the Las Americas Expressway and Manuel Domenech Ave. It has an area of approx.4,549 sm, divided into 12 lots of approx. 400sm each, with a mostly rectangular configuration and a wide front. It is currently used as a parking lot with 135 spaces. This space is ideal for developing an urban, residential or mixed-use project. The area is characterized by a high population density and a dynamic mix of uses. Nearby there are residences, multi-family buildings, medical and health service offices, condominiums, senior living, restaurants and passive parks. This diversity contributes to the vitality and attractiveness of the area. The land is zoned R-4, which offers various development possibilities, although some potential uses could require a zoning change. This is an excellent investment opportunity in one of the few available lands of this type in Hato Rey." +"MFR_CurrentPrice": "4500000.00" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "A" +"MFR_TotalAcreage": "1 to less than 2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "See Remarks" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ForLeaseYN": "0" +"MFR_PublicRemarksAgentSpanish": "Terreno disponible en Hato Rey con una ubicación privilegiada, justo al lado del Hospital del Maestro, la Urb. La Merced, el Expreso Las Américas y la Ave. Manuel Domenech. Cuenta con una extensión de aprox. 4,549m2, dividido en 12 lotes de aprox. 400 m2 cada uno, con una configuración mayormente rectangular y con un amplio frente. Actualmente se utiliza como estacionamiento y cuenta con 135 espacios. Este espacio es ideal para desarrollar un proyecto urbano, residencial o de uso mixto. La zona se caracteriza en ser una alta densidad poblacional y una mezcla dinámica de usos. En las cercanías se encuentran residencias, edificios multifamiliares, oficinas médicas y de servicios de salud, condominios, égidas, restaurantes y parques pasivos. Esta diversidad contribuye a la vitalidad y el atractivo del área. El terreno está zonificado como R-4, lo que ofrece diversas posibilidades de desarrollo, aunque algunos usos potenciales podrían requerir un cambio de zonificación. Esta es una excelente oportunidad de inversión en uno de los pocos terrenos disponibles de este tipo en Hato Rey." +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-745-8777" +"MFR_SellerRepresentation": "Single Agent" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR737741488')" +"provider_name": "Stellar" +"Media": array:9 [ …9] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2358 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR703877609" +"ListingId": "PR9102424" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-09-23T15:28:07Z" +"RFModificationTimestamp": "2024-09-24T12:43:19Z" +"ListPrice": 1744920.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 58164.0 +"City": "San Juan" +"PostalCode": "00927" +"UnparsedAddress": "280 Jesus T Piñero Avenue, San Juan, Florida 00927" +"Coordinates": array:2 [ …2] +"Latitude": 18.40732 +"Longitude": -66.06497 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Annelise Figueroa Cordero" +"ListOfficeName": "TWO20 GROUP" +"ListAgentMlsId": "743575004" +"ListOfficeMlsId": "743575087" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ - Base rent: $18.50/RSF\r\n - OPEX: $11.50\r\n - Total rent: $30.00/RSF\r\n - Up to 58,164 RSF available\r\n - Spaces may be sub-divided to tenant’s need\r\n - Rent includes utilities (electricity & water)\r\n - On-site parking available\r\n - Parking ratio: 4:1,000\r\n - 50% Interior at $75 per space, per month\r\n - 50% Exterior at $65 per space, per month\r\n - 1;1,000 SF free of charge while rent is current\r\n - Capacity for 354 vehicles\r\n - Visitors parking available\r\n - Fiber optic infrastructure\r\n - Central chilled A/C\r\n - After-Hours billed at $150 per hour\u{A0}\u{A0}\u{A0}\u{A0}\u{A0}\r\n - 24/7 Surveillance security & controlled access\r\n - 2 High speed elevators\r\n - Full capacity power generator (1.5KW and 5,000gal Tank)\r\n - Emergency water cisterns (130,000gal & 96,000gal for fire)\r\n - Maintenance and\u{A0}janitorial services\u{A0}within suite are\u{A0}available for $2/SF\r\n - Centralized fire, alarm, and sprinkler systems\r\n - Entrance vestibules from rear parking\r\n - Tenant improvements may be performed by landlord, to be negotiated based on lease term\r\n - Built in 2014 """ +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2023-10-09T16:41:42.083082+00:00" +"CumulativeDaysOnMarket": 350 +"DaysOnMarket": 718 +"Directions": """ PRI-1\r\n Dirígete al sureste por Expreso Las Américas/PR-18.\r\n \r\n 2.1 km\r\n Toma la salida 3B hacia Puerto Rico 17, en dirección a Río Piedras/Carolina/Trujillo Alto\r\n \r\n 290 metros\r\n Incorpórate a Av. Jesús T. Piñero/PR-17\r\n El destino está a la izquierda.\r\n \r\n 550 metros\r\n Has llegado a 280 Av. Jesús T. Piñero (Oriental) """ +"FoundationDetails": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeasableArea": 58164 +"LeaseAmountFrequency": "Annually" +"LeaseTerm": "Three to Five Years" +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-235-9922" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530162" +"ListAgentPager": "787-235-9922" +"ListOfficeKey": "507530003" +"ListOfficePhone": "787-235-9922" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2023-10-04" +"LotSizeAcres": 2 +"LotSizeSquareFeet": 100046 +"MLSAreaMajor": "00927 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2023-10-09" +"OriginalEntryTimestamp": "2023-10-09T16:35:17Z" +"OriginalListPrice": 1744920 +"OriginatingSystemKey": "703877609" +"OwnerPays": array:2 [ …2] +"ParcelNumber": "06308139031" +"PhotosChangeTimestamp": "2024-05-06T22:18:11Z" +"PhotosCount": 47 +"RoadFrontageType": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"ShowingRequirements": array:4 [ …4] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2023-10-09T16:35:17Z" +"StreetName": "JESUS T PIÑERO" +"StreetNumber": "280" +"StreetSuffix": "AVENUE" +"SubdivisionName": "ORIENTAL PLAZA" +"TenantPays": array:2 [ …2] +"UniversalPropertyId": "US-72127-N-06308139031-R-N" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9102424" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530003" +"MFR_LeasePrice": "30.00" +"MFR_LotSizeSquareMeters": "9295" +"MFR_WaterViewYN": "0" +"MFR_TermsOfLease": "Absolute (Triple) Net" +"MFR_ListOfficeContactPreferred": "787-235-9922" +"MFR_CalculatedListPriceByCalculatedSqFt": "30.00" +"MFR_WaterAccessYN": "0" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "0.00" +"MFR_WaterExtrasYN": "0" +"MFR_PublicRemarksAgent": """ - Base rent: $18.50/RSF\r\n - OPEX: $11.50\r\n - Total rent: $30.00/RSF\r\n - Up to 58,164 RSF available\r\n - Spaces may be sub-divided to tenant’s need\r\n - Rent includes utilities (electricity & water)\r\n - On-site parking available\r\n - Parking ratio: 4:1,000\r\n - 50% Interior at $75 per space, per month\r\n - 50% Exterior at $65 per space, per month\r\n - 1;1,000 SF free of charge while rent is current\r\n - Capacity for 354 vehicles\r\n - Visitors parking available\r\n - Fiber optic infrastructure\r\n - Central chilled A/C\r\n - After-Hours billed at $150 per hour\u{A0}\u{A0}\u{A0}\u{A0}\u{A0}\r\n - 24/7 Surveillance security & controlled access\r\n - 2 High speed elevators\r\n - Full capacity power generator (1.5KW and 5,000gal Tank)\r\n - Emergency water cisterns (130,000gal & 96,000gal for fire)\r\n - Maintenance and\u{A0}janitorial services\u{A0}within suite are\u{A0}available for $2/SF\r\n - Centralized fire, alarm, and sprinkler systems\r\n - Entrance vestibules from rear parking\r\n - Tenant improvements may be performed by landlord, to be negotiated based on lease term\r\n - Built in 2014 """ +"MFR_CurrentPrice": "30.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_LeasePricePerSqFt": "30.00" +"MFR_TotalNumBuildings": "1" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "2 to less than 5" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_BuildingAreaTotalSrchSqM": "5403.61" +"MFR_TotalMonthlyFees": "0.00" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-235-9922" +"MFR_LeasePriceUnit": "Per SqFt" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR703877609')" +"provider_name": "Stellar" +"Media": array:47 [ …47] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2359 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR736622965" +"ListingId": "PR9108833" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-09-14T10:49:38Z" +"RFModificationTimestamp": "2024-09-14T11:04:45Z" +"ListPrice": 2150000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2700.0 +"BuildingAreaTotal": 2700.0 +"City": "San Juan" +"PostalCode": "00907" +"UnparsedAddress": "555 C. Monserrate #5, San Juan, Puerto Rico 00907" +"Coordinates": array:2 [ …2] +"Latitude": 18.453707 +"Longitude": -66.077889 +"YearBuilt": 2010 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Javi Rodriguez" +"ListOfficeName": "MICORREDOR.COM" +"ListAgentMlsId": "743520489" +"ListOfficeMlsId": "743574901" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "This luxurious condominium is located on the 5th floor of the Cosmopolitan Condominium. The property has 3 spacious bedrooms and 3.5 luxurious bathrooms, totaling 2,700 sqft of living space. The condominium also comes with 3 parking spaces and access to a beautiful pool ." +"Appliances": array:4 [ …4] +"AssociationFee": "700" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "Javier Rodríguez" +"AssociationYN": true +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaSource": "Appraiser" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-09-14T02:53:54.196285+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 378 +"DirectionFaces": "North" +"Directions": "Cosmopolitan in Condado in front of the lagoon" +"ExteriorFeatures": array:2 [ …2] +"Flooring": array:1 [ …1] +"FoundationDetails": array:2 [ …2] +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:1 [ …1] +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-717-0187" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530134" +"ListAgentURL": "http://www.MiCorredor.com" +"ListOfficeKey": "507529985" +"ListOfficePhone": "787-717-0187" +"ListOfficeURL": "http://www.MiCorredor.com" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-09-13" +"LivingAreaSource": "Appraiser" +"LotSizeSquareFeet": 2700 +"MLSAreaMajor": "00907 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2024-09-13" +"OriginalEntryTimestamp": "2024-09-13T22:08:47Z" +"OriginalListPrice": 2150000 +"OriginatingSystemKey": "736622965" +"Ownership": "Condominium" +"ParcelNumber": "47291793082711" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-09-13T22:11:07Z" +"PhotosCount": 31 +"RoadSurfaceType": array:2 [ …2] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-09-13T22:08:47Z" +"StoriesTotal": "20" +"StreetName": "C. MONSERRATE" +"StreetNumber": "555" +"SubdivisionName": "COSMOPOLITAN" +"UnitNumber": "5" +"UniversalPropertyId": "US-72127-N-47291793082711-S-5" +"Utilities": array:6 [ …6] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9108833" +"WaterSource": array:1 [ …1] +"Zoning": "R2" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507529985" +"MFR_LivingAreaMeters": "250.84" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "251" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_MonthlyHOAAmount": "700.00" +"MFR_CondoLandIncludedYN": "0" +"MFR_ListOfficeContactPreferred": "787-717-0187" +"MFR_CondoFees": "0" +"MFR_CalculatedListPriceByCalculatedSqFt": "796.30" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9108833?w=Customer" +"MFR_AssociationFeeRequirement": "Required" +"MFR_EscrowState": "FL" +"MFR_YrsOfOwnerPriorToLeasingReqYN": "0" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "796.30" +"MFR_AssociationApprovalRequiredYN": "0" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "This luxurious condominium is located on the 5th floor of the Cosmopolitan Condominium. The property has 3 spacious bedrooms and 3.5 luxurious bathrooms, totaling 2,700 sqft of living space. The condominium also comes with 3 parking spaces and access to a beautiful pool ." +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9108833?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "2150000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "na" +"MFR_TotalAcreage": "Non-Applicable" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "8400.00" +"MFR_RoomCount": "3" +"MFR_BuildingElevatorYN": "1" +"MFR_BuildingAreaTotalSrchSqM": "250.84" +"MFR_GreenVerificationCount": "1" +"MFR_MinimumLease": "No Minimum" +"MFR_FloorNumber": "5" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "700.00" +"MFR_ExistLseTenantYN": "0" +"MFR_BuildingNameNumber": "COSMOPOLITAN" +"MFR_MaxPetWeight": "75" +"MFR_AvailableForLeaseYN": "1" +"MFR_MontlyMaintAmtAdditionToHOA": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-717-0187" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR736622965')" +"provider_name": "Stellar" +"Media": array:31 [ …31] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2360 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR715503967" +"ListingId": "PR9104791" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-06-25T23:41:07Z" +"RFModificationTimestamp": "2024-06-26T01:36:02Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 4000.0 +"BuildingAreaTotal": 4000.0 +"City": "San Juan" +"PostalCode": "00927" +"UnparsedAddress": "1928 Petunia, San Juan, Florida 00927" +"Coordinates": array:2 [ …2] +"Latitude": 18.37235609 +"Longitude": -66.08604683 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Andres Rivera" +"ListOfficeName": "EXP PUERTO RICO LLC" +"ListAgentMlsId": "743524010" +"ListOfficeMlsId": "742000999" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Luxury awaits in the prestigious neighbourhood of Santa Maria. This home, featuring 9-foot-high ceilings and marbled floors, offers refined elegance and comfort. Enjoy spacious living areas with a swimming pool and a grand terrace. With four bedrooms, including a primary suite boasting a walk-in closet and balcony, every comfort is assured. Three full bathrooms, a 15KW electric generator, and a solar water heater add practicality. Less than half a mile away from top-rated schools, this residence epitomizes sophisticated living in a coveted locale. Don't miss the chance to call this exclusive property yours." +"Appliances": array:4 [ …4] +"AssociationAmenities": array:5 [ …5] +"AssociationFee": "288" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ …2] +"AssociationName": "UNDARE" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "3" +"CommunityFeatures": array:4 [ …4] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-02-23T18:58:12.250378+00:00" +"CumulativeDaysOnMarket": 123 +"DaysOnMarket": 580 +"DirectionFaces": "Southeast" +"Directions": """ Take Expreso Las Américas/PR-18 to C. Reina de las Flores in Monacillo Urbano, Head south on Expreso Las Américas/PR-18,Exit onto PR-1 S, Take Av. Lomas Verdes/PR-177 to Cll Petunia, Keep right to continue on C. Reina de las Flores\r\n 75 m,Slight right to merge onto Av. Lomas Verdes/PR-177,950 m Turn right onto Calle Romerillo\r\n 10 m\r\n Turn right to stay on Calle Romerillo\r\n 170 m\r\n Turn left onto Cll Petunia """ +"ExteriorFeatures": array:8 [ …8] +"Fencing": array:1 [ …1] +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"InteriorFeatures": array:7 [ …7] +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-938-7178" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "714203062" +"ListOfficeKey": "554496465" +"ListOfficePhone": "939-697-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-02-21" +"ListingTerms": array:2 [ …2] +"LivingAreaSource": "Owner" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 0.21 +"LotSizeSquareFeet": 9149 +"MLSAreaMajor": "00927 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2024-02-23" +"OriginalEntryTimestamp": "2024-02-23T17:55:31Z" +"OriginalListPrice": 1375000 +"OriginatingSystemKey": "715503967" +"OtherStructures": array:1 [ …1] +"Ownership": "Fee Simple" +"ParcelNumber": "114-007-042-10" +"ParkingFeatures": array:4 [ …4] +"PetsAllowed": array:3 [ …3] +"PhotosChangeTimestamp": "2024-02-23T17:57:09Z" +"PhotosCount": 20 +"PoolFeatures": array:3 [ …3] +"PoolPrivateYN": true +"PreviousListPrice": 1375000 +"PriceChangeTimestamp": "2024-06-25T23:41:04Z" +"PropertyCondition": array:1 [ …1] +"RoadSurfaceType": array:2 [ …2] +"Roof": array:1 [ …1] +"SecurityFeatures": array:4 [ …4] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-02-23T17:55:31Z" +"StreetName": "PETUNIA 1928" +"StreetNumber": "Urb. Santa María" +"SubdivisionName": "URB. SANTA MARIA" +"TransactionBrokerCompensation": "0%" +"UniversalPropertyId": "US-72127-N-11400704210-R-N" +"Utilities": array:11 [ …11] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9104791" +"WaterSource": array:1 [ …1] +"Zoning": "R-1" +"MFR_ListOfficeHeadOfficeKeyNumeric": "554496465" +"MFR_LivingAreaMeters": "371.61" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "850" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_MonthlyHOAAmount": "288.00" +"MFR_ListOfficeContactPreferred": "787-455-6501" +"MFR_CalculatedListPriceByCalculatedSqFt": "312.50" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9104791?w=Customer" +"MFR_AssociationFeeRequirement": "Required" +"MFR_EscrowState": "FL" +"MFR_YrsOfOwnerPriorToLeasingReqYN": "0" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "312.50" +"MFR_AssociationApprovalRequiredYN": "0" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Luxury awaits in the prestigious neighbourhood of Santa Maria. This home, featuring 9-foot-high ceilings and marbled floors, offers refined elegance and comfort. Enjoy spacious living areas with a swimming pool and a grand terrace. With four bedrooms, including a primary suite boasting a walk-in closet and balcony, every comfort is assured. Three full bathrooms, a 15KW electric generator, and a solar water heater add practicality. Less than half a mile away from top-rated schools, this residence epitomizes sophisticated living in a coveted locale. Don't miss the chance to call this exclusive property yours." +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9104791?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "1250000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_PropertyDescription": "Corner Unit" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "0 to less than 1/4" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "3456.00" +"MFR_ShowingConsiderations": "No Heat" +"MFR_RoomCount": "13" +"MFR_BuildingAreaTotalSrchSqM": "371.61" +"MFR_GreenVerificationCount": "0" +"MFR_MinimumLease": "8-12 Months" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "288.00" +"MFR_ExistLseTenantYN": "0" +"MFR_AvailableForLeaseYN": "1" +"MFR_PublicRemarksAgentSpanish": "¡El lujo te espera en la prestigiosa urbanización de Santa María! Esta casa, con techos de 9 pies de altura y suelos de mármol, ofrece elegancia y comodidad. Disfruta de amplias áreas de estar con una piscina y una gran terraza. Con cuatro dormitorios, incluida una suite principal con “walk-in closet” y balcón, que garantiza comodidad. Tres baños completos, un generador eléctrico de 15KW y un calentador de agua solar añaden practicidad. A menos de media milla de buenas escuelas, esta residencia ejemplifica una vida sofisticada en una ubicación codiciada. ¡No pierdas la oportunidad de llamar a esta exclusiva propiedad tuya!" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-455-6501" +"MFR_DockYN": "0" +"MFR_NonRepCompensation": "3" +"Media": array:20 [ …20] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR715503967')" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2361 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR728303179" +"ListingId": "PR9106738" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-06-10T21:54:07Z" +"RFModificationTimestamp": "2024-06-11T05:44:29Z" +"ListPrice": 4875000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 2 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 6489.0 +"BuildingAreaTotal": 6489.0 +"City": "San Juan" +"PostalCode": "00907" +"UnparsedAddress": "1365 Wilson Avenue, Haven The Residences East" +"Coordinates": array:2 [ …2] +"Latitude": 18.45278432 +"Longitude": -66.06816532 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "ORIANA JUVELIER" +"ListOfficeName": "PUERTO RICO SOTHEBY'S INTL. REALTY" +"ListAgentMlsId": "743575310" +"ListOfficeMlsId": "743580117" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Pre-Construction. To be built. Elevate your lifestyle with luxurious comfort at Haven the Residences, a brand new construction encompassing only two exclusive homes within the heart of Condado Beach. Spacious interiors/exteriors that afford a total of 6,489 Sq. Ft. and showcase the finest contemporary finishes to create an ambiance of refined elegance. Whether you’re unwinding by the pool on your private terrace with full summer kitchen or hosting gatherings in the expansive double-height great room, every corner exudes unparalleled tranquility. A private elevator, built-in features for smart home automation and an exquisite selection of bespoke materials accent this 3-level residence with 4 bedrooms, 5 bathrooms, and 2 powder rooms. Fully equipped for your culinary endeavors, the beautifully appointed Poliform kitchen features top-of-the-line appliances and butler’s pantry. The media room is the perfect setting for leisure and immersive entertainment. A study and flex gym provide additional options for wellness-focused recreational activities. The oversized primary suite is a spa-inspired sanctuary with a private balcony and a walk-in closet that connects to the luxe primary bath. All three tastefully designed guest bedrooms are also ensuite with custom walk-in closets, exhibiting true attention to detail. A dedicated laundry area and separate wet bar located on the third level complete this unprecedented offering. Inclusive of a full-power generator, water cistern and 3-car garage. Situated in one of the best residential walkable districts, Condado Beach, Haven The Residences offers all of the amenities of metropolitan living, within a beach setting. * The first seven images are renderings and do not reflect the current state of the property." +"Appliances": array:4 [ …4] +"AssociationFeeIncludes": array:1 [ …1] +"AttachedGarageYN": true +"BathroomsFull": 5 +"BuildingAreaSource": "Builder" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "3%" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-06-06T00:46:58.697845+00:00" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 477 +"DirectionFaces": "Southwest" +"Directions": "Head southwest on Ave. Jose de Diego/PR-37, turn right onto Estrella Street. and right onto Washington Street. Turn left at the 1st cross street onto Ave. Wilson. Destination will be on the right." +"ExteriorFeatures": array:3 [ …3] +"Flooring": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:1 [ …1] +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-523-6500" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530208" +"ListOfficeKey": "507530044" +"ListOfficePhone": "787-523-6500" +"ListOfficeURL": "http://puertoricosothebysrealty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-05" +"LivingAreaSource": "Builder" +"MLSAreaMajor": "00907 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NewConstructionYN": true +"OccupantType": "Vacant" +"OnMarketDate": "2024-06-05" +"OriginalEntryTimestamp": "2024-06-05T19:30:25Z" +"OriginalListPrice": 4875000 +"OriginatingSystemKey": "728303179" +"Ownership": "Condominium" +"ParcelNumber": "040-050-042-12-901-02" +"PhotosChangeTimestamp": "2024-06-07T15:23:08Z" +"PhotosCount": 10 +"PoolFeatures": array:1 [ …1] +"PoolPrivateYN": true +"PropertyCondition": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SpaFeatures": array:1 [ …1] +"SpaYN": true +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-06-05T19:30:25Z" +"StoriesTotal": "3" +"StreetName": "WILSON AVENUE EAST, HAVEN THE RESIDENCES" +"StreetNumber": "1365" +"SubdivisionName": "CONDADO" +"TransactionBrokerCompensation": "0%" +"UniversalPropertyId": "US-72127-N-0400500421290102-R-N" +"Utilities": array:3 [ …3] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9106738" +"WaterSource": array:1 [ …1] +"Zoning": "X" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530044" +"MFR_LivingAreaMeters": "602.85" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_CondoLandIncludedYN": "0" +"MFR_ListOfficeContactPreferred": "787-523-6500" +"MFR_CondoFees": "0" +"MFR_CalculatedListPriceByCalculatedSqFt": "751.27" +"MFR_WaterAccessYN": "0" +"MFR_ProjectedCompletionDate": "2025-12-31T00:00:00.000" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9106738?w=Customer" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "751.27" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Elevate your lifestyle with luxurious comfort at Haven the Residences, a brand new construction encompassing only two exclusive homes within the heart of Condado Beach. Spacious interiors/exteriors that afford a total of 6,489 Sq. Ft. and showcase the finest contemporary finishes to create an ambiance of refined elegance. Whether you’re unwinding by the pool on your private terrace with full summer kitchen or hosting gatherings in the expansive double-height great room, every corner exudes unparalleled tranquility. A private elevator, built-in features for smart home automation and an exquisite selection of bespoke materials accent this 3-level residence with 4 bedrooms, 5 bathrooms, and 2 powder rooms. Fully equipped for your culinary endeavors, the beautifully appointed Poliform kitchen features top-of-the-line appliances and butler’s pantry. The media room is the perfect setting for leisure and immersive entertainment. A study and flex gym provide additional options for wellness-focused recreational activities. The oversized primary suite is a spa-inspired sanctuary with a private balcony and a walk-in closet that connects to the luxe primary bath. All three tastefully designed guest bedrooms are also ensuite with custom walk-in closets, exhibiting true attention to detail. A dedicated laundry area and separate wet bar located on the third level complete this unprecedented offering. Inclusive of a full-power generator, water cistern and 3-car garage. Situated in one of the best residential walkable districts, Condado Beach, Haven The Residences offers all of the amenities of metropolitan living, within a beach setting. * The first seven images are renderings and do not reflect the current state of the property." +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9106738?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "4875000.00" +"MFR_UnitNumberYN": "1" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "To Be Built" +"MFR_RoomCount": "3" +"MFR_BuildingElevatorYN": "1" +"MFR_BuildingAreaTotalSrchSqM": "602.85" +"MFR_GreenVerificationCount": "0" +"MFR_FloorNumber": "1" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ExistLseTenantYN": "0" +"MFR_BuildingNameNumber": "HAVEN THE RESIDENCES" +"MFR_AvailableForLeaseYN": "0" +"MFR_MontlyMaintAmtAdditionToHOA": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-523-6500" +"MFR_NonRepCompensation": "3%" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR728303179')" +"provider_name": "Stellar" +"Media": array:10 [ …10] } ] +success: true +page_size: 9 +page_count: 47 +count: 423 +after_key: "" } ] "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=396&$filter=((StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential', 'Residential Income', 'Land', 'Business Opportunity', 'Commercial Sale') and ListPrice ge 300000) OR ( StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential Lease', 'Commercial Lease' ) and ListPrice ge 3000)) and City eq 'San Juan'&$feature=ListAgentMlsId in ('743575075','')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=396&$filter=((StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential', 'Residential Income', 'Land', 'Business Opportunity', 'Commercial Sale') and ListPrice ge 300000) OR ( StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential Lease', 'Commercial Lease' ) and ListPrice ge 3000)) and City eq 'San Juan'&$feature=ListAgentMlsId in ('743575075','')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=396&$filter=((StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential', 'Residential Income', 'Land', 'Business Opportunity', 'Commercial Sale') and ListPrice ge 300000) OR ( StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential Lease', 'Commercial Lease' ) and ListPrice ge 3000)) and City eq 'San Juan'&$feature=ListAgentMlsId in ('743575075','')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=396&$filter=((StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential', 'Residential Income', 'Land', 'Business Opportunity', 'Commercial Sale') and ListPrice ge 300000) OR ( StandardStatus eq 'Active' and StateOrProvince eq 'PR' and PropertyType in ('Residential Lease', 'Commercial Lease' ) and ListPrice ge 3000)) and City eq 'San Juan'&$feature=ListAgentMlsId in ('743575075','')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3827 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3822 +post_id: "486169" +post_author: 1 +"ListingKey": "MFR722276845" +"ListingId": "PR9105585" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-23T14:10:08Z" +"RFModificationTimestamp": "2024-12-23T14:11:49Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "San Juan" +"PostalCode": "00926" +"UnparsedAddress": "Camino Entrada Al Lago, San Juan, Puerto Rico 00926" +"Coordinates": array:2 [ …2] +"Latitude": 18.360405 +"Longitude": -66.077994 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "MAYTE SOTOMAYOR ALONSO" +"ListOfficeName": "MARES - MANAGEMENT REALTY EXPERT" +"ListAgentMlsId": "743575213" +"ListOfficeMlsId": "743580036" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "14 cords, 1 office and three houses, various structures and small squares, 5 electricity meters, fruit trees. Septic tank. Used for Cannabis farm/planting. Horse farm, zipline" +"BuildingAreaUnits": "Square Feet" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-04-06T04:07:53.872487+00:00" +"CumulativeDaysOnMarket": 262 +"CurrentUse": array:1 [ …1] +"DaysOnMarket": 539 +"Directions": """ Tome PR-21, Expreso Las Américas/PR-18, PR-52, Avenida Las Cumbres/PR-199 y PR-176 hasta Cam. Los Andinos en Cupey15 min (9.9 km)Continuar por Cam. Los andinos. Conduzca hasta el Paseo Las Curias.\r\n \r\n \r\n \r\n Take PR-21, Expreso Las Américas/PR-18, PR-52, Las Cumbres Ave/PR-199 and PR-176 to Cam. Los Andinos in Cupey15 min (9.9 km)Continue on Cam. The Andeans. Drive to Paseo Las Curias """ +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-782-4444" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530176" +"ListAgentPager": "787-782-4444" +"ListAgentURL": "http://[email protected]" +"ListOfficeKey": "507530016" +"ListOfficePhone": "939-287-7097" +"ListOfficeURL": "http://[email protected]" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-04-05" +"LotSizeAcres": 13.6 +"LotSizeDimensions": "55.026 mts2" +"LotSizeSquareFeet": 592295 +"MLSAreaMajor": "00926 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2024-04-05" +"OriginalEntryTimestamp": "2024-04-05T19:10:20Z" +"OriginalListPrice": 1100000 +"OriginatingSystemKey": "722276845" +"Ownership": "Fee Simple" +"ParcelNumber": "115-000-006-38-901" +"PhotosChangeTimestamp": "2024-04-05T20:22:08Z" +"PhotosCount": 83 +"RoadSurfaceType": array:1 [ …1] +"Sewer": "Public Sewer" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-04-05T19:10:20Z" +"StreetName": "CAMINO ENTRADA AL LAGO" +"UniversalPropertyId": "US-72127-N-11500000638901-R-N" +"Utilities": "Water Available" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9105585" +"WaterSource": array:2 [ …2] +"Zoning": "R1" +"MFR_FrontFootage": "296148" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530016" +"MFR_LotSizeSquareMeters": "55026" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "939-287-7097" +"MFR_PricePerAcre": "80882" +"MFR_CalculatedListPriceByCalculatedSqFt": "1.86" +"MFR_WaterAccessYN": "0" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "1.86" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "14 cords, 1 office and three houses, various structures and small squares, 5 electricity meters, fruit trees. Septic tank. Used for Cannabis farm/planting. Horse farm, zipline" +"MFR_CurrentPrice": "1100000.00" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "x" +"MFR_TotalAcreage": "10 to less than 20" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "See Remarks" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ForLeaseYN": "0" +"MFR_PublicRemarksAgentSpanish": "14 cuerdas, 1 oficina y tres casas varias estructuras y plazoletas, 5 contadores de luz, arboles frutales . Pozo septico. Sirve para finca de Cannabis/ siembra . Finca de caballos, zipline" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "939-287-7097" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR722276845')" +"provider_name": "Stellar" +"Media": array:83 [ …83] +"ID": "486169" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3824 +post_id: "486101" +post_author: 1 +"ListingKey": "MFR714193587" +"ListingId": "PR9104448" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T13:28:07Z" +"RFModificationTimestamp": "2024-12-16T13:32:38Z" +"ListPrice": 1600000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "San Juan" +"PostalCode": "00907" +"UnparsedAddress": "631 Fernandez Juncos Avenue, San Juan, Florida 00907" +"Coordinates": array:2 [ …2] +"Latitude": 18.4543848 +"Longitude": -66.08726761 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brenda Nieves" +"ListOfficeName": "PUERTO RICO SOTHEBY'S INTL. REALTY" +"ListAgentMlsId": "743575381" +"ListOfficeMlsId": "743580117" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Situated within close proximity to the Convention District Area, entertainment venues, restaurants, and cultural attractions, this prime location offers unparalleled visibility and foot traffic. This lot presents an exceptional opportunity for commercial development with lucrative tourist potential. Visitors and locals alike frequent this area, making it an ideal destination for a wide range of commercial ventures. With easy access to major transportation hubs and thoroughfares, including highways and public transit systems. In summary, this empty lot offers a rare chance to capitalize on the city's dynamic energy and vibrant culture. With its unbeatable location, accessibility, and commercial potential, it's the perfect canvas for creating a landmark destination that will leave a lasting impression on visitors and locals alike. Zoning: CT-2. The Miramar Arts District offers a captivating blend of historic charm, modern sophistication, and natural beauty. Rich in history and culture, Miramar is home to a diverse array of art galleries, museums, and cultural institutions. From the iconic Puerto Rico Convention Center and Distrito TMobile entertainment complex to its historic landmarks. Miramar is a culinary hotspot, with a wide variety of restaurants, cafes, and eateries offering everything from traditional Puerto Rican cuisine to international fare. The area also boasts a vibrant nightlife scene, with trendy bars, lounges, and entertainment venues catering to every taste." +"BuildingAreaUnits": "Square Feet" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-02-06T23:03:28.877295+00:00" +"CumulativeDaysOnMarket": 314 +"CurrentUse": array:1 [ …1] +"DaysOnMarket": 598 +"Directions": "Head southeast on Av. Manuel Fernandez Juncos/PR-35 toward C. Union. Turn left at the 1st cross street onto C. Union. Turn left onto C. Roosevelt. Turn left onto Av. Miramar. Turn right at the 1st cross street onto Av. Manuel Fernández Juncos/PR-35. Destination will be on the right." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-523-6500" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507791183" +"ListOfficeKey": "507530044" +"ListOfficePhone": "787-523-6500" +"ListOfficeURL": "http://puertoricosothebysrealty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-02-06" +"LotSizeAcres": 0.44 +"LotSizeDimensions": "228 x 139" +"LotSizeSquareFeet": 19176 +"MLSAreaMajor": "00907 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2024-02-06" +"OriginalEntryTimestamp": "2024-02-06T20:55:44Z" +"OriginalListPrice": 1900000 +"OriginatingSystemKey": "714193587" +"Ownership": "Fee Simple" +"ParcelNumber": "040 037 740 02 001" +"PhotosChangeTimestamp": "2024-02-07T14:09:09Z" +"PhotosCount": 11 +"PreviousListPrice": 1900000 +"PriceChangeTimestamp": "2024-04-09T17:54:28Z" +"RoadSurfaceType": array:1 [ …1] +"Sewer": "Public Sewer" +"ShowingRequirements": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-02-06T20:55:44Z" +"StreetName": "FERNANDEZ JUNCOS" +"StreetNumber": "631" +"StreetSuffix": "AVENUE" +"TaxAnnualAmount": "6105" +"TaxYear": "2024" +"UniversalPropertyId": "US-72127-N-04003774002001-R-N" +"Utilities": "Electricity Available,Sewer Available,Water Available" +"WaterSource": array:1 [ …1] +"Zoning": "CT-2" +"MFR_FrontFootage": "228" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530044" +"MFR_LotSizeSquareMeters": "1782" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "787-523-6500" +"MFR_PricePerAcre": "3636364" +"MFR_CalculatedListPriceByCalculatedSqFt": "83.44" +"MFR_WaterAccessYN": "0" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "83.44" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Situated within close proximity to the Convention District Area, entertainment venues, restaurants, and cultural attractions, this prime location offers unparalleled visibility and foot traffic. This lot presents an exceptional opportunity for commercial development with lucrative tourist potential. Visitors and locals alike frequent this area, making it an ideal destination for a wide range of commercial ventures. With easy access to major transportation hubs and thoroughfares, including highways and public transit systems. In summary, this empty lot offers a rare chance to capitalize on the city's dynamic energy and vibrant culture. With its unbeatable location, accessibility, and commercial potential, it's the perfect canvas for creating a landmark destination that will leave a lasting impression on visitors and locals alike. Zoning: CT-2. The Miramar Arts District offers a captivating blend of historic charm, modern sophistication, and natural beauty. Rich in history and culture, Miramar is home to a diverse array of art galleries, museums, and cultural institutions. From the iconic Puerto Rico Convention Center and Distrito TMobile entertainment complex to its historic landmarks. Miramar is a culinary hotspot, with a wide variety of restaurants, cafes, and eateries offering everything from traditional Puerto Rican cuisine to international fare. The area also boasts a vibrant nightlife scene, with trendy bars, lounges, and entertainment venues catering to every taste." +"MFR_CurrentPrice": "1600000.00" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "1/4 to less than 1/2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "See Remarks" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ForLeaseYN": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-523-6500" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR714193587')" +"provider_name": "Stellar" +"Media": array:11 [ …11] +"ID": "486101" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3819 +post_id: "485192" +post_author: 1 +"ListingKey": "MFR740255351" +"ListingId": "PR9109905" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-15T14:08:07Z" +"RFModificationTimestamp": "2024-11-15T14:23:47Z" +"ListPrice": 5590000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 4006.0 +"BuildingAreaTotal": 4006.0 +"City": "San Juan" +"PostalCode": "00911" +"UnparsedAddress": "1758 Mcleary Avenue, San Juan, Puerto Rico 00911" +"Coordinates": array:2 [ …2] +"Latitude": 18.45297 +"Longitude": -66.05968 +"YearBuilt": 1932 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Caroline Johnson" +"ListOfficeName": "CORCORAN PUERTO RICO" +"ListAgentMlsId": "743511549" +"ListOfficeMlsId": "743511482" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ A piece of art in the iconic Spanish Revival style, this villa was meticulously crafted in the 1930’s by esteemed architect Pedro Adolfo de Castro. The historic gem spans 4,006 square feet of living space, featuring 5 beds/3.5 baths over two buildings. Located just one block from the widest expanse of beach on the most desirable residential block between Ocean Park and Condado, the property sits on a massive 1099 square meter lot. The land benefits from RT3 zoning, presenting a unique development opportunity. Whether inhabiting this cultural marvel or developing a larger structure, it must be seen and experienced.\r\n \r\n A vast Moroccan garden with water feature and lush landscaping greets visitors with dramatic flourish. As you approach the main entrance - look closely - tiny shells have been incorporated into the entire facade offering a glimpse of the intricacy that awaits. \r\n \r\n Open the front door and witness the sophistication of the interiors, featuring 12-foot ceilings, grand Spanish-style arches, original Terrazzo flooring with ornate bronze seams, custom mahogany woodwork, and Spanish wrought iron. The formal entry and living room are surrounded by windows, continuing the harmonious flow of the tropical gardens outside.\r\n \r\n Behind this grand reception room, a powder room with beautiful stained-glass windows, is conveniently located for visitors. Walk down the hallway, ornamented with immense arches for an aura of grandeur, to the formal library. Adjacent you’ll find a tremendous walk-in climate-controlled wine cave.\r\n \r\n The kitchen is conveniently located nearby and harkens to colorful, classic Puerto Rican cuisine, while equipped with stainless steel and all modern appliances. Connected to the kitchen is the informal dining area and wet bar.\r\n \r\n Float to the elegant formal dining room where a massive floor to ceiling window bathes the space in light. This accent window offers a new vantage point to witness the breath-taking sculpture garden and mosaic fountains outside, making for the most exquisite dining conversation.\r\n \r\n A grand bronze staircase ascends to the second level where you will discover the home’s 3 beds/2 baths, home office, and truly unique Moroccan sitting room.\r\n \r\n The expansive primary suite is a private sanctum of elegance and sophistication. Throw open the French doors to a romantic Juliette balcony overlooking the front garden below. Soak in the jacuzzi tub, an entire spa room apart from the ensuite bathroom for the ultimate in relaxation.\r\n \r\n A distinct walking bridge from the second floor leads to an additional recently remodeled living quarter, which includes 1 bed/1 bath, an office space, and a large area currently serving as an art gallery. \r\n \r\n From this level, ascend the grand outdoor spiral staircase, itself an architectural masterpiece, to view sunsets from the roof, or descend a second spiral staircase to the grounds below. The black bottomed pool, surrounded by mature tropical landscaping, is designed as both a beautiful focal point and for use and enjoyment. \r\n \r\n This entire residence is completely gated for the utmost security, while the driveway leads to an enclosed, private three-car garage. The property is equipped with an automatic Generac-Diesel 30 KLV generator and a 600-gallon water cistern, ensuring uninterrupted convenience.\r\n \r\n This home seamlessly blends contemporary amenities with preserved original elements, situated on one of the largest and most rare lots in Condado. Contact me today. """ +"Appliances": "Cooktop,Dishwasher,Electric Water Heater,Freezer,Ice Maker,Microwave,Refrigerator,Washer,Wine Refrigerator" +"BathroomsFull": 3 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Mini-Split Unit(s)" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-11-06T14:20:59.841220+00:00" +"CumulativeDaysOnMarket": 9 +"DaysOnMarket": 324 +"DirectionFaces": "North" +"Directions": "From highway 26 take the Calle Loiza exit. Make. right onto Ashford Avenue and find the residence on the right side of the street." +"ExteriorFeatures": "Balcony,Courtyard,French Doors,Garden,Irrigation System,Lighting,Outdoor Grill,Shade Shutter(s),Storage" +"Flooring": "Terrazzo,Wood" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3" +"GarageYN": true +"Heating": "None" +"InteriorFeatures": "Eat-in Kitchen,High Ceilings,PrimaryBedroom Upstairs,Walk-In Closet(s),Wet Bar,Window Treatments" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-900-7636" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "577358595" +"ListOfficeKey": "571428148" +"ListOfficePhone": "939-478-6028" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-11-05" +"LivingAreaSource": "Owner" +"LotSizeAcres": 0.27 +"LotSizeSquareFeet": 11830 +"MLSAreaMajor": "00911 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2024-11-06" +"OriginalEntryTimestamp": "2024-11-06T14:15:09Z" +"OriginalListPrice": 5590000 +"OriginatingSystemKey": "740255351" +"Ownership": "Fee Simple" +"ParcelNumber": "041-041-178-04-901" +"PhotosChangeTimestamp": "2024-11-06T14:17:08Z" +"PhotosCount": 29 +"PoolFeatures": "In Ground" +"PoolPrivateYN": true +"RoadSurfaceType": array:1 [ …1] +"Roof": "Concrete" +"Sewer": "Public Sewer" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-11-06T14:15:09Z" +"StreetName": "MCLEARY AVENUE" +"StreetNumber": "1758" +"SubdivisionName": "CONDADO" +"UniversalPropertyId": "US-72127-N-04104117804901-R-N" +"Utilities": "Other" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=i Tky4in Gy4z" +"WaterSource": array:1 [ …1] +"Zoning": "RT3" +"MFR_ListOfficeHeadOfficeKeyNumeric": "571428148" +"MFR_LivingAreaMeters": "372.17" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "1099" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "787-565-8972" +"MFR_CalculatedListPriceByCalculatedSqFt": "1395.41" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109905?w=Customer" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "1395.41" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": """ A piece of art in the iconic Spanish Revival style, this villa was meticulously crafted in the 1930’s by esteemed architect Pedro Adolfo de Castro. The historic gem spans 4,006 square feet of living space, featuring 5 beds/3.5 baths over two buildings. Located just one block from the widest expanse of beach on the most desirable residential block between Ocean Park and Condado, the property sits on a massive 1099 square meter lot. The land benefits from RT3 zoning, presenting a unique development opportunity. Whether inhabiting this cultural marvel or developing a larger structure, it must be seen and experienced.\r\n \r\n A vast Moroccan garden with water feature and lush landscaping greets visitors with dramatic flourish. As you approach the main entrance - look closely - tiny shells have been incorporated into the entire facade offering a glimpse of the intricacy that awaits. \r\n \r\n Open the front door and witness the sophistication of the interiors, featuring 12-foot ceilings, grand Spanish-style arches, original Terrazzo flooring with ornate bronze seams, custom mahogany woodwork, and Spanish wrought iron. The formal entry and living room are surrounded by windows, continuing the harmonious flow of the tropical gardens outside.\r\n \r\n Behind this grand reception room, a powder room with beautiful stained-glass windows, is conveniently located for visitors. Walk down the hallway, ornamented with immense arches for an aura of grandeur, to the formal library. Adjacent you’ll find a tremendous walk-in climate-controlled wine cave.\r\n \r\n The kitchen is conveniently located nearby and harkens to colorful, classic Puerto Rican cuisine, while equipped with stainless steel and all modern appliances. Connected to the kitchen is the informal dining area and wet bar.\r\n \r\n Float to the elegant formal dining room where a massive floor to ceiling window bathes the space in light. This accent window offers a new vantage point to witness the breath-taking sculpture garden and mosaic fountains outside, making for the most exquisite dining conversation.\r\n \r\n A grand bronze staircase ascends to the second level where you will discover the home’s 3 beds/2 baths, home office, and truly unique Moroccan sitting room.\r\n \r\n The expansive primary suite is a private sanctum of elegance and sophistication. Throw open the French doors to a romantic Juliette balcony overlooking the front garden below. Soak in the jacuzzi tub, an entire spa room apart from the ensuite bathroom for the ultimate in relaxation.\r\n \r\n A distinct walking bridge from the second floor leads to an additional recently remodeled living quarter, which includes 1 bed/1 bath, an office space, and a large area currently serving as an art gallery. \r\n \r\n From this level, ascend the grand outdoor spiral staircase, itself an architectural masterpiece, to view sunsets from the roof, or descend a second spiral staircase to the grounds below. The black bottomed pool, surrounded by mature tropical landscaping, is designed as both a beautiful focal point and for use and enjoyment. \r\n \r\n This entire residence is completely gated for the utmost security, while the driveway leads to an enclosed, private three-car garage. The property is equipped with an automatic Generac-Diesel 30 KLV generator and a 600-gallon water cistern, ensuring uninterrupted convenience.\r\n \r\n This home seamlessly blends contemporary amenities with preserved original elements, situated on one of the largest and most rare lots in Condado. Contact me today. """ +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109905?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "5590000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "1/4 to less than 1/2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_RoomCount": "4" +"MFR_InLawSuiteDescription": "1 Bathroom,1 Bedroom" +"MFR_BuildingAreaTotalSrchSqM": "372.17" +"MFR_GreenVerificationCount": "0" +"MFR_MinimumLease": "1-2 Years" +"MFR_InLawSuiteYN": "1" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ExistLseTenantYN": "0" +"MFR_AvailableForLeaseYN": "1" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-565-8972" +"MFR_SellerRepresentation": "Single Agent" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR740255351')" +"provider_name": "Stellar" +"Media": array:29 [ …29] +"ID": "485192" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3879 +post_id: "485224" +post_author: 1 +"ListingKey": "MFR739382848" +"ListingId": "PR9109677" +"PropertyType": "Residential" +"PropertySubType": "Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-01T14:33:07Z" +"RFModificationTimestamp": "2024-11-01T16:56:47Z" +"ListPrice": 949000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1815.0 +"City": "San Juan" +"PostalCode": "00927" +"UnparsedAddress": "4 Calle Clavel, San Juan, Puerto Rico 00927" +"Coordinates": array:2 [ …2] +"Latitude": 18.38133 +"Longitude": -66.085548 +"YearBuilt": 1991 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Annelise Figueroa Cordero" +"ListOfficeName": "TWO20 GROUP" +"ListAgentMlsId": "743575004" +"ListOfficeMlsId": "743575087" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ - Asking Price: $949,000\r\n - Corner Unit 375m2\r\n - GLA: approx. 1,815 sq.ft\r\n - Private Gate \r\n - 3 Bedrooms (convertible to 4)\r\n - 2.5 Bathrooms\r\n - Poggenpohl Kitchen (fully equipped)\r\n - Living & Dining Area\r\n - Family Room\r\n - Extensive patio \r\n - Laundry Room\r\n - Hi’s & Her’s walk-in closets at Master Bedroom\r\n - Move in ready: furnished or unfurnished \r\n - Full Power Generator\r\n - HOA $149 \r\n - CRIM: TBA \r\n - No neighbors, private gate, fully equipped with A/C, Generator, Curtains, Etc. \r\n - Neighborhood amenities include: controlled access, gazebo, basketball & beach tennis court, playground, dog park, and walking and green areas. """ +"Appliances": "Cooktop,Dishwasher,Freezer,Microwave,Refrigerator" +"AssociationFee": "260" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:6 [ …6] +"AssociationName": "Parque Santa Maria" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Dog Park,Gated Community - Guard,Park,Playground,Tennis Courts" +"ConstructionMaterials": array:3 [ …3] +"Cooling": "Mini-Split Unit(s)" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-10-24T20:26:14.218604+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 337 +"DirectionFaces": "North" +"Directions": """ Luis Munoz Marin International Airport\r\n Airport Rd, Carolina, 00979\r\n \r\n ?\r\n Take Marginal Aeropuerto to Airport Rd\r\n 2 min (1.0 km)\r\n \r\n Head east on Airport Rd\r\n 100 m\r\n \r\n Slight right\r\n 99 m\r\n \r\n Turn right\r\n 400 m\r\n \r\n Sharp right onto Marginal Aeropuerto\r\n 400 m\r\n \r\n ?\r\n Follow Puente Teodoro Moscoso, Av. Jesús T. Piñero/PR-17 and Expreso Las Américas/PR-18 to C. San Alonso in Monacillo Urbano, San Juan. Exit from PR-1 S\r\n 11 min (12.2 km)\r\n \r\n Merge onto Airport Rd\r\n Toll road\r\n 3.2 km\r\n \r\n Continue onto Av. Jesús T. Piñero/PR-17\r\n ?\r\n 4.6 km\r\n \r\n Take the ramp onto Expreso Las Américas/PR-18\r\n ?\r\n 3.7 km\r\n \r\n Exit onto PR-1 S\r\n ?\r\n 500 m\r\n \r\n Take the exit toward C. San Alonso\r\n 180 m\r\n \r\n ?\r\n Take C. Reina de las Flores and C. Orquídea to Calle Begonia\r\n 3 min (1.3 km)\r\n \r\n Continue onto C. San Alonso\r\n 230 m\r\n \r\n Continue onto C. Reina de las Flores\r\n 550 m\r\n \r\n Turn right onto C. Orquídea\r\n 500 m\r\n \r\n Turn right onto Calle Begonia\r\n Destination will be on the left\r\n 88 m\r\n Parque Santa María\r\n C. Clavel, San Juan, 00927 """ +"ExteriorFeatures": "Garden,Tennis Court(s)" +"Flooring": "Tile" +"FoundationDetails": array:2 [ …2] +"GarageSpaces": "4" +"GarageYN": true +"Heating": "None" +"InteriorFeatures": "Living Room/Dining Room Combo,Other,PrimaryBedroom Upstairs,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-235-9922" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530162" +"ListAgentPager": "787-235-9922" +"ListOfficeKey": "507530003" +"ListOfficePhone": "787-366-2221" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-10-23" +"LivingAreaSource": "Owner" +"LotSizeAcres": 0.41 +"LotSizeSquareFeet": 1815 +"MLSAreaMajor": "00927 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2024-10-24" +"OriginalEntryTimestamp": "2024-10-24T18:46:46Z" +"OriginalListPrice": 949000 +"OriginatingSystemKey": "739382848" +"Ownership": "Co-op" +"ParcelNumber": "086-077-198-07" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-10-24T19:41:09Z" +"PhotosCount": 20 +"RoadSurfaceType": array:2 [ …2] +"Roof": "Concrete" +"Sewer": "Private Sewer,Public Sewer" +"ShowingRequirements": array:5 [ …5] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-10-24T18:46:46Z" +"StreetName": "CALLE CLAVEL" +"StreetNumber": "4" +"SubdivisionName": "ROTONDA 106" +"UniversalPropertyId": "US-72127-N-08607719807-R-N" +"Utilities": "Other" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9109677" +"WaterSource": array:1 [ …1] +"Zoning": "R-1" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530003" +"MFR_LivingAreaMeters": "0.00" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "169" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_MonthlyHOAAmount": "260.00" +"MFR_ListOfficeContactPreferred": "787-235-9922" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109677?w=Customer" +"MFR_AssociationFeeRequirement": "Required" +"MFR_EscrowState": "FL" +"MFR_YrsOfOwnerPriorToLeasingReqYN": "0" +"MFR_AssociationApprovalRequiredYN": "0" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": """ - Asking Price: $949,000\r\n - Corner Unit 375m2\r\n - GLA: approx. 1,815 sq.ft\r\n - Private Gate \r\n - 3 Bedrooms (convertible to 4)\r\n - 2.5 Bathrooms\r\n - Poggenpohl Kitchen (fully equipped)\r\n - Living & Dining Area\r\n - Family Room\r\n - Extensive patio \r\n - Laundry Room\r\n - Hi’s & Her’s walk-in closets at Master Bedroom\r\n - Move in ready: furnished or unfurnished \r\n - Full Power Generator\r\n - HOA $149 \r\n - CRIM: TBA \r\n - No neighbors, private gate, fully equipped with A/C, Generator, Curtains, Etc. \r\n - Neighborhood amenities include: controlled access, gazebo, basketball & beach tennis court, playground, dog park, and walking and green areas. """ +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9109677?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "949000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "1/4 to less than 1/2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "3120.00" +"MFR_RoomCount": "4" +"MFR_BuildingAreaTotalSrchSqM": "168.62" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "260.00" +"MFR_ExistLseTenantYN": "0" +"MFR_BuildingNameNumber": "L6" +"MFR_AvailableForLeaseYN": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-235-9922" +"MFR_SellerRepresentation": "Single Agent" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR739382848')" +"provider_name": "Stellar" +"Media": array:20 [ …20] +"ID": "485224" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3823 +post_id: "485031" +post_author: 1 +"ListingKey": "MFR737741488" +"ListingId": "PR9109167" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-10-01T05:01:13Z" +"RFModificationTimestamp": "2024-10-01T05:24:31Z" +"ListPrice": 4500000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "San Juan" +"PostalCode": "00918" +"UnparsedAddress": "#541-#559 Sergio Cuevas Bustamente, Hato Rey Ward" +"Coordinates": array:2 [ …2] +"Latitude": 18.4119214 +"Longitude": -66.0679947 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Milton Serrano Lebron" +"ListOfficeName": "REALITY REALTY" +"ListAgentMlsId": "741502978" +"ListOfficeMlsId": "742000096" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Land available in Hato Rey with a privileged location, right next to the Hospital del Maestro, the La Merced Dev., the Las Americas Expressway and Manuel Domenech Ave. It has an area of approx.4,549 sm, divided into 12 lots of approx. 400sm each, with a mostly rectangular configuration and a wide front. It is currently used as a parking lot with 135 spaces. This space is ideal for developing an urban, residential or mixed-use project. The area is characterized by a high population density and a dynamic mix of uses. Nearby there are residences, multi-family buildings, medical and health service offices, condominiums, senior living, restaurants and passive parks. This diversity contributes to the vitality and attractiveness of the area. The land is zoned R-4, which offers various development possibilities, although some potential uses could require a zoning change. This is an excellent investment opportunity in one of the few available lands of this type in Hato Rey." +"AdditionalParcelsDescription": "062-080-831-25-000" +"AdditionalParcelsYN": true +"BuildingAreaUnits": "Square Feet" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-09-30T14:53:30.184571+00:00" +"CurrentUse": array:1 [ …1] +"Directions": "Take PR-18, Las Americas Expressway, towards Hato Rey (towards the South if coming from Old San Juan or Santurce; North if coming from Caguas or Guaynabo). Take the Manuel Domenech Ave. exit towards the East, and immediately turn right on Juan José Jimenez St. Turn left on Sergio Cuevas Bustamante St, the land is on the right-hand side, beginning in the corner and up to #538-B of the same street. The land also includes adjacent lots #570 and #572 on Hermogenes Alverio St. Continue to Manuel Domenech Ave. from Sergio Cuevas Bustamante St, turn right and immediately turn right on Hermogenes Alverio St, up to #570 and #572. These are adjoining on the back with the rest of the land." +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-444-6583" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530077" +"ListAgentPager": "787-444-6583" +"ListOfficeKey": "507529944" +"ListOfficePhone": "787-745-8777" +"ListOfficeURL": "http://www.realityrealtypr.com" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-09-26" +"LotSizeAcres": 1.12 +"LotSizeDimensions": "4549" +"LotSizeSquareFeet": 48947 +"MLSAreaMajor": "00918 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfLots": "12" +"OnMarketDate": "2024-09-30" +"OriginalEntryTimestamp": "2024-09-30T14:44:35Z" +"OriginalListPrice": 4500000 +"OriginatingSystemKey": "737741488" +"Ownership": "Other" +"ParcelNumber": "062-080-831-26-000" +"PhotosChangeTimestamp": "2024-09-30T14:47:07Z" +"PhotosCount": 9 +"RoadSurfaceType": array:1 [ …1] +"Sewer": "Public Sewer" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-09-30T14:44:35Z" +"StreetName": "SERGIO CUEVAS BUSTAMENTE, HATO REY WARD" +"StreetNumber": "#541-#559" +"UniversalPropertyId": "US-72127-N-06208083126000-R-N" +"Utilities": "Electricity Available,Sewer Nearby,Water Nearby" +"WaterSource": array:1 [ …1] +"Zoning": "R-4" +"MFR_FrontFootage": "33" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507529944" +"MFR_LotSizeSquareMeters": "4547" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_ListOfficeContactPreferred": "787-745-8777" +"MFR_PricePerAcre": "4017857" +"MFR_CalculatedListPriceByCalculatedSqFt": "91.94" +"MFR_WaterAccessYN": "0" +"MFR_EscrowState": "PR" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "91.94" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Land available in Hato Rey with a privileged location, right next to the Hospital del Maestro, the La Merced Dev., the Las Americas Expressway and Manuel Domenech Ave. It has an area of approx.4,549 sm, divided into 12 lots of approx. 400sm each, with a mostly rectangular configuration and a wide front. It is currently used as a parking lot with 135 spaces. This space is ideal for developing an urban, residential or mixed-use project. The area is characterized by a high population density and a dynamic mix of uses. Nearby there are residences, multi-family buildings, medical and health service offices, condominiums, senior living, restaurants and passive parks. This diversity contributes to the vitality and attractiveness of the area. The land is zoned R-4, which offers various development possibilities, although some potential uses could require a zoning change. This is an excellent investment opportunity in one of the few available lands of this type in Hato Rey." +"MFR_CurrentPrice": "4500000.00" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "A" +"MFR_TotalAcreage": "1 to less than 2" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "See Remarks" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ForLeaseYN": "0" +"MFR_PublicRemarksAgentSpanish": "Terreno disponible en Hato Rey con una ubicación privilegiada, justo al lado del Hospital del Maestro, la Urb. La Merced, el Expreso Las Américas y la Ave. Manuel Domenech. Cuenta con una extensión de aprox. 4,549m2, dividido en 12 lotes de aprox. 400 m2 cada uno, con una configuración mayormente rectangular y con un amplio frente. Actualmente se utiliza como estacionamiento y cuenta con 135 espacios. Este espacio es ideal para desarrollar un proyecto urbano, residencial o de uso mixto. La zona se caracteriza en ser una alta densidad poblacional y una mezcla dinámica de usos. En las cercanías se encuentran residencias, edificios multifamiliares, oficinas médicas y de servicios de salud, condominios, égidas, restaurantes y parques pasivos. Esta diversidad contribuye a la vitalidad y el atractivo del área. El terreno está zonificado como R-4, lo que ofrece diversas posibilidades de desarrollo, aunque algunos usos potenciales podrían requerir un cambio de zonificación. Esta es una excelente oportunidad de inversión en uno de los pocos terrenos disponibles de este tipo en Hato Rey." +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-745-8777" +"MFR_SellerRepresentation": "Single Agent" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR737741488')" +"provider_name": "Stellar" +"Media": array:9 [ …9] +"ID": "485031" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3818 +post_id: "484946" +post_author: 1 +"ListingKey": "MFR703877609" +"ListingId": "PR9102424" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-09-23T15:28:07Z" +"RFModificationTimestamp": "2024-09-24T12:43:19Z" +"ListPrice": 1744920.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 58164.0 +"City": "San Juan" +"PostalCode": "00927" +"UnparsedAddress": "280 Jesus T Piñero Avenue, San Juan, Florida 00927" +"Coordinates": array:2 [ …2] +"Latitude": 18.40732 +"Longitude": -66.06497 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Annelise Figueroa Cordero" +"ListOfficeName": "TWO20 GROUP" +"ListAgentMlsId": "743575004" +"ListOfficeMlsId": "743575087" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ - Base rent: $18.50/RSF\r\n - OPEX: $11.50\r\n - Total rent: $30.00/RSF\r\n - Up to 58,164 RSF available\r\n - Spaces may be sub-divided to tenant’s need\r\n - Rent includes utilities (electricity & water)\r\n - On-site parking available\r\n - Parking ratio: 4:1,000\r\n - 50% Interior at $75 per space, per month\r\n - 50% Exterior at $65 per space, per month\r\n - 1;1,000 SF free of charge while rent is current\r\n - Capacity for 354 vehicles\r\n - Visitors parking available\r\n - Fiber optic infrastructure\r\n - Central chilled A/C\r\n - After-Hours billed at $150 per hour\u{A0}\u{A0}\u{A0}\u{A0}\u{A0}\r\n - 24/7 Surveillance security & controlled access\r\n - 2 High speed elevators\r\n - Full capacity power generator (1.5KW and 5,000gal Tank)\r\n - Emergency water cisterns (130,000gal & 96,000gal for fire)\r\n - Maintenance and\u{A0}janitorial services\u{A0}within suite are\u{A0}available for $2/SF\r\n - Centralized fire, alarm, and sprinkler systems\r\n - Entrance vestibules from rear parking\r\n - Tenant improvements may be performed by landlord, to be negotiated based on lease term\r\n - Built in 2014 """ +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2023-10-09T16:41:42.083082+00:00" +"CumulativeDaysOnMarket": 350 +"DaysOnMarket": 718 +"Directions": """ PRI-1\r\n Dirígete al sureste por Expreso Las Américas/PR-18.\r\n \r\n 2.1 km\r\n Toma la salida 3B hacia Puerto Rico 17, en dirección a Río Piedras/Carolina/Trujillo Alto\r\n \r\n 290 metros\r\n Incorpórate a Av. Jesús T. Piñero/PR-17\r\n El destino está a la izquierda.\r\n \r\n 550 metros\r\n Has llegado a 280 Av. Jesús T. Piñero (Oriental) """ +"FoundationDetails": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeasableArea": 58164 +"LeaseAmountFrequency": "Annually" +"LeaseTerm": "Three to Five Years" +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-235-9922" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530162" +"ListAgentPager": "787-235-9922" +"ListOfficeKey": "507530003" +"ListOfficePhone": "787-235-9922" +"ListingAgreement": "Exclusive Right To Lease" +"ListingContractDate": "2023-10-04" +"LotSizeAcres": 2 +"LotSizeSquareFeet": 100046 +"MLSAreaMajor": "00927 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2023-10-09" +"OriginalEntryTimestamp": "2023-10-09T16:35:17Z" +"OriginalListPrice": 1744920 +"OriginatingSystemKey": "703877609" +"OwnerPays": array:2 [ …2] +"ParcelNumber": "06308139031" +"PhotosChangeTimestamp": "2024-05-06T22:18:11Z" +"PhotosCount": 47 +"RoadFrontageType": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"ShowingRequirements": array:4 [ …4] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2023-10-09T16:35:17Z" +"StreetName": "JESUS T PIÑERO" +"StreetNumber": "280" +"StreetSuffix": "AVENUE" +"SubdivisionName": "ORIENTAL PLAZA" +"TenantPays": array:2 [ …2] +"UniversalPropertyId": "US-72127-N-06308139031-R-N" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9102424" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530003" +"MFR_LeasePrice": "30.00" +"MFR_LotSizeSquareMeters": "9295" +"MFR_WaterViewYN": "0" +"MFR_TermsOfLease": "Absolute (Triple) Net" +"MFR_ListOfficeContactPreferred": "787-235-9922" +"MFR_CalculatedListPriceByCalculatedSqFt": "30.00" +"MFR_WaterAccessYN": "0" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "0.00" +"MFR_WaterExtrasYN": "0" +"MFR_PublicRemarksAgent": """ - Base rent: $18.50/RSF\r\n - OPEX: $11.50\r\n - Total rent: $30.00/RSF\r\n - Up to 58,164 RSF available\r\n - Spaces may be sub-divided to tenant’s need\r\n - Rent includes utilities (electricity & water)\r\n - On-site parking available\r\n - Parking ratio: 4:1,000\r\n - 50% Interior at $75 per space, per month\r\n - 50% Exterior at $65 per space, per month\r\n - 1;1,000 SF free of charge while rent is current\r\n - Capacity for 354 vehicles\r\n - Visitors parking available\r\n - Fiber optic infrastructure\r\n - Central chilled A/C\r\n - After-Hours billed at $150 per hour\u{A0}\u{A0}\u{A0}\u{A0}\u{A0}\r\n - 24/7 Surveillance security & controlled access\r\n - 2 High speed elevators\r\n - Full capacity power generator (1.5KW and 5,000gal Tank)\r\n - Emergency water cisterns (130,000gal & 96,000gal for fire)\r\n - Maintenance and\u{A0}janitorial services\u{A0}within suite are\u{A0}available for $2/SF\r\n - Centralized fire, alarm, and sprinkler systems\r\n - Entrance vestibules from rear parking\r\n - Tenant improvements may be performed by landlord, to be negotiated based on lease term\r\n - Built in 2014 """ +"MFR_CurrentPrice": "30.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_LeasePricePerSqFt": "30.00" +"MFR_TotalNumBuildings": "1" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "2 to less than 5" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_BuildingAreaTotalSrchSqM": "5403.61" +"MFR_TotalMonthlyFees": "0.00" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-235-9922" +"MFR_LeasePriceUnit": "Per SqFt" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR703877609')" +"provider_name": "Stellar" +"Media": array:47 [ …47] +"ID": "484946" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3817 +post_id: "484953" +post_author: 1 +"ListingKey": "MFR736622965" +"ListingId": "PR9108833" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-09-14T10:49:38Z" +"RFModificationTimestamp": "2024-09-14T11:04:45Z" +"ListPrice": 2150000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2700.0 +"BuildingAreaTotal": 2700.0 +"City": "San Juan" +"PostalCode": "00907" +"UnparsedAddress": "555 C. Monserrate #5, San Juan, Puerto Rico 00907" +"Coordinates": array:2 [ …2] +"Latitude": 18.453707 +"Longitude": -66.077889 +"YearBuilt": 2010 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Javi Rodriguez" +"ListOfficeName": "MICORREDOR.COM" +"ListAgentMlsId": "743520489" +"ListOfficeMlsId": "743574901" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "This luxurious condominium is located on the 5th floor of the Cosmopolitan Condominium. The property has 3 spacious bedrooms and 3.5 luxurious bathrooms, totaling 2,700 sqft of living space. The condominium also comes with 3 parking spaces and access to a beautiful pool ." +"Appliances": "Built-In Oven,Washer,Water Filtration System,Water Purifier" +"AssociationFee": "700" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "Javier Rodríguez" +"AssociationYN": true +"Basement": array:1 [ …1] +"BathroomsFull": 3 +"BuildingAreaSource": "Appraiser" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Fitness Center,Pool" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Mini-Split Unit(s)" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-09-14T02:53:54.196285+00:00" +"CumulativeDaysOnMarket": 1 +"DaysOnMarket": 378 +"DirectionFaces": "North" +"Directions": "Cosmopolitan in Condado in front of the lagoon" +"ExteriorFeatures": "Balcony,Hurricane Shutters" +"Flooring": "Ceramic Tile" +"FoundationDetails": array:2 [ …2] +"GarageSpaces": "3" +"GarageYN": true +"Heating": "Other" +"InteriorFeatures": "Built-in Features" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-717-0187" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530134" +"ListAgentURL": "http://www.MiCorredor.com" +"ListOfficeKey": "507529985" +"ListOfficePhone": "787-717-0187" +"ListOfficeURL": "http://www.MiCorredor.com" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2024-09-13" +"LivingAreaSource": "Appraiser" +"LotSizeSquareFeet": 2700 +"MLSAreaMajor": "00907 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2024-09-13" +"OriginalEntryTimestamp": "2024-09-13T22:08:47Z" +"OriginalListPrice": 2150000 +"OriginatingSystemKey": "736622965" +"Ownership": "Condominium" +"ParcelNumber": "47291793082711" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-09-13T22:11:07Z" +"PhotosCount": 31 +"RoadSurfaceType": array:2 [ …2] +"Roof": "Concrete" +"Sewer": "Public Sewer" +"ShowingRequirements": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-09-13T22:08:47Z" +"StoriesTotal": "20" +"StreetName": "C. MONSERRATE" +"StreetNumber": "555" +"SubdivisionName": "COSMOPOLITAN" +"UnitNumber": "5" +"UniversalPropertyId": "US-72127-N-47291793082711-S-5" +"Utilities": "Cable Available,Cable Connected,Electricity Connected,Fiber Optics,Phone Available,Water Connected" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9108833" +"WaterSource": array:1 [ …1] +"Zoning": "R2" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507529985" +"MFR_LivingAreaMeters": "250.84" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "251" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_MonthlyHOAAmount": "700.00" +"MFR_CondoLandIncludedYN": "0" +"MFR_ListOfficeContactPreferred": "787-717-0187" +"MFR_CondoFees": "0" +"MFR_CalculatedListPriceByCalculatedSqFt": "796.30" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9108833?w=Customer" +"MFR_AssociationFeeRequirement": "Required" +"MFR_EscrowState": "FL" +"MFR_YrsOfOwnerPriorToLeasingReqYN": "0" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "796.30" +"MFR_AssociationApprovalRequiredYN": "0" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "This luxurious condominium is located on the 5th floor of the Cosmopolitan Condominium. The property has 3 spacious bedrooms and 3.5 luxurious bathrooms, totaling 2,700 sqft of living space. The condominium also comes with 3 parking spaces and access to a beautiful pool ." +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9108833?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "2150000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "na" +"MFR_TotalAcreage": "Non-Applicable" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "8400.00" +"MFR_RoomCount": "3" +"MFR_BuildingElevatorYN": "1" +"MFR_BuildingAreaTotalSrchSqM": "250.84" +"MFR_GreenVerificationCount": "1" +"MFR_MinimumLease": "No Minimum" +"MFR_FloorNumber": "5" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "700.00" +"MFR_ExistLseTenantYN": "0" +"MFR_BuildingNameNumber": "COSMOPOLITAN" +"MFR_MaxPetWeight": "75" +"MFR_AvailableForLeaseYN": "1" +"MFR_MontlyMaintAmtAdditionToHOA": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-717-0187" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR736622965')" +"provider_name": "Stellar" +"Media": array:31 [ …31] +"ID": "484953" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4575 +post_id: "486379" +post_author: 1 +"ListingKey": "MFR715503967" +"ListingId": "PR9104791" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-06-25T23:41:07Z" +"RFModificationTimestamp": "2024-06-26T01:36:02Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 4000.0 +"BuildingAreaTotal": 4000.0 +"City": "San Juan" +"PostalCode": "00927" +"UnparsedAddress": "1928 Petunia, San Juan, Florida 00927" +"Coordinates": array:2 [ …2] +"Latitude": 18.37235609 +"Longitude": -66.08604683 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Andres Rivera" +"ListOfficeName": "EXP PUERTO RICO LLC" +"ListAgentMlsId": "743524010" +"ListOfficeMlsId": "742000999" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Luxury awaits in the prestigious neighbourhood of Santa Maria. This home, featuring 9-foot-high ceilings and marbled floors, offers refined elegance and comfort. Enjoy spacious living areas with a swimming pool and a grand terrace. With four bedrooms, including a primary suite boasting a walk-in closet and balcony, every comfort is assured. Three full bathrooms, a 15KW electric generator, and a solar water heater add practicality. Less than half a mile away from top-rated schools, this residence epitomizes sophisticated living in a coveted locale. Don't miss the chance to call this exclusive property yours." +"Appliances": "Dishwasher,Dryer,Solar Hot Water,Washer" +"AssociationAmenities": array:5 [ …5] +"AssociationFee": "288" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ …2] +"AssociationName": "UNDARE" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 3 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "3" +"CommunityFeatures": "Gated Community - Guard,Park,Playground,Sidewalks" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Mini-Split Unit(s)" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-02-23T18:58:12.250378+00:00" +"CumulativeDaysOnMarket": 123 +"DaysOnMarket": 580 +"DirectionFaces": "Southeast" +"Directions": """ Take Expreso Las Américas/PR-18 to C. Reina de las Flores in Monacillo Urbano, Head south on Expreso Las Américas/PR-18,Exit onto PR-1 S, Take Av. Lomas Verdes/PR-177 to Cll Petunia, Keep right to continue on C. Reina de las Flores\r\n 75 m,Slight right to merge onto Av. Lomas Verdes/PR-177,950 m Turn right onto Calle Romerillo\r\n 10 m\r\n Turn right to stay on Calle Romerillo\r\n 170 m\r\n Turn left onto Cll Petunia """ +"ExteriorFeatures": "Balcony,Courtyard,Garden,Hurricane Shutters,Lighting,Rain Barrel/Cistern(s),Sidewalk,Storage" +"Fencing": array:1 [ …1] +"Flooring": "Marble" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageSpaces": "2" +"GarageYN": true +"Heating": "None" +"InteriorFeatures": "Eat-in Kitchen,High Ceilings,Open Floorplan,PrimaryBedroom Upstairs,Solid Surface Counters,Solid Wood Cabinets,Walk-In Closet(s)" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-938-7178" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "714203062" +"ListOfficeKey": "554496465" +"ListOfficePhone": "939-697-6300" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-02-21" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Owner" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 0.21 +"LotSizeSquareFeet": 9149 +"MLSAreaMajor": "00927 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2024-02-23" +"OriginalEntryTimestamp": "2024-02-23T17:55:31Z" +"OriginalListPrice": 1375000 +"OriginatingSystemKey": "715503967" +"OtherStructures": array:1 [ …1] +"Ownership": "Fee Simple" +"ParcelNumber": "114-007-042-10" +"ParkingFeatures": "Converted Garage,Covered,Driveway,Garage Door Opener" +"PetsAllowed": array:3 [ …3] +"PhotosChangeTimestamp": "2024-02-23T17:57:09Z" +"PhotosCount": 20 +"PoolFeatures": "Gunite,In Ground,Lighting" +"PoolPrivateYN": true +"PreviousListPrice": 1375000 +"PriceChangeTimestamp": "2024-06-25T23:41:04Z" +"PropertyCondition": array:1 [ …1] +"RoadSurfaceType": array:2 [ …2] +"Roof": "Concrete" +"SecurityFeatures": array:4 [ …4] +"Sewer": "Public Sewer" +"ShowingRequirements": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-02-23T17:55:31Z" +"StreetName": "PETUNIA 1928" +"StreetNumber": "Urb. Santa María" +"SubdivisionName": "URB. SANTA MARIA" +"TransactionBrokerCompensation": "0%" +"UniversalPropertyId": "US-72127-N-11400704210-R-N" +"Utilities": "BB/HS Internet Available,Cable Available,Electricity Available,Electricity Connected,Fiber Optics,Phone Available,Sewer Available,Sewer Connected,Street Lights,Water Available,Water Connected" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9104791" +"WaterSource": array:1 [ …1] +"Zoning": "R-1" +"MFR_ListOfficeHeadOfficeKeyNumeric": "554496465" +"MFR_LivingAreaMeters": "371.61" +"MFR_LeaseRestrictionsYN": "0" +"MFR_LotSizeSquareMeters": "850" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_MonthlyHOAAmount": "288.00" +"MFR_ListOfficeContactPreferred": "787-455-6501" +"MFR_CalculatedListPriceByCalculatedSqFt": "312.50" +"MFR_WaterAccessYN": "0" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9104791?w=Customer" +"MFR_AssociationFeeRequirement": "Required" +"MFR_EscrowState": "FL" +"MFR_YrsOfOwnerPriorToLeasingReqYN": "0" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "312.50" +"MFR_AssociationApprovalRequiredYN": "0" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Luxury awaits in the prestigious neighbourhood of Santa Maria. This home, featuring 9-foot-high ceilings and marbled floors, offers refined elegance and comfort. Enjoy spacious living areas with a swimming pool and a grand terrace. With four bedrooms, including a primary suite boasting a walk-in closet and balcony, every comfort is assured. Three full bathrooms, a 15KW electric generator, and a solar water heater add practicality. Less than half a mile away from top-rated schools, this residence epitomizes sophisticated living in a coveted locale. Don't miss the chance to call this exclusive property yours." +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9104791?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "1250000.00" +"MFR_UnitNumberYN": "0" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_PropertyDescription": "Corner Unit" +"MFR_FloodZoneCode": "X" +"MFR_TotalAcreage": "0 to less than 1/4" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "3456.00" +"MFR_ShowingConsiderations": "No Heat" +"MFR_RoomCount": "13" +"MFR_BuildingAreaTotalSrchSqM": "371.61" +"MFR_GreenVerificationCount": "0" +"MFR_MinimumLease": "8-12 Months" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "288.00" +"MFR_ExistLseTenantYN": "0" +"MFR_AvailableForLeaseYN": "1" +"MFR_PublicRemarksAgentSpanish": "¡El lujo te espera en la prestigiosa urbanización de Santa María! Esta casa, con techos de 9 pies de altura y suelos de mármol, ofrece elegancia y comodidad. Disfruta de amplias áreas de estar con una piscina y una gran terraza. Con cuatro dormitorios, incluida una suite principal con “walk-in closet” y balcón, que garantiza comodidad. Tres baños completos, un generador eléctrico de 15KW y un calentador de agua solar añaden practicidad. A menos de media milla de buenas escuelas, esta residencia ejemplifica una vida sofisticada en una ubicación codiciada. ¡No pierdas la oportunidad de llamar a esta exclusiva propiedad tuya!" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-455-6501" +"MFR_DockYN": "0" +"MFR_NonRepCompensation": "3" +"Media": array:20 [ …20] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR715503967')" +"ID": "486379" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3825 +post_id: "486382" +post_author: 1 +"ListingKey": "MFR728303179" +"ListingId": "PR9106738" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-06-10T21:54:07Z" +"RFModificationTimestamp": "2024-06-11T05:44:29Z" +"ListPrice": 4875000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 2 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 6489.0 +"BuildingAreaTotal": 6489.0 +"City": "San Juan" +"PostalCode": "00907" +"UnparsedAddress": "1365 Wilson Avenue, Haven The Residences East" +"Coordinates": array:2 [ …2] +"Latitude": 18.45278432 +"Longitude": -66.06816532 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "ORIANA JUVELIER" +"ListOfficeName": "PUERTO RICO SOTHEBY'S INTL. REALTY" +"ListAgentMlsId": "743575310" +"ListOfficeMlsId": "743580117" +"OriginatingSystemName": "Stellar" +"PublicRemarks": "Pre-Construction. To be built. Elevate your lifestyle with luxurious comfort at Haven the Residences, a brand new construction encompassing only two exclusive homes within the heart of Condado Beach. Spacious interiors/exteriors that afford a total of 6,489 Sq. Ft. and showcase the finest contemporary finishes to create an ambiance of refined elegance. Whether you’re unwinding by the pool on your private terrace with full summer kitchen or hosting gatherings in the expansive double-height great room, every corner exudes unparalleled tranquility. A private elevator, built-in features for smart home automation and an exquisite selection of bespoke materials accent this 3-level residence with 4 bedrooms, 5 bathrooms, and 2 powder rooms. Fully equipped for your culinary endeavors, the beautifully appointed Poliform kitchen features top-of-the-line appliances and butler’s pantry. The media room is the perfect setting for leisure and immersive entertainment. A study and flex gym provide additional options for wellness-focused recreational activities. The oversized primary suite is a spa-inspired sanctuary with a private balcony and a walk-in closet that connects to the luxe primary bath. All three tastefully designed guest bedrooms are also ensuite with custom walk-in closets, exhibiting true attention to detail. A dedicated laundry area and separate wet bar located on the third level complete this unprecedented offering. Inclusive of a full-power generator, water cistern and 3-car garage. Situated in one of the best residential walkable districts, Condado Beach, Haven The Residences offers all of the amenities of metropolitan living, within a beach setting. * The first seven images are renderings and do not reflect the current state of the property." +"Appliances": "Convection Oven,Dryer,Refrigerator,Washer" +"AssociationFeeIncludes": array:1 [ …1] +"AttachedGarageYN": true +"BathroomsFull": 5 +"BuildingAreaSource": "Builder" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "3%" +"CommunityFeatures": "Gated Community - No Guard" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Zoned" +"Country": "US" +"CountyOrParish": "San Juan" +"CreationDate": "2024-06-06T00:46:58.697845+00:00" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 477 +"DirectionFaces": "Southwest" +"Directions": "Head southwest on Ave. Jose de Diego/PR-37, turn right onto Estrella Street. and right onto Washington Street. Turn left at the 1st cross street onto Ave. Wilson. Destination will be on the right." +"ExteriorFeatures": "Balcony,Outdoor Grill,Outdoor Kitchen" +"Flooring": "Tile" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3" +"GarageYN": true +"Heating": "None" +"InteriorFeatures": "Built-in Features,Eat-in Kitchen,Elevator,High Ceilings,Living Room/Dining Room Combo,Walk-In Closet(s),Wet Bar" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"Levels": array:1 [ …1] +"ListAOR": "Puerto Rico" +"ListAgentAOR": "Puerto Rico" +"ListAgentDirectPhone": "787-523-6500" +"ListAgentEmail": "[email protected]" +"ListAgentKey": "507530208" +"ListOfficeKey": "507530044" +"ListOfficePhone": "787-523-6500" +"ListOfficeURL": "http://puertoricosothebysrealty.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-05" +"LivingAreaSource": "Builder" +"MLSAreaMajor": "00907 - San Juan" +"MlgCanUse": array:1 [ …1] +"MlgCanView": true +"MlsStatus": "Active" +"NewConstructionYN": true +"OccupantType": "Vacant" +"OnMarketDate": "2024-06-05" +"OriginalEntryTimestamp": "2024-06-05T19:30:25Z" +"OriginalListPrice": 4875000 +"OriginatingSystemKey": "728303179" +"Ownership": "Condominium" +"ParcelNumber": "040-050-042-12-901-02" +"PhotosChangeTimestamp": "2024-06-07T15:23:08Z" +"PhotosCount": 10 +"PoolFeatures": "Lap" +"PoolPrivateYN": true +"PropertyCondition": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"Roof": "Concrete" +"Sewer": "Public Sewer" +"ShowingRequirements": array:2 [ …2] +"SpaFeatures": array:1 [ …1] +"SpaYN": true +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "PR" +"StatusChangeTimestamp": "2024-06-05T19:30:25Z" +"StoriesTotal": "3" +"StreetName": "WILSON AVENUE EAST, HAVEN THE RESIDENCES" +"StreetNumber": "1365" +"SubdivisionName": "CONDADO" +"TransactionBrokerCompensation": "0%" +"UniversalPropertyId": "US-72127-N-0400500421290102-R-N" +"Utilities": "Electricity Available,Sewer Available,Water Available" +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/PR9106738" +"WaterSource": array:1 [ …1] +"Zoning": "X" +"MFR_ListOfficeHeadOfficeKeyNumeric": "507530044" +"MFR_LivingAreaMeters": "602.85" +"MFR_WaterViewYN": "0" +"MFR_ListingExclusionYN": "0" +"MFR_CondoLandIncludedYN": "0" +"MFR_ListOfficeContactPreferred": "787-523-6500" +"MFR_CondoFees": "0" +"MFR_CalculatedListPriceByCalculatedSqFt": "751.27" +"MFR_WaterAccessYN": "0" +"MFR_ProjectedCompletionDate": "2025-12-31T00:00:00.000" +"MFR_DPRYN": "0" +"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9106738?w=Customer" +"MFR_EscrowState": "FL" +"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "751.27" +"MFR_WaterExtrasYN": "0" +"MFR_Association2YN": "0" +"MFR_PublicRemarksAgent": "Elevate your lifestyle with luxurious comfort at Haven the Residences, a brand new construction encompassing only two exclusive homes within the heart of Condado Beach. Spacious interiors/exteriors that afford a total of 6,489 Sq. Ft. and showcase the finest contemporary finishes to create an ambiance of refined elegance. Whether you’re unwinding by the pool on your private terrace with full summer kitchen or hosting gatherings in the expansive double-height great room, every corner exudes unparalleled tranquility. A private elevator, built-in features for smart home automation and an exquisite selection of bespoke materials accent this 3-level residence with 4 bedrooms, 5 bathrooms, and 2 powder rooms. Fully equipped for your culinary endeavors, the beautifully appointed Poliform kitchen features top-of-the-line appliances and butler’s pantry. The media room is the perfect setting for leisure and immersive entertainment. A study and flex gym provide additional options for wellness-focused recreational activities. The oversized primary suite is a spa-inspired sanctuary with a private balcony and a walk-in closet that connects to the luxe primary bath. All three tastefully designed guest bedrooms are also ensuite with custom walk-in closets, exhibiting true attention to detail. A dedicated laundry area and separate wet bar located on the third level complete this unprecedented offering. Inclusive of a full-power generator, water cistern and 3-car garage. Situated in one of the best residential walkable districts, Condado Beach, Haven The Residences offers all of the amenities of metropolitan living, within a beach setting. * The first seven images are renderings and do not reflect the current state of the property." +"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/PR9106738?w=Agent&skip_sso=true" +"MFR_CurrentPrice": "4875000.00" +"MFR_UnitNumberYN": "1" +"MFR_OriginatingSystemName_": "Stellar MLS" +"MFR_FloodZoneCode": "X" +"MFR_SDEOYN": "0" +"MFR_TotalAnnualFees": "0.00" +"MFR_ShowingConsiderations": "To Be Built" +"MFR_RoomCount": "3" +"MFR_BuildingElevatorYN": "1" +"MFR_BuildingAreaTotalSrchSqM": "602.85" +"MFR_GreenVerificationCount": "0" +"MFR_FloorNumber": "1" +"MFR_InLawSuiteYN": "0" +"MFR_TotalMonthlyFees": "0.00" +"MFR_ExistLseTenantYN": "0" +"MFR_BuildingNameNumber": "HAVEN THE RESIDENCES" +"MFR_AvailableForLeaseYN": "0" +"MFR_MontlyMaintAmtAdditionToHOA": "0" +"MFR_WaterfrontFeetTotal": "0" +"MFR_AttributionContact": "787-523-6500" +"MFR_NonRepCompensation": "3%" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR728303179')" +"provider_name": "Stellar" +"Media": array:10 [ …10] +"ID": "486382" } ] +success: true +page_size: 9 +page_count: 47 +count: 423 +after_key: "" } "RF Response Time" => "0.18 seconds" ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4577 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3942 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "MFR733735325" +"ListingId": "PR9108137" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-19T15:28:09Z" +"RFModificationTimestamp": "2025-09-19T15:56:31Z" +"ListPrice": 2485000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3991.0 +"City": "Guaynabo" +"PostalCode": "00966" +"UnparsedAddress": "30 H St., Guaynabo, Puerto Rico 00966" +"Coordinates": array:2 [ …2] +"Latitude": 18.4083 +"Longitude": -66.1119 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jacqueline Lopez-Homar" +"ListOfficeName": "HOMAR REAL ESTATE" +"ListAgentMlsId": "743575075" +"ListOfficeMlsId": "743575145" +"OriginatingSystemName": "Stellar" +"PublicRemarks": """ Experience serenity in this elegant home, perched on a small hill in Villa Caparra, Guaynabo, offering stunning city views of Guaynabo and San Juan. Enjoy the privacy of this residence and the refreshing breeze from the trade winds. Located in a gated and secure community with easy access through multiple entry points, this house is an ideal retreat.\r\n The property features a beautiful terrace overlooking a patio with a stone-covered wall, where all stones have been reclaimed from the original construction. The garden includes a charming fountain, several fruit trees, and a swimming pool area complete with a full bathroom.\r\n Inside, the home boasts pristine terrazzo floors with bronze inlays, high ceilings, and large windows that bathe the space in natural light. The spacious kitchen offers a view of the patio and is accompanied by a separate laundry room and maid’s quarters. Among the seven bedrooms and six bathrooms, a separate level includes a bedroom that could serve as a guest room, plus an office.\r\n The house encompasses 3,991 square feet of living space and sits on 1,993 square meters of land. Full back up 30 kilos generator, water tank, solar water heater and much more completes this classic and special house. """ +"Appliances": array:6 [ …6] +"AssociationFee": "220" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Javier gonzalez" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 6 +"BuildingAreaSource": "Owner" +"BuildingAreaUnits": "Square Feet" +"CarportSpaces": "3" +"CarportYN": true +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:2 [ …2] +"Country": "US" +"CountyOrParish": "Guaynabo" +"CreationDate": "2024-08-14T19:10:28.943953+00:00" +"CumulativeDaysOnMarket": 399 +"DaysOnMarket": 406 +"DirectionFaces": "South" +"Directions": "If going West on Road # 2, make a right at the entrance of Villa Caparra subdivision." +"ExteriorFeatures": array:8 [ …8] +"Flooring": array:2 [ …2] +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:1 [ …1] +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true …92 } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3944 …133} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3941 …156} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3943 …153} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3940 …113} ] +success: true +page_size: 5 +page_count: 351 +count: 1752 +after_key: "" } ] ]