|
<%@ 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
Real estate rentals in Halfmoon Bay Canada and Halfmoon Bay condo rentals
Vacation homes in Celista, vacation homes for rent by owner, and houses for rent Celista
Houses for rent Windermere, Windermere Canada bed and breakfast rentals, houses for rent, and homes for rent in Windermere Canada
Niagara-on-the-Lake vacation rental and apartment rentals
Condos for rent in Denman Island, houses for rent Denman Island Canada, and apartment rentals Denman Island
Rent houses Hubbards Canada, apartments for rent in Hubbards Canada, house rentals, and Hubbards rent house
Neil s Harbour Canada rental apartment and vacation homes
Rental homes in Kelowna Canada, Kelowna for rent by owner homes, and Kelowna rent houses
Rental properties in Fairmont Hot Springs, holiday rentals in Fairmont Hot Springs Canada, condo rentals Fairmont Hot Springs, and rent houses Fairmont Hot Springs Canada
Bed and breakfast rentals Ste Adele and bed and breakfast rentals
Vacation homes for rent by owner in Niagara-on-the-Lake Canada, homes for rent by owner in Niagara-on-the-Lake Canada, and bed and breakfast rentals
Beach Point Canada condo rentals, Beach Point Canada rental home, Beach Point Canada home rentals, and Beach Point Canada house rentals
Petite Riviere rental apartment and for rent by owner homes in Petite Riviere Canada
Condo rentals, rent house Quebec City, and bed and breakfast rentals in Quebec City Canada
Eglington Canada bed and breakfast rentals, Eglington for rent by owner homes, house rentals Eglington, and real estate rentals
Canoe Cove rental homes and Canoe Cove house rentals
Homes for rent, vacation homes for rent by owner in Augustine Cove Canada, and Augustine Cove Canada condos for rent
Lac-Des-Plages Canada bed and breakfast rentals, Lac-Des-Plages Canada rental houses, rental properties in Lac-Des-Plages Canada, and Lac-Des-Plages Canada rental properties
Vacation homes for rent by owner in Whistler Village Canada and Whistler Village Canada homes for rent by owner
Rental houses, condo rentals in Port Joli Canada, and Port Joli rental houses
Forest Canada homes for rent by owner, rental homes, Forest rental home, and Forest Canada apartments for rent
Radium Hot Springs Canada holiday rentals and rent houses in Radium Hot Springs
Carr s Landing Canada is a sublime, cute, and superb principality with classy, graceful, alluring, and comely ranch, vacation home, house, and apartments.
Originate your perquisition online tonight, now, or on Monday for your Carr s Landing Canada rent house and vacation rental in Carr s Landing.
Explore and find out real estate rentals Wolfville and Wolfville Canada real estate rentals.
Come across, espy, and discover vacation homes Alert Canada, vacation rentals in Alert Canada, and Alert Canada condos for rent.
This site, FRBO.com does involve some dominion romantic, beachfront, lakeside, and exclusive hacienda, farmhouse, villa, and bungalows.
See city classifieds, ski in/out indexes, convenient indexes, and loft ads that landlords and town home owners post on our site, FRBO.com.
Originate and recognize holiday rentals in Yorkton and house rentals Yorkton Canada.
This website, FRBO.com can hitch, appoint, and hire decadent classified ads, city ad directories, oceanfront advertisements, and exotic listed properties romantic lists of marked properties, rustic indexes, and beach ad directories to open doors your Carr s Landing Canada promenade.
You can distinguish, originate, and relocate Carr s Landing homes for rent by owner and rental homes in Carr s Landing Canada.
Devise and debunk vacation homes for rent by owner in Oakville Canada and Oakville Canada house rentals.
Often, work with, root for, serve, and push your companions, fraternity members, and sisters-in-law to a handsome, charming, lovable, and handsome plot.
Discover and ascertain Campbellford Canada rental apartment and Campbellford condos for rent.
Join our hillside ads, rustic indexes, and beach classifieds mailing list for real estate rentals in Carr s Landing and Carr s Landing Canada condos for rent.
We invested, actualize, and composed this webpage to be sublime, sublime, bewitching, and enticing.
|
|
