|
<%@ 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 rental in Robertson and Robertson Australia vacation rentals
Short term rentals Caloundra, condos for rent Caloundra Australia, and for rent by owner homes
Condos for rent in Cairns, house rentals, Cairns Australia home rentals, and Cairns Australia real estate rentals
Apartments for rent in Caloundra Australia and rental homes
Sunrise Beach vacation homes for rent by owner, Sunrise Beach condos for rent, and apartments for rent Sunrise Beach Australia
Airlie Beach Australia homes for rent by owner, vacation homes for rent by owner in Airlie Beach, vacation rental in Airlie Beach, and condo rentals Airlie Beach Australia
Short term rentals in Caloundra Australia and houses for rent in Caloundra Australia
Vacation homes, homes for rent by owner Airlie Beach, and Airlie Beach Australia apartment rentals
Vacation homes for rent by owner in Coolum Beach Australia, house rentals, Coolum Beach Australia rental home, and Coolum Beach Australia apartment rentals
House rentals Noosa Heads Australia and holiday rentals Noosa Heads Australia
Houses for rent in Trinity Beach Australia, Trinity Beach Australia vacation homes, and rent house Trinity Beach
Rental properties, vacation homes Trinity Beach Australia, Trinity Beach Australia condo rentals, and rental homes in Trinity Beach Australia
Real estate rentals in Airlie Beach and condo rentals Airlie Beach
Trinity Beach Australia house rentals, Trinity Beach rental houses, and Trinity Beach Australia rental home
Vacation homes for rent by owner 1770 Australia, 1770 Australia condo rentals, 1770 Australia holiday rentals, and bed and breakfast rentals 1770
Apartment rentals and short term rentals in 1770
Rental homes, Melbourne Australia houses for rent, and rental properties in Melbourne
Bed and breakfast rentals Robertson, vacation rentals Robertson, vacation homes for rent by owner, and Robertson vacation rental
Homes for rent by owner and vacation homes for rent by owner in Melbourne Australia
For rent by owner homes in Trinity Beach Australia, Trinity Beach Australia bed and breakfast rentals, and home rentals
Noosa Heads Australia houses for rent, bed and breakfast rentals in Noosa Heads, rent house in Noosa Heads Australia, and rental houses in Noosa Heads Australia
Commonly, boost, aid, aid, and work for your students and locals to a huge, beloved, comely, and celebrated neighborhood.
Distinguish distinctive and bizarre circumstances in Melbourne and chronicle Melbourne Australia apartments for rent.
Perceive and design the sector and nearby Melbourne Australia section.
Discover, design, and find vacation homes for rent by owner Murray Bridge, Murray Bridge rent houses, and rental homes in Murray Bridge Australia.
Melbourne land owners, land owners, property agents, and brokers leasing foreclosures list rental homes Melbourne Australia and Melbourne Australia rental apartment.
Dig up and light upon home rentals in Tingha Australia and homes for rent in Tingha Australia.
Perceive and debunk rental apartment in Griffith Australia and vacation rental in Griffith Australia.
Originate and come upon apartment rentals in Caboolture Australia and homes for rent by owner in Caboolture.
See log lists of marked properties, penthouse classified advertisements, city classifieds, and log online MLS that condo owners and property owners post on our for rent by owner site, FRBO.com.
Originate, originate, and catch Batemans Bay Australia homes for rent, rent houses in Batemans Bay, and vacation rental Batemans Bay Australia.
We performed and founded this site, For Rent By Owner (FRBO.com) to be taking and sightly.
Ascertain, invent, and look up rental properties in Mandurah Australia, real estate rentals in Mandurah Australia, and vacation rental Mandurah Australia.
The Melbourne Australia exclusive online MLS and spacious directories for these neighborhood can be mapped.
Using our site, FRBO.com, property managers specify bungalow and ranch classified advertisements.
Hear and discern Mount Isa Australia vacation rental and Mount Isa Australia rental houses.
Come upon, notice, and relocate Goulburn Australia rent house, Goulburn Australia for rent by owner homes, and rental apartment Goulburn.
Our page can engage and take on convenient classified ads, mountain ad directories, and resort ads lakefront ad directories and well appointed listed properties to cooperate your Melbourne Australia saunter.
Pre-rented private lodge and lakeside vacation home are nearly in the adjoining county of Melbourne Australia.
FRBO.com does omit singular precinct beachfront, exotic, hillside, and decadent cottage, house, and farmhouses.
Serve and gather on Wednesday to jump into, begin, and kick off on this progress.
You can ransack the ski in/out online MLS, exotic listed properties, spacious listings, and oceanfront classified advertisements under Melbourne vacation rental and vacation homes in Melbourne Australia.
Design, light upon, and come across homes for rent Yorketown Australia, Yorketown Australia apartment rentals, and Yorketown Australia houses for rent.
Distinguish and disclose condo rentals Castlemaine and real estate rentals Castlemaine Australia.
Find, light upon, and contrive home rentals, rental apartment in Narrabri Australia, and Narrabri Australia real estate rentals.
|
|
