'" . date("Y-m-d") . "'"; $Where = "WHERE rentals.listingexpires <> '0000-00-00' AND rentals.oktolist = 'Y'"; $Fields = "SELECT DISTINCT rentals.rentalid, rentallocation, rentalcity, rentals.listingheadline, listing, sourceid, source, "; $Fields .= "daily1, daily2, daily3, daily4, ratesfrom, states.statecode, states.statename, "; $Fields .= "rentals.isfeatured, rentals.featuredexpires, featuredcityexpires, featuredstateexpires, featuredcountryexpires, featuredworldexpires, "; $Fields .= "countryname, rentalcountrycode, "; $Fields .= "rentals.primaryphotoid, rentals.featuredphotoid, photos.filename "; $Tables = " FROM rentals LEFT JOIN states ON rentals.rentalstatecode = states.statecode "; $Tables .= " LEFT JOIN countries ON rentals.rentalcountrycode = countries.countrycode "; $Tables .= " LEFT JOIN photos ON rentals.primaryphotoid = photos.photoid "; $Query = $Fields . $Tables . $Where . " AND rentalcountrycode = 'US' ORDER BY datecreated desc LIMIT 18"; mysqli_select_db($Vacation,$database_Vacation); $query_Recordset1 = sprintf($Query); $Recordset1 = mysqli_query( $Vacation,$query_Recordset1) or die(mysqli_error()); //$row_Recordset1 = mysqli_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysqli_num_rows($Recordset1); $Query = $Fields . $Tables . $Where . " AND rentalcountrycode <> 'US' ORDER BY datecreated desc LIMIT 18"; mysqli_select_db($Vacation,$database_Vacation); $query_Recordset2 = sprintf($Query); $Recordset2 = mysqli_query( $Vacation ,$query_Recordset2) or die(mysqli_error()); //$row_Recordset2 = mysqli_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysqli_num_rows($Recordset2); $FeaturedField = "world-region-country"; $page_title = "New Vacation Rental Listings"; include('includes/topchoice-header.php'); ?>

NEW VACATION RENTAL LISTINGS

Welcome to Top Choice Vacation Rentals New Listings!

Travelers: Browse here to view the most recent vacation rentals listed on Top Choice Vacation Rentals! Check often for new listings in your favorite vacation destinations.

Property Owners: Your new listings will show here as well as in the regular listing directory. Your property will receive additional exposure as travelers will check the new listings page for postings of new vacation properties, as well as the regular directories.
JOIN US - LIST YOUR VACATION RENTAL

New International Vacation Rentals

Vacation Rental #

More Information

New United States Vacation Rentals

Vacation Rental #

More Information

Printer-Friendly Page | Bookmark This Vacation Rental Site | Email This Page to a Friend Email This Page to a Friend