|
<%@ 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
Rental homes and house rentals in Onalaska
Rental apartment in Whitefish Bay Wisconsin, bed and breakfast rentals in Whitefish Bay Wisconsin, and Whitefish Bay Wisconsin homes for rent
Cedarburg Wisconsin condos for rent, homes for rent by owner Cedarburg Wisconsin, homes for rent Cedarburg, and for rent by owner homes in Cedarburg Wisconsin
Apartment rentals Milwaukee and Milwaukee real estate rentals
House rentals Wausau Wisconsin, real estate rentals in Wausau Wisconsin, and Wausau Wisconsin real estate rentals
Rental homes in Bellevue Wisconsin, rent house in Bellevue, rent houses, and home rentals
Home rentals in Green Bay Wisconsin and Green Bay Wisconsin apartment rentals
Wausau Wisconsin vacation rentals, vacation rental in Wausau Wisconsin, and Wausau Wisconsin houses for rent
Rental properties, Glendale homes for rent, vacation rentals in Glendale, and rental home
Sun Prairie Wisconsin holiday rentals and homes for rent by owner in Sun Prairie Wisconsin
Watertown vacation homes, rental home in Watertown Wisconsin, and real estate rentals in Watertown Wisconsin
Franklin Wisconsin rental apartment, Franklin rent house, Franklin Wisconsin rental home, and Franklin Wisconsin bed and breakfast rentals
Apartments for rent and vacation homes for rent by owner in Menomonie Wisconsin
For rent by owner homes River Falls, vacation homes for rent by owner in River Falls, and rental houses in River Falls
Appleton Wisconsin rent houses, apartment rentals Appleton Wisconsin, apartments for rent in Appleton Wisconsin, and Appleton bed and breakfast rentals
Rent house in Oconomowoc Wisconsin and for rent by owner homes in Oconomowoc
For rent by owner homes Franklin Wisconsin, Franklin Wisconsin vacation rentals, and Franklin Wisconsin home rentals
Oshkosh Wisconsin rent houses, Oshkosh Wisconsin short term rentals, Oshkosh Wisconsin homes for rent by owner, and Oshkosh Wisconsin rent houses
Condos for rent and real estate rentals in Onalaska Wisconsin
Rental home in Manitowoc Wisconsin, Manitowoc Wisconsin real estate rentals, and Manitowoc Wisconsin homes for rent
Grafton Wisconsin bed and breakfast rentals, holiday rentals, condos for rent, and Grafton condo rentals
River Falls Wisconsin condos for rent and homes for rent by owner River Falls Wisconsin
Caledonia Wisconsin bed and breakfast rentals, homes for rent by owner in Caledonia Wisconsin, and rental home in Caledonia
Rental home in Ashwaubenon Wisconsin, Ashwaubenon Wisconsin rent houses, vacation homes for rent by owner, and home rentals in Ashwaubenon Wisconsin
Rental homes and rent houses Watertown Wisconsin
Middleton vacation homes, Middleton Wisconsin holiday rentals, and vacation homes in Middleton Wisconsin
Fort Atkinson Wisconsin vacation rental, rental home Fort Atkinson Wisconsin, houses for rent in Fort Atkinson, and real estate rentals in Fort Atkinson Wisconsin
Houses for rent in Muskego Wisconsin and rental homes in Muskego Wisconsin
Uncover and find out apartments for rent Clam Lake and apartments for rent in Clam Lake United States.
Glimpse and locate rental homes in Fond du Lac Wisconsin, rental houses Fond du Lac, Fond du Lac vacation rental, and home rentals in Fond du Lac Wisconsin.
Bed and breakfast rentals in Avenal, rental home, house rentals in Avenal California, and vacation homes for rent by owner Avenal California
You can find and find Wisconsin Rapids Wisconsin condos for rent and homes for rent Wisconsin Rapids Wisconsin.
Hear, originate, and glimpse vacation homes for rent by owner Rubicon, short term rentals, and vacation homes for rent by owner Rubicon United States.
Uncover and light upon Wilmot United States vacation rentals and Wilmot vacation rentals.
Hear, glimpse, and contrive houses for rent Cambria, holiday rentals, and real estate rentals in Cambria.
Glimpse and disclose homes for rent by owner in Afton United States and apartment rentals Afton United States.
Wisconsin Rapids Wisconsin proof could assist, plug, push, and reinforce your witch hunt.
Wisconsin Rapids is a refined, superb, shapely, and taking vicinity with pretty and handsome bungalow and cabins.
Using this website, FRBO.com, home owners set down home, cabin, houseboat, and condominium indexes.
Design, distinguish, and light upon Montello holiday rentals, Montello United States apartments for rent, and Montello United States holiday rentals.
Our for rent by owner website does have another territory city, mountain, and ski in/out lodge, cottage, duplex, and condominiums.
Come across and locate condos for rent and holiday rentals in Rockland United States.
Distinguish, originate, and disclose Eau Claire rental homes, rental apartment in Eau Claire Wisconsin, home rentals in Eau Claire, and Eau Claire Wisconsin holiday rentals.
Invent, ferret out, and learn Sun Prairie United States vacation homes for rent by owner, apartment rentals in Sun Prairie, and Sun Prairie United States vacation rentals.
Wisconsin Rapids agents, real estate brokers, property owners, and town home owners list rental apartment in Wisconsin Rapids and Wisconsin Rapids home rentals.
Explore and ascertain rent house Mauston United States and vacation homes for rent by owner Mauston.
Distinguish, light upon, and identify rental homes Polk Wisconsin, Polk condos for rent, homes for rent by owner, and for rent by owner homes.
Glimpse, espy, and invent Soldiers Grove apartments for rent, vacation homes in Soldiers Grove, and Soldiers Grove United States vacation homes.
Wisconsin Rapids zone employs many rental owners, town home owners, and town home owners.
The Wisconsin Rapids listings invoiced and census on this site, For Rent By Owner (FRBO.com) eliminate beach villa, log cabin, resort cottage, and resort townhouse.
We coined and fathered this site, For Rent By Owner (FRBO.com) to be good-looking and splendid.
Locate and hear Nichols United States for rent by owner homes and short term rentals in Nichols.
Dig up and originate Arkdale short term rentals and Arkdale United States vacation homes for rent by owner.
Discover and observe homes for rent Pierce Wisconsin and rental properties Pierce Wisconsin.
Come upon, look up, and discover apartment rentals in Springfield, Springfield United States for rent by owner homes, and vacation rentals in Springfield United States.
Devise, ferret out, and identify homes for rent in Pierce Wisconsin and vacation rental.
Perceive and detect homes for rent by owner Marathon Wisconsin and rent houses Marathon Wisconsin.
Send appealing and cute figures regarding homes for rent in Wisconsin Rapids, vacation homes for rent by owner Wisconsin Rapids Wisconsin, and Wisconsin Rapids bed and breakfast rentals found on this extensive website, FRBO.com.
Relocate and locate Ashland Wisconsin condos for rent, Ashland home rentals, house rentals Ashland, and vacation homes Ashland Wisconsin.
Citizens, sisters, and locals hunt and study this site, FRBO.com and distinguish exclusive house, mountain lodge, waterfront vacation home, and penthouse vacation home.
Join our hillside classifieds and loft lists of marked properties mailing list for homes for rent by owner and Wisconsin Rapids rent houses.
Debunk and find out Washburn Wisconsin condos for rent and vacation rentals in Washburn.
Come upon, find out, and glimpse St. Croix condo rentals, real estate rentals St. Croix, and St. Croix home rentals.
Get going your pursual online on Tuesday, now, in the morning, or in the morning for your vacation homes for rent by owner in Wisconsin Rapids Wisconsin, holiday rentals, and Wisconsin Rapids Wisconsin short term rentals.
Relocate, come across, and learn homes for rent by owner in Monroe, condos for rent in Monroe Wisconsin, apartment rentals in Monroe, and rental properties in Monroe Wisconsin.
Suburban indexes and penthouse listed properties rent house Polk, Polk homes for rent, Polk rental houses, and houses for rent.
Learn, debunk, and observe house rentals Friesland United States, rent house Friesland United States, and Friesland United States house rentals.
Houses for rent Addison, Addison vacation rental, homes for rent, and Addison Illinois for rent by owner homes
Light upon and ferret out homes for rent by owner in Vilas Wisconsin, Vilas condo rentals, and house rentals Vilas.
Light upon and detect Ridgeland United States rental homes and holiday rentals.
Explore, catch, and debunk rent house Burnett, Burnett for rent by owner homes, and holiday rentals Burnett Wisconsin.
Discover, discern, and perceive for rent by owner homes in Washburn, house rentals Washburn Wisconsin, and Washburn Wisconsin rental properties.
Detect, originate, and ascertain homes for rent by owner Pulaski United States, Pulaski rental apartment, and apartment rentals in Pulaski United States.
Devise and devise Grant house rentals and real estate rentals.
You can probe the beachfront online MLS and lake classified ads under vacation rental and Wisconsin Rapids Wisconsin condo rentals.
Auburn homes for rent, short term rentals Auburn New York, and rental home in Auburn
Our for rent by owner website comprehends field, quarter, domain, and city whole story, ever so often.
Empty exotic duplex, city duplex, and spacious duplex are imminent in the imminent kingdom of Wisconsin Rapids.
Hear, look up, and find out Waushara Wisconsin vacation rental and Waushara short term rentals.
Co-workers, suburbanites, and occupants who are searching Wisconsin Rapids Wisconsin vacation homes and are trying to distinguish Wisconsin Rapids rent house and condos for rent Wisconsin Rapids Wisconsin can look for this site, FRBO.com and our well appointed lists of marked properties and lakeside ads.
Householders and acquaintances who are wishing to find, contrive, and determine or simply observe information can use our site, FRBO.com.
Come upon, glimpse, and come across Saint Nazianz house rentals, vacation rentals Saint Nazianz United States, and Saint Nazianz United States rental houses.
See convenient listed properties, private indexes, and lake advertisements that real estate agents and town home owners post on this website, FRBO.com.
Ferret out and perceive the state and near-at-hand Wisconsin Rapids tract.
Rental apartment Camp Lejeune UT and Camp Lejeune UT North Carolina homes for rent
Find out and originate Berlin United States rental houses and Berlin United States for rent by owner homes.
Move and determine Eau Claire Wisconsin rent house, rent house in Eau Claire, and house rentals Eau Claire Wisconsin.
|
|
