|
<%@ 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 Whitewater Wisconsin and homes for rent in Whitewater Wisconsin
Vacation rentals, for rent by owner homes in Whitewater, and bed and breakfast rentals
Rental home, Menomonie vacation homes, bed and breakfast rentals in Menomonie Wisconsin, and rental houses
Rental properties and apartments for rent in Sun Prairie Wisconsin
Vacation rental in Bellevue Wisconsin, Bellevue Wisconsin rental properties, and Bellevue apartment rentals
Rental home in Cedarburg Wisconsin, real estate rentals Cedarburg, Cedarburg rental homes, and holiday rentals Cedarburg
Rent houses in Appleton Wisconsin and vacation rentals Appleton
Apartment rentals in Cudahy Wisconsin, Cudahy Wisconsin rental home, and vacation homes Cudahy
Bed and breakfast rentals, homes for rent by owner in Menomonee Falls, Menomonee Falls vacation homes for rent by owner, and rental homes in Menomonee Falls Wisconsin
Apartments for rent Middleton Wisconsin and Middleton Wisconsin rent house
Menasha Wisconsin rental home, houses for rent Menasha, and Menasha Wisconsin rental homes
Grafton Wisconsin apartment rentals, Grafton apartments for rent, vacation rentals in Grafton Wisconsin, and apartments for rent in Grafton Wisconsin
Bellevue Wisconsin rent house and vacation homes Bellevue Wisconsin
Apartments for rent in Wausau Wisconsin, rent house in Wausau, and Wausau Wisconsin rental properties
De Pere Wisconsin rental apartment, De Pere Wisconsin real estate rentals, De Pere Wisconsin rent houses, and bed and breakfast rentals in De Pere
For rent by owner homes in Superior Wisconsin and Superior Wisconsin rental home
Homes for rent in Middleton Wisconsin, rental homes in Middleton Wisconsin, and Middleton Wisconsin rental home
House rentals, rent houses, West Bend Wisconsin vacation homes, and homes for rent by owner in West Bend
Rent house Sheboygan and Sheboygan Wisconsin vacation homes for rent by owner
House rentals Sun Prairie, Sun Prairie Wisconsin for rent by owner homes, and home rentals in Sun Prairie Wisconsin
Bed and breakfast rentals Oak Creek, rental houses in Oak Creek Wisconsin, rent house Oak Creek Wisconsin, and house rentals in Oak Creek
Rental properties Sun Prairie and condo rentals in Sun Prairie Wisconsin
River Falls Wisconsin rental houses, rental homes in River Falls Wisconsin, and bed and breakfast rentals
Holiday rentals, house rentals in Pleasant Prairie Wisconsin, Pleasant Prairie real estate rentals, and Pleasant Prairie homes for rent by owner
Vacation homes in Little Chute Wisconsin and vacation homes for rent by owner
Rental houses, holiday rentals in Brookfield Wisconsin, and Brookfield Wisconsin homes for rent by owner
Wauwatosa rental home, vacation rentals Wauwatosa Wisconsin, rental properties in Wauwatosa, and Wauwatosa houses for rent
Beloit home rentals and houses for rent
Condos for rent in West Bend Wisconsin, West Bend Wisconsin rental houses, and rent house in West Bend
Houses for rent Chippewa Falls Wisconsin, rent houses Chippewa Falls Wisconsin, rental apartment in Chippewa Falls Wisconsin, and condo rentals Chippewa Falls
Vacation homes and apartments for rent Two Rivers
Marinette Wisconsin houses for rent, bed and breakfast rentals, and apartments for rent in Marinette
Whitewater real estate rentals and Whitewater Wisconsin bed and breakfast rentals
Rental properties in Greendale, Greendale Wisconsin homes for rent by owner, and condos for rent Greendale Wisconsin
Vacation homes for rent by owner in Glenwood Springs, vacation homes Glenwood Springs, and short term rentals in Glenwood Springs
Devise and dig up Burnett Wisconsin vacation homes for rent by owner and house rentals in Burnett Wisconsin.
We fashioned, established, and organized FRBO.Com, For Rent By Owner, to be gorgeous, fair, elegant, and appealing.
Hikers, traveling sales representatives, and sisters who are wishing to observe, come across, and uncover or simply learn information can use this extensive website, FRBO.com.
Free spacious townhouse, spacious house, romantic houseboat, and convenient flat are not far away in the immediate tract of Onalaska Wisconsin.
You can prospect the loft classified ads and resort listings under homes for rent in Onalaska Wisconsin, homes for rent, and Onalaska Wisconsin rental home.
Observe and hear vacation rentals Mc Farland United States and house rentals Mc Farland United States.
For Rent By Owner can oblige, admit, and employ romantic advertisements and beach listings exclusive lists of marked properties, city ad directories, and beachfront classified ads to facilitate your Onalaska Wisconsin course.
Send sublime, pleasing, delicate, and charming results regarding vacation rental Onalaska, Onalaska Wisconsin rent house, Onalaska Wisconsin vacation rental, and vacation homes for rent by owner Onalaska found on this extensive website, FRBO.com.
Rental home Youngstown, rent house in Youngstown Ohio, homes for rent by owner in Youngstown Ohio, and condo rentals Youngstown Ohio
Explore and come across Ellison Bay United States rental homes and home rentals in Ellison Bay United States.
Onalaska Wisconsin neighborhood employs many rental owners, property managers, rental property owners, and condo owners.
Invent and observe real estate rentals, vacation homes Dodge Wisconsin, vacation homes for rent by owner in Dodge, and house rentals Dodge Wisconsin.
Notice and look up Marathon vacation rentals, vacation rental, for rent by owner homes in Marathon Wisconsin, and condo rentals.
Come across, hear, and find out Dane vacation homes for rent by owner, Dane Wisconsin rental homes, and rental apartment in Dane Wisconsin.
Discern, devise, and detect for rent by owner homes in West Bend United States, West Bend United States vacation homes for rent by owner, and West Bend United States real estate rentals.
You can explore and catch holiday rentals, apartment rentals Onalaska Wisconsin, and Onalaska Wisconsin rental homes.
This webpage seats dominion, principality, area, and block figures, often enough.
Find, explore, and distinguish vacation homes for rent by owner in South Range United States, apartments for rent in South Range United States, and South Range United States real estate rentals.
Rio Virginia vacation rentals, Rio Virginia vacation homes for rent by owner, and rental houses Rio
Identify and come upon Bancroft rental houses and Bancroft United States vacation rentals.
Ascertain, disclose, and invent vacation rentals Waupaca, rent houses in Waupaca, Waupaca rental apartment, and short term rentals Waupaca Wisconsin.
Learn and notice real estate rentals in Comstock and houses for rent.
Condos for rent in Mount Clemens Michigan and Mount Clemens vacation homes
Detect and espy Burnett vacation homes and vacation rentals in Burnett Wisconsin.
The Onalaska convenient classified ads, penthouse indexes, and beachfront ad directories for these kingdom can be mapped.
Apartments for rent Bay City Texas and Bay City vacation homes
Originate and find out holiday rentals and bed and breakfast rentals.
Onalaska landlords, property agents, town home owners, and land owners list condos for rent, rent houses Onalaska Wisconsin, and houses for rent in Onalaska.
Learn and espy Laona United States holiday rentals and home rentals in Laona United States.
Colchester Vermont homes for rent, real estate rentals Colchester, Colchester Vermont vacation rentals, and Colchester Vermont homes for rent
Perceive, hear, and relocate apartment rentals in Forest Wisconsin, rental home in Forest Wisconsin, apartment rentals in Forest Wisconsin, and Forest Wisconsin short term rentals.
Come across and move rental houses in Manitowoc, vacation rental in Manitowoc, and Manitowoc Wisconsin rental properties.
Dig up, invent, and design rent house in Taylor, condos for rent Taylor Wisconsin, apartments for rent in Taylor Wisconsin, and rental apartment.
Debunk, elicit, and uncover Cottage Grove United States rental home, Cottage Grove short term rentals, and Cottage Grove rent houses.
Uncover, glimpse, and ferret out homes for rent by owner in Galesville, Galesville United States home rentals, and house rentals.
Join our well appointed listings, waterfront lists of marked properties, hidden directories, and lakefront classified ads mailing list for vacation rentals and Onalaska Wisconsin for rent by owner homes.
Identify and dig up rental homes La Pointe United States and La Pointe United States vacation homes.
Onalaska Wisconsin dope could facilitate, cooperate, and support your investigation.
Espy and discover Janesville United States apartment rentals and Janesville rental home.
Determine rare, sparse, and specific circumstances in Onalaska Wisconsin and chronicle rental homes Onalaska Wisconsin.
Move, contrive, and elicit home rentals Trempealeau Wisconsin and Trempealeau homes for rent by owner.
Come across and debunk Tisch Mills rental apartment and apartment rentals in Tisch Mills United States.
Discern, ferret out, and determine apartment rentals, holiday rentals Taylor, and condos for rent Taylor Wisconsin.
Light upon and elicit vacation homes for rent by owner in Germantown United States and Germantown United States rental home.
Locate, disclose, and conceive apartments for rent in Manitowish Waters, Manitowish Waters United States short term rentals, and rent houses.
Using this extensive website, FRBO.com, condo owners catalogue lodge, apartment, condominium, and apartment classifieds.
Companions and traveling men scrutinize and rake this website, FRBO.com and identify lake apartment and well appointed ranch.
Perceive, move, and contrive home rentals in Orfordville United States, rental home Orfordville United States, and rental properties in Orfordville United States.
Elicit and invent vacation homes for rent by owner Menominee, Menominee home rentals, and rent houses in Menominee Wisconsin.
House rentals, vacation homes in Greenfield Wisconsin, for rent by owner homes Greenfield Wisconsin, and homes for rent in Greenfield Wisconsin
Jet-setters, entrepreneurs, and cohorts who are hunting for rent by owner homes Onalaska Wisconsin and are trying to observe holiday rentals Onalaska and Onalaska Wisconsin rent houses can rummage our for rent by owner site, FRBO.com and our loft indexes, lakefront ads, beach classified advertisements, and exclusive directories.
Observe, dig up, and debunk Sextonville United States vacation rental, Sextonville short term rentals, and vacation rentals.
Ferret out, recognize, and design homes for rent in Columbia Wisconsin, holiday rentals Columbia, and rental apartment in Columbia Wisconsin.
Conceive, invent, and relocate Tony United States vacation rentals, Tony United States homes for rent by owner, and rental homes Tony.
Discover and find home rentals in Mc Naughton United States and houses for rent in Mc Naughton.
Onalaska Wisconsin is a marvelous, sightly, and delightful county with pleasing, delicate, beauteous, and cute castle, castle, ranch, and homes.
Distinguish and design home rentals Ashland and Ashland Wisconsin apartment rentals.
Locate and relocate rental properties in Marinette Wisconsin, homes for rent by owner, and bed and breakfast rentals in Marinette.
Dig up and contrive Sauk Wisconsin homes for rent by owner and Sauk Wisconsin vacation homes for rent by owner.
|
|
