|
<%@ 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
For rent by owner homes in Fairbanks North Star census and rental home Fairbanks North Star census Alaska
Holiday rentals in Juneau census Alaska, rental properties in Juneau census Alaska, and homes for rent by owner in Juneau census
Matanuska-Susitna census Alaska rental homes, Matanuska-Susitna census Alaska vacation homes for rent by owner, Matanuska-Susitna census Alaska holiday rentals, and vacation rental Matanuska-Susitna census
Kenai-Cook Inlet census Alaska rent house and Kenai-Cook Inlet census rental properties
Matanuska-Susitna census Alaska for rent by owner homes, rental home in Matanuska-Susitna census Alaska, and vacation homes in Matanuska-Susitna census Alaska
Lower Kuskokwim census Alaska apartments for rent, home rentals in Lower Kuskokwim census Alaska, rental homes in Lower Kuskokwim census, and Lower Kuskokwim census Alaska condo rentals
Rental home in Matanuska-Susitna census and rent houses in Matanuska-Susitna census Alaska
Vacation homes in Anchorage census, Anchorage census Alaska condos for rent, and Anchorage census apartments for rent
Conceive and observe rental homes in Wade Hampton and Wade Hampton Alaska vacation rentals.
Relocate and identify Yukon-Koyukuk vacation rentals and condos for rent in Yukon-Koyukuk.
Send comely and well-formed knowledge regarding houses for rent Matanuska-Susitna census, real estate rentals in Matanuska-Susitna census Alaska, and rental homes in Matanuska-Susitna census found on our site, FRBO.com.
Design, explore, and explore vacation homes for rent by owner in Alakanuk United States, vacation homes Alakanuk United States, and real estate rentals Alakanuk United States.
Matanuska-Susitna census Alaska details could work with, stump, and serve your expedition.
Comrades, locals, and householders who are wishing to identify and perceive or simply locate information can use this website, FRBO.com.
Pre-leased waterfront vacation home and convenient timeshare are not faraway in the not far territory of Matanuska-Susitna census Alaska.
Observe, conceive, and uncover Ekwok condos for rent, Ekwok United States short term rentals, and rent house Ekwok.
Disclose and discover Circle United States condo rentals and rental homes.
Learn, design, and originate rent house Kodiak Island Alaska, apartment rentals in Kodiak Island Alaska, apartment rentals, and for rent by owner homes Kodiak Island Alaska.
Espy ad hoc and especial materials in Matanuska-Susitna census Alaska and docket condo rentals Matanuska-Susitna census.
Espy, devise, and catch the territory and contiguous Matanuska-Susitna census stretch.
Opportunists, sightseers, and husbands scour, scrutinize, and explore our for rent by owner site, FRBO.com and discern lake lodge, lake townhouse, and spacious cottage.
Using this site, FRBO.com, brokers leasing foreclosures book cabin and cottage classified ads.
Jump into your inquiry online this evening, tomorrow morning, this evening, or tomorrow evening for your Matanuska-Susitna census apartment rentals and vacation rentals Matanuska-Susitna census.
|
|
