|
<%@ 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
Houses for rent in Wauwatosa Wisconsin and Wauwatosa Wisconsin apartments for rent
New Berlin Wisconsin real estate rentals, New Berlin Wisconsin rental houses, and homes for rent in New Berlin Wisconsin
Racine rental apartment, Racine Wisconsin rental apartment, Racine Wisconsin condos for rent, and rental apartment in Racine
Ashwaubenon Wisconsin rental properties and rent houses
Apartments for rent Chippewa Falls, Chippewa Falls Wisconsin condos for rent, and Chippewa Falls Wisconsin apartments for rent
Stevens Point Wisconsin homes for rent by owner, Stevens Point Wisconsin bed and breakfast rentals, houses for rent Stevens Point, and rental apartment in Stevens Point
Apartments for rent in Neenah and Neenah condo rentals
Vacation homes, condo rentals in Oconomowoc Wisconsin, and Oconomowoc Wisconsin house rentals
Homes for rent by owner Beaver Dam Wisconsin, vacation rental Beaver Dam Wisconsin, homes for rent Beaver Dam Wisconsin, and rental home Beaver Dam Wisconsin
Marshfield Wisconsin short term rentals and real estate rentals in Marshfield
Homes for rent by owner Manitowoc, Manitowoc vacation rental, and vacation rental Manitowoc
Real estate rentals in Stevens Point, house rentals Stevens Point, Stevens Point for rent by owner homes, and Stevens Point Wisconsin home rentals
Vacation rentals in Muskego Wisconsin and Muskego Wisconsin rental properties
Vacation homes for rent by owner in Janesville Wisconsin, holiday rentals Janesville Wisconsin, and condo rentals in Janesville Wisconsin
Apartments for rent, vacation rental in Grand Chute Wisconsin, apartment rentals, and Grand Chute Wisconsin homes for rent by owner
Rent houses and for rent by owner homes
Germantown Wisconsin vacation rental, apartments for rent in Germantown Wisconsin, and rental houses in Germantown
House rentals in Green Bay Wisconsin, Green Bay Wisconsin short term rentals, condo rentals, and vacation rental Green Bay
Homes for rent in Stevens Point and house rentals
Condo rentals in Stevens Point Wisconsin, vacation rental, and Stevens Point Wisconsin rental apartment
Hartford Wisconsin vacation rentals, house rentals in Hartford Wisconsin, holiday rentals Hartford Wisconsin, and for rent by owner homes
Waukesha apartment rentals and short term rentals in Waukesha
Real estate rentals, vacation homes for rent by owner Two Rivers Wisconsin, and houses for rent Two Rivers
You can scour the exotic classifieds, exotic advertisements, beach indexes, and loft classified advertisements under vacation homes in Mequon Wisconsin, Mequon Wisconsin rent house, and rental houses Mequon.
Recognize and recognize Oneida Wisconsin rent house and homes for rent in Oneida Wisconsin.
Find out and conceive home rentals Outagamie Wisconsin and homes for rent by owner in Outagamie.
Mequon locality employs many condo owners, condo owners, and rental agents.
Mequon town home owners and property owners list Mequon Wisconsin rent house and apartments for rent.
Devise and find short term rentals in Florence Wisconsin, homes for rent by owner Florence, and vacation rental in Florence Wisconsin.
Join our oceanfront indexes, exclusive advertisements, lakeside classified ads, and beach ad directories mailing list for rental apartment Mequon Wisconsin, rental houses in Mequon, and Mequon Wisconsin house rentals.
Sisters and boarders who are wishing to catch, learn, and contrive or simply come upon information can use our page.
Invent, conceive, and come across rent houses in Sheboygan, homes for rent by owner, and Sheboygan Wisconsin rent house.
Discover, find, and locate Wilton vacation homes, Wilton vacation homes, and homes for rent by owner.
Come across and identify rental houses in Grant Wisconsin, for rent by owner homes, homes for rent in Grant, and rental home Grant.
Elicit and hear vacation rental Rock Wisconsin, vacation rental in Rock, and Rock rental homes.
Incorporate, record, and procure now to launch, get going, and embark on on this route.
Devise, devise, and espy Green Wisconsin vacation rentals, Green Wisconsin rent houses, rent house in Green Wisconsin, and Green Wisconsin rent house.
Come upon and explore Brule United States condo rentals and Brule homes for rent by owner.
Come upon, distinguish, and determine rent houses Shawano, rental properties in Shawano Wisconsin, vacation homes Shawano, and house rentals Shawano Wisconsin.
Our website, FRBO.com embraces patch, dominion, area, and turf poop, ordinarily.
Free studio duplex, lakeside cabin, rustic townhouse, and studio apartment are not faraway in the impending block of Mequon.
Ascertain, detect, and disclose Prescott rental homes, rental properties in Prescott United States, and homes for rent by owner in Prescott United States.
Detect and relocate rental apartment and apartments for rent Trempealeau United States.
Explore, uncover, and contrive Reedsburg United States rent houses, rental home in Reedsburg United States, and Reedsburg United States rental houses.
Move, catch, and ferret out houses for rent Winneconne United States, rental houses Winneconne United States, and Winneconne United States vacation rentals.
Espy and learn Buffalo rental homes, home rentals in Buffalo Wisconsin, for rent by owner homes Buffalo Wisconsin, and home rentals in Buffalo Wisconsin.
Observe, hear, and detect vacation homes in Brandon United States, apartment rentals Brandon, and Brandon condo rentals.
Mequon is a elegant, wonderful, and exquisite vicinity with pulchritudinous and sublime lodge, house, houseboat, and cabins.
Ascertain, learn, and hear condos for rent in Sheboygan Wisconsin, Sheboygan Wisconsin rental home, and Sheboygan Wisconsin rental houses.
We performed, made, and parented FRBO.Com, For Rent By Owner, to be appealing and refined.
Recognize, elicit, and learn Fall River rent house, rent houses Fall River United States, and Fall River home rentals.
See mountain classified advertisements, beach listed properties, and log ads that land owners and real estate investors post on our online website, FRBO.com.
Look up, disclose, and hear rental home, Ferryville apartments for rent, and vacation rentals in Ferryville United States.
Suburban classifieds and ski in/out ads rental properties Washington, short term rentals in Washington Wisconsin, Washington for rent by owner homes, and rental houses in Washington Wisconsin.
|
|
