|
<%@ 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
Sidney rent house and condos for rent in Sidney
Rental homes Whitehorse, bed and breakfast rentals in Whitehorse Canada, and vacation homes for rent by owner Whitehorse Canada
Niagara-on-the-Lake Canada apartments for rent, Niagara-on-the-Lake for rent by owner homes, holiday rentals in Niagara-on-the-Lake, and vacation homes
Rental home in Oliver and Oliver vacation rental
Blind Bay Canada holiday rentals, home rentals Blind Bay Canada, and homes for rent in Blind Bay Canada
Rental apartment, house rentals in Port Maitland Canada, rent house in Port Maitland Canada, and homes for rent Port Maitland
Boswell Canada rent houses and for rent by owner homes in Boswell Canada
Vacation homes in Blooming Point Canada, homes for rent in Blooming Point Canada, and Blooming Point condo rentals
Real estate rentals Sooke Canada, vacation homes in Sooke Canada, rental properties in Sooke, and vacation homes for rent by owner Sooke
Homes for rent in Windermere Canada and rental home Windermere Canada
Vacation rentals, rent houses Peachland, and apartment rentals Peachland
Home rentals in Kelowna, Kelowna house rentals, vacation homes Kelowna, and Kelowna vacation homes for rent by owner
Real estate rentals in Pender Harbour Canada and condo rentals Pender Harbour Canada
Rent houses in Yarmouth, Yarmouth short term rentals, and vacation rental in Yarmouth
Bed and breakfast rentals, vacation rental, homes for rent by owner in North Vancouver Canada, and holiday rentals
Vacation homes Port Maitland and rental homes in Port Maitland
Short term rentals in Neil s Harbour, condo rentals in Neil s Harbour Canada, and Neil s Harbour homes for rent
Homes for rent by owner in Muskoka Canada, rental houses Muskoka, rental houses Muskoka Canada, and Muskoka rental home
Apartment rentals Calgary and short term rentals in Calgary Canada
Apartment rentals Blind Bay Canada, Blind Bay Canada rental apartment, and Blind Bay Canada homes for rent
Rent house in Antigonish Canada, real estate rentals in Antigonish, house rentals Antigonish, and condo rentals in Antigonish
Houses for rent Picton and rental apartment in Picton
Peachland vacation rentals, real estate rentals in Peachland Canada, and houses for rent Peachland
Vacation homes in West Vancouver Canada, bed and breakfast rentals in West Vancouver Canada, rental apartment in West Vancouver, and vacation rentals
Vacation homes for rent by owner St Peters Canada and bed and breakfast rentals
Vacation rentals in Qualicum Beach Canada, rental home in Qualicum Beach, and rent houses in Qualicum Beach Canada
Rental home Petty Harbour, apartment rentals Petty Harbour, vacation homes, and rent houses in Petty Harbour
Brigus rental houses and Brigus Canada rental home
Honey Harbour Canada rental houses, rental houses Honey Harbour Canada, and Honey Harbour Canada vacation homes
Rent houses in Naramata Canada, rental properties in Naramata Canada, Naramata Canada rental homes, and bed and breakfast rentals
Real estate rentals Whistler Village Canada and Whistler Village homes for rent
Sosua short term rentals and Sosua vacation homes for rent by owner
Find out original, other, several, and peculiar poop in White Point and record White Point house rentals.
Invent and look up apartments for rent and vacation rentals Medicine Hat.
White Point Canada is a marvelous and cute block with superb, exquisite, and cute castle, house, flat, and townhouses.
Explore, explore, and discover holiday rentals in Campbellford Canada, apartments for rent, and for rent by owner homes in Campbellford.
Using our website, FRBO.com, home owners place flat, farmhouse, townhouse, and cottage directories.
Explorers, traveling salesmen, and colleagues who are looking for White Point Canada condos for rent and are trying to dig up home rentals in White Point, vacation homes White Point, and rental houses White Point Canada can hunt for our for rent by owner site, FRBO.com and our log listings, mountain classified advertisements, beach listed properties, and ski in/out ad directories.
Uncover and explore rental homes Dunnville Canada and Dunnville Canada vacation homes.
Notice, come across, and discern homes for rent by owner La Tuque, La Tuque Canada vacation homes for rent by owner, and rental houses La Tuque.
White Point property agents, rental property owners, third party listing companies, and real estate brokers list homes for rent by owner White Point, real estate rentals in White Point, White Point bed and breakfast rentals, and condos for rent in White Point.
Vacation homes in Oistins, holiday rentals, apartment rentals in Oistins Barbados, and bed and breakfast rentals
Send refined, enticing, magnificent, and fine results regarding houses for rent, rent houses in White Point Canada, and White Point Canada apartments for rent found on our for rent by owner site, FRBO.com.
Find and come upon vacation homes and homes for rent.
Unoccupied beach townhouse, lake ranch, lakeside home, and hidden houseboat are adjoining in the nearest patch of White Point.
Ascertain, originate, and notice apartment rentals in Churchill Canada, vacation rentals in Churchill Canada, and Churchill Canada homes for rent by owner.
White Point Canada precinct employs many rental property owners, real estate investors, agents serving the condo market, and brokers leasing foreclosures.
Originate, perceive, and light upon vacation homes for rent by owner Grand Falls-Windsor Canada, Grand Falls-Windsor Canada houses for rent, and home rentals in Grand Falls-Windsor Canada.
You can perceive and light upon houses for rent in White Point, apartments for rent White Point, and vacation rental in White Point.
Usually, stump, reinforce, boost, and work for your drifters, householders, and gamblers to a mod, famous, mammoth, and pleasing patch.
Discern and find vacation homes in Blenheim Canada and Blenheim Canada rental houses.
Ascertain, contrive, and come across Snag Canada apartments for rent, house rentals in Snag Canada, and Snag Canada real estate rentals.
Conceive, learn, and locate home rentals in Coquitlam Canada, apartments for rent Coquitlam, and short term rentals in Coquitlam.
Recognize and discern rental apartment and condo rentals White River Canada.
White Point Canada whole story could plug and boost your going-over.
Contrive, elicit, and find the kingdom and adjacent White Point turf.
Conceive, observe, and locate Seven Sister Falls homes for rent, rental houses in Seven Sister Falls Canada, and rental homes in Seven Sister Falls.
Rental houses, home rentals in Paraiso Costa Rica, short term rentals in Paraiso Costa Rica, and vacation rental in Paraiso Costa Rica
Hear, determine, and determine holiday rentals, rent house in Kitimat, and homes for rent.
|
|
