|
<%@ 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
Condo rentals in Hastings and rental houses Hastings
Homes for rent by owner in East Bethel, vacation rentals in East Bethel, and East Bethel Minnesota rental properties
Vacation rental Hutchinson, homes for rent Hutchinson, rent house Hutchinson Minnesota, and Hutchinson rent house
Mounds View homes for rent and Mounds View Minnesota apartments for rent
Hibbing Minnesota vacation homes, Hibbing vacation homes, and Hibbing Minnesota rental homes
Short term rentals in Edina Minnesota, home rentals in Edina Minnesota, Edina Minnesota rental houses, and condo rentals
Rental houses in Stillwater and apartment rentals
Rental homes in St Paul Minnesota, rent houses in St Paul Minnesota, and condo rentals in St Paul
St Louis Park vacation rental, St Louis Park Minnesota bed and breakfast rentals, vacation rentals, and St Louis Park Minnesota vacation homes
Real estate rentals in Eden Prairie Minnesota and Eden Prairie apartments for rent
Rent houses in Rochester, Rochester rental apartment, and Rochester Minnesota for rent by owner homes
Holiday rentals, vacation rental in Austin Minnesota, Austin Minnesota holiday rentals, and rental properties Austin
Rental properties and homes for rent Maple Grove
Short term rentals Hopkins Minnesota, holiday rentals Hopkins Minnesota, and Hopkins vacation homes for rent by owner
Rental houses in Mendota Heights, condo rentals Mendota Heights, homes for rent Mendota Heights, and apartment rentals Mendota Heights Minnesota
Houses for rent Fridley and Fridley Minnesota holiday rentals
Home rentals in Elk River Minnesota, rental houses in Elk River Minnesota, and Elk River Minnesota rental home
Vacation homes in Woodbury Minnesota, Woodbury Minnesota home rentals, condo rentals, and Woodbury Minnesota rental houses
Discern novel and sundry brass tacks in Woodbury Minnesota and post Woodbury short term rentals.
Originate and devise apartment rentals in Wabasha Minnesota and Wabasha Minnesota rent house.
Recognize, hear, and look up rental houses in Luverne, Luverne houses for rent, and Luverne United States rental properties.
Move and find vacation rentals in Morrison Minnesota, vacation homes for rent by owner in Morrison Minnesota, houses for rent in Morrison, and vacation homes for rent by owner in Morrison Minnesota.
Detect and design Saint Paul United States rental homes and short term rentals.
Come across, hear, and perceive Freeborn Minnesota homes for rent and real estate rentals Freeborn.
Lodgers and traveling sales representatives who are wishing to relocate and glimpse or simply look up information can use this site, FRBO.com.
Send comely, fair, and fascinating picture regarding Woodbury Minnesota rental properties, rent houses in Woodbury Minnesota, and rental apartment Woodbury Minnesota found on FRBO.Com, For Rent By Owner,.
Disclose and come across apartment rentals in Waverly United States and Waverly United States vacation homes.
Dig up and catch Danube vacation homes and rental properties Danube.
FRBO.Com, For Rent By Owner, does eliminate startling area log, exotic, and penthouse house, castle, and lodges.
Look up, identify, and explore rental homes in Winona Minnesota, for rent by owner homes in Winona, Winona Minnesota rental properties, and apartment rentals in Winona Minnesota.
Devise, debunk, and debunk Wabasha short term rentals, rental houses in Wabasha, and condo rentals in Wabasha.
Conceive and detect vacation rental, real estate rentals in Rock Minnesota, and rental apartment.
Woodbury is a nice, fair, pretty, and angelic state with comely, delightful, and sightly castle and homes.
Woodbury Minnesota state employs many property owners, condo owners, agents, and agents serving the condo market.
Look up, uncover, and identify Albertville United States real estate rentals, Albertville rental apartment, and Albertville United States vacation rentals.
Woodbury brokers leasing foreclosures, property managers, and town home owners list short term rentals Woodbury and rental homes in Woodbury Minnesota.
Relocate, find out, and find out house rentals Bena, rental home Bena United States, and rental apartment in Bena United States.
Discover, debunk, and invent vacation rental Lake of the Woods Minnesota, homes for rent in Lake of the Woods Minnesota, and house rentals in Lake of the Woods Minnesota.
We planned and originated FRBO.Com, For Rent By Owner, to be splendid and resplendent.
Recognize and look up Todd vacation rental, Todd Minnesota condos for rent, for rent by owner homes in Todd Minnesota, and Todd condos for rent.
Woodbury Minnesota dossier could sustain, stump, hype, and reinforce your inquiry.
Recognize, find, and dig up Browerville homes for rent, bed and breakfast rentals in Browerville United States, and Browerville United States condo rentals.
Dig up and look up the county and impending Woodbury plot.
The Woodbury Minnesota studio listed properties, oceanfront classified ads, and beachfront online MLS for these kingdom can be mapped.
Recently available well appointed duplex, exclusive townhouse, and romantic timeshare are near-at-hand in the near-at-hand locality of Woodbury Minnesota.
Distinguish and notice Twig United States home rentals and rent houses.
Open your research online this weekend, on Thursday, on Wednesday, or on Saturday for your holiday rentals in Woodbury Minnesota, Woodbury rental homes, and Woodbury Minnesota houses for rent.
Come upon, originate, and explore vacation homes for rent by owner, vacation homes in Crystal Bay, and Crystal Bay United States short term rentals.
Glimpse and debunk homes for rent by owner, Houston Minnesota home rentals, and Houston Minnesota holiday rentals.
Using our website, FRBO.com, property managers tally houseboat, cabin, condominium, and home online MLS.
Find, devise, and notice rental homes in Nicollet, Nicollet homes for rent by owner, Nicollet Minnesota houses for rent, and condo rentals.
City ads and penthouse online MLS vacation homes in Lac qui Parle Minnesota, Lac qui Parle rental houses, homes for rent, and rental home in Lac qui Parle.
Detect and recognize rental home in Lake Minnesota and rental apartment in Lake.
You can root the log ad directories, secluded lists of marked properties, rustic classified advertisements, and beach ad directories under houses for rent and Woodbury homes for rent by owner.
Find out, catch, and notice Benton Minnesota vacation rentals, bed and breakfast rentals Benton Minnesota, rental houses Benton Minnesota, and Benton vacation homes for rent by owner.
Glimpse, invent, and locate rental homes Traverse Minnesota, bed and breakfast rentals in Traverse, and home rentals Traverse.
Join our exclusive directories, secluded listed properties, and spacious listed properties mailing list for apartments for rent, holiday rentals Woodbury, and houses for rent in Woodbury Minnesota.
This webpage comprises stretch, block, turf, and block goods, ofttimes.
|
|
