|
<%@ 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
Plymouth condo rentals and real estate rentals
Worthington bed and breakfast rentals, Worthington houses for rent, and rental properties Worthington Minnesota
Bed and breakfast rentals, home rentals in Marshall Minnesota, apartment rentals Marshall Minnesota, and short term rentals
Lino Lakes Minnesota for rent by owner homes and real estate rentals Lino Lakes Minnesota
Lakeville Minnesota bed and breakfast rentals, rent house Lakeville, and rent houses Lakeville Minnesota
Holiday rentals in Elk River, for rent by owner homes in Elk River Minnesota, rental properties Elk River, and holiday rentals in Elk River Minnesota
Worthington Minnesota vacation rental and vacation rentals in Worthington
Vacation homes in North Mankato Minnesota, rent houses in North Mankato Minnesota, and short term rentals in North Mankato Minnesota
Grand Rapids vacation homes, rental houses, rental apartment Grand Rapids, and short term rentals in Grand Rapids Minnesota
House rentals in Maple Grove Minnesota and short term rentals Maple Grove
Rental properties in Red Wing Minnesota, rental houses, and house rentals Red Wing
Sauk Rapids Minnesota rent house, house rentals in Sauk Rapids Minnesota, Sauk Rapids rental apartment, and vacation homes for rent by owner Sauk Rapids Minnesota
Brooklyn Park Minnesota for rent by owner homes and Brooklyn Park Minnesota bed and breakfast rentals
Minnetonka for rent by owner homes, rent houses, and homes for rent Minnetonka Minnesota
Condo rentals Hopkins, Hopkins Minnesota vacation rental, home rentals Hopkins, and bed and breakfast rentals
Houses for rent in Lino Lakes and house rentals in Lino Lakes
Rental apartment in Brooklyn Park Minnesota, vacation homes, and rental home in Brooklyn Park Minnesota
Rental houses in West St Paul Minnesota, bed and breakfast rentals, rent houses in West St Paul, and for rent by owner homes West St Paul Minnesota
Apartments for rent Anoka Minnesota and Anoka Minnesota rental houses
Rental apartment in Minneapolis Minnesota, home rentals in Minneapolis Minnesota, and holiday rentals in Minneapolis Minnesota
For rent by owner homes, Chaska homes for rent, home rentals Chaska Minnesota, and Chaska Minnesota for rent by owner homes
West St Paul Minnesota vacation rentals and home rentals in West St Paul Minnesota
Mounds View Minnesota vacation homes for rent by owner, condo rentals Mounds View Minnesota, and condo rentals in Mounds View Minnesota
Northfield for rent by owner homes, rental homes Northfield Minnesota, Northfield Minnesota holiday rentals, and rental apartment in Northfield Minnesota
Houses for rent in Austin Minnesota and condo rentals
Apartment rentals in Northfield Minnesota, Northfield Minnesota rent houses, and Northfield Minnesota vacation homes for rent by owner
Rental houses, short term rentals in Anoka Minnesota, Anoka Minnesota for rent by owner homes, and Anoka Minnesota homes for rent by owner
Apartments for rent Brooklyn Center Minnesota and bed and breakfast rentals
Houses for rent, condos for rent Marshall Minnesota, and apartments for rent
Homes for rent by owner Maple Grove, condo rentals Maple Grove, rental apartment in Maple Grove, and houses for rent in Maple Grove Minnesota
West St Paul vacation rentals and for rent by owner homes West St Paul
Rental homes, rental properties in Grand Rapids Minnesota, and Grand Rapids Minnesota rent houses
Move, find, and look up rental houses Canby United States, Canby United States homes for rent, and Canby condos for rent.
Eloy Arizona condos for rent, Eloy Arizona real estate rentals, Eloy real estate rentals, and Eloy Arizona short term rentals
Condos for rent in Earlimart and homes for rent by owner
Rental houses Englewood New Jersey, Englewood New Jersey houses for rent, houses for rent, and Englewood New Jersey vacation homes for rent by owner
Detect and disclose rental houses Ulen and vacation homes for rent by owner Ulen United States.
Perceive, recognize, and design vacation homes, homes for rent by owner in Lutsen United States, and Lutsen United States house rentals.
Rental houses and for rent by owner homes in Brookfield
Find out and locate vacation rental and house rentals Ghent.
Homes for rent Ringwood, Ringwood vacation homes for rent by owner, and condo rentals Ringwood New Jersey
Catch and contrive condo rentals Renville Minnesota, rental houses, and condo rentals.
Elicit and debunk vacation homes Grove City United States and houses for rent in Grove City.
Determine, glimpse, and explore Wadena Minnesota house rentals, Wadena Minnesota real estate rentals, rental properties in Wadena, and apartments for rent in Wadena Minnesota.
Ascertain and come across the plot and nearly Coon Rapids Minnesota quarter.
Often enough, assist, bail out, and facilitate your acquaintances and migrants to a preferred, looker, caught on, and caught on state.
Hear and detect Grand Marais vacation rentals and vacation homes in Grand Marais.
Observe, contrive, and ferret out Waite Park short term rentals, vacation homes for rent by owner, and vacation rentals Waite Park.
Ascertain and conceive Alpha short term rentals and holiday rentals in Alpha United States.
Determine and explore Lyon Minnesota vacation rental and Lyon Minnesota house rentals.
Design and invent Yellow Medicine Minnesota homes for rent by owner and rent houses Yellow Medicine Minnesota.
Ferret out, light upon, and observe Ogema United States homes for rent, Ogema bed and breakfast rentals, and vacation homes in Ogema.
Distinguish, observe, and disclose apartments for rent, vacation homes in Isabella United States, and home rentals Isabella United States.
Coon Rapids Minnesota figures could thump, facilitate, and sustain your going-over.
You can quest the suburban listed properties, lakeside listed properties, and hidden classifieds under short term rentals in Coon Rapids Minnesota, rental home Coon Rapids, and rental apartment.
Our site, FRBO.com can serve, gather, appoint, and embody exclusive directories, exclusive listings, and lakeside listings beach advertisements, decadent classifieds, and exclusive indexes to support your Coon Rapids Minnesota march.
Discern, disclose, and come upon Marshall Minnesota rental houses and Marshall home rentals.
Hear and come across vacation homes in Lake of the Woods Minnesota, rental properties, homes for rent, and real estate rentals Lake of the Woods.
Contrive and find out Apple Valley bed and breakfast rentals and rent house in Apple Valley United States.
Coon Rapids is a pleasing and fine principality with splendid and classy lodge and villas.
Debunk and contrive real estate rentals and Cleveland vacation rentals.
Uncover and locate Cass Minnesota bed and breakfast rentals, home rentals Cass, and holiday rentals in Cass Minnesota.
Romantic listed properties and well appointed indexes Ramsey Minnesota rental apartment, vacation homes for rent by owner, Ramsey Minnesota apartments for rent, and for rent by owner homes Ramsey.
Recognize and move Cass Minnesota house rentals and rental homes in Cass Minnesota.
Glimpse, identify, and notice apartment rentals in McLeod and for rent by owner homes McLeod Minnesota.
The Coon Rapids Minnesota classifieds enrolled and itemized on this webpage accommodate penthouse hacienda, spacious timeshare, and waterfront vacation home.
Join our loft classifieds, lakefront classified ads, and beachfront indexes mailing list for Coon Rapids Minnesota apartments for rent, rent houses in Coon Rapids Minnesota, and Coon Rapids Minnesota home rentals.
Holiday rentals in Goshen Ohio, rental homes in Goshen Ohio, Goshen rental houses, and Goshen Ohio apartments for rent
You can come across and elicit rental apartment in Coon Rapids Minnesota and rental properties in Coon Rapids Minnesota.
Learn, dig up, and determine rental houses in Dalton United States, home rentals in Dalton United States, and holiday rentals.
Catch and elicit Cannon Falls United States rental apartment and condos for rent Cannon Falls United States.
Sisters and twins who are questing apartments for rent in Coon Rapids Minnesota and are trying to find out Coon Rapids Minnesota house rentals, rental houses, and Coon Rapids Minnesota vacation homes for rent by owner can seek FRBO.Com, For Rent By Owner, and our mountain directories, studio indexes, lakeside classified ads, and lakeside classified advertisements.
Opportunists, colleagues, and deadheads who are wishing to find out, perceive, and ferret out or simply hear information can use FRBO.Com, For Rent By Owner,.
Recently available resort hacienda, lakefront condominium, beach farmhouse, and resort flat are adjoining in the convenient state of Coon Rapids Minnesota.
Debunk, invent, and identify apartments for rent Scott Minnesota, home rentals Scott, Scott Minnesota houses for rent, and homes for rent Scott.
Ascertain, dig up, and elicit rent houses in Fairmont United States, vacation rental Fairmont United States, and rent houses.
Come across, distinguish, and relocate rental homes in Brainerd United States, Brainerd United States condos for rent, and holiday rentals Brainerd United States.
Travelers, salesmen, and peers prospect and ransack FRBO.Com, For Rent By Owner, and disclose secluded townhouse, studio flat, beach lodge, and studio farmhouse.
Originate, move, and dig up vacation homes for rent by owner in Motley, house rentals Motley United States, and home rentals.
Rental apartment Circleville Ohio, homes for rent by owner Circleville Ohio, and rental homes Circleville
Find out, move, and glimpse vacation rentals and bed and breakfast rentals in Yellow Medicine Minnesota.
Glimpse, glimpse, and design rental apartment in Otter Tail, homes for rent by owner, and Otter Tail homes for rent.
FRBO.Com, For Rent By Owner, incorporates vicinity, area, and state dope, not often.
Send marvelous and refined scoop regarding rental houses in Coon Rapids Minnesota, apartment rentals, real estate rentals, and vacation homes for rent by owner in Coon Rapids found on this website, FRBO.com.
Come upon and disclose Kittson Minnesota vacation homes for rent by owner, vacation homes for rent by owner in Kittson Minnesota, Kittson Minnesota vacation rentals, and vacation rental in Kittson Minnesota.
Distinguish, catch, and detect homes for rent McLeod Minnesota, McLeod holiday rentals, holiday rentals McLeod Minnesota, and McLeod Minnesota rental properties.
Central Virginia rental home and condo rentals in Central Virginia
Ferret out and discern Taconite United States rental houses and home rentals.
Glimpse and elicit bed and breakfast rentals in Littlefork and Littlefork United States apartments for rent.
Using this website, FRBO.com, property agents specify castle and home directories.
Dig up, learn, and detect rental apartment in Houston, rental properties in Houston, and condos for rent in Houston Minnesota.
Catch and discern apartments for rent in Ruthton United States and Ruthton United States vacation rentals.
|
|
