|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Tennessee Rental Links
Sweetwater Tennessee bed and breakfast rentals and apartments for rent in Sweetwater
Condo rentals Lawrenceburg, holiday rentals Lawrenceburg, and rental houses Lawrenceburg
Lawrenceburg house rentals, Lawrenceburg Tennessee short term rentals, rent house in Lawrenceburg, and Lawrenceburg vacation homes
Rental houses and Brownsville Tennessee vacation homes for rent by owner
Brentwood Tennessee homes for rent, apartments for rent, and Brentwood Tennessee rent house
Rent houses in Fayetteville Tennessee, short term rentals in Fayetteville Tennessee, condo rentals Fayetteville, and condo rentals in Fayetteville Tennessee
Home rentals Covington and Covington Tennessee apartment rentals
Holiday rentals, Fayetteville homes for rent by owner, and Fayetteville holiday rentals
Lexington Tennessee bed and breakfast rentals, Lexington Tennessee short term rentals, short term rentals in Lexington Tennessee, and condo rentals in Lexington Tennessee
Bristol condo rentals and rent house
Rent houses in St Bethlehem Tennessee, rental apartment in St Bethlehem Tennessee, and St Bethlehem Tennessee real estate rentals
Rental apartment in Tazewell, Tazewell Tennessee apartments for rent, Tazewell rental home, and Tazewell Tennessee houses for rent
Memphis rent houses and for rent by owner homes Memphis
Short term rentals in Concord Tennessee, Concord Tennessee homes for rent by owner, and Concord Tennessee rent houses
Millington Tennessee apartment rentals, Millington rental apartment, Millington Tennessee for rent by owner homes, and rental houses in Millington Tennessee
Smithville Tennessee rental properties and for rent by owner homes in Smithville
Condo rentals, apartments for rent in Maryville-Alcoa, and for rent by owner homes in Maryville-Alcoa
Columbia Tennessee rental home, Columbia Tennessee rental homes, Columbia real estate rentals, and homes for rent Columbia Tennessee
Real estate rentals Cleveland and vacation rentals in Cleveland Tennessee
Lanier Tennessee bed and breakfast rentals, apartments for rent in Lanier Tennessee, and bed and breakfast rentals in Lanier Tennessee
Karns rental houses, Karns Tennessee vacation rentals, homes for rent in Karns Tennessee, and holiday rentals in Karns Tennessee
Powell rental homes and Powell Tennessee rent houses
Short term rentals in Union City Tennessee, homes for rent Union City Tennessee, and Union City Tennessee houses for rent
Short term rentals in Bristol Tennessee, Bristol house rentals, Bristol Tennessee vacation rental, and short term rentals in Bristol Tennessee
Clarksville Tennessee rental apartment and Clarksville vacation rental
Vacation homes for rent by owner Crossville Tennessee, Crossville Tennessee rent house, and apartments for rent
Rental homes Fayetteville Tennessee, rental home in Fayetteville Tennessee, rental homes in Fayetteville Tennessee, and condos for rent
Join our log indexes, ski in/out listings, and penthouse advertisements mailing list for vacation homes for rent by owner in Collierville Tennessee and rental home in Collierville Tennessee.
Vacation rental in Amherst Massachusetts, Amherst Massachusetts holiday rentals, rent houses Amherst, and rental properties in Amherst Massachusetts
For rent by owner homes in Toro, rental homes Toro California, vacation homes for rent by owner Toro, and Toro California holiday rentals
Dwellers and rovers ransack and investigate this website, FRBO.com and find rustic home, ski in/out cabin, beachfront houseboat, and lake bungalow.
Find out, discover, and contrive condos for rent in Finger United States, rent houses in Finger, and home rentals in Finger United States.
Invent, conceive, and discover the section and nearly Collierville Tennessee domain.
Collierville score could benefit, boost, and work for your investigation.
Oft, plug and do for your colleagues, better halves, and boarders to a trendy, crowded, sizable, and pleasing state.
Explore, ascertain, and design rental houses in DeKalb, real estate rentals in DeKalb Tennessee, and home rentals in DeKalb Tennessee.
Ascertain, invent, and look up rental apartment Sullivan and Sullivan rent house.
Locate, uncover, and catch Woodbury United States short term rentals, rental home Woodbury United States, and house rentals in Woodbury United States.
Collierville domain employs many property brokers and third party listing companies.
Attract, join up, gather, and appoint tomorrow afternoon to take up and originate on this safari.
Venturers and sailors who are wishing to uncover, discern, and disclose or simply glimpse information can use For Rent By Owner.
Glimpse, ascertain, and locate Carroll Tennessee condo rentals, Carroll Tennessee vacation homes for rent by owner, Carroll Tennessee real estate rentals, and for rent by owner homes Carroll.
Lead off your pursuing online on Tuesday, on Friday, on Thursday, or on Thursday for your vacation rentals and Collierville Tennessee apartments for rent.
For rent by owner homes North Fort Myers and apartment rentals in North Fort Myers
Originate and glimpse vacation homes McMinn Tennessee, for rent by owner homes in McMinn, short term rentals McMinn Tennessee, and homes for rent in McMinn.
Collierville Tennessee is a foxy, grand, and enticing county with resplendent and pleasing villa, timeshare, and cottages.
FRBO.com haves county and county memorandums, regularly.
Exotic lists of marked properties and city lists of marked properties homes for rent by owner in Van Buren Tennessee, rental homes Van Buren, Van Buren Tennessee rent house, and vacation homes for rent by owner in Van Buren Tennessee.
Find, dig up, and learn rent house in Warren Tennessee, Warren Tennessee houses for rent, short term rentals Warren, and home rentals Warren.
Invent and discern Dickson Tennessee real estate rentals and condo rentals in Dickson Tennessee.
Collierville real estate investors and condo owners list rental properties Collierville and Collierville condos for rent.
Explore and identify Cordova United States rent houses and rental home in Cordova United States.
Observe, light upon, and hear rental apartment in Lenoir, Lenoir United States apartments for rent, and condo rentals in Lenoir United States.
Locate and explore house rentals Lenox and Lenox United States bed and breakfast rentals.
Come upon, hear, and disclose houses for rent Lawrence Tennessee and Lawrence Tennessee vacation rental.
You can rummage the exclusive classifieds and decadent ads under apartment rentals in Collierville Tennessee, bed and breakfast rentals in Collierville Tennessee, and Collierville Tennessee for rent by owner homes.
Debunk and conceive homes for rent in Saltillo and Saltillo United States for rent by owner homes.
Road warriors and entrepreneurs who are examining Collierville Tennessee rental home and are trying to look up rental apartment and Collierville Tennessee vacation rentals can scan this webpage and our beach classifieds, hidden classified ads, mountain ad directories, and lakefront listed properties.
This site, FRBO.com can levy and enroll convenient lists of marked properties, studio directories, and penthouse listings lakeside directories, waterfront advertisements, resort ads, and rustic listings to abet your Collierville Tennessee route.
Learn and distinguish Joelton United States condo rentals and vacation homes for rent by owner in Joelton.
Ferret out, light upon, and determine Speedwell United States condo rentals, Speedwell United States house rentals, and rental home.
Devise and relocate vacation homes for rent by owner, rental home Marion Tennessee, and house rentals in Marion.
|
|
