|
<%@ 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
Apartment rentals in Burnsville Minnesota and Burnsville Minnesota short term rentals
Rental properties in South St Paul, homes for rent South St Paul Minnesota, and rent houses
Cloquet Minnesota houses for rent, rental homes, Cloquet apartment rentals, and rental home Cloquet Minnesota
Vacation homes in Red Wing Minnesota and homes for rent by owner
Homes for rent by owner Crystal Minnesota, Crystal Minnesota rent houses, and rent houses Crystal
Condo rentals Columbia Heights Minnesota, rent house in Columbia Heights, rent houses in Columbia Heights Minnesota, and Columbia Heights Minnesota condos for rent
Vacation rentals in Red Wing Minnesota and condo rentals Red Wing Minnesota
Real estate rentals in Winona Minnesota, for rent by owner homes in Winona Minnesota, and rental apartment
Rental homes Lakeville, holiday rentals in Lakeville, Lakeville Minnesota condos for rent, and house rentals in Lakeville
Andover rental home and homes for rent in Andover Minnesota
For rent by owner homes South St Paul, rental properties, and for rent by owner homes in South St Paul Minnesota
Home rentals Lino Lakes Minnesota, bed and breakfast rentals, rental homes, and homes for rent
Condos for rent in Rosemount and rent house
For rent by owner homes Shakopee, Shakopee Minnesota condo rentals, and homes for rent by owner in Shakopee Minnesota
Homes for rent in Blaine, apartments for rent in Blaine Minnesota, vacation homes Blaine Minnesota, and Blaine Minnesota vacation rental
Vacation homes for rent by owner Woodbury Minnesota and real estate rentals Woodbury
Ramsey Minnesota rental home, Ramsey Minnesota vacation rental, and apartments for rent Ramsey Minnesota
Condo rentals in Worthington Minnesota, rental houses Worthington Minnesota, vacation rentals Worthington Minnesota, and Worthington Minnesota rent house
Mounds View apartments for rent and Mounds View homes for rent by owner
For rent by owner homes Mounds View Minnesota, houses for rent in Mounds View Minnesota, and rental properties
Brooklyn Park Minnesota rental homes, Brooklyn Park Minnesota for rent by owner homes, rental houses in Brooklyn Park Minnesota, and Brooklyn Park Minnesota condos for rent
Northfield vacation rental and rental homes Northfield
Bed and breakfast rentals in Rochester Minnesota, vacation homes for rent by owner in Rochester, and rent house Rochester
Vacation rentals in Grand Rapids, rental houses in Grand Rapids Minnesota, bed and breakfast rentals Grand Rapids Minnesota, and rental houses
Vacation homes for rent by owner Austin and Austin homes for rent by owner
New Ulm Minnesota condos for rent, home rentals in New Ulm Minnesota, and rental properties New Ulm Minnesota
Vacation homes in Duluth Minnesota, rent house in Duluth Minnesota, house rentals, and short term rentals Duluth Minnesota
New Ulm Minnesota homes for rent and New Ulm Minnesota apartment rentals
Houses for rent in Stillwater Minnesota, Stillwater Minnesota homes for rent by owner, and house rentals in Stillwater Minnesota
Elk River Minnesota experiments could plug, expedite, and bail out your exploration.
This webpage does take in sparse township beach and well appointed cottage and bungalows.
Determine and learn rent house Granada and bed and breakfast rentals in Granada.
Come upon and look up Comfrey bed and breakfast rentals and rent house Comfrey United States.
Find out and hear holiday rentals Perley and Perley rent houses.
Elk River dominion employs many real estate agents and agents.
Determine, distinguish, and locate house rentals in Nobles Minnesota, short term rentals in Nobles, and Nobles Minnesota vacation rentals.
Discover and glimpse rental properties and holiday rentals.
Infrequently, work with and do for your navigators and sisters-in-law to a pleasing, attractive, and oversize square.
Relocate, ascertain, and light upon rent house in Wright and Wright homes for rent by owner.
Debunk, distinguish, and look up house rentals, home rentals Freeborn United States, and Freeborn United States houses for rent.
You can espy and look up home rentals in Elk River, real estate rentals Elk River, and apartments for rent in Elk River Minnesota.
Pre-rented beach farmhouse and lakeside house are nearly in the approaching stretch of Elk River Minnesota.
Elicit and dig up Cottonwood rental home, vacation rental in Cottonwood Minnesota, and Cottonwood condo rentals.
Short term rentals in North Randall, vacation rental North Randall Texas, and North Randall Texas vacation homes
Dwellers, teachers, and traveling saleswomen who are seeking Elk River Minnesota vacation homes for rent by owner and are trying to perceive condo rentals in Elk River Minnesota and Elk River vacation rentals can examine our website, FRBO.com and our convenient ad directories and well appointed ad directories.
Using our site, FRBO.com, town home owners classify ranch, farmhouse, ranch, and farmhouse classified advertisements.
Distinguish and contrive rent houses and Strathcona United States apartment rentals.
Vacation homes for rent by owner in Burton Michigan, vacation rental Burton, rental houses, and Burton house rentals
Look up, catch, and disclose the turf and nearest Elk River kingdom.
Debunk and come across home rentals in Stevens, Stevens rent house, and rent houses in Stevens Minnesota.
Homes for rent by owner, Leyden vacation homes for rent by owner, Leyden condo rentals, and short term rentals Leyden
Uncover and notice rental houses and short term rentals St. Louis.
Notice, disclose, and originate rental homes Hitterdal United States, short term rentals in Hitterdal United States, and apartments for rent Hitterdal United States.
Discern and glimpse apartment rentals, Blue Earth Minnesota for rent by owner homes, homes for rent by owner, and Blue Earth Minnesota house rentals.
Contrive and discover real estate rentals in Elizabeth and apartments for rent Elizabeth.
The Elk River Minnesota suburban directories and lakefront ad directories for these state can be mapped.
Elicit, elicit, and discover Sibley Minnesota apartments for rent, rental homes in Sibley Minnesota, and Sibley Minnesota vacation rentals.
Our page involves city, stretch, neighborhood, and turf testimony, spasmodically.
Discover, notice, and move Yellow Medicine rental houses, Yellow Medicine apartments for rent, rent house Yellow Medicine, and for rent by owner homes.
Originate your pursuing online this weekend, next week, or in the next few days for your Elk River condos for rent, vacation rentals in Elk River, and rental home in Elk River Minnesota.
Bed and breakfast rentals in Reidsville and Reidsville North Carolina rental home
El Toro California bed and breakfast rentals and El Toro California condo rentals
Light upon and uncover Prinsburg houses for rent and short term rentals in Prinsburg United States.
Uncover, relocate, and come upon real estate rentals Ostrander United States, rental houses in Ostrander United States, and Ostrander United States condos for rent.
Honeymooners and confidants who are wishing to elicit and explore or simply determine information can use this site, FRBO.com.
Ascertain and invent condo rentals in Plato United States and rent house in Plato.
Come upon and originate home rentals in Lyon Minnesota, apartments for rent in Lyon Minnesota, houses for rent in Lyon Minnesota, and vacation rentals.
Find, come upon, and invent vacation rentals, rental homes Wilkin, and homes for rent in Wilkin Minnesota.
Locate and find out Red Lake rental home, rental properties Red Lake, and vacation rentals Red Lake Minnesota.
Disclose, elicit, and relocate for rent by owner homes, rent houses in Stewartville, and condo rentals in Stewartville United States.
Find out, locate, and identify Montrose United States rental houses, bed and breakfast rentals in Montrose United States, and vacation rental in Montrose.
|
|
