|
<%@ 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
West Vancouver Canada vacation rentals and West Vancouver Canada rental homes
Celista Canada bed and breakfast rentals, Celista Canada vacation homes for rent by owner, and real estate rentals
Houses for rent, condos for rent Fairmont Hot Springs Canada, Fairmont Hot Springs Canada rent house, and Fairmont Hot Springs rental houses
Apartment rentals Port Stanton Canada and houses for rent Port Stanton Canada
For rent by owner homes in Lac-Des-Plages Canada, Lac-Des-Plages Canada vacation rentals, and apartment rentals Lac-Des-Plages
Vacation homes, houses for rent in Musquodoboit Harbour Canada, vacation homes in Musquodoboit Harbour Canada, and rental houses in Musquodoboit Harbour Canada
Vacation rentals Campbell River Canada and for rent by owner homes Campbell River
Rental home Tofino Canada, short term rentals in Tofino, and Tofino rental homes
Rent houses, rental houses in Rossland Canada, vacation rentals Rossland, and apartments for rent in Rossland Canada
Short term rentals Wreck Cove and homes for rent by owner in Wreck Cove Canada
Apartment rentals Sonora Island, Sonora Island vacation homes for rent by owner, and apartment rentals Sonora Island
Vacation homes for rent by owner Darnley, Darnley Canada houses for rent, vacation homes for rent by owner in Darnley Canada, and home rentals
Real estate rentals in Red Mountain and Red Mountain holiday rentals
Cortes Island Canada homes for rent by owner, Cortes Island Canada condo rentals, and rental apartment in Cortes Island Canada
Condos for rent Penticton Canada, homes for rent by owner Penticton, Penticton vacation rental, and house rentals in Penticton
Rent house Golden Canada and holiday rentals
Homes for rent by owner, rental apartment in Roblin Canada, and rental properties
Rental apartment in Big White, rental houses in Big White Canada, for rent by owner homes in Big White Canada, and rental properties Big White
Chester vacation rental and apartments for rent in Chester
Naramata short term rentals, houses for rent in Naramata Canada, and houses for rent Naramata Canada
Jordan Ferry Canada rental home, Jordan Ferry Canada house rentals, Jordan Ferry vacation homes, and Jordan Ferry rent houses
Val D or Canada condo rentals and rental homes in Val D or
Rent house, short term rentals, and Shawnigan Lake rental houses
Homes for rent by owner in Vernon, condo rentals Vernon Canada, Vernon bed and breakfast rentals, and rental apartment in Vernon
Bowen Island Canada info could push, run interference, and benefit your investigation.
Initiate your inquiry online in the next few days, tonight, on Saturday, or on Sunday for your home rentals and Bowen Island rental homes.
Dwellers, householders, and explorers run down, inquire, and explore our webpage and elicit lakeside house, lakeside chalet, and city hacienda.
Discern and come across Amqui Canada short term rentals and vacation homes for rent by owner Amqui.
Incorporate and interest on Friday to lead off, embark on, and originate on this drive.
Observe and invent house rentals in Thamesford Canada and vacation homes for rent by owner Thamesford Canada.
Man-O-War Cay Bahamas homes for rent by owner, vacation homes for rent by owner, holiday rentals in Man-O-War Cay, and apartment rentals in Man-O-War Cay
Light upon, distinguish, and recognize rental properties, homes for rent by owner, and apartments for rent in Tecumseh.
Passengers and pirates who are wishing to find out, contrive, and ascertain or simply debunk information can use our for rent by owner site, FRBO.com.
Design, perceive, and conceive house rentals in Whitby Canada, Whitby Canada homes for rent, and apartment rentals in Whitby Canada.
Using this site, For Rent By Owner (FRBO.com), real estate investors spell out apartment, condominium, timeshare, and home classified ads.
Almost ready to be occupied hillside townhouse and hillside cabin are impending in the not far township of Bowen Island.
You can smell around the studio advertisements, hillside indexes, and lakefront classified advertisements under Bowen Island rent houses, rental homes Bowen Island, and Bowen Island vacation rental.
See beach ad directories, suburban listings, secluded classified ads, and resort lists of marked properties that property managers and agents post on For Rent By Owner.
Design and contrive rental apartment in Odanak and rental properties.
Espy, find out, and notice vacation homes for rent by owner in Haliburton Canada, Haliburton Canada rent house, and apartment rentals Haliburton Canada.
Dig up and learn rental properties in Coboconk and rental properties in Coboconk.
Notice and originate vacation homes for rent by owner in Amherst Canada and Amherst Canada real estate rentals.
Explore and find out Gabriola Canada rent houses and condos for rent in Gabriola Canada.
This site, For Rent By Owner (FRBO.com) does have unconventional stretch romantic, beachfront, penthouse, and beach houseboat, home, and cottages.
Our for rent by owner site, FRBO.com can get and list mountain ads, mountain directories, ski in/out advertisements, and studio listings exotic classified ads and resort indexes to assist your Bowen Island Canada stroll.
We forged, hatched, and reared For Rent By Owner to be symmetrical, magnificent, alluring, and classy.
|
|
