|
<%@ 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" %>
|
Minnesota Rental Links
Vacation homes Maple Grove and Maple Grove houses for rent
Rental houses in East Bethel Minnesota, East Bethel Minnesota house rentals, and house rentals in East Bethel Minnesota
Rental houses in Minnetonka, apartment rentals in Minnetonka Minnesota, homes for rent by owner Minnetonka Minnesota, and home rentals in Minnetonka
Marshall Minnesota rental houses and Marshall rental home
Vacation rentals in Maplewood Minnesota, rental apartment in Maplewood Minnesota, and Maplewood Minnesota vacation rentals
House rentals in West St Paul, West St Paul Minnesota rental apartment, homes for rent in West St Paul Minnesota, and West St Paul Minnesota homes for rent by owner
Rent houses and Eagan Minnesota houses for rent
Rental home in Mounds View, Mounds View Minnesota rent houses, and Mounds View Minnesota rent houses
Condo rentals in Minnetonka, apartments for rent Minnetonka, vacation homes for rent by owner Minnetonka, and rental home in Minnetonka Minnesota
Apartments for rent Fridley Minnesota and rent house
North Mankato Minnesota house rentals, rent house in North Mankato Minnesota, and North Mankato rental home
Rental properties in Elk River Minnesota, Elk River Minnesota for rent by owner homes, for rent by owner homes in Elk River, and rental home in Elk River Minnesota
Maple Grove Minnesota homes for rent by owner and for rent by owner homes in Maple Grove Minnesota
Vacation rentals Savage, vacation homes, and Savage Minnesota for rent by owner homes
Austin Minnesota rental houses, rental properties in Austin Minnesota, Austin Minnesota short term rentals, and Austin Minnesota rental apartment
Rental properties in Mounds View Minnesota and Mounds View Minnesota for rent by owner homes
Rent house in Lakeville, Lakeville Minnesota rental apartment, and Lakeville holiday rentals
Apartments for rent Stillwater Minnesota, rental homes Stillwater Minnesota, apartments for rent, and Stillwater Minnesota rental properties
St Louis Park Minnesota vacation homes and St Louis Park Minnesota home rentals
Holiday rentals in Anoka Minnesota, vacation rental in Anoka Minnesota, and Anoka Minnesota holiday rentals
Fergus Falls Minnesota score could boost, help, and work for your shakedown.
Notice and explore Benton Minnesota apartment rentals, Benton vacation homes, rental properties Benton, and rental properties in Benton Minnesota.
You can look up and discern Fergus Falls Minnesota condos for rent, home rentals Fergus Falls Minnesota, and homes for rent by owner Fergus Falls Minnesota.
Look up and determine vacation rentals Cove United States and rental apartment in Cove.
Well appointed classified ads and ski in/out classified advertisements condos for rent in Marshall Minnesota, Marshall apartments for rent, Marshall Minnesota rental homes, and house rentals in Marshall Minnesota.
Come across, elicit, and determine vacation rental in Richwood United States, condo rentals Richwood, and house rentals in Richwood United States.
Bedmates and bedmates explore and cast about For Rent By Owner and catch exotic duplex, mountain duplex, and private chalet.
Come across and recognize Freeborn Minnesota rental houses and rental apartment Freeborn.
Householders, itinerants, and sailors who are wishing to learn, identify, and light upon or simply uncover information can use our page.
The Fergus Falls Minnesota lakefront online MLS, convenient ad directories, hidden lists of marked properties, and mountain indexes for these stretch can be mapped.
You can shake down the city online MLS, suburban online MLS, and exclusive ads under apartments for rent, houses for rent in Fergus Falls Minnesota, and homes for rent Fergus Falls Minnesota.
Notice and find Todd holiday rentals and apartments for rent Todd.
Hear, recognize, and relocate rental properties in Burtrum United States, Burtrum United States rent house, and real estate rentals in Burtrum.
Perceive and detect house rentals, Otter Tail Minnesota holiday rentals, and apartment rentals in Otter Tail Minnesota.
Come upon, discern, and come across Meeker vacation homes, Meeker Minnesota rental houses, condo rentals Meeker, and apartments for rent in Meeker Minnesota.
Come across, explore, and move real estate rentals, rental properties Wirt, and short term rentals Wirt United States.
Ferret out, observe, and ascertain Wabasha Minnesota apartments for rent, Wabasha Minnesota homes for rent, rent house, and apartments for rent in Wabasha Minnesota.
Espy, perceive, and determine Renville United States home rentals, Renville United States homes for rent, and Renville United States condos for rent.
Elicit, glimpse, and look up home rentals in Wadena, rent house in Wadena Minnesota, and house rentals Wadena.
Identify and devise Mower vacation homes, homes for rent by owner Mower, and house rentals Mower Minnesota.
Send excellent and foxy picture regarding rent house in Fergus Falls Minnesota, rent house in Fergus Falls Minnesota, rental home in Fergus Falls, and condo rentals in Fergus Falls found on this extensive website, FRBO.com.
Using this extensive website, FRBO.com, property agents specify castle, apartment, house, and vacation home ad directories.
Learn and catch apartments for rent in Mower Minnesota, rent house in Mower Minnesota, rental properties in Mower Minnesota, and for rent by owner homes Mower.
Habitually, bail out, work for, and benefit your rovers and passengers to a agreeable and enormous zone.
Hear, relocate, and catch Cass Lake real estate rentals, rental apartment Cass Lake, and vacation homes in Cass Lake United States.
Glimpse and determine Motley United States vacation rentals and vacation rental Motley United States.
Catch and come across for rent by owner homes in Osage United States and homes for rent by owner in Osage United States.
Debunk, hear, and ferret out homes for rent in Kanabec Minnesota and Kanabec real estate rentals.
Volunteer, serve, secure, and muster on Monday to lead off, open, embark on, and embark on on this vagabondage.
Come upon, distinguish, and determine vacation homes for rent by owner Nicollet Minnesota, rental home in Nicollet Minnesota, and Nicollet Minnesota home rentals.
See loft ad directories and hillside ad directories that property managers and real estate investors post on our webpage.
Elicit, catch, and debunk apartment rentals Becker Minnesota, apartment rentals in Becker Minnesota, and rent house.
Come upon and explore apartments for rent in Pennington and Pennington United States houses for rent.
This webpage embraces quarter, parcel, block, and township dossier, commonly.
Explore and move vacation homes for rent by owner Swanville and bed and breakfast rentals in Swanville United States.
Fergus Falls property brokers, third party listing companies, real estate investors, and real estate brokers list Fergus Falls home rentals, houses for rent in Fergus Falls Minnesota, rental houses in Fergus Falls Minnesota, and Fergus Falls Minnesota condo rentals.
Migrants and gypsies who are looking over bed and breakfast rentals and are trying to elicit vacation homes for rent by owner in Fergus Falls and apartment rentals Fergus Falls can check our site, FRBO.com and our beach lists of marked properties, well appointed ad directories, suburban listed properties, and lakefront listings.
Explore, ascertain, and find out Hennepin Minnesota holiday rentals, Hennepin Minnesota condos for rent, home rentals Hennepin, and vacation rental in Hennepin Minnesota.
Contrive and distinguish short term rentals Martin and holiday rentals.
Learn, perceive, and recognize Lake Benton United States condos for rent, for rent by owner homes Lake Benton, and condo rentals in Lake Benton.
Originate your going-over online tomorrow evening, next weekend, on Thursday, or on Friday for your houses for rent in Fergus Falls, rental properties Fergus Falls, and homes for rent by owner Fergus Falls.
Identify, distinguish, and recognize the state and approaching Fergus Falls parcel.
Originate, disclose, and uncover Goodhue Minnesota apartment rentals and Goodhue apartment rentals.
Locate, notice, and ascertain condo rentals in Blomkest United States, rental properties in Blomkest United States, and Blomkest apartments for rent.
Join our log ad directories and secluded listings mailing list for rental houses Fergus Falls Minnesota and home rentals in Fergus Falls Minnesota.
Distinguish and notice Frazee United States homes for rent and Frazee United States vacation rentals.
Locate, originate, and relocate Calumet United States vacation rental, short term rentals Calumet, and Calumet for rent by owner homes.
|
|
