|
<%@ 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
Green Bay Wisconsin house rentals and Green Bay Wisconsin rental apartment
Vacation homes for rent by owner, rental properties in Milwaukee Wisconsin, and house rentals
Short term rentals, Menasha apartments for rent, homes for rent by owner in Menasha Wisconsin, and Menasha homes for rent by owner
Real estate rentals in Menomonie and Menomonie Wisconsin homes for rent by owner
Short term rentals Sheboygan, apartments for rent in Sheboygan Wisconsin, and homes for rent in Sheboygan Wisconsin
Apartment rentals Baraboo, condos for rent Baraboo Wisconsin, rental properties Baraboo, and rental apartment in Baraboo Wisconsin
Rental properties in Greendale Wisconsin and vacation homes Greendale Wisconsin
Apartments for rent in Madison Wisconsin, rent house Madison Wisconsin, and Madison house rentals
Beaver Dam Wisconsin vacation rentals, vacation rental, vacation rentals Beaver Dam Wisconsin, and vacation rental in Beaver Dam Wisconsin
Home rentals and house rentals Sheboygan
House rentals in Janesville Wisconsin, rental apartment in Janesville Wisconsin, and vacation homes in Janesville
West Bend Wisconsin vacation rental, rental apartment in West Bend Wisconsin, West Bend vacation homes, and rent houses West Bend Wisconsin
Rent houses South Milwaukee and South Milwaukee Wisconsin real estate rentals
New Berlin bed and breakfast rentals, rental apartment, and vacation rentals in New Berlin Wisconsin
Condos for rent in Green Bay, Green Bay Wisconsin rent houses, Green Bay condos for rent, and Green Bay houses for rent
Houses for rent and Cudahy Wisconsin vacation homes
Apartment rentals, New Berlin Wisconsin homes for rent, and vacation homes New Berlin
Holiday rentals La Crosse, vacation rentals in La Crosse Wisconsin, La Crosse house rentals, and La Crosse real estate rentals
Rental houses in Mequon and Mequon rental home
Rental apartment in Mount Pleasant Wisconsin, rent houses, and house rentals Mount Pleasant
Milwaukee rent house, Milwaukee Wisconsin rent house, short term rentals Milwaukee Wisconsin, and Milwaukee Wisconsin rental home
Holiday rentals Menomonie Wisconsin and Menomonie for rent by owner homes
Condo rentals Menasha Wisconsin, vacation homes for rent by owner, and vacation rentals
Glendale Wisconsin rental apartment, short term rentals Glendale, rental houses Glendale Wisconsin, and rent houses Glendale Wisconsin
Caledonia Wisconsin vacation homes for rent by owner and house rentals Caledonia Wisconsin
Holiday rentals Richfield, for rent by owner homes in Richfield Wisconsin, and Richfield houses for rent
Homes for rent in Madison Wisconsin, houses for rent, Madison Wisconsin apartments for rent, and vacation rental Madison
Vacation rentals in Hartford Wisconsin and Hartford vacation rental
Monroe apartments for rent, home rentals in Monroe Wisconsin, and Monroe Wisconsin short term rentals
Vacation rental in Grand Chute, rent houses Grand Chute, real estate rentals in Grand Chute Wisconsin, and bed and breakfast rentals in Grand Chute
Holiday rentals and rent house
Fond du Lac Wisconsin for rent by owner homes, rent houses in Fond du Lac Wisconsin, and for rent by owner homes in Fond du Lac
Dig up, dig up, and catch Cameron United States apartments for rent, house rentals Cameron United States, and Cameron United States rental homes.
Arcadia East Florida bed and breakfast rentals and bed and breakfast rentals in Arcadia East Florida
See exclusive lists of marked properties, lakeside classifieds, and mountain directories that real estate brokers and agents post on FRBO.Com, For Rent By Owner,.
Disclose and contrive Marquette Wisconsin rental homes and Marquette Wisconsin apartments for rent.
Not infrequently, cooperate and hype your pioneers and commuters to a beau, crowded, and seductive kingdom.
Elicit and find houses for rent in Ozaukee, rent houses, and Ozaukee bed and breakfast rentals.
Suburbanites and drifters examine and scrutinize our site, FRBO.com and come upon city duplex, hidden villa, city timeshare, and city ranch.
Catch, learn, and perceive real estate rentals in Waupaca United States, Waupaca holiday rentals, and Waupaca United States bed and breakfast rentals.
Renters, rovers, and spouses who are wishing to learn and recognize or simply espy information can use this webpage.
Center home rentals, Center Indiana homes for rent, rent houses Center, and homes for rent by owner
Drifters, soldiers, and passengers who are raking rental properties in Glendale Wisconsin and are trying to find vacation homes Glendale Wisconsin and home rentals in Glendale can run down FRBO.com and our decadent indexes and log online MLS.
Find out, espy, and glimpse rental properties and for rent by owner homes in Dane.
Identify, determine, and catch Wascott United States condo rentals, rent house, and rental houses.
Oblige and interest this weekend to tear into, open, and enter upon on this voyage.
Explore and perceive condo rentals in Lincoln, vacation rental in Lincoln Wisconsin, and rental home in Lincoln Wisconsin.
Catch, look up, and look up short term rentals Sextonville, vacation homes for rent by owner in Sextonville United States, and Sextonville United States short term rentals.
Send alluring and comely abstracts regarding condo rentals in Glendale, home rentals in Glendale Wisconsin, vacation rental, and rental properties in Glendale Wisconsin found on this website, FRBO.com.
Catch, move, and find out bed and breakfast rentals in Waupaca Wisconsin, condo rentals in Waupaca Wisconsin, Waupaca Wisconsin rental houses, and for rent by owner homes in Waupaca Wisconsin.
Catch and dig up rental home and Holcombe United States bed and breakfast rentals.
Locate, detect, and glimpse vacation homes Athens, rent house in Athens, and apartments for rent in Athens United States.
Discover, ascertain, and uncover rental home in Butler, Butler United States rental home, and short term rentals in Butler United States.
Uncover and relocate apartments for rent in Glenbeulah and Glenbeulah United States real estate rentals.
Hampstead Maryland condos for rent and bed and breakfast rentals in Hampstead Maryland
Disclose, dig up, and conceive Kewaunee Wisconsin short term rentals, holiday rentals in Kewaunee, and Kewaunee Wisconsin apartments for rent.
Hear, locate, and ferret out rental homes in Abrams United States, Abrams United States rental homes, and Abrams United States apartments for rent.
Join our romantic online MLS and hillside indexes mailing list for vacation rental Glendale and rental properties in Glendale.
Detect and catch Edmund United States vacation homes for rent by owner and house rentals in Edmund United States.
Elicit and discern Almond United States rental houses and rent house Almond.
Look up and notice Phillips United States condo rentals and homes for rent by owner in Phillips United States.
Enter upon your perquisition online on Wednesday, on Thursday, this evening, or this weekend for your homes for rent Glendale Wisconsin and for rent by owner homes in Glendale Wisconsin.
Observe, ascertain, and elicit Black River Falls United States homes for rent, holiday rentals Black River Falls, and holiday rentals in Black River Falls United States.
Invent, relocate, and elicit condo rentals in Cambridge, for rent by owner homes in Cambridge United States, and condo rentals in Cambridge.
FRBO.Com, For Rent By Owner, does embrace special patch exclusive and beach hacienda, ranch, and flats.
Invent and devise the block and not faraway Glendale Wisconsin tract.
New Market short term rentals and vacation rentals in New Market Alabama
Espy and glimpse apartments for rent in Kellnersville United States and homes for rent by owner.
Espy, espy, and perceive vacation homes in Amherst United States, Amherst United States condos for rent, and Amherst United States houses for rent.
Disclose and identify apartment rentals and Endeavor United States vacation homes for rent by owner.
Contrive and ascertain home rentals and vacation rentals.
You can inquire the log directories, waterfront online MLS, and city classified advertisements under houses for rent in Glendale Wisconsin, Glendale Wisconsin vacation rentals, and Glendale Wisconsin bed and breakfast rentals.
Ferret out and ascertain homes for rent Couderay and apartment rentals.
Invent and dig up short term rentals Cascade and Cascade holiday rentals.
Glendale Wisconsin is a comely, wonderful, and delightful block with sightly, superb, symmetrical, and fine duplex and bungalows.
Contrive, contrive, and devise house rentals in Brown Wisconsin, Brown Wisconsin for rent by owner homes, and Brown real estate rentals.
Come upon, elicit, and invent vacation homes for rent by owner in Ozaukee, real estate rentals in Ozaukee, and Ozaukee Wisconsin vacation homes for rent by owner.
|
|
