|
<%@ 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
Vacation rentals and short term rentals in Duluth
Grand Rapids Minnesota condos for rent, Grand Rapids Minnesota vacation homes, and rental apartment in Grand Rapids Minnesota
Chanhassen homes for rent, apartments for rent in Chanhassen Minnesota, rental apartment in Chanhassen, and home rentals in Chanhassen Minnesota
Minneapolis Minnesota homes for rent by owner and Minneapolis Minnesota houses for rent
Woodbury Minnesota rental home, Woodbury real estate rentals, and houses for rent in Woodbury
Rental apartment Marshall Minnesota, Marshall Minnesota home rentals, vacation homes Marshall Minnesota, and Marshall Minnesota short term rentals
Homes for rent by owner White Bear and real estate rentals in White Bear
Ramsey vacation homes for rent by owner, rental properties in Ramsey, and rental houses Ramsey Minnesota
St Paul apartment rentals, house rentals in St Paul Minnesota, St Paul condo rentals, and St Paul Minnesota for rent by owner homes
Bed and breakfast rentals in Chanhassen Minnesota and Chanhassen Minnesota homes for rent by owner
Rental properties, Blaine Minnesota houses for rent, and Blaine vacation rentals
For rent by owner homes in Brooklyn Park Minnesota, house rentals in Brooklyn Park Minnesota, Brooklyn Park vacation rental, and condos for rent
Eden Prairie Minnesota vacation rentals and homes for rent by owner in Eden Prairie Minnesota
Apartment rentals Plymouth Minnesota, rental properties in Plymouth, and Plymouth Minnesota apartments for rent
Rental houses in Oakdale Minnesota, rental houses Oakdale, Oakdale Minnesota condos for rent, and condo rentals Oakdale
Homes for rent in Maplewood and house rentals in Maplewood
Brainerd Minnesota holiday rentals, condos for rent in Brainerd, and Brainerd Minnesota houses for rent
Bed and breakfast rentals, rental home Duluth Minnesota, apartment rentals in Duluth Minnesota, and Duluth Minnesota vacation homes
Vacation rental Crystal Minnesota and short term rentals in Crystal
Rental houses in White Bear, White Bear Minnesota homes for rent, and apartment rentals in White Bear Minnesota
Robbinsdale apartments for rent, Robbinsdale Minnesota home rentals, homes for rent by owner in Robbinsdale Minnesota, and Robbinsdale Minnesota rental home
Mendota Heights bed and breakfast rentals and houses for rent Mendota Heights Minnesota
Short term rentals, Hutchinson Minnesota real estate rentals, and vacation rental in Hutchinson Minnesota
Vacation homes in Burnsville Minnesota, condo rentals Burnsville Minnesota, Burnsville Minnesota vacation homes for rent by owner, and homes for rent in Burnsville Minnesota
Rent house Roseville and rent houses in Roseville Minnesota
Condo rentals Crystal Minnesota, vacation homes Crystal Minnesota, and Crystal Minnesota real estate rentals
House rentals in Farmington Minnesota, real estate rentals, Farmington Minnesota condo rentals, and vacation rentals Farmington Minnesota
Disclose and espy apartment rentals in Wright Minnesota and holiday rentals in Wright Minnesota.
Determine, recognize, and discover apartments for rent, rent houses, and rental home in Wirt United States.
Almost ready to be occupied oceanfront townhouse, beach bungalow, lake townhouse, and romantic houseboat are convenient in the not remote principality of New Ulm Minnesota.
New Ulm Minnesota is a alluring, nice, ideal, and lovely sector with exquisite, stunning, and delicate vacation home, house, condominium, and chalets.
Look up, originate, and ascertain Palisade home rentals, holiday rentals in Palisade, and Palisade United States short term rentals.
Find out and come across short term rentals Huntley United States and Huntley home rentals.
Dig up, discern, and catch homes for rent Aldrich, houses for rent Aldrich United States, and house rentals in Aldrich.
Our webpage does embrace various principality waterfront, lake, private, and exclusive cottage, duplex, townhouse, and villas.
The New Ulm Minnesota online MLS run down and tallied on this site, FRBO.com comprehend romantic condominium, spacious farmhouse, and romantic townhouse.
Perceive and conceive rental homes, apartment rentals Pipestone, Pipestone Minnesota apartments for rent, and house rentals Pipestone Minnesota.
Join our log listed properties and suburban lists of marked properties mailing list for rental apartment and New Ulm Minnesota holiday rentals.
Find out, locate, and disclose rent houses in Redwood, Redwood Minnesota vacation rentals, and Redwood apartment rentals.
Using this site, For Rent By Owner (FRBO.com), third party listing companies particularize cottage and cabin classifieds.
Identify and glimpse Carlton Minnesota vacation rentals, real estate rentals, and Carlton Minnesota rental apartment.
Espy and light upon vacation homes for rent by owner in Hendrum United States and for rent by owner homes in Hendrum.
Design, relocate, and glimpse homes for rent by owner in Waseca Minnesota, vacation rentals, and homes for rent by owner.
Perceive and espy condo rentals in Grant Minnesota and Grant Minnesota rental home.
Detect and identify rental apartment in Wadena and apartment rentals in Wadena.
Recurrently, run interference and root for your pioneers, excursionists, and teachers to a mesmeric, barn door, and preferred zone.
Come across and ascertain vacation rental in Waseca Minnesota and rental home in Waseca Minnesota.
Come upon and espy Melrose short term rentals and houses for rent.
Send pulchritudinous, well-formed, and marvelous reports regarding bed and breakfast rentals and house rentals in New Ulm Minnesota found on this site, FRBO.com.
Come upon, move, and look up short term rentals in Lismore United States, Lismore United States house rentals, and holiday rentals Lismore United States.
Discover, ascertain, and design for rent by owner homes, Shevlin rent house, and Shevlin United States rental properties.
Conceive, relocate, and notice rental home in Ramsey Minnesota, Ramsey Minnesota vacation homes for rent by owner, and Ramsey Minnesota vacation homes.
We set up and devised our website, FRBO.com to be angelic, classy, ideal, and grand.
Notice and notice rent house in Jasper United States and apartments for rent in Jasper United States.
Discern and find out rental houses Aldrich United States and houses for rent in Aldrich United States.
Devise, perceive, and catch vacation homes for rent by owner, Trail United States vacation homes for rent by owner, and holiday rentals.
|
|
