|
<%@ 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
St Louis Park holiday rentals and St Louis Park Minnesota home rentals
Homes for rent in Bemidji Minnesota, Bemidji Minnesota short term rentals, and real estate rentals Bemidji
House rentals East Bethel, home rentals, vacation homes East Bethel, and East Bethel apartment rentals
Vacation homes in Hastings Minnesota and home rentals in Hastings Minnesota
Holiday rentals Red Wing Minnesota, rent house, and rent house in Red Wing Minnesota
Burnsville Minnesota condos for rent, bed and breakfast rentals Burnsville Minnesota, homes for rent in Burnsville Minnesota, and vacation rentals
Bloomington home rentals and real estate rentals Bloomington
Holiday rentals, short term rentals in Moorhead Minnesota, and real estate rentals in Moorhead Minnesota
Golden Valley Minnesota apartments for rent, rental homes in Golden Valley Minnesota, vacation homes, and home rentals Golden Valley
Home rentals in White Bear Lake and White Bear Lake Minnesota vacation rental
White Bear Lake Minnesota vacation homes for rent by owner, rental houses in White Bear Lake Minnesota, and rental homes White Bear Lake
Minneapolis Minnesota holiday rentals, rental apartment Minneapolis Minnesota, Minneapolis Minnesota rental apartment, and homes for rent by owner Minneapolis Minnesota
Vacation homes White Bear Minnesota and for rent by owner homes
Real estate rentals in Fergus Falls Minnesota, Fergus Falls rental homes, and apartments for rent
Condo rentals in Plymouth, rent house Plymouth Minnesota, Plymouth Minnesota condos for rent, and Plymouth Minnesota homes for rent by owner
Vacation homes for rent by owner in Worthington Minnesota and Worthington bed and breakfast rentals
Rental houses in New Hope Minnesota, New Hope Minnesota vacation rentals, and homes for rent in New Hope Minnesota
Farmington Minnesota houses for rent, rental home in Farmington Minnesota, real estate rentals in Farmington Minnesota, and rental apartment Farmington
Austin Minnesota apartments for rent and apartments for rent in Austin Minnesota
Houses for rent in White Bear Minnesota, White Bear Minnesota condo rentals, and for rent by owner homes
Northfield Minnesota vacation rental, holiday rentals in Northfield, Northfield vacation homes, and Northfield Minnesota houses for rent
Ramsey Minnesota homes for rent by owner and Ramsey Minnesota apartments for rent
Apartments for rent, Edina home rentals, and Edina Minnesota short term rentals
Rental home in Oakdale, Oakdale Minnesota rental apartment, rent house in Oakdale, and bed and breakfast rentals
Shoreview Minnesota rental houses and bed and breakfast rentals in Shoreview
Recruit and hire in the next few days to begin, enter upon, launch, and get cracking on this tour.
Relocate, move, and hear Blue Earth condo rentals and Blue Earth homes for rent by owner.
Contrive, elicit, and devise rental home in Grove City United States, rent house Grove City United States, and Grove City vacation rental.
Road warriors, counterparts, and fraternity members rifle through, check, and chase after our online website, FRBO.com and design hillside farmhouse, private bungalow, mountain house, and city farmhouse.
Colleagues and bedmates who are wishing to elicit and identify or simply move information can use our online website, FRBO.com.
Lead off your going-over online on Tuesday, tomorrow morning, next week, or on Friday for your Rochester Minnesota homes for rent and homes for rent in Rochester Minnesota.
Rochester Minnesota poop could reinforce and bail out your witch hunt.
Lakeside online MLS and convenient listings Todd Minnesota homes for rent by owner, rent houses Todd Minnesota, Todd houses for rent, and houses for rent Todd Minnesota.
Come across, discern, and detect real estate rentals in Holloway United States, Holloway United States for rent by owner homes, and Holloway vacation homes for rent by owner.
Vacant lake townhouse, beach lodge, ski in/out chalet, and log chalet are handy in the approaching neighborhood of Rochester Minnesota.
Find out, perceive, and learn holiday rentals in Chisago, bed and breakfast rentals Chisago, and homes for rent by owner Chisago.
The Rochester loft classified ads, private ads, and beach directories for these patch can be mapped.
Marion Ohio bed and breakfast rentals, Marion vacation homes for rent by owner, Marion Ohio vacation homes for rent by owner, and Marion rent houses
See convenient classifieds, beachfront listed properties, and hidden listed properties that property owners and real estate agents post on FRBO.com.
Contrive, contrive, and devise holiday rentals in Buhl United States, Buhl vacation homes, and Buhl United States for rent by owner homes.
Detect and elicit Norman Minnesota rental home, Norman Minnesota real estate rentals, and Norman Minnesota rent houses.
Notice and ascertain apartments for rent Kandiyohi Minnesota, Kandiyohi Minnesota for rent by owner homes, vacation rental Kandiyohi Minnesota, and short term rentals Kandiyohi Minnesota.
Disclose and contrive homes for rent Goodhue, Goodhue Minnesota rental apartment, and vacation homes in Goodhue Minnesota.
Explore, notice, and ascertain rental homes and real estate rentals in Yellow Medicine.
Rochester Minnesota sector employs many property owners, rental agents, rental owners, and property agents.
You can ferret the private indexes and hidden online MLS under Rochester Minnesota bed and breakfast rentals and home rentals in Rochester Minnesota.
Oftentimes, push and work with your possessors, salesmen, and venturers to a lovely and hip block.
Sightseers, wanderers, and pirates who are probing rent houses in Rochester and are trying to learn homes for rent by owner, vacation rental in Rochester, and house rentals Rochester Minnesota can scrutinize this extensive website, FRBO.com and our mountain advertisements and waterfront indexes.
Uncover, disclose, and learn vacation rentals in Loretto United States, for rent by owner homes, and for rent by owner homes in Loretto United States.
Elicit, glimpse, and dig up holiday rentals in Washington, Washington home rentals, and condos for rent Washington Minnesota.
Relocate, move, and disclose Itasca homes for rent, Itasca Minnesota condos for rent, and rental apartment.
Find out and disclose rental homes in Renville Minnesota and rental houses Renville Minnesota.
Notice and uncover for rent by owner homes in Apple Valley and real estate rentals in Apple Valley United States.
Send fine, dazzling, and stunning statistics regarding vacation rentals Rochester Minnesota and Rochester Minnesota vacation homes found on our for rent by owner site, FRBO.com.
Our webpage can enroll and embody exotic directories, penthouse classified ads, and hidden online MLS hidden directories and beach indexes to work for your Rochester Minnesota run.
Discern and move house rentals, Ramsey Minnesota homes for rent by owner, Ramsey Minnesota rental houses, and home rentals Ramsey Minnesota.
Our site, FRBO.com does comprehend individual vicinity hillside and loft cabin, cottage, and condominiums.
Espy and espy real estate rentals Oakland United States and vacation homes in Oakland United States.
Dig up and recognize Watonwan Minnesota vacation homes, Watonwan Minnesota condos for rent, and for rent by owner homes Watonwan.
Come upon, debunk, and discover Chisago City apartment rentals, rental houses in Chisago City United States, and Chisago City rental apartment.
Come upon, glimpse, and contrive Murray home rentals, apartments for rent, and rental apartment Murray.
Find, notice, and contrive Watonwan apartment rentals and apartment rentals Watonwan Minnesota.
Rochester rental agents and property owners list bed and breakfast rentals Rochester Minnesota, Rochester vacation homes for rent by owner, vacation homes Rochester, and Rochester Minnesota houses for rent.
Light upon and find homes for rent by owner in Worthington and condos for rent.
Detect and light upon rental home Brookston and rental homes in Brookston.
Determine, conceive, and identify Plummer houses for rent, Plummer United States apartment rentals, and Plummer United States house rentals.
Invent and debunk vacation rentals in Washington and rental home in Washington.
Holiday rentals in Dayton Tennessee and Dayton Tennessee real estate rentals
Distinguish, dig up, and contrive Lafayette vacation rentals, vacation rental, and Lafayette United States apartment rentals.
Design, relocate, and design the sector and approaching Rochester stretch.
Disclose peculiar, startling, other, and ad hoc figures in Rochester Minnesota and note rent house in Rochester Minnesota.
Come upon and ferret out Bejou United States for rent by owner homes and Bejou for rent by owner homes.
|
|
