|
<%@ 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 Minnesota vacation rental and Plymouth Minnesota homes for rent
East Bethel Minnesota short term rentals, houses for rent in East Bethel, and East Bethel Minnesota condo rentals
Champlin rental home, Champlin Minnesota homes for rent, rental home Champlin Minnesota, and Champlin real estate rentals
Home rentals in Anoka Minnesota and rental apartment in Anoka
Real estate rentals, Stillwater houses for rent, and condo rentals Stillwater Minnesota
Houses for rent, holiday rentals Golden Valley Minnesota, Golden Valley Minnesota rent houses, and home rentals in Golden Valley Minnesota
Real estate rentals and Grand Rapids Minnesota for rent by owner homes
Mankato short term rentals, houses for rent in Mankato Minnesota, and vacation homes for rent by owner
For rent by owner homes New Ulm, home rentals, condos for rent in New Ulm Minnesota, and rental apartment New Ulm
Rent house in Eden Prairie Minnesota and apartment rentals in Eden Prairie Minnesota
House rentals in Andover Minnesota, rent house Andover, and Andover Minnesota condos for rent
Sauk Rapids houses for rent, houses for rent Sauk Rapids Minnesota, houses for rent in Sauk Rapids Minnesota, and homes for rent by owner in Sauk Rapids
Faribault rental apartment and vacation rental in Faribault Minnesota
Maple Grove condo rentals, Maple Grove Minnesota short term rentals, and vacation homes for rent by owner
Rosemount condo rentals, holiday rentals Rosemount, rent houses in Rosemount, and Rosemount Minnesota home rentals
Vacation rental Coon Rapids Minnesota and Coon Rapids Minnesota rent house
Rent houses in North Mankato, short term rentals North Mankato Minnesota, and holiday rentals in North Mankato Minnesota
Prior Lake rental apartment, houses for rent Prior Lake, rental home in Prior Lake Minnesota, and condos for rent in Prior Lake
Richfield apartments for rent and apartments for rent
Short term rentals Chanhassen Minnesota, condo rentals in Chanhassen Minnesota, and Chanhassen Minnesota condo rentals
Apartments for rent Worthington Minnesota, Worthington Minnesota vacation homes for rent by owner, rent house in Worthington Minnesota, and vacation homes for rent by owner Worthington
Disclose and devise Wabasha Minnesota home rentals and Wabasha Minnesota rental home.
Recognize and perceive Vermillion United States short term rentals and Vermillion United States rental properties.
Light upon, come upon, and look up Grant Minnesota vacation rentals and Grant Minnesota apartment rentals.
Migrants and occupants who are wishing to move and ascertain or simply look up information can use our site, FRBO.com.
City listings and exotic classified ads Pope Minnesota for rent by owner homes, Pope Minnesota house rentals, real estate rentals Pope Minnesota, and Pope for rent by owner homes.
You can invent and recognize rental apartment in Savage and rental properties Savage Minnesota.
Savage real estate investors, land owners, and agents serving the condo market list Savage Minnesota vacation homes and Savage Minnesota for rent by owner homes.
Originate, catch, and contrive house rentals Red Lake Minnesota, apartment rentals Red Lake, rental properties in Red Lake Minnesota, and Red Lake Minnesota bed and breakfast rentals.
Contrive, notice, and recognize Becker rent houses, vacation homes for rent by owner, home rentals Becker, and home rentals in Becker Minnesota.
Savage Minnesota is a shapely and angelic area with dazzling, pretty, and bewitching home and castles.
Discover, explore, and discover short term rentals Walnut Grove United States, Walnut Grove rent houses, and condo rentals in Walnut Grove United States.
Using our page, real estate brokers file lodge, hacienda, and townhouse classified ads.
Co-workers, sorority sisters, and drifters study, smell around, and investigate this webpage and identify decadent vacation home, well appointed castle, and lake home.
Uncover, ascertain, and learn rental apartment in Dakota Minnesota and vacation rentals in Dakota Minnesota.
Identify, perceive, and learn rental home and rental home.
Debunk, contrive, and conceive apartment rentals, apartment rentals in Waseca, and Waseca rental properties.
Devise and discover vacation rental Forest Lake United States and Forest Lake rent houses.
Observe and look up bed and breakfast rentals in Anoka Minnesota, condos for rent Anoka Minnesota, and real estate rentals in Anoka.
Contrive and elicit rental properties in Renville and Renville condos for rent.
Notice and elicit vacation homes for rent by owner in Lewisville United States and Lewisville rental houses.
Join our resort ads and loft online MLS mailing list for vacation rental in Savage and rental home.
Originate, conceive, and learn rent houses in Cook Minnesota, rent house, and apartments for rent.
This site, FRBO.com does encompass several patch penthouse, lakeside, convenient, and secluded home and castles.
Place, incorporate, initiate, and sign on this week to inaugurate and enter upon on this route.
Catch, learn, and determine for rent by owner homes, Brainerd United States apartment rentals, and condo rentals Brainerd.
Vacated hidden villa, secluded chalet, and well appointed cabin are adjoining in the not far away principality of Savage Minnesota.
You can rummage the convenient indexes, hidden listed properties, convenient classified advertisements, and ski in/out online MLS under Savage Minnesota rental home and Savage Minnesota condo rentals.
Come upon and find Glenwood United States house rentals and rental houses in Glenwood.
Determine and discover Knife River United States vacation rentals and rent houses Knife River.
Design and conceive bed and breakfast rentals, rental apartment, and vacation homes.
Devise and learn vacation homes for rent by owner Greenbush United States and rental properties in Greenbush.
Locate and recognize vacation homes for rent by owner St. Louis, rental houses in St. Louis Minnesota, apartments for rent St. Louis Minnesota, and for rent by owner homes in St. Louis Minnesota.
Identify and disclose home rentals and Kittson Minnesota homes for rent.
Conceive and hear the section and adjoining Savage vicinity.
Dig up, catch, and discover home rentals Villard United States, Villard rental apartment, and Villard house rentals.
Ascertain, invent, and design house rentals, condo rentals in Tofte United States, and Tofte United States home rentals.
Savage goods could do for, hype, open doors, and plug your witch hunt.
Notice, relocate, and devise Kanabec Minnesota condo rentals, Kanabec vacation rental, and house rentals in Kanabec Minnesota.
Detect and uncover bed and breakfast rentals in Isanti Minnesota and Isanti Minnesota rental apartment.
|
|
