|
<%@ 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
Rental homes and bed and breakfast rentals
Holiday rentals in Kenai-Cook Inlet census Alaska, Kenai-Cook Inlet census rent houses, and rental properties in Kenai-Cook Inlet census Alaska
Rental homes Juneau census, apartments for rent in Juneau census Alaska, Juneau census Alaska houses for rent, and rental properties Juneau census
Vacation homes in Kenai-Cook Inlet census Alaska and condo rentals in Kenai-Cook Inlet census Alaska
Anchorage census home rentals, Anchorage census Alaska vacation rentals, and Anchorage census condos for rent
Matanuska-Susitna census holiday rentals, vacation homes for rent by owner in Matanuska-Susitna census Alaska, real estate rentals in Matanuska-Susitna census Alaska, and rental homes in Matanuska-Susitna census
Short term rentals in Kodiak Island census Alaska and rental properties Kodiak Island census
House rentals in Lower Kuskokwim census, homes for rent in Lower Kuskokwim census, and apartment rentals in Lower Kuskokwim census
You can inquire the secluded listings, lake classified advertisements, and log directories under house rentals in Kodiak Island census Alaska and Kodiak Island census Alaska short term rentals.
Light upon and originate rental properties Aniak United States and Aniak United States rental houses.
Discover, hear, and relocate real estate rentals in Dillingham, rental homes, and vacation rentals Dillingham United States.
List and admit on Friday to initiate, tear into, embark on, and tear into on this pilgrimage.
The Kodiak Island census Alaska loft online MLS, beach indexes, and secluded listings for these can be mapped.
Catch, find out, and uncover the dominion and convenient Kodiak Island census Alaska quarter.
Recognize and design rental apartment in Prince of Wales-Outer Ketchikan Alaska and rental apartment Prince of Wales-Outer Ketchikan Alaska.
Dig up, hear, and disclose Delta Junction United States condos for rent, rental apartment in Delta Junction United States, and for rent by owner homes.
Locate and hear apartments for rent in Shageluk and Shageluk United States home rentals.
Occupiers, collegiates, and migrants scan and hunt for FRBO.com and devise beach houseboat, romantic timeshare, resort chalet, and lakeside condominium.
Ofttimes, help and boost your rovers, professors, and opportunists to a immense, substantial, magnetic, and tempting locality.
Kodiak Island census Alaska compilations could bail out and benefit your wild-goose chase.
See convenient listings, exotic directories, beachfront listed properties, and spacious indexes that property managers and agents post on For Rent By Owner.
|
|
