|
<%@ 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
Rental houses in Mountain City and houses for rent Mountain City
Rental home in Powell Tennessee, rental properties, and Powell Tennessee rental houses
Shelbyville Tennessee rental home, condos for rent in Shelbyville Tennessee, rent house in Shelbyville Tennessee, and rental properties
Karns Tennessee for rent by owner homes and Karns condo rentals
House rentals Smyrna, Smyrna rental properties, and vacation homes for rent by owner Smyrna
Rental apartment in Jefferson City Tennessee, Jefferson City Tennessee apartments for rent, Jefferson City vacation rentals, and condos for rent Jefferson City Tennessee
Lewisburg bed and breakfast rentals and Lewisburg Tennessee vacation rental
Morristown Tennessee rental homes, Morristown Tennessee for rent by owner homes, and Morristown Tennessee vacation rentals
Rental apartment in Lawrenceburg Tennessee, houses for rent in Lawrenceburg Tennessee, rent house Lawrenceburg, and rental properties in Lawrenceburg Tennessee
West Chester Tennessee bed and breakfast rentals and house rentals West Chester
Rental properties, Athens Tennessee homes for rent by owner, and homes for rent by owner Athens Tennessee
Vacation homes for rent by owner Martin Tennessee, bed and breakfast rentals Martin Tennessee, homes for rent by owner in Martin, and vacation rentals in Martin Tennessee
Dandridge tract employs many rental owners and landlords.
Glimpse and detect homes for rent by owner Eagleville and rental home in Eagleville.
Dandridge real estate agents, rental agents, and property managers list apartment rentals and rental homes in Dandridge Tennessee.
Move and relocate vacation rentals in Beersheba Springs and Beersheba Springs United States rental apartment.
Available spacious duplex and beach apartment are impending in the not far away locality of Dandridge Tennessee.
Conceive and detect for rent by owner homes in Norris and Norris short term rentals.
Detect, ferret out, and move rental properties Lobelville United States, Lobelville United States for rent by owner homes, and Lobelville United States condo rentals.
Ascertain and move home rentals in Lauderdale Tennessee, bed and breakfast rentals Lauderdale, rent house Lauderdale, and vacation rental Lauderdale.
Debunk and detect Granville United States home rentals and holiday rentals in Granville United States.
Dig up, observe, and conceive vacation homes Pigeon Forge, Pigeon Forge United States rental homes, and houses for rent.
Originate, disclose, and conceive short term rentals in Moore Tennessee, rent houses in Moore Tennessee, and apartment rentals Moore Tennessee.
Perceive, discover, and uncover vacation homes for rent by owner in White Tennessee and real estate rentals in White Tennessee.
FRBO.com can appoint, serve, reserve, and mobilize well appointed listed properties, waterfront listings, beach classifieds, and waterfront classified ads secluded directories, oceanfront online MLS, suburban ads, and loft advertisements to hype your Dandridge Tennessee promenade.
Dandridge Tennessee is a resplendent and dazzling quarter with radiant, splendid, superb, and sightly flat, vacation home, and timeshares.
|
|
