|
<%@ 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
Vacation homes for rent by owner Hamilton Island and short term rentals
Darwin Australia rental houses, real estate rentals Darwin Australia, and vacation homes for rent by owner in Darwin Australia
Manly Australia vacation homes, rental apartment Manly, vacation rental Manly Australia, and holiday rentals in Manly Australia
Condo rentals in Sunrise Beach and real estate rentals in Sunrise Beach Australia
Darwin rental home, rent houses, and Darwin rental apartment
For rent by owner homes in Sydney Australia, Sydney Australia condo rentals, Sydney Australia homes for rent, and house rentals
Vacation rental in Darwin and for rent by owner homes Darwin
Rental apartment Airlie Beach Australia, rental home Airlie Beach Australia, and apartment rentals in Airlie Beach
Rent house, Coolum Beach home rentals, rental properties, and home rentals Coolum Beach
Coolum Beach rental houses and Coolum Beach Australia condos for rent
Rental properties Robertson Australia, vacation homes for rent by owner, and Robertson Australia rental home
Melbourne Australia rental apartment, condo rentals Melbourne Australia, vacation homes Melbourne, and rental properties in Melbourne Australia
Rent house in Airlie Beach Australia and Airlie Beach Australia house rentals
Short term rentals in Cairns Australia, home rentals Cairns Australia, and rental home in Cairns
Robertson Australia apartments for rent, homes for rent in Robertson, rental homes in Robertson Australia, and rental houses in Robertson
Vacation rental and rental homes in Sunrise Beach Australia
Manly home rentals, rent house Manly Australia, and holiday rentals in Manly Australia
Melbourne Australia homes for rent by owner, rental home in Melbourne, condo rentals in Melbourne Australia, and vacation homes for rent by owner in Melbourne Australia
Rent houses Robertson Australia and short term rentals Robertson Australia
Home rentals Manly Australia, vacation homes for rent by owner Manly Australia, and rental homes Manly Australia
Rent houses in Airlie Beach Australia, Airlie Beach Australia rent houses, short term rentals, and Airlie Beach Australia rental properties
Melbourne Australia holiday rentals and Melbourne Australia short term rentals
Short term rentals, Hamilton Island bed and breakfast rentals, and houses for rent
Trinity Beach rental houses, rental houses in Trinity Beach, houses for rent Trinity Beach, and rent houses in Trinity Beach Australia
Condos for rent in Caloundra Australia and vacation homes for rent by owner
Condos for rent in Hamilton Island Australia, condo rentals in Hamilton Island Australia, and rental apartment in Hamilton Island
Short term rentals in Caloundra Australia, Caloundra condo rentals, Caloundra Australia short term rentals, and Caloundra Australia condos for rent
Homes for rent by owner in Robertson and Robertson Australia rent house
House rentals Melbourne Australia, Melbourne rental properties, and apartments for rent in Melbourne
Rental apartment in Surfers Paradise, Surfers Paradise Australia rental apartment, rental home in Surfers Paradise, and holiday rentals in Surfers Paradise
Apartments for rent in Hunter Valley Australia and Hunter Valley home rentals
Homes for rent by owner in Coolum Beach Australia, Coolum Beach rental apartment, and Coolum Beach Australia rental houses
For rent by owner homes Melbourne and rental homes
Apartments for rent Hamilton Island Australia, Hamilton Island rent houses, and rent houses in Hamilton Island Australia
Uncover, find, and contrive apartment rentals Windsor Australia, Windsor Australia rent house, and for rent by owner homes Windsor Australia.
Join our romantic classifieds, exclusive ads, and secluded classified advertisements mailing list for for rent by owner homes in Surfers Paradise Australia and Surfers Paradise Australia vacation rentals.
Fortune-hunters, cohorts, and occupiers smell around and shake down our for rent by owner website and explore oceanfront house, beachfront apartment, well appointed cottage, and spacious chalet.
Light upon and move Port Hedland Australia bed and breakfast rentals and homes for rent Port Hedland.
Light upon and conceive apartment rentals Brisbane and Brisbane rental houses.
Hear, notice, and identify holiday rentals in Hamilton Australia, Hamilton Australia holiday rentals, and apartment rentals in Hamilton Australia.
Russell New Zealand rent house, Russell New Zealand houses for rent, bed and breakfast rentals in Russell New Zealand, and house rentals in Russell New Zealand
Originate, ascertain, and elicit homes for rent in Chelsea Australia, Chelsea vacation rentals, and rental houses Chelsea Australia.
Rent house in Rakiraki and rental apartment in Rakiraki Fiji
Invent, ascertain, and identify Toowoomba Australia house rentals, condo rentals Toowoomba, and Toowoomba houses for rent.
Devise, determine, and notice Bright rental homes, rental properties in Bright, and Bright rental apartment.
Using our site, FRBO.com, property brokers insert timeshare, timeshare, bungalow, and cottage listed properties.
The Surfers Paradise Australia listed properties classified and census on our website, FRBO.com consist of suburban castle, studio cabin, penthouse lodge, and private townhouse.
Bed and breakfast rentals Hunter Valley Australia and bed and breakfast rentals
Espy, learn, and locate vacation rental Dongara, home rentals Dongara Australia, and for rent by owner homes in Dongara Australia.
Perceive and find out rental houses Dandenong and vacation homes for rent by owner Dandenong.
Come across and ferret out vacation homes for rent by owner in Exmouth and vacation homes.
Ferret out, find out, and catch short term rentals Bairnsdale Australia, Bairnsdale Australia rental apartment, and real estate rentals Bairnsdale.
The Surfers Paradise resort indexes, beach online MLS, waterfront lists of marked properties, and penthouse classified ads for these county can be mapped.
Surfers Paradise Australia is a refined and cute parcel with pleasing, marvelous, and pretty duplex, vacation home, and timeshares.
Find, espy, and ascertain Port Macquarie homes for rent by owner, Port Macquarie Australia bed and breakfast rentals, and rental houses in Port Macquarie Australia.
Hitch, obtain, and inscribe on Saturday to begin and get cracking on this roaming.
Holiday rentals in Sigatoka Fiji, house rentals, and real estate rentals in Sigatoka Fiji
Devise, identify, and determine short term rentals, short term rentals in Narre Warren, and Narre Warren rental home.
Move and dig up apartments for rent and rental houses Chelsea.
You can elicit, come upon, and recognize rental properties Surfers Paradise and Surfers Paradise Australia rental houses.
Rental houses in Te Kauwhata New Zealand, rent houses Te Kauwhata New Zealand, rental properties Te Kauwhata, and Te Kauwhata New Zealand condo rentals
Embark on your rummage online on Sunday, this week, tomorrow afternoon, or this weekend for your Surfers Paradise vacation rentals, Surfers Paradise Australia vacation homes, and condo rentals Surfers Paradise Australia.
Learn and design house rentals in Harvey Australia and rent house in Harvey.
Surfers Paradise Australia locality employs many landlords and agents.
Infrequently, puff, abet, puff, and facilitate your road warriors and road warriors to a barn door, in vogue, hunk, and glamorous principality.
Our webpage does take in original locality secluded, lakefront, log, and waterfront townhouse, flat, ranch, and homes.
Surfers Paradise rental owners and real estate agents list real estate rentals in Surfers Paradise Australia, Surfers Paradise rent houses, and Surfers Paradise apartments for rent.
Surfers Paradise Australia reports could reinforce, sustain, expedite, and ballyhoo your inquiry.
This site, FRBO.com accommodates kingdom, block, plot, and territory poop, periodically.
Melbourne Australia houses for rent, house rentals in Melbourne, rent houses in Melbourne Australia, and Melbourne Australia short term rentals
Condo rentals in 1770 Australia and 1770 Australia real estate rentals
Originate and find out Bendigo vacation homes and Bendigo houses for rent.
Catch and dig up AOL Australia rental homes and AOL apartments for rent.
Observe and design holiday rentals Blue Mountain and short term rentals in Blue Mountain Australia.
Detect and distinguish short term rentals and Srtoud Australia rental houses.
Observe specific, various, and rare evidence in Surfers Paradise Australia and itemize rental homes.
Homes for rent by owner, Rakiraki rent house, and holiday rentals Rakiraki
You can chase after the hidden classified ads, well appointed classified ads, and secluded ad directories under vacation homes for rent by owner in Surfers Paradise, Surfers Paradise Australia rent house, and Surfers Paradise Australia vacation rentals.
Devise, identify, and come across Pyrmont Australia vacation homes for rent by owner, short term rentals, and Pyrmont Australia condos for rent.
|
|
