|
<%@ 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 homes for rent by owner Newport and house rentals Newport Kentucky
Home rentals Murray, apartment rentals Murray, and bed and breakfast rentals in Murray Kentucky
Daviess West Kentucky for rent by owner homes, house rentals in Daviess West Kentucky, vacation homes for rent by owner Daviess West, and vacation homes for rent by owner in Daviess West Kentucky
Homes for rent by owner Russellville Kentucky and rental homes Russellville
Prestonsburg Kentucky home rentals, rental homes in Prestonsburg Kentucky, and Prestonsburg short term rentals
Homes for rent, home rentals in Paris, Paris homes for rent by owner, and Paris rental homes
Maysville vacation rental and condos for rent
Rent houses in Hebron Kentucky, apartment rentals in Hebron Kentucky, and Hebron Kentucky apartments for rent
Rental apartment La Grange Kentucky, holiday rentals in La Grange Kentucky, rental properties La Grange, and rent houses La Grange Kentucky
Danville Kentucky vacation rental and Danville Kentucky houses for rent
Rental houses in Paris Kentucky, Paris house rentals, and Paris home rentals
Murray Kentucky vacation homes, Murray Kentucky bed and breakfast rentals, Murray Kentucky home rentals, and for rent by owner homes Murray Kentucky
Vacation homes Richmond and Richmond rental apartment
Alexandria apartments for rent, short term rentals in Alexandria Kentucky, and rental houses in Alexandria Kentucky
Condo rentals in Ashland Kentucky, for rent by owner homes in Ashland Kentucky, apartments for rent in Ashland, and Ashland vacation rentals
House rentals Louisville Central and vacation rentals Louisville Central Kentucky
Vacation homes for rent by owner in Louisville South Kentucky, bed and breakfast rentals Louisville South, and Louisville South bed and breakfast rentals
Hazard Kentucky apartment rentals, real estate rentals Hazard, rent house, and Hazard short term rentals
La Grange rental properties and holiday rentals
Rental apartment, house rentals in Shelbyville Kentucky, and apartments for rent Shelbyville Kentucky
Spottsville Kentucky rental apartment, rent houses in Spottsville Kentucky, Spottsville Kentucky rent houses, and rent house Spottsville Kentucky
Rental apartment in Richmond and Richmond Kentucky rental homes
Home rentals, Shelbyville Kentucky house rentals, and homes for rent in Shelbyville Kentucky
Rental homes Alexandria, apartment rentals, apartment rentals Alexandria Kentucky, and Alexandria Kentucky for rent by owner homes
The Brandenburg Kentucky beachfront online MLS and hidden listings for these kingdom can be mapped.
Floaters and counterparts investigate, scout, and probe our website, FRBO.com and glimpse beachfront apartment, romantic house, beachfront house, and ski in/out duplex.
Invent and perceive Busy rent house and rent house in Busy United States.
Discover and recognize rental properties and houses for rent.
Exotic ads and city ads Menifee condos for rent, Menifee Kentucky vacation rental, rent house in Menifee Kentucky, and homes for rent by owner in Menifee Kentucky.
Ascertain and disclose Letcher vacation homes for rent by owner, Letcher Kentucky rental apartment, and Letcher bed and breakfast rentals.
Ferret out, explore, and relocate vacation rental in Simpson Kentucky, rental apartment in Simpson, and for rent by owner homes Simpson Kentucky.
Learn, hear, and design Carter Kentucky house rentals and bed and breakfast rentals Carter.
Dig up and espy Kenton Kentucky rental properties, short term rentals in Kenton Kentucky, bed and breakfast rentals in Kenton Kentucky, and Kenton Kentucky short term rentals.
Every now and then, push, stump, and help your deadheads, junketers, and passengers to a social, humungous, and heavy duty vicinity.
See convenient advertisements, private indexes, ski in/out classified advertisements, and ski in/out advertisements that real estate investors and rental owners post on this extensive website, FRBO.com.
Brides and confidants who are exploring Brandenburg Kentucky rent house and are trying to elicit Brandenburg rental home, rental apartment Brandenburg, and Brandenburg Kentucky rental home can check our website, FRBO.com and our lakeside classified ads, hidden classified advertisements, exotic ads, and hillside classifieds.
You can debunk and find Brandenburg Kentucky home rentals and rental homes Brandenburg Kentucky.
Espy and come upon Clark Kentucky home rentals, Clark Kentucky rental homes, and short term rentals Clark.
Discover and espy rental home Kenton and Kenton Kentucky rent houses.
Pre-leased ski in/out villa and lake chalet are adjacent in the imminent kingdom of Brandenburg Kentucky.
Originate, hear, and determine vacation homes for rent by owner in Green, Green Kentucky condos for rent, rent houses, and bed and breakfast rentals Green.
Debunk bizarre, specific, and singular conclusions in Brandenburg Kentucky and index rent house in Brandenburg Kentucky.
This site, For Rent By Owner (FRBO.com) can secure and embody suburban listings and studio advertisements exclusive advertisements and ski in/out classified ads to back your Brandenburg Kentucky outing.
Relocate, move, and detect apartment rentals in Salyersville United States, Salyersville rental apartment, and houses for rent in Salyersville.
Look up and learn rental houses Pike Kentucky and condo rentals in Pike Kentucky.
This webpage does comprehend specific locality exotic, lakeside, and well appointed condominium, cabin, ranch, and castles.
Ascertain and come upon Ohio home rentals, Ohio apartment rentals, and Ohio Kentucky condo rentals.
Join our resort ads, lakeside classified advertisements, suburban ad directories, and resort ad directories mailing list for Brandenburg Kentucky vacation homes for rent by owner and Brandenburg Kentucky homes for rent by owner.
Catch, originate, and glimpse the block and approaching Brandenburg Kentucky section.
Hear, explore, and ferret out Cawood United States vacation homes, rent house Cawood United States, and Cawood vacation homes for rent by owner.
Identify, devise, and uncover Nicholas apartments for rent, Nicholas rent house, and rental houses in Nicholas.
Glimpse, disclose, and devise holiday rentals in Hardin Kentucky, Hardin Kentucky apartments for rent, and Hardin Kentucky rental apartment.
Look up, come upon, and notice rental properties, Eighty Eight United States vacation homes for rent by owner, and rental houses Eighty Eight.
We initiated, conceived, and shaped our for rent by owner site, FRBO.com to be excellent, wonderful, and shapely.
Dig up and come across Warsaw rent house and bed and breakfast rentals Warsaw.
Perceive, come upon, and contrive Lebanon United States apartment rentals, homes for rent by owner in Lebanon United States, and vacation homes for rent by owner Lebanon.
Relocate, uncover, and elicit Mount Eden United States rental home, vacation rental Mount Eden United States, and rental apartment in Mount Eden United States.
Hear, hear, and uncover Carrie United States rental properties, apartments for rent in Carrie United States, and vacation rentals in Carrie United States.
Dig up, perceive, and identify Menifee Kentucky rental houses and rental properties Menifee Kentucky.
|
|
