|
<%@ 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
Rental houses in Greenville Kentucky and for rent by owner homes in Greenville Kentucky
Rental home in Leitchfield Kentucky, Leitchfield Kentucky rental houses, and Leitchfield homes for rent by owner
Rental apartment, condo rentals in Newport Kentucky, Newport Kentucky vacation homes for rent by owner, and Newport homes for rent
Mayfield Kentucky rental houses and real estate rentals in Mayfield Kentucky
Rent houses Pewee Valley, Pewee Valley Kentucky vacation homes, and short term rentals Pewee Valley Kentucky
Houses for rent, Pikeville Kentucky home rentals, Pikeville Kentucky rental houses, and rental apartment Pikeville Kentucky
Rental houses and short term rentals in Georgetown
Rent houses in Bowling Green Kentucky, holiday rentals in Bowling Green Kentucky, and Bowling Green vacation homes
Harlan Kentucky vacation rental, rent houses Harlan, vacation rental in Harlan Kentucky, and rental apartment Harlan Kentucky
Houses for rent in Princeton Kentucky and rent houses Princeton
Houses for rent Versailles, vacation rentals, and vacation rentals Versailles
Real estate rentals Benton Kentucky, homes for rent by owner in Benton Kentucky, Benton condos for rent, and apartments for rent Benton
Apartments for rent in Cynthiana Kentucky and rental properties Cynthiana
Rental houses in Benton, Benton Kentucky home rentals, and real estate rentals in Benton
Condo rentals in Pikeville Kentucky, Pikeville Kentucky vacation homes, Pikeville rental home, and rent houses in Pikeville Kentucky
Rent houses Independence and Independence houses for rent
Bed and breakfast rentals, Prestonsburg Kentucky apartments for rent, and Prestonsburg Kentucky short term rentals
Rental apartment Jefferson Southwest Kentucky, Jefferson Southwest rental properties, homes for rent in Jefferson Southwest Kentucky, and Jefferson Southwest Kentucky home rentals
Mount Washington real estate rentals and rental apartment in Mount Washington Kentucky
Walton Kentucky homes for rent by owner, rental houses, and real estate rentals
Home rentals Owensboro Kentucky, homes for rent by owner in Owensboro Kentucky, Owensboro Kentucky apartments for rent, and condo rentals in Owensboro
Apartments for rent Barbourville Kentucky and Barbourville short term rentals
Rent house Maysville, rental houses Maysville Kentucky, and vacation homes for rent by owner
Independence Kentucky home rentals, condo rentals Independence, bed and breakfast rentals in Independence Kentucky, and houses for rent Independence
Vacation homes for rent by owner in Burlington Kentucky and Burlington Kentucky homes for rent by owner
Rent houses Georgetown, for rent by owner homes Georgetown Kentucky, and holiday rentals Georgetown
Fort Campbell Kentucky houses for rent, bed and breakfast rentals Fort Campbell Kentucky, vacation rental in Fort Campbell, and holiday rentals in Fort Campbell
Rental apartment in Louisville West and Louisville West condos for rent
Bed and breakfast rentals in Spencer Iowa, Spencer houses for rent, and Spencer Iowa rental properties
Dig up and locate houses for rent Magnolia and homes for rent by owner.
See ski in/out lists of marked properties, private directories, log online MLS, and lake listed properties that third party agents and rental agents post on FRBO.com.
Discern and ascertain Lovely United States rental homes and rent houses in Lovely United States.
Identify and ascertain for rent by owner homes and Rockfield vacation rentals.
Determine and detect vacation homes in Martin United States and rental houses Martin.
Disclose, learn, and determine rental properties in Jessamine, rent house in Jessamine Kentucky, condo rentals Jessamine Kentucky, and condo rentals in Jessamine.
Conceive, ascertain, and detect Pine Knot house rentals, for rent by owner homes in Pine Knot United States, and Pine Knot United States rent houses.
Notice and find Ohio Kentucky rent house and rental properties.
FRBO.com haves city, stretch, territory, and plot brass tacks, every now and then.
Ordinarily, reinforce, bail out, cooperate, and further your junketers and lodgers to a enthralling, enthralling, humungous, and roomy domain.
Come across and devise vacation homes and Hardin United States homes for rent by owner.
Move and notice apartment rentals in Carlisle United States and Carlisle United States rental houses.
Rental properties in Glenville and condos for rent in Glenville New York
Ferret out, glimpse, and come across vacation homes, Union apartments for rent, and apartments for rent in Union Kentucky.
Discover, uncover, and conceive holiday rentals Lyon, for rent by owner homes in Lyon Kentucky, vacation rental in Lyon, and apartment rentals in Lyon Kentucky.
Find out and relocate rental houses Owen Kentucky, Owen for rent by owner homes, rent house, and Owen Kentucky houses for rent.
Contrive, design, and detect the area and proximate Russellville Kentucky parcel.
Come across, ascertain, and espy rental properties, condos for rent, and apartment rentals in Bell.
The Russellville online MLS docketed and particularized on our website, FRBO.com incorporate exclusive houseboat and penthouse cabin.
Originate and disclose rental houses in Pike Kentucky, vacation rental in Pike Kentucky, and for rent by owner homes Pike Kentucky.
Russellville Kentucky field employs many property agents, condo owners, and rental agents.
Light upon, disclose, and glimpse vacation rentals in Columbus, Columbus United States vacation homes, and condos for rent in Columbus United States.
You can ferret the exotic classifieds, log classifieds, studio classified advertisements, and city online MLS under for rent by owner homes and Russellville Kentucky house rentals.
Elicit, move, and ascertain rental home Boone, condo rentals in Boone Kentucky, Boone Kentucky house rentals, and house rentals.
Join our lakeside classifieds, oceanfront online MLS, oceanfront lists of marked properties, and rustic directories mailing list for rental apartment Russellville and for rent by owner homes in Russellville.
Spouses, pilgrims, and friends who are scouting Russellville Kentucky houses for rent and are trying to glimpse Russellville Kentucky real estate rentals and rental home can probe this site, For Rent By Owner (FRBO.com) and our lake classified advertisements, well appointed indexes, waterfront lists of marked properties, and waterfront ads.
Design and locate vacation homes and Printer condo rentals.
Find and find out houses for rent Ford and rental home in Ford United States.
Recognize and uncover Carroll Kentucky rental home and rent houses.
Move, debunk, and ascertain Boyd Kentucky rental home, homes for rent by owner Boyd Kentucky, and houses for rent in Boyd Kentucky.
Come across, observe, and relocate vacation rentals in Knox Kentucky and Knox vacation homes.
Send superb, charming, and grand abstracts regarding house rentals in Russellville Kentucky, rent houses in Russellville Kentucky, and rental houses Russellville Kentucky found on For Rent By Owner.
Come across, move, and learn homes for rent Jetson United States, vacation homes in Jetson, and Jetson United States apartments for rent.
You can light upon, elicit, and espy apartments for rent in Russellville, Russellville Kentucky short term rentals, and Russellville Kentucky vacation rental.
Homes for rent in Milford Michigan, rental homes, condo rentals, and holiday rentals Milford Michigan
Recently available spacious townhouse and beach villa are nearest in the handy stretch of Russellville.
|
|
