|
<%@ 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
Menomonee Falls Wisconsin short term rentals and condo rentals
Rental apartment in Neenah, houses for rent in Neenah Wisconsin, and Neenah Wisconsin rent houses
Vacation rentals Baraboo Wisconsin, Baraboo rental homes, vacation homes for rent by owner Baraboo Wisconsin, and Baraboo vacation homes
Vacation rentals in Watertown and rental homes in Watertown Wisconsin
Monroe Wisconsin house rentals, apartment rentals in Monroe, and holiday rentals in Monroe
Home rentals in Menasha Wisconsin, condos for rent in Menasha Wisconsin, rental home Menasha, and bed and breakfast rentals Menasha
Rental home in Baraboo Wisconsin and rental homes Baraboo
Real estate rentals in Caledonia, rent house in Caledonia Wisconsin, and condos for rent in Caledonia
Madison homes for rent by owner, condo rentals in Madison Wisconsin, vacation rentals in Madison, and Madison Wisconsin rental home
Real estate rentals Oconomowoc Wisconsin and apartment rentals
Greenfield Wisconsin holiday rentals, apartments for rent in Greenfield, and bed and breakfast rentals in Greenfield Wisconsin
Caledonia rent houses, rental homes Caledonia, houses for rent in Caledonia, and houses for rent in Caledonia Wisconsin
For rent by owner homes Beaver Dam Wisconsin and vacation rental Beaver Dam Wisconsin
Rent houses in Oconomowoc Wisconsin, rental apartment, and Oconomowoc Wisconsin rental apartment
Holiday rentals, for rent by owner homes in Grand Chute, rental properties in Grand Chute, and condo rentals Grand Chute Wisconsin
Home rentals in Cedarburg Wisconsin and Cedarburg rental home
Mount Pleasant Wisconsin rental apartment, rental properties, and house rentals in Mount Pleasant Wisconsin
Whitewater house rentals, vacation homes for rent by owner Whitewater, holiday rentals Whitewater, and Whitewater Wisconsin vacation homes
Oconomowoc Wisconsin condo rentals and Oconomowoc rental homes
Shorewood short term rentals, condo rentals Shorewood Wisconsin, and Shorewood Wisconsin rental homes
Plover rental home, rental home, real estate rentals in Plover, and vacation homes
Homes for rent Brookfield Wisconsin and Brookfield Wisconsin condos for rent
Home rentals in Greenfield Wisconsin, homes for rent by owner Greenfield, and short term rentals in Greenfield Wisconsin
Bed and breakfast rentals in Caledonia Wisconsin, holiday rentals in Caledonia, holiday rentals in Caledonia Wisconsin, and condos for rent in Caledonia
Green Bay homes for rent by owner and condos for rent Green Bay Wisconsin
Homes for rent Middleton Wisconsin, house rentals in Middleton, and homes for rent by owner Middleton
Plover Wisconsin vacation homes, bed and breakfast rentals in Plover, Plover apartment rentals, and Plover Wisconsin vacation homes for rent by owner
Explore, contrive, and distinguish vacation homes in Eldorado, condo rentals in Eldorado, and vacation homes in Eldorado.
Well appointed indexes and exotic classified advertisements Marathon Wisconsin rental home, bed and breakfast rentals Marathon, Marathon Wisconsin rent houses, and rental home in Marathon Wisconsin.
You can examine the romantic online MLS, hillside classifieds, and mountain listed properties under rental houses in Superior Wisconsin, vacation rental, and rent houses in Superior.
The Superior Wisconsin exclusive classified ads and oceanfront classifieds for these precinct can be mapped.
Contrive, perceive, and originate houses for rent Vilas, vacation rental, for rent by owner homes in Vilas Wisconsin, and houses for rent Vilas Wisconsin.
Find and find out Lena home rentals and Lena rental houses.
Contrive, uncover, and disclose short term rentals in Woodruff, Woodruff United States rental home, and Woodruff United States for rent by owner homes.
Look up and come upon real estate rentals in Monroe Wisconsin and rent house in Monroe Wisconsin.
Originate and hear house rentals in Iron Belt United States and for rent by owner homes in Iron Belt United States.
Come across and glimpse Brown Wisconsin condo rentals, rental properties, and short term rentals.
Rental apartment in Lebanon Oregon, home rentals in Lebanon, rental homes in Lebanon, and rental houses in Lebanon Oregon
Determine diverse, uncommon, and diverse proof in Superior Wisconsin and insert for rent by owner homes in Superior Wisconsin.
Join our well appointed ads, exotic ads, and rustic directories mailing list for bed and breakfast rentals Superior Wisconsin and Superior Wisconsin rent house.
Explore and observe rental homes in Kewaunee Wisconsin, rental home in Kewaunee Wisconsin, Kewaunee Wisconsin homes for rent by owner, and vacation homes Kewaunee.
Catch, catch, and debunk vacation homes for rent by owner in Winneconne, Winneconne short term rentals, and condo rentals Winneconne United States.
Glimpse, determine, and ferret out vacation rental in Outagamie Wisconsin and homes for rent in Outagamie Wisconsin.
Determine, conceive, and light upon rental homes Winnebago, Winnebago Wisconsin rental home, Winnebago Wisconsin rental home, and Winnebago for rent by owner homes.
Vacation rental in Shawnee and home rentals in Shawnee
Relocate and perceive Brillion United States houses for rent and home rentals in Brillion.
Identify, discover, and elicit Honey Creek United States rental apartment, rental apartment in Honey Creek, and condo rentals Honey Creek United States.
Conceive and detect short term rentals Bayfield and rental homes Bayfield United States.
Ready to move in rustic houseboat, waterfront flat, convenient villa, and beach hacienda are immediate in the not far away tract of Superior Wisconsin.
Disclose, originate, and determine house rentals and Columbia Wisconsin apartment rentals.
You can elicit and catch apartments for rent Superior, Superior Wisconsin condo rentals, and Superior Wisconsin vacation rentals.
Bedford New York rent house, rental home in Bedford, and Bedford New York home rentals
Superior Wisconsin conclusions could thump, do for, and assist your research.
Come upon, detect, and relocate rental homes in Cross Plains United States, Cross Plains United States short term rentals, and vacation homes for rent by owner Cross Plains.
Lead off your research online on Friday, next week, now, or on Monday for your rental houses in Superior, houses for rent, and rental houses Superior.
Relocate and detect apartments for rent Sun Prairie and houses for rent Sun Prairie.
Discover, discover, and design Sawyer vacation homes, apartments for rent Sawyer, and rent houses in Sawyer Wisconsin.
Our page does except peculiar waterfront and loft castle, castle, and houseboats.
Identify, disclose, and debunk Pierce short term rentals, Pierce rental homes, and Pierce Wisconsin rental properties.
Conceive and move home rentals Elroy United States and condo rentals Elroy United States.
Our for rent by owner site, FRBO.com embraces turf, county, and state goods, ever so often.
Notice, identify, and discern rent house Fremont United States, rental apartment in Fremont United States, and rental homes Fremont.
Invent and ferret out Iowa Wisconsin real estate rentals, vacation rental in Iowa Wisconsin, and short term rentals Iowa.
Identify, look up, and espy the kingdom and not remote Superior Wisconsin territory.
Invent, determine, and identify Clark Wisconsin home rentals, Clark vacation homes for rent by owner, and rental houses in Clark Wisconsin.
|
|
