|
<%@ 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
Milwaukee Wisconsin vacation rentals and apartments for rent Milwaukee Wisconsin
Rental homes, holiday rentals in Middleton Wisconsin, and Middleton Wisconsin rent house
Rental houses Germantown, Germantown Wisconsin bed and breakfast rentals, Germantown Wisconsin rental properties, and vacation rental in Germantown Wisconsin
Real estate rentals Greendale and vacation homes in Greendale Wisconsin
Apartments for rent West Bend, West Bend for rent by owner homes, and short term rentals
Apartments for rent Onalaska Wisconsin, rental homes Onalaska Wisconsin, homes for rent by owner, and short term rentals in Onalaska Wisconsin
Rental properties in Milwaukee Wisconsin and house rentals in Milwaukee
House rentals in Watertown Wisconsin, Watertown real estate rentals, and Watertown homes for rent by owner
Racine vacation rental, bed and breakfast rentals Racine Wisconsin, Racine Wisconsin rental apartment, and Racine Wisconsin homes for rent
Homes for rent in Superior Wisconsin and vacation homes for rent by owner
Grafton Wisconsin holiday rentals, rental apartment, and rental properties Grafton
Neenah Wisconsin vacation rentals, rental apartment Neenah, rental homes in Neenah, and Neenah Wisconsin vacation homes
Green Bay Wisconsin home rentals and Green Bay Wisconsin rental homes
Vacation rental Whitefish Bay, rental homes in Whitefish Bay Wisconsin, and vacation homes for rent by owner Whitefish Bay Wisconsin
Fort Atkinson Wisconsin bed and breakfast rentals, short term rentals in Fort Atkinson, homes for rent in Fort Atkinson, and Fort Atkinson house rentals
For rent by owner homes Caledonia and vacation rentals in Caledonia Wisconsin
House rentals, Marshfield Wisconsin vacation homes for rent by owner, and Marshfield Wisconsin bed and breakfast rentals
Neenah Wisconsin rental houses, holiday rentals in Neenah, short term rentals in Neenah Wisconsin, and rental houses in Neenah
Houses for rent Racine and holiday rentals Racine Wisconsin
Bellevue for rent by owner homes, rental apartment in Bellevue Wisconsin, and condo rentals in Bellevue Wisconsin
Menomonee Falls Wisconsin vacation rental, real estate rentals Menomonee Falls Wisconsin, bed and breakfast rentals in Menomonee Falls Wisconsin, and Menomonee Falls Wisconsin vacation homes for rent by owner
House rentals and Ashwaubenon for rent by owner homes
Come upon and relocate vacation homes in Grant Wisconsin and for rent by owner homes in Grant Wisconsin.
Look up and learn rental home Fond du Lac, rental properties Fond du Lac, and vacation homes Fond du Lac Wisconsin.
Determine, contrive, and find vacation homes in Outagamie Wisconsin, Outagamie Wisconsin rental apartment, Outagamie Wisconsin rent houses, and Outagamie Wisconsin rent house.
Waukesha property owners, land owners, brokers leasing foreclosures, and property brokers list Waukesha Wisconsin condo rentals and Waukesha rent houses.
Determine, debunk, and ascertain bed and breakfast rentals Iron Ridge, condo rentals in Iron Ridge, and Iron Ridge United States homes for rent.
We fashioned and actualize FRBO.com to be good-looking, fine, comely, and pulchritudinous.
Find out and come across rental houses in Pickerel and home rentals Pickerel.
Waukesha Wisconsin conclusions could relieve and expedite your pursual.
Distinguish, originate, and detect Polk Wisconsin for rent by owner homes, Polk houses for rent, and Polk Wisconsin rental properties.
Recognize, disclose, and conceive vacation homes in Saint Cloud United States, Saint Cloud United States rental homes, and Saint Cloud home rentals.
Relocate and originate homes for rent Silver Lake United States and rental properties Silver Lake.
Procure, join, initiate, and register on Wednesday to originate, kick off, enter upon, and open on this trip.
Come across, explore, and discover Downing United States for rent by owner homes, Downing United States house rentals, and home rentals Downing.
Uncover and come across apartment rentals in Monroe Wisconsin and vacation homes in Monroe.
Our webpage embodys sector, precinct, state, and parcel documents, now and again.
FRBO.com can appoint, enter into, and take on hidden classified ads, well appointed advertisements, private classifieds, and lakeside advertisements mountain ads, resort classified advertisements, private directories, and loft lists of marked properties to push your Waukesha Wisconsin sojourn.
You can grub the convenient listings and lake classifieds under rent house and Waukesha rent houses.
Observe, conceive, and design Franklin United States rental apartment, home rentals in Franklin United States, and Franklin short term rentals.
Ferret out and invent apartment rentals in Merrillan and rent houses in Merrillan United States.
See beachfront indexes and exclusive classified ads that third party agents and rental property owners post on this webpage.
Uncover and come across condos for rent, homes for rent by owner in Dunn Wisconsin, homes for rent Dunn, and vacation homes for rent by owner.
Transmigrants, brothers-in-law, and locals inquire and look our website, FRBO.com and invent city lodge, lakefront hacienda, and private house.
|
|
