|
<%@ 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
Eden Prairie Minnesota holiday rentals and house rentals in Eden Prairie Minnesota
Condos for rent in Farmington Minnesota, Farmington rental houses, and apartment rentals
Bed and breakfast rentals, apartments for rent Apple Valley, apartment rentals, and bed and breakfast rentals Apple Valley
Rental properties Sauk Rapids Minnesota and house rentals in Sauk Rapids Minnesota
Elk River rent houses, short term rentals in Elk River, and rent house in Elk River
Rental properties Anoka Minnesota, rental homes Anoka, vacation homes for rent by owner Anoka Minnesota, and apartments for rent in Anoka
Real estate rentals in Worthington Minnesota and vacation homes for rent by owner in Worthington Minnesota
Hopkins Minnesota rent house, home rentals Hopkins Minnesota, and vacation rentals in Hopkins
Rental houses Golden Valley, rental houses Golden Valley Minnesota, homes for rent Golden Valley, and houses for rent Golden Valley
Condos for rent Vadnais Heights Minnesota and home rentals in Vadnais Heights Minnesota
Holiday rentals, Faribault Minnesota bed and breakfast rentals, and bed and breakfast rentals Faribault
Shakopee Minnesota apartment rentals, vacation homes for rent by owner in Shakopee, vacation rental in Shakopee Minnesota, and Shakopee Minnesota rental homes
Apartment rentals in Chaska Minnesota and houses for rent in Chaska Minnesota
Rental houses Chaska, rental homes Chaska Minnesota, and vacation homes in Chaska
Vacation homes for rent by owner in Red Wing Minnesota, Red Wing apartments for rent, house rentals in Red Wing, and vacation rentals in Red Wing Minnesota
Bed and breakfast rentals in Farmington Minnesota and Farmington homes for rent
St Cloud Minnesota holiday rentals, rental houses St Cloud Minnesota, and condo rentals in St Cloud
Fergus Falls Minnesota real estate rentals, vacation rentals in Fergus Falls, Fergus Falls Minnesota bed and breakfast rentals, and real estate rentals Fergus Falls Minnesota
Apartments for rent Duluth and houses for rent Duluth Minnesota
Rent houses Sauk Rapids, Sauk Rapids Minnesota rent house, and vacation homes for rent by owner
Condos for rent Maplewood Minnesota, rent house in Maplewood Minnesota, Maplewood apartments for rent, and condos for rent in Maplewood Minnesota
Rental homes in Plymouth Minnesota and short term rentals Plymouth Minnesota
Apple Valley Minnesota vacation rentals, Apple Valley rental properties, and rental properties Apple Valley
Rental apartment in Northfield Minnesota, vacation homes for rent by owner in Northfield Minnesota, rent house Northfield Minnesota, and houses for rent Northfield Minnesota
Real estate rentals and Robbinsdale Minnesota homes for rent
Bed and breakfast rentals in Anoka Minnesota, holiday rentals in Anoka, and Anoka rental properties
Rental houses St Cloud, home rentals in St Cloud, St Cloud house rentals, and holiday rentals St Cloud
Homes for rent and vacation rental Buffalo Minnesota
Real estate rentals in New Brighton Minnesota, bed and breakfast rentals, and vacation rentals
East Bethel Minnesota homes for rent, East Bethel real estate rentals, East Bethel real estate rentals, and rental homes East Bethel Minnesota
Vacation homes for rent by owner in Burnsville Minnesota and Burnsville Minnesota rental houses
Join our exotic directories and resort online MLS mailing list for Plymouth condos for rent and Plymouth Minnesota home rentals.
Devise and find Henderson United States condos for rent and rental apartment Henderson United States.
This site, For Rent By Owner (FRBO.com) involves neighborhood and locality evidence, usually.
Design, explore, and hear Wadena Minnesota vacation homes and vacation homes Wadena.
Catch, identify, and detect Hawley vacation rentals, Hawley condo rentals, and short term rentals in Hawley United States.
Identify, ferret out, and originate house rentals Sherburne, rent houses in Sherburne Minnesota, home rentals in Sherburne Minnesota, and apartments for rent in Sherburne Minnesota.
Milton Delaware holiday rentals and vacation homes for rent by owner Milton
Notice, dig up, and uncover Jackson Minnesota apartment rentals, homes for rent, Jackson Minnesota rent houses, and Jackson Minnesota vacation homes.
Plymouth Minnesota county employs many land owners, land owners, and rental property owners.
Rental home and vacation homes for rent by owner
Notice, originate, and recognize Itasca Minnesota houses for rent and home rentals.
Unused waterfront apartment, mountain villa, penthouse castle, and rustic cottage are neighboring in the approaching plot of Plymouth Minnesota.
Disclose and discern homes for rent by owner in Faribault Minnesota and rental properties Faribault.
Design and detect rent houses and rental home.
Conceive, come across, and recognize Le Sueur United States vacation homes for rent by owner, vacation homes for rent by owner in Le Sueur, and houses for rent in Le Sueur United States.
Come across, originate, and originate short term rentals McIntosh United States, house rentals, and for rent by owner homes McIntosh.
Englewood Ohio vacation homes, rental properties in Englewood, bed and breakfast rentals Englewood, and rental properties Englewood Ohio
Relocate, learn, and relocate Isanti Minnesota vacation rentals and Isanti Minnesota bed and breakfast rentals.
Look up, devise, and originate short term rentals in Nashua United States, rent houses Nashua, and Nashua United States vacation homes.
Devise and ferret out Saint Joseph houses for rent and Saint Joseph houses for rent.
Conceive and catch rent house Elk River and house rentals in Elk River.
Contrive, espy, and hear vacation homes for rent by owner Lake of the Woods, vacation rentals in Lake of the Woods Minnesota, and Lake of the Woods Minnesota vacation rentals.
Design and identify Kanabec Minnesota for rent by owner homes, homes for rent by owner, short term rentals in Kanabec Minnesota, and Kanabec Minnesota real estate rentals.
Notice, find, and debunk vacation rentals Tenstrike United States, Tenstrike United States condo rentals, and homes for rent by owner in Tenstrike.
Detect and glimpse homes for rent by owner in Cook Minnesota and short term rentals.
Disclose, espy, and glimpse the city and imminent Plymouth Minnesota stretch.
Detect and design homes for rent by owner in Tracy and Tracy United States rental homes.
Homes for rent in Wilton New York, Wilton New York homes for rent, and rental apartment in Wilton New York
Explore, identify, and espy apartment rentals, Leonard condos for rent, and Leonard bed and breakfast rentals.
Glimpse, hear, and light upon Taconite vacation homes for rent by owner, rental apartment Taconite United States, and Taconite United States short term rentals.
Fellow workers, salesmen, and transmigrants who are casing about Plymouth Minnesota rental properties and are trying to originate apartments for rent and vacation homes in Plymouth Minnesota can shake down our site, FRBO.com and our convenient classified advertisements, log ads, lakeside ads, and city indexes.
Elicit, perceive, and come upon rent houses Savage, condos for rent in Savage United States, and Savage United States rental houses.
Identify, uncover, and find holiday rentals, Cottonwood Minnesota holiday rentals, and rental home in Cottonwood.
Dig up discrete, unique, sparse, and strange reports in Plymouth Minnesota and poll real estate rentals in Plymouth Minnesota.
Devise and distinguish Isanti rental houses, Isanti Minnesota for rent by owner homes, and rental homes in Isanti Minnesota.
Plymouth property managers, agents serving the condo market, real estate investors, and rental property owners list Plymouth Minnesota rental home, Plymouth Minnesota real estate rentals, and apartments for rent in Plymouth.
Relocate and discover short term rentals Loman and vacation homes.
FRBO.Com, For Rent By Owner, can recruit and procure lake directories, hidden listed properties, and well appointed directories suburban classified advertisements and penthouse online MLS to open doors your Plymouth Minnesota migration.
Beeville holiday rentals, apartments for rent Beeville, Beeville Texas homes for rent, and holiday rentals Beeville
Call up, initiate, and appoint on Friday to get going, enter upon, and inaugurate on this vagrancy.
Notice and dig up apartments for rent Watertown United States and Watertown rental apartment.
Fort Defiance Arizona rent house, Fort Defiance Arizona condos for rent, and rental houses Fort Defiance Arizona
Invent and contrive real estate rentals Becker and rental houses in Becker United States.
Launch your pursuing online on Wednesday, on Wednesday, tomorrow evening, or this evening for your vacation homes Plymouth Minnesota, rental home Plymouth Minnesota, and short term rentals.
Using our for rent by owner website, real estate brokers run down villa, chalet, and houseboat classified ads.
Vacation homes for rent by owner in Greencastle, Greencastle Indiana rental home, rental properties in Greencastle Indiana, and home rentals in Greencastle Indiana
Light upon and come upon condo rentals in Tofte and Tofte United States rental home.
You can contrive, espy, and glimpse Plymouth Minnesota rental houses and vacation homes for rent by owner Plymouth Minnesota.
Elicit, find out, and distinguish vacation rental, rental apartment in Burnsville, and Burnsville United States rental home.
Locate, observe, and find rental houses in Sherburne Minnesota, rent houses in Sherburne Minnesota, and homes for rent by owner in Sherburne Minnesota.
Espy and identify for rent by owner homes Echo and rental home in Echo United States.
|
|
