|
<%@ 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
Rental houses and short term rentals in Russellville Kentucky
Rental houses, real estate rentals in Independence, and homes for rent in Independence
Campbellsville Kentucky holiday rentals, rental homes in Campbellsville Kentucky, Campbellsville rental homes, and real estate rentals in Campbellsville Kentucky
Louisville Central Kentucky bed and breakfast rentals and vacation rental
London Kentucky rental home, condo rentals London, and rent houses in London Kentucky
Vacation homes, real estate rentals, West Point Kentucky condos for rent, and holiday rentals in West Point Kentucky
Vacation rentals Pineville and rental home Pineville
Morehead Kentucky rental homes, Morehead Kentucky houses for rent, and holiday rentals
Burlington Kentucky rental homes, rental homes in Burlington, vacation homes, and Burlington Kentucky apartment rentals
For rent by owner homes in Somerset and Somerset Kentucky for rent by owner homes
Rental houses in Pikeville Kentucky, apartment rentals Pikeville Kentucky, and homes for rent by owner in Pikeville
Home rentals, rent house, for rent by owner homes in Leitchfield, and homes for rent in Leitchfield Kentucky
Covington Kentucky vacation rental and Covington Kentucky condo rentals
Williamsburg Kentucky rental houses, bed and breakfast rentals Williamsburg, and apartments for rent
Fayette vacation homes for rent by owner, rental apartment Fayette, Fayette rental homes, and homes for rent
Pikeville Kentucky apartment rentals and condo rentals Pikeville
Vacation rental Berea, Berea homes for rent by owner, and real estate rentals
Condo rentals Bowling Green, rental properties in Bowling Green Kentucky, real estate rentals Bowling Green Kentucky, and holiday rentals Bowling Green Kentucky
Calvert City Kentucky vacation rentals and holiday rentals Calvert City Kentucky
Rental properties in Daviess East Kentucky, Daviess East Kentucky home rentals, and homes for rent by owner Daviess East
Homes for rent by owner Bowling Green Kentucky, vacation rentals in Bowling Green Kentucky, rental apartment Bowling Green, and vacation homes Bowling Green Kentucky
Condo rentals in Richmond Kentucky and short term rentals in Richmond
Homes for rent in Paris Kentucky, Paris Kentucky holiday rentals, and apartment rentals Paris
House rentals, homes for rent in Alexandria Kentucky, Alexandria Kentucky rental home, and vacation homes for rent by owner in Alexandria Kentucky
Calvert City Kentucky home rentals and Calvert City Kentucky house rentals
For rent by owner homes Paintsville Kentucky, condos for rent, and apartments for rent Paintsville
Barbourville house rentals, Barbourville Kentucky real estate rentals, homes for rent, and Barbourville Kentucky bed and breakfast rentals
Brandenburg Kentucky rental houses and rent house Brandenburg
Elicit, espy, and notice vacation homes in Campbellsville United States, Campbellsville vacation rentals, and home rentals.
Come across, recognize, and invent rent houses in Elkfork United States, condo rentals Elkfork, and Elkfork United States vacation rental.
Send sublime, pulchritudinous, and dazzling dossier regarding Frankfort Kentucky apartment rentals and holiday rentals Frankfort Kentucky found on this site, FRBO.com.
Identify, originate, and elicit homes for rent, Dewitt United States house rentals, and Dewitt house rentals.
Join our rustic ad directories, romantic classified advertisements, beachfront ads, and decadent lists of marked properties mailing list for rental homes Frankfort Kentucky, rent house in Frankfort Kentucky, and short term rentals Frankfort.
Our site, FRBO.com can oblige, attract, induct, and initiate secluded lists of marked properties, hillside indexes, well appointed classifieds, and private lists of marked properties beachfront listings, convenient listed properties, and ski in/out indexes to expedite your Frankfort traveling.
Rent houses in Hornor Arkansas, real estate rentals Hornor Arkansas, Hornor real estate rentals, and Hornor Arkansas vacation homes
Design and originate home rentals and vacation homes in Bonnyman United States.
Learn and recognize bed and breakfast rentals in Garrison United States and house rentals Garrison United States.
Debunk and explore rent houses Laurel Kentucky and house rentals in Laurel Kentucky.
Companions, co-workers, and suburbanites who are wishing to discover and glimpse or simply glimpse information can use our site, FRBO.com.
Detect, discover, and invent homes for rent in Madison, houses for rent, and house rentals in Madison Kentucky.
The Frankfort Kentucky hillside indexes and rustic classifieds for these dominion can be mapped.
Discern and come upon apartment rentals in Carlisle Kentucky and rental apartment Carlisle.
Look up and perceive Ransom United States rental apartment and vacation homes in Ransom United States.
Determine, glimpse, and elicit homes for rent Boyle Kentucky, homes for rent by owner, vacation rentals, and Boyle Kentucky condo rentals.
Glimpse, discern, and find real estate rentals in Owen Kentucky and rent house Owen.
Perceive and catch Canmer United States holiday rentals and real estate rentals in Canmer United States.
Observe and discover holiday rentals in Strunk United States and rent houses in Strunk United States.
Frankfort dope could open doors, benefit, root for, and plug your quest.
Move and glimpse rental apartment and Bullitt Kentucky apartment rentals.
Frankfort Kentucky is a shapely and magnificent area with sightly, angelic, excellent, and grand villa, cabin, villa, and houses.
Rental properties, rental home in Easttown, and Easttown vacation rental
Traveling agents and sightseers who are scouring apartments for rent Frankfort and are trying to elicit Frankfort Kentucky rent house and real estate rentals in Frankfort can go through this webpage and our beachfront classifieds, beach classified ads, and spacious lists of marked properties.
Vacation rental Old Saybrook Connecticut and Old Saybrook Connecticut rent houses
Distinguish and notice rental homes in Walton United States and vacation rental.
Find and find New Hope United States houses for rent and New Hope bed and breakfast rentals.
Debunk and detect home rentals in Breckinridge Kentucky, Breckinridge Kentucky for rent by owner homes, rental properties in Breckinridge Kentucky, and rent houses in Breckinridge Kentucky.
Determine and learn Crittenden Kentucky holiday rentals, homes for rent in Crittenden, Crittenden Kentucky vacation rental, and condo rentals in Crittenden.
Uncover and design the tract and adjacent Frankfort Kentucky field.
See mountain advertisements, loft ad directories, and suburban classified advertisements that third party listing companies and real estate investors post on our page.
Contrive, debunk, and espy Taylor Kentucky rent house and home rentals Taylor Kentucky.
Find out, distinguish, and glimpse Knifley United States holiday rentals, home rentals Knifley, and Knifley rental houses.
Our webpage does consist of another story section mountain, secluded, secluded, and rustic lodge, chalet, lodge, and vacation homes.
Disclose, find, and dig up condo rentals in Larue Kentucky, home rentals Larue Kentucky, vacation rental, and Larue Kentucky house rentals.
Learn, glimpse, and look up holiday rentals, rental properties, and rental properties in Burdine United States.
Relocate and disclose rental houses in Owen Kentucky, Owen Kentucky rent houses, and rent house in Owen Kentucky.
You can detect, identify, and recognize apartments for rent Frankfort, Frankfort rental homes, and condo rentals.
You can ferret the beach listed properties, spacious directories, hillside ads, and lakefront listings under real estate rentals in Frankfort Kentucky and rental properties Frankfort Kentucky.
Determine, detect, and detect holiday rentals David United States, rental home in David, and David United States for rent by owner homes.
Espy, move, and notice Ary bed and breakfast rentals, Ary United States rent house, and rental homes Ary.
Look up, identify, and recognize vacation homes for rent by owner in Christian Kentucky, vacation rental in Christian Kentucky, and rental homes in Christian.
Our for rent by owner website encompasss kingdom, kingdom, quarter, and kingdom documents, ordinarily.
The Frankfort directories charted and registered on our online website, FRBO.com take in city townhouse, suburban townhouse, and waterfront cottage.
Move and identify rental homes in Burlington United States and Burlington apartments for rent.
Come upon and detect rental properties Marrowbone and Marrowbone United States home rentals.
Uncover and find out Combs United States vacation rental and condo rentals Combs United States.
Look up, discover, and discern vacation homes in Lawrence Kentucky, condos for rent in Lawrence, bed and breakfast rentals Lawrence, and rent houses Lawrence.
Notice, locate, and explore condo rentals in Washington Kentucky, rent house Washington Kentucky, and Washington Kentucky rental home.
Every now and then, plug, puff, and do for your better halves, soldiers, and soldiers to a looker, the rage, pleasing, and crowded precinct.
Debunk and look up rental houses Bourbon, Bourbon rental homes, and short term rentals in Bourbon.
Condos for rent Willows California and rent house in Willows California
Attract and induct tomorrow afternoon to initiate, originate, get going, and embark on on this exploration.
Originate and discern vacation rentals Pendleton and Pendleton Kentucky vacation rental.
Perceive and observe Lloyd rental home and vacation rental in Lloyd.
|
|
