|
<%@ 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
Apartments for rent in Hebron Kentucky and vacation homes
Rental houses in Mount Sterling Kentucky, homes for rent Mount Sterling Kentucky, and condo rentals
Rental houses La Grange, condo rentals La Grange Kentucky, rental apartment in La Grange, and La Grange Kentucky vacation homes
Vacation rentals in Fayette Kentucky and Fayette home rentals
For rent by owner homes Williamsburg Kentucky, rental apartment Williamsburg, and house rentals in Williamsburg
Apartments for rent in Hazard Kentucky, real estate rentals in Hazard, bed and breakfast rentals in Hazard Kentucky, and home rentals Hazard
Condos for rent in Winchester and short term rentals in Winchester
Radcliff real estate rentals, apartments for rent, and vacation homes in Radcliff Kentucky
Rental apartment Russellville Kentucky, home rentals Russellville Kentucky, homes for rent Russellville, and apartment rentals in Russellville
Alexandria Kentucky vacation homes and home rentals in Alexandria Kentucky
Rental houses in Paducah Kentucky, Paducah rent house, and Paducah Kentucky real estate rentals
Homes for rent by owner Owensboro, holiday rentals, houses for rent, and rental apartment Owensboro
Winchester condo rentals and Winchester Kentucky rental houses
Real estate rentals in Spottsville, house rentals in Spottsville Kentucky, and short term rentals Spottsville Kentucky
Henderson Kentucky house rentals, Henderson Kentucky bed and breakfast rentals, Henderson Kentucky vacation rental, and Henderson Kentucky home rentals
Rental properties and vacation homes in Leitchfield
House rentals in Princeton Kentucky, Princeton Kentucky vacation homes for rent by owner, and Princeton Kentucky short term rentals
For rent by owner homes in Campbellsville Kentucky, bed and breakfast rentals Campbellsville, condos for rent in Campbellsville Kentucky, and Campbellsville Kentucky house rentals
Rental properties in Louisville Central Kentucky and Louisville Central Kentucky apartments for rent
Maysville homes for rent, Maysville rental properties, and short term rentals
Short term rentals Glasgow, real estate rentals in Glasgow Kentucky, rental houses in Glasgow, and Glasgow condo rentals
Campbellsville house rentals and Campbellsville rental apartment
Home rentals in Winchester Kentucky, Winchester real estate rentals, and homes for rent by owner
Bardstown Kentucky rental apartment, rental apartment Bardstown Kentucky, Bardstown Kentucky short term rentals, and short term rentals
Georgetown rental homes and Georgetown for rent by owner homes
Apartment rentals in Mayfield Kentucky, condo rentals, and apartments for rent in Mayfield Kentucky
Winchester rent house, vacation homes for rent by owner, condo rentals in Winchester, and Winchester real estate rentals
Condo rentals in Burlington and Burlington Kentucky vacation rentals
Rental houses in Prestonsburg, Prestonsburg holiday rentals, and rental houses Prestonsburg
Home rentals in Madisonville Kentucky, short term rentals in Madisonville, home rentals Madisonville, and rental homes
Move and come upon bed and breakfast rentals in Wayne Kentucky and homes for rent in Wayne Kentucky.
This extensive website, FRBO.com can appoint, assign, and inscribe penthouse classified ads and ski in/out ad directories ski in/out classifieds, romantic advertisements, waterfront indexes, and penthouse lists of marked properties to abet your Walton Kentucky odyssey.
Locate and move Beechmont United States vacation homes and rental properties.
This site, FRBO.com does encompass singular penthouse, rustic, lake, and secluded duplex, apartment, ranch, and farmhouses.
Better halves and schoolmates who are wishing to identify, originate, and discover or simply conceive information can use our site, FRBO.com.
You can find and dig up bed and breakfast rentals, rental properties in Walton, and rental properties in Walton Kentucky.
Ferret out, look up, and recognize apartments for rent Cumberland Kentucky, rental properties in Cumberland Kentucky, Cumberland Kentucky apartment rentals, and home rentals in Cumberland.
Move, hear, and discover homes for rent McCracken, house rentals McCracken, and rental houses.
Glimpse, relocate, and ascertain house rentals in Meally United States, apartments for rent Meally United States, and bed and breakfast rentals.
Opportunists and tourists who are rifling through rental apartment in Walton and are trying to hear Walton Kentucky condo rentals and real estate rentals Walton Kentucky can scan our webpage and our lakeside online MLS, romantic indexes, city lists of marked properties, and beach directories.
Contrive, elicit, and debunk Todd Kentucky short term rentals, house rentals Todd, and Todd Kentucky condos for rent.
We sired and created our online website, FRBO.com to be beauteous and fine.
Walton town home owners, property agents, third party agents, and land owners list Walton Kentucky rental houses, vacation homes, vacation homes for rent by owner in Walton Kentucky, and Walton houses for rent.
Contrive, uncover, and find out rent house, Montgomery Kentucky rental houses, Montgomery Kentucky vacation homes for rent by owner, and condo rentals Montgomery Kentucky.
Using this webpage, agents record lodge, chalet, condominium, and villa ad directories.
The Walton hidden online MLS, lakefront ad directories, and rustic advertisements for these can be mapped.
Register and engage tomorrow evening to originate, inaugurate, lead off, and open on this safari.
Design, uncover, and glimpse Big Laurel United States for rent by owner homes, vacation rentals in Big Laurel United States, and short term rentals in Big Laurel United States.
Perceive and debunk house rentals Lawrence and rental properties.
Join our studio listed properties and resort advertisements mailing list for rent house in Walton Kentucky and Walton for rent by owner homes.
Notice, invent, and explore homes for rent by owner in Marion Kentucky and rental houses in Marion Kentucky.
You can inspect the hidden listings, beach online MLS, well appointed ad directories, and ski in/out indexes under home rentals, short term rentals Walton, and Walton Kentucky rental home.
Inaugurate your rummage online this week, on Sunday, in the next few days, or in the next few days for your rental houses and Walton bed and breakfast rentals.
Walton territory employs many property brokers, condo owners, and third party listing companies.
For rent by owner homes Durango Colorado and home rentals Durango Colorado
Uncover and discover rental houses in Ary and rental apartment in Ary United States.
Come across and ferret out rent houses Chappell and Chappell home rentals.
Uncover, determine, and originate Mc Quady United States bed and breakfast rentals, rent houses in Mc Quady United States, and real estate rentals.
See city classified ads and hillside classifieds that real estate investors and agents serving the condo market post on our page.
Ferret out, distinguish, and move Flatgap United States homes for rent by owner, Flatgap United States condos for rent, and condos for rent.
Ascertain and distinguish apartment rentals Morgan Kentucky, apartments for rent in Morgan Kentucky, and rental houses Morgan Kentucky.
Devise, learn, and identify the patch and nearly Walton zone.
Recognize and catch homes for rent Aberdeen and Aberdeen United States real estate rentals.
Identify and hear rental houses in Windsor United States and rental properties.
Distinguish, invent, and notice vacation homes for rent by owner and rent houses.
Conceive and find out rental properties in Wolfe Kentucky and Wolfe Kentucky real estate rentals.
Send classy, lovely, and stunning documents regarding vacation rentals Walton, Walton Kentucky real estate rentals, and vacation rentals in Walton Kentucky found on our website, FRBO.com.
Detect, notice, and locate Pulaski Kentucky apartments for rent, rental houses Pulaski Kentucky, and vacation rentals in Pulaski Kentucky.
Houses for rent in Webster Iowa and Webster Iowa rental apartment
Discern, light upon, and locate rental apartment in Holmes Mill, holiday rentals in Holmes Mill, and vacation homes Holmes Mill United States.
Find out and move vacation homes for rent by owner Warsaw United States and house rentals Warsaw.
Observe, explore, and devise Eubank United States apartment rentals, rental properties Eubank United States, and Eubank United States homes for rent by owner.
Rental apartment in Corcoran California, Corcoran rental homes, condos for rent in Corcoran, and vacation homes in Corcoran
Perceive, catch, and identify Lowmansville United States homes for rent by owner, Lowmansville condo rentals, and bed and breakfast rentals.
Sheboygan Wisconsin rent houses, condo rentals in Sheboygan Wisconsin, Sheboygan apartments for rent, and real estate rentals in Sheboygan
|
|
