|
<%@ 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
Chemong Lake Canada holiday rentals and rental homes Chemong Lake
Darnley Canada apartments for rent, condo rentals Darnley, and rental properties in Darnley Canada
Vacation homes for rent by owner Blooming Point Canada, condos for rent in Blooming Point, bed and breakfast rentals in Blooming Point Canada, and rental homes Blooming Point
Apartment rentals in Severn Bridge Canada and vacation rentals in Severn Bridge Canada
Peterborough houses for rent, Peterborough Canada for rent by owner homes, and Peterborough Canada vacation homes
Petty Harbour Canada homes for rent, real estate rentals in Petty Harbour Canada, home rentals in Petty Harbour Canada, and apartment rentals Petty Harbour
Rental homes in Kenora Canada and Kenora vacation homes for rent by owner
Oliver Canada for rent by owner homes, rental properties Oliver Canada, and Oliver Canada short term rentals
Houses for rent in Brackley Beach, Brackley Beach rental properties, holiday rentals, and rent houses in Brackley Beach
Rent houses in Malpeque Canada and bed and breakfast rentals Malpeque
Condos for rent in Fairmont Hot Springs Canada, Fairmont Hot Springs Canada houses for rent, and Fairmont Hot Springs houses for rent
Rental apartment North Vancouver, apartment rentals North Vancouver Canada, home rentals in North Vancouver Canada, and apartment rentals North Vancouver Canada
Vacation homes in Haliburton Canada and houses for rent in Haliburton Canada
Pender Harbour Canada rental properties, Pender Harbour Canada for rent by owner homes, and condos for rent Pender Harbour Canada
Leaf Rapids Canada houses for rent, apartment rentals in Leaf Rapids, for rent by owner homes Leaf Rapids Canada, and homes for rent by owner Leaf Rapids Canada
Rent house in Anglemont Canada and vacation rentals Anglemont Canada
Wakefield Canada rental properties, apartment rentals in Wakefield, and bed and breakfast rentals in Wakefield Canada
Vacation rental North Vancouver, house rentals, condos for rent, and holiday rentals North Vancouver Canada
Houses for rent in Honey Harbour and apartments for rent Honey Harbour
Vacation rental Picton, houses for rent Picton Canada, and rent house in Picton Canada
Bed and breakfast rentals in Denman Island, condos for rent, rental home in Denman Island, and short term rentals
St Peters Canada rental apartment and rental apartment St Peters Canada
Big Tancook Island rental houses, Big Tancook Island rental houses, and rental homes Big Tancook Island
Malpeque vacation rentals, Malpeque houses for rent, Malpeque homes for rent by owner, and rent houses in Malpeque
Vacation rental in Hubbards and Hubbards rental houses
Ascertain, come across, and determine house rentals Parksville, home rentals, and vacation homes for rent by owner in Parksville Canada.
Using For Rent By Owner, real estate investors classify home, duplex, and hacienda directories.
House rentals in Cap Estate St Lucia, homes for rent in Cap Estate St Lucia, rental apartment in Cap Estate St Lucia, and houses for rent in Cap Estate St Lucia
Santa Barbara Bonaire apartments for rent and vacation rental
Invent, come upon, and relocate rental home in Val-d Or Canada, Val-d Or Canada rental houses, and vacation rentals in Val-d Or Canada.
Debunk and look up Joliette Canada vacation homes and vacation rental in Joliette Canada.
Elicit, uncover, and invent the territory and proximate Annapolis Royal Canada principality.
Discover, find, and disclose Madoc Canada rental apartment, Madoc Canada rent house, and rental properties in Madoc Canada.
Soon to be vacant log villa, spacious apartment, and resort hacienda are contiguous in the nearly dominion of Annapolis Royal Canada.
Move discrete, unconventional, and other materials in Annapolis Royal and tick off rent houses Annapolis Royal.
Annapolis Royal state employs many property brokers, rental agents, agents, and town home owners.
Join our lake listings, decadent directories, hillside classified ads, and log classifieds mailing list for condos for rent in Annapolis Royal, apartments for rent in Annapolis Royal, and homes for rent by owner in Annapolis Royal.
Annapolis Royal rental property owners and property managers list vacation rental and Annapolis Royal houses for rent.
Come upon, dig up, and design condo rentals in Cobble Hill Canada, vacation homes for rent by owner in Cobble Hill Canada, and vacation rentals Cobble Hill Canada.
The Annapolis Royal Canada classified advertisements run down and manifested on FRBO.Com, For Rent By Owner, arrange lake house and suburban vacation home.
Come upon and dig up apartments for rent Rexdale and rental properties Rexdale.
Kick off your chase online on Sunday, tomorrow morning, or on Wednesday for your Annapolis Royal Canada real estate rentals and rental homes Annapolis Royal Canada.
Contrive and uncover St. John s Canada condo rentals and home rentals St. John s.
Invent and devise rental houses and rental homes Oliver Canada.
Elicit, relocate, and learn Stettler rental properties, apartment rentals in Stettler, and vacation rentals.
Displaced persons, confidants, and dwellers who are chasing after vacation rental Annapolis Royal and are trying to light upon vacation homes for rent by owner in Annapolis Royal Canada, Annapolis Royal Canada real estate rentals, and Annapolis Royal Canada apartments for rent can hunt our site, FRBO.com and our lakefront online MLS, well appointed lists of marked properties, rustic online MLS, and romantic ad directories.
|
|
