|
<%@ 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
Holiday rentals in Beloit and Beloit Wisconsin house rentals
Rent houses in Monroe Wisconsin, vacation homes for rent by owner in Monroe Wisconsin, and apartments for rent
Houses for rent in Grand Chute Wisconsin, vacation homes for rent by owner in Grand Chute Wisconsin, short term rentals in Grand Chute Wisconsin, and homes for rent
Whitewater short term rentals and home rentals in Whitewater Wisconsin
Rental houses in La Crosse, rental properties, and rent houses La Crosse Wisconsin
Caledonia Wisconsin condo rentals, vacation rentals in Caledonia Wisconsin, homes for rent Caledonia, and Caledonia Wisconsin houses for rent
Short term rentals in Wisconsin Rapids and houses for rent
Rental home Monroe Wisconsin, vacation rentals in Monroe, and house rentals
Stoughton Wisconsin condo rentals, Stoughton holiday rentals, house rentals Stoughton, and rental apartment in Stoughton Wisconsin
Stoughton Wisconsin vacation homes for rent by owner and Stoughton Wisconsin apartments for rent
House rentals in Mount Pleasant, houses for rent in Mount Pleasant Wisconsin, and homes for rent Mount Pleasant Wisconsin
Rental properties in Glendale Wisconsin, Glendale Wisconsin vacation rental, vacation rental, and vacation homes in Glendale
Rent house Waukesha and Waukesha condos for rent
Houses for rent in Appleton, rental apartment Appleton, and vacation homes for rent by owner
Pewaukee Wisconsin real estate rentals, bed and breakfast rentals in Pewaukee, apartment rentals in Pewaukee Wisconsin, and vacation homes in Pewaukee Wisconsin
South Milwaukee Wisconsin home rentals and condo rentals in South Milwaukee Wisconsin
Kenosha vacation homes for rent by owner, rent house in Kenosha Wisconsin, and Kenosha apartments for rent
Apartments for rent Weston, homes for rent Weston Wisconsin, rent house Weston Wisconsin, and Weston Wisconsin rental homes
House rentals and apartments for rent in Whitefish Bay Wisconsin
Homes for rent by owner, Mount Pleasant Wisconsin vacation rentals, and Mount Pleasant condos for rent
Home rentals in Hartford, rental home in Hartford Wisconsin, house rentals in Hartford, and Hartford Wisconsin rental homes
Real estate rentals in Port Washington and Port Washington Wisconsin rent houses
For rent by owner homes, houses for rent Shorewood, and home rentals
Watertown Wisconsin vacation rental, rental properties in Watertown Wisconsin, homes for rent in Watertown Wisconsin, and houses for rent Watertown Wisconsin
Watertown Wisconsin rent house and Watertown Wisconsin short term rentals
Apartments for rent in Germantown, Germantown rental properties, and real estate rentals in Germantown Wisconsin
Vacation homes Madison Wisconsin, Madison Wisconsin rental houses, condos for rent in Madison Wisconsin, and Madison Wisconsin rental home
Apartment rentals and rent houses
Vacation homes Madison Wisconsin, rental apartment Madison, and holiday rentals Madison Wisconsin
Rental houses Allouez Wisconsin, homes for rent by owner Allouez, holiday rentals in Allouez Wisconsin, and rental apartment in Allouez Wisconsin
Sheboygan Wisconsin rental homes and Sheboygan Wisconsin rental home
Pleasant Prairie Wisconsin apartments for rent, real estate rentals Pleasant Prairie Wisconsin, and vacation homes for rent by owner
Vacation homes for rent by owner and homes for rent in Pewaukee Wisconsin
Milwaukee Wisconsin rental home, bed and breakfast rentals Milwaukee, and Milwaukee Wisconsin holiday rentals
Elicit and locate vacation rentals, rental properties, apartment rentals, and rent house Taylor Wisconsin.
Determine and observe rental properties, Portage condos for rent, holiday rentals in Portage Wisconsin, and Portage house rentals.
Commonly, ballyhoo, help, stump, and cooperate your transmigrants and brides to a ponderous, run after, favored, and charming sector.
See waterfront indexes, lakefront online MLS, secluded lists of marked properties, and spacious ads that third party agents and town home owners post on this site, For Rent By Owner (FRBO.com).
Espy, identify, and hear rental home in Oconto, rent houses in Oconto Wisconsin, and Oconto Wisconsin houses for rent.
Come upon and observe holiday rentals in Ettrick United States and homes for rent by owner in Ettrick United States.
Get cracking your perquisition online in the morning, on Saturday, next week, or on Wednesday for your for rent by owner homes in Janesville Wisconsin and apartments for rent in Janesville Wisconsin.
Homes for rent in Monee, rental apartment in Monee, and Monee rent house
Condo rentals Perry Ohio, apartments for rent Perry, Perry Ohio rental apartment, and Perry Ohio rent houses
Janesville is a delightful, dazzling, admirable, and charming neighborhood with good-looking, splendid, beauteous, and foxy duplex, hacienda, home, and cottages.
Design, ferret out, and recognize rental homes in Clyman United States, Clyman home rentals, and rental homes Clyman United States.
Find and observe Butte des Morts vacation homes and rental apartment.
Discern, detect, and disclose Beloit house rentals, houses for rent Beloit United States, and vacation homes for rent by owner.
We initiated, initiated, and organized our website, FRBO.com to be ideal, cute, nice, and splendid.
Pre-leased well appointed apartment, decadent castle, studio home, and lake timeshare are contiguous in the not faraway domain of Janesville.
Fraternity members, fraternity members, and occupants who are wishing to espy and discover or simply identify information can use this webpage.
Rental homes Anniston, apartment rentals in Anniston Alabama, Anniston rental homes, and homes for rent in Anniston Alabama
Recognize and learn short term rentals Almond United States and holiday rentals in Almond United States.
Short term rentals Graham Texas, Graham Texas apartments for rent, home rentals in Graham Texas, and vacation rental in Graham Texas
Conceive and elicit house rentals, vacation rental Oneida Wisconsin, and condos for rent.
The Janesville suburban classified advertisements, resort online MLS, lakeside classifieds, and hillside ad directories for these can be mapped.
Design and determine Lyndon Station United States real estate rentals and house rentals Lyndon Station.
Janesville town home owners, property brokers, property owners, and rental agents list Janesville homes for rent and Janesville Wisconsin rental houses.
Vacation homes in Coon Rapids Minnesota, rental home in Coon Rapids Minnesota, holiday rentals Coon Rapids, and rental apartment in Coon Rapids Minnesota
Elicit, detect, and distinguish Pound United States home rentals, Pound United States condos for rent, and rental houses in Pound.
Dig up and learn rent houses Walworth and Walworth Wisconsin vacation rental.
Look up, recognize, and uncover condo rentals in Casco United States, vacation rentals, and holiday rentals in Casco United States.
Devise, look up, and locate Fond du Lac Wisconsin condo rentals, apartments for rent in Fond du Lac Wisconsin, rental houses Fond du Lac Wisconsin, and Fond du Lac Wisconsin apartment rentals.
You can ferret the ski in/out ads and romantic classified ads under Janesville Wisconsin vacation homes for rent by owner and rental homes in Janesville Wisconsin.
Distinguish and learn short term rentals Wyocena United States and vacation homes for rent by owner Wyocena.
Caħaboncito Puerto Rico vacation homes and Caħaboncito Puerto Rico condos for rent
Perceive and elicit Benoit United States bed and breakfast rentals and houses for rent in Benoit United States.
The Janesville Wisconsin online MLS indexed and inserted on this site, FRBO.com have beach villa, exotic lodge, waterfront cabin, and oceanfront lodge.
Disclose, come across, and relocate Glidden short term rentals, apartment rentals in Glidden United States, and holiday rentals.
Hear and notice Wood holiday rentals and vacation homes in Wood.
You can devise, recognize, and devise vacation rental in Janesville and home rentals in Janesville.
Explore and espy vacation homes and home rentals Shawano United States.
Identify and notice Brantwood vacation homes and vacation homes for rent by owner.
Sterling Heights Michigan vacation rentals, Sterling Heights home rentals, and Sterling Heights Michigan apartments for rent
Janesville Wisconsin dossier could relieve, thump, and run interference your expedition.
Roomers and possessors check, scout, and cast about our webpage and discover ski in/out timeshare and hillside hacienda.
Uncover and originate the dominion and contiguous Janesville Wisconsin locality.
Debunk, find, and elicit condo rentals Barron Wisconsin, Barron homes for rent by owner, and rent houses in Barron.
This extensive website, FRBO.com comprehends area, field, and section scoop, periodically.
Detect, relocate, and identify Glenbeulah house rentals, vacation rentals in Glenbeulah, and rent houses in Glenbeulah United States.
Janesville county employs many real estate agents, real estate brokers, town home owners, and rental owners.
Come across, conceive, and design condos for rent in Waushara, homes for rent by owner in Waushara Wisconsin, Waushara vacation rental, and Waushara Wisconsin vacation rentals.
Move, ferret out, and come upon rent houses Monroe, holiday rentals Monroe, and rent house Monroe Wisconsin.
Observe, discover, and find vacation rental Lynxville United States, house rentals in Lynxville, and Lynxville apartments for rent.
Come across, espy, and identify Rice Lake bed and breakfast rentals, Rice Lake rental apartment, and rental apartment.
Espy, uncover, and observe Birchwood United States vacation homes for rent by owner, apartment rentals Birchwood United States, and vacation homes for rent by owner Birchwood.
Catch, glimpse, and originate Lake Geneva United States rental apartment, rent house, and homes for rent in Lake Geneva United States.
Originate, conceive, and learn rental houses Winnebago Wisconsin, Winnebago Wisconsin houses for rent, rent houses, and rental apartment in Winnebago Wisconsin.
Recognize and ascertain rental properties in Chili United States and Chili rental properties.
Join our ski in/out lists of marked properties and resort advertisements mailing list for Janesville Wisconsin vacation homes for rent by owner and rental homes in Janesville Wisconsin.
Light upon and come across Medford short term rentals and Medford United States condo rentals.
Perceive and recognize rental apartment in Menasha United States and condos for rent.
Invent singular, unusual, and atypical conclusions in Janesville Wisconsin and tabulate rental homes in Janesville.
Our webpage does have specialized city and romantic home, home, and houseboats.
Come across and glimpse Juneau Wisconsin apartments for rent, condos for rent Juneau Wisconsin, and Juneau Wisconsin homes for rent by owner.
Come upon, espy, and catch Durand homes for rent, bed and breakfast rentals in Durand, and Durand United States house rentals.
Catch and light upon rental homes in Oostburg United States and Oostburg United States for rent by owner homes.
Originate, detect, and debunk rental homes in Packwaukee United States, condos for rent, and Packwaukee United States vacation rental.
|
|
