$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1352) "1% LENDER CREDIT available toward rate buydown or closing costs. Beautifully...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
1% LENDER CREDIT available toward rate buydown or closing costs. Beautifully updated 4-bedroom, 2-bath home in Marion Oaks. Luxury vinyl plank flooring flows through the main living areas, while the front dining room and versatile 4th bedroom offer flexible space for guests, an office, or hobbies. Decorative wainscoting in the foyer and custom wall trim add a designer touch throughout. The kitchen is the true centerpiece, featuring stainless steel appliances, white cabinetry, and a stunning waterfall quartz island that's perfect for gathering and entertaining. The living room showcases a modern accent wall with a floating TV console and sliding glass doors that open to your private backyard retreat. Enjoy Florida living year-round with a covered patio and a separate pergola outfitted with a stone bar, sink, built-in smoker, and brick grill-ideal for hosting friends and family. The fully fenced yard includes two double gates, offering easy access and plenty of room for a boat, trailer, or large vehicles. A split-bedroom layout provides extra privacy, with the spacious primary suite tucked away and featuring a walk-in closet, linen storage, and an ensuite bath with a large vanity and shower. Additional highlights include under-soffit lighting, a smart thermostat, and a two-car garage-making this home as functional as it is inviting.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DirectionFaces
⇄⧉public Directions -> string (154) "SR 200 to SW Hwy 484. Right on Marion Oaks Manor. Right on Marion Oaks Blvd....
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Directions
SR 200 to SW Hwy 484. Right on Marion Oaks Manor. Right on Marion Oaks Blvd. Right on SW 42nd Avenue Rd. Right on SW 170th Street Rd. Home is on the left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1352) "1% LENDER CREDIT available toward rate buydown or closing costs. Beautifully...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_PublicRemarksAgent
1% LENDER CREDIT available toward rate buydown or closing costs. Beautifully updated 4-bedroom, 2-bath home in Marion Oaks. Luxury vinyl plank flooring flows through the main living areas, while the front dining room and versatile 4th bedroom offer flexible space for guests, an office, or hobbies. Decorative wainscoting in the foyer and custom wall trim add a designer touch throughout. The kitchen is the true centerpiece, featuring stainless steel appliances, white cabinetry, and a stunning waterfall quartz island that's perfect for gathering and entertaining. The living room showcases a modern accent wall with a floating TV console and sliding glass doors that open to your private backyard retreat. Enjoy Florida living year-round with a covered patio and a separate pergola outfitted with a stone bar, sink, built-in smoker, and brick grill-ideal for hosting friends and family. The fully fenced yard includes two double gates, offering easy access and plenty of room for a boat, trailer, or large vehicles. A split-bedroom layout provides extra privacy, with the spacious primary suite tucked away and featuring a walk-in closet, linen storage, and an ensuite bath with a large vanity and shower. Additional highlights include under-soffit lighting, a smart thermostat, and a two-car garage-making this home as functional as it is inviting.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1083) "Welcome to Skypoint in the heart of downtown Tampa! This beautifully renovat...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
Welcome to Skypoint in the heart of downtown Tampa! This beautifully renovated 1-bedroom, 1-bath residence offers 838 square feet of thoughtfully designed living space on the 16th floor. The spacious eat-in kitchen features sleek quartz countertops and ample cabinetry, perfect for everyday living or entertaining. The large primary bedroom is complemented by an updated, spa-like bathroom with a generously sized walk-in shower. A convenient in-unit laundry closet adds to the ease of condo living. Step out onto the private balcony and take in breathtaking southern views of downtown Tampa, Curtis Hixon Waterfront Park, the University of Tampa, Davis Islands, and Tampa Bay—sunsets included. Skypoint Condominiums delivers unmatched urban convenience just steps from the Arts District, the Tampa Riverwalk, and all the dining, entertainment, and culture of Tampa’s ever-growing downtown scene. One assigned parking space is included. Skypoint amenities include a modern fitness center, resort style pool, and resident clubhouse, which can be an extension of your living space.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_BuildingNameNumber
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1083) "Welcome to Skypoint in the heart of downtown Tampa! This beautifully renovat...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
Welcome to Skypoint in the heart of downtown Tampa! This beautifully renovated 1-bedroom, 1-bath residence offers 838 square feet of thoughtfully designed living space on the 16th floor. The spacious eat-in kitchen features sleek quartz countertops and ample cabinetry, perfect for everyday living or entertaining. The large primary bedroom is complemented by an updated, spa-like bathroom with a generously sized walk-in shower. A convenient in-unit laundry closet adds to the ease of condo living. Step out onto the private balcony and take in breathtaking southern views of downtown Tampa, Curtis Hixon Waterfront Park, the University of Tampa, Davis Islands, and Tampa Bay—sunsets included. Skypoint Condominiums delivers unmatched urban convenience just steps from the Arts District, the Tampa Riverwalk, and all the dining, entertainment, and culture of Tampa’s ever-growing downtown scene. One assigned parking space is included. Skypoint amenities include a modern fitness center, resort style pool, and resident clubhouse, which can be an extension of your living space.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (937) "Virtually Staged. Welcome to 9805 N 54th Street, a beautifully reimagined 4-...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->PublicRemarks
Virtually Staged. Welcome to 9805 N 54th Street, a beautifully reimagined 4-bedroom, 2-bathroom home offering 1,680 square feet of fully remodeled living space. Every corner has been thoughtfully updated, creating a truly move-in-ready home with modern finishes throughout. Major improvements include a brand-new 2026 roof, 2026 windows, a new sliding glass door, and a 2024 HVAC system. Inside, you’ll find new flooring, contemporary lighting, a completely renovated kitchen, new appliances, and tastefully updated bathrooms. The spacious primary suite features a walk-in closet and a private, refreshed bathroom. Step outside to enjoy the fenced backyard, offering plenty of room for entertaining, relaxing, pets, or future outdoor improvements. With no HOA and no CDD, this home delivers both freedom and affordability in a convenient location. Schedule your private showing and experience this complete transformation for yourself!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (919) "Welcome to 9805 N 54th Street, a beautifully reimagined 4-bedroom, 2-bathroo...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_PublicRemarksAgent
Welcome to 9805 N 54th Street, a beautifully reimagined 4-bedroom, 2-bathroom home offering 1,680 square feet of fully remodeled living space. Every corner has been thoughtfully updated, creating a truly move-in-ready home with modern finishes throughout. Major improvements include a brand-new 2026 roof, 2026 windows, a new sliding glass door, and a 2024 HVAC system. Inside, you’ll find new flooring, contemporary lighting, a completely renovated kitchen, new appliances, and tastefully updated bathrooms. The spacious primary suite features a walk-in closet and a private, refreshed bathroom. Step outside to enjoy the fenced backyard, offering plenty of room for entertaining, relaxing, pets, or future outdoor improvements. With no HOA and no CDD, this home delivers both freedom and affordability in a convenient location. Schedule your private showing and experience this complete transformation for yourself!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (881) "Under Construction. 1 ACRE New Construction Home in Rainbow Lakes Estates – ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->PublicRemarks
Under Construction. 1 ACRE New Construction Home in Rainbow Lakes Estates – Close to World Equestrian Center & Rainbow River
Beautifully crafted 4-bedroom, 2-bathroom BLOCK home, inside has luxury vinyl wood flooring and granite countertops home located in the peaceful community of Rainbow Lakes Estates in Dunnellon, Florida. Just 30 minutes from the World Equestrian Center and 25 minutes from the famous Rainbow River, you’ll enjoy endless opportunities for kayaking, canoeing, tubing, and fishing in crystal-clear waters. Built with quality and attention to detail, this brand-new home offers modern finishes, a functional floor plan, and the comfort of low-maintenance living in a serene setting. Whether you’re an outdoor enthusiast or simply looking for a quiet retreat, this property blends the best of Florida living with everyday convenience. Photos coming soon.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->DirectionFaces
⇄⧉public Directions -> string (456) "From I-75, take Exit 341 for FL-484 West toward Dunnellon. Continue on FL-48...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Directions
From I-75, take Exit 341 for FL-484 West toward Dunnellon. Continue on FL-484 W to US-41 North and turn right. Continue north, then turn left onto County Road 328 (SW 80th Street). Turn left onto NW Ridgewood Road, then left onto NW Falcon Avenue. Turn left onto NW Buena Vista Road, then right onto NW Falcon Avenue. Turn right onto NW Redwood Road, then left onto NW Water Oak Avenue. Continue to 23636 NW Water Oak Ave; the property will be on your left
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (861) "1 ACRE New Construction Home in Rainbow Lakes Estates – Close to World Eques...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_PublicRemarksAgent
1 ACRE New Construction Home in Rainbow Lakes Estates – Close to World Equestrian Center & Rainbow River
Beautifully crafted 4-bedroom, 2-bathroom BLOCK home, inside has luxury vinyl wood flooring and granite countertops home located in the peaceful community of Rainbow Lakes Estates in Dunnellon, Florida. Just 30 minutes from the World Equestrian Center and 25 minutes from the famous Rainbow River, you’ll enjoy endless opportunities for kayaking, canoeing, tubing, and fishing in crystal-clear waters. Built with quality and attention to detail, this brand-new home offers modern finishes, a functional floor plan, and the comfort of low-maintenance living in a serene setting. Whether you’re an outdoor enthusiast or simply looking for a quiet retreat, this property blends the best of Florida living with everyday convenience. Photos coming soon.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (253) "COMING SOON!!! Welcome home to this beautiful 3-bedroom, 2-bathroom home loc...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->PublicRemarks
COMING SOON!!! Welcome home to this beautiful 3-bedroom, 2-bathroom home located in the desirable 55+ community of Sandpiper Golf and Country Club! This home backs up to the golf course and has several appealing updates. Call today for more information!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->CreationDate
⇄public DirectionFaces -> string (4) "East"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->DirectionFaces
⇄⧉public Directions -> string (315) "From I-4, take exit 33 toward CR-582/Lakeland/SR-33. Go for 0.3 mi. Turn rig...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->Directions
From I-4, take exit 33 toward CR-582/Lakeland/SR-33. Go for 0.3 mi. Turn right onto N Socrum Loop Rd (CR-582). Go for 1.2 mi. Turn right onto Sandpiper Club Blvd. Make a left at the clubhouse (Sandpipers Drive) and then a right on Meadowlark Drive. Take your third left onto Crane Drive. House will be on your left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_FloodZonePanel
⇄⧉public MFR_ApprovalProcess -> string (248) "Fee per person background check and application. Check with Sandpiper POA fo...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_ApprovalProcess
Fee per person background check and application. Check with Sandpiper POA for complete rules and procedures for renting. https://sandpiperflpoa.org/ (scroll down to "Governing Documents" and look at Rental App and Residential Application Committee)
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_EscrowAgentName
⇄⧉public MFR_PetRestrictions -> string (177) "Check with Sandpiper POA for complete rules and procedures for pets. Breedin...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_PetRestrictions
Check with Sandpiper POA for complete rules and procedures for pets. Breeding is prohibited. Permission to keep a pet may be revoked by The Association in certain circumstances.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (253) "COMING SOON!!! Welcome home to this beautiful 3-bedroom, 2-bathroom home loc...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_PublicRemarksAgent
COMING SOON!!! Welcome home to this beautiful 3-bedroom, 2-bathroom home located in the desirable 55+ community of Sandpiper Golf and Country Club! This home backs up to the golf course and has several appealing updates. Call today for more information!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (2332) "Virtually Staged. Welcome to this brand-new home in Lakes of Mount Dora, a s...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->PublicRemarks
Virtually Staged. Welcome to this brand-new home in Lakes of Mount Dora, a sought-after 55+ community offering an active lifestyle, beautiful surroundings, and NO CDD fees. This upgraded St. Thomas floor plan features 3 bedrooms, 2 bathrooms, plus a dedicated office that could easily be converted into a 4th bedroom if desired. With no rear neighbors, the home offers added privacy and a peaceful setting to enjoy every day.
Inside, luxury vinyl flooring flows throughout the home, creating a clean and cohesive look that is both stylish and easy to maintain. The kitchen features quartz countertops, a gas stove, and a spacious walk-in pantry with upgraded wood shelving. The upgraded wood shelving continues throughout the bedroom closets and linen closets, adding both function and a custom feel. Quartz countertops are also featured in the bathrooms, while vaulted ceilings help make the main living areas feel bright, open, and spacious. A tankless water heater adds another touch of efficiency and convenience.
Since the home is brand new and still covered by the builder's warranty, you can enjoy the benefits of new construction without the wait.
Living in Lakes of Mount Dora is about much more than the home itself. The community is centered around an impressive 18,000-square-foot clubhouse with a fitness center, library, resort-style pool, billiards room, card room, craft room, and spacious social hall with events and activities throughout the year. Outdoor amenities include a fire pit, tennis and pickleball courts, croquet, bocce ball, cornhole, and a softball field.
Private golf cart access connects the community to the Country Club of Mount Dora for dining and golf, and a future boat ramp is planned to provide access to scenic Loch Leven Lake for gas-powered boats. The $290 monthly HOA fee also includes access to secured, fenced boat and RV storage.
Located just about 10 minutes from historic Downtown Mount Dora, you'll have easy access to locally loved restaurants, charming shops, festivals, and the small-town atmosphere the area is known for.
With its brand-new construction, thoughtful upgrades, flexible floor plan, no rear neighbors, and incredible community amenities, this home offers an easy Florida lifestyle from the moment you move in. Schedule your private showing today.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->DirectionFaces
⇄⧉public Directions -> string (326) "From 429 N take exit 38 Kelly Park Rd, turn left onto Co Rd 437/ Plymouth So...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Directions
From 429 N take exit 38 Kelly Park Rd, turn left onto Co Rd 437/ Plymouth Sorrento Rd. Then turn right on Sorrento Ave then left on Co Rd 437. Continue then turn left on FL 44W. Turn left into the community on Mt Dora Blvd. Follow the roundabout to Bridgeport Bay Cir then follow to Kennebunk Loop. House will be on the right.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Utilities
BB/HS Internet Available,Cable Available,Electricity Connected,Fiber Optics,Natural Gas Available,Natural Gas Connected,Public,Sewer Connected,Sprinkler Recycled,Underground Utilities,Water Connected
⇄⧉public Vegetation -> array (1)
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Vegetation
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (2314) "Welcome to this brand-new home in Lakes of Mount Dora, a sought-after 55+ co...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_PublicRemarksAgent
Welcome to this brand-new home in Lakes of Mount Dora, a sought-after 55+ community offering an active lifestyle, beautiful surroundings, and NO CDD fees. This upgraded St. Thomas floor plan features 3 bedrooms, 2 bathrooms, plus a dedicated office that could easily be converted into a 4th bedroom if desired. With no rear neighbors, the home offers added privacy and a peaceful setting to enjoy every day.
Inside, luxury vinyl flooring flows throughout the home, creating a clean and cohesive look that is both stylish and easy to maintain. The kitchen features quartz countertops, a gas stove, and a spacious walk-in pantry with upgraded wood shelving. The upgraded wood shelving continues throughout the bedroom closets and linen closets, adding both function and a custom feel. Quartz countertops are also featured in the bathrooms, while vaulted ceilings help make the main living areas feel bright, open, and spacious. A tankless water heater adds another touch of efficiency and convenience.
Since the home is brand new and still covered by the builder's warranty, you can enjoy the benefits of new construction without the wait.
Living in Lakes of Mount Dora is about much more than the home itself. The community is centered around an impressive 18,000-square-foot clubhouse with a fitness center, library, resort-style pool, billiards room, card room, craft room, and spacious social hall with events and activities throughout the year. Outdoor amenities include a fire pit, tennis and pickleball courts, croquet, bocce ball, cornhole, and a softball field.
Private golf cart access connects the community to the Country Club of Mount Dora for dining and golf, and a future boat ramp is planned to provide access to scenic Loch Leven Lake for gas-powered boats. The $290 monthly HOA fee also includes access to secured, fenced boat and RV storage.
Located just about 10 minutes from historic Downtown Mount Dora, you'll have easy access to locally loved restaurants, charming shops, festivals, and the small-town atmosphere the area is known for.
With its brand-new construction, thoughtful upgrades, flexible floor plan, no rear neighbors, and incredible community amenities, this home offers an easy Florida lifestyle from the moment you move in. Schedule your private showing today.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_OriginatingSystemName_
⇄⧉public MFR_AmenitiesAdditionalFees -> string (234) "The community features approximately 4.5 miles of scenic, man-made lakes - p...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_AmenitiesAdditionalFees
The community features approximately 4.5 miles of scenic, man-made lakes - perfect for catch-and-release fishing. These waters welcome electric boats, kayaks, canoes, and other non-motorized watercraft, but prohibit gas-powered boats.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_AssociationFeeRequirement
⇄⧉public MFR_AdditionalWaterInformation -> string (234) "The community features approximately 4.5 miles of scenic, man-made lakes - p...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_AdditionalWaterInformation
The community features approximately 4.5 miles of scenic, man-made lakes - perfect for catch-and-release fishing. These waters welcome electric boats, kayaks, canoes, and other non-motorized watercraft, but prohibit gas-powered boats.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1866) "WATERFRONT LIVING AT ITS BEST! Enjoy spectacular waterfront views and the re...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->PublicRemarks
WATERFRONT LIVING AT ITS BEST! Enjoy spectacular waterfront views and the relaxed Florida lifestyle in this beautifully renovated, single-story 2-bedroom, 2-bath end-unit villa in the desirable 55+ community of Casco Dorado. Perfectly positioned on a protected deep-water canal with direct access to Palma Sola Bay, this exceptional waterfront home provides a front-row seat to Florida's natural beauty. Relax on your lanai, back porch, or seawall while enjoying peaceful water views and watching manatees, dolphins, mullet, birds, and other local wildlife that frequent the canal. This beautifully renovated end-unit villa features a bright and open floor plan with slip-resistant ceramic tile throughout, crown molding, and new interior doors. The updated kitchen features stainless steel appliances, while both bathrooms have been completely remodeled. The living area flows into a climate-controlled lanai overlooking the water, creating wonderful additional living space for relaxing, entertaining, or simply enjoying the tranquil waterfront setting and additional conveniences. This home also includes a shaded, and conveniently located carport parking space. Residents of Casco Dorado enjoy a heated community pool and an active clubhouse featuring Wi-Fi, fitness facilities, billiards, yoga classes, and guest spaces, all within a friendly and well-maintained waterfront community. Ideally located just minutes from Anna Maria Island and its beautiful Gulf beaches, IMG Academy, G.T. Bray Park, restaurants, shopping, and everyday conveniences. Enjoy the ability to walk or bike to nearby destinations while taking advantage of everything this coastal location provides. Annual lease includes internet, cable, water, sewer, and trash. Pet-friendly. Come experience the peaceful waterfront lifestyle and make this beautiful Casco Dorado villa your next home!
⇄⧉public Appliances -> string (83) "Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Range,Refrigerator...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Appliances
Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Range,Refrigerator,Washer
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_BuildingNameNumber
⇄⧉public MFR_PublicRemarksAgent -> string (1866) "WATERFRONT LIVING AT ITS BEST! Enjoy spectacular waterfront views and the re...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_PublicRemarksAgent
WATERFRONT LIVING AT ITS BEST! Enjoy spectacular waterfront views and the relaxed Florida lifestyle in this beautifully renovated, single-story 2-bedroom, 2-bath end-unit villa in the desirable 55+ community of Casco Dorado. Perfectly positioned on a protected deep-water canal with direct access to Palma Sola Bay, this exceptional waterfront home provides a front-row seat to Florida's natural beauty. Relax on your lanai, back porch, or seawall while enjoying peaceful water views and watching manatees, dolphins, mullet, birds, and other local wildlife that frequent the canal. This beautifully renovated end-unit villa features a bright and open floor plan with slip-resistant ceramic tile throughout, crown molding, and new interior doors. The updated kitchen features stainless steel appliances, while both bathrooms have been completely remodeled. The living area flows into a climate-controlled lanai overlooking the water, creating wonderful additional living space for relaxing, entertaining, or simply enjoying the tranquil waterfront setting and additional conveniences. This home also includes a shaded, and conveniently located carport parking space. Residents of Casco Dorado enjoy a heated community pool and an active clubhouse featuring Wi-Fi, fitness facilities, billiards, yoga classes, and guest spaces, all within a friendly and well-maintained waterfront community. Ideally located just minutes from Anna Maria Island and its beautiful Gulf beaches, IMG Academy, G.T. Bray Park, restaurants, shopping, and everyday conveniences. Enjoy the ability to walk or bike to nearby destinations while taking advantage of everything this coastal location provides. Annual lease includes internet, cable, water, sewer, and trash. Pet-friendly. Come experience the peaceful waterfront lifestyle and make this beautiful Casco Dorado villa your next home!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2041) "One or more photo(s) has been virtually staged. **Virtually Staged – Modern ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->PublicRemarks
One or more photo(s) has been virtually staged. **Virtually Staged – Modern Luxury, Move-In Ready!**
Welcome to this beautifully crafted 4-bedroom, 2-bathroom home where contemporary design meets everyday comfort. Although the original exterior walls were constructed in 2000, this home underwent a complete transformation and received its **Certificate of Occupancy in 2025**, offering the confidence and appeal of modern construction.
From the moment you step inside, you'll be impressed by the soaring ceilings, abundant natural light, and spacious open-concept floor plan designed for today's lifestyle. The seamless flow between the living, dining, and kitchen areas creates the perfect setting for entertaining family and friends or simply enjoying everyday living.
The stunning chef-inspired kitchen showcases premium finishes, stylish cabinetry, and ample workspace, making it as functional as it is beautiful. Throughout the home, you'll find luxury flooring and thoughtfully selected high-end finishes that create an elegant, cohesive design.
The spacious primary suite serves as your private retreat, featuring a spa-like atmosphere and an oversized walk-in closet with the feel of a personal dressing room.
Step outside to an expansive backyard with plenty of room to design your dream outdoor living space—including space for a future pool. Whether you envision weekend barbecues, a tropical garden, or relaxing evenings under the Florida sky, the possibilities are endless.
This exceptional home offers the perfect combination of modern luxury, quality craftsmanship, and peace of mind with its **2025 Certificate of Occupancy**. Don't miss your opportunity to own this truly move-in-ready property.
**Buyer Incentive:** Our preferred lender offers **up to 1% lender credit** toward closing costs or rate buy-down for qualified buyers.
This version is more inviting, emphasizes the value of the 2025 Certificate of Occupancy, and presents the history of the home positively while remaining accurate.
⇄public Appliances -> string (70) "Dishwasher,Disposal,Electric Water Heater,Microwave,Range,Refrigerator"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->Appliances
⇄public AttachedGarageYN -> boolean true
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->AttachedGarageYN
⇄public BathroomsFull -> integer 2
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->BathroomsFull
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1993) "**Virtually Staged – Modern Luxury, Move-In Ready!** Welcome to this beautif...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_PublicRemarksAgent
**Virtually Staged – Modern Luxury, Move-In Ready!**
Welcome to this beautifully crafted 4-bedroom, 2-bathroom home where contemporary design meets everyday comfort. Although the original exterior walls were constructed in 2000, this home underwent a complete transformation and received its **Certificate of Occupancy in 2025**, offering the confidence and appeal of modern construction.
From the moment you step inside, you'll be impressed by the soaring ceilings, abundant natural light, and spacious open-concept floor plan designed for today's lifestyle. The seamless flow between the living, dining, and kitchen areas creates the perfect setting for entertaining family and friends or simply enjoying everyday living.
The stunning chef-inspired kitchen showcases premium finishes, stylish cabinetry, and ample workspace, making it as functional as it is beautiful. Throughout the home, you'll find luxury flooring and thoughtfully selected high-end finishes that create an elegant, cohesive design.
The spacious primary suite serves as your private retreat, featuring a spa-like atmosphere and an oversized walk-in closet with the feel of a personal dressing room.
Step outside to an expansive backyard with plenty of room to design your dream outdoor living space—including space for a future pool. Whether you envision weekend barbecues, a tropical garden, or relaxing evenings under the Florida sky, the possibilities are endless.
This exceptional home offers the perfect combination of modern luxury, quality craftsmanship, and peace of mind with its **2025 Certificate of Occupancy**. Don't miss your opportunity to own this truly move-in-ready property.
**Buyer Incentive:** Our preferred lender offers **up to 1% lender credit** toward closing costs or rate buy-down for qualified buyers.
This version is more inviting, emphasizes the value of the 2025 Certificate of Occupancy, and presents the history of the home positively while remaining accurate.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_BuildingAreaTotalSrchSqM
⇄⧉public MFR_PublicRemarksAgentSpanish -> UTF-8 string (2016) "**¡Virtualmente Amueblada – Lujo Moderno Listo para Estrenar!** Descubra el ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_PublicRemarksAgentSpanish
**¡Virtualmente Amueblada – Lujo Moderno Listo para Estrenar!**
Descubra el equilibrio perfecto entre elegancia, comodidad y diseño contemporáneo en esta espectacular residencia de **4 habitaciones y 2 baños**. Aunque las paredes exteriores originales fueron construidas en el año 2000, la propiedad fue completamente renovada y recibió su **Certificado de Ocupación (Certificate of Occupancy) en 2025**, ofreciendo la tranquilidad y calidad de una vivienda prácticamente nueva.
Desde el momento en que ingrese, quedará impresionado por sus techos altos, abundante luz natural y un amplio concepto abierto que integra armoniosamente la sala, el comedor y la cocina, creando el ambiente ideal para compartir con familiares y amigos o disfrutar del día a día con total comodidad.
La cocina, diseñada para quienes disfrutan cocinar y recibir invitados, combina funcionalidad y sofisticación con acabados de alta gama, elegantes gabinetes y amplias superficies de trabajo. Los pisos de lujo y los detalles cuidadosamente seleccionados aportan un estilo moderno y refinado a cada espacio del hogar.
La suite principal es un verdadero refugio privado, con un espacioso vestidor (walk-in closet) que ofrece la sensación de un elegante cuarto de vestir.
En el exterior encontrará un amplio patio trasero con espacio suficiente para construir la piscina de sus sueños, crear una cocina de verano o diseñar el oasis perfecto para disfrutar del estilo de vida de Florida durante todo el año.
Esta propiedad combina el encanto de una construcción sólida con todas las ventajas y comodidades de una renovación moderna, respaldada por su **Certificado de Ocupación emitido en 2025**. ¡Una oportunidad única para adquirir una residencia lista para mudarse!
**Incentivo para el comprador:** Nuestro prestamista preferido ofrece **hasta un 0.75% de crédito** para compradores calificados, que puede utilizarse para cubrir costos de cierre o reducir la tasa de interés de su préstamo.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2192) "One or more photo(s) was virtually staged. 2.5% ASSUMABLE VA MORTGAGE + TWO ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->PublicRemarks
One or more photo(s) was virtually staged. 2.5% ASSUMABLE VA MORTGAGE + TWO SEPARATE LIVING SPACES. Opportunities like this are almost impossible to recreate at today’s rates. 12643 Weston Drive combines a spacious 3 bedroom 2.5 bath end-unit townhome with a separate detached apartment + its own private kitchen, bathroom and entrance —creating uncommon flexibility for both personal use and rental income. The main residence previously rented for $3,100/month and the detached suite currently rents for $1,100/month. Live in the main home and rent the apartment. Maximize the property’s income potential by renting both spaces. Keep the studio for guests, extended family, a private office, or your own separate retreat. The main home offers generous living space, excellent storage, a large walk-in primary closet, a renovated bathroom, a large kitchen with wood cabinets and granite countertops, a two-car garage and multiple upstairs balconies. The primary suite enjoys a direct view of the community pool, while the private screened courtyard creates an outdoor living space that feels tucked away from the rest of the neighborhood. Big-ticket updates include the 2025 roof and newly completed exterior paint in 2026. The property is located in Flood Zone X, and the HOA is only approximately $254 per month. Hampton Lakes at Main Street delivers something increasingly hard to find in the area: true walkability. The pool is just steps away, with restaurants, shopping, schools, and everyday conveniences nearby, while Westchase, Citrus Park, and major Tampa roadways are all within easy reach. Then there is the financing. For a qualified buyer, the existing VA mortgage may be assumable at approximately 2.5% APR, subject to lender and VA approval. In today’s market, that rate can translate into meaningful monthly savings compared with current financing options. A separate detached living space. Two-car garage. End-unit location. Pool views. Rental potential. Low HOA. Newer roof. Flood Zone X. And a possible 2.5% assumable mortgage. There are plenty of townhomes for sale. There are very few that offer this many ways to make the numbers — and the lifestyle — work.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2192) "One or more photo(s) was virtually staged. 2.5% ASSUMABLE VA MORTGAGE + TWO ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_PublicRemarksAgent
One or more photo(s) was virtually staged. 2.5% ASSUMABLE VA MORTGAGE + TWO SEPARATE LIVING SPACES. Opportunities like this are almost impossible to recreate at today’s rates. 12643 Weston Drive combines a spacious 3 bedroom 2.5 bath end-unit townhome with a separate detached apartment + its own private kitchen, bathroom and entrance —creating uncommon flexibility for both personal use and rental income. The main residence previously rented for $3,100/month and the detached suite currently rents for $1,100/month. Live in the main home and rent the apartment. Maximize the property’s income potential by renting both spaces. Keep the studio for guests, extended family, a private office, or your own separate retreat. The main home offers generous living space, excellent storage, a large walk-in primary closet, a renovated bathroom, a large kitchen with wood cabinets and granite countertops, a two-car garage and multiple upstairs balconies. The primary suite enjoys a direct view of the community pool, while the private screened courtyard creates an outdoor living space that feels tucked away from the rest of the neighborhood. Big-ticket updates include the 2025 roof and newly completed exterior paint in 2026. The property is located in Flood Zone X, and the HOA is only approximately $254 per month. Hampton Lakes at Main Street delivers something increasingly hard to find in the area: true walkability. The pool is just steps away, with restaurants, shopping, schools, and everyday conveniences nearby, while Westchase, Citrus Park, and major Tampa roadways are all within easy reach. Then there is the financing. For a qualified buyer, the existing VA mortgage may be assumable at approximately 2.5% APR, subject to lender and VA approval. In today’s market, that rate can translate into meaningful monthly savings compared with current financing options. A separate detached living space. Two-car garage. End-unit location. Pool views. Rental potential. Low HOA. Newer roof. Flood Zone X. And a possible 2.5% assumable mortgage. There are plenty of townhomes for sale. There are very few that offer this many ways to make the numbers — and the lifestyle — work.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2481) "Designed by Studio 11. Delivered on the ground floor. Ready now. Behind the ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->PublicRemarks
Designed by Studio 11. Delivered on the ground floor. Ready now.
Behind the gates of Grand Haven, Grand Vista holds just 24 residences — and this is the Oakmont, the largest of the three floorplans at 2,167 square feet, three bedrooms, three full baths, and a private two-car garage. What sets it apart isn't square footage. It's that the interiors were designed by Studio 11, the firm behind some of the world's most recognized luxury hotels, and it shows in every room.
The kitchen alone is worth the walkthrough: European walnut cabinetry with integrated pulls, quartz stone countertops, a hand-glazed emerald tile backsplash laid in a custom geometric pattern, and a full GE appliance package — double wall ovens, cooktop with chimney hood, French-door refrigeration, and a dishwasher drawer. A corner trough sink sits beneath a window wall. A breakfast nook catches the morning light. A pass-through bar opens to the great room so the cook is never separated from the conversation.
The owner's suite is a genuine retreat: a coffered tray ceiling in dramatic charcoal, a sitting area framed by live oaks, and a spa bath with two separate vanities, brushed gold Toto fixtures, a freestanding soaking tub on a tiled plinth, and an oversized walk-in shower clad floor-to-ceiling in book-matched marble-look tile. Two additional bedrooms and two more designer baths — one wrapped in emerald subway tile over an iridescent pebble floor — mean guests are never an afterthought.
Throughout: 10-foot ceilings, crown moulding, seven-inch baseboards, eight-foot solid-core doors in black lacquer with crystal and brass hardware, high-grade LVT flooring, Williams Sonoma lighting, and a full laundry room with washer, dryer, sink, and cabinetry.
As a ground-floor residence, this one lives like a single-family home. Walk straight out from the great room to a screened, tiled patio that opens onto lawn, palms, and preserve — with peeks of the Intracoastal beyond. No elevator. No stairs. Just the door and the outdoors.
The practical case is just as strong: concrete block construction, high-impact windows, Flood Zone X, and monthly dues under $700 that cover water, sewer, cable, high-speed internet, trash, and pest control. Golf in, golf out on a Jack Nicklaus Signature course, with lock-and-leave ease when you travel.
Quiet luxury, fully finished, available immediately. Schedule your private tour. *Photos include staging that is no longer present.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 90
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') 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=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->DirectionFaces
⇄⧉public Directions -> string (201) "Palm Coast Pkwy to Colbert Lane. Left at Grand Haven main entrance, Watersid...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->Directions
Palm Coast Pkwy to Colbert Lane. Left at Grand Haven main entrance, Waterside Pkwy. Through gate down to Riverfront Dr,
take left and follow to Grand Vista Condos. Building A parallel to Intracoastal.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2481) "Designed by Studio 11. Delivered on the ground floor. Ready now. Behind the ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_PublicRemarksAgent
Designed by Studio 11. Delivered on the ground floor. Ready now.
Behind the gates of Grand Haven, Grand Vista holds just 24 residences — and this is the Oakmont, the largest of the three floorplans at 2,167 square feet, three bedrooms, three full baths, and a private two-car garage. What sets it apart isn't square footage. It's that the interiors were designed by Studio 11, the firm behind some of the world's most recognized luxury hotels, and it shows in every room.
The kitchen alone is worth the walkthrough: European walnut cabinetry with integrated pulls, quartz stone countertops, a hand-glazed emerald tile backsplash laid in a custom geometric pattern, and a full GE appliance package — double wall ovens, cooktop with chimney hood, French-door refrigeration, and a dishwasher drawer. A corner trough sink sits beneath a window wall. A breakfast nook catches the morning light. A pass-through bar opens to the great room so the cook is never separated from the conversation.
The owner's suite is a genuine retreat: a coffered tray ceiling in dramatic charcoal, a sitting area framed by live oaks, and a spa bath with two separate vanities, brushed gold Toto fixtures, a freestanding soaking tub on a tiled plinth, and an oversized walk-in shower clad floor-to-ceiling in book-matched marble-look tile. Two additional bedrooms and two more designer baths — one wrapped in emerald subway tile over an iridescent pebble floor — mean guests are never an afterthought.
Throughout: 10-foot ceilings, crown moulding, seven-inch baseboards, eight-foot solid-core doors in black lacquer with crystal and brass hardware, high-grade LVT flooring, Williams Sonoma lighting, and a full laundry room with washer, dryer, sink, and cabinetry.
As a ground-floor residence, this one lives like a single-family home. Walk straight out from the great room to a screened, tiled patio that opens onto lawn, palms, and preserve — with peeks of the Intracoastal beyond. No elevator. No stairs. Just the door and the outdoors.
The practical case is just as strong: concrete block construction, high-impact windows, Flood Zone X, and monthly dues under $700 that cover water, sewer, cable, high-speed internet, trash, and pest control. Golf in, golf out on a Jack Nicklaus Signature course, with lock-and-leave ease when you travel.
Quiet luxury, fully finished, available immediately. Schedule your private tour. *Photos include staging that is no longer present.
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=60&$filter=(Appliances eq \'Luxury Vinyl\' OR ArchitecturalStyle eq \'Luxury Vinyl\' OR CommunityFeatures eq \'Luxury Vinyl\' OR Cooling eq \'Luxury Vinyl\' OR CountyOrParish eq \'Luxury Vinyl\' OR ElementarySchool eq \'Luxury Vinyl\' OR ExteriorFeatures eq \'Luxury Vinyl\' OR Flooring eq \'Luxury Vinyl\' OR Heating eq \'Luxury Vinyl\' OR HighSchool eq \'Luxury Vinyl\' OR InteriorFeatures eq \'Luxury Vinyl\' OR ListingTerms eq \'Luxury Vinyl\' OR MiddleOrJuniorSchool eq \'Luxury Vinyl\' OR ParkingFeatures eq \'Luxury Vinyl\' OR PoolFeatures eq \'Luxury Vinyl\' OR PropertyType eq \'Luxury Vinyl\' OR Roof eq \'Luxury Vinyl\' OR SchoolDistrict eq \'Luxury Vinyl\' OR Sewer eq \'Luxury Vinyl\' OR Utilities eq \'Luxury Vinyl\' OR WaterfrontFeatures eq \'Luxury Vinyl\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']