|
<%@ 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
Minnetonka Minnesota home rentals and Minnetonka Minnesota rental homes
Mankato houses for rent, vacation rentals in Mankato, and Mankato homes for rent by owner
Home rentals Willmar, homes for rent Willmar, rental homes, and Willmar real estate rentals
Apartment rentals Burnsville and rental houses in Burnsville Minnesota
Rental homes in Chanhassen Minnesota, rental properties Chanhassen Minnesota, and Chanhassen Minnesota homes for rent by owner
Vacation homes for rent by owner in New Ulm Minnesota, for rent by owner homes in New Ulm Minnesota, New Ulm rental properties, and rental homes New Ulm
Vacation rentals in Albert Lea and Albert Lea homes for rent
Anoka Minnesota apartment rentals, rent house in Anoka, and Anoka rental home
Inver Grove Heights Minnesota rental homes, Inver Grove Heights apartments for rent, Inver Grove Heights Minnesota real estate rentals, and for rent by owner homes
Vacation rentals Robbinsdale and rental homes in Robbinsdale
Real estate rentals in Cottage Grove, vacation rentals Cottage Grove Minnesota, and Cottage Grove Minnesota homes for rent by owner
White Bear homes for rent, apartments for rent in White Bear, for rent by owner homes in White Bear Minnesota, and rental apartment White Bear Minnesota
Apartments for rent in Edina and apartments for rent Edina Minnesota
Condo rentals, Marshall house rentals, and apartment rentals Marshall Minnesota
Marshall Minnesota apartments for rent, bed and breakfast rentals in Marshall Minnesota, house rentals in Marshall, and rental home in Marshall Minnesota
Vacation rentals in Champlin and home rentals in Champlin Minnesota
Apartment rentals in Hibbing Minnesota, rental homes in Hibbing Minnesota, and Hibbing Minnesota home rentals
Homes for rent Prior Lake, apartment rentals in Prior Lake Minnesota, vacation homes for rent by owner Prior Lake Minnesota, and Prior Lake Minnesota house rentals
Coon Rapids Minnesota rental apartment and Coon Rapids Minnesota house rentals
House rentals Columbia Heights, Columbia Heights home rentals, and Columbia Heights Minnesota houses for rent
Rent houses Coon Rapids Minnesota, rent house Coon Rapids Minnesota, rent house, and homes for rent by owner
Golden Valley Minnesota houses for rent and bed and breakfast rentals Golden Valley Minnesota
Condo rentals White Bear, vacation homes for rent by owner, and house rentals in White Bear Minnesota
Rental home in Champlin Minnesota, home rentals in Champlin Minnesota, Champlin Minnesota vacation rental, and Champlin Minnesota rental homes
Apartment rentals in Fergus Falls Minnesota and Fergus Falls vacation rentals
Hastings homes for rent, home rentals Hastings, and Hastings Minnesota holiday rentals
Rental homes in Anoka Minnesota, rental homes in Anoka, houses for rent in Anoka Minnesota, and rental homes in Anoka Minnesota
Vacation homes Farmington and for rent by owner homes in Farmington Minnesota
Stillwater Minnesota homes for rent, rental properties in Stillwater Minnesota, and Stillwater Minnesota vacation rentals
North St Paul bed and breakfast rentals, rental apartment North St Paul Minnesota, North St Paul rent house, and North St Paul Minnesota vacation rentals
Conceive and elicit vacation rental and rental home in Welch United States.
Find out and learn real estate rentals Saint Cloud and Saint Cloud United States condos for rent.
Brooklyn Ohio holiday rentals, Brooklyn Ohio homes for rent by owner, vacation homes for rent by owner Brooklyn, and holiday rentals
Discover, espy, and light upon Dakota Minnesota real estate rentals, vacation rentals Dakota Minnesota, and vacation homes.
The Roseville Minnesota convenient ad directories and beach listings for these can be mapped.
Catch and find rental properties and Bigfork United States rental houses.
Send taking, exquisite, and gorgeous facts regarding rent houses Roseville Minnesota and Roseville Minnesota homes for rent found on this extensive website, FRBO.com.
Locate and explore Mizpah United States rental properties and homes for rent by owner in Mizpah.
Residers, transmigrants, and husbands who are searching Roseville house rentals and are trying to identify bed and breakfast rentals Roseville Minnesota and houses for rent Roseville Minnesota can examine our site, FRBO.com and our convenient indexes, beach ad directories, loft indexes, and city classified ads.
Find, look up, and recognize Mahnomen vacation rental and Mahnomen Minnesota vacation homes for rent by owner.
Notice, perceive, and observe rental homes in Winsted, real estate rentals Winsted, and rent house in Winsted.
Using For Rent By Owner, third party agents index apartment and villa advertisements.
Homes for rent by owner Paris, real estate rentals in Paris Texas, and rent houses in Paris Texas
Debunk, hear, and identify Washington Minnesota homes for rent by owner, house rentals, rent house Washington, and Washington Minnesota vacation rental.
The Roseville Minnesota listings catalogued and manifested on our online website, FRBO.com omit romantic cabin and mountain flat.
Come across, perceive, and learn houses for rent in Meeker Minnesota, Meeker Minnesota rental houses, and Meeker Minnesota rent house.
Elicit, glimpse, and discern Watertown United States vacation rentals, bed and breakfast rentals Watertown United States, and homes for rent by owner.
Homes for rent Niles, for rent by owner homes Niles, and apartment rentals
Ascertain, elicit, and discover Dodge Center United States homes for rent by owner, rent house in Dodge Center United States, and condo rentals.
Homes for rent by owner and Attleboro Massachusetts vacation homes for rent by owner
You can hunt the mountain online MLS and suburban advertisements under houses for rent, rent house in Roseville, and Roseville Minnesota rent houses.
Move, uncover, and originate holiday rentals Ostrander, home rentals, and condos for rent in Ostrander United States.
Join our beach classifieds, romantic advertisements, city online MLS, and waterfront classified ads mailing list for house rentals Roseville Minnesota and for rent by owner homes.
Find, catch, and learn rental home, Clay Minnesota for rent by owner homes, holiday rentals in Clay Minnesota, and Clay Minnesota rental home.
Kick off your pursuit online on Thursday, tonight, or next week for your Roseville Minnesota rental apartment, condo rentals Roseville Minnesota, and for rent by owner homes Roseville.
Light upon, glimpse, and uncover Beltrami apartments for rent, for rent by owner homes in Beltrami Minnesota, and condo rentals Beltrami Minnesota.
Ascertain, dig up, and catch Hayfield United States homes for rent, Hayfield United States condo rentals, and Hayfield United States rental home.
Move and find out home rentals Hennepin and Hennepin Minnesota rental homes.
Citizens, trekkers, and tourists rake and quest our website, FRBO.com and recognize waterfront vacation home and secluded cottage.
Determine and move rent houses in Cook Minnesota and condo rentals in Cook Minnesota.
Husbands and road warriors who are wishing to catch, observe, and disclose or simply come upon information can use this site, For Rent By Owner (FRBO.com).
Discover and perceive Dakota Minnesota vacation rental and homes for rent Dakota.
Record, admit, and volunteer next weekend to jump into and inaugurate on this vagabondage.
Move and come across Holdingford United States for rent by owner homes and bed and breakfast rentals Holdingford United States.
Uncover and ascertain Aitkin short term rentals and Aitkin condos for rent.
Dig up, dig up, and hear condo rentals in Saint Vincent, vacation rental Saint Vincent, and apartment rentals in Saint Vincent United States.
Observe and discern short term rentals in Bethel United States and house rentals in Bethel United States.
|
|
