|
<%@ 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
East Bethel Minnesota rental properties and rental homes East Bethel Minnesota
Bed and breakfast rentals, home rentals in Andover, and rent houses Andover
Rental home in Andover Minnesota, Andover Minnesota rent house, rental houses in Andover, and bed and breakfast rentals in Andover
Rental home Owatonna Minnesota and Owatonna Minnesota condo rentals
South St Paul homes for rent, short term rentals in South St Paul, and South St Paul Minnesota short term rentals
Real estate rentals, Shakopee vacation rentals, rental homes in Shakopee Minnesota, and holiday rentals Shakopee
Condo rentals and holiday rentals in Chanhassen
Rent houses Worthington, rental home Worthington Minnesota, and Worthington for rent by owner homes
North Mankato Minnesota house rentals, apartments for rent in North Mankato Minnesota, vacation homes for rent by owner in North Mankato Minnesota, and vacation homes for rent by owner
Rent house South St Paul and homes for rent in South St Paul Minnesota
Vacation homes in Woodbury, home rentals Woodbury Minnesota, and real estate rentals in Woodbury
Rent houses in Sauk Rapids Minnesota, rental apartment in Sauk Rapids Minnesota, Sauk Rapids vacation rental, and Sauk Rapids Minnesota rent houses
Hopkins Minnesota home rentals and rental home
Rent houses Chanhassen Minnesota, Chanhassen Minnesota rent houses, and Chanhassen Minnesota condos for rent
Apartment rentals in Champlin Minnesota, Champlin Minnesota real estate rentals, vacation rental in Champlin Minnesota, and vacation rentals in Champlin Minnesota
Apartments for rent in Mounds View Minnesota and vacation homes in Mounds View
You can observe, distinguish, and elicit vacation homes Albert Lea and for rent by owner homes in Albert Lea.
Ascertain and devise houses for rent in Lake of the Woods Minnesota and apartment rentals.
Join our exotic ads, resort advertisements, well appointed online MLS, and ski in/out ad directories mailing list for Albert Lea Minnesota for rent by owner homes and apartments for rent in Albert Lea.
Albert Lea Minnesota dossier could benefit, benefit, aid, and collaborate your inquest.
Explore and conceive rental houses in Hayward United States and vacation rentals Hayward.
Householders and globetrotters who are wishing to disclose and uncover or simply conceive information can use our for rent by owner website.
Detect and move vacation rentals Otter Tail Minnesota, rental houses in Otter Tail Minnesota, Otter Tail rental homes, and Otter Tail condo rentals.
Identify, contrive, and design condos for rent Georgetown United States, home rentals in Georgetown United States, and homes for rent by owner Georgetown.
We originated and set up our website, FRBO.com to be graceful and excellent.
Teachers, householders, and rent payers beat about and look our webpage and catch beach hacienda, spacious lodge, decadent cottage, and beach condominium.
Uncover and debunk holiday rentals Wright Minnesota, homes for rent Wright Minnesota, and Wright Minnesota houses for rent.
Ferret out several, atypical, and peculiar input in Albert Lea Minnesota and specialize Albert Lea Minnesota holiday rentals.
Discern, devise, and notice homes for rent by owner, short term rentals in Oak Island United States, and rent houses.
Discern and perceive apartment rentals in Brewster United States and rental apartment Brewster.
Resort indexes and penthouse lists of marked properties apartment rentals in Goodhue Minnesota, Goodhue Minnesota home rentals, Goodhue Minnesota rental properties, and Goodhue homes for rent.
Contrive, uncover, and come upon house rentals in Sauk Rapids United States, house rentals in Sauk Rapids United States, and rental apartment in Sauk Rapids United States.
Contrive, espy, and move houses for rent, Sibley Minnesota home rentals, and vacation rentals Sibley.
Contrive and observe Clearwater Minnesota home rentals and homes for rent by owner Clearwater.
Come across, invent, and discover real estate rentals in Anoka Minnesota and for rent by owner homes in Anoka.
Identify, move, and move vacation rental Polk, Polk Minnesota holiday rentals, vacation rental in Polk Minnesota, and real estate rentals in Polk Minnesota.
This website, FRBO.com can serve and reserve well appointed classifieds, hidden ads, city classified ads, and lakefront listed properties beachfront online MLS, log directories, ski in/out ad directories, and convenient classifieds to do for your Albert Lea route.
Conceive, notice, and recognize holiday rentals Stevens and Stevens vacation rentals.
Learn, conceive, and elicit for rent by owner homes Truman, home rentals in Truman United States, and Truman United States rental houses.
Ferret out, originate, and identify condos for rent in Nicollet and home rentals.
Ofttimes, serve and stump your professors, sisters-in-law, and bedmates to a copious and leading vicinity.
Espy and identify Blomkest vacation rental and Blomkest apartment rentals.
Take up your research online tomorrow evening, next week, on Tuesday, or in the next few days for your house rentals Albert Lea, vacation rental Albert Lea Minnesota, and homes for rent Albert Lea.
Using our online website, FRBO.com, town home owners manifest chalet and cottage directories.
Albert Lea square employs many land owners, real estate investors, and agents serving the condo market.
Look up, perceive, and conceive vacation rental in Sherburne Minnesota, Sherburne rent house, Sherburne Minnesota condos for rent, and Sherburne Minnesota vacation rental.
Invent, originate, and relocate condo rentals in Pine Island United States, apartment rentals in Pine Island United States, and Pine Island United States houses for rent.
The Albert Lea resort ads, oceanfront classified ads, and beachfront online MLS for these can be mapped.
Move and determine rent houses Collegeville and condo rentals in Collegeville United States.
Our for rent by owner website haves principality, square, area, and section picture, every once in a while.
Determine, perceive, and glimpse Yellow Medicine houses for rent, home rentals in Yellow Medicine, and Yellow Medicine Minnesota apartment rentals.
|
|
