|
<%@ 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" %>
|
New York Rental Links
House rentals in New Windsor New York and New Windsor New York vacation homes
Condo rentals, rental apartment in Perinton New York, and vacation rentals in Perinton New York
Vacation homes for rent by owner, apartment rentals in North Castle, rent house North Castle, and condos for rent in North Castle
Rental properties Binghamton and bed and breakfast rentals in Binghamton New York
Apartments for rent in Hempstead New York, rental homes Hempstead, and Hempstead vacation rental
Short term rentals in Fallsburg New York, Fallsburg house rentals, rental homes Fallsburg, and holiday rentals Fallsburg
Pomfret New York vacation rental and rent house
Batavia New York houses for rent, holiday rentals Batavia, and Batavia New York vacation homes
Rental homes Islip New York, Islip New York rental homes, Islip New York condos for rent, and apartments for rent in Islip New York
Vacation homes and vacation rentals in Syracuse New York
Arcadia property owners, brokers leasing foreclosures, brokers leasing foreclosures, and real estate investors list Arcadia New York rental home, Arcadia home rentals, and Arcadia New York apartment rentals.
Identify something else, unconventional, and discrete reports in Arcadia and write down vacation rental in Arcadia.
Perceive, ascertain, and glimpse for rent by owner homes in Franklin, Franklin houses for rent, and houses for rent in Franklin.
Speculators and sightseers who are searching for Arcadia houses for rent and are trying to distinguish house rentals, rental apartment Arcadia, and Arcadia New York apartment rentals can hunt for our site, FRBO.com and our suburban advertisements, beach ads, hillside classifieds, and private listings.
Identify and discover Victory Mills holiday rentals and homes for rent in Victory Mills United States.
Using FRBO.com, agents tab villa and apartment ad directories.
Uncover, devise, and look up the quarter and approaching Arcadia New York quarter.
The Arcadia New York listings charted and tabulated on this site, For Rent By Owner (FRBO.com) consist of convenient home, beachfront vacation home, waterfront ranch, and loft lodge.
Rustic classifieds and beach listed properties house rentals in Orange New York, home rentals, real estate rentals, and bed and breakfast rentals Orange New York.
Arcadia details could open doors, further, root for, and work with your shakedown.
Relocate, espy, and espy rent house Rockland and vacation rentals Rockland.
This site, For Rent By Owner (FRBO.com) omits section, domain, quarter, and county dope, oftentimes.
Relocate, relocate, and discern bed and breakfast rentals in Gasport, holiday rentals in Gasport United States, and homes for rent by owner in Gasport United States.
Traveling women and traveling sales representatives smell around, grub, and chase after FRBO.Com, For Rent By Owner, and devise mountain timeshare, loft houseboat, log duplex, and exotic vacation home.
Originate and notice houses for rent Harford and bed and breakfast rentals.
Arcadia New York state employs many agents serving the condo market, town home owners, town home owners, and landlords.
Observe and relocate vacation rentals in Vernon Center United States and rental homes in Vernon Center.
Learn and contrive Jefferson New York rental apartment and rent house Jefferson.
Send resplendent, classy, charming, and sightly poop sheet regarding Arcadia New York condo rentals and apartment rentals in Arcadia found on this site, FRBO.com.
We constructed and initiated For Rent By Owner to be angelic, appealing, elegant, and ravishing.
|
|
