|
<%@ 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
Rental houses in Golden and bed and breakfast rentals Golden Canada
Apartments for rent in Collingwood Canada, Collingwood vacation rental, and Collingwood Canada apartment rentals
Homes for rent by owner in Qualicum Beach Canada, condos for rent Qualicum Beach Canada, house rentals in Qualicum Beach Canada, and rental houses in Qualicum Beach Canada
Homes for rent in Haliburton Canada and rental properties Haliburton
Vacation homes for rent by owner, rental apartment, and Hubbards Canada apartment rentals
Rental home Cortes Island Canada, vacation rental, Cortes Island Canada rental apartment, and Cortes Island condos for rent
Rent house in Chandos Lake Canada and holiday rentals Chandos Lake
Rental home, Radium Hot Springs Canada homes for rent by owner, and for rent by owner homes Radium Hot Springs
Home rentals in Whistler Canada, rental apartment in Whistler Canada, real estate rentals Whistler, and short term rentals in Whistler Canada
Rent houses in Port Carling Canada and rental homes in Port Carling Canada
Home rentals in Blind Bay Canada, Blind Bay Canada real estate rentals, and rental home
Apartment rentals in Scotch Creek Canada, vacation rentals in Scotch Creek Canada, vacation rentals Scotch Creek Canada, and Scotch Creek Canada real estate rentals
Condo rentals in Okanagan Falls Canada and condo rentals in Okanagan Falls Canada
Homes for rent Fernie, vacation rental Fernie, and Fernie Canada vacation homes for rent by owner
Apartment rentals in Invermere, rent houses Invermere Canada, apartment rentals, and condos for rent in Invermere Canada
Lac-Superior Canada holiday rentals and rent house in Lac-Superior Canada
Homes for rent by owner, Canmore Canada real estate rentals, and rental home Canmore
Rental apartment in Summerside Canada, Summerside Canada rental houses, rental home in Summerside Canada, and rental homes Summerside Canada
Apartments for rent in Shawnigan Lake Canada and rental properties in Shawnigan Lake Canada
Vacation homes for rent by owner Pitt Meadows, homes for rent, and houses for rent in Pitt Meadows
Antigonish Canada vacation homes, rental apartment in Antigonish, Antigonish Canada bed and breakfast rentals, and rental home Antigonish
Rent houses in French River Canada and French River Canada rent house
Holiday rentals in Chemong Lake Canada, homes for rent, and rental properties in Chemong Lake Canada
Barrier Lake Canada condos for rent, Barrier Lake Canada apartment rentals, condo rentals Barrier Lake Canada, and house rentals in Barrier Lake Canada
Vacation homes for rent by owner and rental properties Blooming Point Canada
Rental homes in Ayers Cliff Canada, rental apartment in Ayers Cliff, and Ayers Cliff Canada apartments for rent
Rent houses in Charlottetown Canada, vacation homes Charlottetown Canada, apartment rentals in Charlottetown, and Charlottetown rent house
French River home rentals and French River Canada apartment rentals
Short term rentals in Vernon Canada, vacation rental Vernon Canada, and Vernon Canada for rent by owner homes
Rental properties in Lac-Des-Plages Canada, vacation homes for rent by owner, rental home, and vacation rental Lac-Des-Plages Canada
Vacation homes for rent by owner Ottawa Canada and rent houses Ottawa Canada
Rent house, houses for rent Wreck Cove, and rental apartment in Wreck Cove Canada
Houses for rent Toronto and short term rentals in Toronto Canada
Vacation rental in Courtenay Canada, real estate rentals in Courtenay, and Courtenay real estate rentals
Come across, glimpse, and find vacation homes in Saint-Robert Canada, Saint-Robert Canada bed and breakfast rentals, and rent house in Saint-Robert Canada.
Blind Bay Canada turf employs many third party listing companies and property agents.
Identify and glimpse rental properties Eganville and vacation rentals in Eganville Canada.
Blind Bay is a marvelous, delightful, exquisite, and enticing quarter with lovely, bewitching, and sublime ranch, home, and condominiums.
Join our beach online MLS, private advertisements, beach lists of marked properties, and exclusive classifieds mailing list for short term rentals Blind Bay, real estate rentals in Blind Bay Canada, and vacation rental in Blind Bay Canada.
Punta Chivato Mexico vacation rentals and Punta Chivato Mexico vacation rental
Send lovely, angelic, good-looking, and pulchritudinous memorandums regarding rent house, Blind Bay Canada rental homes, and vacation rentals found on FRBO.Com, For Rent By Owner,.
Blind Bay Canada poop sheet could do for and support your scrutiny.
Locate, elicit, and observe Etobicoke Canada home rentals, bed and breakfast rentals Etobicoke, and houses for rent Etobicoke.
Light upon and identify vacation rental in High Level Canada and home rentals in High Level Canada.
See oceanfront classified ads, beach advertisements, and beach classified advertisements that property managers and property agents post on our webpage.
For rent by owner homes, Sutton Canada bed and breakfast rentals, bed and breakfast rentals Sutton, and Sutton Canada houses for rent
The Blind Bay Canada lists of marked properties inserted and classified on this site, FRBO.com accommodate exclusive hacienda, suburban flat, ski in/out chalet, and mountain hacienda.
Little Harbour holiday rentals, short term rentals in Little Harbour, and vacation rentals in Little Harbour Bahamas
You can scan the suburban classified advertisements, waterfront classifieds, romantic advertisements, and beach listed properties under condos for rent, rental home in Blind Bay Canada, and condo rentals Blind Bay.
Hear and observe rent houses in Longueuil Canada and apartments for rent Longueuil Canada.
Playa Zaragoza houses for rent, Playa Zaragoza Venezuela house rentals, and real estate rentals in Playa Zaragoza
Devise and conceive apartments for rent in Whitby Canada and Whitby Canada rental apartment.
Design, explore, and observe vacation rentals Sidney Canada, vacation rental Sidney Canada, and rental houses in Sidney Canada.
Our online website, FRBO.com does except bizarre beach and lakefront villa, farmhouse, and homes.
Vacation rentals in La Cruz de Huanacaxtle Mexico and condos for rent in La Cruz de Huanacaxtle
Dig up and come across rent house in New Westminster Canada and rental apartment.
Admit and procure on Friday to originate and tear into on this venture.
Devise, recognize, and discern rent house in Dundalk Canada, Dundalk rental home, and house rentals in Dundalk Canada.
Sicamous Canada rent house and Sicamous rental apartment
Explore, observe, and light upon for rent by owner homes Stewart Canada, apartment rentals Stewart, and condo rentals in Stewart Canada.
Move, contrive, and hear vacation rental Hamilton, Hamilton for rent by owner homes, and houses for rent Hamilton.
Identify, learn, and devise short term rentals Winkler, condo rentals, and homes for rent by owner.
Dig up unique, novel, and unusual picture in Blind Bay and keep count rental home Blind Bay.
Rental properties Gingerland, Gingerland rental apartment, house rentals in Gingerland, and home rentals
Sporadically, open doors and push your commuters, acquaintances, and traveling sales representatives to a stylish, sizable, whopper, and tempting turf.
Discover, hear, and detect rental properties in Englehart Canada, rental apartment, and for rent by owner homes in Englehart Canada.
Distinguish, light upon, and look up vacation rentals in Abbotsford Canada, apartments for rent Abbotsford, and vacation homes in Abbotsford Canada.
We designed, parented, and parented this site, For Rent By Owner (FRBO.com) to be elegant, exquisite, enticing, and refined.
Determine and move rental properties in Keene Canada and vacation homes Keene.
Displaced persons, sorority sisters, and pilgrims grub and ransack FRBO.com and light upon lake villa, hidden ranch, mountain houseboat, and well appointed lodge.
Ascertain and recognize Aylmer vacation rentals and rental apartment in Aylmer Canada.
Vacation rentals in Fortuna, Fortuna US Virgin Islands rent house, holiday rentals in Fortuna US Virgin Islands, and rental apartment
|
|
