'" . 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

 

  icon Vacation Rental #

Vacation Rental



iconMore Information


  New United States Vacation Rentals

 

  icon Vacation Rental #

Vacation Rental



iconMore Information



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

Home | Vacation Rental FAQ's | About Top Choice Vacation Rentals | Contact Us | Vacation Rental Press Room
TCVR Members Log In | List Your Rental | Properties For Sale | Vacation Rentals Specials | Featured Rentals
Calendar of Events | Renters Testimonials | Join Our Frequent User E-Club | E Vacation Planner
New Vacation Rental Listings | Link with Us | Our Friends


Copyright © 2005 by Top Choice Vacation Rentals All Rights Reserved

 

Copyright © 2005 by Top Choice Vacation Rentals All Rights Reserved | Privacy & Legal Statement | Site Map