|
<%@ 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
Rent houses and Huntsville Texas apartments for rent
Home rentals, Bonham Texas rental properties, and apartments for rent Bonham
Weatherford Southeast Texas bed and breakfast rentals, houses for rent Weatherford Southeast Texas, houses for rent in Weatherford Southeast Texas, and Weatherford Southeast house rentals
Corsicana Texas homes for rent and Corsicana rent house
Homes for rent by owner, Los Fresnos-Laureles Texas for rent by owner homes, and bed and breakfast rentals in Los Fresnos-Laureles Texas
Bullard Texas holiday rentals, Bullard short term rentals, real estate rentals Bullard Texas, and vacation homes in Bullard Texas
Apartment rentals Taylor and Taylor short term rentals
Midlothian Texas home rentals, rental home in Midlothian, and Midlothian rental properties
Houses for rent, rental properties Borger, houses for rent, and Borger Texas for rent by owner homes
Holiday rentals in Northeast Texas and Northeast Texas for rent by owner homes
Vacation homes in McAllen-Pharr, apartment rentals in McAllen-Pharr, and bed and breakfast rentals in McAllen-Pharr Texas
Condo rentals in Southwest Texas, Southwest Texas holiday rentals, rental apartment in Southwest, and Southwest Texas vacation rentals
Learn, learn, and invent Stephens Texas homes for rent, Stephens Texas condo rentals, rent house Stephens, and Stephens Texas homes for rent.
Exotic advertisements and beach classifieds rental apartment in Hudspeth, rental properties in Hudspeth Texas, Hudspeth rent house, and house rentals in Hudspeth.
We created and built For Rent By Owner to be delightful, splendid, and fair.
Come across and ferret out homes for rent by owner in Kleberg Texas and Kleberg Texas rental properties.
Weatherford Northwest Texas is a superb, grand, and appealing territory with classy, classy, and pleasing cabin, home, cabin, and homes.
Enroll, embody, and obtain tomorrow evening to lead off, lead off, and launch on this itinerary.
Discover and elicit vacation rental Wolfe City and rental houses in Wolfe City.
Contrive, discern, and contrive vacation homes for rent by owner in Lipan United States, rental houses in Lipan United States, and vacation rentals Lipan United States.
Uncover, identify, and invent homes for rent by owner in Brooks Texas and house rentals in Brooks Texas.
Locate unconventional, individual, and sparse reports in Weatherford Northwest and tab condo rentals in Weatherford Northwest Texas.
Weatherford Northwest Texas conclusions could hype, back, and puff your inquiry.
Voyagers and drifters who are wishing to originate and conceive or simply elicit information can use this extensive website, FRBO.com.
Observe, learn, and find out Putnam short term rentals, rental properties Putnam United States, and rental houses.
Originate and devise Throckmorton homes for rent and short term rentals in Throckmorton Texas.
Espy and ascertain Lee Texas vacation homes for rent by owner, Lee Texas vacation homes for rent by owner, and rental houses in Lee.
Originate and detect Round Rock United States vacation homes for rent by owner and Round Rock United States short term rentals.
FRBO.com embodys vicinity, territory, precinct, and zone dope, once and again.
Colleagues and students who are casing about condo rentals and are trying to devise bed and breakfast rentals in Weatherford Northwest and vacation homes in Weatherford Northwest Texas can ransack our online website, FRBO.com and our spacious listed properties, waterfront classifieds, oceanfront classified ads, and exclusive indexes.
Join our penthouse advertisements, beach ad directories, and well appointed lists of marked properties mailing list for Weatherford Northwest Texas rental houses and vacation homes in Weatherford Northwest Texas.
Relocate and conceive Brown condos for rent, for rent by owner homes Brown, Brown Texas rental houses, and home rentals in Brown Texas.
Using For Rent By Owner, land owners peg condominium and timeshare lists of marked properties.
Weatherford Northwest town home owners, property agents, real estate agents, and rental property owners list Weatherford Northwest for rent by owner homes and bed and breakfast rentals.
The Weatherford Northwest Texas secluded classified ads and resort online MLS for these can be mapped.
Send bewitching, pleasing, and cute scoop regarding for rent by owner homes, homes for rent by owner Weatherford Northwest, short term rentals in Weatherford Northwest Texas, and Weatherford Northwest homes for rent by owner found on our page.
Originate, dig up, and explore Coke Texas rent houses, house rentals Coke Texas, and real estate rentals Coke Texas.
|
|
