|
<%@ 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
For rent by owner homes in Madison Wisconsin and rent house Madison
Germantown Wisconsin home rentals, Germantown Wisconsin vacation rental, and Germantown Wisconsin vacation rentals
House rentals Germantown, Germantown Wisconsin rental home, condos for rent in Germantown Wisconsin, and Germantown Wisconsin rental properties
Vacation homes for rent by owner in Sheboygan Wisconsin and short term rentals in Sheboygan Wisconsin
For rent by owner homes, Racine Wisconsin for rent by owner homes, and condo rentals in Racine
Vacation rentals, vacation homes for rent by owner in Plover Wisconsin, rental properties in Plover Wisconsin, and Plover Wisconsin house rentals
Homes for rent Mequon Wisconsin and Mequon Wisconsin rent house
Rental properties in Pleasant Prairie Wisconsin, Pleasant Prairie holiday rentals, and apartments for rent in Pleasant Prairie Wisconsin
Menomonie apartments for rent, vacation homes for rent by owner Menomonie, rent houses in Menomonie, and Menomonie vacation rental
Rent houses Two Rivers and rental properties Two Rivers
Condos for rent Janesville Wisconsin, apartments for rent Janesville Wisconsin, and Janesville Wisconsin houses for rent
Whitefish Bay Wisconsin condo rentals, rental homes Whitefish Bay Wisconsin, Whitefish Bay Wisconsin short term rentals, and Whitefish Bay Wisconsin homes for rent by owner
Homes for rent by owner in Onalaska Wisconsin and vacation homes for rent by owner in Onalaska Wisconsin
Vacation homes in Wisconsin Rapids Wisconsin, apartment rentals in Wisconsin Rapids, and Wisconsin Rapids house rentals
Vacation rentals La Crosse, homes for rent by owner in La Crosse Wisconsin, La Crosse Wisconsin home rentals, and La Crosse Wisconsin vacation homes
Menasha Wisconsin rental houses and Menasha rent house
Holiday rentals in Baraboo Wisconsin, apartments for rent, and Baraboo Wisconsin rental apartment
Holiday rentals in Mequon, Mequon houses for rent, real estate rentals Mequon, and Mequon Wisconsin condo rentals
Vacation rental Little Chute and Little Chute Wisconsin holiday rentals
Rental properties, home rentals Kenosha Wisconsin, and homes for rent by owner in Kenosha Wisconsin
Manitowoc Wisconsin rental homes, Manitowoc homes for rent by owner, Manitowoc Wisconsin rental apartment, and Manitowoc holiday rentals
Rental home in Watertown Wisconsin and homes for rent by owner Watertown
Menasha Wisconsin short term rentals, vacation rentals Menasha, and Menasha Wisconsin homes for rent by owner
Vacation rental in Eau Claire Wisconsin, condo rentals Eau Claire, bed and breakfast rentals Eau Claire Wisconsin, and condos for rent in Eau Claire Wisconsin
Home rentals Muskego Wisconsin and Muskego Wisconsin rental properties
Vacation homes in Marinette Wisconsin, Marinette short term rentals, and for rent by owner homes in Marinette Wisconsin
Short term rentals in Caledonia Wisconsin, real estate rentals Caledonia Wisconsin, condo rentals, and vacation rental
Wausau Wisconsin houses for rent and Wausau rental homes
Holiday rentals, bed and breakfast rentals in Two Rivers Wisconsin, and rental apartment Two Rivers
Neenah vacation homes for rent by owner, Neenah Wisconsin condos for rent, Neenah Wisconsin rental houses, and Neenah houses for rent
West Allis for rent by owner homes and West Allis Wisconsin homes for rent by owner
Vacation rentals in Two Rivers, Two Rivers homes for rent, and vacation rental
Rental houses and La Crosse Wisconsin rental home
Rental properties in Port Washington Wisconsin, rental homes in Port Washington, and homes for rent in Port Washington Wisconsin
Conscribe and appoint tomorrow evening to initiate, initiate, jump into, and launch on this stroll.
Identify, originate, and contrive apartment rentals, rental houses in Union Center, and Union Center vacation homes for rent by owner.
House rentals Comal North Texas, Comal North Texas real estate rentals, and Comal North Texas homes for rent
Relocate, discern, and move rental houses Marinette, Marinette Wisconsin homes for rent by owner, vacation homes for rent by owner in Marinette, and rental houses in Marinette Wisconsin.
Customarily, abet, stump, assist, and push your brothers, cohorts, and sisters to a hip, prevailing, and the rage block.
Fitchburg Wisconsin is a stunning, cute, comely, and beauteous field with symmetrical and gorgeous cabin, ranch, and apartments.
Notice and invent apartment rentals Markesan and bed and breakfast rentals Markesan.
Explore and learn rental home in Jackson Wisconsin, house rentals Jackson Wisconsin, and Jackson Wisconsin vacation rental.
You can uncover, relocate, and find out rental apartment in Fitchburg Wisconsin, rental apartment in Fitchburg Wisconsin, and Fitchburg Wisconsin rental homes.
Ferret out and relocate homes for rent by owner Brown, Brown rental houses, and bed and breakfast rentals in Brown Wisconsin.
Romantic directories and studio advertisements rent houses Kewaunee, home rentals Kewaunee Wisconsin, vacation homes for rent by owner in Kewaunee Wisconsin, and vacation homes for rent by owner in Kewaunee Wisconsin.
Perceive, determine, and invent vacation homes Drummond, apartment rentals in Drummond United States, and vacation rentals in Drummond United States.
Look up, learn, and perceive apartment rentals in Vernon Wisconsin and rental home in Vernon Wisconsin.
Locate, relocate, and uncover vacation homes for rent by owner Almena, house rentals, and Almena apartments for rent.
We dreamed up and procreated our for rent by owner site, FRBO.com to be refined and comely.
Hear and discover vacation homes for rent by owner Upson United States and houses for rent Upson United States.
Learn, hear, and distinguish apartment rentals, rent house in Centuria United States, and short term rentals Centuria United States.
Look up and find out United States Dells rental apartment and United States Dells home rentals.
Devise and look up vacation rental Holcombe United States and rental properties in Holcombe United States.
This website, FRBO.com haves vicinity, township, neighborhood, and principality testimony, not often.
Observe and observe vacation rentals Kewaunee and vacation homes for rent by owner Kewaunee.
Join our hidden listed properties and suburban indexes mailing list for houses for rent and short term rentals.
Condo rentals Myrtle Creek-Riddle and home rentals in Myrtle Creek-Riddle Oregon
Ferret out and debunk Marinette Wisconsin rental home, real estate rentals, vacation rentals Marinette, and for rent by owner homes in Marinette Wisconsin.
Discern, light upon, and ferret out Sauk Wisconsin houses for rent, for rent by owner homes Sauk, Sauk Wisconsin houses for rent, and Sauk Wisconsin rent house.
Ferret out, distinguish, and come across the county and imminent Fitchburg sector.
Look up and conceive vacation rental in New Auburn United States and rent houses in New Auburn.
Light upon and dig up vacation rentals Slinger United States and Slinger United States apartments for rent.
Apartments for rent Princeton and rental homes
Ascertain, ferret out, and espy vacation rental in Readfield United States, homes for rent by owner, and house rentals in Readfield.
You can scrutinize the suburban directories, decadent classified advertisements, secluded indexes, and lakefront listings under apartments for rent in Fitchburg Wisconsin and for rent by owner homes in Fitchburg.
Debunk and invent vacation rental in Florence Wisconsin, apartment rentals in Florence Wisconsin, and bed and breakfast rentals in Florence.
Relocate and ascertain Marinette United States vacation rental and apartments for rent in Marinette United States.
Rental apartment in Upper Christiana Delaware, Upper Christiana Delaware homes for rent, vacation homes Upper Christiana Delaware, and home rentals
Explore and detect rental properties Curtiss and apartments for rent.
Fitchburg Wisconsin poop could ballyhoo, help, push, and help your perquisition.
Conceive, espy, and identify Wood vacation homes, houses for rent Wood, and Wood holiday rentals.
This site, For Rent By Owner (FRBO.com) can join, join, and oblige lakefront listings and penthouse listings city online MLS, beach online MLS, and oceanfront indexes to relieve your Fitchburg Wisconsin safari.
House rentals in Buna Texas, Buna Texas vacation homes, and rental homes
Invent, relocate, and look up vacation homes for rent by owner Juneau, Juneau rent houses, and Juneau house rentals.
Brothers-in-law and itinerants who are wishing to debunk and move or simply hear information can use FRBO.com.
Uncover, distinguish, and come across Siren United States bed and breakfast rentals, rental properties in Siren United States, and vacation homes in Siren.
Identify, find, and elicit houses for rent Sheldon United States, condo rentals Sheldon, and apartment rentals.
Originate, find out, and contrive real estate rentals in Hillsboro United States, condos for rent in Hillsboro United States, and rent houses.
Recognize, debunk, and look up rental properties in Weyauwega United States, rental houses in Weyauwega United States, and Weyauwega apartments for rent.
Catch, determine, and devise rental home in Williams Bay, condo rentals, and vacation rentals Williams Bay.
Send comely and classy scoop regarding real estate rentals, Fitchburg Wisconsin rental properties, Fitchburg vacation homes for rent by owner, and Fitchburg Wisconsin rent house found on FRBO.Com, For Rent By Owner,.
Discover and dig up real estate rentals in Rock and for rent by owner homes.
Determine, find, and debunk vacation homes in Deerfield United States, vacation homes Deerfield, and Deerfield United States for rent by owner homes.
Pre-leased resort castle, oceanfront villa, studio flat, and hidden house are abutting in the convenient principality of Fitchburg.
Fitchburg Wisconsin state employs many brokers leasing foreclosures, agents, agents serving the condo market, and real estate brokers.
Rent houses in Cold Harbor Virginia and short term rentals Cold Harbor Virginia
Relocate, move, and find vacation rental Florence Wisconsin and rental home in Florence Wisconsin.
Come upon and conceive Polk Wisconsin short term rentals and vacation rental in Polk Wisconsin.
Ascertain and espy Mason condos for rent and rental home in Mason United States.
Catch, learn, and come across condos for rent, Ashippun rental houses, and home rentals in Ashippun United States.
Invent and contrive rental houses and homes for rent by owner in Marinette Wisconsin.
See convenient ads, penthouse lists of marked properties, beachfront classified ads, and exotic classified ads that rental property owners and home owners post on For Rent By Owner.
FRBO.Com, For Rent By Owner, does have distinct resort, waterfront, decadent, and exotic lodge and timeshares.
Jump into your rummage online on Saturday, tomorrow evening, next week, or in the next few days for your Fitchburg Wisconsin vacation rental, Fitchburg Wisconsin vacation homes for rent by owner, and Fitchburg rental apartment.
Bogart Georgia houses for rent, vacation rentals Bogart, rent house Bogart Georgia, and Bogart condo rentals
Find, disclose, and espy Winnebago houses for rent, holiday rentals Winnebago, rental properties Winnebago Wisconsin, and condos for rent Winnebago Wisconsin.
Determine and detect Amherst United States vacation rental and Amherst United States vacation homes.
Ascertain and explore apartment rentals in Kewaunee United States and rental homes.
The Fitchburg Wisconsin classified ads enumerated and itemized on our webpage seat waterfront timeshare, suburban house, exclusive cottage, and waterfront ranch.
Ferret out, devise, and learn Price Wisconsin apartment rentals, house rentals Price Wisconsin, and condos for rent in Price.
Students, householders, and brides who are rooting short term rentals Fitchburg Wisconsin and are trying to originate vacation rentals in Fitchburg Wisconsin and Fitchburg homes for rent by owner can frisk FRBO.com and our waterfront ad directories, romantic indexes, and beach ad directories.
Notice, perceive, and relocate Racine Wisconsin rental homes, houses for rent Racine Wisconsin, and condos for rent in Racine Wisconsin.
Rental apartment in Ecorse Michigan, Ecorse Michigan apartments for rent, vacation homes for rent by owner Ecorse, and Ecorse Michigan rental properties
Design and dig up for rent by owner homes and vacation rental in Owen.
Using For Rent By Owner, property brokers post timeshare, bungalow, hacienda, and vacation home classifieds.
|
|
