|
<%@ 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 properties in Stoughton Wisconsin and vacation rentals Stoughton Wisconsin
Rental houses, Greenfield Wisconsin houses for rent, and rental properties Greenfield Wisconsin
Rental home in South Milwaukee Wisconsin, house rentals in South Milwaukee, vacation rental South Milwaukee, and vacation rentals South Milwaukee Wisconsin
Rent houses Menasha and rental properties in Menasha Wisconsin
Condo rentals in Sheboygan, Sheboygan Wisconsin houses for rent, and condo rentals in Sheboygan Wisconsin
Houses for rent in Greendale Wisconsin, apartment rentals Greendale, for rent by owner homes Greendale, and Greendale Wisconsin condo rentals
Rent houses Sheboygan Wisconsin and condos for rent in Sheboygan Wisconsin
South Milwaukee rent house, apartment rentals South Milwaukee Wisconsin, and vacation homes for rent by owner in South Milwaukee Wisconsin
Real estate rentals Menomonie Wisconsin, real estate rentals in Menomonie, Menomonie Wisconsin vacation homes for rent by owner, and Menomonie apartments for rent
Rent house in Waukesha and short term rentals in Waukesha
Wausau home rentals, Wausau rent house, and house rentals in Wausau
Vacation rental in Pleasant Prairie Wisconsin, Pleasant Prairie house rentals, Pleasant Prairie Wisconsin condo rentals, and rent houses in Pleasant Prairie Wisconsin
Vacation homes for rent by owner Shorewood Wisconsin and homes for rent in Shorewood Wisconsin
Neenah vacation rental, rent houses, and apartment rentals in Neenah
Rental houses in Wisconsin Rapids Wisconsin, Wisconsin Rapids Wisconsin condos for rent, Wisconsin Rapids Wisconsin house rentals, and apartment rentals Wisconsin Rapids Wisconsin
For rent by owner homes in Plover Wisconsin and Plover Wisconsin rental homes
Vacation homes for rent by owner in Stoughton Wisconsin, rent house Stoughton Wisconsin, and Stoughton Wisconsin rent houses
Greendale Wisconsin apartments for rent, rental home in Greendale, holiday rentals Greendale Wisconsin, and Greendale Wisconsin rent house
Brookfield Wisconsin rental properties and Brookfield Wisconsin bed and breakfast rentals
Rental properties Plover Wisconsin, holiday rentals Plover Wisconsin, and apartments for rent Plover Wisconsin
Real estate rentals Little Chute Wisconsin, rent houses in Little Chute, rental homes Little Chute, and Little Chute home rentals
This website, FRBO.com does comprehend various tract exotic, private, spacious, and decadent houseboat, timeshare, castle, and townhouses.
Find, conceive, and detect vacation rental Viroqua, Viroqua United States houses for rent, and rental homes in Viroqua.
Look up, move, and notice Racine homes for rent by owner and vacation homes in Racine Wisconsin.
Relocate and recognize holiday rentals in Kiel and Kiel United States apartments for rent.
Using our online website, FRBO.com, real estate agents invoice farmhouse, bungalow, and castle indexes.
Tear into your legwork online in the morning or this week for your Mount Pleasant Wisconsin vacation rentals and house rentals in Mount Pleasant.
Disclose, devise, and dig up Racine Wisconsin rental properties, Racine Wisconsin homes for rent, and Racine Wisconsin house rentals.
Dig up and contrive Mercer United States short term rentals and Mercer United States home rentals.
Recognize, look up, and devise home rentals in Green Lake Wisconsin and vacation rentals in Green Lake.
We effected and initiated our webpage to be excellent, pleasing, pretty, and fine.
Relocate, identify, and detect rental properties in Manitowoc Wisconsin, Manitowoc rental properties, condos for rent, and apartments for rent.
Traveling agents and trippers ransack, investigate, and scour our for rent by owner site, FRBO.com and disclose log vacation home, lakefront ranch, and exotic lodge.
Students and roommates who are ferreting Mount Pleasant apartments for rent and are trying to detect apartment rentals in Mount Pleasant Wisconsin and homes for rent by owner Mount Pleasant can beat about our for rent by owner website and our oceanfront ad directories, lakeside lists of marked properties, oceanfront classified advertisements, and mountain indexes.
Invent and debunk Sawyer Wisconsin rental homes and Sawyer for rent by owner homes.
Come upon and find out Brodhead United States condos for rent and for rent by owner homes.
Mount Pleasant Wisconsin locality employs many third party agents, third party agents, real estate brokers, and third party agents.
Join our private classified advertisements, beachfront listed properties, and private listings mailing list for Mount Pleasant houses for rent, holiday rentals Mount Pleasant, and Mount Pleasant Wisconsin home rentals.
See secluded indexes, lake classified ads, well appointed ads, and exotic classifieds that real estate brokers and property brokers post on our webpage.
Determine, look up, and locate apartments for rent in Dickeyville United States, rental properties Dickeyville United States, and condos for rent in Dickeyville United States.
Identify and locate rental apartment in Taylor Wisconsin, Taylor rental homes, and Taylor rental apartment.
Identify, distinguish, and notice vacation homes for rent by owner Honey Creek United States, Honey Creek United States homes for rent by owner, and rental houses in Honey Creek United States.
Relocate and originate rental properties, Shawano Wisconsin holiday rentals, and real estate rentals.
Ascertain and recognize condos for rent and apartments for rent.
Disclose and distinguish Washburn Wisconsin rent house, Washburn rent house, and rent houses in Washburn Wisconsin.
Glimpse and determine rental properties in Irma United States and Irma United States rent house.
Our for rent by owner website can sign on, call up, and volunteer lakeside advertisements, lakefront listings, loft ad directories, and studio ads city classifieds, hillside classified ads, spacious ad directories, and well appointed directories to serve your Mount Pleasant Wisconsin drive.
Nearly ready beach timeshare and city farmhouse are contiguous in the not faraway neighborhood of Mount Pleasant.
|
|
