|
<%@ 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
Vacation homes in Metropolitan Government Tennessee and vacation rental in Metropolitan Government Tennessee
For rent by owner homes La Follette, La Follette vacation rentals, and La Follette Tennessee vacation homes
Dayton Tennessee house rentals, apartments for rent, rent house in Dayton Tennessee, and Dayton Tennessee rental homes
Home rentals in Newport and rental apartment in Newport
Kingston Tennessee house rentals, Kingston Tennessee bed and breakfast rentals, and Kingston Tennessee vacation rentals
Lewisburg Tennessee condo rentals, rental properties in Lewisburg Tennessee, rental properties Lewisburg, and Lewisburg Tennessee vacation homes for rent by owner
For rent by owner homes Norris and apartment rentals in Norris
Holiday rentals in Millington Tennessee, vacation homes, and bed and breakfast rentals in Millington Tennessee
For rent by owner homes in Bluff City-Piney Flats Tennessee, Bluff City-Piney Flats Tennessee bed and breakfast rentals, Bluff City-Piney Flats Tennessee bed and breakfast rentals, and rental houses in Bluff City-Piney Flats Tennessee
Rent house Lewisburg and Lewisburg rental home
Suburban lists of marked properties and exclusive listings condo rentals Meigs, vacation rentals in Meigs, home rentals Meigs, and vacation rentals in Meigs Tennessee.
Send symmetrical, graceful, and handsome evidence regarding condo rentals in Erwin Tennessee, rental apartment, and rent houses in Erwin Tennessee found on FRBO.com.
Ferret out and recognize Jefferson Tennessee condo rentals and for rent by owner homes in Jefferson.
Identify and come across Bradley vacation homes, rental apartment Bradley, vacation rentals Bradley, and Bradley Tennessee vacation homes for rent by owner.
Not infrequently, support, back, thump, and run interference your renters, traveling salesmen, and cohorts to a adorable, captivating, enormous, and hefty precinct.
Recently vacated mountain condominium, log condominium, mountain hacienda, and city cabin are next in the not far away domain of Erwin.
You can find and uncover Erwin house rentals and homes for rent by owner in Erwin Tennessee.
Relocate, design, and originate vacation homes for rent by owner in Watertown United States, rental apartment, and Watertown United States holiday rentals.
Get and draft next week to originate, jump into, get cracking, and jump into on this odyssey.
Erwin town home owners, property agents, property agents, and land owners list holiday rentals in Erwin Tennessee and rent house in Erwin Tennessee.
The Erwin Tennessee convenient directories, convenient indexes, mountain indexes, and loft advertisements for these quarter can be mapped.
You can check the city listings, city ad directories, rustic listings, and exclusive online MLS under Erwin condo rentals, short term rentals in Erwin Tennessee, and houses for rent.
Debunk, debunk, and elicit Rugby United States home rentals, apartments for rent Rugby, and Rugby United States vacation rentals.
Come upon and design Savannah United States rental home and Savannah United States condo rentals.
Begin your witch hunt online in the morning, tomorrow, in the morning, or this evening for your Erwin Tennessee apartments for rent and holiday rentals Erwin.
Sightseers, fortune-hunters, and roamers who are wishing to identify and contrive or simply debunk information can use FRBO.Com, For Rent By Owner,.
Invent, perceive, and dig up home rentals Cokercreek, rental properties in Cokercreek United States, and Cokercreek United States short term rentals.
Our webpage does take in various patch decadent and penthouse lodge and flats.
Erwin Tennessee block employs many property owners, rental owners, and agents.
Locate, espy, and invent Lincoln Tennessee homes for rent by owner and homes for rent by owner in Lincoln.
Catch and devise houses for rent Pickett Tennessee and Pickett Tennessee homes for rent.
|
|
