|
<%@ 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" %>
|
Texas Rental Links
Rental apartment in North Randall Texas and North Randall Texas condos for rent
Decatur vacation homes, Decatur condos for rent, and rental houses in Decatur Texas
Vacation homes in Midland, Midland Texas short term rentals, bed and breakfast rentals Midland Texas, and condo rentals in Midland Texas
Home rentals Huntsville and house rentals Huntsville
Condo rentals in San Antonio, apartments for rent San Antonio, and San Antonio rent houses
Rental homes Bastrop, vacation rental, home rentals in Bastrop Texas, and Bastrop Texas vacation homes for rent by owner
Holiday rentals Stephenville and short term rentals in Stephenville
Huntsville vacation rental, Huntsville Texas rental houses, and rental houses in Huntsville
Houses for rent in South Brazos Texas, home rentals in South Brazos Texas, homes for rent by owner South Brazos, and rent houses South Brazos
Rental homes Bryan-College Station Texas and Bryan-College Station Texas real estate rentals
Homes for rent by owner in Waller Texas, holiday rentals, and homes for rent in Waller Texas
Apartment rentals Alice, Alice Texas vacation homes, rent house Alice, and rental houses Alice Texas
Short term rentals in Cleveland Texas and vacation rentals
Edcouch-Elsa Texas bed and breakfast rentals, rental houses Edcouch-Elsa, and Edcouch-Elsa houses for rent
Weatherford Northwest Texas rental apartment, Weatherford Northwest vacation homes, vacation homes Weatherford Northwest Texas, and Weatherford Northwest Texas apartments for rent
Vacation rental in Southeast Harris Texas and Southeast Harris Texas condos for rent
East Grayson Texas vacation rental, rental homes in East Grayson, and holiday rentals East Grayson
Tyler Texas homes for rent by owner, Tyler home rentals, Tyler homes for rent by owner, and Tyler Texas vacation homes for rent by owner
Rental homes in Lubbock and Lubbock Texas rental properties
Liberty-Dayton Texas for rent by owner homes, homes for rent Liberty-Dayton, and rent houses in Liberty-Dayton Texas
Observe, contrive, and observe rent house Ledbetter United States, Ledbetter United States homes for rent, and rent houses in Ledbetter United States.
The Tyler East Texas directories charted and kept counted on our for rent by owner website hold lakeside cabin, lakeside cabin, romantic farmhouse, and loft timeshare.
Elicit, come across, and locate rental homes in Smith Texas and rental homes in Smith Texas.
Acquaintances, migrants, and commuters who are wishing to perceive and notice or simply discern information can use our for rent by owner site, FRBO.com.
Recognize, catch, and disclose Howard Texas condos for rent, vacation rental Howard, rental home in Howard Texas, and house rentals in Howard Texas.
FRBO.Com, For Rent By Owner, does seat several stretch loft, mountain, lakefront, and resort houseboat and condominiums.
Private online MLS and secluded online MLS rental apartment Medina, Medina Texas apartments for rent, Medina apartments for rent, and rental homes in Medina.
Discover and locate home rentals Salado United States and holiday rentals Salado.
Find out, originate, and ferret out house rentals in Clay Texas and Clay rent house.
Light upon and locate apartment rentals in Wildorado United States and houses for rent in Wildorado.
Look up and invent condos for rent El Paso Texas, vacation homes El Paso, and vacation homes.
You can catch and learn rent house, Tyler East vacation homes for rent by owner, and Tyler East Texas rental apartment.
Catch, conceive, and distinguish houses for rent in Howard, homes for rent in Howard Texas, and apartments for rent Howard.
The Tyler East Texas mountain classifieds, mountain ad directories, penthouse directories, and romantic listed properties for these area can be mapped.
Send nice, pretty, and fine details regarding apartment rentals Tyler East Texas and Tyler East Texas real estate rentals found on For Rent By Owner.
Observe, detect, and look up real estate rentals, Springlake rent houses, and rental apartment in Springlake United States.
Determine, catch, and perceive Dickens Texas vacation homes for rent by owner and Dickens Texas vacation homes for rent by owner.
Conceive and identify houses for rent in Willacy, holiday rentals, rental apartment, and Willacy Texas homes for rent by owner.
Join our hidden online MLS and oceanfront directories mailing list for apartments for rent Tyler East, rental properties in Tyler East Texas, and for rent by owner homes.
Tyler East Texas is a exquisite, delightful, and nice tract with magnificent, fine, resplendent, and gorgeous vacation home, apartment, cabin, and bungalows.
Soldiers, entrepreneurs, and occupants who are inspecting rent house in Tyler East Texas and are trying to determine Tyler East Texas short term rentals and rental properties in Tyler East Texas can forage this site, For Rent By Owner (FRBO.com) and our lakeside classified ads and beach online MLS.
Distinguish, relocate, and find out Sublime vacation rentals, Sublime United States vacation rentals, and for rent by owner homes Sublime United States.
Light upon and distinguish home rentals Denison and house rentals.
Explore and devise rental homes and rental houses.
Globetrotters and trekkers grub, hunt, and frisk For Rent By Owner and glimpse lake home, beachfront house, resort villa, and lake duplex.
|
|
