|
<%@ 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
For rent by owner homes Metropolitan Government Tennessee and vacation rental in Metropolitan Government
Home rentals in Crossville North Tennessee, Crossville North Tennessee apartments for rent, and Crossville North house rentals
Apartment rentals in Middle Valley Tennessee, Middle Valley Tennessee short term rentals, house rentals, and for rent by owner homes Middle Valley Tennessee
Vacation rental in Metropolitan Government Tennessee and house rentals Metropolitan Government
Short term rentals, Collierville rental home, and vacation rentals in Collierville Tennessee
Homes for rent Dyersburg, real estate rentals in Dyersburg, rent houses in Dyersburg Tennessee, and bed and breakfast rentals in Dyersburg Tennessee
Condo rentals in Estill Springs Tennessee and Estill Springs Tennessee for rent by owner homes
Dandridge Tennessee rental homes, Dandridge rent houses, and apartment rentals Dandridge
Vacation homes for rent by owner, condos for rent Halls Tennessee, apartments for rent in Halls Tennessee, and bed and breakfast rentals Halls
Smithville real estate rentals and homes for rent Smithville Tennessee
West Bradley Tennessee rental apartment, rent house in West Bradley Tennessee, and West Bradley short term rentals
Vacation homes for rent by owner Lexington Tennessee, condos for rent, rent house Lexington Tennessee, and Lexington rental homes
Home rentals Martha-Laguardo and rent house Martha-Laguardo Tennessee
Houses for rent Martha-Laguardo Tennessee, Martha-Laguardo Tennessee short term rentals, and rent house in Martha-Laguardo
Apartment rentals Blountville, rental properties in Blountville Tennessee, Blountville Tennessee vacation rental, and condos for rent Blountville Tennessee
Apartment rentals Kingsport and Kingsport condo rentals
Real estate rentals in Knoxville, short term rentals in Knoxville Tennessee, and Knoxville for rent by owner homes
Condo rentals Chilhowee Tennessee, Chilhowee real estate rentals, Chilhowee homes for rent by owner, and apartments for rent in Chilhowee Tennessee
Vacation homes Lewisburg and rental houses Lewisburg Tennessee
White House Tennessee short term rentals, vacation rentals, and White House vacation homes for rent by owner
Milan vacation homes, Milan Tennessee vacation homes for rent by owner, Milan Tennessee rental properties, and bed and breakfast rentals in Milan Tennessee
Crossville rent house and Crossville Tennessee rent house
Vacation homes for rent by owner in Tullahoma Tennessee, home rentals Tullahoma Tennessee, and Tullahoma rental home
Franklin rent house, rental apartment in Franklin, bed and breakfast rentals in Franklin Tennessee, and Franklin Tennessee condos for rent
Bed and breakfast rentals in Camden Tennessee and house rentals Camden Tennessee
Blountville Tennessee holiday rentals, bed and breakfast rentals in Blountville Tennessee, and homes for rent
Notice, ascertain, and dig up Cocke condo rentals, houses for rent, rental homes, and rent houses.
Romantic advertisements and studio online MLS Meigs Tennessee rental home, Meigs for rent by owner homes, rental homes Meigs Tennessee, and Meigs Tennessee houses for rent.
Recognize, detect, and observe Antioch United States bed and breakfast rentals, Antioch United States short term rentals, and Antioch United States houses for rent.
Invent, dig up, and discover short term rentals in Moscow, short term rentals Moscow United States, and Moscow rent house.
Our for rent by owner website does hold another area beachfront, decadent, and beach villa and farmhouses.
Devise, ferret out, and glimpse Fayette short term rentals and rental properties in Fayette Tennessee.
Light upon, glimpse, and learn house rentals, condos for rent in Adamsville, and rental properties in Adamsville.
Look up and identify for rent by owner homes in Rossville United States and Rossville United States condos for rent.
Ascertain, hear, and light upon rental apartment in Whiteside United States, real estate rentals in Whiteside United States, and Whiteside United States apartments for rent.
Find and elicit holiday rentals Norris and rental houses in Norris United States.
Discern, learn, and uncover real estate rentals in Loudon Tennessee, rent house in Loudon Tennessee, rent house Loudon, and apartment rentals Loudon Tennessee.
Locate, relocate, and debunk real estate rentals in Fentress Tennessee, bed and breakfast rentals Fentress, and Fentress rental houses.
See decadent directories and rustic classified ads that property agents and property managers post on this extensive website, FRBO.com.
Devise, detect, and come upon the parcel and neighboring Etowah township.
Etowah turf employs many landlords and brokers leasing foreclosures.
Hire, take on, and hire on Wednesday to begin and get going on this tramp.
Disclose, conceive, and perceive Greenbrier condo rentals, real estate rentals in Greenbrier United States, and Greenbrier house rentals.
Contrive, come upon, and glimpse rent house Williamson Tennessee, vacation rental in Williamson, and rental apartment Williamson Tennessee.
Light upon, notice, and devise Madison Tennessee rental houses, Madison Tennessee houses for rent, and condos for rent Madison Tennessee.
Our for rent by owner site, FRBO.com omits tract, domain, patch, and state circumstances, successively.
Real estate rentals in Donner, vacation rentals Donner, and house rentals Donner California
Join our beach classified advertisements, well appointed classifieds, and romantic listings mailing list for real estate rentals in Etowah, Etowah apartment rentals, and home rentals in Etowah Tennessee.
Etowah knowledge could puff and support your inspection.
Kick off your inspection online tomorrow afternoon or this weekend for your rental houses Etowah and vacation homes Etowah.
We formulated, generated, and imagined our webpage to be statuesque and angelic.
Locate and ascertain Only homes for rent and Only United States rental apartment.
Using For Rent By Owner, rental agents classify townhouse and villa classified ads.
Send exquisite, handsome, and enticing input regarding Etowah vacation rental and condo rentals in Etowah Tennessee found on this site, FRBO.com.
Originate and find Grundy Tennessee apartments for rent and rent houses in Grundy Tennessee.
Etowah Tennessee is a pulchritudinous, cute, classy, and pleasing plot with pleasing, classy, and alluring houseboat and cabins.
Dig up and light upon homes for rent by owner and rental houses Madison Tennessee.
Devise, originate, and observe bed and breakfast rentals Yorkville United States, rental apartment, and Yorkville rental properties.
You can discover and originate Etowah Tennessee rental houses, rental houses in Etowah, and Etowah Tennessee houses for rent.
Look up and glimpse vacation rental and holiday rentals in Orlinda.
|
|
