|
<%@ 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
Apartments for rent in Kimberley and bed and breakfast rentals in Kimberley Canada
Short term rentals Pender Islands Canada, rent houses in Pender Islands, and rental home Pender Islands
House rentals Chemong Lake Canada, Chemong Lake Canada holiday rentals, rental houses in Chemong Lake Canada, and Chemong Lake bed and breakfast rentals
Apartments for rent in Lac-Des-Plages and Lac-Des-Plages short term rentals
Sonora Island Canada rental apartment, rental properties in Sonora Island Canada, and holiday rentals in Sonora Island Canada
Sun Peaks Canada rent houses, Sun Peaks Canada home rentals, for rent by owner homes Sun Peaks, and vacation homes for rent by owner in Sun Peaks
Rental apartment Sechelt and Sechelt short term rentals
Tyne Valley vacation homes for rent by owner, home rentals Tyne Valley Canada, and apartments for rent in Tyne Valley Canada
House rentals Whitehorse Canada, for rent by owner homes Whitehorse Canada, holiday rentals in Whitehorse Canada, and Whitehorse rental home
Rent house in Ste Adele Canada and house rentals Ste Adele Canada
Rental houses in Invermere Canada, Invermere Canada rental home, and rental apartment in Invermere Canada
Home rentals Salt Spring Island, Salt Spring Island homes for rent, house rentals in Salt Spring Island Canada, and rental home Salt Spring Island
Salt Spring Island Canada rent house and apartments for rent
Rent houses Bowser, rent houses in Bowser, and vacation homes Bowser Canada
Lac-Superior Canada houses for rent, Lac-Superior Canada houses for rent, Lac-Superior condo rentals, and home rentals Lac-Superior Canada
Rental home in Penetanguishene Canada and Penetanguishene short term rentals
Rental home North Rustico, vacation rental in North Rustico Canada, and North Rustico Canada real estate rentals
Apartments for rent in Chester Canada, Chester vacation rental, vacation homes in Chester Canada, and vacation rental
Vacation homes for rent by owner Whistler Village and Whistler Village vacation homes
Apartments for rent in Mill Bay Canada, holiday rentals Mill Bay, and condos for rent
Haliburton homes for rent, Haliburton Canada homes for rent by owner, Haliburton Canada real estate rentals, and vacation homes for rent by owner
Invermere vacation rental and rent house in Invermere Canada
Traveling agents, educators, and spouses look for, ransack, and go through FRBO.Com, For Rent By Owner, and discern resort apartment, penthouse cabin, decadent bungalow, and resort castle.
We conceived, formulated, and constructed FRBO.Com, For Rent By Owner, to be pleasing and sightly.
Red Mountain Canada vicinity employs many rental agents, home owners, agents serving the condo market, and agents serving the condo market.
Red Mountain Canada whole story could facilitate, relieve, and push your perquisition.
Come across and identify Lively Canada vacation rentals and Lively Canada rental properties.
Perceive, identify, and come across Hearst Canada for rent by owner homes, rental home in Hearst Canada, and Hearst Canada apartments for rent.
The Red Mountain Canada online MLS tabbed and recorded on this site, FRBO.com comprehend loft duplex, rustic houseboat, and mountain flat.
Traveling saleswomen and confidants who are inquiring real estate rentals and are trying to conceive house rentals in Red Mountain Canada, house rentals Red Mountain Canada, and vacation rental Red Mountain Canada can seek this extensive website, FRBO.com and our well appointed directories and private advertisements.
Invent, find, and identify Williams Lake for rent by owner homes, Williams Lake Canada real estate rentals, and for rent by owner homes Williams Lake Canada.
Embark on your pursuance online this weekend or on Monday for your Red Mountain rental apartment and Red Mountain houses for rent.
Red Mountain real estate agents and rental agents list rental houses in Red Mountain Canada and condos for rent Red Mountain Canada.
Find, discover, and identify Legal homes for rent by owner, condo rentals, and Legal Canada homes for rent by owner.
Discern and hear Happy Valley-Goose Bay home rentals and homes for rent by owner Happy Valley-Goose Bay Canada.
Our webpage does comprehend specific square mountain, exclusive, and exclusive castle, townhouse, and duplexs.
Unused mountain home and lake houseboat are imminent in the convenient section of Red Mountain Canada.
Look up, detect, and identify Kincardine Canada homes for rent by owner, holiday rentals Kincardine, and rental houses Kincardine Canada.
Learn and glimpse the tract and adjoining Red Mountain Canada vicinity.
Hear, contrive, and glimpse homes for rent by owner in Abbotsford, home rentals in Abbotsford Canada, and house rentals in Abbotsford Canada.
Discover and debunk holiday rentals Saint Marys Canada and vacation homes in Saint Marys Canada.
Determine and explore Burwash homes for rent and Burwash Canada rent house.
For Rent By Owner comprehends area and locality reports, ordinarily.
Identify and contrive Prince Albert Canada rent house and bed and breakfast rentals in Prince Albert.
The Red Mountain Canada ski in/out online MLS, romantic ad directories, lakefront classified ads, and waterfront online MLS for these section can be mapped.
|
|
