$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1996) "Price improvement! Now is your opportunity to own this gorgeous home in a go...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
Price improvement! Now is your opportunity to own this gorgeous home in a golf course/waterfront gated community! Bring the beautiful Florida outdoors right into your triple-sliding-door living room, with the inviting covered lanai on this immaculate Osprey Cove lagoon-like screen-enclosed pool Home by Hickson Construction Co. This home backs up to a fairway at Turnbull Bay Preserve golf course, which gives you both privacy and good views from the pool area, and is across the street from the homes with docks on Turnbull Bay. Enjoy the breezes! True to form, this Hickson home has all of the custom features you have come to expect: Extensive use of crown molding; high ceilings; over-window transoms; upgraded trim and solid-core wood doors; bull-nose drywall corners; Corian counters throughout with solid wood cabinets; and the popular Hickson 34' front porch complete with porch swing! There is also a cute side porch off the garage. Other features that will catch your eye include extra storage closets, mirrored walls and walk-in closet in the workout room (BR 2), Cat 5 wiring, surround sound with porch speakers, upgraded lighting, 3-car garage, beautiful landscaping, and a screened-in solar heated salt water pool with flagstone wall pool fountain. Plantation Shutters in DR and Study front windows, Bahama-like awnings on the side windows, roll-down hurricane shutters on the back with aluminum panels for front windows. Osprey Cove is a quiet gated community on Turnbull Bay with 2 cul de sacs, sidewalks, front porches, neighborhood get-togethers. Uniquely, one side of the street fronts the golf course and the other side fronts Turnbull Bay. Even though when you are home it may feel far from the hustle and bustle of the world, it is just a short drive to shopping, restaurants and pubs, and New Smyrna's beautiful beaches. The new nearby I-95/Pioneer Trail interchange, when completed, makes it easy to enjoy Port Orange and all its amenities too. This really is a must see!
⇄⧉public Appliances -> string (101) "Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Range,Range...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Appliances
Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Range,Range Hood,Refrigerator,Washer
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 527
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 330
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DaysOnMarket
⇄public DirectionFaces -> string (4) "East"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DirectionFaces
⇄⧉public Directions -> string (154) "US 1 to Turnbull Bay Road, right into Turnbull Bay Estates, turn right at Os...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Directions
US 1 to Turnbull Bay Road, right into Turnbull Bay Estates, turn right at Osprey Cove entrance and gate. Go right onto Bay Side Drive, house on the right.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1996) "Price improvement! Now is your opportunity to own this gorgeous home in a go...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_PublicRemarksAgent
Price improvement! Now is your opportunity to own this gorgeous home in a golf course/waterfront gated community! Bring the beautiful Florida outdoors right into your triple-sliding-door living room, with the inviting covered lanai on this immaculate Osprey Cove lagoon-like screen-enclosed pool Home by Hickson Construction Co. This home backs up to a fairway at Turnbull Bay Preserve golf course, which gives you both privacy and good views from the pool area, and is across the street from the homes with docks on Turnbull Bay. Enjoy the breezes! True to form, this Hickson home has all of the custom features you have come to expect: Extensive use of crown molding; high ceilings; over-window transoms; upgraded trim and solid-core wood doors; bull-nose drywall corners; Corian counters throughout with solid wood cabinets; and the popular Hickson 34' front porch complete with porch swing! There is also a cute side porch off the garage. Other features that will catch your eye include extra storage closets, mirrored walls and walk-in closet in the workout room (BR 2), Cat 5 wiring, surround sound with porch speakers, upgraded lighting, 3-car garage, beautiful landscaping, and a screened-in solar heated salt water pool with flagstone wall pool fountain. Plantation Shutters in DR and Study front windows, Bahama-like awnings on the side windows, roll-down hurricane shutters on the back with aluminum panels for front windows. Osprey Cove is a quiet gated community on Turnbull Bay with 2 cul de sacs, sidewalks, front porches, neighborhood get-togethers. Uniquely, one side of the street fronts the golf course and the other side fronts Turnbull Bay. Even though when you are home it may feel far from the hustle and bustle of the world, it is just a short drive to shopping, restaurants and pubs, and New Smyrna's beautiful beaches. The new nearby I-95/Pioneer Trail interchange, when completed, makes it easy to enjoy Port Orange and all its amenities too. This really is a must see!
⇄public MFR_ZoningCompatibleYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ZoningCompatibleYN
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2346) "**MAJOR PRICE REDUCTION – NOW ONLY $375,000! BRAND-NEW | 4 BEDROOMS | APPROX...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
**MAJOR PRICE REDUCTION – NOW ONLY $375,000! BRAND-NEW | 4 BEDROOMS | APPROX. 2,335 SQ. FT. | MOVE-IN READY | NO CDD | ONLY $1,000 TO SECURE!** Don’t miss this exceptional opportunity at **4002 Sagefield Drive in St. Cloud!** This spacious two-story home offers approximately **2,335 sq. ft., 4 bedrooms, 2.5 bathrooms, and an oversized loft**—all for just **$375,000!**
Step inside and discover a spacious, open floor plan designed for today’s lifestyle. The kitchen serves as the heart of the home and features **granite countertops and a large center island**, providing plenty of space for everyday meals, entertaining, and gathering with family and friends.
Upstairs, an **OVERSIZED LOFT** provides valuable additional living space and endless possibilities—create a second family room, media room, game room, home office, or play area. Four generously sized bedrooms provides even more flexibility for family, guests, or working from home.
Everything is **BRAND-NEW AND MOVE-IN READY**, allowing you to enjoy the benefits of new construction without the renovations, updates, and maintenance concerns that can come with an older resale home.
And here’s another major advantage—**NO CDD!** Enjoy a brand-new home in Harmony Central without the additional recurring CDD expense commonly found in many new construction communities.
The savings continue at closing! Secure this home with **ONLY A $1,000 DEPOSIT**, and when using a preferred lender, the **BUILDER PAYS ALL CLOSING COSTS EXCEPT PREPAIDS**, potentially saving qualified buyers thousands of dollars at closing.
**$375,000 + 4 BEDROOMS + 2.5 BATHROOMS + APPROX. 2,335 SQ. FT. + OVERSIZED LOFT + BRAND-NEW + MOVE-IN READY + NO CDD + BUILDER-PAID CLOSING COSTS!**
If you previously considered this home, **TAKE ANOTHER LOOK!** The price has changed—and so has the opportunity. If you’ve been searching for a spacious **brand-new 4-bedroom home under $400,000 in St. Cloud**, this one deserves your attention.
**DON’T JUST SAVE THIS HOME ONLINE—SCHEDULE YOUR PRIVATE SHOWING TODAY and experience 4002 Sagefield Drive in person before someone else takes advantage of this new price!**
*Builder-paid closing costs exclude prepaids and require the use of a preferred lender. Buyer qualification and applicable program requirements apply.*
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 323
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 375
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DaysOnMarket
⇄public DirectionFaces -> string (5) "North"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DirectionFaces
⇄⧉public Directions -> string (154) "Take 192 towards St. Cloud continue to go pass Harmony High-school you will ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->Directions
Take 192 towards St. Cloud continue to go pass Harmony High-school you will shortly see the community on the left hand side of 192 following Harmony Main.
⇄public ElementarySchool -> string (30) "Harmony Community School (K-5)"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->ElementarySchool
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_AttributionContact
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2346) "**MAJOR PRICE REDUCTION – NOW ONLY $375,000! BRAND-NEW | 4 BEDROOMS | APPROX...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
**MAJOR PRICE REDUCTION – NOW ONLY $375,000! BRAND-NEW | 4 BEDROOMS | APPROX. 2,335 SQ. FT. | MOVE-IN READY | NO CDD | ONLY $1,000 TO SECURE!** Don’t miss this exceptional opportunity at **4002 Sagefield Drive in St. Cloud!** This spacious two-story home offers approximately **2,335 sq. ft., 4 bedrooms, 2.5 bathrooms, and an oversized loft**—all for just **$375,000!**
Step inside and discover a spacious, open floor plan designed for today’s lifestyle. The kitchen serves as the heart of the home and features **granite countertops and a large center island**, providing plenty of space for everyday meals, entertaining, and gathering with family and friends.
Upstairs, an **OVERSIZED LOFT** provides valuable additional living space and endless possibilities—create a second family room, media room, game room, home office, or play area. Four generously sized bedrooms provides even more flexibility for family, guests, or working from home.
Everything is **BRAND-NEW AND MOVE-IN READY**, allowing you to enjoy the benefits of new construction without the renovations, updates, and maintenance concerns that can come with an older resale home.
And here’s another major advantage—**NO CDD!** Enjoy a brand-new home in Harmony Central without the additional recurring CDD expense commonly found in many new construction communities.
The savings continue at closing! Secure this home with **ONLY A $1,000 DEPOSIT**, and when using a preferred lender, the **BUILDER PAYS ALL CLOSING COSTS EXCEPT PREPAIDS**, potentially saving qualified buyers thousands of dollars at closing.
**$375,000 + 4 BEDROOMS + 2.5 BATHROOMS + APPROX. 2,335 SQ. FT. + OVERSIZED LOFT + BRAND-NEW + MOVE-IN READY + NO CDD + BUILDER-PAID CLOSING COSTS!**
If you previously considered this home, **TAKE ANOTHER LOOK!** The price has changed—and so has the opportunity. If you’ve been searching for a spacious **brand-new 4-bedroom home under $400,000 in St. Cloud**, this one deserves your attention.
**DON’T JUST SAVE THIS HOME ONLINE—SCHEDULE YOUR PRIVATE SHOWING TODAY and experience 4002 Sagefield Drive in person before someone else takes advantage of this new price!**
*Builder-paid closing costs exclude prepaids and require the use of a preferred lender. Buyer qualification and applicable program requirements apply.*
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1141) "Priced to sell quickly !!! HUGE $51,900 IN PRICE REDUCTION !!! Closing Costs...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->PublicRemarks
Priced to sell quickly !!! HUGE $51,900 IN PRICE REDUCTION !!! Closing Costs Paid that will bring an easily estimated monthly payment of $2,500's with everything included also including estimated real property taxes, NOT just Land Taxes Only. This means an easily $381 monthly savings over current market rate with our preferred lender!!! Not only stop here, but we are also a NO CDD community. This is Limited time opportunity to reserve this huge home with only $1,000 that bring great value at lower price.
Welcome to the stunning 2-story 2202 floorplan by Adams Homes — featuring 4 spacious bedrooms, 2.5 baths, an open-concept layout, and a modern kitchen with a large island and ample storage. Upstairs you’ll find a private owner’s suite with en-suite bath and big walk-in closet, plus 3 versatile guest bedrooms. Enjoy outdoor living with our beautiful, covered lanai.
Located in Harmony Central, the final phase of a beautiful master-planned community near golf courses, top-rated schools, a community pool & cabana, and scenic green spaces. Just minutes from Lake Nona, the FL Turnpike, and charming downtown St. Cloud.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 234
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 286
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->DaysOnMarket
⇄public DirectionFaces -> string (9) "Southwest"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->DirectionFaces
⇄⧉public Directions -> string (161) "From Narcoossee Rd take 192 East for 8 miles towards Melbourne, continue pas...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->Directions
From Narcoossee Rd take 192 East for 8 miles towards Melbourne, continue past Harmony High-school and Harmony Main, Harmony Central will be located on your left.
⇄public ElementarySchool -> string (30) "Harmony Community School (K-5)"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->ElementarySchool
⇄public ExteriorFeatures -> string (8) "Sidewalk"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->ExteriorFeatures
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_AttributionContact
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1141) "Priced to sell quickly !!! HUGE $51,900 IN PRICE REDUCTION !!! Closing Costs...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_PublicRemarksAgent
Priced to sell quickly !!! HUGE $51,900 IN PRICE REDUCTION !!! Closing Costs Paid that will bring an easily estimated monthly payment of $2,500's with everything included also including estimated real property taxes, NOT just Land Taxes Only. This means an easily $381 monthly savings over current market rate with our preferred lender!!! Not only stop here, but we are also a NO CDD community. This is Limited time opportunity to reserve this huge home with only $1,000 that bring great value at lower price.
Welcome to the stunning 2-story 2202 floorplan by Adams Homes — featuring 4 spacious bedrooms, 2.5 baths, an open-concept layout, and a modern kitchen with a large island and ample storage. Upstairs you’ll find a private owner’s suite with en-suite bath and big walk-in closet, plus 3 versatile guest bedrooms. Enjoy outdoor living with our beautiful, covered lanai.
Located in Harmony Central, the final phase of a beautiful master-planned community near golf courses, top-rated schools, a community pool & cabana, and scenic green spaces. Just minutes from Lake Nona, the FL Turnpike, and charming downtown St. Cloud.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1122) "A Rare Opportunity on North Siesta Key with exceptional weekly income, prime...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->PublicRemarks
A Rare Opportunity on North Siesta Key with exceptional weekly income, prime location 350 Feet of Waterfront!
Discover this unique multi-family income producing single-story property on Bay Island, offering both beauty and potential. High and dry, the home remained unaffected by recent storms, with 4–5 feet of elevation to spare. Set on a tranquil, tropical lot, this historic location on Garden Lane—once home to the Siesta Key Fish Market—with easy fast access to the bay and Big Pass it is truly a boater’s and fisherman’s paradise. Just a few steps to Shell Beach and its breathtaking sunsets, minutes from the world famous Siesta Beach, Siesta Village with restaurants, shopping, nightlife, quick access to downtown, and St. Armands Circle. You have it all!
The property features a classic Florida ranch-style 4-bedroom, 2-bathroom home with a pool, large deck, and lush backyard designed for entertaining, plus a detached 2-bedroom, 2-bathroom guest house. Whether you choose to renovate, rebuild, or divide the lot (buyers to verify with the City), the possibilities are endless with this property!
⇄public Appliances -> string (61) "Dishwasher,Dryer,Electric Water Heater,Microwave,Range,Washer"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Appliances
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 363
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 415
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->DaysOnMarket
⇄public DirectionFaces -> string (4) "West"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->DirectionFaces
⇄⧉public Directions -> string (156) "Take the North Siesta Key bridge onto the island and continue over the hump ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Directions
Take the North Siesta Key bridge onto the island and continue over the hump back bridge around the large corner. Garden Lane is the 3rd. street on the left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->SubdivisionName
⇄public TaxAnnualAmount -> string (8) "12545.28"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxAnnualAmount
⇄public TaxBlock -> string (2) "23"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxBlock
⇄public TaxBookNumber -> string (4) "A-38"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxBookNumber
⇄⧉public TaxLegalDescription -> string (163) "LOTS 2 & 3, BLK 23 & LOTS 4 & 5, BLK 22 & VAC ST BETWEEN SAID LOTS & E 1/2 V...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxLegalDescription
LOTS 2 & 3, BLK 23 & LOTS 4 & 5, BLK 22 & VAC ST BETWEEN SAID LOTS & E 1/2 VAC ST W LOT 3 BLK 23 REVISED PLAT OF SIESTA, BEING SAME LANDS AS DESC IN ORI 2016003221
⇄public TaxLot -> string (1) "2"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxLot
⇄public TaxYear -> string (4) "2024"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxYear
⇄public Township -> string (3) "36S"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Township
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_AttributionContact
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1122) "A Rare Opportunity on North Siesta Key with exceptional weekly income, prime...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_PublicRemarksAgent
A Rare Opportunity on North Siesta Key with exceptional weekly income, prime location 350 Feet of Waterfront!
Discover this unique multi-family income producing single-story property on Bay Island, offering both beauty and potential. High and dry, the home remained unaffected by recent storms, with 4–5 feet of elevation to spare. Set on a tranquil, tropical lot, this historic location on Garden Lane—once home to the Siesta Key Fish Market—with easy fast access to the bay and Big Pass it is truly a boater’s and fisherman’s paradise. Just a few steps to Shell Beach and its breathtaking sunsets, minutes from the world famous Siesta Beach, Siesta Village with restaurants, shopping, nightlife, quick access to downtown, and St. Armands Circle. You have it all!
The property features a classic Florida ranch-style 4-bedroom, 2-bathroom home with a pool, large deck, and lush backyard designed for entertaining, plus a detached 2-bedroom, 2-bathroom guest house. Whether you choose to renovate, rebuild, or divide the lot (buyers to verify with the City), the possibilities are endless with this property!
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2196) "2BR/2BA Condo in The Madison, located in the Waterfront District of downtown...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->PublicRemarks
2BR/2BA Condo in The Madison, located in the Waterfront District of downtown St. Petersburg.
Welcome to The Madison, located in the Waterfront District of downtown St. Petersburg. 2br/2ba/covered garage, one assigned parking. Annual/Unfurnished rental. This Mediterranean style building is gated and complete with tropical landscaping, swimming pool, clubhouse, workout room, grills, outdoor seating, and is close to everything! Easy access to Publix, shops, museums, fine dining, live entertainment and sports venues, farmers market, USF St. Pete Campus, hospitals, banks, dali museum, the pier, Al Lang Stadium and list goes on. The unit features high ceilings 10 ft, open/split concept floor plan, freshly painted, dual master suites with large bathrooms, walkin in closets, a large soak bathtub in one and standing shower in the other, laundry room with newer full size washer and dryer, open balcony overlooking pool courtyard, extra storage, updated kitchen and baths, newer luxury vinyl plank flooring, newer HVAC, newer water heater, and a parking spot located in the garage #194. Home has an open and airy floor plan with lots of natural lighting. This is resort style living at it's best! First full month's rent and equal security deposit apply. Water Sewer Trash & basic cable/internet included. No pets. HOA fee: garage transmitter sticker for $25.00, $150 application fee for association.
If you decide to apply for one of our properties:
Screening includes credit/background check, income verification of 2.5 to 3 times the monthly rent and rental history verification.
APPLICANT CHARGES:
Application Fee: $75 each adult, 18 years of age and older (non-refundable).
Lease Initiation Admin Fee: $150.00 after approval and upon signing.
Security Deposit: Equal to one month’s rent on approved credit.
All Rent Solutions residents are enrolled in the Resident Benefits Package (RBP) for $49.95/month which includes liability insurance, credit building to help boost the resident’s credit score with timely rent payments, HVAC air filter delivery (for applicable properties), our best-in-class resident rewards program, and much more! More details upon application.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_AttributionContact
⇄public MFR_BuildingElevatorYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_BuildingElevatorYN
⇄public MFR_BuildingNameNumber -> string (11) "THE MADISON"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_BuildingNameNumber
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2196) "2BR/2BA Condo in The Madison, located in the Waterfront District of downtown...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_PublicRemarksAgent
2BR/2BA Condo in The Madison, located in the Waterfront District of downtown St. Petersburg.
Welcome to The Madison, located in the Waterfront District of downtown St. Petersburg. 2br/2ba/covered garage, one assigned parking. Annual/Unfurnished rental. This Mediterranean style building is gated and complete with tropical landscaping, swimming pool, clubhouse, workout room, grills, outdoor seating, and is close to everything! Easy access to Publix, shops, museums, fine dining, live entertainment and sports venues, farmers market, USF St. Pete Campus, hospitals, banks, dali museum, the pier, Al Lang Stadium and list goes on. The unit features high ceilings 10 ft, open/split concept floor plan, freshly painted, dual master suites with large bathrooms, walkin in closets, a large soak bathtub in one and standing shower in the other, laundry room with newer full size washer and dryer, open balcony overlooking pool courtyard, extra storage, updated kitchen and baths, newer luxury vinyl plank flooring, newer HVAC, newer water heater, and a parking spot located in the garage #194. Home has an open and airy floor plan with lots of natural lighting. This is resort style living at it's best! First full month's rent and equal security deposit apply. Water Sewer Trash & basic cable/internet included. No pets. HOA fee: garage transmitter sticker for $25.00, $150 application fee for association.
If you decide to apply for one of our properties:
Screening includes credit/background check, income verification of 2.5 to 3 times the monthly rent and rental history verification.
APPLICANT CHARGES:
Application Fee: $75 each adult, 18 years of age and older (non-refundable).
Lease Initiation Admin Fee: $150.00 after approval and upon signing.
Security Deposit: Equal to one month’s rent on approved credit.
All Rent Solutions residents are enrolled in the Resident Benefits Package (RBP) for $49.95/month which includes liability insurance, credit building to help boost the resident’s credit score with timely rent payments, HVAC air filter delivery (for applicable properties), our best-in-class resident rewards program, and much more! More details upon application.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1089) "This 4-bedroom, 2-bath single-family home offers a functional layout with sp...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->PublicRemarks
This 4-bedroom, 2-bath single-family home offers a functional layout with spacious rooms and a generous primary suite. Brand-new flooring has been installed throughout the home, giving the interior a consistent, updated finish. The layout provides comfortable separation between the bedrooms and main living areas, with plenty of room for everyday living.
The spacious primary bedroom provides additional flexibility for furnishings and personal use. The home has been well maintained and features a screened-in garage and front door, providing covered space while allowing for airflow and added protection from the elements. The fenced-in property creates a defined outdoor area with added privacy.
Additional features include the practical floor plan, spacious secondary rooms, and low-maintenance flooring throughout. The fenced yard provides usable exterior space for a variety of needs while keeping the property clearly defined.
Located in Tampa with convenient access to major roadways, shopping, dining, entertainment, and all kinds of amenities Tampa has to offer No HOA.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->CreationDate
⇄public DirectionFaces -> string (5) "South"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->DirectionFaces
⇄⧉public Directions -> string (161) "From I-4, use Exit 1 toward N 21st St/N 22nd St. Merge onto N 21st St, then ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Directions
From I-4, use Exit 1 toward N 21st St/N 22nd St. Merge onto N 21st St, then turn right onto E 7th Ave. Turn right onto 9th Ave; the property will be on the left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1089) "This 4-bedroom, 2-bath single-family home offers a functional layout with sp...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_PublicRemarksAgent
This 4-bedroom, 2-bath single-family home offers a functional layout with spacious rooms and a generous primary suite. Brand-new flooring has been installed throughout the home, giving the interior a consistent, updated finish. The layout provides comfortable separation between the bedrooms and main living areas, with plenty of room for everyday living.
The spacious primary bedroom provides additional flexibility for furnishings and personal use. The home has been well maintained and features a screened-in garage and front door, providing covered space while allowing for airflow and added protection from the elements. The fenced-in property creates a defined outdoor area with added privacy.
Additional features include the practical floor plan, spacious secondary rooms, and low-maintenance flooring throughout. The fenced yard provides usable exterior space for a variety of needs while keeping the property clearly defined.
Located in Tampa with convenient access to major roadways, shopping, dining, entertainment, and all kinds of amenities Tampa has to offer No HOA.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1198) "Presenting an exceptional waterfront opportunity on desirable Indian Rocks B...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->PublicRemarks
Presenting an exceptional waterfront opportunity on desirable Indian Rocks Beach, this is an opportunity not to be missed! Situated on a generous lot of over 7,000 square feet with an impressive 65 feet of deep water frontage, this property features a robust seawall—offering an invaluable head start and solid foundation for your coastal vision. The existing structure, which sustained damage during the recent hurricane and is being sold as-is, currently features a functional split-floor plan with three bedrooms, two bathrooms, an air-conditioned Florida room, an in-ground pool, dedicated storage spaces, and a wide driveway. This is a premier blank canvas for investors, builders, or visionary homeowners looking to craft a personalized beachside haven in an exclusive community. Embrace the IRB lifestyle where your days can be spent boating and fishing right from your backyard, taking a stroll to the beaches and local parks, fine dining, and shopping, or enjoying a short drive to world-class golf destinations. Do not miss this outstanding chance to claim your slice of paradise and build or re-create the waterfront home of your dreams in this peaceful, highly desirable seaside town.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->CreationDate
⇄public DirectionFaces -> string (5) "North"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->DirectionFaces
⇄⧉public Directions -> string (165) "West on Walsingham Rd, to north on Gulf Blvd, to east on 8th Ave, to north o...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Directions
West on Walsingham Rd, to north on Gulf Blvd, to east on 8th Ave, to north on E Gulf Blvd, to east on La Hacienda Dr, the property is on the south end of the street.
⇄public ExteriorFeatures -> string (8) "Lighting"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->ExteriorFeatures
⇄⧉public Fencing -> array (1)
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Fencing
⇄0 => string (4) "Wood"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Fencing[0]
⇄public Flooring -> string (13) "Terrazzo,Tile"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Flooring
⇄⧉public FoundationDetails -> array (1)
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->FoundationDetails
⇄0 => string (4) "Slab"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->FoundationDetails[0]
⇄public Furnished -> string (11) "Unfurnished"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Furnished
⇄public Heating -> string (7) "Central"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Heating
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1198) "Presenting an exceptional waterfront opportunity on desirable Indian Rocks B...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_PublicRemarksAgent
Presenting an exceptional waterfront opportunity on desirable Indian Rocks Beach, this is an opportunity not to be missed! Situated on a generous lot of over 7,000 square feet with an impressive 65 feet of deep water frontage, this property features a robust seawall—offering an invaluable head start and solid foundation for your coastal vision. The existing structure, which sustained damage during the recent hurricane and is being sold as-is, currently features a functional split-floor plan with three bedrooms, two bathrooms, an air-conditioned Florida room, an in-ground pool, dedicated storage spaces, and a wide driveway. This is a premier blank canvas for investors, builders, or visionary homeowners looking to craft a personalized beachside haven in an exclusive community. Embrace the IRB lifestyle where your days can be spent boating and fishing right from your backyard, taking a stroll to the beaches and local parks, fine dining, and shopping, or enjoying a short drive to world-class golf destinations. Do not miss this outstanding chance to claim your slice of paradise and build or re-create the waterfront home of your dreams in this peaceful, highly desirable seaside town.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (316) "Welcome to this inviting three-bedroom, two-bath home in Ocala. The comforta...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->PublicRemarks
Welcome to this inviting three-bedroom, two-bath home in Ocala. The comfortable floor plan features well-proportioned, versatile living spaces ideal for everyday living, entertaining, or working from home. Situated in a quiet community, this property is ready for its next owner. Schedule your private showing today.
⇄public Appliances -> string (59) "Disposal,Electric Water Heater,Microwave,Range,Refrigerator"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Appliances
⇄public AttachedGarageYN -> boolean true
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->AttachedGarageYN
⇄public BathroomsFull -> integer 2
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->BathroomsFull
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->CreationDate
⇄public DirectionFaces -> string (4) "East"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->DirectionFaces
⇄⧉public Directions -> string (214) "From SW 17th Street in Ocala, travel east and continue onto SE Maricamp Road...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Directions
From SW 17th Street in Ocala, travel east and continue onto SE Maricamp Road. Turn right onto Locust Road, then right onto Locust Run. Turn right onto Locust Run Radial and continue to 38 Locust Run Radial on left.
⇄public ExteriorFeatures -> string (4) "None"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->ExteriorFeatures
⇄public Flooring -> string (8) "Laminate"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Flooring
⇄⧉public FoundationDetails -> array (1)
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->FoundationDetails
⇄0 => string (4) "Slab"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->FoundationDetails[0]
⇄public Furnished -> string (11) "Unfurnished"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Furnished
⇄public GarageSpaces -> string (1) "2"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->GarageSpaces
⇄public GarageYN -> boolean true
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->GarageYN
⇄public Heating -> string (7) "Central"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Heating
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (316) "Welcome to this inviting three-bedroom, two-bath home in Ocala. The comforta...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_PublicRemarksAgent
Welcome to this inviting three-bedroom, two-bath home in Ocala. The comfortable floor plan features well-proportioned, versatile living spaces ideal for everyday living, entertaining, or working from home. Situated in a quiet community, this property is ready for its next owner. Schedule your private showing today.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1626) "This recently constructed 2024 contemporary custom-built home has it all. En...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->PublicRemarks
This recently constructed 2024 contemporary custom-built home has it all. Enjoy breathtaking wide open Intracoastal Waterway views from every room in the house! Beautiful solid white oak stair treads with a welded aluminum stair frame, beautifully lighted. The mid-level features a great room plan with incredible panoramic water views. A gourmet kitchen with gleaming marble surfaces, quality stainless steel appliances, gas cooking, a pot filler, custom cabinetry and a huge center island. The second-level covered porch overlooks the water. Hardwired for music throughout every level, inside and out. Large principal bedroom with cathedral ceilings that extend into the luxurious bathroom, complete with a soaking tub, separate shower, and top-of-the-line fixtures. The third level includes a guest suite, a third bedroom, two bathrooms and another balcony with fantastic Intracoastal views. The first level has all the room you need for cars, tools and toys. The garage is 30 x 33 with an epoxied floor and 2 electric car charging stations. The lower level has a covered patio that overlooks the salt water pool and spa (travertine tile deck) . This home is equipped with Solar power, a generator, natural gas for the cooktop & dryer, and a propane system that runs the Generac generator, pool heater & water heater (The electric bill in the summer is approximately $270). Pool and spa. 13,000-pound boat lift, jet ski lift & kayak rack. Second and third-floor balconies include filtered water power washers for easy maintenance. New seawall. There is also an assumable $1,200,000 loan at 3.375% (Buyer must be qualified).
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->Appliances
Built-In Oven,Convection Oven,Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Range Hood,Refrigerator,Tankless Water Heater,Washer,Water Softener
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1626) "This recently constructed 2024 contemporary custom-built home has it all. En...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_PublicRemarksAgent
This recently constructed 2024 contemporary custom-built home has it all. Enjoy breathtaking wide open Intracoastal Waterway views from every room in the house! Beautiful solid white oak stair treads with a welded aluminum stair frame, beautifully lighted. The mid-level features a great room plan with incredible panoramic water views. A gourmet kitchen with gleaming marble surfaces, quality stainless steel appliances, gas cooking, a pot filler, custom cabinetry and a huge center island. The second-level covered porch overlooks the water. Hardwired for music throughout every level, inside and out. Large principal bedroom with cathedral ceilings that extend into the luxurious bathroom, complete with a soaking tub, separate shower, and top-of-the-line fixtures. The third level includes a guest suite, a third bedroom, two bathrooms and another balcony with fantastic Intracoastal views. The first level has all the room you need for cars, tools and toys. The garage is 30 x 33 with an epoxied floor and 2 electric car charging stations. The lower level has a covered patio that overlooks the salt water pool and spa (travertine tile deck) . This home is equipped with Solar power, a generator, natural gas for the cooktop & dryer, and a propane system that runs the Generac generator, pool heater & water heater (The electric bill in the summer is approximately $270). Pool and spa. 13,000-pound boat lift, jet ski lift & kayak rack. Second and third-floor balconies include filtered water power washers for easy maintenance. New seawall. There is also an assumable $1,200,000 loan at 3.375% (Buyer must be qualified).
⇄public MFR_ZoningCompatibleYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_ZoningCompatibleYN
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_LeaseRestrictionsYN
new \Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse($body)
/**
* RFResponse constructor.
*/
Defined in <ROOT>/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/RFClient/SDK/RF/RFResponse.php:43
⇄RF Response Time => string (11) "0.1 seconds"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=160&$filter=(Appliances eq \'Ceiling Fans(s)\' OR ArchitecturalStyle eq \'Ceiling Fans(s)\' OR CommunityFeatures eq \'Ceiling Fans(s)\' OR Cooling eq \'Ceiling Fans(s)\' OR CountyOrParish eq \'Ceiling Fans(s)\' OR ElementarySchool eq \'Ceiling Fans(s)\' OR ExteriorFeatures eq \'Ceiling Fans(s)\' OR Flooring eq \'Ceiling Fans(s)\' OR Heating eq \'Ceiling Fans(s)\' OR HighSchool eq \'Ceiling Fans(s)\' OR InteriorFeatures eq \'Ceiling Fans(s)\' OR ListingTerms eq \'Ceiling Fans(s)\' OR MiddleOrJuniorSchool eq \'Ceiling Fans(s)\' OR ParkingFeatures eq \'Ceiling Fans(s)\' OR PoolFeatures eq \'Ceiling Fans(s)\' OR PropertyType eq \'Ceiling Fans(s)\' OR Roof eq \'Ceiling Fans(s)\' OR SchoolDistrict eq \'Ceiling Fans(s)\' OR Sewer eq \'Ceiling Fans(s)\' OR Utilities eq \'Ceiling Fans(s)\' OR WaterfrontFeatures eq \'Ceiling Fans(s)\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']
