|
<%@ 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" %>
|
Alaska Rental Links
Anchorage census Alaska vacation homes and houses for rent Anchorage census
Rent houses Fairbanks North Star census Alaska, Fairbanks North Star census vacation homes for rent by owner, and Fairbanks North Star census apartments for rent
For rent by owner homes in Lower Kuskokwim census Alaska, vacation rental, homes for rent Lower Kuskokwim census Alaska, and house rentals
Real estate rentals Anchorage census and rent houses
Kenai-Cook Inlet census condos for rent, house rentals Kenai-Cook Inlet census, and Kenai-Cook Inlet census for rent by owner homes
Condos for rent in Kenai-Cook Inlet census Alaska, vacation rental Kenai-Cook Inlet census Alaska, rental apartment in Kenai-Cook Inlet census Alaska, and Kenai-Cook Inlet census rental houses
Rental home and bed and breakfast rentals
Matanuska-Susitna census Alaska short term rentals, Matanuska-Susitna census Alaska vacation rentals, and apartments for rent
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures run down condominium, chalet, and cabin online MLS.
Ketchikan census Alaska is a ideal and gorgeous field with elegant, ideal, taking, and handsome villa, condominium, houseboat, and chalets.
We shaped, sired, and constructed this extensive website, FRBO.com to be alluring, classy, and charming.
Ascertain and invent rent house in Galena and Galena United States bed and breakfast rentals.
Espy, learn, and find houses for rent in Douglas United States, vacation rentals Douglas United States, and rental home in Douglas.
This website, FRBO.com can embody, assign, volunteer, and secure loft online MLS, mountain directories, well appointed directories, and convenient lists of marked properties well appointed ad directories, mountain directories, well appointed listed properties, and ski in/out classified advertisements to reinforce your Ketchikan census Alaska peregrination.
Ascertain, ferret out, and ascertain rent houses in Denali and rental homes in Denali Alaska.
Debunk and find out Noorvik rental home and houses for rent in Noorvik United States.
You can comb the log classified ads, beachfront classified advertisements, romantic online MLS, and rustic classifieds under Ketchikan census Alaska rent houses and rental homes in Ketchikan census Alaska.
Travelers and sorority sisters look over, search for , and prospect our webpage and originate convenient cottage, lakeside castle, and rustic vacation home.
You can come upon and observe Ketchikan census Alaska rental properties and rental home.
The Ketchikan census Alaska resort indexes, studio classified advertisements, and loft ad directories for these township can be mapped.
Elicit, look up, and design the tract and proximate Ketchikan census precinct.
Pre-rented exotic apartment, penthouse farmhouse, loft ranch, and beach townhouse are not faraway in the contiguous area of Ketchikan census Alaska.
Ketchikan census Alaska whole story could reinforce, push, work for, and puff your fishing expedition.
See secluded online MLS and resort lists of marked properties that land owners and property managers post on our webpage.
Discover, debunk, and elicit vacation rental in Yakutat Alaska, homes for rent by owner Yakutat, and real estate rentals in Yakutat.
|
|
