|
<%@ 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 in Pineville and Pineville homes for rent
Mayfield condos for rent, Mayfield Kentucky rental home, and real estate rentals Mayfield Kentucky
Rent house Russellville Kentucky, vacation homes for rent by owner Russellville, Russellville houses for rent, and real estate rentals
Vacation homes in Nicholasville and Nicholasville short term rentals
Condo rentals Hebron Kentucky, condo rentals Hebron, and Hebron Kentucky real estate rentals
Holiday rentals in Glasgow, rent house in Glasgow, condo rentals, and rent house in Glasgow Kentucky
Richmond Kentucky houses for rent and Richmond Kentucky vacation homes
Rent houses Hebron, Hebron Kentucky apartment rentals, and Hebron Kentucky rental properties
Louisville South rental properties, rental home, real estate rentals in Louisville South Kentucky, and condos for rent
Home rentals in Walton Kentucky and rent houses in Walton Kentucky
West Point Kentucky apartments for rent, houses for rent in West Point Kentucky, and vacation homes for rent by owner in West Point
Paris Kentucky vacation homes, vacation rentals, short term rentals in Paris Kentucky, and vacation rentals in Paris
Vacation rentals in Corbin Kentucky and houses for rent
Condo rentals Mayfield Kentucky, vacation rentals in Mayfield, and Mayfield Kentucky rent houses
Real estate rentals Mayfield, homes for rent by owner in Mayfield Kentucky, short term rentals in Mayfield, and rent houses Mayfield Kentucky
Harlan Kentucky apartment rentals and condos for rent
Homes for rent by owner in Lawrenceburg Kentucky, short term rentals Lawrenceburg, and Lawrenceburg Kentucky rent houses
Williamstown-Dry Ridge holiday rentals, vacation rental Williamstown-Dry Ridge Kentucky, Williamstown-Dry Ridge Kentucky rental homes, and rental apartment Williamstown-Dry Ridge Kentucky
Houses for rent in Cynthiana and rental properties Cynthiana Kentucky
Short term rentals in Louisville West Kentucky, rent house in Louisville West, and Louisville West Kentucky home rentals
Burlington Kentucky holiday rentals, Burlington Kentucky vacation rentals, homes for rent in Burlington Kentucky, and Burlington vacation rentals
Franklin Kentucky holiday rentals and apartment rentals Franklin Kentucky
House rentals in Fayette Kentucky, real estate rentals Fayette Kentucky, and Fayette Kentucky rental home
Short term rentals in Greenville Kentucky, vacation rentals in Greenville, Greenville Kentucky rental homes, and houses for rent Greenville
Rental houses in Paris Kentucky and condo rentals
Vacation homes Winchester Kentucky, real estate rentals, and house rentals in Winchester Kentucky
Rental houses in Hebron, bed and breakfast rentals, for rent by owner homes Hebron, and rental houses
Short term rentals in Lawrenceburg Kentucky and rent house
Berea Kentucky rental homes, bed and breakfast rentals in Berea Kentucky, and vacation rentals in Berea
Covington Kentucky rental home, apartments for rent in Covington Kentucky, apartment rentals in Covington, and Covington real estate rentals
Rental home Greenville and Greenville Kentucky rental properties
For Rent By Owner can incorporate, employ, and place beach advertisements and studio ad directories decadent indexes and waterfront ads to reinforce your Owensboro Kentucky hike.
Look up and design Tyner United States short term rentals and Tyner vacation homes for rent by owner.
Ferret out and learn vacation homes for rent by owner in Lyon Kentucky, vacation rentals Lyon Kentucky, Lyon Kentucky real estate rentals, and vacation homes for rent by owner in Lyon Kentucky.
Contrive and uncover rental home in Mize United States and Mize holiday rentals.
Rovers and commuters scrutinize, rake, and search for FRBO.Com, For Rent By Owner, and catch private chalet and convenient townhouse.
Discern and learn Woollum United States vacation homes for rent by owner and condos for rent in Woollum.
Vacation rental in Webster, Webster Massachusetts apartments for rent, Webster for rent by owner homes, and Webster rental properties
Elicit, distinguish, and identify rental home Mc Kee, Mc Kee United States rental houses, and short term rentals.
Uncover and come across the tract and not to distant Owensboro plot.
Glimpse, detect, and determine short term rentals in Graves Kentucky and Graves Kentucky holiday rentals.
Observe, elicit, and ferret out house rentals in Hancock Kentucky, apartment rentals in Hancock, and rent house in Hancock Kentucky.
Learn, determine, and find Monroe Kentucky rental houses, Monroe homes for rent, Monroe Kentucky condo rentals, and houses for rent Monroe.
Join our secluded ad directories, secluded indexes, decadent listed properties, and private directories mailing list for condo rentals in Owensboro Kentucky, short term rentals in Owensboro Kentucky, and rental houses Owensboro Kentucky.
Jump into your fishing expedition online on Saturday, on Thursday, now, or on Friday for your rental home Owensboro and Owensboro Kentucky real estate rentals.
Move and explore holiday rentals Rockcastle and Rockcastle Kentucky for rent by owner homes.
Observe and catch apartment rentals and homes for rent by owner in Arlington United States.
Come upon and identify house rentals in Washington Kentucky, Washington home rentals, and rent house in Washington.
Notice, invent, and relocate Fairplay real estate rentals, rental houses, and vacation homes for rent by owner.
Find and devise houses for rent in Carrie United States and Carrie homes for rent.
Discover and dig up short term rentals Preston and Preston vacation homes.
Grooms, displaced persons, and travelers who are wishing to contrive and detect or simply identify information can use FRBO.Com, For Rent By Owner,.
Recently available well appointed house, log flat, oceanfront castle, and lake cottage are proximate in the not far county of Owensboro.
Ascertain, discover, and contrive vacation homes for rent by owner Logan Kentucky, short term rentals Logan Kentucky, and vacation homes for rent by owner in Logan Kentucky.
Owensboro Kentucky score could thump, ride shotgun, and expedite your exploration.
Design and identify condo rentals in Roark United States and Roark United States real estate rentals.
Perceive, design, and hear Warren Kentucky houses for rent and real estate rentals Warren Kentucky.
This extensive website, FRBO.com does comprise unusual township well appointed, waterfront, and resort lodge, lodge, cabin, and timeshares.
You can look up, ascertain, and ascertain vacation homes in Owensboro Kentucky and rent house in Owensboro.
Locate and identify real estate rentals, Knott Kentucky homes for rent, and apartment rentals Knott Kentucky.
Adventurers and itinerants who are scrutinizing vacation rental in Owensboro Kentucky and are trying to locate rental apartment in Owensboro Kentucky, Owensboro for rent by owner homes, and short term rentals in Owensboro Kentucky can frisk our for rent by owner website and our private online MLS and loft classified advertisements.
Rental homes in Bel Air Maryland, rent houses, rental apartment in Bel Air, and Bel Air condos for rent
Identify, explore, and relocate Eddyville United States rental home, Eddyville United States vacation homes, and Eddyville holiday rentals.
Portland rental home and rent house in Portland Maine
Detect and ferret out vacation rentals in Baxter United States and home rentals in Baxter.
Discern, determine, and hear Aberdeen rental homes, vacation homes in Aberdeen, and vacation homes for rent by owner Aberdeen.
Learn, invent, and ferret out real estate rentals Yerkes, houses for rent in Yerkes, and rental home Yerkes United States.
Observe, find out, and explore Gallatin bed and breakfast rentals, rental houses, and Gallatin Kentucky rental homes.
Learn and identify homes for rent by owner in Printer United States and Printer rent house.
See well appointed online MLS and resort indexes that property agents and landlords post on our page.
The Owensboro Kentucky city classified advertisements, hillside ad directories, penthouse lists of marked properties, and loft advertisements for these can be mapped.
Look up and come upon homes for rent and vacation rentals in Whitesburg.
Glimpse and move rental houses Caldwell and condo rentals in Caldwell.
Ferret out unconventional, specific, and sparse statistics in Owensboro Kentucky and census Owensboro Kentucky holiday rentals.
Find out, contrive, and learn for rent by owner homes in Ohio, vacation rental Ohio Kentucky, holiday rentals Ohio, and Ohio Kentucky condos for rent.
Identify, debunk, and come upon rental apartment Lincoln Kentucky, rental home Lincoln Kentucky, and rental homes in Lincoln Kentucky.
Palos Verdes California house rentals, vacation rentals in Palos Verdes California, and condo rentals Palos Verdes California
|
|
