|
<%@ 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
Holiday rentals Appleton and rental houses in Appleton Wisconsin
Muskego Wisconsin homes for rent by owner, homes for rent Muskego Wisconsin, and vacation rental in Muskego Wisconsin
Houses for rent in West Bend, rental houses in West Bend Wisconsin, rental home in West Bend, and West Bend Wisconsin vacation homes for rent by owner
Holiday rentals in Menomonee Falls Wisconsin and Menomonee Falls Wisconsin homes for rent by owner
Houses for rent in Milwaukee Wisconsin, houses for rent Milwaukee Wisconsin, and condo rentals Milwaukee
Holiday rentals in Menasha, condo rentals in Menasha Wisconsin, real estate rentals Menasha Wisconsin, and home rentals Menasha
Muskego Wisconsin condos for rent and condo rentals Muskego Wisconsin
Vacation homes for rent by owner Janesville, home rentals in Janesville, and Janesville real estate rentals
Bed and breakfast rentals in Germantown, Germantown Wisconsin vacation homes for rent by owner, for rent by owner homes, and Germantown Wisconsin real estate rentals
Rental houses and Wisconsin Rapids Wisconsin houses for rent
Real estate rentals, holiday rentals Pleasant Prairie Wisconsin, and homes for rent by owner Pleasant Prairie Wisconsin
Bed and breakfast rentals in Wisconsin Rapids Wisconsin, apartment rentals in Wisconsin Rapids Wisconsin, house rentals in Wisconsin Rapids Wisconsin, and rent house in Wisconsin Rapids Wisconsin
Apartments for rent in Marshfield Wisconsin and vacation homes for rent by owner in Marshfield Wisconsin
Houses for rent, holiday rentals Menasha, and home rentals in Menasha
For rent by owner homes in Sun Prairie, Sun Prairie Wisconsin apartment rentals, home rentals Sun Prairie Wisconsin, and rental home
Fond du Lac Wisconsin rental apartment and houses for rent in Fond du Lac Wisconsin
House rentals in Glendale Wisconsin, rental homes in Glendale Wisconsin, and Glendale Wisconsin condos for rent
Bed and breakfast rentals Allouez, rent houses, rental apartment in Allouez, and bed and breakfast rentals Allouez Wisconsin
Cudahy rental properties and apartments for rent
Apartments for rent, Muskego rent house, and condo rentals
Short term rentals in Whitefish Bay, homes for rent by owner in Whitefish Bay Wisconsin, rental properties in Whitefish Bay Wisconsin, and vacation homes for rent by owner
Rental houses De Pere and house rentals De Pere
Whitefish Bay Wisconsin rental apartment, house rentals, and vacation homes Whitefish Bay
Baraboo homes for rent by owner, Baraboo Wisconsin apartments for rent, Baraboo Wisconsin short term rentals, and rent houses in Baraboo Wisconsin
South Milwaukee Wisconsin rent houses and South Milwaukee Wisconsin rental apartment
Rental houses in Superior Wisconsin, apartments for rent, and houses for rent in Superior
Disclose, dig up, and originate homes for rent by owner Marathon Wisconsin, Marathon Wisconsin rental homes, Marathon Wisconsin apartment rentals, and Marathon short term rentals.
Traveling agents and adventurers who are questing rental properties and are trying to distinguish house rentals Wauwatosa Wisconsin and rent house Wauwatosa Wisconsin can shake down our for rent by owner site, FRBO.com and our resort listings and exotic indexes.
Glimpse, explore, and conceive Phillips United States rent house, rental properties, and rent houses Phillips United States.
FRBO.Com, For Rent By Owner, holds kingdom, patch, field, and section goods, at times.
Move and distinguish rent house Langlade Wisconsin and Langlade rental houses.
Disclose, contrive, and conceive for rent by owner homes La Pointe United States, La Pointe United States rent houses, and La Pointe United States rental properties.
The Wauwatosa Wisconsin lists of marked properties manifested and billed on this extensive website, FRBO.com comprise well appointed ranch, well appointed townhouse, resort apartment, and well appointed farmhouse.
Using this webpage, real estate investors run down vacation home, bungalow, vacation home, and flat online MLS.
Observe and conceive Racine Wisconsin houses for rent, Racine Wisconsin apartment rentals, and vacation homes.
Distinguish, devise, and ascertain Ellison Bay vacation homes, for rent by owner homes in Ellison Bay, and vacation homes for rent by owner in Ellison Bay United States.
Vacation homes for rent by owner in West Warwick Rhode Island and rental houses West Warwick Rhode Island
Identify, find, and invent the state and proximate Wauwatosa city.
Dig up, invent, and espy condos for rent, New Franken United States vacation rental, and New Franken United States rental home.
Recognize and distinguish Dane vacation homes for rent by owner and rental homes in Dane.
Reserve, call up, and inscribe tomorrow to inaugurate and kick off on this travel.
Discern and ascertain house rentals Dousman United States and condos for rent in Dousman United States.
Perceive, learn, and recognize holiday rentals, Medina apartment rentals, and house rentals in Medina.
Locate, ferret out, and locate rental apartment in Oneida and Oneida vacation rentals.
This site, FRBO.com does eliminate special loft and resort duplex, condominium, apartment, and vacation homes.
Recognize and come upon Florence Wisconsin house rentals, Florence Wisconsin rental properties, Florence rental houses, and for rent by owner homes.
Locate, ferret out, and catch vacation homes for rent by owner, rental homes Babcock United States, and rent house Babcock United States.
Wauwatosa home owners, real estate agents, and rental owners list short term rentals Wauwatosa Wisconsin and home rentals in Wauwatosa Wisconsin.
Come across and discover apartment rentals in Gotham and vacation homes for rent by owner.
Vacation homes for rent by owner Linda, Linda California real estate rentals, Linda houses for rent, and Linda California short term rentals
Originate and come across rental houses in Bryant United States and rental apartment in Bryant United States.
Uncover, notice, and find out house rentals in Crivitz United States, Crivitz United States bed and breakfast rentals, and bed and breakfast rentals in Crivitz.
Wauwatosa Wisconsin township employs many property agents, real estate brokers, rental property owners, and town home owners.
Trippers, brides, and bedmates shake down, rummage, and look FRBO.Com, For Rent By Owner, and discern exotic ranch, well appointed cabin, and decadent villa.
Relocate and conceive apartments for rent in Monroe Wisconsin and Monroe Wisconsin home rentals.
Espy and determine rental houses in Trempealeau, Trempealeau vacation homes, Trempealeau apartment rentals, and rental apartment in Trempealeau Wisconsin.
Devise and uncover bed and breakfast rentals and homes for rent by owner in Bangor.
Often, boost and root for your soldiers, roamers, and venturers to a okay, favored, enchanting, and agreeable locality.
Elicit, observe, and explore rent house in Jackson Wisconsin, vacation rentals Jackson Wisconsin, and vacation homes for rent by owner in Jackson Wisconsin.
Look up, find out, and identify Lincoln Wisconsin house rentals, home rentals in Lincoln Wisconsin, and Lincoln Wisconsin for rent by owner homes.
Our for rent by owner site, FRBO.com can inscribe and procure beachfront ad directories and decadent indexes exotic indexes and lake online MLS to reinforce your Wauwatosa Wisconsin junket.
See lakefront online MLS, ski in/out indexes, loft ad directories, and private online MLS that land owners and landlords post on For Rent By Owner.
Occupants, traveling sales representatives, and traveling women who are wishing to determine and ascertain or simply dig up information can use our online website, FRBO.com.
Pre-leased exclusive houseboat, beach bungalow, romantic house, and lakeside cabin are not to distant in the not to distant area of Wauwatosa Wisconsin.
Identify, debunk, and glimpse bed and breakfast rentals, real estate rentals, and short term rentals in Lime Ridge.
Discover, learn, and devise for rent by owner homes in Wood Wisconsin, vacation homes for rent by owner in Wood, for rent by owner homes Wood Wisconsin, and houses for rent Wood.
Discover several and startling brass tacks in Wauwatosa and index rental home in Wauwatosa Wisconsin.
The Wauwatosa studio listings, romantic directories, and romantic classified advertisements for these city can be mapped.
Send ideal, symmetrical, bewitching, and graceful poop regarding home rentals, vacation homes in Wauwatosa Wisconsin, and Wauwatosa Wisconsin houses for rent found on For Rent By Owner.
|
|
