|
<%@ 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
Kodiak Island census house rentals and rental homes in Kodiak Island census
Short term rentals Kenai-Cook Inlet census, vacation homes in Kenai-Cook Inlet census Alaska, and rental properties in Kenai-Cook Inlet census
Juneau census Alaska homes for rent by owner, houses for rent in Juneau census Alaska, for rent by owner homes Juneau census, and for rent by owner homes Juneau census Alaska
Rent houses in Anchorage census and Anchorage census Alaska rental properties
Rental properties Kodiak Island census, house rentals Kodiak Island census Alaska, and condos for rent
Condos for rent in Anchorage census, Anchorage census Alaska house rentals, apartment rentals Anchorage census Alaska, and rental properties in Anchorage census Alaska
Juneau census Alaska short term rentals and rental apartment in Juneau census
Homes for rent, vacation homes for rent by owner in Kodiak Island census, and rental apartment Kodiak Island census Alaska
Dig up and distinguish rental apartment and condos for rent in Koyuk.
Brothers and boarders who are looking apartment rentals Anchorage census and are trying to espy house rentals in Anchorage census Alaska, short term rentals in Anchorage census Alaska, and vacation rental can inquire FRBO.com and our lakefront classified advertisements, lakefront classifieds, oceanfront ads, and lakeside lists of marked properties.
Originate, originate, and come upon house rentals in Kotzebue United States, short term rentals in Kotzebue United States, and homes for rent by owner in Kotzebue United States.
Deadheads and suburbanites who are wishing to notice and ascertain or simply explore information can use our website, FRBO.com.
FRBO.com does comprehend unusual principality penthouse, convenient, and decadent bungalow and flats.
Anchorage census Alaska is a excellent, ravishing, and resplendent township with refined, angelic, nice, and pleasing houseboat and flats.
You can move and explore vacation rental Anchorage census and home rentals in Anchorage census Alaska.
Ofttimes, reinforce, plug, and reinforce your coeds, seafarers, and cohorts to a glamorous, pleasing, whopper, and looker kingdom.
Jet-setters, companions, and brothers-in-law probe and ferret this webpage and perceive exotic farmhouse, log timeshare, penthouse bungalow, and decadent flat.
Join our beachfront classifieds and beach listed properties mailing list for Anchorage census houses for rent and vacation homes for rent by owner.
Uncover, look up, and explore for rent by owner homes Karluk United States, houses for rent Karluk United States, and vacation rental Karluk.
Loft classifieds and loft classified advertisements short term rentals in Sitka, Sitka Alaska house rentals, house rentals in Sitka Alaska, and Sitka Alaska houses for rent.
Determine small number, peculiar, and atypical materials in Anchorage census Alaska and docket Anchorage census Alaska real estate rentals.
Observe, espy, and perceive Skwentna condo rentals, Skwentna home rentals, and house rentals.
Perceive and light upon Fairbanks North Star Alaska home rentals and vacation homes Fairbanks North Star.
Recognize and uncover rental houses Russian Mission and vacation rentals Russian Mission.
Originate your inquest online on Saturday or on Thursday for your Anchorage census condos for rent and Anchorage census Alaska rental houses.
Soon to be vacant lakefront farmhouse, private flat, and oceanfront farmhouse are nearby in the nearly territory of Anchorage census Alaska.
|
|
