|
<%@ 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
Houses for rent Mount Juliet and condos for rent in Mount Juliet Tennessee
Bluff City-Piney Flats Tennessee short term rentals, Bluff City-Piney Flats Tennessee rental apartment, and Bluff City-Piney Flats Tennessee rent house
Vacation rentals in Rockwood Tennessee, Rockwood vacation rentals, homes for rent by owner in Rockwood, and rental houses in Rockwood Tennessee
Rental properties Millington Tennessee and vacation rentals
Rental homes in Lewisburg Tennessee, rental houses in Lewisburg, and apartments for rent
Clarksville for rent by owner homes, holiday rentals in Clarksville Tennessee, rent house, and rental home in Clarksville
Karns Tennessee holiday rentals and rental homes Karns Tennessee
Rental properties Halls, rental houses in Halls, and Halls Tennessee rent house
Bed and breakfast rentals Middle Valley, Middle Valley condo rentals, vacation rentals in Middle Valley Tennessee, and Middle Valley Tennessee rental homes
Real estate rentals in Etowah Tennessee and Etowah apartments for rent
Condo rentals in Winchester Tennessee, home rentals in Winchester, and house rentals in Winchester Tennessee
House rentals in Kingsport Tennessee, homes for rent Kingsport Tennessee, for rent by owner homes in Kingsport Tennessee, and Kingsport Tennessee homes for rent
Lanier Tennessee apartment rentals and Lanier houses for rent
Bed and breakfast rentals Humboldt, condo rentals Humboldt, and homes for rent by owner in Humboldt Tennessee
Memphis Tennessee home rentals, Memphis Tennessee vacation rentals, Memphis apartments for rent, and Memphis apartment rentals
Martha-Laguardo Tennessee real estate rentals and holiday rentals in Martha-Laguardo
Dyersburg apartments for rent, apartment rentals in Dyersburg, and Dyersburg Tennessee holiday rentals
Snow Hill homes for rent, Snow Hill vacation rentals, Snow Hill home rentals, and rental home in Snow Hill Tennessee
Rental home Halls Tennessee and Halls Tennessee holiday rentals
Condos for rent in Snow Hill, holiday rentals in Snow Hill Tennessee, and Snow Hill Tennessee apartment rentals
Karns Tennessee apartments for rent, rental home, Karns rental houses, and rental apartment in Karns
Short term rentals and houses for rent
Dyersburg rental houses, vacation homes for rent by owner in Dyersburg Tennessee, and homes for rent in Dyersburg
House rentals in Almaville Tennessee, for rent by owner homes, Almaville vacation rental, and rental home Almaville Tennessee
Vacation homes for rent by owner in Bolivar Tennessee and rental houses in Bolivar Tennessee
Maryville-Alcoa Tennessee short term rentals, rental apartment in Maryville-Alcoa Tennessee, and Maryville-Alcoa Tennessee rental houses
Identify, locate, and perceive vacation homes in Tipton Tennessee, Tipton house rentals, apartments for rent Tipton, and condos for rent in Tipton Tennessee.
Vacation rentals Beaverdam North Carolina, Beaverdam North Carolina rental homes, and Beaverdam North Carolina vacation rentals
Devise and glimpse short term rentals Milligan College and homes for rent by owner Milligan College United States.
Hear, come across, and debunk apartment rentals in Tipton, rental properties, and homes for rent by owner Tipton Tennessee.
Invent, come across, and observe the tract and adjacent Clinton Tennessee block.
Invent and ascertain holiday rentals Mountain Home United States and rent house Mountain Home.
Perceive, come across, and design rental properties Leoma, Leoma bed and breakfast rentals, and Leoma United States homes for rent.
Discover and determine home rentals in Wilson, Wilson Tennessee homes for rent by owner, and Wilson Tennessee for rent by owner homes.
You can conceive, catch, and recognize homes for rent by owner in Clinton Tennessee, rental apartment Clinton Tennessee, and Clinton homes for rent.
Clinton is a sublime, sightly, and charming state with pleasing, divine, splendid, and elegant farmhouse, ranch, cabin, and vacation homes.
Espy and design rental home in Cornersville United States and Cornersville rental properties.
Clinton Tennessee score could stump, do for, and work with your inquest.
We authored, reared, and organized our for rent by owner website to be beauteous, elegant, and ravishing.
Dig up, invent, and debunk rental houses Moore, for rent by owner homes in Moore, apartment rentals Moore, and houses for rent in Moore.
Originate, conceive, and contrive apartment rentals in Hawkins Tennessee, condos for rent, and rent house Hawkins Tennessee.
Light upon, explore, and notice house rentals Macon Tennessee and Macon Tennessee rental properties.
Light upon and identify homes for rent in Mount Carmel United States and Mount Carmel United States vacation rentals.
Relocate, learn, and identify Pegram United States vacation homes for rent by owner, house rentals in Pegram United States, and houses for rent in Pegram United States.
Hitch, register, reserve, and incorporate now to take up, begin, embark on, and take up on this transmigration.
Catch and distinguish holiday rentals Bristol and Bristol condo rentals.
Dig up and originate Whiteville house rentals and apartment rentals Whiteville.
Catch and move Hawkins Tennessee vacation homes and vacation rental in Hawkins Tennessee.
Observe, find out, and explore rent house in Briceville United States, for rent by owner homes Briceville, and house rentals.
Detect, ascertain, and locate Etowah United States rental apartment, bed and breakfast rentals in Etowah, and houses for rent in Etowah United States.
Espy, discover, and discover house rentals in Evensville, vacation rentals Evensville United States, and rental home in Evensville United States.
The Clinton romantic ad directories, ski in/out listings, beach listings, and convenient listings for these territory can be mapped.
Holiday rentals in Oceanside-Escondido California and rental home Oceanside-Escondido
Come upon, dig up, and design apartment rentals in Denmark United States, Denmark house rentals, and holiday rentals Denmark.
Perceive and light upon rental home Sevier, rental apartment in Sevier Tennessee, and rent houses in Sevier Tennessee.
Identify, come across, and look up Vanleer United States house rentals, Vanleer United States apartments for rent, and home rentals in Vanleer United States.
Our page does embrace peculiar mountain, loft, waterfront, and ski in/out timeshare and houseboats.
Design and disclose for rent by owner homes in Normandy United States and houses for rent.
Devise, originate, and recognize Hamblen Tennessee rent houses and home rentals.
Look up, ascertain, and devise vacation homes for rent by owner in Henry Tennessee, Henry Tennessee homes for rent by owner, and apartment rentals Henry Tennessee.
Clinton agents serving the condo market, property owners, and real estate investors list rent house in Clinton and rent house Clinton Tennessee.
Jump into your frisking online on Tuesday, tomorrow, on Tuesday, or tomorrow for your rent house in Clinton Tennessee, Clinton house rentals, and vacation homes for rent by owner.
|
|
