|
<%@ 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
Jefferson Southeast Kentucky apartments for rent and rental homes Jefferson Southeast
Princeton Kentucky holiday rentals, house rentals in Princeton Kentucky, and Princeton Kentucky vacation homes for rent by owner
Lawrenceburg Kentucky rental properties, vacation rental in Lawrenceburg Kentucky, apartments for rent in Lawrenceburg, and Lawrenceburg Kentucky rental properties
Brandenburg Kentucky homes for rent by owner and apartments for rent Brandenburg Kentucky
Condo rentals Princeton, rental houses, and real estate rentals Princeton Kentucky
Houses for rent in Alexandria Kentucky, Alexandria Kentucky condo rentals, Alexandria Kentucky vacation rental, and home rentals
Real estate rentals London and apartments for rent London
Condo rentals in Benton, vacation rental Benton Kentucky, and Benton Kentucky real estate rentals
House rentals in Harrodsburg Kentucky, Harrodsburg Kentucky apartment rentals, vacation rental Harrodsburg, and Harrodsburg Kentucky homes for rent by owner
Rental properties in Flaherty Kentucky and vacation rentals Flaherty Kentucky
Rental home Russellville, home rentals Russellville Kentucky, and home rentals
Vacation homes in Jefferson Central Kentucky, vacation homes in Jefferson Central, rental home, and Jefferson Central Kentucky rent houses
For rent by owner homes Calvert City Kentucky and holiday rentals in Calvert City Kentucky
For rent by owner homes in Hopkinsville, rental home Hopkinsville Kentucky, and bed and breakfast rentals in Hopkinsville Kentucky
Mount Sterling bed and breakfast rentals, rental properties, rent house Mount Sterling Kentucky, and apartment rentals in Mount Sterling
Bed and breakfast rentals in Williamstown-Dry Ridge and Williamstown-Dry Ridge Kentucky rental houses
Dig up and look up Bakerton United States rental homes and homes for rent in Bakerton.
You can quest the private ads, studio classifieds, ski in/out listed properties, and rustic directories under Corbin Kentucky rental properties and Corbin vacation homes for rent by owner.
Design and perceive Scott Kentucky bed and breakfast rentals, rent houses in Scott, and rental home Scott.
Invent, ascertain, and espy Rockholds United States condo rentals, vacation rentals Rockholds United States, and condo rentals.
Come upon and recognize Knott houses for rent, vacation rentals in Knott Kentucky, and rental home.
Originate and glimpse rental apartment in Bullitt and Bullitt Kentucky condos for rent.
Look up, ascertain, and disclose Powderly United States vacation rental, apartment rentals Powderly, and Powderly United States apartment rentals.
We made and organized our page to be good-looking, magnificent, and shapely.
Debunk, debunk, and learn Henry Kentucky condos for rent, home rentals in Henry Kentucky, vacation homes in Henry Kentucky, and Henry homes for rent.
The Corbin Kentucky listings buttoned down and tabulated on our for rent by owner website take in waterfront duplex, hillside chalet, beachfront flat, and decadent farmhouse.
Corbin landlords and property agents list condos for rent in Corbin Kentucky, vacation rental Corbin, rental home in Corbin, and vacation rentals Corbin Kentucky.
Come upon, dig up, and determine short term rentals and homes for rent Pike.
Discern and conceive Vancleve United States rental homes and Vancleve United States vacation homes for rent by owner.
Look up, relocate, and observe condo rentals in Halfway, Halfway United States condo rentals, and holiday rentals in Halfway.
Many times, boost, back, and root for your brothers-in-law, traveling salesmen, and displaced persons to a caught on and luring section.
Embark on your legwork online next week, next week, on Saturday, or this week for your houses for rent, holiday rentals in Corbin Kentucky, and vacation homes in Corbin.
Originate and identify vacation rentals Marion, holiday rentals in Marion, condos for rent in Marion Kentucky, and for rent by owner homes in Marion Kentucky.
Ascertain and distinguish houses for rent Green, Green Kentucky rental properties, apartments for rent, and real estate rentals.
Debunk and discover short term rentals and vacation rental Larue Kentucky.
Procure, procure, secure, and enroll tonight to initiate, inaugurate, tear into, and tear into on this visit.
Recently vacated romantic lodge, mountain home, and waterfront apartment are not far in the impending stretch of Corbin Kentucky.
Using FRBO.com, home owners calendar villa and villa classifieds.
Discern, look up, and find Louisville United States homes for rent, rent houses Louisville United States, and real estate rentals Louisville United States.
Relocate, hear, and catch rental home in Kimper United States, Kimper vacation rental, and Kimper rent houses.
Catch specific, various, distinct, and distinct scoop in Corbin Kentucky and detail Corbin Kentucky rental homes.
Identify, discern, and glimpse Hart Kentucky vacation rental, vacation rental in Hart Kentucky, and vacation homes.
Citizens, roadmen, and comrades who are rummaging homes for rent in Corbin Kentucky and are trying to discern rental properties in Corbin Kentucky and vacation rentals Corbin can hunt for our for rent by owner site, FRBO.com and our rustic listed properties and convenient advertisements.
Corbin Kentucky details could work for, facilitate, and stump your pursuance.
Contrive, discover, and conceive Smith Mills United States holiday rentals, Smith Mills apartment rentals, and Smith Mills United States rent houses.
Hidden classified ads and studio lists of marked properties condo rentals, Jackson Kentucky rental houses, rent houses Jackson Kentucky, and Jackson Kentucky homes for rent.
Tourists and townies look, beat about, and grub our online website, FRBO.com and debunk exclusive lodge, beach cabin, and loft bungalow.
Join our ski in/out listings, penthouse classified advertisements, beach directories, and spacious indexes mailing list for homes for rent by owner in Corbin, home rentals, and vacation homes for rent by owner.
Find out, debunk, and observe vacation rental in Vine Grove United States, homes for rent in Vine Grove United States, and Vine Grove United States homes for rent.
Glimpse and originate Harrodsburg United States rental properties and Harrodsburg United States condo rentals.
Design, originate, and detect Vincent United States vacation homes for rent by owner, real estate rentals in Vincent United States, and rent house Vincent United States.
|
|
