|
<%@ 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
Magnolia Texas rent houses and Magnolia Texas rental homes
Apartments for rent, vacation rental West Tom Green, and rental home
Rental home Southwest, Southwest Texas vacation homes for rent by owner, Southwest Texas house rentals, and Southwest Texas rental houses
Houses for rent in La Marque-Hitchcock Texas and vacation rental La Marque-Hitchcock Texas
Burnet Texas real estate rentals, Burnet short term rentals, and home rentals Burnet
Condo rentals, bed and breakfast rentals Seguin, Seguin Texas apartments for rent, and Seguin rent house
Apartment rentals in Georgetown-Round Rock Texas and short term rentals in Georgetown-Round Rock
Marble Falls Texas houses for rent, rental home Marble Falls, and rental houses
Houses for rent South Brazos Texas, vacation homes for rent by owner in South Brazos, rental apartment, and home rentals in South Brazos
Real estate rentals in McAllen-Pharr Texas and for rent by owner homes in McAllen-Pharr Texas
Homes for rent by owner New Boston, homes for rent by owner in New Boston Texas, and holiday rentals in New Boston Texas
Short term rentals, house rentals, home rentals Lampasas Texas, and rental homes in Lampasas Texas
Nacogdoches Texas houses for rent and short term rentals in Nacogdoches Texas
Amarillo homes for rent, Amarillo Texas homes for rent, and for rent by owner homes in Amarillo
Fredericksburg rent houses, vacation rental in Fredericksburg, Fredericksburg Texas rental homes, and bed and breakfast rentals in Fredericksburg Texas
Apartments for rent in Del Rio and Del Rio Texas rent houses
Homes for rent in Northeast Tarrant, real estate rentals, and rental homes
Bed and breakfast rentals in East Cameron Texas, rent houses in East Cameron, holiday rentals East Cameron, and vacation rental in East Cameron Texas
Canyon rental properties and rent houses in Canyon Texas
Northwest Rockwall Texas homes for rent by owner, Northwest Rockwall Texas short term rentals, and rental homes
This site, For Rent By Owner (FRBO.com) can place and muster decadent online MLS and hillside ad directories secluded online MLS, resort ad directories, beach indexes, and waterfront ads to abet your New Boston Texas safari.
Invent, find, and catch real estate rentals Wise and bed and breakfast rentals Wise.
New Boston Texas city employs many real estate agents and landlords.
Using For Rent By Owner, land owners insert castle, apartment, and farmhouse classified advertisements.
Locate and learn Lueders rent house and condo rentals Lueders United States.
Elicit and ferret out Madison Texas condos for rent and Madison Texas bed and breakfast rentals.
Explore, relocate, and notice apartment rentals in Cuero, rent houses, and condos for rent in Cuero.
Disclose and uncover rental apartment in Colorado Texas and apartment rentals Colorado.
Perceive, notice, and elicit Tahoka United States condos for rent, rent house in Tahoka United States, and Tahoka United States rent house.
Come upon, find, and notice for rent by owner homes in Dimmit and home rentals in Dimmit.
Look up distinct, specific, strange, and peculiar scoop in New Boston Texas and tabulate homes for rent.
You can dig up and detect New Boston Texas house rentals and rental home in New Boston Texas.
Find, ascertain, and dig up Moore vacation homes, houses for rent in Moore Texas, and houses for rent Moore Texas.
The New Boston listings charted and enrolled on our page incorporate beach houseboat, log farmhouse, and secluded farmhouse.
Look up and discern rental home in Breckenridge and rental homes Breckenridge United States.
Contrive and invent short term rentals Comal and houses for rent in Comal Texas.
Dig up, detect, and detect homes for rent by owner, homes for rent by owner Montalba United States, and homes for rent by owner in Montalba United States.
You can shake down the penthouse lists of marked properties, beach lists of marked properties, resort advertisements, and oceanfront advertisements under apartment rentals in New Boston Texas and condo rentals in New Boston.
Hear and ascertain Muleshoe United States rental apartment and Muleshoe United States short term rentals.
Perceive, espy, and invent Lampasas Texas house rentals, vacation rentals in Lampasas Texas, and Lampasas house rentals.
Soldiers, spouses, and teachers look over and ransack our for rent by owner website and invent beachfront vacation home, well appointed farmhouse, and decadent apartment.
Assign and enroll this evening to embark on, initiate, take up, and lead off on this peregrination.
Discover and dig up Scurry Texas vacation homes for rent by owner, apartment rentals Scurry, houses for rent Scurry, and rent house Scurry.
Look up, detect, and contrive rental properties in Frost United States, Frost United States rent houses, and rental properties in Frost United States.
Observe and originate vacation homes for rent by owner, Gonzales vacation homes, short term rentals in Gonzales Texas, and rent house in Gonzales Texas.
Move and observe rent house in Hempstead United States and houses for rent Hempstead United States.
Observe and contrive rent house Oilton and houses for rent Oilton United States.
Relocate and identify bed and breakfast rentals in Lane City and vacation rental in Lane City.
Locate and determine condo rentals Gruver United States and rental homes in Gruver United States.
Debunk and come across Guadalupe Texas vacation homes and Guadalupe houses for rent.
Send cute and enticing dossier regarding rental homes New Boston Texas, real estate rentals New Boston, rent house in New Boston Texas, and rental homes New Boston found on our for rent by owner website.
The New Boston Texas penthouse listed properties, loft listings, and spacious ad directories for these can be mapped.
Ascertain, glimpse, and design Jefferson homes for rent, Jefferson condo rentals, rental apartment in Jefferson, and Jefferson Texas rental properties.
Find, hear, and originate Archer Texas vacation homes, Archer Texas homes for rent, and rental apartment in Archer Texas.
Ascertain and dig up Montgomery United States vacation rental and homes for rent.
Deadheads and floaters who are wishing to disclose, explore, and light upon or simply uncover information can use FRBO.Com, For Rent By Owner,.
Notice and observe vacation rentals Matagorda, holiday rentals in Matagorda Texas, and apartment rentals Matagorda.
Occasionally, work with and open doors your fellow workers and romantics to a mesmeric, whopping, and copious principality.
Enter upon your perquisition online on Wednesday, next weekend, or tomorrow morning for your vacation homes and New Boston home rentals.
Locate, come across, and detect Joshua United States apartments for rent, rental home Joshua United States, and rent house in Joshua.
See lakeside classified ads, lakefront online MLS, rustic classified advertisements, and exclusive online MLS that rental owners and real estate investors post on FRBO.com.
Discern, explore, and come upon apartments for rent in Sabine Texas, vacation homes for rent by owner Sabine Texas, and Sabine Texas condo rentals.
Perceive, notice, and recognize Celina United States home rentals, Celina United States for rent by owner homes, and Celina United States real estate rentals.
Contrive and distinguish the turf and not remote New Boston stretch.
New Boston rental owners, third party agents, condo owners, and home owners list rental homes New Boston Texas and apartment rentals.
We formulated and formed our online website, FRBO.com to be graceful, admirable, sightly, and foxy.
Empty secluded vacation home, romantic townhouse, and mountain duplex are not to distant in the not faraway state of New Boston Texas.
New Boston Texas testimony could help, ride shotgun, and assist your research.
|
|
