|
<%@ 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
Franklin Kentucky house rentals and real estate rentals in Franklin
Henderson Kentucky rental houses, vacation homes in Henderson, and short term rentals in Henderson Kentucky
Home rentals Radcliff Kentucky, homes for rent by owner Radcliff, for rent by owner homes Radcliff Kentucky, and Radcliff rental home
Rent houses in Madisonville and rent house in Madisonville Kentucky
House rentals in Danville Kentucky, Danville Kentucky for rent by owner homes, and Danville for rent by owner homes
Condo rentals Danville, Danville holiday rentals, rental homes, and condos for rent Danville Kentucky
Condo rentals in Louisville West and homes for rent
Bed and breakfast rentals, Fort Campbell Kentucky home rentals, and homes for rent Fort Campbell Kentucky
Rental homes in Prestonsburg Kentucky, short term rentals in Prestonsburg, rent houses Prestonsburg Kentucky, and condo rentals
Daviess East Kentucky holiday rentals and rental apartment in Daviess East
Rent house in Calvert City Kentucky, Calvert City rental properties, and real estate rentals in Calvert City Kentucky
Rental homes Russellville, Russellville Kentucky rent house, Russellville home rentals, and vacation homes Russellville
Vacation homes Maysville and Maysville Kentucky rental home
Real estate rentals in Harlan Kentucky, rent houses Harlan Kentucky, and rental apartment Harlan
Flaherty Kentucky vacation homes for rent by owner, apartments for rent in Flaherty Kentucky, apartments for rent, and rental homes Flaherty
Corbin Kentucky rent houses and short term rentals in Corbin
Homes for rent in Barbourville, Barbourville Kentucky homes for rent by owner, and vacation rental Barbourville
Rent house in Pewee Valley Kentucky, apartment rentals Pewee Valley, apartment rentals, and Pewee Valley Kentucky apartment rentals
Campbellsville Kentucky rental apartment and vacation homes for rent by owner
Rental homes, rent house, and condo rentals in Spottsville
Short term rentals Pewee Valley, Pewee Valley Kentucky rental houses, Pewee Valley Kentucky rental apartment, and Pewee Valley Kentucky bed and breakfast rentals
Short term rentals Prestonsburg Kentucky and Prestonsburg Kentucky condos for rent
Houses for rent Winchester Kentucky, vacation rentals in Winchester, and rental properties in Winchester Kentucky
Rent house Daviess East, Daviess East condo rentals, Daviess East Kentucky vacation homes for rent by owner, and Daviess East home rentals
Benton Kentucky rental houses and real estate rentals Benton Kentucky
Perceive, elicit, and identify house rentals Calloway Kentucky and rental homes in Calloway Kentucky.
Contrive and espy apartment rentals in McCracken Kentucky and real estate rentals McCracken Kentucky.
Design, distinguish, and hear Carter rental houses, Carter Kentucky for rent by owner homes, and home rentals Carter.
Conceive and find bed and breakfast rentals Perry, Perry Kentucky condos for rent, holiday rentals, and rental houses in Perry Kentucky.
Studio indexes and well appointed lists of marked properties rental apartment in Fleming Kentucky, for rent by owner homes in Fleming Kentucky, Fleming Kentucky vacation homes, and home rentals Fleming Kentucky.
Come across, come across, and find apartment rentals in Rockfield United States, Rockfield United States vacation rentals, and vacation rentals Rockfield United States.
Notice and detect Daviess rental apartment, Daviess Kentucky home rentals, homes for rent by owner in Daviess, and rent houses in Daviess.
Short term rentals Jurupa and bed and breakfast rentals in Jurupa California
Join our suburban listings and convenient directories mailing list for home rentals in Winchester, Winchester rent house, and house rentals in Winchester Kentucky.
Find out and discover holiday rentals in Carter Kentucky and Carter homes for rent.
This webpage does exclude distinct section romantic, beachfront, rustic, and exotic farmhouse and vacation homes.
Winchester Kentucky county employs many rental agents, condo owners, and real estate investors.
You can find out, learn, and find Winchester Kentucky rental homes and rent houses Winchester.
Come across and dig up homes for rent by owner in Greenup United States and Greenup homes for rent.
Come upon and hear vacation homes, short term rentals in Breckinridge, and Breckinridge Kentucky holiday rentals.
Originate, conceive, and disclose home rentals Estill, Estill holiday rentals, and house rentals.
Locate, hear, and perceive Edna vacation homes for rent by owner, rental properties in Edna, and apartments for rent Edna United States.
Possessors and householders hunt for, root, and study FRBO.Com, For Rent By Owner, and detect suburban farmhouse, decadent cottage, beachfront houseboat, and penthouse hacienda.
Learn, determine, and identify Grant vacation rentals, apartment rentals in Grant Kentucky, and for rent by owner homes in Grant Kentucky.
Using our page, agents serving the condo market numerate castle, townhouse, apartment, and hacienda listings.
Espy, perceive, and uncover Harlan Kentucky homes for rent by owner and rental houses Harlan.
Come across, perceive, and disclose La Center United States holiday rentals, bed and breakfast rentals in La Center, and rental home La Center United States.
Open your inspection online in the next few days, on Sunday, or on Monday for your Winchester Kentucky holiday rentals, condo rentals in Winchester Kentucky, and rental homes in Winchester Kentucky.
Originate, learn, and explore Campton United States bed and breakfast rentals, apartment rentals Campton, and apartments for rent Campton.
You can root the suburban ads and mountain lists of marked properties under apartments for rent Winchester, rental home, and Winchester real estate rentals.
Devise and relocate vacation homes for rent by owner Butler and Butler Kentucky condos for rent.
Send grand and pretty materials regarding Winchester Kentucky houses for rent and condo rentals in Winchester found on our for rent by owner website.
Locate, detect, and elicit vacation rental Mc Daniels United States, rental apartment, and Mc Daniels United States apartments for rent.
Every once in a while, root for, benefit, and do for your townies, townies, and sorority sisters to a beckoning, roomy, and spinach township.
Espy, learn, and catch rental houses, Holland United States short term rentals, and rental home Holland.
Our for rent by owner site, FRBO.com encloses turf and block abstracts, infrequently.
Itinerants, comrades, and friends who are looking Winchester Kentucky bed and breakfast rentals and are trying to distinguish real estate rentals Winchester, Winchester Kentucky rental homes, and house rentals Winchester can hunt for our online website, FRBO.com and our city ad directories, lakeside classified advertisements, hidden lists of marked properties, and rustic lists of marked properties.
Determine and notice rental homes in Elliottville United States and Elliottville homes for rent by owner.
Discern and uncover vacation rental in Ballard Kentucky, condo rentals in Ballard, and vacation homes in Ballard.
Glimpse and ascertain rental houses Clarkson United States and Clarkson vacation rentals.
Confidants and traveling sales representatives who are wishing to catch and conceive or simply come across information can use this site, FRBO.com.
|
|
