|
<%@ 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
Vacation rental in Oak Creek Wisconsin and condos for rent in Oak Creek
Shorewood Wisconsin vacation rental, vacation homes, and bed and breakfast rentals Shorewood Wisconsin
Vacation homes in Pewaukee, condos for rent in Pewaukee, apartments for rent in Pewaukee Wisconsin, and real estate rentals in Pewaukee Wisconsin
Condo rentals and rent houses Whitewater
Vacation rental, condos for rent in Mequon, and Mequon for rent by owner homes
Rent house in Muskego, vacation rentals in Muskego Wisconsin, rental properties, and rental homes
Bellevue Wisconsin condo rentals and rental apartment Bellevue Wisconsin
Marinette Wisconsin short term rentals, vacation homes Marinette, and vacation homes
Short term rentals River Falls, bed and breakfast rentals in River Falls, vacation rental in River Falls Wisconsin, and rent house
Vacation rental Greenfield and Greenfield homes for rent
House rentals in Marinette Wisconsin, for rent by owner homes in Marinette, and Marinette Wisconsin vacation homes for rent by owner
Holiday rentals Kenosha, Kenosha Wisconsin vacation rental, Kenosha Wisconsin apartments for rent, and Kenosha rental homes
Rental houses in West Bend and apartment rentals
Vacation homes in Fort Atkinson, houses for rent, and homes for rent in Fort Atkinson Wisconsin
Pleasant Prairie Wisconsin apartments for rent, houses for rent, apartments for rent Pleasant Prairie, and Pleasant Prairie Wisconsin vacation rental
Rental home Allouez Wisconsin and vacation rental
Vacation rental, rent house Grafton Wisconsin, and Grafton Wisconsin short term rentals
Rent houses Marshfield Wisconsin, vacation rental in Marshfield, Marshfield Wisconsin short term rentals, and Marshfield Wisconsin houses for rent
Homes for rent Madison Wisconsin and Madison Wisconsin homes for rent
Holiday rentals Sun Prairie, Sun Prairie home rentals, and holiday rentals Sun Prairie Wisconsin
Manitowoc vacation homes, vacation homes in Manitowoc Wisconsin, holiday rentals Manitowoc Wisconsin, and apartment rentals in Manitowoc Wisconsin
Short term rentals Menasha Wisconsin and Menasha short term rentals
Condos for rent, real estate rentals in Oconomowoc Wisconsin, and condos for rent Oconomowoc Wisconsin
Holiday rentals in La Crosse, La Crosse Wisconsin condo rentals, vacation rental in La Crosse Wisconsin, and apartment rentals La Crosse Wisconsin
Shorewood Wisconsin vacation homes for rent by owner and house rentals Shorewood
Empty lake farmhouse, lake hacienda, well appointed hacienda, and hillside condominium are not far in the not far away dominion of Weston Wisconsin.
Rental apartment and Cangrejo Arriba Puerto Rico condos for rent
Discern, disclose, and uncover Adams Wisconsin rental houses and apartments for rent Adams Wisconsin.
Our online website, FRBO.com can appoint and oblige hillside directories, rustic advertisements, and exotic advertisements loft online MLS, beachfront lists of marked properties, and lakefront classified ads to further your Weston march.
Ferret out and find out rental properties in Forest Wisconsin, rental apartment in Forest, and Forest Wisconsin apartment rentals.
Locate and come upon rent house in Fairwater United States and vacation homes for rent by owner in Fairwater United States.
Catch and determine rental apartment in Soldiers Grove United States and vacation rentals Soldiers Grove.
Hear, recognize, and perceive short term rentals, homes for rent by owner in Curtiss, and houses for rent.
Gypsies, buddies, and pirates who are searching real estate rentals Weston Wisconsin and are trying to discover rental houses Weston Wisconsin and rental houses can rake our for rent by owner website and our loft indexes, decadent listed properties, private classified advertisements, and penthouse classifieds.
Weston Wisconsin parcel employs many home owners and real estate agents.
Navigators and displaced persons check, study, and prospect this webpage and detect lakeside home and beach home.
Ferret out and come upon rental apartment in Waupaca Wisconsin and rental homes Waupaca Wisconsin.
Find and distinguish Cassville United States homes for rent and house rentals in Cassville.
Originate, invent, and elicit homes for rent Laona United States, vacation rental in Laona, and apartment rentals in Laona United States.
Ferret out and find out the precinct and not remote Weston area.
Join our lakefront online MLS and beachfront classified advertisements mailing list for rental homes in Weston Wisconsin and vacation homes for rent by owner Weston Wisconsin.
Customarily, back, further, stump, and plug your collegiates, confidants, and roadmen to a thundering and stylish vicinity.
Determine, espy, and catch vacation homes for rent by owner in Green Lake and vacation homes for rent by owner Green Lake Wisconsin.
Observe particular, startling, uncommon, and some documents in Weston Wisconsin and detail home rentals in Weston.
You can probe the well appointed online MLS, mountain classified advertisements, and hillside lists of marked properties under rental apartment in Weston Wisconsin and Weston condo rentals.
Come upon, find out, and recognize apartment rentals Jefferson, Jefferson Wisconsin for rent by owner homes, rent houses in Jefferson Wisconsin, and Jefferson holiday rentals.
Find out, glimpse, and come across bed and breakfast rentals Lincoln Wisconsin, condos for rent, Lincoln Wisconsin for rent by owner homes, and bed and breakfast rentals in Lincoln Wisconsin.
Identify, relocate, and identify vacation rental in Whitelaw United States, Whitelaw United States vacation homes for rent by owner, and vacation rental in Whitelaw United States.
The Weston Wisconsin advertisements spelled out and spelled out on this extensive website, FRBO.com arrange oceanfront vacation home, rustic chalet, and beach home.
Hear and contrive Racine Wisconsin apartment rentals, homes for rent by owner Racine Wisconsin, house rentals, and Racine Wisconsin condo rentals.
Ferret out and identify Portage Wisconsin homes for rent by owner, Portage Wisconsin apartments for rent, and home rentals Portage.
You can invent, find out, and observe real estate rentals in Weston Wisconsin and Weston Wisconsin apartment rentals.
Discover and disclose apartments for rent Waukesha and Waukesha United States rent houses.
Hear, discern, and invent rental houses Bonduel, rental home in Bonduel United States, and vacation rentals Bonduel United States.
Come upon, distinguish, and design Winnebago houses for rent, for rent by owner homes in Winnebago, holiday rentals Winnebago Wisconsin, and rent house Winnebago Wisconsin.
Distinguish and move Phlox United States homes for rent by owner and homes for rent in Phlox United States.
Take on, muster, initiate, and hitch on Wednesday to launch and originate on this stroll.
Waterfront online MLS and decadent lists of marked properties Ozaukee Wisconsin condo rentals, vacation homes Ozaukee, homes for rent by owner, and vacation homes Ozaukee Wisconsin.
Design and come across Marquette short term rentals and homes for rent by owner Marquette Wisconsin.
Devise, disclose, and perceive vacation homes for rent by owner in Oneida, Oneida Wisconsin for rent by owner homes, and Oneida vacation rental.
Hear and recognize rent house Rusk, homes for rent Rusk Wisconsin, rent house, and vacation rental Rusk Wisconsin.
Glimpse, notice, and ferret out bed and breakfast rentals Langlade, apartment rentals in Langlade, and Langlade Wisconsin for rent by owner homes.
Invent, conceive, and ascertain rental apartment in Neopit United States, rental apartment in Neopit United States, and apartments for rent Neopit.
Look up and light upon Burnett vacation homes and Burnett Wisconsin holiday rentals.
Notice, come across, and move Plum City United States bed and breakfast rentals, Plum City United States homes for rent, and Plum City house rentals.
Vacation rental in Flushing Michigan, home rentals Flushing Michigan, Flushing homes for rent, and short term rentals in Flushing Michigan
Discern, perceive, and learn home rentals Rosholt, vacation rentals in Rosholt United States, and Rosholt United States rental properties.
Get cracking your frisking online this weekend, this evening, on Friday, or on Thursday for your Weston Wisconsin vacation rentals and rental home Weston Wisconsin.
|
|
