|
<%@ 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
Knoxville rental apartment and Knoxville Tennessee condo rentals
Apartment rentals in Sevierville, house rentals in Sevierville Tennessee, and vacation homes Sevierville
Martha-Laguardo rental homes, Martha-Laguardo Tennessee vacation rental, apartment rentals in Martha-Laguardo Tennessee, and Martha-Laguardo short term rentals
Vacation rental and Maryville-Alcoa Tennessee condos for rent
Rental home, bed and breakfast rentals in Kingsport Tennessee, and Kingsport Tennessee rental properties
Bed and breakfast rentals, vacation homes for rent by owner in Tazewell Tennessee, Tazewell real estate rentals, and vacation homes for rent by owner in Tazewell Tennessee
Rental houses in Lenoir City and rental houses Lenoir City
Smithville Tennessee vacation rental, short term rentals Smithville Tennessee, and house rentals Smithville Tennessee
Rental houses Lanier Tennessee, condo rentals in Lanier, vacation rentals in Lanier Tennessee, and vacation homes in Lanier
Greeneville vacation rentals and real estate rentals
House rentals in Burns-White Bluff, Burns-White Bluff Tennessee rental houses, and rental properties in Burns-White Bluff Tennessee
Millington apartments for rent, rental apartment Millington Tennessee, apartments for rent Millington Tennessee, and Millington Tennessee rental home
Martin rent houses and condo rentals in Martin Tennessee
Homes for rent in Brentwood Tennessee, homes for rent in Brentwood Tennessee, and homes for rent Brentwood Tennessee
Rental apartment in Elizabethton Tennessee, houses for rent Elizabethton Tennessee, home rentals Elizabethton Tennessee, and Elizabethton Tennessee rental homes
Rental home in Milan Tennessee and real estate rentals Milan
Memphis Tennessee rental properties, Memphis houses for rent, and apartment rentals
Vacation homes for rent by owner in Cookeville Tennessee, vacation rentals Cookeville Tennessee, for rent by owner homes, and Cookeville Tennessee rental properties
Condo rentals in Cedars Tennessee and Cedars Tennessee homes for rent by owner
Rent houses Erwin, houses for rent in Erwin Tennessee, and vacation rentals Erwin
Condo rentals Jackson Tennessee, holiday rentals in Jackson, Jackson vacation homes, and Jackson Tennessee apartment rentals
Rental properties in Metropolitan Government and houses for rent Metropolitan Government
Clinton Tennessee for rent by owner homes, house rentals Clinton, and Clinton Tennessee bed and breakfast rentals
Rental homes West Chester Tennessee, West Chester Tennessee house rentals, homes for rent by owner West Chester Tennessee, and rental houses West Chester
Rental home Hendersonville Tennessee and Hendersonville Tennessee real estate rentals
Vacation homes in Tullahoma, rental homes Tullahoma Tennessee, and apartment rentals in Tullahoma Tennessee
Rental apartment, Karns Tennessee homes for rent, vacation homes Karns, and rent houses Karns Tennessee
Rent houses Signal Mountain and rental home in Signal Mountain Tennessee
Move and elicit rental home Lake Tennessee, condos for rent, for rent by owner homes in Lake Tennessee, and rental properties Lake Tennessee.
Discover and light upon real estate rentals Camden and Camden United States vacation homes.
Ascertain, identify, and conceive Dickson Tennessee vacation rentals, Dickson vacation homes for rent by owner, Dickson Tennessee house rentals, and vacation homes for rent by owner Dickson Tennessee.
Uncover and come upon rent house in Lewis Tennessee and rental homes Lewis Tennessee.
Distinguish, disclose, and discover condos for rent Gates United States, houses for rent in Gates United States, and vacation rentals Gates United States.
See lakefront lists of marked properties, resort listings, resort lists of marked properties, and waterfront classifieds that land owners and rental property owners post on our website, FRBO.com.
Home rentals in Chesterfield Missouri, condo rentals Chesterfield, Chesterfield for rent by owner homes, and home rentals in Chesterfield Missouri
Cedars rental agents and condo owners list rental houses in Cedars, rental home in Cedars Tennessee, Cedars Tennessee holiday rentals, and vacation homes in Cedars Tennessee.
Recognize, espy, and devise apartment rentals Cannon Tennessee, rent houses in Cannon Tennessee, and rental apartment in Cannon Tennessee.
Move, recognize, and perceive Hermitage United States rental home, Hermitage apartments for rent, and Hermitage United States holiday rentals.
Cedars Tennessee neighborhood employs many rental owners and agents serving the condo market.
Perceive and debunk Pleasantville United States house rentals and vacation homes.
Notice and discern Madison Tennessee homes for rent and Madison rent houses.
Discover, invent, and hear Sullivan rent houses, Sullivan Tennessee rental properties, and Sullivan Tennessee rental properties.
We designed, fabricated, and erected our webpage to be elegant and bewitching.
Design and glimpse Smartt United States vacation rentals and vacation homes Smartt.
Come upon and locate home rentals Laconia United States and vacation rentals in Laconia United States.
Uncover, light upon, and discover vacation homes for rent by owner Rugby United States, Rugby United States vacation homes, and short term rentals in Rugby.
Join our suburban ad directories, decadent online MLS, loft directories, and beachfront listed properties mailing list for vacation rentals in Cedars, short term rentals Cedars Tennessee, and Cedars Tennessee condos for rent.
Cedars Tennessee notes could abet, thump, benefit, and ballyhoo your pursual.
You can determine, determine, and uncover rental home Cedars Tennessee and Cedars Tennessee rent houses.
Observe and hear condo rentals in Copperhill and homes for rent by owner in Copperhill United States.
Glimpse, conceive, and ascertain homes for rent, Moore Tennessee rental home, rental apartment in Moore Tennessee, and Moore Tennessee rent house.
Disclose, identify, and find Parsons United States house rentals, houses for rent in Parsons United States, and rental homes in Parsons.
Dig up, design, and elicit real estate rentals in Smith Tennessee and real estate rentals Smith Tennessee.
Brothers-in-law and journeyers who are probing real estate rentals in Cedars and are trying to perceive real estate rentals in Cedars Tennessee, Cedars Tennessee house rentals, and vacation rentals can ransack For Rent By Owner and our exclusive classifieds, log classified advertisements, and private advertisements.
Perceive, come upon, and observe vacation rental, condo rentals Marion Tennessee, short term rentals in Marion Tennessee, and homes for rent by owner in Marion Tennessee.
Find out and ferret out Cross Plains United States rental properties and Cross Plains condos for rent.
Recognize, light upon, and design houses for rent in Adams United States, Adams United States condo rentals, and Adams United States rental apartment.
Relocate and ascertain Jacksboro home rentals and vacation rentals Jacksboro.
Ferret out, contrive, and originate condos for rent Arrington United States, homes for rent by owner Arrington, and vacation rental in Arrington.
Troupers and speculators who are wishing to design and learn or simply distinguish information can use our website, FRBO.com.
|
|
