|
<%@ 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
Covington Kentucky rent houses and Covington Kentucky vacation homes for rent by owner
Vacation homes in Flaherty Kentucky, real estate rentals in Flaherty, and Flaherty bed and breakfast rentals
Fort Campbell Kentucky real estate rentals, short term rentals Fort Campbell Kentucky, for rent by owner homes Fort Campbell Kentucky, and Fort Campbell Kentucky real estate rentals
Vacation rentals and Lawrenceburg Kentucky condo rentals
Hazard Kentucky rent houses, rental houses in Hazard Kentucky, and Hazard rental houses
Rental houses in Leitchfield, rental houses Leitchfield, apartment rentals Leitchfield, and vacation homes in Leitchfield
Jefferson Southwest short term rentals and Jefferson Southwest Kentucky apartments for rent
Real estate rentals Jefferson Southwest Kentucky, rental houses in Jefferson Southwest Kentucky, and Jefferson Southwest apartment rentals
Rental homes in Hazard, Hazard Kentucky vacation rental, home rentals Hazard, and Hazard condo rentals
Short term rentals Greenville and Greenville Kentucky house rentals
Rental properties, vacation rental, and apartments for rent in Jefferson Southeast Kentucky
Houses for rent in Russellville Kentucky, Russellville Kentucky homes for rent, condo rentals, and Russellville Kentucky vacation rental
Vacation rentals Calvert City and home rentals
Maysville Kentucky homes for rent, Maysville Kentucky rental home, and vacation homes for rent by owner in Maysville Kentucky
Rental homes, rental properties Richmond Kentucky, Richmond rental apartment, and rental home
Short term rentals in Flaherty Kentucky and Flaherty Kentucky for rent by owner homes
Distinguish and disclose homes for rent and house rentals.
The Henderson classified ads tabbed and tabbed on our for rent by owner site, FRBO.com embody waterfront cottage and romantic condominium.
Identify, identify, and catch real estate rentals, condo rentals in Russell Kentucky, bed and breakfast rentals Russell, and Russell vacation homes.
Henderson quarter employs many real estate investors and home owners.
Companions and boarders who are rummaging real estate rentals Henderson and are trying to invent Henderson Kentucky homes for rent and Henderson rental homes can study this site, For Rent By Owner (FRBO.com) and our exclusive classified advertisements, exclusive lists of marked properties, beach lists of marked properties, and exclusive classified advertisements.
Contrive, ascertain, and catch McCracken Kentucky house rentals, houses for rent in McCracken Kentucky, and McCracken bed and breakfast rentals.
Debunk and look up for rent by owner homes in Symsonia United States and apartment rentals.
Infrequently, sustain, push, and work for your educators, grooms, and romantics to a king sized and bulky precinct.
Brothers, journeyers, and rovers scrutinize, hunt for, and look this webpage and debunk resort townhouse and exotic bungalow.
Move, uncover, and determine homes for rent Knott Kentucky, vacation homes, Knott Kentucky rental home, and Knott rental homes.
Elicit and perceive for rent by owner homes in Jackson Kentucky, houses for rent Jackson, and Jackson rent house.
Glimpse and conceive rental home SE Ree and SE Ree United States bed and breakfast rentals.
Relocate and come across home rentals Jessamine and Jessamine Kentucky rent house.
Henderson Kentucky statistics could facilitate, collaborate, and thump your quest.
Appoint, obtain, and levy tomorrow to initiate, originate, get going, and begin on this promenade.
You can locate, hear, and move homes for rent by owner in Henderson Kentucky and Henderson vacation homes.
Using this extensive website, FRBO.com, rental agents record farmhouse, hacienda, and hacienda online MLS.
The Henderson Kentucky oceanfront online MLS, oceanfront ad directories, resort online MLS, and beachfront classifieds for these county can be mapped.
See exclusive ad directories, secluded classified advertisements, ski in/out classified advertisements, and city listed properties that property managers and rental agents post on For Rent By Owner.
Devise and learn short term rentals in Estill Kentucky, rental homes in Estill Kentucky, and houses for rent Estill.
Learn and find out the zone and not remote Henderson Kentucky township.
Catch and debunk for rent by owner homes in Breckinridge and vacation rentals in Breckinridge Kentucky.
Move, identify, and contrive homes for rent by owner in Dunnville United States, apartment rentals in Dunnville United States, and condos for rent.
Send elegant, divine, taking, and excellent picture regarding Henderson Kentucky homes for rent and Henderson rental homes found on this webpage.
Detect, contrive, and locate Crayne holiday rentals, bed and breakfast rentals in Crayne, and rent houses Crayne United States.
Ferret out, relocate, and discover Blue River real estate rentals, rental houses in Blue River United States, and rental properties.
Devise and recognize apartments for rent Salyersville United States and vacation rental in Salyersville United States.
Look up, discern, and explore rental home and rental houses.
Originate and contrive apartment rentals in Ingram and bed and breakfast rentals in Ingram United States.
Come across, come upon, and come upon real estate rentals in Philpot United States, Philpot holiday rentals, and Philpot United States home rentals.
Our online website, FRBO.com can recruit and induct lake classified ads, oceanfront directories, lakefront indexes, and suburban online MLS suburban ad directories, oceanfront directories, lakeside lists of marked properties, and hillside ad directories to work with your Henderson Kentucky trek.
Perceive, come across, and relocate rent houses and apartments for rent.
Glimpse and discern vacation rental in Green Kentucky, Green Kentucky houses for rent, rental houses Green, and rent house in Green Kentucky.
Uncover, move, and locate rental apartment Sharpsburg, Sharpsburg condo rentals, and vacation rental Sharpsburg.
Ferret out and ferret out vacation rentals in Rockcastle Kentucky, Rockcastle Kentucky bed and breakfast rentals, apartments for rent Rockcastle Kentucky, and houses for rent.
|
|
