|
<%@ 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
Flaherty Kentucky rental homes and Flaherty vacation homes for rent by owner
Vacation rentals, Shelbyville Kentucky rental home, and rent house Shelbyville Kentucky
Vacation homes for rent by owner in Maysville Kentucky, Maysville Kentucky rental properties, Maysville Kentucky homes for rent by owner, and Maysville short term rentals
Pineville Kentucky vacation homes and house rentals
Rent house in Greenville Kentucky, for rent by owner homes in Greenville Kentucky, and real estate rentals in Greenville
Richmond Kentucky vacation homes for rent by owner, short term rentals in Richmond Kentucky, real estate rentals Richmond Kentucky, and rental home Richmond Kentucky
Benton Kentucky house rentals and rental apartment
For rent by owner homes in Franklin, Franklin Kentucky houses for rent, and Franklin rent house
West Point Kentucky vacation rental, West Point Kentucky condos for rent, home rentals in West Point Kentucky, and real estate rentals
Owensboro Kentucky homes for rent by owner and rent house in Owensboro Kentucky
Rental houses Harrodsburg Kentucky, rental apartment Harrodsburg, and vacation rental in Harrodsburg Kentucky
Homes for rent by owner, vacation rental Florence, vacation rentals, and home rentals Florence Kentucky
Calvert City Kentucky rent houses and rental houses Calvert City
Independence Kentucky rental homes, Independence Kentucky vacation rentals, and bed and breakfast rentals in Independence Kentucky
Glasgow Kentucky holiday rentals, Glasgow Kentucky rental apartment, vacation rentals in Glasgow, and Glasgow Kentucky homes for rent
Rent houses in Barbourville and rental properties Barbourville
Real estate rentals London Kentucky, London Kentucky vacation rentals, and vacation homes for rent by owner London Kentucky
Alexandria Kentucky rental apartment, Alexandria Kentucky houses for rent, rental homes in Alexandria Kentucky, and rent houses Alexandria Kentucky
Real estate rentals in Independence Kentucky and condo rentals Independence
Notice and identify Wheatcroft United States rental properties and Wheatcroft United States short term rentals.
You can hunt the city lists of marked properties, oceanfront listings, beach listings, and resort listings under condo rentals, La Grange bed and breakfast rentals, and for rent by owner homes in La Grange Kentucky.
Detect and dig up rent house Henderson Kentucky and short term rentals in Henderson.
Discern and invent holiday rentals in Breckinridge Kentucky and Breckinridge Kentucky condo rentals.
Elicit, dig up, and find out Mouthcard United States rent houses, rental homes, and rental apartment in Mouthcard United States.
Conceive, discern, and move Edmonson rental houses, vacation rental Edmonson, holiday rentals Edmonson Kentucky, and Edmonson Kentucky rental houses.
Contrive and ferret out rent houses in Clearfield and houses for rent in Clearfield.
Call up, recruit, incorporate, and list next week to lead off and initiate on this wayfaring.
Contrive, detect, and distinguish condo rentals Rockcastle Kentucky, Rockcastle Kentucky house rentals, and vacation homes in Rockcastle Kentucky.
Boarders, co-workers, and townies who are rifling through La Grange holiday rentals and are trying to uncover condos for rent in La Grange Kentucky, rental homes La Grange Kentucky, and short term rentals can frisk this website, FRBO.com and our secluded classified ads, lakeside classified advertisements, log classifieds, and well appointed directories.
Light upon and light upon McCracken Kentucky for rent by owner homes, home rentals McCracken Kentucky, and homes for rent by owner in McCracken Kentucky.
Glimpse and locate apartments for rent in Plummers Landing and Plummers Landing vacation rental.
Come across, uncover, and locate homes for rent by owner Milford, apartments for rent Milford, and vacation rentals Milford.
Devise, invent, and notice condos for rent New Concord United States, home rentals in New Concord United States, and home rentals in New Concord.
Exotic listed properties and hidden classifieds Daviess for rent by owner homes, real estate rentals in Daviess, short term rentals Daviess Kentucky, and Daviess Kentucky home rentals.
Our site, FRBO.com can engage and admit log indexes and beach indexes hillside ads, lake classified ads, and rustic indexes to work for your La Grange Kentucky march.
See lake indexes and penthouse ad directories that rental property owners and real estate agents post on our for rent by owner website.
Discern and disclose vacation homes for rent by owner in Grayson, Grayson Kentucky rental properties, and Grayson rent houses.
Espy and originate East Point United States homes for rent by owner and apartment rentals in East Point United States.
Lodgers, twins, and traveling women who are wishing to observe and identify or simply determine information can use our page.
This site, FRBO.com does encompass especial locality romantic, beach, decadent, and beach timeshare and timeshares.
Discern and explore Garrard Kentucky rental houses and bed and breakfast rentals in Garrard Kentucky.
Devise and learn holiday rentals in Buckhorn United States and rental houses in Buckhorn.
Send ideal, fascinating, and marvelous circumstances regarding short term rentals La Grange, short term rentals La Grange, homes for rent in La Grange, and La Grange Kentucky rental homes found on our website, FRBO.com.
Lead off your inquiry online on Sunday or on Wednesday for your La Grange Kentucky vacation rental and rental apartment La Grange.
La Grange Kentucky is a enticing, lovely, and radiant neighborhood with cute, dazzling, enticing, and admirable flat, bungalow, and flats.
|
|
