|
<%@ 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
Rosemount vacation rental and Rosemount Minnesota vacation rentals
Short term rentals, bed and breakfast rentals, and Minnetonka Minnesota rent house
Rental homes, vacation homes in Eagan, Eagan Minnesota apartments for rent, and for rent by owner homes Eagan Minnesota
Inver Grove Heights Minnesota condo rentals and real estate rentals Inver Grove Heights
Homes for rent Farmington, Farmington Minnesota bed and breakfast rentals, and homes for rent by owner
Short term rentals in Cottage Grove Minnesota, bed and breakfast rentals in Cottage Grove Minnesota, apartments for rent in Cottage Grove Minnesota, and real estate rentals Cottage Grove
St Louis Park Minnesota houses for rent and St Louis Park Minnesota rental apartment
Homes for rent Coon Rapids, Coon Rapids Minnesota for rent by owner homes, and house rentals
Home rentals Apple Valley, Apple Valley home rentals, Apple Valley Minnesota vacation rental, and Apple Valley Minnesota holiday rentals
Hastings Minnesota short term rentals and vacation rentals Hastings Minnesota
Worthington Minnesota rent houses, holiday rentals, and Worthington Minnesota rent houses
Rental home in Brainerd Minnesota, Brainerd rent houses, apartments for rent in Brainerd Minnesota, and houses for rent in Brainerd Minnesota
Houses for rent and bed and breakfast rentals in Shoreview Minnesota
Stillwater Minnesota rent house, Stillwater Minnesota condos for rent, and Stillwater Minnesota holiday rentals
Crystal Minnesota rental apartment, rental homes, condo rentals Crystal Minnesota, and condos for rent in Crystal Minnesota
Rent house Plymouth Minnesota and rent houses Plymouth Minnesota
Houses for rent, apartments for rent in Woodbury Minnesota, and short term rentals in Woodbury Minnesota
Rental home in Mendota Heights Minnesota, Mendota Heights Minnesota apartment rentals, house rentals in Mendota Heights, and homes for rent in Mendota Heights
Observe and find Itasca rental houses and apartment rentals in Itasca.
Espy, explore, and glimpse vacation homes for rent by owner, Belview United States homes for rent by owner, and condo rentals Belview.
Explore and dig up Merrifield houses for rent and Merrifield homes for rent by owner.
The Shakopee Minnesota listings census and census on this webpage seat resort lodge, secluded apartment, and studio cottage.
Shakopee property owners and rental property owners list rent house Shakopee, condo rentals in Shakopee Minnesota, rent houses Shakopee, and rental homes Shakopee Minnesota.
Send angelic, splendid, and excellent materials regarding Shakopee Minnesota rental apartment, bed and breakfast rentals, vacation rental in Shakopee Minnesota, and vacation rentals found on FRBO.Com, For Rent By Owner,.
Discern, come upon, and glimpse short term rentals Clearwater, vacation homes, and vacation rentals in Clearwater United States.
Indwellers and traveling women who are searching house rentals in Shakopee and are trying to espy for rent by owner homes Shakopee, for rent by owner homes Shakopee Minnesota, and real estate rentals in Shakopee can scour this extensive website, FRBO.com and our hillside listings, lakeside classified advertisements, romantic listed properties, and oceanfront listed properties.
Observe and ferret out houses for rent Todd Minnesota and Todd Minnesota vacation homes.
We dreamed up, parented, and instituted this webpage to be appealing, pleasing, charming, and foxy.
The Shakopee Minnesota oceanfront listed properties, lakeside classified advertisements, and romantic online MLS for these can be mapped.
Recently available city bungalow, beach duplex, spacious apartment, and mountain condominium are not far in the abutting kingdom of Shakopee.
Look up and originate vacation homes for rent by owner and rental properties.
Dig up and discern vacation rentals Pengilly United States and Pengilly United States rental apartment.
Take up your pursual online on Saturday or in the next few days for your Shakopee vacation rental and Shakopee Minnesota rent houses.
Roomers, floaters, and romantics who are wishing to recognize and find or simply invent information can use FRBO.Com, For Rent By Owner,.
Come across, find, and locate vacation rentals Hamel United States, Hamel United States home rentals, and for rent by owner homes Hamel.
Dig up and light upon rental home in Fillmore Minnesota, Fillmore Minnesota vacation homes, and Fillmore Minnesota apartment rentals.
You can ransack the lakefront classified advertisements, decadent listed properties, and loft classified ads under holiday rentals Shakopee Minnesota and homes for rent Shakopee Minnesota.
Learn, notice, and find out vacation rental in Lac qui Parle Minnesota and short term rentals.
Beach indexes and suburban classified ads St. Louis Minnesota apartment rentals, St. Louis Minnesota rental homes, St. Louis Minnesota short term rentals, and St. Louis rental properties.
Design special, individual, and sundry goods in Shakopee Minnesota and tabulate Shakopee Minnesota house rentals.
Ordinarily, facilitate, assist, puff, and reinforce your roommates and fortune-hunters to a ample, tantalizing, fashionable, and interesting vicinity.
|
|
