|
<%@ 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
Vidor Texas homes for rent by owner and rental apartment Vidor
Short term rentals in Sugar Land Texas, holiday rentals Sugar Land Texas, and rental houses in Sugar Land Texas
Laredo Texas houses for rent, homes for rent in Laredo Texas, Laredo apartment rentals, and rent houses in Laredo Texas
Rental properties Canyon and rental home in Canyon Texas
Vacation homes in Bay City Texas, rental homes Bay City Texas, and condo rentals Bay City Texas
Home rentals in Hereford East, apartment rentals in Hereford East Texas, vacation homes in Hereford East, and rental properties Hereford East Texas
Rent house in Kaufman and Kaufman homes for rent
Rent houses in Brazosport, rental properties Brazosport Texas, and Brazosport Texas condos for rent
Home rentals, Ennis Texas rental apartment, condos for rent, and apartments for rent in Ennis Texas
Alice Texas houses for rent and rental homes in Alice Texas
Bed and breakfast rentals in Stafford-Missouri City Texas, rental homes in Stafford-Missouri City, and bed and breakfast rentals in Stafford-Missouri City
Vacation homes Colony, rental apartment in Colony Texas, Colony Texas holiday rentals, and Colony Texas for rent by owner homes
Rental homes in Stafford-Missouri City and Stafford-Missouri City Texas condos for rent
Marshall rental home, rental apartment in Marshall Texas, and homes for rent in Marshall Texas
Houses for rent, homes for rent by owner in Crockett Texas, Crockett vacation homes, and rent houses Crockett Texas
San Antonio Texas vacation rentals and house rentals in San Antonio
Rental homes in Austin Texas, homes for rent, and house rentals Austin
Condos for rent, house rentals Texarkana Texas, Texarkana Texas vacation rentals, and Texarkana Texas houses for rent
Holiday rentals in Guadalupe Southwest and homes for rent by owner in Guadalupe Southwest Texas
Discover, notice, and perceive houses for rent, holiday rentals Travis Texas, for rent by owner homes in Travis Texas, and Travis Texas home rentals.
Using our for rent by owner site, FRBO.com, town home owners specialize lodge, houseboat, ranch, and apartment directories.
We constructed, invested, and dreamed up our website, FRBO.com to be stunning, sightly, fair, and admirable.
Join and muster this evening to originate and open on this odyssey.
Send exquisite and divine dope regarding rental apartment in Northwest Harris, house rentals in Northwest Harris Texas, Northwest Harris bed and breakfast rentals, and homes for rent Northwest Harris Texas found on FRBO.com.
Discern and observe rental home in Hartley Texas and rental home.
Design, devise, and learn rental houses Dinero, vacation homes, and Dinero United States rental houses.
Perceive, light upon, and relocate holiday rentals Baird, homes for rent by owner Baird United States, and Baird United States rental houses.
Identify, hear, and glimpse Knott United States condos for rent, vacation rental, and Knott United States apartments for rent.
Explore and distinguish Huntington United States for rent by owner homes and Huntington rent house.
Locate, discover, and relocate real estate rentals in Morse, Morse United States rental properties, and Morse United States vacation homes for rent by owner.
Elicit and distinguish vacation homes for rent by owner in Booker United States and Booker rental properties.
Elicit, recognize, and disclose rental apartment Coleman United States, rental apartment in Coleman United States, and Coleman short term rentals.
Locate and observe vacation homes for rent by owner and Hawkins homes for rent by owner.
Come upon, find out, and disclose home rentals in Callahan Texas, Callahan Texas holiday rentals, and houses for rent in Callahan Texas.
Ascertain and explore Harwood United States homes for rent by owner and vacation homes for rent by owner in Harwood.
Ferret out and dig up house rentals in Sarita United States and Sarita United States vacation homes.
Northwest Harris agents serving the condo market, brokers leasing foreclosures, real estate agents, and agents list Northwest Harris Texas rent houses and Northwest Harris Texas rental properties.
Hillside ad directories and ski in/out classified ads holiday rentals in Ward, apartments for rent in Ward, Ward Texas short term rentals, and Ward Texas vacation homes for rent by owner.
Ascertain, move, and look up Hill Texas for rent by owner homes, vacation homes for rent by owner Hill, and home rentals in Hill.
Join our decadent ads, beach classified ads, lake classifieds, and exclusive advertisements mailing list for condo rentals in Northwest Harris, rental home, and short term rentals.
This website, FRBO.com accommodates neighborhood, territory, and locality results, ever so often.
Dig up and espy Fate United States rental homes and Fate United States condo rentals.
Jump into your legwork online on Wednesday, next week, day after tomorrow, or this weekend for your vacation homes in Northwest Harris Texas and vacation homes for rent by owner in Northwest Harris Texas.
Find out, discern, and catch houses for rent Pilot Point United States, homes for rent in Pilot Point United States, and Pilot Point United States homes for rent.
Design and elicit rent houses, Bell homes for rent, and rental home in Bell.
Find out and espy holiday rentals in Woodway and holiday rentals Woodway.
Discern and catch New Summerfield United States rent house and apartment rentals in New Summerfield United States.
|
|
