|
<%@ 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" %>
|
Wisconsin Rental Links
Homes for rent by owner in Appleton Wisconsin and for rent by owner homes Appleton Wisconsin
Rental home in Whitewater, bed and breakfast rentals in Whitewater Wisconsin, and apartments for rent in Whitewater
Wauwatosa Wisconsin rent houses, homes for rent Wauwatosa, rental apartment, and Wauwatosa Wisconsin rental homes
Real estate rentals in Sheboygan Wisconsin and bed and breakfast rentals in Sheboygan Wisconsin
Mount Pleasant Wisconsin rental home, rent houses in Mount Pleasant, and Mount Pleasant Wisconsin rental houses
Beaver Dam Wisconsin vacation rental, rental apartment in Beaver Dam, rental home in Beaver Dam, and homes for rent by owner Beaver Dam Wisconsin
Fort Atkinson Wisconsin apartments for rent and rental apartment Fort Atkinson
Rent house, Glendale houses for rent, and rental homes Glendale Wisconsin
Plover Wisconsin bed and breakfast rentals, homes for rent, Plover Wisconsin apartments for rent, and apartments for rent Plover Wisconsin
Rent house Oak Creek Wisconsin and home rentals in Oak Creek Wisconsin
Vacation rental in Appleton Wisconsin, Appleton rental homes, and condo rentals Appleton Wisconsin
Rent houses in Monroe Wisconsin, Monroe apartments for rent, rent houses Monroe, and home rentals
Homes for rent in South Milwaukee Wisconsin and rental houses South Milwaukee Wisconsin
Home rentals Greendale, Greendale Wisconsin rental houses, and houses for rent in Greendale
Bed and breakfast rentals Mount Pleasant, Mount Pleasant Wisconsin for rent by owner homes, Mount Pleasant Wisconsin rental homes, and short term rentals Mount Pleasant
Rent house Appleton and real estate rentals in Appleton Wisconsin
Home rentals River Falls, rental homes in River Falls Wisconsin, and for rent by owner homes
Home rentals, for rent by owner homes, homes for rent by owner Middleton Wisconsin, and condos for rent Middleton Wisconsin
Homes for rent Plover and houses for rent in Plover Wisconsin
Rent house in Milwaukee Wisconsin, house rentals, and houses for rent in Milwaukee Wisconsin
Real estate rentals Grafton Wisconsin, Grafton Wisconsin homes for rent by owner, rental apartment Grafton, and home rentals in Grafton
Vacation rental in Muskego and homes for rent Muskego Wisconsin
West Bend Wisconsin homes for rent by owner, apartment rentals in West Bend, and vacation homes in West Bend Wisconsin
Middleton Wisconsin rental houses, bed and breakfast rentals in Middleton Wisconsin, homes for rent by owner in Middleton Wisconsin, and rental houses Middleton
Debunk, identify, and recognize rental home North Lake United States, condo rentals in North Lake United States, and house rentals North Lake.
Invent, invent, and relocate Barron vacation homes and apartments for rent Barron Wisconsin.
Locate, catch, and discern real estate rentals Osceola United States, Osceola United States houses for rent, and Osceola vacation rental.
Light upon, relocate, and identify home rentals in Clear Lake United States, bed and breakfast rentals, and Clear Lake United States rental houses.
Look up, locate, and relocate apartments for rent New London United States, New London vacation rental, and for rent by owner homes New London United States.
See ski in/out classifieds, beach classified advertisements, and exclusive ad directories that agents serving the condo market and property brokers post on this website, FRBO.com.
You can explore and contrive condos for rent Stoughton Wisconsin, for rent by owner homes in Stoughton Wisconsin, and Stoughton Wisconsin condo rentals.
You can scrutinize the secluded directories, rustic indexes, loft indexes, and waterfront listed properties under Stoughton Wisconsin rental houses, home rentals, and rental homes in Stoughton Wisconsin.
This webpage does eliminate individual convenient, waterfront, mountain, and log duplex and houseboats.
Customarily, push and abet your adventurers and soldiers to a fetching and in favor county.
Dig up, conceive, and ascertain holiday rentals in Monroe, vacation rentals Monroe, and rental homes in Monroe.
Conceive, recognize, and observe house rentals in Greenville, rental homes Greenville United States, and condo rentals.
Design, design, and distinguish Random Lake United States house rentals, real estate rentals in Random Lake, and rental homes in Random Lake United States.
Contrive and invent Randolph United States vacation homes and Randolph short term rentals.
Discern, espy, and detect homes for rent Buffalo Wisconsin, apartment rentals Buffalo, and Buffalo Wisconsin rental houses.
Learn and dig up house rentals Dunn and apartments for rent.
Catch and espy vacation rentals in Oconto Wisconsin, Oconto Wisconsin real estate rentals, Oconto Wisconsin house rentals, and for rent by owner homes Oconto.
Identify and observe rental homes in Kiel United States and Kiel United States bed and breakfast rentals.
Dwellers and jet-setters who are wishing to detect and debunk or simply uncover information can use this site, For Rent By Owner (FRBO.com).
Join our lake listed properties, resort indexes, and waterfront advertisements mailing list for rent houses, bed and breakfast rentals in Stoughton Wisconsin, and rent houses in Stoughton Wisconsin.
Originate unusual and extraordinary abstracts in Stoughton Wisconsin and chronicle Stoughton Wisconsin vacation rental.
Discover and come across Benoit house rentals and Benoit United States vacation homes for rent by owner.
Embark on your shakedown online in the morning, now, or this week for your Stoughton rental apartment, vacation homes Stoughton Wisconsin, and house rentals Stoughton Wisconsin.
Distinguish and find Tunnel City United States vacation rentals and Tunnel City United States holiday rentals.
Determine and invent houses for rent Oneida Wisconsin and Oneida Wisconsin rent house.
|
|
