$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1815) "Wake up to peaceful water and golf course views from this beautifully mainta...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
Wake up to peaceful water and golf course views from this beautifully maintained second floor condo in Oakmont Village at The Hideaway Country Club. Featuring 3 bedrooms and 2 bathrooms, this bright and spacious residence provides a comfortable layout filled with natural light and inviting Florida charm. The open living and dining area features a vaulted ceiling, neutral finishes, tile flooring, ceiling fans, and large sliding glass doors that showcase the scenic surroundings. The kitchen provides abundant cabinet and counter space, a breakfast bar, appliances, and an open connection to the main living area. The spacious primary bedroom includes a ceiling fan, generous closet space, and convenient access to a private bathroom with an extended vanity and walk in shower. The additional bedroom is bright and comfortably sized, while the separate den provides flexible space for a home office, guest area, reading room, or hobby space. An interior laundry area adds everyday convenience. Step through the sliding glass doors onto the private screened lanai and enjoy relaxing views of the landscaped grounds, and golf course. Whether enjoying a quiet morning or unwinding at the end of the day, this outdoor space is a standout feature of the home. Additional highlights include covered assigned parking, a community pool, maintained tropical landscaping, and a gated golf community setting. Conveniently located near shopping, dining, entertainment, major roadways, the airport, and Southwest Florida beaches, this condo combines comfort, scenery, and convenience. Clean, welcoming, and ready for its next owner, this property is a wonderful choice for a primary residence, seasonal getaway, or investment opportunity. Schedule your private showing and experience everything this Fort Myers condo provides!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->CreationDate
⇄public DirectionFaces -> string (4) "West"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DirectionFaces
⇄⧉public Directions -> string (195) "From Daniels Pkwy, head north on Metro Pkwy. Turn left onto Crystal Dr, then...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Directions
From Daniels Pkwy, head north on Metro Pkwy. Turn left onto Crystal Dr, then right onto Trailwinds Dr. Proceed through The Hideaway Country Club gate and continue to 5925 Trailwinds Dr, Unit 925.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1815) "Wake up to peaceful water and golf course views from this beautifully mainta...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_PublicRemarksAgent
Wake up to peaceful water and golf course views from this beautifully maintained second floor condo in Oakmont Village at The Hideaway Country Club. Featuring 3 bedrooms and 2 bathrooms, this bright and spacious residence provides a comfortable layout filled with natural light and inviting Florida charm. The open living and dining area features a vaulted ceiling, neutral finishes, tile flooring, ceiling fans, and large sliding glass doors that showcase the scenic surroundings. The kitchen provides abundant cabinet and counter space, a breakfast bar, appliances, and an open connection to the main living area. The spacious primary bedroom includes a ceiling fan, generous closet space, and convenient access to a private bathroom with an extended vanity and walk in shower. The additional bedroom is bright and comfortably sized, while the separate den provides flexible space for a home office, guest area, reading room, or hobby space. An interior laundry area adds everyday convenience. Step through the sliding glass doors onto the private screened lanai and enjoy relaxing views of the landscaped grounds, and golf course. Whether enjoying a quiet morning or unwinding at the end of the day, this outdoor space is a standout feature of the home. Additional highlights include covered assigned parking, a community pool, maintained tropical landscaping, and a gated golf community setting. Conveniently located near shopping, dining, entertainment, major roadways, the airport, and Southwest Florida beaches, this condo combines comfort, scenery, and convenience. Clean, welcoming, and ready for its next owner, this property is a wonderful choice for a primary residence, seasonal getaway, or investment opportunity. Schedule your private showing and experience everything this Fort Myers condo provides!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_OriginatingSystemName_
⇄⧉public MFR_AmenitiesAdditionalFees -> string (162) "HOW INFORMATION Annual Hideaway POA - $5325 - May Quarterly Oakmont POA - $1...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_AmenitiesAdditionalFees
HOW INFORMATION
Annual Hideaway POA - $5325 - May
Quarterly Oakmont POA - $1632 - January, April, July and October
Annual Pre-Paid Clubhouse - $600 - October
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1997) "Welcome to exceptional Florida living in the highly sought-after, gated Gran...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
Welcome to exceptional Florida living in the highly sought-after, gated Grand Haven community of Palm Coast! Custom built by Olsen Homes, this beautifully designed residence combines an open-concept layout, impressive architectural details, and peaceful water and golf course views to create the perfect setting for both everyday living and entertaining.
Step inside to a light and bright interior featuring soaring ceilings, tile flooring, and expansive living spaces that flow effortlessly throughout the home. The spacious chef’s kitchen is the heart of the home, complete with stone countertops, gas stove, upgraded stainless steel appliances, a large center island, abundant cabinetry and a casual dining area overlooking the surrounding scenery.
The open living area extends seamlessly to the large covered and screened lanai, where your own sparkling pool awaits. Situated along a tranquil lake with no rear neighbors, the backyard offers a wonderful sense of privacy along with beautiful water views—the perfect backdrop for morning coffee, afternoon swims, or evenings spent entertaining outdoors. Water and golf course views can be enjoyed from many areas of the home, bringing the beauty of the outdoors inside.
Additional highlights include a three-car garage, durable tile roof, spacious rooms, high ceilings, and thoughtful custom details throughout.
Living in Grand Haven means enjoying a resort-style lifestyle just moments from home. Community amenities include two heated swimming pools, two fitness centers, restaurants, tennis and pickleball courts, bocce courts, croquet fields, walking and biking trails, a dog park, playground, fishing pier, an impressive calendar of social clubs and events, and the renowned Jack Nicklaus Signature Golf Course.
With its custom design, sparkling pool, lakefront setting, no rear neighbors, and access to an incredible collection of amenities, this Grand Haven home offers the Florida lifestyle you’ve been waiting for!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 1
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 53
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DaysOnMarket
⇄public DirectionFaces -> string (4) "East"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DirectionFaces
⇄⧉public Directions -> string (407) "From I-95, take Exit 289 for Palm Coast Parkway and head east on Palm Coast ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->Directions
From I-95, take Exit 289 for Palm Coast Parkway and head east on Palm Coast Parkway. Turn right onto Colbert Lane and continue south for approximately 2 miles to the main entrance of the Grand Haven community. After passing through the guard gate, take the first left onto Marlin Drive. Continue to North Village Parkway and follow it to the end. You will arrive at 1 S Waterview Drive, Palm Coast, FL 32137
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1997) "Welcome to exceptional Florida living in the highly sought-after, gated Gran...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
Welcome to exceptional Florida living in the highly sought-after, gated Grand Haven community of Palm Coast! Custom built by Olsen Homes, this beautifully designed residence combines an open-concept layout, impressive architectural details, and peaceful water and golf course views to create the perfect setting for both everyday living and entertaining.
Step inside to a light and bright interior featuring soaring ceilings, tile flooring, and expansive living spaces that flow effortlessly throughout the home. The spacious chef’s kitchen is the heart of the home, complete with stone countertops, gas stove, upgraded stainless steel appliances, a large center island, abundant cabinetry and a casual dining area overlooking the surrounding scenery.
The open living area extends seamlessly to the large covered and screened lanai, where your own sparkling pool awaits. Situated along a tranquil lake with no rear neighbors, the backyard offers a wonderful sense of privacy along with beautiful water views—the perfect backdrop for morning coffee, afternoon swims, or evenings spent entertaining outdoors. Water and golf course views can be enjoyed from many areas of the home, bringing the beauty of the outdoors inside.
Additional highlights include a three-car garage, durable tile roof, spacious rooms, high ceilings, and thoughtful custom details throughout.
Living in Grand Haven means enjoying a resort-style lifestyle just moments from home. Community amenities include two heated swimming pools, two fitness centers, restaurants, tennis and pickleball courts, bocce courts, croquet fields, walking and biking trails, a dog park, playground, fishing pier, an impressive calendar of social clubs and events, and the renowned Jack Nicklaus Signature Golf Course.
With its custom design, sparkling pool, lakefront setting, no rear neighbors, and access to an incredible collection of amenities, this Grand Haven home offers the Florida lifestyle you’ve been waiting for!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (954) "NO HOA Lovely Four-bedroom two-bath split floor plan manufacture home with l...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->PublicRemarks
NO HOA Lovely Four-bedroom two-bath split floor plan manufacture home with land. Has a spacious mordern open concept living, dining and kitchen with cathedral ceilings. This home has abundant storage with walk-in closet in the master. Kitchen is mordern and large with shaker style cabintes with self closing doors, stainless appliances, Quarts countertop and walk-in pantry with more storage. Both bathrooms have 2 vanity each. Excellent home for you the the family. The rural town of Lake Panasoffkee has a quaint small-town feel and is centrally located only minutes to I-75, Orlando, Tampa, and The Villages. Spring-fed Lake Panasoffkee is famous for some of the best bass, bluegill, and crappie fishing in Florida. Don't miss your chance to purchase your own piece of Florida Paradise and enjoy nature including birdwatching. Wildlife Management Area along the eastern shore of Lake Panasoffkee, part of the Great Florida Birding and Wildlife Trail.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (954) "NO HOA Lovely Four-bedroom two-bath split floor plan manufacture home with l...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_PublicRemarksAgent
NO HOA Lovely Four-bedroom two-bath split floor plan manufacture home with land. Has a spacious mordern open concept living, dining and kitchen with cathedral ceilings. This home has abundant storage with walk-in closet in the master. Kitchen is mordern and large with shaker style cabintes with self closing doors, stainless appliances, Quarts countertop and walk-in pantry with more storage. Both bathrooms have 2 vanity each. Excellent home for you the the family. The rural town of Lake Panasoffkee has a quaint small-town feel and is centrally located only minutes to I-75, Orlando, Tampa, and The Villages. Spring-fed Lake Panasoffkee is famous for some of the best bass, bluegill, and crappie fishing in Florida. Don't miss your chance to purchase your own piece of Florida Paradise and enjoy nature including birdwatching. Wildlife Management Area along the eastern shore of Lake Panasoffkee, part of the Great Florida Birding and Wildlife Trail.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1601) "WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Y...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->PublicRemarks
WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Yacht & Tennis Club of St Pete Beach! Just a short walk to the sandy beaches of Treasure Island, this condo has tremendous views from its 5th floor balcony. To start with the condo itself... enjoy watching dolphins & sunsets from the comfort of your home, updated and open kitchen with an island, updated bathrooms, in-unit washer/dryer, hurricane shutters, an extra secured storage closet in the garage, and so many recent updates to the condo itself. Updates include: water heater (2024), furnace/ac including uv light (2022), water filter (2023), windows/sliders (2021), hurricane shutters (2018), Refrigerator (2019), Stove (2021), microwave (2025), dishwasher (2023), closet doors (2022), gemstone coating on balcony (2022).
The HOA/condo fee covers so many amenities! Included in the HOA is: water, sewer, trash, cable & internet, secure gated community with new gate access equipment, heated waterfront pool & spa, men’s/women’s saunas, clay tennis courts, pickle ball courts, updated clubhouse & activity room, new seawall, boardwalk, docks & kayak launch, state of the art fitness facility, shuffleboard, dedicated grilling area. This building has passed the milestone Engineering Study and the Structural Reserve requirements and is in great financial health.
If you are going to spend your time in Florida, spend it at a condo community that feels like the best vacation every day of the year. Enjoy countless amenities, sunset views from your condo living room, and the comfort of an updated home.
⇄⧉public Appliances -> string (153) "Convection Oven,Cooktop,Dishwasher,Dryer,Electric Water Heater,Exhaust Fan,I...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Appliances
Convection Oven,Cooktop,Dishwasher,Dryer,Electric Water Heater,Exhaust Fan,Ice Maker,Microwave,Refrigerator,Washer,Water Filtration System,Water Softener
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->DirectionFaces
⇄⧉public Directions -> string (153) "From Treasure Island, take Gulf Blvd towards St Pete Beach. Turn left on Bli...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Directions
From Treasure Island, take Gulf Blvd towards St Pete Beach. Turn left on Blind Pass. Entry gate to Yacht & Tennis Club of St Pete Beach is on the left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1601) "WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Y...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_PublicRemarksAgent
WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Yacht & Tennis Club of St Pete Beach! Just a short walk to the sandy beaches of Treasure Island, this condo has tremendous views from its 5th floor balcony. To start with the condo itself... enjoy watching dolphins & sunsets from the comfort of your home, updated and open kitchen with an island, updated bathrooms, in-unit washer/dryer, hurricane shutters, an extra secured storage closet in the garage, and so many recent updates to the condo itself. Updates include: water heater (2024), furnace/ac including uv light (2022), water filter (2023), windows/sliders (2021), hurricane shutters (2018), Refrigerator (2019), Stove (2021), microwave (2025), dishwasher (2023), closet doors (2022), gemstone coating on balcony (2022).
The HOA/condo fee covers so many amenities! Included in the HOA is: water, sewer, trash, cable & internet, secure gated community with new gate access equipment, heated waterfront pool & spa, men’s/women’s saunas, clay tennis courts, pickle ball courts, updated clubhouse & activity room, new seawall, boardwalk, docks & kayak launch, state of the art fitness facility, shuffleboard, dedicated grilling area. This building has passed the milestone Engineering Study and the Structural Reserve requirements and is in great financial health.
If you are going to spend your time in Florida, spend it at a condo community that feels like the best vacation every day of the year. Enjoy countless amenities, sunset views from your condo living room, and the comfort of an updated home.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1445) "Extension Villa Caparra, exclusive gated community located in Guaynabo. Grea...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->PublicRemarks
Extension Villa Caparra, exclusive gated community located in Guaynabo. Great opportunity with an independent apartment. The contemporary design home sits in a lot of 516.98 square meters and features features 3,397 sqft of living area. Beautiful corner split level home welcomes you to an open layout living area. The main level is composed of living room, and formal dining room, equipped kitchen, with a laundry area. Flex area ideal for an office, playroom with a powder room that opens to the terrace. Enjoy hosting special home gatherings in a covered terrace with a nice patio. The main bedroom enjoys the privacy of an en-suite full bathroom, a spacious closet and a balcony. The property is complemented with three additional bedrooms and a full bathroom. This home includes a Generator, water cistern, refrigerator, stove with oven, 4a/c units, and a garage door. On the second level the independent apartment consists of a living area, kitchen, three bedrooms and two full bathroom. For your convenience this unit has solar panels and a battery. Amenities for Extension Villa Caparra residents enjoyment: 24/7 security, tennis court, basketball court, and playground. Conveniently located, close to private schools: fine dining restaurants, shopping centers and other places of interest. Don't miss this opportunity. For a private showing call us today.
Selling Price $895,000
Property Tax $ 1,180.67 anually
HOA $200 monthly
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1445) "Extension Villa Caparra, exclusive gated community located in Guaynabo. Grea...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_PublicRemarksAgent
Extension Villa Caparra, exclusive gated community located in Guaynabo. Great opportunity with an independent apartment. The contemporary design home sits in a lot of 516.98 square meters and features features 3,397 sqft of living area. Beautiful corner split level home welcomes you to an open layout living area. The main level is composed of living room, and formal dining room, equipped kitchen, with a laundry area. Flex area ideal for an office, playroom with a powder room that opens to the terrace. Enjoy hosting special home gatherings in a covered terrace with a nice patio. The main bedroom enjoys the privacy of an en-suite full bathroom, a spacious closet and a balcony. The property is complemented with three additional bedrooms and a full bathroom. This home includes a Generator, water cistern, refrigerator, stove with oven, 4a/c units, and a garage door. On the second level the independent apartment consists of a living area, kitchen, three bedrooms and two full bathroom. For your convenience this unit has solar panels and a battery. Amenities for Extension Villa Caparra residents enjoyment: 24/7 security, tennis court, basketball court, and playground. Conveniently located, close to private schools: fine dining restaurants, shopping centers and other places of interest. Don't miss this opportunity. For a private showing call us today.
Selling Price $895,000
Property Tax $ 1,180.67 anually
HOA $200 monthly
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (953) "Income-producing quadplex with four separate 2BR/1BA units — two on the grou...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->PublicRemarks
Income-producing quadplex with four separate 2BR/1BA units — two on the ground floor, two upstairs — each with a private entrance and individually metered utilities. Two units are currently tenant-occupied and generating rental income; the other two are vacant and move-in ready, offering the flexibility to occupy one unit while renting the others, or to re-lease immediately at market rent. Durable brick-and-stucco construction under a distinctive mansard shingle roof, on a spacious lot with paved multi-vehicle parking and a shaded yard. Vacant units feature functional kitchens, comfortable living areas, good natural light, and full baths; flooring varies between tile and wood-look laminate, with vaulted ceilings in some living areas. Each unit has its own HVAC system and separate electric panel. Strong cash-flow opportunity with upside to stabilize remaining units at market rents. Buyer to verify all leases, rents, and income/expenses.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->CreationDate
⇄⧉public Directions -> string (159) "From US-1/Nova Rd area, head west on LPGA Blvd, turn onto Derbyshire Rd, the...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Directions
From US-1/Nova Rd area, head west on LPGA Blvd, turn onto Derbyshire Rd, then turn onto Williamsburg Dr. Property will be on your right at 656 Williamsburg Dr.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxAnnualAmount
⇄public TaxBlock -> string (2) "00"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxBlock
⇄public TaxBookNumber -> string (5) "29-54"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxBookNumber
⇄⧉public TaxLegalDescription -> string (255) "LOT 1 COLONIAL LAKE SUB MB 29 PG 54 PER OR 4634 PG 1707 PER OR 6053 PG 1093 ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxLegalDescription
LOT 1 COLONIAL LAKE SUB MB 29 PG 54 PER OR 4634 PG 1707 PER OR 6053 PG 1093 PER OR 6598 PG 1374 PER OR 6768 PG 2758 PER OR 7187 PGS 2724-2727 INC PER OR 7187 PGS 2728-2729 PER OR 7398 PGS 4595-4596 PER OR 7536 PG 2250 PER OR 8089 PG 0153 PER OR 8681 PG 26
⇄public TaxLot -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxLot
⇄public TaxYear -> string (4) "2025"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxYear
⇄public Township -> string (3) "15S"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Township
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (953) "Income-producing quadplex with four separate 2BR/1BA units — two on the grou...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_PublicRemarksAgent
Income-producing quadplex with four separate 2BR/1BA units — two on the ground floor, two upstairs — each with a private entrance and individually metered utilities. Two units are currently tenant-occupied and generating rental income; the other two are vacant and move-in ready, offering the flexibility to occupy one unit while renting the others, or to re-lease immediately at market rent. Durable brick-and-stucco construction under a distinctive mansard shingle roof, on a spacious lot with paved multi-vehicle parking and a shaded yard. Vacant units feature functional kitchens, comfortable living areas, good natural light, and full baths; flooring varies between tile and wood-look laminate, with vaulted ceilings in some living areas. Each unit has its own HVAC system and separate electric panel. Strong cash-flow opportunity with upside to stabilize remaining units at market rents. Buyer to verify all leases, rents, and income/expenses.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_NumAssignedParkingSpaces
⇄⧉public MFR_PublicRemarksAgentSpanish -> UTF-8 string (1022) "Cuadruplex generador de ingresos con cuatro unidades independientes de 2 hab...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_PublicRemarksAgentSpanish
Cuadruplex generador de ingresos con cuatro unidades independientes de 2 hab./1 baño — dos en planta baja, dos en planta alta — cada una con entrada privada y servicios medidos individualmente. Dos unidades cuentan con inquilinos actuales y generan ingresos de alquiler; las otras dos están vacías y listas para mudarse, con la flexibilidad de ocupar una unidad y alquilar las demás, o de volver a alquilar de inmediato a precio de mercado. Construcción duradera de ladrillo y estuco bajo techo estilo mansarda, en terreno amplio con estacionamiento pavimentado y patio con sombra. Las unidades vacías cuentan con cocinas funcionales, áreas de estar cómodas, buena luz natural y baños completos; pisos de cerámica o laminado, con techos abovedados en algunas áreas. Cada unidad cuenta con su propio sistema de aire acondicionado y panel eléctrico independiente. Excelente oportunidad de flujo de efectivo con potencial de estabilizar rentas. El comprador debe verificar contratos, rentas e ingresos/gastos.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (726) "Welcome to 3428 SE 4th Pl, Cape Coral, FL 33904, a beautifully maintained re...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->PublicRemarks
Welcome to 3428 SE 4th Pl, Cape Coral, FL 33904, a beautifully maintained residence in a desirable location offering comfort, convenience, and versatile living space. The inviting layout features spacious living areas filled with natural light, a well appointed kitchen with ample cabinetry and counter space, and comfortable bedrooms designed for everyday relaxation. Enjoy seamless indoor-outdoor living with a private backyard area ideal for entertaining, dining, or unwinding. Conveniently located near shopping, dining, schools, parks, and major roadways, this residence provides easy access to everything Cape Coral has to offer. A wonderful opportunity for those seeking a comfortable and convenient place to call home.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->CreationDate
⇄⧉public Directions -> string (211) "From Veterans Memorial Parkway and Country Club Boulevard, travel south on C...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Directions
From Veterans Memorial Parkway and Country Club Boulevard, travel south on Country Club Boulevard. Turn right (west) onto SE 34th Terrace, then turn left (south) onto SE 4th Place. Continue to 3428 SE 4th Place.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_AttributionContact
⇄⧉public MFR_PublicRemarksAgent -> string (726) "Welcome to 3428 SE 4th Pl, Cape Coral, FL 33904, a beautifully maintained re...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_PublicRemarksAgent
Welcome to 3428 SE 4th Pl, Cape Coral, FL 33904, a beautifully maintained residence in a desirable location offering comfort, convenience, and versatile living space. The inviting layout features spacious living areas filled with natural light, a well appointed kitchen with ample cabinetry and counter space, and comfortable bedrooms designed for everyday relaxation. Enjoy seamless indoor-outdoor living with a private backyard area ideal for entertaining, dining, or unwinding. Conveniently located near shopping, dining, schools, parks, and major roadways, this residence provides easy access to everything Cape Coral has to offer. A wonderful opportunity for those seeking a comfortable and convenient place to call home.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (867) "Welcome to this spacious 3-bedroom, 2-bath home with a one-car garage in a d...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->PublicRemarks
Welcome to this spacious 3-bedroom, 2-bath home with a one-car garage in a desirable Riverview location. Whether you are looking for a primary residence or a strong investment opportunity, this property offers flexibility, comfort, and convenience.
The home features a functional layout with generous living space, a comfortable kitchen and dining area, and well-sized bedrooms. Its larger floor plan gives you room to live, work, entertain, or rent with confidence.
Located in a nice, established area with easy access to shopping, dining, major roads, and everyday conveniences, this home is a great option for buyers who want both value and location.
Move in, rent it out, or add it to your investment portfolio. This property offers several possibilities in one of Riverview’s growing areas.
Schedule your showing today and see the opportunity for yourself.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->DirectionFaces
⇄⧉public Directions -> string (336) "Big Bend Rd 1 min (0.1 mi) Head southwest 203 ft Turn right toward Summerfie...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->Directions
Big Bend Rd 1 min (0.1 mi) Head southwest 203 ft Turn right toward Summerfield Blvd 197 ft Turn left toward Summerfield Blvd. Turn right onto Summerfield Blvd. Continue on Big Bend Rd to Summerview Cir 4 min (1.5 mi) Turn right onto Summerview Cir Destination will be on the right 1 min (0.2 mi) 10331 Summerview Cir Riverview, FL 33578
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (867) "Welcome to this spacious 3-bedroom, 2-bath home with a one-car garage in a d...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_PublicRemarksAgent
Welcome to this spacious 3-bedroom, 2-bath home with a one-car garage in a desirable Riverview location. Whether you are looking for a primary residence or a strong investment opportunity, this property offers flexibility, comfort, and convenience.
The home features a functional layout with generous living space, a comfortable kitchen and dining area, and well-sized bedrooms. Its larger floor plan gives you room to live, work, entertain, or rent with confidence.
Located in a nice, established area with easy access to shopping, dining, major roads, and everyday conveniences, this home is a great option for buyers who want both value and location.
Move in, rent it out, or add it to your investment portfolio. This property offers several possibilities in one of Riverview’s growing areas.
Schedule your showing today and see the opportunity for yourself.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (995) "A rare opportunity to own a fully renovated townhouse in one of Tampa’s most...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->PublicRemarks
A rare opportunity to own a fully renovated townhouse in one of Tampa’s most desirable locations: Davis Islands.
This exceptional property offers the freedom of no HOA fees or restrictions, along with remarkable expansion potential. The ground level, currently used as a garage, may have the possibility of being converted to accommodate up to two additional bedrooms, subject to applicable permits and local regulations.
Thoughtfully renovated with impeccable taste, the home features a new HVAC system, new flooring, elegant marble finishes, and high-end details throughout. The beautifully redesigned kitchen and completely remodeled bathrooms combine modern style with premium craftsmanship. Additional highlights include fresh interior paint, a charming fireplace, French doors, and high end finishes at every turn.
With its outstanding location, extensive upgrades, flexible living potential, and zero HOA fees, this Davis Islands townhouse is truly a one-of-a-kind opportunity.
⇄⧉public Appliances -> string (111) "Convection Oven,Dishwasher,Disposal,Dryer,Electric Water Heater,Exhaust Fan,...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Appliances
Convection Oven,Dishwasher,Disposal,Dryer,Electric Water Heater,Exhaust Fan,Microwave,Range,Refrigerator,Washer
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->TaxAnnualAmount
⇄public TaxBlock -> string (2) "13"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->TaxBlock
⇄public TaxBookNumber -> string (5) "10-52"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->TaxBookNumber
⇄⧉public TaxLegalDescription -> string (361) "DAVIS ISLANDS PB10 PG52 TO 57 AND PB17 PG5 TO 9 FROM NW COR OF LOT 31 BLK 13...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->TaxLegalDescription
DAVIS ISLANDS PB10 PG52 TO 57 AND PB17 PG5 TO 9 FROM NW COR OF LOT 31 BLK 13 RUN S 49 DEG 39 MIN 47 SEC E 32.33 FT FOR POB CONT S 49 DEG 39 MIN 47 SEC E 22.23 FT THN N 51 DEG 26 MIN 05 SEC E 90.67 FT TO E BDRY OF BLK 13 THN N 38 DEG 32 MIN 46 SEC W 2 2.25 FT ALG ELY BDRY THN S 51 DEG 10 MIN 53 SEC W 94.92 FT TO POB BEING PT OF LOTS 32 AND 33 BLOCK 13 PARCEL H
⇄public TaxLot -> string (2) "31"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->TaxLot
⇄public TaxYear -> string (4) "2025"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->TaxYear
⇄public Township -> string (2) "29"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Township
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (995) "A rare opportunity to own a fully renovated townhouse in one of Tampa’s most...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_PublicRemarksAgent
A rare opportunity to own a fully renovated townhouse in one of Tampa’s most desirable locations: Davis Islands.
This exceptional property offers the freedom of no HOA fees or restrictions, along with remarkable expansion potential. The ground level, currently used as a garage, may have the possibility of being converted to accommodate up to two additional bedrooms, subject to applicable permits and local regulations.
Thoughtfully renovated with impeccable taste, the home features a new HVAC system, new flooring, elegant marble finishes, and high-end details throughout. The beautifully redesigned kitchen and completely remodeled bathrooms combine modern style with premium craftsmanship. Additional highlights include fresh interior paint, a charming fireplace, French doors, and high end finishes at every turn.
With its outstanding location, extensive upgrades, flexible living potential, and zero HOA fees, this Davis Islands townhouse is truly a one-of-a-kind opportunity.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2652) "Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Res...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->PublicRemarks
Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Residences, where timeless sophistication, exceptional service, and the legendary standards of Ritz-Carlton management come together in one remarkable coastal retreat. This residence, fully furnished and move-in ready, was re-envisioned and completely transformed in 2024 with a million dollars renovation. It offers generous proportions, refined European-inspired design, and the enduring quality of Amish craftsmanship. Every detail was considered to create a sophisticated yet comfortable enclave—a private sanctuary. Breathtaking views, framed by dramatic floor-to-ceiling glass, capture the very essence of coastal living. Watch nature unfold from the expansive balcony, with sweeping views across a lagoon, bird sanctuary and the Intracoastal Waterway. As day turns to evening, the downtown Sarasota skyline comes alive with twinkling lights, creating an enchanting backdrop for cocktails, intimate dinners, and moonlit evenings. The versatile floor plan offers two bedrooms and three baths. The office/den includes a murphy bed for ultimate flexibility. Two beautifully appointed primary suites provide exceptional privacy and spa-like ambiance. A gourmet kitchen sits at the heart of this home, perfect for refined entertaining or relaxed family gatherings. Ten-foot ceilings, custom finishes, and an understated elegance carry throughout, while a private elevator foyer provides an exclusive arrival experience. The Beach Residences offer an extraordinary collection of amenities designed around wellness, relaxation, work and social connection. Residents enjoy access to a private boardroom, theater, sauna, massage room, guest suites and flexible recreation space for yoga, ping-pong, and more—all complemented by the attentive, discreet service synonymous with Ritz-Carlton. The Beach Club is one of Lido Key's most coveted amenities, and membership is included with this residence - complete with tiki bar, pool, restaurant and bar, to add another layer of effortless convenience. St. Armands Circle is also close at hand, easily reached by foot, bicycle, car, or the Ritz-Carlton shuttle for exceptional dining, boutique shopping, and Sarasota's vibrant coastal lifestyle. Here, luxury is not simply something you see—it is something you experience every day. From spectacular sunrise and moonlight views to private evenings overlooking the water, from impeccable interiors to world-class service, this is a rare opportunity to enjoy coastal beauty, sophisticated design, and quiet opulence in the perfect seasonal escape or year-round haven.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->Appliances
Bar Fridge,Built-In Oven,Convection Oven,Dishwasher,Disposal,Dryer,Electric Water Heater,Exhaust Fan,Microwave,Range,Range Hood,Refrigerator,Washer,Wine Refrigerator
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 264
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->DaysOnMarket
⇄public DirectionFaces -> string (4) "West"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->DirectionFaces
⇄⧉public Directions -> string (229) "From North Tamiami Trail and Bayfront Drive, head west on John Ringling Blvd...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->Directions
From North Tamiami Trail and Bayfront Drive, head west on John Ringling Blvd to St. Armands Circle. 2nd exit from the Circle to stay on John Ringling Blvd. Left on Benjamin Franklin Drive. Turn right into The Beach Residences.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2652) "Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Res...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_PublicRemarksAgent
Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Residences, where timeless sophistication, exceptional service, and the legendary standards of Ritz-Carlton management come together in one remarkable coastal retreat. This residence, fully furnished and move-in ready, was re-envisioned and completely transformed in 2024 with a million dollars renovation. It offers generous proportions, refined European-inspired design, and the enduring quality of Amish craftsmanship. Every detail was considered to create a sophisticated yet comfortable enclave—a private sanctuary. Breathtaking views, framed by dramatic floor-to-ceiling glass, capture the very essence of coastal living. Watch nature unfold from the expansive balcony, with sweeping views across a lagoon, bird sanctuary and the Intracoastal Waterway. As day turns to evening, the downtown Sarasota skyline comes alive with twinkling lights, creating an enchanting backdrop for cocktails, intimate dinners, and moonlit evenings. The versatile floor plan offers two bedrooms and three baths. The office/den includes a murphy bed for ultimate flexibility. Two beautifully appointed primary suites provide exceptional privacy and spa-like ambiance. A gourmet kitchen sits at the heart of this home, perfect for refined entertaining or relaxed family gatherings. Ten-foot ceilings, custom finishes, and an understated elegance carry throughout, while a private elevator foyer provides an exclusive arrival experience. The Beach Residences offer an extraordinary collection of amenities designed around wellness, relaxation, work and social connection. Residents enjoy access to a private boardroom, theater, sauna, massage room, guest suites and flexible recreation space for yoga, ping-pong, and more—all complemented by the attentive, discreet service synonymous with Ritz-Carlton. The Beach Club is one of Lido Key's most coveted amenities, and membership is included with this residence - complete with tiki bar, pool, restaurant and bar, to add another layer of effortless convenience. St. Armands Circle is also close at hand, easily reached by foot, bicycle, car, or the Ritz-Carlton shuttle for exceptional dining, boutique shopping, and Sarasota's vibrant coastal lifestyle. Here, luxury is not simply something you see—it is something you experience every day. From spectacular sunrise and moonlight views to private evenings overlooking the water, from impeccable interiors to world-class service, this is a rare opportunity to enjoy coastal beauty, sophisticated design, and quiet opulence in the perfect seasonal escape or year-round haven.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_AssociationFeeRequirement
⇄⧉public MFR_AdditionalWaterInformation -> string (240) "Wonderful view of Sarasota Skyline, Big Pass, Sarasota Bay, quiet lagoons wi...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_AdditionalWaterInformation
Wonderful view of Sarasota Skyline, Big Pass, Sarasota Bay, quiet lagoons with fish jumping. Partial views of the John Ringling Bridge and Gulf of Mexico. One of the best views in Sarasota especially during the Fourth of July and New Years.
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=10&$filter=(Appliances eq \'Convection Oven\' OR ArchitecturalStyle eq \'Convection Oven\' OR CommunityFeatures eq \'Convection Oven\' OR Cooling eq \'Convection Oven\' OR CountyOrParish eq \'Convection Oven\' OR ElementarySchool eq \'Convection Oven\' OR ExteriorFeatures eq \'Convection Oven\' OR Flooring eq \'Convection Oven\' OR Heating eq \'Convection Oven\' OR HighSchool eq \'Convection Oven\' OR InteriorFeatures eq \'Convection Oven\' OR ListingTerms eq \'Convection Oven\' OR MiddleOrJuniorSchool eq \'Convection Oven\' OR ParkingFeatures eq \'Convection Oven\' OR PoolFeatures eq \'Convection Oven\' OR PropertyType eq \'Convection Oven\' OR Roof eq \'Convection Oven\' OR SchoolDistrict eq \'Convection Oven\' OR Sewer eq \'Convection Oven\' OR Utilities eq \'Convection Oven\' OR WaterfrontFeatures eq \'Convection Oven\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']