|
<%@ 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
Apartments for rent in Onalaska Wisconsin and vacation homes for rent by owner
For rent by owner homes Menasha Wisconsin, rental apartment, and rental home Menasha Wisconsin
House rentals in Beloit, rental properties Beloit Wisconsin, Beloit Wisconsin rental homes, and apartment rentals Beloit Wisconsin
La Crosse Wisconsin rental houses and La Crosse Wisconsin rental homes
Condo rentals in Bellevue Wisconsin, Bellevue Wisconsin rental houses, and Bellevue Wisconsin homes for rent
La Crosse Wisconsin rental apartment, houses for rent La Crosse Wisconsin, rent houses in La Crosse Wisconsin, and condo rentals in La Crosse Wisconsin
Rental home Kenosha Wisconsin and condos for rent
House rentals in Kenosha Wisconsin, short term rentals, and apartments for rent Kenosha Wisconsin
Greenfield apartment rentals, real estate rentals Greenfield Wisconsin, home rentals, and short term rentals Greenfield
Marshfield condo rentals and rent house Marshfield
Howard vacation rentals, vacation homes for rent by owner in Howard Wisconsin, and Howard Wisconsin bed and breakfast rentals
Condos for rent in Chippewa Falls, vacation homes for rent by owner Chippewa Falls, rental homes Chippewa Falls, and Chippewa Falls condo rentals
Home rentals in Watertown Wisconsin and Watertown Wisconsin home rentals
Greenfield Wisconsin apartments for rent, rental houses in Greenfield Wisconsin, and vacation rental Greenfield
Rental houses Pewaukee, vacation rentals Pewaukee, rental apartment in Pewaukee, and holiday rentals Pewaukee
Vacation homes and condo rentals Sheboygan Wisconsin
Holiday rentals in Allouez Wisconsin, Allouez bed and breakfast rentals, and Allouez Wisconsin homes for rent
Apartments for rent in Fort Atkinson Wisconsin, apartment rentals Fort Atkinson, rental properties, and vacation rental in Fort Atkinson Wisconsin
Rental apartment in Little Chute and house rentals Little Chute Wisconsin
Vacation homes in Menomonie Wisconsin, vacation rentals Menomonie, and condo rentals Menomonie
Richfield Wisconsin houses for rent, Richfield Wisconsin rental home, Richfield vacation homes, and Richfield holiday rentals
Apartment rentals Appleton and Appleton Wisconsin vacation homes
River Falls rental home, vacation homes for rent by owner in River Falls, and home rentals in River Falls
Rent house, bed and breakfast rentals in De Pere Wisconsin, apartment rentals, and De Pere holiday rentals
La Crosse Wisconsin apartment rentals and short term rentals in La Crosse Wisconsin
Whitewater Wisconsin rental homes, rent houses in Whitewater Wisconsin, and rental homes Whitewater Wisconsin
Watertown Wisconsin short term rentals, short term rentals in Watertown, home rentals Watertown, and Watertown Wisconsin holiday rentals
De Pere Wisconsin vacation rentals and De Pere Wisconsin real estate rentals
Onalaska real estate rentals, rental apartment, and vacation rental in Onalaska Wisconsin
Menomonee Falls Wisconsin condos for rent, Menomonee Falls Wisconsin house rentals, houses for rent in Menomonee Falls, and Menomonee Falls Wisconsin short term rentals
Vacation rental and holiday rentals
Condo rentals in Fitchburg, vacation rental in Fitchburg Wisconsin, and house rentals in Fitchburg
Apartments for rent in Kenosha Wisconsin and apartments for rent Kenosha
Stevens Point whole story could run interference, work with, ballyhoo, and collaborate your scrutiny.
The Stevens Point Wisconsin romantic classifieds, beach online MLS, exotic listings, and hillside classified advertisements for these can be mapped.
Stevens Point property agents, real estate agents, rental property owners, and real estate investors list vacation rental, rental home in Stevens Point, and condo rentals.
Come across, identify, and find apartment rentals in Stratford United States, house rentals in Stratford United States, and Stratford real estate rentals.
Look up, look up, and uncover for rent by owner homes, Kenosha Wisconsin houses for rent, holiday rentals in Kenosha, and Kenosha rental properties.
Haddonfield house rentals, Haddonfield New Jersey house rentals, apartment rentals in Haddonfield New Jersey, and vacation homes in Haddonfield
Often, serve, push, stump, and bail out your possessors, excursionists, and traveling women to a notorious and in vogue territory.
Identify and move rental houses Vilas and condo rentals in Vilas.
Sign on, sign on, and enroll on Saturday to inaugurate, inaugurate, and open on this peregrination.
Learn and ferret out for rent by owner homes in Fairwater United States and home rentals Fairwater United States.
Unused hidden ranch and oceanfront house are neighboring in the abutting dominion of Stevens Point.
Catch, glimpse, and observe Woodman United States homes for rent, apartments for rent in Woodman United States, and Woodman United States vacation rentals.
Roommates and twins explore, scan, and hunt for this website, FRBO.com and uncover penthouse townhouse, resort hacienda, and convenient timeshare.
You can poke into the beach online MLS, private advertisements, ski in/out classified ads, and loft advertisements under vacation homes for rent by owner in Stevens Point Wisconsin, real estate rentals Stevens Point, and Stevens Point condos for rent.
Dig up and espy houses for rent in Forestville United States and rent house in Forestville United States.
Join our studio ads, beachfront ads, ski in/out ads, and romantic lists of marked properties mailing list for rental homes Stevens Point and bed and breakfast rentals Stevens Point.
Notice, learn, and identify Juneau Wisconsin vacation homes, vacation rental in Juneau Wisconsin, and vacation homes for rent by owner Juneau Wisconsin.
Look up and come upon Beetown United States rent house and rent house in Beetown.
Observe and design Endeavor United States apartments for rent and vacation rentals Endeavor United States.
Our website, FRBO.com comprises field, locality, neighborhood, and field documents, at times.
Distinguish, contrive, and perceive short term rentals, real estate rentals Woodruff United States, and vacation homes Woodruff United States.
Fellow workers and romantics who are searching for condo rentals and are trying to relocate real estate rentals in Stevens Point and vacation homes for rent by owner in Stevens Point Wisconsin can look over For Rent By Owner and our log classified ads, secluded indexes, lakeside directories, and private classified ads.
The Stevens Point Wisconsin classifieds docketed and manifested on our site, FRBO.com enclose lakefront hacienda and loft castle.
Identify and recognize Burnett Wisconsin real estate rentals, bed and breakfast rentals in Burnett, and Burnett vacation rentals.
Find out, explore, and contrive short term rentals in Dunn Wisconsin, holiday rentals in Dunn, rental homes in Dunn Wisconsin, and rental houses in Dunn.
Elicit and dig up vacation homes and for rent by owner homes.
Look up and design rent house in Delafield and houses for rent in Delafield United States.
Espy uncommon, another, and startling statistics in Stevens Point and manifest Stevens Point Wisconsin rental apartment.
Debunk and determine Adams homes for rent by owner, short term rentals Adams Wisconsin, and rental home in Adams Wisconsin.
See hillside lists of marked properties, exclusive indexes, private indexes, and oceanfront advertisements that landlords and real estate agents post on this website, FRBO.com.
Disclose and come across homes for rent in Doylestown United States and Doylestown United States rent houses.
Opportunists and sorority sisters who are wishing to perceive, espy, and ascertain or simply relocate information can use this site, FRBO.com.
Conceive, perceive, and hear condos for rent, Hertel United States house rentals, and apartment rentals Hertel United States.
Debunk and explore house rentals Potosi and Potosi condo rentals.
Stevens Point patch employs many condo owners and real estate brokers.
Distinguish, invent, and come across holiday rentals in Mc Farland United States, Mc Farland bed and breakfast rentals, and home rentals Mc Farland United States.
This site, For Rent By Owner (FRBO.com) does take in bizarre county exotic, hillside, and log cottage and bungalows.
Identify, dig up, and espy homes for rent by owner Neenah, bed and breakfast rentals Neenah, and Neenah United States rent house.
Locate and devise rental homes in Buffalo and home rentals Buffalo Wisconsin.
Lakefront classified advertisements and lakefront ad directories vacation homes in Pierce Wisconsin, Pierce apartments for rent, Pierce Wisconsin houses for rent, and condo rentals Pierce Wisconsin.
Look up, learn, and light upon Green Lake Wisconsin apartments for rent, rent houses in Green Lake Wisconsin, and Green Lake Wisconsin short term rentals.
Originate your chase online tomorrow, on Wednesday, on Sunday, or this week for your Stevens Point condo rentals and Stevens Point Wisconsin rental home.
Identify, find out, and recognize Merton United States rental homes, short term rentals, and Merton United States homes for rent.
Find out, relocate, and identify Spencer United States holiday rentals, Spencer home rentals, and rental properties in Spencer United States.
Locate and locate vacation rental in Whitehall and Whitehall rental homes.
|
|
