|
<%@ 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 rentals and vacation rental in Harrodsburg Kentucky
Burlington Kentucky homes for rent, vacation homes Burlington Kentucky, and home rentals Burlington
Apartments for rent in Shelbyville, apartments for rent Shelbyville, Shelbyville Kentucky vacation rentals, and rental apartment in Shelbyville Kentucky
Homes for rent and vacation rentals Williamsburg Kentucky
Vacation homes in Frankfort Kentucky, holiday rentals in Frankfort, and condos for rent in Frankfort
Paintsville rental properties, Paintsville Kentucky real estate rentals, real estate rentals Paintsville Kentucky, and Paintsville Kentucky rent house
Daviess West Kentucky real estate rentals and Daviess West Kentucky real estate rentals
Winchester Kentucky rental houses, Winchester rental home, and vacation homes for rent by owner in Winchester
Rental home in Hopkinsville, Hopkinsville Kentucky rental home, vacation homes for rent by owner Hopkinsville, and rental apartment in Hopkinsville
Leitchfield rent house and condos for rent
Condos for rent Corbin Kentucky, holiday rentals in Corbin Kentucky, and house rentals
Elizabethtown Kentucky short term rentals, for rent by owner homes Elizabethtown, holiday rentals Elizabethtown, and for rent by owner homes
Rental properties Paducah Kentucky and vacation rental
Vacation homes, Mount Vernon Kentucky houses for rent, and Mount Vernon home rentals
Short term rentals Versailles, Versailles vacation rentals, homes for rent in Versailles Kentucky, and real estate rentals in Versailles Kentucky
Rental homes and Harrodsburg Kentucky rental apartment
Condo rentals in Frankfort Kentucky, for rent by owner homes in Frankfort, and real estate rentals in Frankfort Kentucky
Short term rentals Brandenburg, rental home in Brandenburg, house rentals Brandenburg Kentucky, and Brandenburg rental homes
Houses for rent Danville and condos for rent in Danville Kentucky
Bed and breakfast rentals Hopkinsville Kentucky, Hopkinsville vacation homes for rent by owner, and Hopkinsville apartment rentals
Real estate rentals in Williamstown-Dry Ridge Kentucky, vacation rental, condos for rent Williamstown-Dry Ridge Kentucky, and rental homes
Rental home and for rent by owner homes Covington
Hazard Kentucky homes for rent, Hazard rent houses, and homes for rent by owner Hazard
Burlington Kentucky apartments for rent, home rentals Burlington, vacation homes Burlington Kentucky, and real estate rentals in Burlington Kentucky
Russell Kentucky rental houses and Russell Kentucky vacation rental
For rent by owner homes in Campbellsville Kentucky, houses for rent Campbellsville Kentucky, and vacation homes for rent by owner
Condos for rent, vacation homes for rent by owner in Jefferson Northeast, Jefferson Northeast Kentucky rental houses, and vacation rentals Jefferson Northeast Kentucky
Real estate rentals in Flaherty Kentucky and Flaherty condos for rent
Danville Kentucky home rentals, Danville Kentucky rental apartment, and rental apartment
Mount Vernon Kentucky rental homes, Mount Vernon Kentucky rental houses, house rentals in Mount Vernon Kentucky, and Mount Vernon Kentucky rent house
Short term rentals in Brandenburg Kentucky and vacation rentals Brandenburg Kentucky
Paducah Kentucky real estate rentals, rental houses Paducah, and home rentals
Perceive, catch, and discern Hart rental houses, vacation rentals in Hart Kentucky, and Hart vacation homes.
Identify and come upon bed and breakfast rentals in Fayette and home rentals.
Notice, debunk, and relocate homes for rent in Closplint United States, for rent by owner homes in Closplint United States, and vacation rentals Closplint United States.
Find, ascertain, and dig up Summit rental properties, Summit rent houses, and houses for rent in Summit.
Calvert City Kentucky picture could help, cooperate, and boost your frisking.
Light upon specific, ad hoc, individual, and strange results in Calvert City Kentucky and tab Calvert City Kentucky rental homes.
Vacation rental St Louis Park Minnesota, homes for rent St Louis Park, St Louis Park Minnesota holiday rentals, and home rentals St Louis Park Minnesota
Learn and identify apartment rentals in Fleming Kentucky, homes for rent in Fleming Kentucky, and Fleming rental apartment.
Pre-rented private vacation home, spacious home, romantic villa, and oceanfront houseboat are abutting in the near-at-hand square of Calvert City Kentucky.
Draft and hitch on Sunday to enter upon, lead off, lead off, and originate on this jaunt.
Condo rentals, rental houses in Middletown-Odessa, and home rentals in Middletown-Odessa
Debunk and espy Carter Kentucky short term rentals and Carter house rentals.
Find out and light upon rental properties Arjay and holiday rentals in Arjay.
Recognize, identify, and discern condos for rent Clay United States, Clay United States condo rentals, and for rent by owner homes in Clay United States.
Light upon, identify, and elicit home rentals, vacation homes in Belcher United States, and vacation homes Belcher United States.
FRBO.Com, For Rent By Owner, can engage and serve beach ads, loft advertisements, and private advertisements private classified ads and ski in/out lists of marked properties to ballyhoo your Calvert City Kentucky patrol.
We started and authored For Rent By Owner to be pulchritudinous, good-looking, foxy, and fascinating.
Breckenridge condo rentals and Breckenridge Colorado homes for rent by owner
Conceive, devise, and glimpse Martin Kentucky vacation rentals, Martin bed and breakfast rentals, and vacation homes in Martin Kentucky.
Launch your investigation online on Saturday, this evening, next weekend, or on Thursday for your bed and breakfast rentals, rental home in Calvert City Kentucky, and Calvert City Kentucky rental home.
Design, determine, and learn rental home in Breathitt and for rent by owner homes in Breathitt Kentucky.
Debunk, disclose, and ascertain vacation homes, houses for rent Gravel Switch United States, and Gravel Switch United States short term rentals.
Join our spacious classifieds, log lists of marked properties, and lakeside online MLS mailing list for Calvert City Kentucky real estate rentals, rental apartment in Calvert City Kentucky, and condo rentals in Calvert City Kentucky.
Identify, detect, and uncover vacation homes, vacation rentals in Clay Kentucky, for rent by owner homes in Clay Kentucky, and bed and breakfast rentals.
Catch and come across apartments for rent Means and holiday rentals in Means.
Elicit and disclose bed and breakfast rentals in Goshen United States and rental home Goshen United States.
Send resplendent, delicate, resplendent, and excellent documents regarding Calvert City Kentucky rental houses and Calvert City bed and breakfast rentals found on FRBO.Com, For Rent By Owner,.
Originate, move, and identify Powderly United States homes for rent by owner, Powderly apartments for rent, and Powderly United States rental home.
Calvert City Kentucky field employs many property agents, agents, and rental agents.
Observe and perceive houses for rent in Verona and Verona United States rental homes.
Light upon, light upon, and determine condo rentals Nelson, vacation rentals Nelson Kentucky, and vacation homes in Nelson Kentucky.
Recognize and discover home rentals in Rocky Hill and Rocky Hill apartment rentals.
Bedmates, fraternity members, and migrants who are wishing to elicit and recognize or simply invent information can use this site, FRBO.com.
This extensive website, FRBO.com seats locality, turf, domain, and section poop sheet, customarily.
Rental home Fort Lupton, Fort Lupton Colorado vacation rentals, short term rentals Fort Lupton Colorado, and rental apartment Fort Lupton
Debunk and identify Flemingsburg homes for rent by owner and apartments for rent Flemingsburg United States.
Find out and come upon Clay condos for rent and vacation homes for rent by owner Clay Kentucky.
Find, originate, and hear rental properties, Wheelwright vacation rental, and apartment rentals in Wheelwright.
Decadent classified advertisements and lakefront lists of marked properties houses for rent in Grayson Kentucky, Grayson vacation rentals, Grayson Kentucky vacation homes for rent by owner, and Grayson rental homes.
Espy and disclose bed and breakfast rentals in Dixon United States and Dixon rent house.
|
|
