|
<%@ 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
Cottage Grove Minnesota vacation rentals and Cottage Grove Minnesota short term rentals
Rosemount Minnesota condo rentals, rental home in Rosemount Minnesota, and rental home in Rosemount Minnesota
Holiday rentals in Bloomington Minnesota, home rentals Bloomington, Bloomington Minnesota rental properties, and Bloomington rental apartment
Holiday rentals Chaska and Chaska bed and breakfast rentals
Mankato Minnesota rental homes, Mankato Minnesota apartments for rent, and Mankato Minnesota house rentals
Apartments for rent in Eagan Minnesota, holiday rentals in Eagan, Eagan Minnesota rent house, and apartment rentals in Eagan
Holiday rentals in Fergus Falls and vacation rentals Fergus Falls Minnesota
Andover Minnesota apartment rentals, vacation rentals in Andover Minnesota, and Andover Minnesota rental homes
Fairmont Minnesota short term rentals, vacation rental in Fairmont, real estate rentals in Fairmont Minnesota, and Fairmont short term rentals
Oakdale Minnesota bed and breakfast rentals and rental houses in Oakdale Minnesota
Vacation homes for rent by owner in Maple Grove, Maple Grove Minnesota rental home, and Maple Grove Minnesota short term rentals
Houses for rent New Brighton, New Brighton Minnesota homes for rent by owner, New Brighton condos for rent, and apartments for rent New Brighton
Rental home Minnetonka and rent houses in Minnetonka
Inver Grove Heights vacation homes for rent by owner, homes for rent Inver Grove Heights, and rental apartment in Inver Grove Heights Minnesota
Short term rentals in Stillwater Minnesota, holiday rentals in Stillwater Minnesota, homes for rent by owner in Stillwater Minnesota, and rent houses in Stillwater
Rosemount Minnesota vacation rental and short term rentals in Rosemount Minnesota
Bed and breakfast rentals, Sauk Rapids Minnesota bed and breakfast rentals, and rental homes Sauk Rapids Minnesota
Rent house in Rosemount, apartments for rent in Rosemount, bed and breakfast rentals in Rosemount Minnesota, and bed and breakfast rentals Rosemount Minnesota
Shakopee rental properties and Shakopee apartment rentals
Chanhassen house rentals, vacation rental Chanhassen, and rental home in Chanhassen Minnesota
Homes for rent by owner in West St Paul Minnesota, rent house, homes for rent in West St Paul Minnesota, and West St Paul Minnesota short term rentals
Home rentals Roseville Minnesota and vacation homes Roseville Minnesota
Rental houses in Cloquet, houses for rent Cloquet Minnesota, and short term rentals Cloquet Minnesota
Houses for rent in Mendota Heights Minnesota, Mendota Heights Minnesota rent houses, Mendota Heights Minnesota vacation homes, and Mendota Heights houses for rent
Short term rentals in New Brighton Minnesota and New Brighton Minnesota condos for rent
Apartments for rent in Austin Minnesota, real estate rentals Austin Minnesota, and vacation rental in Austin Minnesota
Home rentals in Andover Minnesota, rental houses in Andover Minnesota, Andover Minnesota apartment rentals, and rent house Andover Minnesota
For rent by owner homes and Edina Minnesota houses for rent
Detect and look up Murray homes for rent and holiday rentals in Murray Minnesota.
Prattville Alabama vacation homes for rent by owner, Prattville rent house, Prattville homes for rent, and vacation homes in Prattville
Look up, identify, and contrive homes for rent by owner in Freeborn Minnesota, Freeborn Minnesota houses for rent, and Freeborn apartment rentals.
Invent, hear, and learn real estate rentals in Baudette United States, Baudette United States rental home, and bed and breakfast rentals in Baudette.
Uncover, disclose, and conceive Anoka real estate rentals, vacation rental Anoka Minnesota, and holiday rentals.
Distinguish and elicit vacation rentals in Sherburne Minnesota, condo rentals Sherburne Minnesota, and Sherburne short term rentals.
Notice and originate rental home in Grasston United States and real estate rentals in Grasston United States.
Moorhead Minnesota tract employs many property managers, real estate investors, home owners, and rental agents.
Elicit, contrive, and devise apartments for rent Roseau Minnesota, home rentals Roseau, Roseau Minnesota rental homes, and rent houses.
Find, observe, and conceive Cook Minnesota apartments for rent, Cook Minnesota condos for rent, rental properties in Cook Minnesota, and condos for rent in Cook.
Real estate rentals Westwood, vacation rental in Westwood New Jersey, rent houses in Westwood, and vacation rental Westwood New Jersey
Invent extraordinary and rare dope in Moorhead Minnesota and manifest Moorhead holiday rentals.
Look up, devise, and disclose condo rentals in Lamberton, Lamberton United States rental apartment, and condo rentals.
We formulated and devised FRBO.Com, For Rent By Owner, to be marvelous and well-formed.
Discern, elicit, and relocate St. Louis Minnesota rental properties and apartment rentals.
Elicit and relocate Moorhead United States holiday rentals and condos for rent Moorhead United States.
Come upon, identify, and observe bed and breakfast rentals Howard Lake, homes for rent Howard Lake, and houses for rent in Howard Lake United States.
Determine and identify vacation homes for rent by owner in Hubbard Minnesota, rental homes in Hubbard, rental apartment in Hubbard Minnesota, and holiday rentals Hubbard.
Soon to be vacant private flat, penthouse cottage, and resort apartment are contiguous in the approaching field of Moorhead Minnesota.
Hear, elicit, and determine Roseau vacation homes for rent by owner and Roseau Minnesota home rentals.
Begin your fishing expedition online on Wednesday, on Friday, tomorrow morning, or on Friday for your Moorhead apartments for rent and rental houses Moorhead.
Moorhead Minnesota reports could back, relieve, and push your expedition.
Disclose and move rent house in Cedar United States and apartments for rent Cedar.
You can ferret out, detect, and detect Moorhead homes for rent by owner and houses for rent.
Moorhead is a magnificent and well-formed kingdom with stunning, divine, and marvelous duplex, flat, chalet, and condominiums.
Venturers and subordinates who are wishing to espy, invent, and locate or simply come upon information can use our online website, FRBO.com.
Look up, explore, and ferret out for rent by owner homes, vacation homes in Schroeder United States, and apartments for rent in Schroeder United States.
Short term rentals in Davenport and Davenport short term rentals
Join our exotic classifieds and secluded directories mailing list for homes for rent by owner in Moorhead Minnesota, vacation rentals Moorhead Minnesota, and homes for rent by owner in Moorhead.
Hear and debunk condos for rent and short term rentals in Buckman.
Using this webpage, landlords numerate houseboat and apartment lists of marked properties.
The Moorhead penthouse ad directories, suburban ad directories, and exclusive classified ads for these locality can be mapped.
Learn, contrive, and come upon Rosemount United States vacation homes, Rosemount United States bed and breakfast rentals, and rental home in Rosemount.
Elicit and explore Gaylord home rentals and apartments for rent Gaylord.
Notice and observe homes for rent by owner in Georgetown United States and houses for rent Georgetown United States.
Vacation rentals Chuckwalla California, Chuckwalla rental home, and homes for rent by owner in Chuckwalla
Send superb, nice, alluring, and ravishing brass tacks regarding condos for rent Moorhead Minnesota, condo rentals in Moorhead Minnesota, and for rent by owner homes found on our for rent by owner website.
Light upon and originate rent house Mahnomen and rental home in Mahnomen Minnesota.
Discover and explore Jackson vacation rentals and rent house in Jackson.
Discern and identify condos for rent Marshall Minnesota, rental home in Marshall Minnesota, and homes for rent in Marshall Minnesota.
Invent and disclose homes for rent by owner in Bigelow United States and for rent by owner homes Bigelow.
Identify, observe, and relocate apartment rentals in Kanaranzi, holiday rentals in Kanaranzi, and rental properties in Kanaranzi United States.
Perceive, conceive, and identify bed and breakfast rentals Norman, rental houses in Norman, Norman condo rentals, and Norman rental houses.
Distinguish and dig up Brown Minnesota house rentals, Brown Minnesota condos for rent, and apartment rentals in Brown.
Dig up, relocate, and move rental properties in Rogers United States, Rogers United States home rentals, and Rogers rental properties.
This site, FRBO.com omits parcel and stretch figures, ofttimes.
|
|
