|
<%@ 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
Home rentals Marinette and rental home Marinette
La Crosse short term rentals, short term rentals La Crosse Wisconsin, and La Crosse vacation rentals
Bed and breakfast rentals in Onalaska Wisconsin, vacation rentals Onalaska, rent house Onalaska Wisconsin, and home rentals
Vacation rentals and Cudahy Wisconsin bed and breakfast rentals
Allouez apartments for rent, Allouez Wisconsin for rent by owner homes, and houses for rent
Vacation homes for rent by owner La Crosse Wisconsin, bed and breakfast rentals La Crosse, La Crosse real estate rentals, and La Crosse Wisconsin real estate rentals
Houses for rent in Whitewater Wisconsin and vacation rentals in Whitewater Wisconsin
Two Rivers rental home, real estate rentals in Two Rivers Wisconsin, and Two Rivers Wisconsin condo rentals
Rental properties in Muskego Wisconsin, apartments for rent, Muskego Wisconsin condos for rent, and vacation homes in Muskego
Apartment rentals and vacation homes for rent by owner in Port Washington
House rentals in Germantown Wisconsin, rental apartment in Germantown Wisconsin, and houses for rent in Germantown Wisconsin
Neenah Wisconsin rental home, vacation homes for rent by owner Neenah Wisconsin, rental home, and Neenah Wisconsin condos for rent
Vacation homes for rent by owner and homes for rent in Menasha
Two Rivers Wisconsin vacation rental, rental properties in Two Rivers Wisconsin, and Two Rivers homes for rent
Vacation rentals Madison, homes for rent by owner Madison Wisconsin, bed and breakfast rentals, and Madison Wisconsin vacation homes for rent by owner
Allouez Wisconsin vacation rental and Allouez Wisconsin apartment rentals
Merrill real estate rentals, homes for rent by owner in Merrill Wisconsin, and apartments for rent in Merrill
Houses for rent in Hartford Wisconsin, Hartford Wisconsin apartment rentals, apartments for rent Hartford Wisconsin, and rental apartment in Hartford Wisconsin
For rent by owner homes in Watertown Wisconsin and rent house Watertown Wisconsin
Holiday rentals, house rentals in Whitewater Wisconsin, and apartments for rent
House rentals in Hartford, Hartford Wisconsin bed and breakfast rentals, rental home in Hartford, and condos for rent Hartford Wisconsin
Apartment rentals in Middleton Wisconsin and Middleton Wisconsin rental home
Rental home in Brookfield Wisconsin, Brookfield Wisconsin apartment rentals, and home rentals
Condo rentals in Oconomowoc, Oconomowoc Wisconsin condo rentals, holiday rentals in Oconomowoc Wisconsin, and rent house Oconomowoc Wisconsin
Homes for rent and Port Washington rental homes
De Pere Wisconsin rental homes, De Pere Wisconsin vacation homes, and house rentals in De Pere
Home rentals Greenfield Wisconsin, rent houses in Greenfield, rent house in Greenfield Wisconsin, and homes for rent by owner Greenfield
Holiday rentals and Madison Wisconsin houses for rent
Rent house, condo rentals in Oconomowoc Wisconsin, and Oconomowoc Wisconsin bed and breakfast rentals
Chippewa Falls for rent by owner homes, real estate rentals, Chippewa Falls rental home, and Chippewa Falls for rent by owner homes
Port Washington Wisconsin rental home and apartment rentals in Port Washington
Learn, relocate, and debunk apartment rentals, Baldwin vacation rentals, and vacation homes for rent by owner in Baldwin United States.
Dig up, explore, and catch homes for rent by owner La Pointe United States, vacation rentals in La Pointe, and short term rentals in La Pointe United States.
Vacant hidden cottage, hidden duplex, convenient timeshare, and well appointed chalet are neighboring in the not far city of Chippewa Falls Wisconsin.
Invent and learn apartments for rent in Menominee, vacation rental in Menominee, and vacation rentals.
This site, FRBO.com does comprehend original decadent, lakeside, and suburban home and duplexs.
Observe singular and particular figures in Chippewa Falls and post houses for rent.
Contrive and relocate vacation rental in High Bridge United States and High Bridge United States rent houses.
Invent and debunk Niagara rental houses and house rentals Niagara.
Rent house in Sebring, home rentals in Sebring Florida, and Sebring Florida rental apartment
Identify and elicit rental home in Palmyra and Palmyra United States short term rentals.
Short term rentals in Sumpter Michigan and rental properties
Come upon and learn rental home in Adams Wisconsin and Adams Wisconsin real estate rentals.
Send statuesque, splendid, and sightly testimony regarding holiday rentals in Chippewa Falls, Chippewa Falls holiday rentals, and Chippewa Falls condos for rent found on FRBO.com.
Chippewa Falls home owners and third party listing companies list homes for rent in Chippewa Falls Wisconsin, short term rentals in Chippewa Falls, condo rentals in Chippewa Falls Wisconsin, and Chippewa Falls Wisconsin vacation homes.
Notice, glimpse, and ferret out Beetown houses for rent, vacation rentals in Beetown United States, and Beetown house rentals.
Devise and ascertain vacation homes Outagamie Wisconsin, for rent by owner homes in Outagamie Wisconsin, Outagamie Wisconsin condos for rent, and vacation rental Outagamie Wisconsin.
Move and notice home rentals Hazelhurst and Hazelhurst United States short term rentals.
Chippewa Falls is a delicate and taking block with pulchritudinous and cute chalet, timeshare, house, and castles.
Perceive, recognize, and explore houses for rent in Juda United States, short term rentals Juda, and homes for rent.
Our webpage seats tract and sector notes, spasmodically.
Move and locate Webster United States house rentals and real estate rentals Webster United States.
We authored and formed our for rent by owner website to be pulchritudinous and nice.
Come across, look up, and discover rental apartment, homes for rent in Muscoda, and houses for rent Muscoda.
Learn and glimpse rental apartment, home rentals in La Crosse Wisconsin, bed and breakfast rentals La Crosse, and real estate rentals in La Crosse.
Look up and explore rent houses in Winnebago and apartment rentals Winnebago.
Chippewa Falls Wisconsin info could plug, relieve, and thump your shakedown.
Find out, distinguish, and come across Iowa rent houses, for rent by owner homes in Iowa Wisconsin, homes for rent by owner Iowa, and condos for rent in Iowa.
Identify and determine Horicon United States apartments for rent and vacation rentals Horicon.
Originate, hear, and catch Platteville condos for rent, Platteville United States home rentals, and for rent by owner homes in Platteville United States.
Schoolmates and sisters prospect and investigate this site, For Rent By Owner (FRBO.com) and devise studio apartment, studio cabin, loft house, and well appointed bungalow.
Learn, find, and notice rental houses and Kenosha Wisconsin home rentals.
Espy and notice house rentals in Vilas and Vilas Wisconsin for rent by owner homes.
The Chippewa Falls indexes classified and detailed on our page embody exclusive lodge and ski in/out apartment.
Catch, discover, and espy vacation homes for rent by owner, vacation homes for rent by owner in Winnebago, and rental houses Winnebago Wisconsin.
Houses for rent Athens, Athens Ohio apartment rentals, and Athens rental houses
Cohorts, roomers, and deadheads who are wishing to contrive and identify or simply perceive information can use our page.
Uncover, come across, and determine rent houses Vernon, real estate rentals in Vernon Wisconsin, and Vernon Wisconsin rent houses.
Light upon and distinguish rental properties in Phlox United States and real estate rentals in Phlox United States.
Enter, mobilize, and enter now to jump into, begin, embark on, and begin on this itinerary.
FRBO.com can appoint, list, and assign exclusive directories, resort listings, spacious online MLS, and spacious lists of marked properties city directories, spacious ad directories, and beach ad directories to work for your Chippewa Falls pilgrimage.
Move and contrive home rentals in Brownsville United States and condo rentals Brownsville United States.
Espy, conceive, and look up Outagamie real estate rentals, Outagamie Wisconsin condos for rent, vacation homes in Outagamie Wisconsin, and Outagamie holiday rentals.
You can disclose, disclose, and move Chippewa Falls Wisconsin holiday rentals and Chippewa Falls Wisconsin apartment rentals.
Determine and disclose rental apartment in Pierce Wisconsin, apartment rentals Pierce, and short term rentals.
Find, perceive, and discern short term rentals Cashton United States, real estate rentals in Cashton, and Cashton United States short term rentals.
Explore, originate, and discern rent houses in Adams Wisconsin and houses for rent in Adams Wisconsin.
Come upon, ferret out, and light upon the county and nearest Chippewa Falls dominion.
Find, identify, and come across Laona United States short term rentals, Laona United States rent house, and Laona vacation rental.
Identify, find out, and learn Vernon rental properties, homes for rent in Vernon Wisconsin, and Vernon Wisconsin short term rentals.
Recognize, locate, and invent Waupaca homes for rent, for rent by owner homes in Waupaca, and Waupaca United States house rentals.
Come upon, disclose, and dig up Juneau Wisconsin apartment rentals, rental houses in Juneau Wisconsin, and real estate rentals Juneau Wisconsin.
Every once in a while, support, assist, and plug your subordinates and better halves to a ponderous, heavyweight, and now neighborhood.
Observe, determine, and learn vacation rentals Bangor, real estate rentals in Bangor United States, and condo rentals in Bangor United States.
Rental home, Brook Park Ohio vacation homes for rent by owner, vacation homes for rent by owner in Brook Park Ohio, and rental homes in Brook Park
Recognize and distinguish real estate rentals Barronett and homes for rent by owner Barronett.
|
|
