Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1462 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1462 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1462 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2301 Collins Ave
Miami Beach, FL 33139

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $10,000
Beds: 1
Baths: Full: 1, ½: 1
Status: Active
SqFt: 960 Square Feet
Agency: XLS Realty LLC
Agency Phone: (305) 282-5725

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Oven, Washer, Microwave, Range, Refrigerator, Dryer
Architectural Style: Other
Construction Materials: Block
Rooms: Bathroom 1, Bathroom 2, Bedroom 1

Window Features

Exterior Features: Security High Impact Doors
Parking Features: Garage, Valet
View: Ocean
Waterfront Features: Waterfront, Ocean Access, Ocean Front

Neighborhood/Schools

Elementary School/District: North Miami/North Miami Community Schools
Middle/Junior High School/District:
High School/District: Miami Beach
Subvidision Name: Roney Palace Condo

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential Lease-Condominium
Year Built: 1926
Notes: Brand New Renovation! Fully Furnished Jr. 2 bed (1 +Den Bedroom), 2 full bathrooms residence with direct ocean front balcony. <br /> <br /> One of the best lines in the building, this spacious corner condo boasts a sunny southeastern exposure. <br /> <br /> Newly renovated with high-quality finishes and washer-dryer in unit. <br /> <br /> Electricity, cable, WiFi, water and 1 Valet. <br /> <br /> Situated inside the same building as the luxurious 1 Hotel, Roney Palace residents enjoy the best of South Beach with access to 3 oceanfront swimming pools, a hot tub and beach service. <br /> <br /> Onsite restaurants include Habitat, STK South Beach, Plnthouse organic café, Watr at the 1 Hotel Rooftop! <br /> <br /> Home to SoulCycle, Anatomy Gym, high-end spa, salon and retail fashion boutiques. <br /> <br /> Valet parking, full-time security, and more...
MlsNumber: --
ListingId: A11550867


Listing Provided By: XLS Realty LLC, original listing
Phone: (305) 901-1422
Office Phone: (305) 282-5725
Agent Name: David Sotolongo
Disclaimer: Copyright © 2024 MIAMI Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App