|
<%@ 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" %>
|
Australia Rental Links
Homes for rent in Manly and rent house in Manly Australia
Sydney Australia rent houses, Sydney Australia apartments for rent, and rental apartment in Sydney
Rental apartment, rental home in Sydney Australia, Sydney Australia rental properties, and holiday rentals in Sydney Australia
Robertson Australia homes for rent and Robertson home rentals
Sydney Australia home rentals, Sydney holiday rentals, and Sydney Australia rent house
Rental homes in Caloundra Australia, Caloundra Australia homes for rent, vacation homes in Caloundra Australia, and real estate rentals in Caloundra
Homes for rent by owner in Manly Australia and rental home in Manly Australia
Rental properties, Melbourne apartments for rent, and rental properties in Melbourne
Coolum Beach Australia houses for rent, Coolum Beach Australia houses for rent, vacation rentals, and homes for rent Coolum Beach
Rental apartment and vacation homes for rent by owner
Condos for rent, Palm Cove Australia rental properties, and for rent by owner homes
Robertson Australia rental home, homes for rent by owner Robertson, Robertson holiday rentals, and Robertson rental apartment
Condos for rent Surfers Paradise Australia and rental homes Surfers Paradise
Darwin Australia homes for rent by owner, Darwin Australia rent houses, and vacation rentals in Darwin Australia
Sunrise Beach Australia homes for rent by owner, real estate rentals Sunrise Beach, for rent by owner homes in Sunrise Beach, and rent house in Sunrise Beach
Vacation homes for rent by owner in Robertson Australia and Robertson Australia rental houses
Caloundra Australia for rent by owner homes, houses for rent Caloundra Australia, and Caloundra Australia rent houses
Hamilton Island Australia vacation rental, rental apartment in Hamilton Island Australia, apartment rentals Hamilton Island Australia, and homes for rent by owner in Hamilton Island Australia
Homes for rent 1770 Australia and vacation homes for rent by owner in 1770 Australia
Vacation rentals Surfers Paradise, real estate rentals in Surfers Paradise Australia, and bed and breakfast rentals Surfers Paradise Australia
Rental homes in Melbourne Australia, Melbourne Australia apartment rentals, rental home, and vacation rental in Melbourne
Hunter Valley house rentals and short term rentals
Sunrise Beach rental houses, Sunrise Beach Australia vacation rentals, and rental properties in Sunrise Beach Australia
Rental homes in Melbourne Australia, vacation homes for rent by owner, condo rentals, and holiday rentals in Melbourne Australia
Hamilton Island Australia vacation homes for rent by owner and houses for rent in Hamilton Island Australia
Coolum Beach Australia rental apartment, for rent by owner homes Coolum Beach, and for rent by owner homes
Discover and explore vacation homes for rent by owner in Woomera and bed and breakfast rentals in Woomera Australia.
Catch and devise Wodonga Australia vacation homes and short term rentals Wodonga.
Recognize, espy, and ferret out houses for rent in Lake Haven, Lake Haven rent house, and homes for rent Lake Haven.
You can find out, come upon, and move bed and breakfast rentals in Sydney Australia, home rentals in Sydney Australia, and bed and breakfast rentals in Sydney Australia.
Ascertain, conceive, and uncover Rockingham Australia vacation rentals, Rockingham vacation rental, and vacation homes in Rockingham Australia.
Savusavu Fiji for rent by owner homes, vacation homes for rent by owner in Savusavu Fiji, and condos for rent Savusavu Fiji
See resort online MLS, log ads, penthouse directories, and convenient directories that real estate brokers and town home owners post on our for rent by owner website.
Sydney rental agents, third party listing companies, and real estate brokers list holiday rentals Sydney, rent house in Sydney Australia, Sydney houses for rent, and bed and breakfast rentals in Sydney.
Come upon, ascertain, and detect the section and not far Sydney zone.
Come across, perceive, and ferret out rental houses, houses for rent Broome, and rental home in Broome Australia.
Elicit and catch Kempsey Australia for rent by owner homes and Kempsey rent houses.
Ascertain and invent vacation homes for rent by owner in Mudgee and for rent by owner homes Mudgee Australia.
Te Kauwhata New Zealand vacation rentals, house rentals in Te Kauwhata New Zealand, for rent by owner homes in Te Kauwhata, and condos for rent in Te Kauwhata New Zealand
Sydney Australia facts could ballyhoo, thump, serve, and serve your pursuing.
Move, find out, and determine real estate rentals Maryborough, Maryborough Australia house rentals, and Maryborough Australia homes for rent.
This website, FRBO.com seats precinct and county input, generally.
Look up, identify, and come across Launceston condo rentals, vacation homes in Launceston, and Launceston Australia homes for rent.
Identify, identify, and come across vacation rental in Nowra Australia, Nowra Australia bed and breakfast rentals, and rental properties in Nowra Australia.
Sydney Australia is a elegant and statuesque stretch with refined, cute, and magnificent flat, house, flat, and castles.
Recently available decadent ranch, beach cottage, and romantic townhouse are not faraway in the immediate locality of Sydney Australia.
Find and distinguish Carnarvon Australia house rentals and Carnarvon real estate rentals.
The Sydney Australia advertisements manifested and invoiced on this site, FRBO.com incorporate oceanfront apartment, rustic vacation home, exclusive houseboat, and log vacation home.
Distinguish and move Port Macquarie Australia homes for rent and homes for rent Port Macquarie.
You can examine the studio listings and exotic listings under Sydney Australia homes for rent and Sydney Australia vacation rentals.
FRBO.Com, For Rent By Owner, does eliminate rare log, hidden, beachfront, and oceanfront castle, flat, cottage, and flats.
|
|
