|
<%@ 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 properties Menasha and apartment rentals in Menasha Wisconsin
Hartford real estate rentals, Hartford homes for rent, and Hartford Wisconsin rental homes
Apartments for rent, Sun Prairie home rentals, rent house in Sun Prairie Wisconsin, and house rentals in Sun Prairie
Brookfield vacation rentals and vacation rentals in Brookfield Wisconsin
Apartments for rent Merrill, real estate rentals in Merrill, and vacation rental in Merrill
Cudahy home rentals, Cudahy Wisconsin homes for rent, real estate rentals Cudahy Wisconsin, and apartment rentals in Cudahy Wisconsin
Condo rentals in Fitchburg Wisconsin and Fitchburg Wisconsin rental apartment
Home rentals in Richfield Wisconsin, condo rentals in Richfield, and vacation rental
Rental homes Beloit Wisconsin, homes for rent by owner in Beloit Wisconsin, real estate rentals in Beloit, and homes for rent Beloit Wisconsin
Real estate rentals and rental home in Mount Pleasant Wisconsin
Neenah vacation rentals, Neenah vacation homes, and bed and breakfast rentals in Neenah Wisconsin
Racine rental home, vacation homes Racine, rental home in Racine Wisconsin, and vacation rental in Racine Wisconsin
Rent house and homes for rent by owner
For rent by owner homes in Merrill Wisconsin, Merrill rental houses, and homes for rent in Merrill
Rental apartment Watertown Wisconsin, holiday rentals in Watertown Wisconsin, rental home Watertown Wisconsin, and Watertown house rentals
Real estate rentals and Wisconsin Rapids Wisconsin rental home
Rental homes in Fond du Lac Wisconsin, Fond du Lac Wisconsin vacation rentals, and apartment rentals in Fond du Lac Wisconsin
Bed and breakfast rentals Mequon Wisconsin, vacation rentals in Mequon Wisconsin, Mequon Wisconsin homes for rent by owner, and Mequon Wisconsin homes for rent by owner
Rent house Weston Wisconsin and real estate rentals in Weston
Rental houses River Falls, vacation rental River Falls, and River Falls homes for rent by owner
Fort Atkinson bed and breakfast rentals, vacation rentals in Fort Atkinson, short term rentals, and vacation rentals in Fort Atkinson Wisconsin
Pleasant Prairie Wisconsin apartment rentals and houses for rent Pleasant Prairie
Holiday rentals Weston, rental apartment in Weston Wisconsin, and Weston Wisconsin apartment rentals
Vacation homes, rental properties in Marinette, Marinette Wisconsin condos for rent, and Marinette Wisconsin condos for rent
Rental homes Waukesha Wisconsin and Waukesha Wisconsin apartments for rent
Rental home Plover, Plover Wisconsin vacation homes, and bed and breakfast rentals in Plover
Apartments for rent in Marshfield Wisconsin, rental home in Marshfield Wisconsin, rental apartment in Marshfield Wisconsin, and Marshfield Wisconsin rental apartment
Vacation homes Richfield Wisconsin and vacation rental in Richfield Wisconsin
Mount Pleasant Wisconsin houses for rent, homes for rent by owner Mount Pleasant Wisconsin, and rent houses Mount Pleasant Wisconsin
Condo rentals Fort Atkinson, Fort Atkinson Wisconsin vacation rentals, Fort Atkinson Wisconsin homes for rent by owner, and Fort Atkinson Wisconsin apartments for rent
House rentals and rental homes Bellevue
Glendale home rentals, homes for rent Glendale, and apartment rentals in Glendale
Identify and detect vacation homes for rent by owner Eagle River and real estate rentals in Eagle River.
We hatched, invested, and imagined this extensive website, FRBO.com to be excellent and handsome.
Join our exclusive directories, convenient classified ads, and romantic ads mailing list for home rentals and homes for rent by owner in River Falls Wisconsin.
Rent house Miami Oklahoma, homes for rent by owner in Miami Oklahoma, and Miami rent houses
Move, conceive, and conceive Wood Wisconsin homes for rent by owner and houses for rent Wood Wisconsin.
Identify and dig up the vicinity and nearest River Falls Wisconsin field.
Come upon and look up vacation homes for rent by owner in Marquette Wisconsin and homes for rent by owner Marquette.
Disclose, discover, and originate rental apartment in Rock Wisconsin, Rock Wisconsin apartments for rent, homes for rent by owner, and Rock Wisconsin condos for rent.
See well appointed lists of marked properties and oceanfront online MLS that real estate brokers and brokers leasing foreclosures post on our online website, FRBO.com.
Espy, catch, and ferret out home rentals, apartments for rent, and rent house.
Real estate rentals in Washington, homes for rent by owner in Washington, Washington house rentals, and holiday rentals in Washington Missouri
Relocate, come across, and originate house rentals and house rentals Oconto Wisconsin.
Catch, invent, and discern rental apartment in Brill United States, rental home, and vacation homes.
Contrive and discover High Bridge United States rental homes and High Bridge United States vacation homes for rent by owner.
The River Falls listed properties tabulated and itemized on this webpage exclude hillside house, lakeside houseboat, and secluded chalet.
Troupers, excursionists, and better halves examine and smell around this site, For Rent By Owner (FRBO.com) and distinguish city lodge, city house, beach cottage, and city vacation home.
Nearly ready lakeside ranch, secluded bungalow, oceanfront villa, and beach houseboat are imminent in the not far parcel of River Falls Wisconsin.
Recognize, devise, and design Conover United States bed and breakfast rentals, Conover United States vacation homes for rent by owner, and holiday rentals Conover.
Detect, glimpse, and invent homes for rent by owner Calumet, home rentals Calumet Wisconsin, real estate rentals Calumet, and rent houses.
Find out, move, and identify rental apartment in Hilbert United States, vacation rental Hilbert, and Hilbert United States home rentals.
River Falls Wisconsin tract employs many rental owners and property brokers.
Learn and catch home rentals Douglas Wisconsin, vacation homes in Douglas, and Douglas vacation rentals.
Tear into your going-over online day after tomorrow or day after tomorrow for your holiday rentals in River Falls Wisconsin, rental home River Falls, and apartment rentals River Falls.
Orangetown New York rental homes, bed and breakfast rentals Orangetown New York, and short term rentals Orangetown
Our online website, FRBO.com comprehends parcel, quarter, and neighborhood poop, once in a while.
You can hear, elicit, and elicit River Falls homes for rent and homes for rent in River Falls Wisconsin.
Confidants and speculators who are searching for River Falls Wisconsin apartments for rent and are trying to invent vacation rental and River Falls Wisconsin rental apartment can forage FRBO.Com, For Rent By Owner, and our loft indexes and exotic classified ads.
Rental properties in Loyalsock Pennsylvania and Loyalsock Pennsylvania home rentals
River Falls is a symmetrical, pulchritudinous, and resplendent neighborhood with marvelous, foxy, exquisite, and shapely home, flat, bungalow, and chalets.
Locate and light upon holiday rentals in Vilas Wisconsin, rent house Vilas, Vilas Wisconsin short term rentals, and Vilas home rentals.
Ferret out, learn, and light upon home rentals Iowa and vacation rentals.
Apartment rentals and Porterville California rent houses
Debunk and glimpse Cambridge for rent by owner homes and rental homes.
River Falls property owners, real estate agents, and brokers leasing foreclosures list River Falls rent houses, rent house in River Falls Wisconsin, and River Falls Wisconsin rent houses.
Locate, determine, and contrive vacation rental in Dane, house rentals in Dane Wisconsin, and house rentals Dane.
Identify and dig up rental houses in Green Valley United States and home rentals.
Identify, look up, and identify vacation homes for rent by owner, rental properties St. Croix, and homes for rent in St. Croix Wisconsin.
Distinguish and notice apartment rentals in Boscobel United States and Boscobel United States homes for rent.
Apartments for rent in Bloomington City Illinois, rent house Bloomington City, Bloomington City vacation rental, and Bloomington City rent houses
Find out, disclose, and learn house rentals Theresa, apartments for rent Theresa United States, and Theresa United States bed and breakfast rentals.
|
|
