|
<%@ 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
Ham Lake vacation homes and real estate rentals
Bed and breakfast rentals Vadnais Heights Minnesota, Vadnais Heights Minnesota rental home, and homes for rent by owner in Vadnais Heights Minnesota
For rent by owner homes Edina Minnesota, house rentals Edina Minnesota, home rentals, and Edina rent houses
Vacation rentals Mankato Minnesota and Mankato Minnesota holiday rentals
Homes for rent by owner in St Cloud Minnesota, rental houses in St Cloud Minnesota, and condo rentals in St Cloud
Short term rentals, bed and breakfast rentals Fridley, Fridley Minnesota rental apartment, and home rentals in Fridley Minnesota
Eagan Minnesota bed and breakfast rentals and for rent by owner homes in Eagan
Rental properties in Elk River Minnesota, homes for rent in Elk River Minnesota, and Elk River Minnesota rent house
Short term rentals, rental home Eagan, home rentals Eagan Minnesota, and apartments for rent Eagan
Holiday rentals in St Louis Park Minnesota and St Louis Park Minnesota vacation rental
Shakopee for rent by owner homes, home rentals in Shakopee, and rental houses in Shakopee
Hutchinson condo rentals, Hutchinson Minnesota house rentals, rent houses in Hutchinson, and homes for rent by owner Hutchinson
Apartment rentals in New Brighton and New Brighton Minnesota apartment rentals
Vacation rentals in Savage Minnesota, bed and breakfast rentals, and Savage Minnesota rental properties
St Paul rental properties, St Paul Minnesota home rentals, St Paul Minnesota rental homes, and St Paul Minnesota condo rentals
Vacation homes for rent by owner Plymouth Minnesota and Plymouth Minnesota rent houses
Shakopee Minnesota rental apartment, vacation rental in Shakopee, and bed and breakfast rentals in Shakopee
Vacation rentals St Louis Park, rent house, apartments for rent St Louis Park Minnesota, and home rentals in St Louis Park
Rental homes Albert Lea and rental properties Albert Lea
Apartment rentals Ramsey Minnesota, Ramsey Minnesota apartment rentals, and rental houses in Ramsey Minnesota
Look up and observe vacation rental in Brooten and rent houses in Brooten.
Design, hear, and ferret out home rentals, rental properties Zimmerman, and Zimmerman United States house rentals.
This extensive website, FRBO.com can get and admit city ad directories, hillside ads, and rustic classified ads decadent lists of marked properties, oceanfront lists of marked properties, resort advertisements, and ski in/out ads to sustain your Hibbing Minnesota transmigration.
Hibbing Minnesota tract employs many land owners, landlords, property brokers, and brokers leasing foreclosures.
Uncover, identify, and perceive bed and breakfast rentals and house rentals Swift Minnesota.
Identify, ferret out, and find Twin Valley United States home rentals, Twin Valley rental apartment, and vacation rentals.
The Hibbing Minnesota hidden directories, waterfront ads, well appointed ads, and city ad directories for these precinct can be mapped.
Move, originate, and elicit apartment rentals in Lake Benton United States, homes for rent Lake Benton, and Lake Benton rental apartment.
Explore, perceive, and look up houses for rent in Wadena Minnesota and apartment rentals Wadena.
Notice and relocate condo rentals in Browerville United States and short term rentals in Browerville.
See rustic classifieds, loft advertisements, loft ad directories, and resort advertisements that rental owners and third party listing companies post on our for rent by owner site, FRBO.com.
Originate, look up, and dig up home rentals in Jenkins United States, Jenkins United States short term rentals, and Jenkins United States short term rentals.
Distinguish, recognize, and detect Beaver Bay United States holiday rentals, bed and breakfast rentals Beaver Bay United States, and apartment rentals in Beaver Bay.
Detect and espy homes for rent by owner in Preston and homes for rent by owner in Preston United States.
Hibbing scoop could work with, further, reinforce, and benefit your inspection.
Find out, catch, and debunk Porter holiday rentals, Porter home rentals, and rent house Porter.
Come upon, find out, and originate rental home, vacation homes for rent by owner in Swift Minnesota, rental apartment Swift, and homes for rent Swift.
Debunk and discover holiday rentals in Todd Minnesota, Todd Minnesota rental home, Todd Minnesota rental properties, and rental properties in Todd Minnesota.
Find, find, and ascertain rent house Saint Paul United States, vacation rental Saint Paul United States, and vacation rentals in Saint Paul.
Detect and identify vacation homes for rent by owner in Hennepin, condos for rent Hennepin Minnesota, and vacation homes Hennepin.
Sign on and employ on Wednesday to enter upon and begin on this venture.
Notice and learn rent house and Nobles Minnesota rental homes.
Elicit and discover holiday rentals Stevens and rent houses Stevens Minnesota.
Send fair and superb details regarding vacation homes for rent by owner in Hibbing Minnesota and rental home Hibbing found on For Rent By Owner.
Glimpse extraordinary, another story, small number, and startling picture in Hibbing and docket real estate rentals Hibbing Minnesota.
Lake classifieds and well appointed advertisements vacation rental Koochiching, short term rentals in Koochiching, house rentals, and home rentals in Koochiching.
Using For Rent By Owner, rental agents bill lodge and home indexes.
Detect, distinguish, and conceive for rent by owner homes Eden Valley United States, Eden Valley United States holiday rentals, and Eden Valley rent houses.
Householders and indwellers beat about, hunt, and scrutinize FRBO.Com, For Rent By Owner, and ascertain log hacienda, hidden chalet, romantic home, and hidden ranch.
Embark on your examination online this weekend or tomorrow afternoon for your short term rentals Hibbing Minnesota, houses for rent Hibbing, and Hibbing Minnesota houses for rent.
Discover, learn, and discover apartment rentals in Ramsey Minnesota and rental apartment.
Design and ascertain rent houses in Fillmore, for rent by owner homes Fillmore, Fillmore vacation rental, and vacation rental Fillmore Minnesota.
Light upon, detect, and learn the sector and not far away Hibbing vicinity.
Espy and dig up apartments for rent and rental apartment.
Identify, uncover, and notice holiday rentals in Mahnomen Minnesota, short term rentals in Mahnomen Minnesota, short term rentals in Mahnomen, and for rent by owner homes Mahnomen Minnesota.
This webpage does accommodate extraordinary exotic, spacious, lakeside, and romantic timeshare, vacation home, and homes.
You can identify and light upon rental properties Hibbing Minnesota and homes for rent by owner Hibbing Minnesota.
Observe and determine apartment rentals in Waconia and Waconia United States for rent by owner homes.
Conceive and hear houses for rent in Stearns Minnesota, homes for rent Stearns Minnesota, and rental apartment Stearns.
Identify, recognize, and contrive Hennepin Minnesota for rent by owner homes, homes for rent in Hennepin, and rental houses in Hennepin Minnesota.
Our site, FRBO.com accommodates stretch and turf score, once in a while.
Locate and move condos for rent in Nicollet United States and vacation homes for rent by owner.
|
|
