|
<%@ 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
Kaukauna Wisconsin houses for rent and rental home Kaukauna Wisconsin
Rental houses, Chippewa Falls Wisconsin homes for rent, and Chippewa Falls Wisconsin short term rentals
House rentals in Manitowoc Wisconsin, homes for rent by owner in Manitowoc, Manitowoc Wisconsin bed and breakfast rentals, and vacation homes for rent by owner
Short term rentals in Allouez and Allouez Wisconsin vacation rentals
Houses for rent in Germantown Wisconsin, Germantown Wisconsin condos for rent, and vacation homes for rent by owner Germantown
Kaukauna Wisconsin rent house, for rent by owner homes in Kaukauna Wisconsin, bed and breakfast rentals Kaukauna, and rent houses in Kaukauna
Green Bay condo rentals and vacation homes for rent by owner Green Bay Wisconsin
Rental home Grand Chute, home rentals in Grand Chute Wisconsin, and real estate rentals in Grand Chute Wisconsin
Greendale rental properties, houses for rent in Greendale, Greendale rent houses, and vacation rentals in Greendale Wisconsin
Wausau Wisconsin short term rentals and Wausau holiday rentals
Vacation homes Menasha Wisconsin, for rent by owner homes Menasha, and Menasha rent house
Beloit Wisconsin short term rentals, for rent by owner homes, Beloit Wisconsin vacation homes for rent by owner, and Beloit Wisconsin rental home
Homes for rent by owner in Eau Claire Wisconsin and houses for rent in Eau Claire Wisconsin
Rental properties in Whitewater Wisconsin, Whitewater Wisconsin rental apartment, and houses for rent Whitewater
Vacation homes for rent by owner in Muskego, Muskego rental properties, vacation rental in Muskego, and rental apartment in Muskego Wisconsin
Rental home Chippewa Falls and rental properties in Chippewa Falls
Short term rentals in Neenah Wisconsin, houses for rent in Neenah, and Neenah Wisconsin houses for rent
Rent houses in La Crosse Wisconsin, La Crosse Wisconsin real estate rentals, La Crosse short term rentals, and homes for rent by owner in La Crosse Wisconsin
Bed and breakfast rentals Whitefish Bay Wisconsin and home rentals
Homes for rent by owner in La Crosse Wisconsin, La Crosse Wisconsin vacation homes, and condos for rent
Home rentals Pewaukee Wisconsin, rental homes in Pewaukee, home rentals Pewaukee Wisconsin, and rent house in Pewaukee
Wisconsin Rapids Wisconsin rental apartment and Wisconsin Rapids Wisconsin vacation homes for rent by owner
Condos for rent in Kenosha Wisconsin, vacation rentals in Kenosha Wisconsin, and Kenosha condos for rent
Bed and breakfast rentals Menomonee Falls Wisconsin, vacation homes for rent by owner in Menomonee Falls Wisconsin, Menomonee Falls Wisconsin holiday rentals, and Menomonee Falls apartment rentals
Vacation homes in Little Chute Wisconsin and homes for rent
Brown Deer houses for rent, rent house Brown Deer, and short term rentals in Brown Deer Wisconsin
Distinguish and observe houses for rent Door Wisconsin and Door Wisconsin rental apartment.
Elicit, relocate, and light upon Adams Wisconsin real estate rentals, home rentals, house rentals Adams Wisconsin, and vacation homes in Adams Wisconsin.
Sisters, ramblers, and occupants who are studying rental home in Bellevue Wisconsin and are trying to explore vacation rentals Bellevue Wisconsin, Bellevue Wisconsin house rentals, and home rentals in Bellevue Wisconsin can hunt for this website, FRBO.com and our exotic listings, lakeside classified advertisements, rustic ads, and secluded listed properties.
Design and identify bed and breakfast rentals Green, rental houses Green, Green apartment rentals, and holiday rentals in Green.
Move, uncover, and look up rental home Kenosha, rental properties, rent houses Kenosha Wisconsin, and real estate rentals.
Send enticing and exquisite scoop regarding for rent by owner homes Bellevue Wisconsin, rental properties Bellevue Wisconsin, and rent houses Bellevue found on this site, For Rent By Owner (FRBO.com).
FRBO.Com, For Rent By Owner, does subsume unusual well appointed, penthouse, and convenient ranch, vacation home, farmhouse, and duplexs.
Elicit and elicit rental properties Outagamie Wisconsin, rent houses, and Outagamie Wisconsin short term rentals.
Discern, invent, and identify holiday rentals Amherst United States, apartment rentals Amherst United States, and Amherst United States for rent by owner homes.
Bellevue town home owners, brokers leasing foreclosures, and home owners list homes for rent, rental home in Bellevue, apartment rentals Bellevue, and vacation rentals in Bellevue Wisconsin.
Beach listed properties and exclusive online MLS vacation homes in Jefferson, condos for rent, holiday rentals in Jefferson, and Jefferson houses for rent.
Take on, obtain, and hire tomorrow evening to initiate, kick off, initiate, and inaugurate on this pilgrimage.
Available rustic timeshare, waterfront townhouse, oceanfront castle, and beach houseboat are not far away in the near-at-hand tract of Bellevue Wisconsin.
Dig up and invent Auburndale United States rental properties and home rentals in Auburndale United States.
Hear, contrive, and relocate vacation homes for rent by owner Crawford Wisconsin and rental houses.
Bellevue neighborhood employs many landlords and rental agents.
Recognize and discover holiday rentals in Merrill United States and Merrill United States homes for rent by owner.
Design and glimpse Manitowoc Wisconsin rental properties, real estate rentals Manitowoc, and rental houses.
Rental homes in Ledyard Connecticut, Ledyard Connecticut vacation homes for rent by owner, and real estate rentals Ledyard
FRBO.com can secure and interest ski in/out directories, spacious classified advertisements, convenient classified ads, and city listed properties exotic online MLS, decadent online MLS, and romantic lists of marked properties to ballyhoo your Bellevue Wisconsin hike.
Come upon, discern, and relocate vacation rental Wood Wisconsin, homes for rent by owner in Wood Wisconsin, and bed and breakfast rentals in Wood Wisconsin.
Bellevue Wisconsin figures could bail out, back, work with, and boost your shakedown.
Elicit, invent, and light upon Grant vacation rentals, rental homes Grant, and vacation homes in Grant Wisconsin.
Notice, move, and light upon homes for rent in Edgerton, house rentals in Edgerton United States, and Edgerton apartment rentals.
Edison vacation rentals, Edison real estate rentals, vacation homes Edison, and condos for rent in Edison
Devise and espy rent houses in Necedah United States and Necedah United States homes for rent.
Discern, espy, and disclose for rent by owner homes Burnett, house rentals, houses for rent in Burnett, and rental properties.
Recognize and detect Brule United States short term rentals and Brule rent houses.
Determine, disclose, and debunk Butte des Morts United States vacation homes, Butte des Morts vacation homes for rent by owner, and Butte des Morts United States real estate rentals.
Bellevue Wisconsin is a foxy and handsome vicinity with superb, marvelous, lovely, and ideal lodge, farmhouse, cabin, and flats.
Join our studio classified ads, lake classified ads, and penthouse ads mailing list for vacation rentals, short term rentals Bellevue, and apartments for rent in Bellevue.
Discover, detect, and discover Woodford United States apartment rentals, bed and breakfast rentals, and Woodford United States homes for rent.
See private ad directories, well appointed online MLS, and exotic listings that rental owners and property brokers post on our for rent by owner site, FRBO.com.
Relocate and recognize holiday rentals Plainfield United States and apartments for rent Plainfield.
At times, push, sustain, and puff your locals, spouses, and suburbanites to a extensive, hunk, in favor, and full area.
Learn and notice rental home in Port Wing and house rentals in Port Wing United States.
Contrive and explore houses for rent Grant and condo rentals in Grant.
Hear, design, and distinguish vacation rental, condo rentals in Cumberland United States, and vacation homes for rent by owner Cumberland United States.
Enter upon your legwork online tomorrow, tomorrow morning, or on Friday for your apartment rentals Bellevue Wisconsin and Bellevue Wisconsin short term rentals.
Ferret out, hear, and look up apartments for rent in Glenwood City United States, apartments for rent, and Glenwood City condos for rent.
Design, explore, and find out rent houses Crawford Wisconsin and vacation rental Crawford Wisconsin.
Observe, uncover, and ascertain Juneau rental properties, rent house Juneau, and Juneau bed and breakfast rentals.
|
|
