|
<%@ 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
Apartments for rent Ketchikan census and rental apartment
Bed and breakfast rentals Ketchikan census Alaska, vacation homes for rent by owner in Ketchikan census, and vacation homes for rent by owner in Ketchikan census
Vacation rental Anchorage census, vacation homes for rent by owner Anchorage census, vacation homes for rent by owner in Anchorage census Alaska, and Anchorage census Alaska bed and breakfast rentals
Home rentals in Lower Kuskokwim census Alaska and rent house Lower Kuskokwim census
Vacation homes for rent by owner Lower Kuskokwim census Alaska, apartment rentals in Lower Kuskokwim census, and homes for rent Lower Kuskokwim census Alaska
Rental homes Anchorage census, Anchorage census Alaska rental apartment, Anchorage census for rent by owner homes, and condos for rent in Anchorage census
Rental houses in Ketchikan census Alaska and Ketchikan census apartments for rent
Vacation homes, Matanuska-Susitna census Alaska rental houses, and rent houses in Matanuska-Susitna census
Discover, detect, and espy vacation homes, condo rentals in Wrangell-Petersburg, and Wrangell-Petersburg vacation rentals.
Notice some and peculiar picture in Juneau census Alaska and schedule vacation homes for rent by owner in Juneau census.
The Juneau census advertisements recorded and specialized on FRBO.com comprise exclusive condominium, beach cabin, and decadent duplex.
Muster, serve, list, and place next week to inaugurate, begin, initiate, and begin on this voyage.
The Juneau census studio listed properties and studio indexes for these can be mapped.
Juneau census is a well-formed, delicate, ideal, and foxy section with good-looking, refined, well-formed, and marvelous chalet, apartment, villa, and lodges.
Indwellers and sightseers hunt, seek, and shake down this extensive website, FRBO.com and look up lakeside houseboat, rustic flat, and waterfront houseboat.
Determine and conceive condo rentals Tununak and condo rentals in Tununak United States.
Debunk, contrive, and locate vacation homes in Sleetmute United States, Sleetmute United States vacation homes, and condo rentals in Sleetmute.
Find out and originate short term rentals in Matanuska-Susitna and condos for rent in Matanuska-Susitna Alaska.
Send good-looking and enticing details regarding Juneau census home rentals, home rentals in Juneau census, and Juneau census houses for rent found on For Rent By Owner.
Our online website, FRBO.com comprises precinct, city, tract, and patch statistics, infrequently.
Juneau census section employs many condo owners, brokers leasing foreclosures, and third party agents.
Juneau census property owners, rental owners, property owners, and real estate brokers list house rentals, homes for rent by owner Juneau census Alaska, and condo rentals Juneau census.
Learn, discover, and elicit house rentals in Galena United States, rental home in Galena United States, and Galena United States for rent by owner homes.
Join our rustic advertisements and studio online MLS mailing list for vacation homes Juneau census, for rent by owner homes in Juneau census, and vacation homes for rent by owner Juneau census Alaska.
Catch and espy rental apartment Mekoryuk and homes for rent by owner Mekoryuk United States.
Distinguish and uncover bed and breakfast rentals Southeast Fairbanks and home rentals in Southeast Fairbanks.
You can explore and ferret out Juneau census house rentals, Juneau census Alaska short term rentals, and rent houses in Juneau census Alaska.
|
|
