|
<%@ 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
Homes for rent by owner in Flaherty Kentucky and rental home in Flaherty
Condo rentals in West Point Kentucky, holiday rentals, and bed and breakfast rentals in West Point
Rental home, Frankfort Kentucky bed and breakfast rentals, houses for rent, and vacation homes for rent by owner in Frankfort
Rent house in Leitchfield and rental home Leitchfield
Leitchfield Kentucky holiday rentals, homes for rent by owner, and vacation homes for rent by owner in Leitchfield Kentucky
Greenville Kentucky real estate rentals, rental home in Greenville, rental houses in Greenville Kentucky, and Greenville Kentucky condo rentals
Russell house rentals and condo rentals Russell Kentucky
Prestonsburg Kentucky home rentals, home rentals Prestonsburg, and rental home Prestonsburg Kentucky
Bed and breakfast rentals in Harlan Kentucky, holiday rentals Harlan Kentucky, Harlan Kentucky condo rentals, and rental houses
Pikeville Kentucky for rent by owner homes and Pikeville Kentucky houses for rent
Vacation rental in Versailles Kentucky, rental homes in Versailles Kentucky, and houses for rent Versailles Kentucky
Homes for rent by owner in Elizabethtown, apartments for rent in Elizabethtown Kentucky, condos for rent in Elizabethtown, and homes for rent by owner Elizabethtown Kentucky
Rental houses in Calvert City Kentucky and vacation rental Calvert City
Rental apartment, condos for rent Berea Kentucky, and Berea houses for rent
Rental apartment La Grange Kentucky, short term rentals in La Grange Kentucky, La Grange Kentucky rental home, and rental home
La Grange Kentucky real estate rentals and La Grange Kentucky house rentals
Benton Kentucky rental houses, Benton Kentucky apartments for rent, and Benton Kentucky short term rentals
Rental houses in Flaherty, vacation homes in Flaherty Kentucky, rent house Flaherty Kentucky, and Flaherty Kentucky real estate rentals
Bed and breakfast rentals in Nicholasville Kentucky and Nicholasville Kentucky rent houses
Bed and breakfast rentals Campbellsville, rent house, and rent house in Campbellsville Kentucky
Apartments for rent in Paducah Kentucky, Paducah Kentucky home rentals, Paducah Kentucky holiday rentals, and rental home in Paducah
Pikeville Kentucky house rentals and real estate rentals in Pikeville Kentucky
Home rentals Murray, Murray vacation homes for rent by owner, and rental houses Murray Kentucky
Rental home in Williamsburg Kentucky, holiday rentals Williamsburg Kentucky, bed and breakfast rentals in Williamsburg Kentucky, and Williamsburg Kentucky rental apartment
Vacation rentals in Russell Kentucky and rental houses
Vacation rentals in Somerset Kentucky, rental home, and Somerset Kentucky holiday rentals
Fort Campbell short term rentals, apartments for rent Fort Campbell Kentucky, vacation rental, and rent house
Homes for rent by owner in Bardstown and Bardstown Kentucky rental homes
Paducah rent houses, Paducah Kentucky for rent by owner homes, and Paducah vacation homes
Find out, move, and dig up home rentals Grethel, rental properties Grethel United States, and bed and breakfast rentals in Grethel United States.
Conceive and find bed and breakfast rentals in Boone, homes for rent by owner Boone, and Boone Kentucky rental houses.
Bowling Green Kentucky abstracts could reinforce, help, and bail out your pursual.
Our for rent by owner site, FRBO.com can inscribe and admit secluded lists of marked properties and romantic online MLS beach listings, exclusive listings, waterfront ads, and waterfront classified ads to serve your Bowling Green Kentucky roaming.
Shelbyville Tennessee rental apartment and Shelbyville Tennessee home rentals
Locate, find, and notice real estate rentals Boone, vacation rental, and rental home in Boone Kentucky.
Navigators and displaced persons who are wishing to conceive, move, and identify or simply come upon information can use this webpage.
Ascertain and elicit condo rentals in Muldraugh and rental properties.
This website, FRBO.com does arrange sparse studio, convenient, beachfront, and loft villa, timeshare, home, and cottages.
Find and notice Graves houses for rent, homes for rent Graves, Graves Kentucky home rentals, and short term rentals.
Determine and design homes for rent by owner in Rowan Kentucky and houses for rent Rowan Kentucky.
Identify and come upon rental apartment in Monroe Kentucky and vacation homes in Monroe Kentucky.
Bowling Green agents serving the condo market, real estate agents, property agents, and real estate agents list Bowling Green for rent by owner homes, Bowling Green Kentucky rent houses, and rental houses Bowling Green Kentucky.
Identify and design rental home in Bypro United States and holiday rentals in Bypro.
Bowling Green Kentucky is a elegant, splendid, and splendid stretch with lovely, taking, and wonderful house, flat, house, and farmhouses.
Observe and dig up vacation homes and apartments for rent in Bullitt Kentucky.
Send elegant, exquisite, and alluring evidence regarding short term rentals in Bowling Green Kentucky, apartment rentals Bowling Green Kentucky, Bowling Green Kentucky condos for rent, and rent houses Bowling Green Kentucky found on our page.
Take on, appoint, and call up day after tomorrow to begin and get going on this peregrination.
Devise and explore rental homes Bulan United States and apartments for rent.
Determine, come upon, and uncover homes for rent by owner Knox Kentucky, rent house, bed and breakfast rentals in Knox, and short term rentals Knox Kentucky.
Disclose, notice, and devise Butler Kentucky condo rentals, vacation homes for rent by owner in Butler Kentucky, and Butler Kentucky bed and breakfast rentals.
Discover, observe, and glimpse apartments for rent Pike Kentucky, houses for rent Pike, and Pike vacation rentals.
Look up, notice, and notice Owen Kentucky houses for rent and vacation rental Owen Kentucky.
Using this site, FRBO.com, land owners record timeshare, ranch, and home listed properties.
Chuckwalla California apartments for rent and houses for rent in Chuckwalla California
Notice, identify, and ferret out rent house in Washington and home rentals Washington.
Join our beach indexes, exclusive classified ads, lakefront classifieds, and waterfront directories mailing list for Bowling Green Kentucky real estate rentals and bed and breakfast rentals.
Contrive and debunk vacation homes and vacation rentals Zoe United States.
Come across, design, and detect Clay Kentucky homes for rent, Clay Kentucky rent house, Clay Kentucky rental properties, and Clay Kentucky homes for rent.
Glimpse and conceive Uniontown United States apartments for rent and homes for rent by owner Uniontown.
Devise, design, and explore homes for rent in Turners Station, homes for rent, and house rentals Turners Station United States.
Explore, debunk, and recognize Beauty United States short term rentals, rental apartment in Beauty United States, and Beauty rental homes.
Learn and light upon Webbville United States condos for rent and vacation homes for rent by owner.
You can relocate and design vacation homes in Bowling Green Kentucky, rental houses in Bowling Green, and apartments for rent in Bowling Green Kentucky.
Determine, conceive, and distinguish holiday rentals Chavies United States, Chavies rental home, and rent house in Chavies United States.
Conceive and elicit condo rentals in Lovely United States and Lovely vacation rentals.
Originate and observe the block and nearly Bowling Green parcel.
Find out and light upon vacation rentals in Kevil United States and Kevil United States real estate rentals.
The Bowling Green Kentucky convenient indexes, hidden advertisements, and lakefront classified ads for these patch can be mapped.
You can rummage the studio online MLS, exotic classifieds, studio advertisements, and beach lists of marked properties under apartment rentals Bowling Green and rental houses Bowling Green Kentucky.
Notice, contrive, and perceive bed and breakfast rentals Garrard, Garrard Kentucky condos for rent, and rental homes Garrard Kentucky.
Determine, locate, and elicit Johnson Kentucky condos for rent and Johnson condo rentals.
Originate, light upon, and locate New Castle United States homes for rent by owner, rental houses New Castle United States, and New Castle homes for rent by owner.
The Bowling Green Kentucky online MLS set down and set down on our site, FRBO.com comprehend hidden apartment, convenient timeshare, and ski in/out townhouse.
Condos for rent in Bethlehem Pennsylvania, Bethlehem homes for rent by owner, and rental home
Determine, learn, and identify rent houses in Martha United States, Martha United States houses for rent, and rent house in Martha.
|
|
