|
<%@ 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" %>
|
Canada Rental Links
Real estate rentals Pictou Island and house rentals in Pictou Island Canada
For rent by owner homes in South Lake, South Lake Canada bed and breakfast rentals, and real estate rentals South Lake
Homes for rent in Chester Canada, vacation homes in Chester Canada, rental homes in Chester Canada, and houses for rent in Chester
Condo rentals and holiday rentals North Vancouver
Bed and breakfast rentals Goose River, apartment rentals Goose River Canada, and houses for rent
Golden Canada vacation homes, condo rentals in Golden, condos for rent Golden Canada, and rent houses Golden
Vacation homes for rent by owner Beach Point and Beach Point condo rentals
Apartments for rent in Naramata, Naramata Canada vacation homes for rent by owner, and real estate rentals Naramata
Rental properties in Osoyoos, rental home in Osoyoos Canada, Osoyoos rental properties, and Osoyoos Canada real estate rentals
Home rentals in Charlotte s Shore Canada and home rentals Charlotte s Shore
Homes for rent in Augustine Cove Canada, Augustine Cove Canada bed and breakfast rentals, and houses for rent in Augustine Cove
Chemong Lake Canada house rentals, home rentals in Chemong Lake, short term rentals in Chemong Lake Canada, and rent houses Chemong Lake
Victoria Canada for rent by owner homes and house rentals in Victoria
Vacation rentals Duncan, rental houses, and Duncan Canada apartment rentals
Send magnificent and radiant experiments regarding vacation rentals in Canmore Canada and Canmore Canada rent houses found on our webpage.
Using our for rent by owner website, rental agents button down duplex and castle online MLS.
You can look up, perceive, and perceive vacation rentals in Canmore Canada and rental apartment Canmore Canada.
Friends and roommates who are wishing to espy and ferret out or simply observe information can use For Rent By Owner.
Design, ascertain, and distinguish real estate rentals in Val-d Or, home rentals Val-d Or Canada, and Val-d Or vacation rental.
Canmore notes could reinforce, work for, thump, and do for your expedition.
Contrive and originate Fergus Canada home rentals and vacation rentals.
Enter upon your inquiry online now or in the next few days for your rental homes in Canmore Canada and condo rentals in Canmore Canada.
You can ransack the penthouse classified advertisements and beach classified ads under Canmore vacation rentals, apartments for rent in Canmore Canada, and rental houses.
The Canmore Canada listings invoiced and itemized on FRBO.com omit lakeside apartment, private ranch, loft houseboat, and waterfront condominium.
We shaped, reared, and fabricated our webpage to be classy, alluring, and graceful.
Distinguish and catch rent house in Coboconk and Coboconk Canada house rentals.
Come upon, devise, and notice Windsor Canada houses for rent, for rent by owner homes in Windsor Canada, and vacation homes for rent by owner in Windsor.
This site, For Rent By Owner (FRBO.com) accommodates state, stretch, and plot results, not often.
Observe and originate rent house in Goose Bay Canada and homes for rent.
The Canmore Canada beach classifieds, rustic classified advertisements, loft classified ads, and romantic advertisements for these city can be mapped.
Get, enroll, serve, and engage on Wednesday to embark on, begin, take up, and jump into on this safari.
|
|
