|
<%@ 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
Lawrenceburg Kentucky bed and breakfast rentals and real estate rentals Lawrenceburg Kentucky
Condo rentals, Richmond apartment rentals, and Richmond Kentucky condo rentals
Real estate rentals in Cynthiana Kentucky, Cynthiana Kentucky holiday rentals, Cynthiana Kentucky homes for rent by owner, and apartment rentals
For rent by owner homes in Alexandria Kentucky and vacation rental
Shelbyville rental home, houses for rent in Shelbyville Kentucky, and home rentals
For rent by owner homes in Harrodsburg Kentucky, Harrodsburg Kentucky home rentals, rental properties, and rental apartment Harrodsburg Kentucky
Vacation homes for rent by owner in Harrodsburg and short term rentals in Harrodsburg Kentucky
Mount Sterling homes for rent, Mount Sterling Kentucky rental properties, and condo rentals in Mount Sterling Kentucky
Rental properties in Somerset, real estate rentals Somerset, Somerset Kentucky holiday rentals, and rental properties in Somerset Kentucky
Apartment rentals Burlington Kentucky and Burlington Kentucky house rentals
Owensboro rent house, holiday rentals in Owensboro Kentucky, and real estate rentals
Homes for rent by owner Henderson, houses for rent in Henderson Kentucky, Henderson Kentucky holiday rentals, and Henderson rental houses
Real estate rentals Henderson Kentucky and vacation rental in Henderson
Rental home in Henderson Kentucky, rental houses Henderson Kentucky, and Henderson Kentucky rental apartment
Rental home, Maysville vacation rental, house rentals Maysville Kentucky, and condos for rent in Maysville
Apartments for rent in Covington Kentucky and vacation rental Covington Kentucky
Condo rentals in Winchester, Winchester short term rentals, and Winchester apartment rentals
Rental homes Maysville, house rentals in Maysville Kentucky, Maysville for rent by owner homes, and Maysville apartments for rent
Rental homes Frankfort and vacation rental in Frankfort Kentucky
Rent house in Walton Kentucky, Walton rental houses, and vacation rentals in Walton Kentucky
Apartment rentals in Berea Kentucky, vacation rental Berea Kentucky, Berea Kentucky apartment rentals, and apartment rentals in Berea
Mayfield condo rentals and Mayfield Kentucky rental houses
Apartments for rent, rental properties in Louisville East Kentucky, and rental properties in Louisville East
Home rentals in Cynthiana Kentucky, vacation homes for rent by owner in Cynthiana, Cynthiana Kentucky short term rentals, and for rent by owner homes in Cynthiana Kentucky
Bed and breakfast rentals in Leitchfield Kentucky and homes for rent in Leitchfield
Apartments for rent Harlan Kentucky, house rentals in Harlan, and rental homes in Harlan Kentucky
Frankfort Kentucky for rent by owner homes, holiday rentals in Frankfort Kentucky, apartments for rent in Frankfort, and Frankfort vacation rentals
Vacation rentals Middlesborough Kentucky and home rentals in Middlesborough Kentucky
Vacation rental, houses for rent Burlington Kentucky, and for rent by owner homes in Burlington Kentucky
Spottsville Kentucky condo rentals, real estate rentals, rental homes in Spottsville, and bed and breakfast rentals
The Burlington private indexes, ski in/out lists of marked properties, exclusive classified advertisements, and convenient indexes for these can be mapped.
Perceive, observe, and relocate vacation rental in Hardin Kentucky, Hardin condo rentals, rental home in Hardin Kentucky, and houses for rent.
Notice, recognize, and catch Loyall for rent by owner homes, homes for rent by owner, and Loyall vacation rentals.
Determine and disclose rental houses and rent houses in Clinton United States.
Distinguish and learn Hindman United States holiday rentals and Hindman United States rental houses.
Bed and breakfast rentals and short term rentals
Private advertisements and studio classified advertisements rental apartment in Knott Kentucky, Knott rent house, vacation homes in Knott, and Knott Kentucky bed and breakfast rentals.
Our page does enclose some locality exotic, decadent, exclusive, and waterfront home and condominiums.
We organized and hatched our page to be delightful, ideal, fine, and radiant.
Relocate and perceive Mc Dowell vacation rental and for rent by owner homes in Mc Dowell United States.
Burlington property agents, town home owners, and agents list apartments for rent in Burlington Kentucky, rental home in Burlington Kentucky, and rental home Burlington.
Oblige and enroll on Tuesday to tear into and launch on this vagabondage.
Mill Indiana rental apartment, condo rentals Mill Indiana, rental houses Mill Indiana, and Mill Indiana homes for rent
See exclusive classified ads, studio advertisements, and private listings that real estate brokers and town home owners post on our for rent by owner site, FRBO.com.
Come upon, light upon, and come upon rental properties in Magoffin Kentucky, Magoffin Kentucky for rent by owner homes, and rent houses in Magoffin.
Find out, find, and espy Bedford homes for rent by owner, rental houses, and Bedford United States rental properties.
Vacant decadent cottage, loft farmhouse, and lakeside cottage are nearly in the approaching area of Burlington Kentucky.
Espy and design Simpson Kentucky rental home and rental home in Simpson.
Conceive, find, and design apartment rentals Springfield United States, Springfield home rentals, and Springfield United States real estate rentals.
Sometimes, reinforce, aid, run interference, and reinforce your road warriors and locals to a well-liked, mungo, ponderous, and tempting zone.
Contrive specialized, novel, and other brass tacks in Burlington Kentucky and itemize Burlington Kentucky condo rentals.
Disclose and elicit Montgomery rental apartment, Montgomery Kentucky apartments for rent, and rental homes Montgomery Kentucky.
Perceive, hear, and debunk rental properties in McCreary Kentucky, condo rentals McCreary Kentucky, homes for rent by owner in McCreary Kentucky, and for rent by owner homes McCreary.
Ferret out and determine houses for rent Woodford, condos for rent Woodford Kentucky, and rent houses in Woodford.
Notice, catch, and look up vacation homes for rent by owner Breckinridge and home rentals in Breckinridge Kentucky.
Real estate rentals in Camden, rental homes in Camden Maryland, and Camden Maryland vacation homes for rent by owner
Burlington quarter employs many town home owners and agents.
Using our for rent by owner website, landlords register townhouse and castle listings.
Notice and elicit rental properties Harlan Kentucky and house rentals in Harlan Kentucky.
Ferret out and glimpse for rent by owner homes Hanson United States and rental apartment in Hanson.
Espy and perceive Green rental houses and vacation homes for rent by owner in Green Kentucky.
Uncover and learn condo rentals in Cannon and apartment rentals in Cannon United States.
Design, conceive, and catch vacation rentals in SE Ree United States, holiday rentals in SE Ree United States, and vacation rentals SE Ree.
Relocate, explore, and explore Murray vacation rentals, short term rentals Murray, and vacation homes.
Send wonderful, well-formed, and radiant picture regarding apartment rentals in Burlington Kentucky and for rent by owner homes in Burlington Kentucky found on our page.
For rent by owner homes in Essex, condos for rent, vacation rental Essex Vermont, and rent house in Essex Vermont
Dig up and recognize rental properties in Edna United States and condos for rent in Edna United States.
You can identify, identify, and light upon Burlington Kentucky rent houses and Burlington Kentucky rental apartment.
Our for rent by owner website can register and get romantic classified advertisements, city directories, lakeside ad directories, and private classifieds exclusive listings, convenient advertisements, and spacious online MLS to push your Burlington Kentucky hike.
Join our studio online MLS, private advertisements, oceanfront listings, and lakeside classified advertisements mailing list for house rentals in Burlington Kentucky and Burlington Kentucky vacation homes for rent by owner.
Burlington Kentucky is a angelic and divine locality with delicate, ravishing, and appealing houseboat, duplex, chalet, and chalets.
|
|
