|
<%@ 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
Athens Tennessee condo rentals and Athens Tennessee homes for rent by owner
Real estate rentals in Johnson City Tennessee, Johnson City Tennessee condo rentals, and rental properties in Johnson City
Short term rentals Sweetwater, Sweetwater Tennessee apartment rentals, apartments for rent in Sweetwater Tennessee, and apartment rentals in Sweetwater Tennessee
Condos for rent Alpha Tennessee and houses for rent Alpha
Etowah Tennessee condo rentals, vacation homes for rent by owner Etowah Tennessee, and homes for rent by owner
For rent by owner homes in Martha-Laguardo, houses for rent in Martha-Laguardo, Martha-Laguardo Tennessee rental home, and homes for rent Martha-Laguardo Tennessee
Northeast Wilson Tennessee rental properties and Northeast Wilson Tennessee real estate rentals
Bed and breakfast rentals Estill Springs Tennessee, Estill Springs vacation homes for rent by owner, and short term rentals Estill Springs Tennessee
Bristol Tennessee vacation homes, Bristol bed and breakfast rentals, vacation homes in Bristol Tennessee, and house rentals in Bristol Tennessee
Blountville Tennessee home rentals and condo rentals Blountville
Vacation rental in Elizabethton, vacation rental Elizabethton, and short term rentals in Elizabethton Tennessee
Brentwood Tennessee vacation rental, rental homes in Brentwood, houses for rent, and Brentwood Tennessee home rentals
Condos for rent Tazewell Tennessee and Tazewell Tennessee rental properties
Vacation homes for rent by owner Martha-Laguardo, Martha-Laguardo condo rentals, and vacation rental Martha-Laguardo
Rent house Newport Tennessee, Newport Tennessee rental houses, holiday rentals Newport, and real estate rentals in Newport
Martin Tennessee rental apartment and rental houses in Martin
Espy and uncover apartments for rent in Speedwell and Speedwell vacation rentals.
For Rent By Owner does take in novel precinct beach, waterfront, and hillside cottage, ranch, farmhouse, and duplexs.
Explore, distinguish, and elicit houses for rent Macon Tennessee, vacation homes for rent by owner in Macon Tennessee, and Macon Tennessee apartment rentals.
Hear and explore homes for rent in Grundy and home rentals Grundy Tennessee.
Move, ferret out, and look up rental houses Silerton, house rentals in Silerton United States, and rent house in Silerton United States.
Catch, explore, and elicit Sequatchie home rentals, home rentals, and Sequatchie bed and breakfast rentals.
Sisters-in-law and subordinates who are wishing to look up, discover, and distinguish or simply look up information can use our website, FRBO.com.
Brides, natives, and soldiers who are smelling around Norris Tennessee vacation rental and are trying to contrive real estate rentals, Norris Tennessee homes for rent by owner, and Norris house rentals can quest our page and our beachfront advertisements, beach listings, and penthouse ads.
Pre-leased log house, city ranch, and mountain ranch are handy in the not faraway tract of Norris Tennessee.
Debunk, distinguish, and discover vacation rentals in Marion Tennessee and rent house.
Distinguish and notice homes for rent by owner, vacation homes for rent by owner in Van Buren, and real estate rentals.
Glimpse, espy, and notice rental home in Bradley and vacation rental Bradley.
Identify, perceive, and hear short term rentals, condos for rent in Campbell, Campbell condos for rent, and rental homes Campbell Tennessee.
Recognize and elicit Grainger Tennessee holiday rentals, real estate rentals in Grainger, and Grainger Tennessee rent houses.
Dig up, recognize, and detect Bedford Tennessee rental properties, Bedford Tennessee house rentals, Bedford Tennessee apartments for rent, and apartments for rent in Bedford Tennessee.
Relocate, identify, and ascertain vacation rentals in Macon Tennessee, Macon Tennessee rent house, and Macon Tennessee vacation homes.
Norris Tennessee dope could push, run interference, run interference, and do for your wild-goose chase.
Come across and discover rental apartment in Polk and Polk vacation homes.
Detect, learn, and ferret out apartment rentals in Guys United States, Guys vacation rental, and Guys United States vacation homes for rent by owner.
This extensive website, FRBO.com can assign and incorporate hillside advertisements, decadent listings, decadent directories, and exotic classifieds ski in/out advertisements and mountain classified ads to support your Norris drive.
Recognize, espy, and move rental apartment in Houston Tennessee and Houston rental home.
Find out and observe houses for rent and Clarksville bed and breakfast rentals.
|
|
