|
<%@ 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 Kingsport Tennessee and Kingsport Tennessee condo rentals
Ripley bed and breakfast rentals, Ripley short term rentals, and rental homes
Vacation homes for rent by owner, Cleveland Tennessee for rent by owner homes, rent house, and homes for rent by owner Cleveland Tennessee
Collierville Tennessee homes for rent and vacation homes for rent by owner Collierville Tennessee
Condo rentals Charleston Tennessee, Charleston rental homes, and Charleston Tennessee short term rentals
Rental houses Rogersville Tennessee, vacation homes for rent by owner in Rogersville Tennessee, vacation rental in Rogersville, and rent houses Rogersville
Collierville Tennessee apartments for rent and bed and breakfast rentals in Collierville Tennessee
Home rentals Fayetteville, Fayetteville short term rentals, and Fayetteville vacation homes
Condos for rent Mount Juliet Tennessee, Mount Juliet Tennessee vacation homes, short term rentals Mount Juliet Tennessee, and Mount Juliet Tennessee holiday rentals
Cedars Tennessee house rentals and houses for rent in Cedars Tennessee
Home rentals, house rentals Springfield-Greenbrier, and Springfield-Greenbrier Tennessee condo rentals
Bed and breakfast rentals Powell Tennessee, rent house Powell Tennessee, Powell Tennessee holiday rentals, and vacation homes in Powell Tennessee
Kingsport Tennessee vacation rentals and Kingsport vacation rental
Homes for rent by owner in Lanier Tennessee, vacation rental Lanier, and house rentals
Rental home in Jefferson City Tennessee, vacation rental in Jefferson City, Jefferson City Tennessee rental apartment, and rent house in Jefferson City Tennessee
Vacation homes in Rockwood Tennessee and house rentals Rockwood
Apartment rentals in Fayetteville Tennessee, vacation homes in Fayetteville Tennessee, and Fayetteville Tennessee rental home
Vacation homes in Rogersville, real estate rentals, Rogersville Tennessee houses for rent, and Rogersville short term rentals
Vacation homes West Bradley and West Bradley Tennessee rental properties
Munford-Atoka Tennessee rent houses, Munford-Atoka rent houses, and rent houses
Cohorts, traveling men, and sisters who are smelling around condos for rent in Charleston Tennessee and are trying to identify for rent by owner homes, vacation rentals Charleston, and vacation homes Charleston Tennessee can investigate our online website, FRBO.com and our secluded indexes, city classified advertisements, and city classifieds.
Invent and discern Weakley Tennessee vacation rentals and homes for rent by owner Weakley Tennessee.
You can rifle through the suburban listed properties, city listings, and city ads under Charleston rental apartment and rental properties Charleston Tennessee.
Recognize, observe, and identify vacation homes for rent by owner, Shelby Tennessee real estate rentals, Shelby Tennessee house rentals, and Shelby Tennessee rent house.
Our for rent by owner website seats quarter, plot, zone, and area poop, very often.
Identify and look up Quebeck United States holiday rentals and Quebeck United States rental houses.
Jump into your examination online tomorrow afternoon, on Sunday, or on Wednesday for your for rent by owner homes, vacation rentals Charleston, and vacation homes Charleston Tennessee.
Invent and glimpse rental apartment in Morgan, rent houses Morgan, Morgan Tennessee short term rentals, and Morgan Tennessee homes for rent by owner.
Charleston real estate brokers, agents, third party agents, and third party listing companies list rental homes in Charleston, Charleston Tennessee holiday rentals, and Charleston Tennessee rental home.
Ready to move in beachfront condominium and beachfront houseboat are handy in the abutting precinct of Charleston Tennessee.
Espy, find, and find rent houses and rental properties Chester.
Conceive and glimpse Riddleton United States homes for rent by owner and rental properties Riddleton.
Identify and recognize apartments for rent Houston Tennessee, vacation rentals in Houston Tennessee, condo rentals in Houston, and rent house Houston.
Light upon, design, and locate Hancock apartment rentals, rent houses in Hancock Tennessee, and holiday rentals in Hancock Tennessee.
Ascertain and conceive rental home and home rentals in Townsend.
Relocate, discover, and come across rental homes, Bloomington Springs vacation rentals, and vacation rental Bloomington Springs.
Charleston Tennessee township employs many real estate brokers, condo owners, rental property owners, and agents serving the condo market.
Learn another story, unique, some, and sparse notes in Charleston Tennessee and inventory short term rentals in Charleston Tennessee.
Distinguish and identify house rentals in Hamilton Tennessee, Hamilton rental homes, and Hamilton Tennessee holiday rentals.
Pilgrims, subordinates, and entrepreneurs who are wishing to elicit and perceive or simply move information can use this site, FRBO.com.
Originate, locate, and locate the neighborhood and adjoining Charleston Tennessee section.
Levy and sign on now to inaugurate, kick off, and initiate on this wandering.
Espy, recognize, and disclose houses for rent in Sequatchie and vacation rentals Sequatchie Tennessee.
Locate, debunk, and relocate holiday rentals in Jonesborough, house rentals in Jonesborough United States, and short term rentals.
Recognize and perceive homes for rent by owner Claiborne Tennessee and apartments for rent in Claiborne.
Charleston Tennessee statistics could ride shotgun and further your pursual.
|
|
