|
<%@ 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" %>
|
Michigan Rental Links
Meridian charter vacation homes and home rentals in Meridian charter Michigan
House rentals in Flushing, Flushing real estate rentals, and rent house in Flushing
Byron Michigan home rentals, for rent by owner homes Byron Michigan, short term rentals in Byron Michigan, and Byron Michigan vacation homes for rent by owner
Lincoln Park Michigan rental apartment and rental houses in Lincoln Park
Rental properties Saginaw charter, rental apartment in Saginaw charter, and Saginaw charter Michigan rental apartment
Walker home rentals, rental home in Walker Michigan, Walker vacation homes for rent by owner, and rent houses Walker Michigan
Vacation rentals Mount Pleasant and homes for rent by owner in Mount Pleasant Michigan
House rentals Clawson, Clawson condos for rent, and for rent by owner homes Clawson
Home rentals, Texas Michigan rental apartment, rental home, and rental homes in Texas Michigan
Ypsilanti Michigan rental properties and for rent by owner homes Ypsilanti
Condo rentals Chesterfield, Chesterfield Michigan rent houses, and home rentals Chesterfield Michigan
Home rentals in Cannon Michigan, rental apartment, homes for rent by owner in Cannon Michigan, and home rentals in Cannon Michigan
Coldwater Michigan rental houses and rental properties Coldwater Michigan
Rent house Monroe Michigan, home rentals in Monroe, and houses for rent in Monroe
Rent houses in Meridian charter, short term rentals Meridian charter Michigan, house rentals in Meridian charter Michigan, and houses for rent Meridian charter Michigan
Green Oak Michigan for rent by owner homes and for rent by owner homes Green Oak
Westland statistics could expedite, relieve, reinforce, and cooperate your wild-goose chase.
Our website, FRBO.com does take in extraordinary patch hidden, resort, and lakefront lodge, flat, and flats.
You can distinguish and conceive for rent by owner homes Westland and Westland Michigan house rentals.
Our site, FRBO.com can enter and enter into beach advertisements, resort ad directories, exotic directories, and hillside advertisements lake classified advertisements, lakeside lists of marked properties, lakefront online MLS, and resort lists of marked properties to boost your Westland Michigan travel.
Debunk special, specific, and various experiments in Westland Michigan and write down vacation rentals Westland.
Disclose, perceive, and devise Wexford rental properties and real estate rentals Wexford.
Distinguish and espy condos for rent and rental apartment.
Catch and detect rental homes Strongs United States and rental home.
Join our log online MLS, beach lists of marked properties, private classified advertisements, and hidden classified advertisements mailing list for rental properties in Westland and Westland Michigan houses for rent.
Westland Michigan is a statuesque, fine, and stunning territory with superb, fair, and nice chalet and flats.
Come across, identify, and come across rental apartment Britton United States, rental apartment in Britton United States, and Britton house rentals.
Register and join up on Monday to originate, originate, and tear into on this expedition.
Relocate, locate, and dig up Manistee apartments for rent, Manistee rent house, and Manistee Michigan homes for rent by owner.
Relocate, explore, and dig up vacation rentals in Calhoun Michigan, vacation rentals in Calhoun, Calhoun Michigan for rent by owner homes, and rental properties in Calhoun Michigan.
Friends and speculators who are beating about condo rentals in Westland Michigan and are trying to invent house rentals in Westland Michigan, Westland Michigan for rent by owner homes, and vacation rental in Westland Michigan can frisk FRBO.com and our decadent classified ads, loft classifieds, hidden listed properties, and secluded directories.
Uncover, glimpse, and espy vacation rentals and real estate rentals Gladwin Michigan.
Identify, ascertain, and uncover rental properties in Clarksville United States, real estate rentals in Clarksville United States, and Clarksville United States short term rentals.
Observe, identify, and perceive vacation rentals, vacation rentals in Pleasant Lake, and house rentals in Pleasant Lake United States.
Glimpse and design condo rentals Marquette and Marquette Michigan house rentals.
Distinguish, discover, and glimpse rental home in Union Lake United States, rent houses Union Lake, and Union Lake rental properties.
Ferret out and originate home rentals Mackinac Michigan, Mackinac Michigan apartments for rent, condos for rent in Mackinac Michigan, and Mackinac Michigan vacation homes for rent by owner.
We imagined, authored, and erected our page to be exquisite, refined, admirable, and admirable.
Find, identify, and invent apartment rentals in Champion, vacation homes for rent by owner Champion United States, and Champion rental houses.
|
|
