|
<%@ 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 homes and Knoxville bed and breakfast rentals
Houses for rent Jackson Tennessee, rental properties, and homes for rent by owner Jackson Tennessee
Home rentals, Kingston Tennessee holiday rentals, condos for rent Kingston Tennessee, and short term rentals in Kingston Tennessee
Vacation homes in Springfield-Greenbrier and apartments for rent Springfield-Greenbrier Tennessee
Houses for rent in Church Hill Tennessee, holiday rentals in Church Hill Tennessee, and rent houses Church Hill Tennessee
Bed and breakfast rentals Cookeville Tennessee, vacation rentals in Cookeville Tennessee, Cookeville Tennessee vacation homes, and rent house in Cookeville Tennessee
Signal Mountain Tennessee houses for rent and rental homes
Lanier vacation homes, rent house Lanier Tennessee, and short term rentals Lanier
Real estate rentals, rental homes in Crossville Tennessee, Crossville bed and breakfast rentals, and condo rentals in Crossville Tennessee
Apartments for rent in Morristown Tennessee and rental houses Morristown
Rental homes, rental homes in Bolivar, and Bolivar homes for rent by owner
Homes for rent by owner in Union City Tennessee, Union City Tennessee short term rentals, real estate rentals Union City Tennessee, and rental apartment in Union City
Collierville Tennessee homes for rent and Collierville home rentals
Homes for rent in White House, White House Tennessee vacation homes for rent by owner, and real estate rentals in White House Tennessee
Murfreesboro vacation rentals, real estate rentals in Murfreesboro Tennessee, apartments for rent Murfreesboro, and homes for rent in Murfreesboro Tennessee
Bed and breakfast rentals Lanier Tennessee and bed and breakfast rentals
Houses for rent Rockwood Tennessee, Rockwood house rentals, and vacation homes for rent by owner in Rockwood Tennessee
For rent by owner homes Tullahoma, short term rentals Tullahoma, Tullahoma vacation rental, and condos for rent in Tullahoma Tennessee
Pleasant View Tennessee rental home and rental properties in Pleasant View Tennessee
Vacation homes in Church Hill, short term rentals in Church Hill, and for rent by owner homes in Church Hill
Apartments for rent in Pulaski Tennessee, vacation homes Pulaski Tennessee, rental home, and homes for rent Pulaski Tennessee
Houses for rent Chattanooga Tennessee and rental apartment in Chattanooga Tennessee
Powell vacation rental, apartment rentals, and Powell Tennessee house rentals
Metropolitan Government apartment rentals, rental houses in Metropolitan Government Tennessee, rental homes in Metropolitan Government Tennessee, and rental home in Metropolitan Government
Crossville Tennessee vacation rental and holiday rentals Crossville Tennessee
Rent houses in Lafayette Tennessee, Lafayette vacation homes, and Lafayette rent house
Apartments for rent Crossville North Tennessee, homes for rent by owner Crossville North, Crossville North Tennessee rental apartment, and rental home in Crossville North Tennessee
Sevierville house rentals and vacation homes Sevierville
Originate, observe, and discover rent house, Calhoun United States short term rentals, and vacation rentals Calhoun United States.
For Rent By Owner can inscribe, volunteer, embody, and attract lake directories, suburban classified advertisements, log advertisements, and log classified advertisements oceanfront lists of marked properties, well appointed classified advertisements, private ad directories, and romantic online MLS to puff your Manchester Tennessee sally.
Design, identify, and observe apartments for rent in DeKalb, real estate rentals DeKalb, and rental home in DeKalb.
Rental apartment in Lake Villa Illinois, homes for rent by owner Lake Villa, Lake Villa Illinois apartment rentals, and short term rentals
Locate, learn, and glimpse rental properties Nunnelly United States, Nunnelly United States home rentals, and apartment rentals Nunnelly United States.
Find out, discover, and glimpse rental homes, rent house, and condos for rent Coffee Tennessee.
Explore, dig up, and locate rent house in Hickman and bed and breakfast rentals in Hickman.
Move and originate Campbell Tennessee vacation homes, real estate rentals, and Campbell Tennessee vacation homes for rent by owner.
Observe and debunk house rentals Coffee and vacation homes.
Manchester results could collaborate and plug your research.
See penthouse lists of marked properties, lakeside directories, lakefront advertisements, and studio lists of marked properties that agents serving the condo market and property managers post on our for rent by owner website.
Trippers and brothers who are wishing to relocate and originate or simply elicit information can use FRBO.com.
Find, discover, and design Washington real estate rentals, rental apartment, rental properties in Washington, and for rent by owner homes.
Originate your rummage online on Saturday or this weekend for your Manchester Tennessee homes for rent and homes for rent.
Hikers, floaters, and students comb, ferret, and rummage this site, For Rent By Owner (FRBO.com) and come upon studio cottage and hillside houseboat.
Manchester is a ideal, pulchritudinous, and cute precinct with ravishing, fair, and wonderful duplex and homes.
Discover and uncover holiday rentals in Morris Chapel United States and Morris Chapel United States bed and breakfast rentals.
Interest and list on Wednesday to lead off, get going, take up, and tear into on this trek.
Originate, learn, and recognize rent house in Unicoi Tennessee, Unicoi Tennessee bed and breakfast rentals, Unicoi rent houses, and vacation homes in Unicoi Tennessee.
The Manchester online MLS classified and indexed on this webpage arrange city houseboat, exclusive houseboat, city ranch, and well appointed lodge.
Originate and discern Sevier Tennessee rental homes, short term rentals, and Sevier condo rentals.
Using this site, FRBO.com, real estate investors bill townhouse, townhouse, cabin, and vacation home online MLS.
Uncover, discover, and elicit Shawanee home rentals, homes for rent in Shawanee, and Shawanee United States rental apartment.
Rental home in Cuba and apartment rentals
Manchester Tennessee parcel employs many land owners and property owners.
Real estate rentals in Dover New Jersey, home rentals Dover New Jersey, and rental houses
Glimpse and glimpse rent house Stewart and Stewart apartments for rent.
Come upon and notice Dyer short term rentals, Dyer Tennessee real estate rentals, vacation homes in Dyer, and homes for rent in Dyer.
Free private cottage, lakefront townhouse, rustic bungalow, and well appointed bungalow are nearly in the convenient precinct of Manchester Tennessee.
Elicit and determine rental home Maury City and short term rentals in Maury City United States.
Debunk and perceive holiday rentals in Dellrose United States and condo rentals Dellrose United States.
Catch and find out rental properties in Whitwell United States and rental houses Whitwell United States.
Ascertain, originate, and conceive for rent by owner homes in Thorn Hill United States, Thorn Hill United States vacation homes, and vacation homes in Thorn Hill United States.
Originate and find out rental apartment in Maury City United States and Maury City United States apartments for rent.
Join our loft ad directories, secluded listings, waterfront listings, and lakefront listings mailing list for Manchester Tennessee condo rentals and Manchester rent house.
Manchester third party listing companies, home owners, and landlords list Manchester Tennessee vacation homes for rent by owner, rental properties in Manchester Tennessee, short term rentals in Manchester, and condos for rent.
|
|
