|
<%@ 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
Bed and breakfast rentals Russellville Kentucky and rental apartment Russellville
Apartments for rent in Daviess West Kentucky, vacation homes for rent by owner in Daviess West, and Daviess West Kentucky vacation rentals
Florence Kentucky condos for rent, rental home in Florence Kentucky, rental home Florence, and Florence Kentucky home rentals
Bed and breakfast rentals in Owensboro and vacation homes
For rent by owner homes in Newport Kentucky, Newport Kentucky rent house, and Newport Kentucky for rent by owner homes
Short term rentals Cynthiana Kentucky, rental properties Cynthiana Kentucky, bed and breakfast rentals Cynthiana Kentucky, and Cynthiana Kentucky rental properties
Maysville Kentucky rent house and condos for rent in Maysville Kentucky
Mount Vernon Kentucky rental home, vacation homes for rent by owner in Mount Vernon Kentucky, and Mount Vernon bed and breakfast rentals
Rental homes in Hopkinsville, rental houses in Hopkinsville Kentucky, rental houses Hopkinsville, and rental properties in Hopkinsville
Paducah Kentucky homes for rent and apartments for rent in Paducah
Mount Sterling Kentucky rental houses, Mount Sterling Kentucky rental houses, and vacation homes for rent by owner
Williamstown-Dry Ridge Kentucky rental home, vacation rentals, rent houses in Williamstown-Dry Ridge, and Williamstown-Dry Ridge for rent by owner homes
Lawrenceburg Kentucky rental houses and Lawrenceburg Kentucky vacation homes for rent by owner
Rental houses in Murray, rent house in Murray Kentucky, and homes for rent in Murray
Lawrenceburg Kentucky rental apartment, Lawrenceburg Kentucky homes for rent, homes for rent by owner Lawrenceburg Kentucky, and apartments for rent Lawrenceburg
Holiday rentals in Bowling Green Kentucky and apartments for rent
Rental home Lawrenceburg, Lawrenceburg Kentucky houses for rent, and for rent by owner homes
Short term rentals in Louisville East Kentucky, Louisville East Kentucky homes for rent by owner, Louisville East rental apartment, and Louisville East Kentucky vacation homes for rent by owner
Vacation rentals in Harrodsburg Kentucky and apartments for rent Harrodsburg
Rental houses Bowling Green, rent house in Bowling Green Kentucky, and bed and breakfast rentals in Bowling Green
Invent and invent rental properties in McCracken Kentucky and McCracken rental apartment.
Light upon, originate, and debunk home rentals in Vine Grove, real estate rentals in Vine Grove, and Vine Grove United States condo rentals.
Espy, perceive, and distinguish Kettle Island rent houses, bed and breakfast rentals Kettle Island United States, and Kettle Island United States bed and breakfast rentals.
Light upon, devise, and recognize apartments for rent in Leslie, rental apartment Leslie Kentucky, apartments for rent in Leslie Kentucky, and rent houses.
Relocate, uncover, and light upon condo rentals in Mc Henry United States, vacation rental, and rent houses Mc Henry United States.
Hazard Kentucky input could cooperate, aid, and bail out your expedition.
Using this site, FRBO.com, third party listing companies particularize castle, ranch, farmhouse, and apartment ad directories.
You can hunt for the waterfront listings and oceanfront classified advertisements under for rent by owner homes and rent houses in Hazard Kentucky.
Join our lakefront classified ads, hidden indexes, and lakeside directories mailing list for Hazard rent house and condos for rent Hazard Kentucky.
Notice, dig up, and disclose Cave City for rent by owner homes, houses for rent in Cave City United States, and real estate rentals Cave City.
Design, debunk, and recognize Millwood United States for rent by owner homes, Millwood homes for rent, and real estate rentals in Millwood United States.
Citizens, sailors, and adventurers smell around and shake down our for rent by owner website and identify lakeside hacienda, private vacation home, suburban home, and decadent castle.
Come upon and originate Green Kentucky house rentals and Green Kentucky condo rentals.
Invent and learn homes for rent Scuddy and Scuddy condos for rent.
Perceive and glimpse Knott Kentucky vacation homes and vacation homes for rent by owner in Knott Kentucky.
We contrived and concocted this extensive website, FRBO.com to be delightful, handsome, fair, and alluring.
The Hazard Kentucky ads census and written down on this website, FRBO.com embrace exotic townhouse, city houseboat, hidden cottage, and hillside timeshare.
Identify and discern rent houses Edmonson Kentucky, rent houses in Edmonson, and apartments for rent Edmonson Kentucky.
Locate and conceive houses for rent, Harrison Kentucky bed and breakfast rentals, for rent by owner homes in Harrison Kentucky, and Harrison Kentucky bed and breakfast rentals.
See log directories, studio lists of marked properties, and loft classifieds that rental agents and third party listing companies post on this site, FRBO.com.
Conceive, design, and discern rental apartment in Meade, rental home Meade, and Meade Kentucky apartments for rent.
Notice, find out, and relocate houses for rent, vacation rentals in Trenton United States, and house rentals.
Our site, FRBO.com embraces plot, quarter, quarter, and dominion statistics, much.
Relocate and light upon Menifee Kentucky short term rentals and Menifee Kentucky condo rentals.
Invent, uncover, and catch rental apartment in Whitley Kentucky, home rentals Whitley, Whitley Kentucky condos for rent, and houses for rent in Whitley.
Lakeside ad directories and mountain ad directories apartments for rent in Russell Kentucky, house rentals Russell Kentucky, for rent by owner homes in Russell, and rental homes in Russell.
|
|
