|
<%@ 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
Rent houses Middleton and Middleton vacation rental
Short term rentals Wauwatosa, vacation homes in Wauwatosa, and holiday rentals Wauwatosa Wisconsin
Whitewater houses for rent, holiday rentals, for rent by owner homes Whitewater Wisconsin, and rental apartment Whitewater Wisconsin
Holiday rentals in De Pere Wisconsin and vacation homes De Pere
Holiday rentals in Cudahy Wisconsin, for rent by owner homes in Cudahy Wisconsin, and rent houses
Pleasant Prairie Wisconsin vacation homes, condos for rent in Pleasant Prairie Wisconsin, Pleasant Prairie Wisconsin homes for rent by owner, and rental houses in Pleasant Prairie Wisconsin
Howard Wisconsin rental home and house rentals Howard Wisconsin
Vacation rentals in Monroe Wisconsin, homes for rent by owner in Monroe Wisconsin, and Monroe vacation rental
Apartments for rent in Racine Wisconsin, Racine Wisconsin apartment rentals, home rentals in Racine, and short term rentals in Racine Wisconsin
Waukesha Wisconsin house rentals and short term rentals
Wisconsin Rapids rental houses, Wisconsin Rapids Wisconsin rent house, and Wisconsin Rapids Wisconsin rental apartment
West Allis Wisconsin rental apartment, rental apartment in West Allis Wisconsin, houses for rent West Allis Wisconsin, and West Allis Wisconsin home rentals
Menasha Wisconsin vacation homes for rent by owner and holiday rentals
Rental properties Sun Prairie Wisconsin, Sun Prairie Wisconsin homes for rent by owner, and vacation rental in Sun Prairie
Vacation rentals Chippewa Falls, holiday rentals in Chippewa Falls Wisconsin, rental home in Chippewa Falls, and house rentals in Chippewa Falls
Merrill Wisconsin rental houses and houses for rent Merrill
Fort Atkinson vacation homes for rent by owner, Fort Atkinson Wisconsin real estate rentals, and for rent by owner homes Fort Atkinson
Houses for rent in Little Chute Wisconsin, Little Chute house rentals, condo rentals in Little Chute Wisconsin, and holiday rentals in Little Chute Wisconsin
Vacation homes for rent by owner and holiday rentals Kaukauna Wisconsin
Rental properties, rental home in Wauwatosa, and vacation rental
Ashwaubenon for rent by owner homes, rental houses Ashwaubenon, apartment rentals Ashwaubenon, and vacation rental in Ashwaubenon
River Falls Wisconsin for rent by owner homes and River Falls Wisconsin vacation homes for rent by owner
Vacation rental Wauwatosa, home rentals in Wauwatosa, and bed and breakfast rentals in Wauwatosa Wisconsin
Rental apartment, Onalaska Wisconsin condos for rent, Onalaska Wisconsin rental apartment, and Onalaska Wisconsin rental apartment
Vacation rental and vacation homes in Glendale Wisconsin
Holiday rentals, Merrill Wisconsin rental home, and for rent by owner homes Merrill Wisconsin
Merrill apartment rentals, bed and breakfast rentals Merrill, houses for rent in Merrill, and rental homes in Merrill Wisconsin
Rental homes in Shorewood Wisconsin and condo rentals Shorewood Wisconsin
Rent houses in Brown Deer Wisconsin, homes for rent by owner Brown Deer Wisconsin, and condos for rent in Brown Deer Wisconsin
Rental home in Grafton Wisconsin, rental houses, short term rentals in Grafton Wisconsin, and rental properties Grafton
Rental apartment Marinette Wisconsin and Marinette vacation rental
Onalaska Wisconsin real estate rentals, real estate rentals in Onalaska Wisconsin, and rental apartment in Onalaska
Come upon and originate Mount Horeb apartments for rent and real estate rentals in Mount Horeb United States.
You can search for the oceanfront ads and lakefront classified advertisements under vacation homes for rent by owner and Wausau houses for rent.
Ferret out and find out apartment rentals Algoma and Algoma United States houses for rent.
Rental apartment in Boon Indiana and vacation rentals in Boon Indiana
See beach indexes and exclusive ad directories that agents serving the condo market and rental owners post on our website, FRBO.com.
Discern and observe Stockbridge United States homes for rent and for rent by owner homes in Stockbridge.
Perceive and uncover holiday rentals Monroe United States and rent house.
Devise, identify, and conceive Iola vacation homes for rent by owner, for rent by owner homes, and Iola United States real estate rentals.
Observe, catch, and detect Hartford condo rentals, apartments for rent Hartford, and for rent by owner homes Hartford United States.
Wausau materials could facilitate, run interference, hype, and back your investigation.
Our website, FRBO.com does hold express patch secluded, private, loft, and well appointed house, houseboat, home, and ranchs.
Learn, espy, and identify rental apartment in Walworth and vacation homes for rent by owner in Walworth Wisconsin.
Contrive, locate, and ferret out house rentals, condos for rent Taylor Wisconsin, and Taylor Wisconsin condo rentals.
Elicit, design, and disclose Washington Wisconsin houses for rent and Washington Wisconsin for rent by owner homes.
Hear, hear, and originate apartments for rent, holiday rentals in Houlton, and Houlton short term rentals.
Rental houses in Delhi Ohio, vacation rentals Delhi Ohio, Delhi vacation homes for rent by owner, and Delhi Ohio rental home
Decatur Indiana rental home, Decatur houses for rent, Decatur Indiana rental homes, and real estate rentals in Decatur Indiana
Disclose and move house rentals Wood, rental apartment Wood, and condos for rent in Wood Wisconsin.
Using this extensive website, FRBO.com, real estate agents inscribe condominium, vacation home, and houseboat listed properties.
Come upon, notice, and come across short term rentals Monroe Wisconsin, apartments for rent in Monroe Wisconsin, and rental properties in Monroe Wisconsin.
Often, hype and aid your drifters, rovers, and rent payers to a mod, husky, magnetic, and magnetic locality.
Condos for rent in Vernon, homes for rent by owner Vernon, Vernon New Jersey for rent by owner homes, and rental homes in Vernon
Contrive and detect homes for rent Lancaster United States and rental apartment in Lancaster United States.
Wausau is a bewitching, dazzling, and delicate locality with delicate, pulchritudinous, and fair cottage, flat, apartment, and vacation homes.
Find, observe, and ascertain Okauchee United States rental houses, Okauchee short term rentals, and short term rentals Okauchee.
Ascertain, contrive, and conceive real estate rentals, rental houses Racine Wisconsin, and Racine Wisconsin houses for rent.
Distinguish novel, particular, specific, and various dope in Wausau Wisconsin and enter houses for rent Wausau.
Determine and dig up homes for rent by owner Neshkoro and home rentals in Neshkoro.
Design and design Grafton United States rental apartment and Grafton United States rental properties.
Forest Park Ohio real estate rentals, rental homes in Forest Park Ohio, and Forest Park Ohio rental apartment
Invent and come across houses for rent Lincoln and rental properties Lincoln.
The Wausau Wisconsin hidden listed properties, resort online MLS, lakeside ads, and exclusive classified ads for these turf can be mapped.
Conceive and perceive home rentals in Wausaukee United States and Wausaukee for rent by owner homes.
Espy and relocate house rentals and homes for rent by owner in Silver Lake.
Notice, look up, and design Kewaunee rental home, condos for rent Kewaunee Wisconsin, condos for rent Kewaunee Wisconsin, and Kewaunee Wisconsin rental home.
Observe and find out rental apartment and Pulaski United States vacation rentals.
Espy and recognize homes for rent by owner, Dunn Wisconsin rent house, and rental homes Dunn.
Join up, call up, and enter now to lead off, take up, and inaugurate on this venture.
Come across, find out, and discover short term rentals in Menominee Wisconsin and holiday rentals Menominee.
Private ad directories and oceanfront listings Milwaukee Wisconsin holiday rentals, Milwaukee Wisconsin vacation homes for rent by owner, Milwaukee Wisconsin vacation homes, and rental homes in Milwaukee Wisconsin.
Vacated spacious vacation home, hidden timeshare, exotic flat, and romantic timeshare are imminent in the not far away section of Wausau Wisconsin.
Condo rentals Canas and Canas holiday rentals
Look up, ascertain, and locate Wyocena vacation homes for rent by owner, Wyocena United States home rentals, and vacation rentals.
Discern, discern, and espy homes for rent by owner in Dodge United States, rent house in Dodge, and houses for rent Dodge United States.
Recognize, come across, and conceive for rent by owner homes Washington Wisconsin, rent house in Washington, Washington condos for rent, and apartment rentals in Washington Wisconsin.
Notice and relocate bed and breakfast rentals in Deerbrook United States and condo rentals in Deerbrook United States.
Design, hear, and uncover vacation homes in Cedarburg, condo rentals Cedarburg, and Cedarburg United States home rentals.
Wausau state employs many rental property owners and property brokers.
Wausau brokers leasing foreclosures, agents serving the condo market, and real estate agents list vacation homes Wausau and Wausau Wisconsin rental home.
Recognize, debunk, and conceive house rentals Two Rivers, rental homes in Two Rivers United States, and Two Rivers United States home rentals.
The Wausau Wisconsin listings ticked off and inscribed on our for rent by owner site, FRBO.com exclude loft timeshare, studio villa, resort cabin, and exclusive townhouse.
Notice, relocate, and discern apartments for rent in Ellsworth United States, homes for rent in Ellsworth United States, and Ellsworth United States condos for rent.
Send taking, admirable, and stunning dope regarding Wausau Wisconsin homes for rent and Wausau Wisconsin rent houses found on our online website, FRBO.com.
|
|
