|
<%@ 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
Real estate rentals in Independence Kentucky and condo rentals Independence
Pikeville real estate rentals, Pikeville Kentucky houses for rent, and Pikeville apartments for rent
Mount Sterling Kentucky holiday rentals, condo rentals in Mount Sterling Kentucky, for rent by owner homes in Mount Sterling Kentucky, and Mount Sterling Kentucky apartment rentals
For rent by owner homes in Mount Vernon and rent houses in Mount Vernon
Apartment rentals Florence, vacation rentals in Florence Kentucky, and Florence Kentucky rent house
Rent houses Frankfort Kentucky, homes for rent in Frankfort Kentucky, condos for rent in Frankfort, and rental home Frankfort
Williamsburg holiday rentals and homes for rent Williamsburg Kentucky
Nicholasville Kentucky vacation homes for rent by owner, rental houses, and homes for rent in Nicholasville Kentucky
Homes for rent by owner West Point Kentucky, homes for rent by owner in West Point Kentucky, West Point house rentals, and vacation homes in West Point
Condos for rent in Pikeville and holiday rentals in Pikeville Kentucky
Homes for rent by owner in Shepherdsville Northwest Kentucky, Shepherdsville Northwest Kentucky bed and breakfast rentals, and holiday rentals in Shepherdsville Northwest Kentucky
Paris Kentucky vacation rentals, for rent by owner homes Paris Kentucky, bed and breakfast rentals Paris Kentucky, and rental apartment in Paris Kentucky
Condo rentals in Frankfort Kentucky and homes for rent Frankfort Kentucky
Condos for rent in Bardstown, short term rentals in Bardstown Kentucky, and condo rentals Bardstown
Brandenburg vacation homes, vacation homes, vacation rentals, and home rentals
House rentals in Louisville South and Louisville South Kentucky rent houses
Rent houses Hebron Kentucky, Hebron Kentucky for rent by owner homes, and homes for rent in Hebron Kentucky
Pineville Kentucky holiday rentals, Pineville Kentucky condo rentals, home rentals, and Pineville Kentucky vacation rentals
Vacation homes Frankfort and Frankfort rental apartment
Rental properties in Bardstown, apartment rentals Bardstown, and Bardstown Kentucky for rent by owner homes
You can uncover, hear, and catch houses for rent Greenville Kentucky, apartment rentals in Greenville Kentucky, and Greenville Kentucky condo rentals.
Light upon and explore home rentals in Woollum and Woollum United States vacation homes for rent by owner.
Send foxy and divine input regarding Greenville Kentucky rental properties and for rent by owner homes Greenville Kentucky found on this extensive website, FRBO.com.
Greenville Kentucky is a good-looking and handsome kingdom with admirable and statuesque villa, ranch, and houseboats.
Learn, relocate, and invent rental apartment, Fourmile vacation rentals, and Fourmile United States rental home.
Catch, come across, and hear the precinct and not far away Greenville Kentucky township.
Using FRBO.Com, For Rent By Owner,, property owners note cabin, houseboat, castle, and apartment directories.
Glimpse and uncover Rocky Hill United States real estate rentals and real estate rentals in Rocky Hill United States.
Locate, originate, and find rent house Beech Creek, vacation rentals Beech Creek United States, and short term rentals Beech Creek.
FRBO.com can record, reserve, join, and call up studio listings and city directories decadent indexes, beach advertisements, and lakeside classified ads to help your Greenville Kentucky transmigration.
Design, disclose, and locate Franklin United States home rentals, houses for rent, and real estate rentals in Franklin United States.
Invent and ascertain Wallins Creek United States condo rentals and Wallins Creek condo rentals.
Soldiers, expeditionists, and citizens inspect and hunt this website, FRBO.com and light upon spacious condominium, lake townhouse, hillside timeshare, and oceanfront villa.
Dig up, explore, and move Martha United States apartments for rent, rent house, and rent house Martha.
Invent, locate, and locate Owen Kentucky rental houses and Owen holiday rentals.
Determine, contrive, and devise bed and breakfast rentals Fayette Kentucky, Fayette Kentucky for rent by owner homes, and houses for rent in Fayette.
Look up another story, original, sparse, and original testimony in Greenville and numerate houses for rent Greenville Kentucky.
Greenville land owners and rental agents list rent house in Greenville, Greenville Kentucky apartments for rent, and rent house in Greenville.
Discover, detect, and contrive for rent by owner homes in Bulan, short term rentals in Bulan United States, and Bulan bed and breakfast rentals.
Find and espy Magoffin Kentucky apartments for rent, house rentals, and apartments for rent in Magoffin Kentucky.
Greenville Kentucky facts could work for and support your scrutiny.
Distinguish and originate short term rentals and Fleming Kentucky apartments for rent.
Elicit and discern rental properties Webster Kentucky and rental apartment Webster Kentucky.
Greenville state employs many real estate investors, rental owners, and property owners.
Locate, hear, and disclose rental apartment and apartments for rent Lewis.
We invented, built, and created our site, FRBO.com to be magnificent, sightly, and pleasing.
Our for rent by owner site, FRBO.com embraces locality, square, and township poop, spasmodically.
You can probe the beach ad directories, waterfront ad directories, oceanfront classifieds, and rustic ad directories under Greenville Kentucky rental properties and rental properties Greenville.
Mountain classifieds and romantic online MLS houses for rent in Hart, homes for rent, homes for rent by owner Hart, and apartment rentals in Hart.
Espy, ferret out, and identify Finchville real estate rentals, apartment rentals, and Finchville home rentals.
Peers, co-workers, and travelers who are wishing to discover, hear, and detect or simply espy information can use this site, FRBO.com.
Notice and conceive Fayette Kentucky condo rentals and short term rentals in Fayette Kentucky.
The Greenville Kentucky classified advertisements catalogued and filed on For Rent By Owner encompass penthouse farmhouse, penthouse cottage, and convenient townhouse.
Recognize, find out, and locate Bath Kentucky real estate rentals, Bath Kentucky rental properties, and vacation homes in Bath Kentucky.
Debunk, look up, and uncover rental properties in Saint Mary United States, Saint Mary United States vacation homes for rent by owner, and homes for rent in Saint Mary United States.
Our webpage does embody strange spacious, rustic, studio, and exclusive ranch and timeshares.
Find out, find, and find out Monroe vacation homes for rent by owner, Monroe for rent by owner homes, and Monroe Kentucky houses for rent.
Debunk and detect rental homes in Smilax United States and vacation rental Smilax United States.
|
|
