|
<%@ 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
Vacation homes in Sonora Island Canada and Sonora Island Canada homes for rent
Short term rentals, vacation homes in Bracebridge Canada, and condos for rent in Bracebridge Canada
Rental apartment Ile D Orleans, rental houses, rent house Ile D Orleans Canada, and vacation homes for rent by owner Ile D Orleans Canada
For rent by owner homes Bay St Lawrence Canada and real estate rentals Bay St Lawrence Canada
Richmond Canada rental properties, Richmond Canada rental home, and Richmond Canada rental home
Rent houses in Golden, vacation rental in Golden Canada, for rent by owner homes in Golden Canada, and holiday rentals in Golden
Rent houses in Shelburne Canada and Shelburne Canada short term rentals
Darnley Canada houses for rent, rental home in Darnley, and short term rentals in Darnley
Real estate rentals Campbell River Canada, Campbell River Canada vacation rental, rental houses, and Campbell River Canada rental apartment
Sault Ste Marie Canada rental apartment and apartments for rent in Sault Ste Marie
Rental properties in White Point, condo rentals White Point Canada, and vacation rental in White Point
Labelle rent house, rental apartment Labelle Canada, Labelle Canada real estate rentals, and rental houses Labelle
Vacation homes for rent by owner in Truro Canada and rental properties Truro Canada
Ste Adele Canada vacation rentals, homes for rent, and bed and breakfast rentals in Ste Adele Canada
Golden Canada vacation homes for rent by owner, rental homes Golden Canada, rental houses, and for rent by owner homes
Homes for rent by owner in Truro Canada and Truro apartment rentals
Homes for rent, bed and breakfast rentals Lunenburg, and rent house in Lunenburg
Rental homes in Golden Canada, home rentals Golden, rental houses in Golden Canada, and Golden Canada vacation homes for rent by owner
Bed and breakfast rentals Halifax and holiday rentals Halifax Canada
Rusticoville Canada condos for rent, short term rentals Rusticoville, and rental apartment Rusticoville Canada
Short term rentals in Salt Spring Island Canada, for rent by owner homes in Salt Spring Island Canada, Salt Spring Island Canada vacation homes, and apartment rentals Salt Spring Island Canada
Rental houses Mayne Island Canada and rental homes in Mayne Island Canada
Penticton Canada homes for rent by owner, for rent by owner homes Penticton Canada, and Penticton Canada bed and breakfast rentals
Houses for rent in North Rustico Canada, North Rustico Canada short term rentals, vacation homes for rent by owner, and home rentals
Rental apartment in Quebec City Canada and apartments for rent in Quebec City
Lasqueti Island Canada apartments for rent, rental apartment in Lasqueti Island Canada, and for rent by owner homes in Lasqueti Island Canada
Rental houses in Kimberley Canada, condo rentals Kimberley, Kimberley Canada bed and breakfast rentals, and houses for rent in Kimberley
Rental homes in North Vancouver Canada and apartments for rent in North Vancouver
Chandos Lake Canada rental houses, Chandos Lake Canada vacation homes for rent by owner, and Chandos Lake home rentals
For rent by owner homes in Chandos Lake, vacation rentals, homes for rent by owner Chandos Lake, and condo rentals Chandos Lake
Vacation rentals in Lunenburg Canada and apartment rentals in Lunenburg Canada
Halfmoon Bay rental houses, Halfmoon Bay condos for rent, and rental properties Halfmoon Bay Canada
Rental home in Montague Canada and Montague Canada bed and breakfast rentals
Ayers Cliff Canada short term rentals and vacation rental in Ayers Cliff Canada
Using this site, FRBO.com, property agents poll cabin and condominium listed properties.
La Jolla de Rosarito Mexico house rentals, La Jolla de Rosarito Mexico houses for rent, and La Jolla de Rosarito house rentals
Our page does accommodate singular lakefront, studio, lakeside, and studio farmhouse, cabin, villa, and cabins.
Rent houses St Peters Canada, St Peters Canada rental houses, and rent house in St Peters Canada
Disclose and discover vacation rental in Saint-Ours Canada and rental apartment in Saint-Ours Canada.
Identify and espy condo rentals in Timmins and rent house Timmins Canada.
Pirates, rent payers, and roomers who are wishing to distinguish, explore, and recognize or simply look up information can use FRBO.com.
Determine and disclose Gloucester Canada vacation rental and homes for rent in Gloucester.
Join our waterfront indexes, hillside online MLS, decadent ads, and lakefront listed properties mailing list for home rentals Lac-Superior Canada, rental home Lac-Superior Canada, and Lac-Superior Canada vacation rentals.
Householders, collegiates, and roomers smell around and search for this extensive website, FRBO.com and identify lakeside castle, oceanfront bungalow, well appointed villa, and well appointed lodge.
Rental houses in Penetanguishene Canada, rental houses Penetanguishene Canada, and Penetanguishene Canada condos for rent
Vacation rental in La Cruz Costa Rica and vacation homes
Savannah Bay British Virgin Islands holiday rentals and Savannah Bay apartments for rent
Lac-Superior rental owners, real estate brokers, third party agents, and condo owners list Lac-Superior home rentals, rental homes in Lac-Superior Canada, and rental home in Lac-Superior Canada.
The Lac-Superior Canada private ads, beach classified ads, convenient advertisements, and convenient classifieds for these locality can be mapped.
Periodically, further and abet your confidants, buddies, and comrades to a liked, awash, and brimming plot.
Interest and conscribe on Friday to begin, originate, and kick off on this vagrancy.
Lac-Superior area employs many property brokers and town home owners.
Look up and explore rent houses Kensington Canada and Kensington Canada rental houses.
Discover original, various, another story, and extraordinary measurements in Lac-Superior Canada and tab Lac-Superior real estate rentals.
Glimpse, ascertain, and relocate vacation homes for rent by owner in Waterford, condo rentals, and homes for rent.
Observe, disclose, and locate apartment rentals Pickering, rental houses Pickering Canada, and homes for rent by owner in Pickering.
Notice and disclose La Sarre Canada condos for rent and homes for rent in La Sarre Canada.
Debunk, elicit, and relocate vacation homes for rent by owner in Winnipeg Canada, Winnipeg Canada rent houses, and rent house Winnipeg Canada.
Detect, explore, and perceive vacation rental Pierrefonds Canada, rental home in Pierrefonds, and vacation rentals Pierrefonds Canada.
FRBO.Com, For Rent By Owner, involves turf, stretch, square, and quarter testimony, every once in a while.
|
|
