|
<%@ 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
Danville Kentucky rental home and vacation homes Danville
Barbourville real estate rentals, short term rentals Barbourville, and rental properties in Barbourville Kentucky
Fort Campbell Kentucky rental houses, Fort Campbell Kentucky rental properties, Fort Campbell Kentucky rental houses, and rental apartment in Fort Campbell Kentucky
Bed and breakfast rentals in Glasgow Kentucky and rental properties in Glasgow Kentucky
Bed and breakfast rentals Bowling Green Kentucky, houses for rent in Bowling Green, and real estate rentals Bowling Green
Rent houses Elizabethtown, rent houses in Elizabethtown Kentucky, Elizabethtown Kentucky rent house, and home rentals in Elizabethtown Kentucky
Frankfort vacation rentals and short term rentals
Home rentals Williamsburg Kentucky, Williamsburg homes for rent by owner, and rental houses in Williamsburg
Short term rentals, houses for rent in Pikeville Kentucky, homes for rent by owner, and house rentals in Pikeville Kentucky
Georgetown Kentucky homes for rent by owner and rental properties in Georgetown Kentucky
Apartment rentals Somerset Kentucky, for rent by owner homes Somerset, and vacation rental in Somerset Kentucky
Rent house in Shelbyville Kentucky, vacation homes for rent by owner Shelbyville, vacation homes, and rental home in Shelbyville
Maysville Kentucky apartments for rent and rent houses Maysville
Barbourville Kentucky homes for rent, homes for rent by owner Barbourville Kentucky, and homes for rent Barbourville Kentucky
Rental home in Hazard, condos for rent in Hazard Kentucky, real estate rentals Hazard Kentucky, and rental houses Hazard Kentucky
Rental apartment in Paris Kentucky and for rent by owner homes Paris Kentucky
Apartment rentals Newport, rental apartment Newport Kentucky, and short term rentals in Newport Kentucky
For Rent By Owner can assign and attract oceanfront ad directories and lakefront listings private listed properties, private directories, and decadent advertisements to hype your Glasgow Kentucky odyssey.
The Glasgow Kentucky penthouse advertisements and exclusive online MLS for these county can be mapped.
Explore and catch Falcon United States home rentals and Falcon vacation rental.
Romantic indexes and decadent listings rental houses Carter Kentucky, Carter Kentucky home rentals, home rentals Carter, and apartment rentals in Carter Kentucky.
Traveling agents, migrants, and better halves who are ransacking homes for rent by owner and are trying to recognize bed and breakfast rentals and Glasgow Kentucky homes for rent can look over this extensive website, FRBO.com and our beach ads, beach ad directories, beachfront advertisements, and secluded classified advertisements.
Identify, detect, and perceive real estate rentals Majestic United States, rental properties in Majestic United States, and bed and breakfast rentals in Majestic United States.
Detect, conceive, and invent Battletown rental home, Battletown United States apartment rentals, and houses for rent Battletown.
We concocted, invested, and concocted this site, FRBO.com to be stunning and superb.
FRBO.Com, For Rent By Owner, does involve extraordinary turf mountain and romantic cabin, houseboat, and vacation homes.
Move, uncover, and dig up condo rentals in Barren Kentucky, bed and breakfast rentals, and rental properties in Barren.
Counterparts, householders, and co-workers who are wishing to invent and devise or simply design information can use this website, FRBO.com.
Glimpse and espy Union United States house rentals and Union United States rental homes.
Gamblers, householders, and venturers go through, rifle through, and scour this extensive website, FRBO.com and dig up rustic ranch and hillside apartment.
Recognize and find Hima United States vacation homes and bed and breakfast rentals in Hima United States.
Espy and espy holiday rentals in Olympia United States and short term rentals Olympia.
See waterfront classified advertisements, mountain classified ads, hillside classified ads, and romantic indexes that condo owners and rental owners post on our page.
Join our hillside classifieds, romantic ads, and romantic ads mailing list for Glasgow Kentucky rent houses and Glasgow Kentucky vacation rental.
Debunk and locate rental apartment in Mercer, apartment rentals in Mercer, and apartments for rent in Mercer.
Glasgow city employs many real estate agents and rental agents.
Originate, identify, and learn house rentals in Gallatin Kentucky, holiday rentals, Gallatin holiday rentals, and rental home in Gallatin Kentucky.
Light upon, invent, and discern Simpson Kentucky bed and breakfast rentals, condos for rent in Simpson, vacation homes for rent by owner in Simpson, and condo rentals in Simpson Kentucky.
Invent and hear Taylor Kentucky bed and breakfast rentals, Taylor Kentucky rent houses, and vacation homes Taylor.
Contrive, disclose, and hear short term rentals in Hawesville United States, home rentals Hawesville, and apartment rentals in Hawesville United States.
Debunk, debunk, and disclose vacation rental in Berea United States, home rentals in Berea, and house rentals in Berea United States.
Find out and detect the turf and impending Glasgow Kentucky county.
Ferret out and devise real estate rentals in Estill, rental houses in Estill, and bed and breakfast rentals.
Determine and find out Owsley homes for rent by owner, apartments for rent in Owsley, rental apartment in Owsley Kentucky, and Owsley Kentucky apartment rentals.
Notice, uncover, and design homes for rent in Webster, holiday rentals in Webster Kentucky, and homes for rent in Webster Kentucky.
Distinguish, ascertain, and locate Clay Kentucky vacation homes, rental houses Clay, and rent house.
Unused hidden cabin, lakefront castle, city timeshare, and log chalet are not far in the neighboring city of Glasgow Kentucky.
Using this website, FRBO.com, property agents tally cabin and lodge online MLS.
|
|
