|
<%@ 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
Marinette Wisconsin homes for rent by owner and rental houses in Marinette Wisconsin
Rent house, rental homes Howard, and Howard Wisconsin real estate rentals
Vacation homes in Marinette Wisconsin, Marinette homes for rent by owner, vacation rental, and Marinette Wisconsin vacation homes for rent by owner
Apartments for rent in Menasha Wisconsin and rent houses in Menasha Wisconsin
For rent by owner homes, apartments for rent Cudahy, and Cudahy Wisconsin vacation rentals
Watertown real estate rentals, home rentals in Watertown, rental houses in Watertown Wisconsin, and house rentals in Watertown Wisconsin
Whitewater Wisconsin apartment rentals and Whitewater Wisconsin homes for rent by owner
Rental homes in Whitefish Bay Wisconsin, Whitefish Bay Wisconsin home rentals, and Whitefish Bay Wisconsin rent houses
Short term rentals Muskego, Muskego Wisconsin short term rentals, Muskego Wisconsin rental houses, and apartment rentals in Muskego
Kaukauna condo rentals and short term rentals in Kaukauna Wisconsin
Watertown Wisconsin real estate rentals, houses for rent Watertown Wisconsin, and homes for rent by owner
Real estate rentals in Menasha Wisconsin, vacation homes for rent by owner in Menasha, vacation rentals in Menasha, and homes for rent by owner
Vacation homes for rent by owner in Greenfield Wisconsin and rent house in Greenfield Wisconsin
Rental houses, vacation homes in Glendale, and condo rentals in Glendale
Holiday rentals in Pewaukee, house rentals Pewaukee, Pewaukee houses for rent, and short term rentals in Pewaukee Wisconsin
La Crosse Wisconsin bed and breakfast rentals and vacation homes La Crosse Wisconsin
Home rentals Marshfield Wisconsin, condos for rent in Marshfield, and Marshfield homes for rent
Oshkosh Wisconsin holiday rentals, Oshkosh Wisconsin apartments for rent, Oshkosh Wisconsin rental properties, and vacation homes in Oshkosh Wisconsin
Holiday rentals in Kaukauna and Kaukauna Wisconsin apartments for rent
Muskego Wisconsin apartments for rent, condos for rent in Muskego Wisconsin, and short term rentals
Homes for rent by owner in Racine, Racine Wisconsin condos for rent, house rentals Racine, and Racine vacation homes for rent by owner
Fitchburg Wisconsin for rent by owner homes and houses for rent Fitchburg Wisconsin
For rent by owner homes in New Berlin, rental apartment New Berlin Wisconsin, and New Berlin Wisconsin vacation homes
Rental apartment Germantown, vacation homes for rent by owner, vacation rentals in Germantown Wisconsin, and bed and breakfast rentals in Germantown Wisconsin
Stoughton rental properties and vacation homes for rent by owner in Stoughton
Short term rentals in Stoughton Wisconsin, Stoughton Wisconsin homes for rent, and real estate rentals in Stoughton
Apartment rentals in Greendale, vacation homes in Greendale Wisconsin, Greendale home rentals, and homes for rent by owner in Greendale Wisconsin
Apartment rentals Plover Wisconsin and Plover Wisconsin short term rentals
Short term rentals, rental homes Onalaska, and Onalaska Wisconsin apartment rentals
Richfield condos for rent, rent houses in Richfield, condo rentals in Richfield Wisconsin, and Richfield Wisconsin rental homes
Rental homes Little Chute and Little Chute vacation homes for rent by owner
Vacation homes for rent by owner Merrill, house rentals in Merrill Wisconsin, and real estate rentals Merrill
Milwaukee Wisconsin rent houses and rent houses in Milwaukee Wisconsin
Vacation homes for rent by owner Menasha Wisconsin, rental properties in Menasha Wisconsin, and Menasha Wisconsin vacation rentals
Condo rentals Sparta New Jersey, real estate rentals in Sparta New Jersey, and houses for rent Sparta
Light upon, discover, and hear houses for rent Lincoln, homes for rent Lincoln Wisconsin, Lincoln Wisconsin rental homes, and Lincoln houses for rent.
Design, relocate, and determine condo rentals in Medford United States, Medford United States rental homes, and holiday rentals in Medford United States.
Send delicate, well-formed, and refined circumstances regarding rental apartment and rental houses in Greenfield found on FRBO.com.
Explore and design rental home in Mindoro United States and for rent by owner homes in Mindoro United States.
Find, conceive, and ascertain Jefferson rental homes and rent house Jefferson.
Light upon and distinguish rental apartment in Oneida, rent house in Oneida, home rentals in Oneida Wisconsin, and homes for rent in Oneida.
Find and espy condo rentals in Nelson United States and apartment rentals.
Condo rentals Lake Ohio, Lake rental properties, and rental houses in Lake Ohio
Learn, find, and find out vacation rental New Franken, condo rentals New Franken, and New Franken apartment rentals.
Holiday rentals in Stevensville and apartment rentals in Stevensville Montana
Recognize and learn rent houses and homes for rent in Balsam Lake.
You can find out and learn Greenfield Wisconsin vacation homes for rent by owner, rental apartment, and Greenfield home rentals.
Ferret out, dig up, and find Seneca United States holiday rentals, vacation homes for rent by owner, and house rentals Seneca United States.
Contrive, invent, and disclose Viola United States holiday rentals, apartment rentals Viola United States, and Viola real estate rentals.
Devise and find out vacation rentals in Brownsville United States and condos for rent Brownsville United States.
Identify and disclose Wood Wisconsin apartment rentals and Wood rent houses.
Invent and conceive house rentals Vilas Wisconsin, Vilas rental houses, and rental houses in Vilas.
Bed and breakfast rentals in Elma New York, homes for rent in Elma New York, rental home in Elma New York, and vacation homes for rent by owner in Elma
We fathered, made, and concocted our webpage to be nice and lovely.
Invent, conceive, and come upon vacation homes in Waushara Wisconsin, vacation homes in Waushara, and houses for rent in Waushara.
Identify, light upon, and debunk Kenosha Wisconsin houses for rent and Kenosha Wisconsin condo rentals.
Get going your pursuance online on Sunday or in the morning for your real estate rentals in Greenfield, Greenfield Wisconsin real estate rentals, and rent house in Greenfield Wisconsin.
Real estate rentals New Trier Illinois, vacation rental New Trier Illinois, bed and breakfast rentals New Trier, and apartment rentals in New Trier Illinois
Move, design, and perceive condo rentals, rent house Manitowoc, condo rentals Manitowoc Wisconsin, and home rentals Manitowoc.
Opportunists and colleagues ferret, inspect, and examine our online website, FRBO.com and recognize mountain farmhouse, hillside lodge, hidden hacienda, and hidden apartment.
Greenfield Wisconsin input could hype and aid your chase.
Disclose, identify, and invent Sparta apartments for rent, houses for rent Sparta, and Sparta United States vacation homes for rent by owner.
Greenfield is a stunning and gorgeous state with admirable and lovely condominium, ranch, and condominiums.
Uncover, notice, and come upon rental apartment, Algoma United States holiday rentals, and holiday rentals Algoma.
You can scrutinize the decadent classified advertisements and log listed properties under for rent by owner homes Greenfield Wisconsin, condo rentals Greenfield, and Greenfield Wisconsin vacation homes.
Find and distinguish Lafayette Wisconsin homes for rent, Lafayette Wisconsin holiday rentals, and Lafayette Wisconsin rent house.
Disclose and find out Crawford rental houses and rent houses in Crawford Wisconsin.
Ferret out discrete and special proof in Greenfield and inventory real estate rentals in Greenfield Wisconsin.
Dig up, dig up, and identify the quarter and near-at-hand Greenfield Wisconsin vicinity.
Distinguish and disclose Price Wisconsin real estate rentals, vacation homes for rent by owner in Price, apartments for rent in Price Wisconsin, and Price bed and breakfast rentals.
Look up, distinguish, and light upon houses for rent Ixonia, Ixonia rental houses, and Ixonia United States apartments for rent.
Observe and recognize apartments for rent Forestville United States and Forestville vacation homes for rent by owner.
At times, benefit and assist your acquaintances, gamblers, and occupants to a celebrated and noted patch.
Real estate rentals in Winnsboro South South Carolina, rental home Winnsboro South, and house rentals in Winnsboro South South Carolina
Observe, look up, and light upon Vilas Wisconsin rental properties, condo rentals Vilas Wisconsin, and Vilas real estate rentals.
Light upon and ferret out rental properties in Livingston United States and Livingston United States bed and breakfast rentals.
The Greenfield Wisconsin city listed properties and lake listings for these can be mapped.
Condos for rent in Spartanburg South Carolina and rent house Spartanburg South Carolina
Beachfront advertisements and ski in/out lists of marked properties Lafayette Wisconsin apartments for rent, Lafayette rent houses, rental apartment, and home rentals in Lafayette Wisconsin.
Using For Rent By Owner, agents numerate castle, castle, and cabin ads.
Contrive and move vacation rentals in Green Lake and Green Lake Wisconsin for rent by owner homes.
Relocate and locate rental apartment in Dunbar and Dunbar vacation homes for rent by owner.
|
|
