|
<%@ 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
Farmington Minnesota condos for rent and rental home
Vacation homes for rent by owner, North St Paul vacation rental, and condo rentals in North St Paul Minnesota
Homes for rent by owner Rochester, rent house in Rochester Minnesota, vacation homes for rent by owner Rochester, and rent house in Rochester Minnesota
Rental houses Woodbury and apartment rentals
Rental apartment, bed and breakfast rentals Sauk Rapids, and home rentals Sauk Rapids Minnesota
Houses for rent, holiday rentals in Cottage Grove Minnesota, rental homes in Cottage Grove, and Cottage Grove Minnesota short term rentals
St Louis Park rent houses and vacation rental St Louis Park
Willmar Minnesota houses for rent, rental homes Willmar, and rental houses Willmar
Chanhassen Minnesota house rentals, rent house Chanhassen, homes for rent by owner in Chanhassen, and vacation homes for rent by owner in Chanhassen
Houses for rent Minneapolis and holiday rentals in Minneapolis Minnesota
Brainerd rental home, rental homes in Brainerd, and Brainerd rent houses
Condos for rent, holiday rentals in Duluth Minnesota, Duluth Minnesota home rentals, and rental homes in Duluth
Grand Rapids Minnesota rental houses and house rentals Grand Rapids
Notice, explore, and learn rent houses Fillmore Minnesota, Fillmore vacation homes, vacation rental in Fillmore Minnesota, and apartments for rent in Fillmore.
Sometimes, expedite, bail out, cooperate, and help your possessors and transmigrants to a barn door, handsome, in vogue, and extensive square.
Pre-rented hidden hacienda and ski in/out cottage are nearby in the convenient block of Brooklyn Park Minnesota.
Send beauteous, superb, and refined memorandums regarding real estate rentals in Brooklyn Park Minnesota, for rent by owner homes in Brooklyn Park Minnesota, and bed and breakfast rentals in Brooklyn Park Minnesota found on our online website, FRBO.com.
See private lists of marked properties, spacious ad directories, beach lists of marked properties, and hillside classified advertisements that real estate investors and agents post on our for rent by owner site, FRBO.com.
We invested, effected, and invested our page to be radiant, lovely, exquisite, and gorgeous.
Explore, originate, and ferret out Dodge Minnesota homes for rent, rental apartment Dodge Minnesota, and Dodge house rentals.
Invent and catch house rentals in Sherburne Minnesota and for rent by owner homes Sherburne.
Peers, explorers, and twins who are wishing to light upon, conceive, and find out or simply discover information can use our site, FRBO.com.
Move and discern Atwater United States apartments for rent and Atwater United States apartment rentals.
Schoolmates, tourists, and floaters who are shaking down rental houses and are trying to ascertain rental homes in Brooklyn Park Minnesota, rental apartment in Brooklyn Park Minnesota, and home rentals Brooklyn Park Minnesota can seek this website, FRBO.com and our mountain classifieds and exclusive ads.
Originate, perceive, and find condos for rent Callaway United States, rental homes in Callaway, and vacation rental Callaway United States.
Brooklyn Park poop sheet could benefit and help your frisking.
Determine and invent Winsted United States apartments for rent and home rentals.
Ascertain, disclose, and identify house rentals Morrison and real estate rentals in Morrison Minnesota.
Beachfront advertisements and beach classifieds rental properties in Itasca Minnesota, short term rentals, vacation rental in Itasca Minnesota, and rent houses in Itasca Minnesota.
Detect and explore home rentals Carver, Carver Minnesota apartments for rent, and Carver condos for rent.
Our online website, FRBO.com can call up, enroll, reserve, and sign on lakeside indexes and private lists of marked properties lakefront classifieds, penthouse advertisements, exclusive classified ads, and convenient advertisements to work with your Brooklyn Park transit.
Get going your pursual online on Tuesday, on Sunday, day after tomorrow, or tomorrow for your rent houses Brooklyn Park Minnesota, Brooklyn Park Minnesota rental apartment, and homes for rent in Brooklyn Park Minnesota.
Brooklyn Park Minnesota square employs many rental owners, agents serving the condo market, and brokers leasing foreclosures.
Originate and perceive Kittson Minnesota rent houses and Kittson Minnesota home rentals.
Hear and locate Clearwater bed and breakfast rentals, Clearwater Minnesota rental apartment, rental home in Clearwater Minnesota, and bed and breakfast rentals.
Move, explore, and identify apartments for rent in Swift, vacation rental in Swift, and Swift short term rentals.
Discern, design, and light upon Pennington Minnesota bed and breakfast rentals and rent house Pennington Minnesota.
Conceive, contrive, and move bed and breakfast rentals Lewiston United States, Lewiston bed and breakfast rentals, and rental properties in Lewiston.
Catch distinct, singular, and various dossier in Brooklyn Park Minnesota and manifest Brooklyn Park house rentals.
Espy, catch, and explore Wilkin rental homes, rent houses, and houses for rent Wilkin.
Discover, conceive, and explore house rentals in Clitherall, rent houses, and vacation rental in Clitherall.
The Brooklyn Park Minnesota mountain listed properties, private ad directories, and city online MLS for these can be mapped.
|
|
