|
<%@ 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 rentals Parrsboro and houses for rent
Short term rentals in Gabarus Canada, rent houses, and rental apartment in Gabarus Canada
For rent by owner homes, Margaretsville Canada short term rentals, vacation rentals in Margaretsville Canada, and condo rentals in Margaretsville Canada
Real estate rentals Charlotte s Shore and houses for rent Charlotte s Shore
For rent by owner homes in Qualicum Beach Canada, for rent by owner homes in Qualicum Beach Canada, and vacation rental Qualicum Beach
Short term rentals Cape Sable Island, vacation homes Cape Sable Island Canada, Cape Sable Island Canada vacation rental, and bed and breakfast rentals in Cape Sable Island
Celista Canada home rentals and condos for rent in Celista Canada
Vacation homes for rent by owner in Savage Harbour Canada, Savage Harbour Canada rental homes, and Savage Harbour Canada bed and breakfast rentals
Rossland vacation rentals, vacation homes in Rossland Canada, Rossland vacation rental, and condo rentals
Nanoose Bay Canada apartments for rent and vacation homes in Nanoose Bay Canada
Rental home Halfmoon Bay, rental homes in Halfmoon Bay Canada, and apartments for rent in Halfmoon Bay Canada
Banff Canada homes for rent by owner, for rent by owner homes Banff Canada, Banff condos for rent, and Banff real estate rentals
House rentals Roberts Creek Canada and Roberts Creek Canada house rentals
Alert Bay Canada rental home, houses for rent in Alert Bay Canada, and rental properties
Condo rentals in White Dummer Lake Canada, rental homes in White Dummer Lake, rent houses White Dummer Lake Canada, and rental houses
Ingonish Canada home rentals and condos for rent in Ingonish
Home rentals in Canmore Canada, Canmore rental properties, and rental home Canmore Canada
Sechelt Canada vacation homes for rent by owner, condo rentals Sechelt Canada, vacation rentals Sechelt Canada, and homes for rent by owner in Sechelt Canada
Vacation rental Quebec City Canada and Quebec City Canada apartment rentals
Harbourville Canada holiday rentals, holiday rentals in Harbourville Canada, and rental home
Niagara Falls Canada rent house, condos for rent, Niagara Falls Canada vacation homes, and rental homes in Niagara Falls
Ottawa Canada vacation rentals and Ottawa Canada rental properties
Lac Le Jeune house rentals, real estate rentals Lac Le Jeune, and Lac Le Jeune Canada vacation rentals
Apartment rentals, Big White Canada condos for rent, apartment rentals in Big White Canada, and Big White condos for rent
Apartment rentals Mont Ste-Marie Canada and rent house in Mont Ste-Marie Canada
Real estate rentals in Johnstown, Johnstown Canada rental homes, and rental home
Apartment rentals in Niagara-on-the-Lake, vacation rentals Niagara-on-the-Lake Canada, short term rentals Niagara-on-the-Lake, and Niagara-on-the-Lake Canada apartments for rent
Chase homes for rent and short term rentals
House rentals in Barrier Lake, apartment rentals, and holiday rentals Barrier Lake
Launch your expedition online on Thursday, tomorrow afternoon, on Sunday, or next week for your Mont-Carmel Canada vacation rental and vacation rentals in Mont-Carmel.
Determine, light upon, and contrive holiday rentals in Huntsville Canada, Huntsville Canada rental home, and Huntsville real estate rentals.
Mont-Carmel rental agents, land owners, condo owners, and town home owners list rental properties in Mont-Carmel, vacation homes for rent by owner Mont-Carmel, Mont-Carmel Canada home rentals, and Mont-Carmel Canada holiday rentals.
Uncover, come across, and light upon condo rentals in Mont-laurier, Mont-laurier Canada rent house, and house rentals in Mont-laurier Canada.
Elicit, locate, and discover Edson Canada homes for rent, homes for rent by owner Edson, and Edson Canada bed and breakfast rentals.
Houses for rent in Charlotte s Shore Canada and apartments for rent in Charlotte s Shore
Vacation rental, San Antonio Mexico rental homes, San Antonio vacation rental, and San Antonio apartment rentals
Oftentimes, stump, support, and expedite your sisters, townies, and tourists to a prodigious and preferred plot.
The Mont-Carmel Canada penthouse ads, lakefront ad directories, and secluded ad directories for these plot can be mapped.
Mont-Carmel whole story could boost, work with, back, and puff your inquiry.
Dwellers and renters run down and seek our online website, FRBO.com and devise penthouse home, beachfront farmhouse, beachfront castle, and city lodge.
Light upon and conceive Scarborough rent houses and Scarborough Canada homes for rent by owner.
Catch and move rental apartment in Truro and real estate rentals Truro.
Move, invent, and identify Leamington Canada vacation homes for rent by owner, apartment rentals Leamington Canada, and rental houses in Leamington.
Move, glimpse, and detect condo rentals, Sioux Lookout Canada condos for rent, and apartments for rent in Sioux Lookout Canada.
Send alluring, elegant, divine, and refined brass tacks regarding vacation rental in Mont-Carmel Canada and homes for rent by owner in Mont-Carmel found on this site, For Rent By Owner (FRBO.com).
Relocate, find, and distinguish Perth Canada apartment rentals, Perth real estate rentals, and vacation homes.
Vacation homes in Fernie Canada, short term rentals, Fernie Canada bed and breakfast rentals, and home rentals Fernie Canada
Using our webpage, home owners note timeshare and hacienda listings.
Discover and uncover home rentals and vacation homes in Newcastle Canada.
You can discern, locate, and light upon Mont-Carmel Canada rental homes and Mont-Carmel Canada vacation rental.
Perceive and identify rent houses Sault Ste. Marie Canada and apartment rentals.
You can scout the studio listed properties, spacious advertisements, and waterfront ad directories under rent houses in Mont-Carmel Canada, Mont-Carmel homes for rent, and rental apartment.
Locate and identify Gaspé rental apartment and vacation rentals in Gaspé.
Ferret out and devise Gloucester Canada rent house and bed and breakfast rentals in Gloucester.
Pilgrims and indwellers who are wishing to find, identify, and detect or simply elicit information can use this webpage.
Mont-Carmel Canada is a fascinating and pretty neighborhood with magnificent, shapely, and comely houseboat, chalet, houseboat, and houses.
Join our beachfront classifieds, beach online MLS, and suburban online MLS mailing list for for rent by owner homes and Mont-Carmel Canada rental properties.
|
|
