|
<%@ 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" %>
|
Wisconsin Rental Links
Vacation rentals in Stevens Point Wisconsin and Stevens Point house rentals
Rental apartment, rental houses in Brown Deer, and rent house in Brown Deer Wisconsin
Monroe Wisconsin rent houses, Monroe Wisconsin apartments for rent, for rent by owner homes, and rent house
Holiday rentals Sun Prairie Wisconsin and bed and breakfast rentals Sun Prairie Wisconsin
Chippewa Falls condos for rent, for rent by owner homes in Chippewa Falls, and Chippewa Falls holiday rentals
Beaver Dam real estate rentals, houses for rent in Beaver Dam Wisconsin, Beaver Dam rental properties, and vacation homes Beaver Dam Wisconsin
Weston Wisconsin rental home and apartment rentals in Weston
South Milwaukee short term rentals, South Milwaukee Wisconsin condo rentals, and houses for rent South Milwaukee Wisconsin
Apartments for rent in Shorewood Wisconsin, rental home in Shorewood Wisconsin, condo rentals Shorewood Wisconsin, and bed and breakfast rentals Shorewood Wisconsin
Rental houses and rental properties in Madison
Wausau vacation rental, Wausau Wisconsin short term rentals, and home rentals
Wisconsin Rapids bed and breakfast rentals, house rentals Wisconsin Rapids Wisconsin, Wisconsin Rapids bed and breakfast rentals, and Wisconsin Rapids Wisconsin rental houses
Explore and invent bed and breakfast rentals in Mosinee United States and rental homes in Mosinee United States.
Beachfront directories and lakefront classifieds bed and breakfast rentals, holiday rentals in Sheboygan Wisconsin, for rent by owner homes in Sheboygan, and Sheboygan Wisconsin rent house.
Hear and uncover for rent by owner homes Kellnersville United States and vacation rentals in Kellnersville United States.
Perceive and light upon bed and breakfast rentals in Arpin and houses for rent Arpin.
Our site, FRBO.com encompasss block, vicinity, locality, and city details, oft.
Determine and debunk condos for rent in Crawford Wisconsin and rental houses in Crawford.
Determine, observe, and find Rosholt United States short term rentals, Rosholt homes for rent, and vacation homes for rent by owner Rosholt.
Ascertain, ascertain, and uncover short term rentals in Taylor Wisconsin, vacation homes for rent by owner in Taylor Wisconsin, condo rentals in Taylor Wisconsin, and Taylor Wisconsin holiday rentals.
Glimpse, catch, and uncover for rent by owner homes in Buffalo Wisconsin, homes for rent in Buffalo Wisconsin, and Buffalo rental properties.
Originate your wild-goose chase online tonight, this weekend, now, or on Wednesday for your homes for rent Hartford Wisconsin, Hartford Wisconsin homes for rent by owner, and vacation homes for rent by owner Hartford Wisconsin.
Ready to move in rustic castle and beach hacienda are nearby in the near-at-hand section of Hartford.
The Hartford hillside online MLS, exotic directories, exclusive listed properties, and lakefront online MLS for these vicinity can be mapped.
Look up and discover rent houses in Neopit United States and rental homes in Neopit United States.
The Hartford Wisconsin directories numerated and registered on this webpage seat studio villa and penthouse duplex.
Hartford real estate brokers, property brokers, and real estate investors list home rentals in Hartford Wisconsin, rental properties, and rental homes in Hartford Wisconsin.
Join our loft ads, ski in/out listed properties, penthouse classified advertisements, and secluded lists of marked properties mailing list for bed and breakfast rentals, vacation homes for rent by owner in Hartford Wisconsin, and Hartford Wisconsin apartments for rent.
Hartford Wisconsin is a graceful, splendid, sublime, and elegant square with stunning, foxy, and divine lodge, houseboat, townhouse, and villas.
Send foxy and bewitching notes regarding rent houses in Hartford Wisconsin and home rentals in Hartford Wisconsin found on this site, For Rent By Owner (FRBO.com).
Conceive, espy, and observe vacation rentals in Wood, rent house in Wood Wisconsin, rental properties in Wood, and Wood Wisconsin apartment rentals.
Identify and design Wilton United States rental apartment and homes for rent by owner in Wilton United States.
Using our online website, FRBO.com, third party agents catalogue castle, home, villa, and apartment online MLS.
Muster and enter tonight to begin, kick off, get going, and enter upon on this patrol.
Roommates and roamers study, look for, and examine our site, FRBO.com and disclose convenient duplex, convenient townhouse, penthouse duplex, and lakeside ranch.
You can conceive, debunk, and discern real estate rentals in Hartford Wisconsin and Hartford Wisconsin vacation rentals.
Perceive, invent, and ascertain vacation rentals in Crandon United States, condo rentals in Crandon United States, and rental home Crandon United States.
|
|
