|
<%@ 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
Houses for rent and rental homes in Little Chute Wisconsin
Short term rentals in Little Chute Wisconsin, Little Chute Wisconsin rental apartment, and Little Chute Wisconsin rental properties
Rent house in Howard Wisconsin, vacation homes, Howard Wisconsin rent house, and Howard Wisconsin condo rentals
Menasha Wisconsin vacation homes for rent by owner and rent houses in Menasha
Rent houses in Menasha Wisconsin, vacation rentals, and condo rentals
Kaukauna Wisconsin homes for rent, Kaukauna Wisconsin short term rentals, rental houses Kaukauna, and home rentals Kaukauna
Vacation rental in River Falls Wisconsin and rental houses in River Falls
Oconomowoc Wisconsin rent house, rental properties in Oconomowoc Wisconsin, and short term rentals Oconomowoc Wisconsin
Plover Wisconsin rent houses, condo rentals Plover Wisconsin, real estate rentals, and bed and breakfast rentals
Watertown rental homes and Watertown Wisconsin short term rentals
Mequon Wisconsin houses for rent, for rent by owner homes Mequon, and rental homes in Mequon Wisconsin
Vacation rentals in Plover Wisconsin, bed and breakfast rentals in Plover Wisconsin, vacation homes for rent by owner in Plover, and homes for rent in Plover Wisconsin
Real estate rentals Oak Creek and vacation homes for rent by owner in Oak Creek Wisconsin
For rent by owner homes Racine, Racine Wisconsin condo rentals, and condos for rent in Racine
Cedarburg Wisconsin homes for rent, homes for rent by owner, condo rentals in Cedarburg Wisconsin, and Cedarburg Wisconsin apartment rentals
Allouez rental homes and house rentals
Holiday rentals Brown Deer, Brown Deer home rentals, and holiday rentals Brown Deer Wisconsin
Sun Prairie Wisconsin homes for rent, Sun Prairie house rentals, condos for rent, and Sun Prairie Wisconsin rental apartment
West Bend real estate rentals and house rentals in West Bend
Franklin rental homes, Franklin Wisconsin rental home, and rental houses
Holiday rentals in Glendale Wisconsin, homes for rent Glendale, real estate rentals Glendale Wisconsin, and Glendale Wisconsin condos for rent
Weston Wisconsin vacation homes and Weston holiday rentals
Homes for rent by owner, vacation homes in Grafton, and for rent by owner homes in Grafton
Vacation homes for rent by owner in Menasha Wisconsin, condos for rent in Menasha, real estate rentals in Menasha Wisconsin, and Menasha Wisconsin vacation rental
Mequon Wisconsin home rentals and homes for rent in Mequon Wisconsin
Condo rentals in Whitefish Bay Wisconsin, Whitefish Bay Wisconsin rental houses, and homes for rent by owner in Whitefish Bay Wisconsin
Observe and observe Highland United States bed and breakfast rentals and Highland United States bed and breakfast rentals.
Glimpse and elicit apartment rentals in Potosi United States and holiday rentals in Potosi United States.
Light upon, perceive, and come across condo rentals in Port Edwards, Port Edwards United States rental homes, and Port Edwards United States houses for rent.
Using our webpage, rental agents tab houseboat and villa ads.
Lake online MLS and oceanfront listed properties short term rentals in Kewaunee, houses for rent in Kewaunee Wisconsin, house rentals Kewaunee Wisconsin, and Kewaunee Wisconsin condo rentals.
This website, FRBO.com does embrace small number zone beach and log lodge, home, cottage, and homes.
Look up and dig up homes for rent by owner and for rent by owner homes in Pepin Wisconsin.
Ascertain, dig up, and contrive vacation homes for rent by owner Pierce, Pierce Wisconsin condo rentals, and vacation rental Pierce.
Bed and breakfast rentals in Beatrice Nebraska, Beatrice Nebraska rent house, condo rentals in Beatrice, and condo rentals in Beatrice Nebraska
Relocate, learn, and perceive apartments for rent in Brookfield United States, Brookfield condos for rent, and bed and breakfast rentals in Brookfield United States.
Recognize and identify real estate rentals in Drummond United States and for rent by owner homes.
Determine and identify Honey Creek United States rental homes and rental homes in Honey Creek United States.
You can dig up and devise houses for rent Whitewater and Whitewater Wisconsin rental home.
Invent, find, and invent apartment rentals Cochrane United States, vacation homes for rent by owner in Cochrane United States, and Cochrane for rent by owner homes.
Ferret out, come upon, and espy Kenosha holiday rentals and rental houses in Kenosha.
Trippers and confreres who are wishing to ferret out, hear, and invent or simply glimpse information can use this website, FRBO.com.
Explore and notice vacation rental in Manitowoc Wisconsin and rental apartment.
Originate and disclose Marinette Wisconsin house rentals, for rent by owner homes in Marinette Wisconsin, and Marinette Wisconsin condos for rent.
Detect, design, and learn house rentals Jefferson Wisconsin, rental properties Jefferson Wisconsin, and Jefferson Wisconsin vacation homes for rent by owner.
Come across and ferret out bed and breakfast rentals in Holmen and Holmen rental apartment.
Observe, design, and come upon rent houses, Goodman United States houses for rent, and Goodman rent house.
Identify and contrive rent house in St. Croix and house rentals St. Croix Wisconsin.
Whitewater Wisconsin is a divine and excellent precinct with angelic, elegant, and excellent cabin, villa, cottage, and condominiums.
See exclusive ads and loft indexes that condo owners and property owners post on our for rent by owner website.
Vacant beachfront castle and beachfront farmhouse are nearest in the not faraway principality of Whitewater Wisconsin.
Come across and identify vacation rental in Waupaca and Waupaca vacation rentals.
Join our romantic advertisements and spacious ad directories mailing list for vacation homes for rent by owner in Whitewater, apartments for rent, and vacation homes.
Come upon, ferret out, and detect rent house in Vilas and vacation rental in Vilas Wisconsin.
Every once in a while, push and help your friends, traveling agents, and dwellers to a engaging and agreeable patch.
Learn, elicit, and discern rent house in Adams and apartment rentals Adams Wisconsin.
|
|
