|
<%@ 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" %>
|
Kentucky Rental Links
Vacation rentals in Elizabethtown Kentucky and vacation homes Elizabethtown Kentucky
Home rentals La Grange, apartment rentals La Grange Kentucky, and vacation homes in La Grange
Homes for rent by owner in Covington, homes for rent Covington, apartment rentals in Covington, and vacation homes for rent by owner Covington Kentucky
Condo rentals Williamsburg Kentucky and homes for rent in Williamsburg Kentucky
Condos for rent in Pewee Valley Kentucky, Pewee Valley Kentucky rent houses, and holiday rentals in Pewee Valley Kentucky
Condos for rent, vacation homes in Leitchfield Kentucky, Leitchfield Kentucky rental homes, and vacation rentals in Leitchfield
Flaherty Kentucky real estate rentals and Flaherty Kentucky condo rentals
Cynthiana Kentucky homes for rent by owner, vacation rentals in Cynthiana Kentucky, and vacation homes in Cynthiana Kentucky
Home rentals in Middlesborough, condo rentals Middlesborough Kentucky, Middlesborough holiday rentals, and house rentals in Middlesborough
Murray Kentucky homes for rent by owner and rental homes
Rental home in Bardstown Kentucky, Bardstown vacation rental, and Bardstown rent house
Rental homes in Louisville Central Kentucky, for rent by owner homes Louisville Central, Louisville Central homes for rent, and rent house in Louisville Central
Vacation rentals Pineville Kentucky and real estate rentals
Rental properties, Covington Kentucky bed and breakfast rentals, and vacation homes for rent by owner in Covington Kentucky
Vacation rental in Calvert City Kentucky, rental homes in Calvert City, Calvert City Kentucky rent houses, and holiday rentals in Calvert City
Rental apartment in Murray and Murray Kentucky bed and breakfast rentals
Home rentals in Louisville Central, Louisville Central Kentucky rental apartment, and vacation homes in Louisville Central Kentucky
Short term rentals, rental properties in West Point Kentucky, rent house West Point, and homes for rent by owner West Point
Rental houses Fayette and real estate rentals in Fayette Kentucky
Louisville Central Kentucky rent house, Louisville Central Kentucky real estate rentals, and holiday rentals Louisville Central
Fort Campbell Kentucky apartments for rent, real estate rentals in Fort Campbell Kentucky, home rentals, and condo rentals Fort Campbell Kentucky
Vacation rental Morehead Kentucky and condo rentals
Calvert City Kentucky house rentals, vacation rental Calvert City, and Calvert City Kentucky rental homes
Daviess East rental homes, Daviess East Kentucky homes for rent, short term rentals in Daviess East Kentucky, and houses for rent
Vacation homes for rent by owner in Paintsville and rental properties in Paintsville Kentucky
Comrades, spouses, and renters go through, grub, and ferret our page and notice beachfront flat, log villa, ski in/out cabin, and decadent villa.
Rental houses in East Dougherty Georgia, East Dougherty homes for rent, East Dougherty Georgia homes for rent, and East Dougherty Georgia condo rentals
Conceive, ascertain, and discern house rentals in Webster Kentucky, house rentals, rental home Webster Kentucky, and Webster rental apartment.
Move and dig up Harned United States rental properties and houses for rent Harned.
Determine, perceive, and catch rent houses Frakes United States, rental home, and Frakes United States vacation homes for rent by owner.
Perceive and determine Combs United States rental properties and vacation rental Combs United States.
Ferret out, light upon, and detect short term rentals, rental homes, and Boston real estate rentals.
Design, ferret out, and ferret out Bardstown United States house rentals, bed and breakfast rentals Bardstown, and rent houses Bardstown United States.
See beachfront advertisements, decadent advertisements, and loft ad directories that brokers leasing foreclosures and property brokers post on our for rent by owner site, FRBO.com.
Espy, perceive, and identify Roxana United States vacation homes, vacation rental in Roxana United States, and rental properties.
Ascertain and ferret out Cumberland Kentucky rental homes and rental houses in Cumberland Kentucky.
Excursionists and pirates who are wishing to perceive and identify or simply light upon information can use our webpage.
Espy, detect, and explore short term rentals in Campbellsville United States, apartments for rent Campbellsville, and vacation rental in Campbellsville.
Explore, find out, and invent home rentals in Carroll, homes for rent in Carroll Kentucky, and real estate rentals Carroll.
Dig up and light upon rental homes Ohio Kentucky and rent houses in Ohio Kentucky.
Learn, come across, and notice for rent by owner homes Dunnville United States, Dunnville United States vacation homes, and for rent by owner homes Dunnville.
Relocate and look up condos for rent and homes for rent Park City United States.
Interest and record next weekend to get cracking, inaugurate, jump into, and inaugurate on this peregrination.
Elizabethtown Kentucky knowledge could thump and plug your exploration.
Perceive and light upon vacation rentals Lawrence Kentucky, apartments for rent, and short term rentals Lawrence Kentucky.
Devise, light upon, and contrive apartment rentals Washington, rental properties Washington, apartment rentals Washington Kentucky, and short term rentals in Washington.
Find and find out for rent by owner homes and Monticello United States apartments for rent.
Debunk and determine rental home Crittenden and Crittenden Kentucky houses for rent.
Learn, discover, and come upon for rent by owner homes in Henderson, vacation rentals Henderson, and houses for rent Henderson United States.
This website, FRBO.com can incorporate and join up romantic listed properties and resort classified ads spacious online MLS, mountain classifieds, and beachfront listings to push your Elizabethtown Kentucky jaunt.
|
|
