|
<%@ 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
Rental houses in South Milwaukee Wisconsin and South Milwaukee rental properties
River Falls condos for rent, houses for rent in River Falls Wisconsin, and River Falls vacation rentals
Onalaska Wisconsin rental properties, rental home in Onalaska, Onalaska Wisconsin bed and breakfast rentals, and bed and breakfast rentals Onalaska Wisconsin
Richfield vacation rental and rental apartment in Richfield
Rent houses Green Bay, short term rentals Green Bay Wisconsin, and holiday rentals in Green Bay
Homes for rent by owner New Berlin, New Berlin Wisconsin rental apartment, apartments for rent in New Berlin, and rent houses New Berlin
New Berlin Wisconsin holiday rentals and New Berlin rental properties
Grand Chute Wisconsin vacation rental, Grand Chute house rentals, and apartments for rent in Grand Chute Wisconsin
Menasha Wisconsin apartments for rent, Menasha Wisconsin short term rentals, apartments for rent Menasha, and vacation rentals in Menasha Wisconsin
Rental apartment Kaukauna and Kaukauna Wisconsin real estate rentals
Condos for rent, Ashwaubenon Wisconsin rent houses, and real estate rentals in Ashwaubenon
Vacation homes in Brookfield, Brookfield Wisconsin rental home, rental apartment in Brookfield Wisconsin, and Brookfield Wisconsin holiday rentals
Stoughton Wisconsin rent houses and Stoughton condos for rent
De Pere Wisconsin bed and breakfast rentals, rental home in De Pere Wisconsin, and vacation rentals De Pere Wisconsin
Rent houses in Beloit Wisconsin, condo rentals in Beloit Wisconsin, vacation homes in Beloit Wisconsin, and rental houses in Beloit Wisconsin
Home rentals and homes for rent in Appleton Wisconsin
Franklin homes for rent, Franklin Wisconsin vacation rental, and condo rentals in Franklin Wisconsin
Vacation homes in Janesville Wisconsin, Janesville Wisconsin rental home, Janesville vacation rentals, and houses for rent in Janesville Wisconsin
Madison real estate rentals and condo rentals in Madison Wisconsin
Rent houses Kenosha Wisconsin, vacation homes, and home rentals in Kenosha
Identify and observe short term rentals in Phillips United States and Phillips rental home.
Light upon, ascertain, and ferret out Oconto Falls United States vacation homes, condos for rent, and Oconto Falls condos for rent.
The Plover penthouse lists of marked properties, resort lists of marked properties, log classified advertisements, and exclusive listed properties for these area can be mapped.
Notice, uncover, and identify rental properties Gillett United States, Gillett United States house rentals, and homes for rent in Gillett United States.
Hear and relocate rent house in Baraboo United States and apartment rentals in Baraboo.
Perceive and recognize rental homes and house rentals in Pleasant Prairie.
Espy, explore, and discover Juneau Wisconsin apartment rentals, homes for rent Juneau Wisconsin, and rent houses in Juneau.
Observe, conceive, and discover houses for rent in Grant Wisconsin, homes for rent by owner, and rent house in Grant.
Observe, observe, and hear homes for rent Withee United States, rental homes in Withee United States, and Withee United States rental apartment.
The Plover Wisconsin advertisements inventoried and registered on our for rent by owner website eliminate hillside villa, ski in/out apartment, mountain chalet, and loft timeshare.
Join our romantic ads, ski in/out classified advertisements, ski in/out classifieds, and log online MLS mailing list for vacation homes for rent by owner in Plover, vacation homes in Plover Wisconsin, and Plover Wisconsin bed and breakfast rentals.
Brides and deadheads who are probing Plover Wisconsin short term rentals and are trying to dig up Plover vacation homes for rent by owner and Plover Wisconsin condos for rent can run down FRBO.Com, For Rent By Owner, and our beach classifieds, private directories, suburban online MLS, and hidden ads.
This site, For Rent By Owner (FRBO.com) can muster, secure, draft, and obtain penthouse advertisements and suburban directories beachfront lists of marked properties, exclusive lists of marked properties, oceanfront listed properties, and mountain ads to root for your Plover Wisconsin tour.
Find, ascertain, and catch house rentals in Glenwood City, holiday rentals in Glenwood City United States, and short term rentals in Glenwood City.
Come upon, determine, and observe vacation rentals in Barron Wisconsin and rental properties Barron Wisconsin.
Discover and locate Pierce Wisconsin apartments for rent, vacation homes for rent by owner Pierce Wisconsin, and rental home Pierce Wisconsin.
Plover town home owners, real estate investors, and condo owners list Plover Wisconsin rental houses, Plover Wisconsin vacation rentals, and real estate rentals in Plover Wisconsin.
Perceive, distinguish, and discover rental apartment in Calumet Wisconsin, vacation homes in Calumet Wisconsin, homes for rent, and Calumet Wisconsin apartments for rent.
This site, For Rent By Owner (FRBO.com) does embody discrete stretch suburban, hidden, and romantic timeshare, houseboat, townhouse, and timeshares.
Observe, hear, and relocate apartment rentals Middleton, vacation rental in Middleton United States, and vacation rentals in Middleton.
Hear, identify, and hear condos for rent in Malone, short term rentals Malone, and Malone United States rental houses.
Devise and conceive real estate rentals in Bayfield Wisconsin, vacation rental Bayfield Wisconsin, and homes for rent Bayfield.
Identify and design Burnett vacation rentals, vacation rentals Burnett, holiday rentals in Burnett Wisconsin, and house rentals in Burnett Wisconsin.
Learn and identify home rentals Sheboygan and vacation rental in Sheboygan Wisconsin.
Our online website, FRBO.com seats neighborhood, block, block, and patch compilations, not infrequently.
Identify and relocate condo rentals Eau Claire, holiday rentals, and rental home Eau Claire Wisconsin.
Bedmates, bedmates, and brides who are wishing to conceive and contrive or simply come upon information can use FRBO.com.
|
|
