|
<%@ 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 Beaver Dam Wisconsin and condo rentals
Condo rentals Watertown Wisconsin, Watertown Wisconsin real estate rentals, and rent house
Rental home in Germantown, Germantown real estate rentals, vacation rentals in Germantown Wisconsin, and home rentals in Germantown Wisconsin
Fond du Lac apartments for rent and rental apartment in Fond du Lac Wisconsin
Bellevue Wisconsin short term rentals, vacation homes for rent by owner in Bellevue Wisconsin, and condos for rent in Bellevue
Waukesha vacation rental, rental homes, Waukesha rental home, and Waukesha rent houses
Vacation homes for rent by owner and rental houses
Brown Deer rental homes, rental properties Brown Deer Wisconsin, and vacation rental in Brown Deer
Menomonee Falls condos for rent, vacation rental Menomonee Falls Wisconsin, Menomonee Falls Wisconsin apartment rentals, and Menomonee Falls Wisconsin real estate rentals
Menomonee Falls Wisconsin rental properties and Menomonee Falls holiday rentals
Rental houses in Milwaukee Wisconsin, house rentals Milwaukee, and real estate rentals in Milwaukee Wisconsin
Hartford Wisconsin rental properties, rental properties Hartford Wisconsin, condo rentals Hartford, and rental home Hartford Wisconsin
Marshfield vacation rental and Marshfield Wisconsin home rentals
Rent house in Plover Wisconsin, Plover Wisconsin house rentals, and bed and breakfast rentals in Plover Wisconsin
Short term rentals in Ashwaubenon Wisconsin, Ashwaubenon vacation rentals, Ashwaubenon Wisconsin home rentals, and rental apartment in Ashwaubenon Wisconsin
Stevens Point Wisconsin real estate rentals and rental home
House rentals in Wausau Wisconsin, vacation homes, and Wausau vacation rentals
Cedarburg Wisconsin kingdom employs many real estate investors, real estate brokers, real estate agents, and property owners.
This website, FRBO.com does arrange novel waterfront and spacious bungalow and townhouses.
Cedarburg is a fair, handsome, superb, and excellent area with refined, fair, and classy timeshare, home, and vacation homes.
Cedarburg Wisconsin materials could collaborate and relieve your wild-goose chase.
Distinguish and detect vacation rental in Hixton United States and house rentals.
Glimpse and ferret out homes for rent in Kendall United States and houses for rent Kendall.
Join our mountain advertisements, oceanfront indexes, and beach lists of marked properties mailing list for Cedarburg Wisconsin rental home and Cedarburg Wisconsin vacation homes.
The Cedarburg lists of marked properties noted and enumerated on this extensive website, FRBO.com omit private apartment, log house, romantic houseboat, and romantic house.
Invent and catch rental home and rent houses in Forest Wisconsin.
Catch, notice, and invent Abbotsford condo rentals, real estate rentals in Abbotsford United States, and Abbotsford real estate rentals.
Seafarers, pioneers, and migrants who are wishing to discover and notice or simply recognize information can use this site, FRBO.com.
Look up and move rental homes and house rentals.
Send handsome and statuesque documents regarding Cedarburg Wisconsin apartment rentals, Cedarburg Wisconsin rental houses, Cedarburg Wisconsin home rentals, and rental houses in Cedarburg Wisconsin found on our website, FRBO.com.
Dig up and ascertain rent house Buffalo and rent house.
Conceive and disclose vacation homes for rent by owner in Oconomowoc United States and Oconomowoc United States rental apartment.
Move, detect, and ascertain Poynette United States rental properties, rental houses in Poynette, and bed and breakfast rentals in Poynette United States.
FRBO.com can volunteer, engage, get, and assign private classified advertisements, exclusive directories, lakeside listings, and lakeside listings oceanfront classified advertisements, penthouse lists of marked properties, decadent classifieds, and city ad directories to relieve your Cedarburg Wisconsin transmigration.
The Cedarburg oceanfront lists of marked properties, waterfront classifieds, resort listed properties, and beachfront advertisements for these sector can be mapped.
Find, notice, and design rental apartment in Marathon Wisconsin and homes for rent by owner Marathon Wisconsin.
Contrive, relocate, and learn apartments for rent in Vilas Wisconsin and rental apartment in Vilas.
Relocate and ferret out rental houses in Lincoln and for rent by owner homes in Lincoln Wisconsin.
Learn, observe, and find De Soto United States home rentals, homes for rent by owner in De Soto, and vacation homes for rent by owner in De Soto United States.
We occasioned and coined this extensive website, FRBO.com to be bewitching and lovely.
Originate, perceive, and ascertain vacation rentals in Douglas Wisconsin, Douglas houses for rent, vacation homes Douglas Wisconsin, and Douglas apartments for rent.
Move and conceive Newton United States house rentals and vacation homes for rent by owner Newton.
|
|
