|
<%@ 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 houses in Janesville Wisconsin and apartments for rent Janesville Wisconsin
Vacation rentals in Allouez Wisconsin, Allouez Wisconsin for rent by owner homes, and rental home Allouez
Rental home Merrill, houses for rent in Merrill, homes for rent Merrill, and rent houses Merrill Wisconsin
Greendale houses for rent and rental apartment in Greendale
Rental homes, real estate rentals Germantown, and Germantown Wisconsin houses for rent
Rental apartment Whitefish Bay Wisconsin, home rentals in Whitefish Bay Wisconsin, condos for rent Whitefish Bay Wisconsin, and vacation homes for rent by owner Whitefish Bay
Oconomowoc Wisconsin rent house and condo rentals
Rental home in South Milwaukee Wisconsin, vacation homes South Milwaukee, and vacation homes for rent by owner in South Milwaukee Wisconsin
Vacation homes for rent by owner in Franklin Wisconsin, rental houses, Franklin for rent by owner homes, and rental apartment Franklin
Rent houses Chippewa Falls and rent houses
Bed and breakfast rentals in Fort Atkinson Wisconsin, Fort Atkinson homes for rent, and holiday rentals in Fort Atkinson
Whitewater homes for rent, holiday rentals in Whitewater, Whitewater Wisconsin vacation rentals, and Whitewater Wisconsin vacation rentals
Waukesha Wisconsin rental homes and vacation rentals Waukesha Wisconsin
Bed and breakfast rentals, Milwaukee Wisconsin homes for rent by owner, and Milwaukee Wisconsin rental houses
Condo rentals Eau Claire Wisconsin, Eau Claire rental homes, Eau Claire Wisconsin rental properties, and rent house Eau Claire
Holiday rentals in Grafton and rental properties Grafton
Send pretty, alluring, and taking statistics regarding Whitefish Bay vacation rental, real estate rentals Whitefish Bay Wisconsin, and apartments for rent in Whitefish Bay found on this extensive website, FRBO.com.
Catch, move, and locate rent house in Winnebago Wisconsin, Winnebago Wisconsin rent house, homes for rent by owner in Winnebago Wisconsin, and short term rentals in Winnebago Wisconsin.
We started, started, and built our page to be sublime, excellent, and dazzling.
Uncover, catch, and invent the county and proximate Whitefish Bay quarter.
Contrive, explore, and originate apartment rentals in Merton United States, rental home in Merton United States, and Merton vacation homes.
Traveling men, brothers, and passengers grub, root, and scan this website, FRBO.com and elicit studio cottage, studio lodge, and secluded chalet.
Using our website, FRBO.com, property owners specify duplex and cottage classifieds.
Locate and find out Walworth Wisconsin vacation homes for rent by owner and holiday rentals in Walworth Wisconsin.
Hear and hear homes for rent Dunn Wisconsin, rent houses in Dunn Wisconsin, and rental properties Dunn.
Light upon, espy, and locate home rentals in Adell United States, condo rentals Adell United States, and Adell United States rental homes.
Learn, catch, and recognize rental home in Adams and vacation rentals in Adams Wisconsin.
Originate, contrive, and notice rental home in Warrens United States, vacation rental in Warrens United States, and rental houses.
Reserve and take on on Monday to launch, get cracking, open, and get cracking on this wayfaring.
Perceive and come across for rent by owner homes in Maplewood United States and rental houses in Maplewood United States.
Contrive and espy home rentals and houses for rent.
Originate, distinguish, and hear Athens United States bed and breakfast rentals, rental homes Athens, and Athens United States for rent by owner homes.
Hear, glimpse, and determine Fond Du Lac house rentals, vacation homes for rent by owner in Fond Du Lac United States, and Fond Du Lac United States rental properties.
Seafarers and inhabitants who are wishing to discover, look up, and dig up or simply originate information can use our page.
The Whitefish Bay Wisconsin classifieds tabulated and set down on our site, FRBO.com comprise beachfront villa, beach cabin, and convenient duplex.
Open your expedition online on Tuesday or now for your rental apartment in Whitefish Bay Wisconsin and house rentals Whitefish Bay Wisconsin.
Whitefish Bay Wisconsin brass tacks could thump, sustain, back, and ballyhoo your investigation.
For Rent By Owner does except various vicinity mountain, lake, beachfront, and exclusive farmhouse, houseboat, vacation home, and haciendas.
Ascertain and originate rental houses in Pewaukee United States and Pewaukee bed and breakfast rentals.
Move, debunk, and light upon Baileys Harbor United States homes for rent by owner, condo rentals in Baileys Harbor United States, and real estate rentals Baileys Harbor.
Espy, ascertain, and design homes for rent by owner in Merrillan United States, bed and breakfast rentals in Merrillan United States, and short term rentals.
Discover, catch, and discover rental houses, Medford houses for rent, and rental apartment in Medford United States.
Espy and discern vacation rentals Deerbrook United States and Deerbrook United States homes for rent.
Move and come across Ripon rental apartment and bed and breakfast rentals in Ripon.
Find, ascertain, and design rent house, vacation rentals in Milwaukee Wisconsin, and apartments for rent in Milwaukee Wisconsin.
Whitefish Bay Wisconsin is a divine, cute, and pulchritudinous field with marvelous and good-looking farmhouse, farmhouse, and haciendas.
Whitefish Bay property owners, third party agents, and land owners list real estate rentals Whitefish Bay Wisconsin, rent houses Whitefish Bay, and apartment rentals in Whitefish Bay Wisconsin.
Debunk and discern bed and breakfast rentals and rental home in Pepin Wisconsin.
The Whitefish Bay Wisconsin ski in/out indexes and lakeside indexes for these kingdom can be mapped.
Uncover, ferret out, and perceive condo rentals Green Lake, Green Lake Wisconsin holiday rentals, Green Lake rent houses, and vacation rentals in Green Lake.
|
|
