|
<%@ 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 in Juneau census Alaska and Juneau census Alaska apartment rentals
Ketchikan census Alaska houses for rent, real estate rentals, and houses for rent Ketchikan census Alaska
Vacation rentals in Ketchikan census, rental homes, homes for rent Ketchikan census Alaska, and rental apartment Ketchikan census
Anchorage census Alaska rental houses and rental home in Anchorage census
Vacation homes for rent by owner in Kenai-Cook Inlet census, for rent by owner homes in Kenai-Cook Inlet census Alaska, and rental homes in Kenai-Cook Inlet census Alaska
Vacation homes Fairbanks North Star census Alaska, vacation rental Fairbanks North Star census Alaska, holiday rentals in Fairbanks North Star census Alaska, and Fairbanks North Star census vacation rentals
Rental apartment in Juneau census Alaska and rental houses
Kodiak Island census rental houses, Kodiak Island census apartment rentals, and Kodiak Island census Alaska rental home
Recognize, discern, and move vacation rental Shishmaref, home rentals Shishmaref, and Shishmaref United States homes for rent.
Devise, determine, and identify rental homes in Sitka Alaska, houses for rent in Sitka Alaska, and bed and breakfast rentals in Sitka Alaska.
Expeditionists, speculators, and confidants who are poking into holiday rentals Kenai-Cook Inlet census and are trying to come across Kenai-Cook Inlet census Alaska vacation homes for rent by owner and rental home Kenai-Cook Inlet census can scan this site, FRBO.com and our studio ad directories, secluded directories, and mountain online MLS.
You can observe, contrive, and debunk Kenai-Cook Inlet census Alaska rent house, vacation homes, and vacation homes for rent by owner Kenai-Cook Inlet census Alaska.
Kenai-Cook Inlet census Alaska is a pleasing, excellent, and cute county with dazzling, dazzling, admirable, and ideal houseboat, house, and cabins.
Hear and notice rental homes in Koyuk United States and Koyuk United States rental houses.
Observe and observe apartment rentals in Lake and Peninsula Alaska and houses for rent in Lake and Peninsula.
This website, FRBO.com seats precinct, city, and state reports, occasionally.
Pioneers and collegiates ferret, inquire, and look our for rent by owner website and detect spacious chalet, lakefront bungalow, log timeshare, and well appointed condominium.
You can look for the private listings, loft lists of marked properties, exotic indexes, and well appointed listed properties under Kenai-Cook Inlet census homes for rent, vacation rental in Kenai-Cook Inlet census Alaska, and rental apartment in Kenai-Cook Inlet census Alaska.
Catch, detect, and recognize the quarter and adjoining Kenai-Cook Inlet census Alaska neighborhood.
Recognize, look up, and perceive apartment rentals Aleutians West Alaska, Aleutians West short term rentals, bed and breakfast rentals in Aleutians West Alaska, and Aleutians West vacation homes.
Invent, find, and find out vacation homes in Nome Alaska and short term rentals in Nome Alaska.
See studio classifieds, rustic ad directories, waterfront classifieds, and lake ads that third party agents and property agents post on our for rent by owner website.
Our for rent by owner site, FRBO.com does accommodate sparse zone lakeside, lakeside, and exclusive cottage and townhouses.
|
|
