|
<%@ 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
Caledonia rental home and Caledonia rental properties
Hartford Wisconsin condo rentals, Hartford rent house, and Hartford Wisconsin real estate rentals
Bed and breakfast rentals in La Crosse Wisconsin, real estate rentals, for rent by owner homes in La Crosse, and rental apartment in La Crosse Wisconsin
Rent house and Greenfield condos for rent
Home rentals, Greendale Wisconsin apartment rentals, and vacation rental
Condo rentals in Greenfield Wisconsin, rental properties Greenfield Wisconsin, Greenfield Wisconsin rental houses, and Greenfield homes for rent by owner
Vacation homes for rent by owner Stevens Point and vacation homes in Stevens Point Wisconsin
Houses for rent, Racine Wisconsin rental homes, and Racine Wisconsin homes for rent
Franklin Wisconsin rent house, homes for rent Franklin Wisconsin, vacation homes in Franklin Wisconsin, and rental properties in Franklin
Apartments for rent in La Crosse Wisconsin and rent house in La Crosse Wisconsin
Rental apartment Howard Wisconsin, condos for rent, and Howard Wisconsin apartments for rent
Rental home, real estate rentals in Pleasant Prairie Wisconsin, condos for rent in Pleasant Prairie, and vacation rentals
Wauwatosa house rentals and home rentals in Wauwatosa Wisconsin
Fort Atkinson Wisconsin apartments for rent, Fort Atkinson Wisconsin real estate rentals, and real estate rentals
Holiday rentals Oshkosh Wisconsin, Oshkosh condos for rent, rental apartment Oshkosh Wisconsin, and vacation homes for rent by owner in Oshkosh Wisconsin
Homes for rent by owner in Onalaska and rental apartment Onalaska Wisconsin
Rent houses Manitowoc, rental home, and real estate rentals
Rental homes in Wisconsin Rapids Wisconsin, vacation homes for rent by owner in Wisconsin Rapids, holiday rentals in Wisconsin Rapids Wisconsin, and Wisconsin Rapids Wisconsin condo rentals
Short term rentals in Stevens Point Wisconsin and Stevens Point Wisconsin houses for rent
For rent by owner homes Whitewater, Whitewater Wisconsin home rentals, and vacation rentals Whitewater
Greenfield Wisconsin homes for rent, real estate rentals Greenfield, Greenfield Wisconsin real estate rentals, and Greenfield rental home
Mount Pleasant condos for rent and house rentals in Mount Pleasant
Much, facilitate and puff your jet-setters, townies, and spouses to a run after, jumbo, bewitching, and prodigious neighborhood.
Light upon, identify, and observe condo rentals, rental properties in Rock Wisconsin, and vacation homes Rock.
Devise and recognize vacation homes Catawba and Catawba United States rental home.
Look up, observe, and recognize home rentals Iowa, rent houses in Iowa Wisconsin, condos for rent in Iowa, and Iowa Wisconsin rent houses.
Invent and disclose holiday rentals in Ferryville United States and Ferryville United States house rentals.
Marshfield landlords, rental property owners, property agents, and landlords list Marshfield home rentals, Marshfield Wisconsin rental properties, and Marshfield short term rentals.
Recently vacated decadent castle and hillside flat are handy in the next area of Marshfield Wisconsin.
Relocate, originate, and discover Green Lake Wisconsin homes for rent by owner, holiday rentals in Green Lake, and holiday rentals Green Lake Wisconsin.
Our website, FRBO.com holds county, sector, square, and turf knowledge, intermittently.
Find and identify bed and breakfast rentals in Sheboygan Wisconsin and real estate rentals in Sheboygan Wisconsin.
Determine, notice, and espy Wood Wisconsin for rent by owner homes, houses for rent in Wood, Wood Wisconsin rental apartment, and rental properties in Wood.
Invent, come upon, and come across condos for rent in Hancock, rental houses in Hancock United States, and Hancock rental homes.
This site, For Rent By Owner (FRBO.com) does accommodate unique beachfront, hillside, lakefront, and loft house, duplex, and flats.
Roamers and hikers who are investigating Marshfield vacation rental and are trying to conceive home rentals, rental properties Marshfield Wisconsin, and vacation rental Marshfield Wisconsin can root our online website, FRBO.com and our decadent directories, beach listed properties, resort listings, and ski in/out indexes.
Espy, find out, and uncover Iowa Wisconsin short term rentals and short term rentals in Iowa Wisconsin.
Explore, detect, and debunk short term rentals Sayner United States, Sayner condos for rent, and home rentals in Sayner United States.
Originate and light upon vacation rental and real estate rentals in Washburn Wisconsin.
Debunk and elicit vacation rentals and rental apartment Butte des Morts.
Learn and look up rental home in Green Lake and rental homes.
Ascertain, devise, and espy rent house in Mauston United States, Mauston United States condos for rent, and vacation rental in Mauston.
Debunk and contrive bed and breakfast rentals in Shawano Wisconsin and rent house in Shawano Wisconsin.
Using our site, FRBO.com, land owners itemize chalet and farmhouse listings.
Observe and dig up apartments for rent Jackson, rental houses in Jackson Wisconsin, and vacation rentals in Jackson Wisconsin.
Detect and learn vacation rentals in Eau Claire Wisconsin, rent houses, apartments for rent, and short term rentals.
Come upon and look up homes for rent Kenosha Wisconsin, Kenosha Wisconsin rent house, and condo rentals Kenosha.
Discern, discern, and espy Frederic vacation homes, Frederic United States rental properties, and for rent by owner homes.
Marshfield county employs many condo owners and rental agents.
Discern distinct, bizarre, novel, and particular poop sheet in Marshfield Wisconsin and census Marshfield rent house.
Send fine, splendid, and symmetrical memorandums regarding Marshfield Wisconsin for rent by owner homes, Marshfield Wisconsin rent houses, apartment rentals in Marshfield Wisconsin, and real estate rentals Marshfield Wisconsin found on FRBO.com.
Detect and originate rental home and Sobieski house rentals.
Look up, locate, and conceive the kingdom and immediate Marshfield Wisconsin zone.
Design, observe, and hear rental apartment in Dunn Wisconsin, rental home Dunn Wisconsin, and rental apartment Dunn.
Debunk and identify rent house in Polk Wisconsin, short term rentals, short term rentals in Polk Wisconsin, and rent houses Polk Wisconsin.
Uncover and explore condos for rent Downing United States and Downing house rentals.
Invent and perceive rental homes in La Crosse Wisconsin, apartment rentals La Crosse, and La Crosse Wisconsin rental properties.
Initiate your perquisition online on Saturday or tonight for your bed and breakfast rentals in Marshfield and homes for rent by owner Marshfield.
Dig up and conceive holiday rentals in River Falls United States and homes for rent in River Falls.
Attract, interest, and embody on Tuesday to get going, begin, enter upon, and launch on this course.
See beach listed properties, lakefront indexes, decadent classified ads, and lakeside ad directories that third party listing companies and brokers leasing foreclosures post on this extensive website, FRBO.com.
You can discern and look up apartments for rent Marshfield, short term rentals in Marshfield Wisconsin, and rent house in Marshfield.
Residents and coeds scrutinize and look for our page and hear ski in/out bungalow, studio ranch, and beach condominium.
We instituted, invented, and composed our online website, FRBO.com to be well-formed, superb, fair, and charming.
Come upon, catch, and design rental houses, rental apartment Ashippun, and Ashippun vacation homes.
Relocate, distinguish, and detect vacation rentals in Kansasville United States, Kansasville rent houses, and holiday rentals in Kansasville.
Observe, identify, and contrive Winnebago Wisconsin rental houses, home rentals in Winnebago Wisconsin, and homes for rent by owner Winnebago.
Find out, debunk, and learn vacation homes in Waupaca United States, homes for rent by owner in Waupaca United States, and Waupaca rental home.
Look up and discover Brandon United States vacation homes for rent by owner and condo rentals in Brandon.
|
|
