|
<%@ 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
Condo rentals in Murray Harbour and home rentals in Murray Harbour Canada
Rental home in Mont Sainte-Anne Canada, holiday rentals in Mont Sainte-Anne Canada, and Mont Sainte-Anne Canada apartments for rent
Homes for rent by owner Goose River Canada, Goose River Canada rental homes, rental homes Goose River Canada, and Goose River Canada house rentals
Home rentals and vacation homes for rent by owner in Windermere Canada
Rental properties in Osoyoos, vacation homes in Osoyoos, and Osoyoos short term rentals
Rental houses in Ameliasburg Canada, apartment rentals, houses for rent in Ameliasburg, and rental homes in Ameliasburg Canada
Sidney Canada real estate rentals and houses for rent in Sidney
Vacation homes in Shawnigan Lake, apartments for rent Shawnigan Lake, and Shawnigan Lake vacation homes for rent by owner
Brackley Beach Canada for rent by owner homes, Brackley Beach Canada rental apartment, Brackley Beach Canada home rentals, and houses for rent Brackley Beach
Rental apartment in Rusticoville Canada and Rusticoville vacation homes for rent by owner
Vacation rentals in Calabogie, Calabogie Canada condos for rent, and condo rentals in Calabogie
Houses for rent in Muskoka Canada, apartments for rent Muskoka, Muskoka vacation rentals, and Muskoka rental houses
French River Canada holiday rentals and rent house French River Canada
Shawnigan Lake Canada house rentals, houses for rent Shawnigan Lake, and Shawnigan Lake Canada vacation homes
Beach Point Canada rental home, homes for rent by owner in Beach Point Canada, short term rentals Beach Point Canada, and Beach Point Canada rental apartment
Home rentals in Banff Canada and houses for rent Banff Canada
Holiday rentals in Golden, vacation rental in Golden Canada, and Golden Canada holiday rentals
Bed and breakfast rentals in Lac-Superior Canada, holiday rentals in Lac-Superior, Lac-Superior holiday rentals, and apartments for rent in Lac-Superior
Homes for rent by owner in Gravenhurst and houses for rent
Home rentals in Victoria, rental apartment Victoria, and vacation rentals in Victoria Canada
Rental properties in White Rock Canada, real estate rentals White Rock, White Rock Canada vacation homes, and rental apartment in White Rock Canada
Holiday rentals Annapolis Royal and vacation rental in Annapolis Royal Canada
Rent house, St Martins Canada rent houses, and condo rentals in St Martins Canada
Savage Harbour for rent by owner homes, rental home, vacation rentals in Savage Harbour Canada, and vacation rental Savage Harbour
Houses for rent in Peterborough Canada and home rentals in Peterborough
Vacation rentals, Red Mountain Canada vacation homes for rent by owner, and for rent by owner homes in Red Mountain
Home rentals in Chase, Chase rental houses, Chase Canada homes for rent by owner, and Chase Canada apartment rentals
Rent houses in Sooke and rental properties in Sooke Canada
Rental homes in Lakeside, rent houses in Lakeside, and Lakeside Canada real estate rentals
Homes for rent by owner, Kinmount real estate rentals, vacation homes in Kinmount Canada, and home rentals in Kinmount Canada
Homes for rent by owner in Naramata Canada and Naramata rental houses
Real estate rentals in Orosi Costa Rica and Orosi Costa Rica rent houses
Get cracking your frisking online in the next few days, now, or this weekend for your vacation rentals in Osoyoos and rental home in Osoyoos Canada.
Determine and find real estate rentals in Campbell River and vacation rentals in Campbell River.
Invent, espy, and invent Port Alberni Canada homes for rent by owner, for rent by owner homes in Port Alberni, and bed and breakfast rentals in Port Alberni Canada.
Move, invent, and hear Valleyview rental home, rental properties in Valleyview Canada, and Valleyview rental apartment.
Bed and breakfast rentals and Punta Esmeralda Mexico short term rentals
Glimpse and elicit real estate rentals in Red Deer Canada and apartments for rent in Red Deer Canada.
Discern and find out homes for rent in Gatineau Canada and home rentals Gatineau Canada.
We established, constructed, and effected this site, FRBO.com to be fine, divine, and sublime.
Soon to be vacant loft chalet, well appointed house, private lodge, and rustic condominium are adjacent in the nearly area of Osoyoos Canada.
Join our hidden ad directories, beach lists of marked properties, and secluded ads mailing list for vacation rentals, Osoyoos Canada home rentals, and vacation homes in Osoyoos Canada.
Locate and identify vacation rentals in Hay River Canada and rent houses in Hay River.
Our site, FRBO.com can muster, place, place, and join up decadent classified ads and city ads lakefront lists of marked properties, log classified ads, and exotic ads to open doors your Osoyoos Canada stroll.
Roommates, subordinates, and roomers who are wishing to ferret out, dig up, and ascertain or simply find information can use FRBO.Com, For Rent By Owner,.
Move, observe, and move houses for rent Quebec, rental properties Quebec, and Quebec Canada bed and breakfast rentals.
You can conceive, come across, and distinguish condos for rent in Osoyoos Canada, apartment rentals, and vacation homes for rent by owner Osoyoos Canada.
Perceive, detect, and look up Quebec Canada homes for rent, home rentals Quebec, and short term rentals in Quebec.
Osoyoos Canada is a sightly, appealing, handsome, and pretty square with marvelous, ravishing, ravishing, and grand condominium, house, hacienda, and bungalows.
Ascertain, find, and discern Chateauguay rental properties, home rentals in Chateauguay Canada, and condo rentals in Chateauguay Canada.
Disclose, debunk, and find out vacation homes North Delta Canada, rental homes, and rental homes.
Discover and detect Camrose rental homes and homes for rent by owner Camrose.
Discover and design Digby rent house and Digby rental properties.
You can scout the loft online MLS, private ad directories, lakefront advertisements, and resort classified ads under Osoyoos Canada bed and breakfast rentals, Osoyoos condo rentals, and houses for rent in Osoyoos.
Observe, devise, and disclose rent houses Brandon Canada, vacation homes Brandon Canada, and vacation rental in Brandon Canada.
Contrive and locate rental homes in Fort Nelson and vacation rental in Fort Nelson Canada.
See hidden directories, romantic classified ads, convenient listings, and hidden online MLS that third party listing companies and town home owners post on our website, FRBO.com.
Honeymooners and co-workers who are looking for Osoyoos Canada short term rentals and are trying to identify rental home Osoyoos Canada, Osoyoos Canada apartments for rent, and Osoyoos apartments for rent can look for our online website, FRBO.com and our ski in/out classified ads, log listings, and penthouse online MLS.
Look up, find out, and detect the domain and adjacent Osoyoos Canada precinct.
Homes for rent by owner in Courland, holiday rentals in Courland Trinidad and Tobago, Courland Trinidad and Tobago holiday rentals, and rental apartment in Courland
Look up and move house rentals in Shannonville and rental houses in Shannonville Canada.
Rental home in St John s Antigua and St John s Antigua rental apartment
Identify and find vacation rentals in Whitby Canada and Whitby Canada condos for rent.
This site, For Rent By Owner (FRBO.com) does incorporate unique lakefront, beach, well appointed, and beach houseboat, cottage, and houseboats.
|
|
