Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:18:55.943' ,`MLSNumber` = '24543429' ,`ListAgentFullName` = 'Pinky Pirani' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595298' ,`Longitude` = '-95.804469' ,`PhotoCount` = '41' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickshire' ,`StreetNumber` = '6018' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning single-story home with no back neighbors in the desirable community of Kingdom Heights. This home invites you into an open-plan breakfast and family area with windows that envelope the room in natural light plus a sophisticated fireplace to keep you warm during cold winter nights. The kitchen is stunning! Plenty of cabinets, granite countertops, nice backsplash with an island perfect for hosting events. The primary bedroom is spacious with 2 walk-in closet and an ensuite bathroom with a soaking tub. You will absolutely love this home with a study that can also be used as a bedroom. With lots of new upgrades up to $20k. Relax and enjoy in the covered patio with a view of the detailed landscaped backyard with new sprinkler system. This wonderful home is just waiting for you and your family! The house comes with washer/dryer and refrigerator!!!' ,`Acres` = '0.1413' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGDOM HEIGHTS SEC 1, BLOCK 7, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6156' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights Sec 1' ,`TaxAmount` = '5623' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105674' WHERE `Matrix_Unique_ID` = '211333996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T18:39:30.120' ,`MLSNumber` = '50968187' ,`ListAgentFullName` = 'Ruby Polichino' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.321511' ,`Longitude` = '-96.116179' ,`PhotoCount` = '9' ,`PostalCode` = '77488' ,`RoomCount` = '2' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Mattie Street' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is an estate sell. The home on the property is not livable. The seller is wanting to sell the property and home as is. Do not have survey. \r\nProperty has nice trees, an acre to build a home. Great property for investors. Must sell this estate. Must See!\r\n711 Mattie 1.0006 acres. Must see!' ,`Acres` = '1.0006' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WHARTON A.JACKSON BLK.60A LOT 24A, Lot 16' ,`LotDesciption` = 'Other' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wharton Ajackson Blk60a' ,`TaxAmount` = '795' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105675' WHERE `Matrix_Unique_ID` = '211498057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:06:29.723' ,`MLSNumber` = '34348986' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411828' ,`Longitude` = '-95.055858' ,`PhotoCount` = '30' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '519492.00' ,`Status` = 'Active' ,`StreetName` = 'Secret Lagoon' ,`StreetNumber` = '3117' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation P) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '0.1717' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1804' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '2008' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105675' WHERE `Matrix_Unique_ID` = '212096265' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:05:40.460' ,`MLSNumber` = '2115189' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411482' ,`Longitude` = '-95.055458' ,`PhotoCount` = '34' ,`PostalCode` = '77568' ,`RoomCount` = '17' ,`ListPrice` = '549948.00' ,`Status` = 'Active' ,`StreetName` = 'Secret Lagoon' ,`StreetNumber` = '3114' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Wimberly, Elevation A) Lake lot! CURRENTLY BEING BUILT. 4 bedrooms, 3.5 baths. Private Primary Suite downstairs with large walk-in closet. Second bedroom downstairs with private bath. Family room, Study and Formal Dining Room. Spacious island kitchen open to family room. Spacious Game Room and Media Room upstairs. Covered patio and attached 3-car tandem garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '0.1805' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1804' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '2022' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105675' WHERE `Matrix_Unique_ID` = '212139341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:28:16.560' ,`MLSNumber` = '47016265' ,`ListAgentFullName` = 'Dane Gates' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.244649' ,`Longitude` = '-95.574735' ,`PhotoCount` = '49' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '2450000.00' ,`Status` = 'Active' ,`StreetName` = 'Honea Egypt' ,`StreetNumber` = '1822' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '5228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Frank Lloyd Wright Inspired Prairie Style Estate nestled snugly in the piney woods of beautiful Magnolia Texas. Prairie homes seem to bloom from their sites! This elegant home is carefully positioned to ensure maximum privacy while respecting the natural features of the landscape. Tranquil woodland views through frameless windows accented by a natural looking pool/spa, stone waterfall, gardens with native trees, colorful flowers and carefully selected shrubs. Resort stye floorplan with a beautifully appointed open concept island kitchen, wine bar, dining space and family room. Large gameroom up and down. Owners Retreat features a cozy fire, coffee bar, large sitting area, luxurious bath, and custom built closet. Spacious Guest Rooms. Designer paint and finishes. 3 car garage with workshop. Professionally landscaped and fully game fenced with automatic gate. RV hookup. Maintained trails throughout the property. Horses Welcome! Tucked in the forest but just minutes from The Woodlands.' ,`Acres` = '5.09' ,`Area` = '15' ,`BuilderName` = 'Jim O\'Connor' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S861600 - SENDERA RANCH 01, BLOCK 1, LOT 2, ACRES 5.09' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '221720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Sendera Ranch' ,`TaxAmount` = '13159' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105675' WHERE `Matrix_Unique_ID` = '212348463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:05:14.190' ,`MLSNumber` = '96307209' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402870' ,`Longitude` = '-95.070481' ,`PhotoCount` = '10' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '509637.00' ,`Status` = 'Active' ,`StreetName` = 'Sorico Bay' ,`StreetNumber` = '13720' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Bailey III, Elevation F) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room with tall ceilings and wall of windows. Study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and 2-car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1404' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105676' WHERE `Matrix_Unique_ID` = '212526048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:07:19.393' ,`MLSNumber` = '26969315' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361701' ,`Longitude` = '-95.388687' ,`PhotoCount` = '28' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Hills' ,`StreetNumber` = '12230' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Deer Trail Estates -SOUGHT AFTER VALLEY BREEZE plan 1/3 acre lot-4 BEDROOMS, GAMEROOM, STUDY - island kitchen –\r\nback patio - very well-designed floorplan. It even has the all-important home office (first floor study). Attractive front elevation\r\nwith 2 and could be 3 car garage. The 2nd floor master has a lovely bathroom with a large semi frameless shower, great\r\nstorage, and a large walk-in master closet. The island kitchen has beautiful cabinets and granite countertops look towards the\r\nfamily room. 3 secondary bedrooms are located upstairs. They share a spacious bath, and both have great closet spaces. This\r\none is ready now, so come and visit the sales office (ASK ABOUT ANY BUILDER SPECIALS) at 12376 North Chestnut Hills, in\r\nConroe. The sales office is open from 10:00 AM to 6:00 PM (Mon, Thurs, Fri, Sat), and 12:00 noon to 6:00 PM on Sunday.' ,`Acres` = '0.3673' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEER TRAIL ESTATES 03, BLOCK 3, LOT 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '16000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105676' WHERE `Matrix_Unique_ID` = '212558047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:23:29.107' ,`MLSNumber` = '57612857' ,`ListAgentFullName` = 'Sheri Morris' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984136' ,`Longitude` = '-95.112341' ,`PhotoCount` = '28' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Point' ,`StreetNumber` = '1714' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back corner of lot on 3rd hole of golf course. Oversized back patio with large covered deck perfect for entertaining outdoors! Recently updated interior features a beautiful, open family room with vaulted 15\' ceiling and wet bar that passes through to game room. Fireplace is double-sided opening up to family room and game room in front of the home. Kitchen is bright with painted cabinets, 4-burner gas range with middle griddle gas with griddle & combo electric/convection oven and microwave. The kitchen also opens to breakfast in back of home and formal dining in front of home. Primary bath with double undermount sinks, granite countertops, shower only and dual closets. Fully operational security system with cameras around property & an in-line Generac back-up generator so never go without power! Replaced all electrical outlets, switches, and lighting fixtures including electrical panel box and updated all interior hardware. All repairs & maintenance up to date with receipts.' ,`Acres` = '0.3544' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 27 INDIAN SHORES SEC 4' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '15438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '90' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Shores Sec 04' ,`TaxAmount` = '5706' ,`TaxRate` = '2.5873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105676' WHERE `Matrix_Unique_ID` = '213097750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:04:47.890' ,`MLSNumber` = '36595727' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409381' ,`Longitude` = '-95.056185' ,`PhotoCount` = '30' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '519816.00' ,`Status` = 'Active' ,`StreetName` = 'Deep Marine' ,`StreetNumber` = '12919' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation P) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '0.1906' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8303' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1804' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '2028' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105676' WHERE `Matrix_Unique_ID` = '213107089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T18:35:56.330' ,`MLSNumber` = '84502561' ,`ListAgentFullName` = 'John Branch' ,`ListOfficeName` = 'Cynthia Tibbs Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.653735' ,`Longitude` = '-95.503453' ,`PhotoCount` = '7' ,`PostalCode` = '77035' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Meadow' ,`StreetNumber` = '6403' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful place to call home, Quail Meadow is a family style traditional home with remolded quartz kitchen countertops, stainless steel hardware, remolded bathrooms, a stacked stone fire place, backyard big enough for a swimming pool, as well as a patio connected to the master bedroom.' ,`Acres` = '0.1476' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 SOUTHWOOD PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HALPIN/TINSLEY' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwood Place' ,`TaxAmount` = '3141' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105676' WHERE `Matrix_Unique_ID` = '213180250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T18:24:49.713' ,`MLSNumber` = '73182118' ,`ListAgentFullName` = 'Corin Gascon' ,`ListOfficeName` = 'INNOVA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594039' ,`Longitude` = '-95.215562' ,`PhotoCount` = '35' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Sagedowne' ,`StreetNumber` = '11218' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Come check out this fabulous 4 bedroom 2 bath home! Completely renovated. This beautiful home features an open concept, new windows, all new electrical wiring, new gas water heater, granite countertops and new cabinets. Beyond a functional entryway space, the home flows into a luminous, open- concept dining, kitchen area and a nice sized living room. Enjoy the Spacious Backyard perfect for Kids & Pets.' ,`Acres` = '0.2938' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 18 SAGEMONT SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '174' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Left Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 05' ,`TaxAmount` = '2467' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105677' WHERE `Matrix_Unique_ID` = '214152320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T18:58:15.293' ,`MLSNumber` = '2303426' ,`ListAgentFullName` = 'Caroline Morrison' ,`ListOfficeName` = 'Keystone Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.241569' ,`Longitude` = '-95.720693' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '755000.00' ,`Status` = 'Active' ,`StreetName` = 'Mill' ,`StreetNumber` = '41121' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING home situated on 2.68 secluded acres! It is a staycation every day at this property with a breathtaking backyard featuring a saltwater pool with rock features, a swim-in grotto waterfall, hot tub, and multi color LED lighting! HVAC system replaced 2016, roof replaced 2016, Leaf Guard Lifetime gutters added 8/2020, added whole home generator 6/2020, carport (not pictured) added 2016, exterior of home painted 9/2022, interior painted in main living areas 9/2022, new gas range 7/2022, wall mounted garage door opener added 2016 (for big door). Home has 2 primary bedrooms with en-suite bathrooms! Fully remodeled garage apartment with full bathroom, kitchen and private covered balcony 9/2021! Come take a look, I know you will fall in love!' ,`Acres` = '2.68' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'MILL CREEK LANDING 01, BLOCK 1, LOT 1A,1-B-1, ACRES 2.680' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '116741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Landing 01' ,`TaxAmount` = '8273' ,`TaxRate` = '1.9722' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105677' WHERE `Matrix_Unique_ID` = '214357581' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-06T17:02:59.677' ,`MLSNumber` = '6242207' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402574' ,`Longitude` = '-95.069174' ,`PhotoCount` = '32' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '519827.00' ,`Status` = 'Active' ,`StreetName` = 'Sorico Bay' ,`StreetNumber` = '13605' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7793' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1404' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105677' WHERE `Matrix_Unique_ID` = '214668232' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215559603','1675105677','215559603','2023-01-06T18:29:58.430','14786419','Valery Smith-Blank','RE/MAX Integrity','','','30.278398','-95.476409','28','77304','10','779000.00','Active','Marble Garden','209','Lane','Conroe','3','1','3','3289','Single-Family','CUSTOM MODEL HOME FOR SALE WITH FURNISHINGS! Study & Living Room feature 12\' ceilings & built in cabinetry. Very open floor plan w/lots of natural light. The gourmet kitchen is beautiful w/custom cabinetry, lg. pantry, huge center island, BOSCH stainless appliances-incl., double ovens, 5 Burner Cooktop. Primary Bedroom Retreat is HUGE w/a great sitting area & primary bath w/double sinks, separate shower, over-sized tub. Huge closet. All bedrooms have separate baths. Lg. covered back porch with an outdoor kitchen. HUGE TX Basement w/easy stair access. Model offers over $108,000 in Upgrades, $30,000 Lot Premium, all model furnishings, construction office as it is (193 sq ft) or buyer can opt to have it converted to a 3 car tandem garage. NO FLOODING.','','19','Jaeger Homes, Inc.','','Electric Dryer Connections,Washer Connections','','Mud','1','Gas Connections,Gaslog Fireplace','1','Conroe Southwest','Central Gas,Zoned','1','S537506 - Grand Central Park 06, BLOCK 1, Lot 18','Subdivision Lot','16827','Appraisal District','','1075','0','','0','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Grand Central Park','18518','3.2585','Public Sewer,Water District','2016','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215630492','1675105677','215630492','2023-01-06T17:43:37.667','10513125','Mackella Rohan','FYI Realty-Katy','','','29.829284','-95.475757','12','77092','6','315000.00','Active','Lou Anne','4123','Lane','Houston','1','1','3','1274','Single-Family','Welcome home to 4123 Lou Anne Ln in the highly sought after Oak Forest subdivision. Home has been beautifully updated and the open floor plan is a dream for entertaining. Delight in the completely remodeled chef\'s kitchen and enjoy the relaxing expansive patio and back yard. Easy access to major freeways.','0.1885','9','','','Gas Dryer Connections','','Sellers Disclosure','1','','0','Oak Forest West Area','Central Gas','0','LT 6 BLK 17 OAK FOREST SEC 17 R/P','Subdivision Lot','8211','Appraisal District','','','0','','2','Gas Oven','0','','','','','Composition','27 - Houston','WAINWRIGHT ELEMENTARY SCHOOL','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Ranch','Oak Forest Sec 17 R/P','5289','2.3307','Public Sewer','1967','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216070227','1675105678','216070227','2023-01-06T17:23:08.000','88808927','Jared Turner','LennarVillageBldr-JaredTurner','','','30.095456','-95.184316','6','77365','7','270000.00','Active','Delancey Bend','3004','Way','Porter','2','0','4','1538','Single-Family','NEW! \"San Luis II C\" floor plan from the Gulf Coast collection by Lennar in Royal Brook. This single-story home has a smart layout for growing families. Three bedrooms share a hall bathroom at the back of the home and the owner’s suite is in the front with a full bathroom. Beside it is the open concept living area with a family room, modern kitchen, breakfast nook and covered patio.\r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.','','32','Lennar','','','','Mud','','','','Kingwood East','Central Gas','1','SEC 0019 BLK 002 LOT 012','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','','','0','','','','','Composition','29 - Humble','ELM GROVE ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Kingwood Royal Brook','','2.58','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216117703','1675105678','216117703','2023-01-06T18:23:29.610','98993325','Daniel Amaya','Jason Mitchell Real Estate LLC','','','30.300548','-95.499160','31','77304','3','240000.00','Active','Maple','339','Lane','Conroe','2','0','3','1453','Single-Family','Great opportunity to own in the beautiful Artesian Forest community in Conroe! This Home features 3 bedrooms, 2 full bathrooms, tile and carpet flooring throughout, a fireplace, and a 2 car garage. Upon entering you are greeted with a fireplace view, followed by a spacious kitchen, breakfast area, and living areas, with lots of character throughout the Home! Enjoy your extended private back patio area with no back neighbors, great for hosting Family and Friends! Also quickly access I45 freeway, putting you minutes away from Lake Conroe, shopping, and dining just minutes from The Woodlands Mall. Schedule your tour today!','0.2916','19','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Conroe Southwest','Central Gas','0','ARTESIAN FOREST 02, LOT 35','Subdivision Lot','12700','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','11 - Conroe','RICE ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Right Side,Vacant/Unoccupied','Appraisal District','1','Traditional','Artesian Forest 02','3191','2.1863','Public Sewer,Public Water','1973','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216136124','1675105678','216136124','2023-01-06T17:32:46.543','33604842','Jeremy Fain','Greenwood King Properties','','','29.686389','-95.237329','10','77017','8','199900.00','Active','Sweetbriar','5518','Street','Houston','2','0','3','1146','Single-Family','Cozy 3 bedroom 2 bathroom home in the heart of Pecan Park. Lovely open floor plan with combined living and dining spaces along with a well equipped kitchen. A spacious en-suite primary bedroom is accompanied by two generous sized secondary bedrooms which share the communal powder room. Situated on a sizable lot the front and back yard spaces easily lend themselves to sizable gatherings.','0.1505','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Hobby Area','Central Gas','0','TRS 19 & 21A BLK 24 FOREST OAKS','Subdivision Lot','6555','Appraisal District','','','0','','0','Electric Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','PATTERSON ELEMENTARY SCHOOL (HOUSTON)','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Forest Oaks','2849','2.3307','Public Sewer,Public Water','1948','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216138495','1675105678','216138495','2023-01-06T17:17:31.910','98435838','Justin Dickey','Keller Williams Professionals','','','29.405875','-95.059823','20','77568','10','299990.00','Active','Dalvay Beach','13114','Drive','Texas City','2','0','4','1605','Single-Family','CHARMING 1 STORY COLINA HOME WITH 1605 SQUARE FEET, OPEN CONCEPT-4 BEDROOM, 2 BATH HOME WITH STORMY NIGHT GRANITE KITCHEN COUNTERTOPS, BUILDER\'S CHOICE WHITE-42\" CABINETS WITH CROWN MOULDING, 9\' SINGLE BOWL KITCHEN SINK, FRIGIDAIRE STAINLESS STEEL APPLIANCES WITH 5 BURNER GAS STOVE, 6X24 TILE FLOORING EVERYWHERE EXCEPT BEDROOMS, BUILT IN TAEEZX PEST CONTROL, RINNAH TANKLESS WATER HEATER, FRONT GUTTERS, PEX PLUMBING, LENNOX SEER 16 A/C, BACK COVERED PORCH, CORDLESS FAUX WOOD BLINDS THROUGHOUT, DOUBLE VANITIES IN MASTER BATH, SUPER SIZED SHOWER IN MASTER, BUILT IN SHELVES IN MASTER CLOSET, READY IN DECEMBER! NO BACK NEIGHBORS! Photos are Representative!!','','33','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Texas City','Central Gas','1','Lot 13 Block 2 Section 3','Subdivision Lot','5400','Survey','','1330','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','1','Traditional','Lago Mar','','3.55','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216145899','1675105678','216145899','2023-01-06T18:43:25.003','67225889','Dorothy Watts','Martindale Real EstateInvestments','','','30.774540','-94.423575','31','75979','7','149900.00','Active','South Pecan','108','','Woodville','1','0','3','1462','Single-Family','Adorable home in the city limits of Woodville. This 3 bedroom 1 bath has lots of storage and is super cute.. Living room is very large with fireplace and lots of windows. Back porch has a new metal roof for you to sit and enjoy.. Lot has nice large trees and also has a fenced back yard and 2 buildings for storage or for a shop. Large utility room with more closet shelves for storage. Must see to appreciate.','','48','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Tyler County','Central Gas','0','A0657 J. Wheat Block 69 C Acres 0.8220','Cleared','','','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','253 - Woodville','WHEAT ELEMENTARY SCHOOL','WOODVILLE HIGH SCHOOL','WOODVILLE MIDDLE SCHOOL','Appointment Required,Lockbox Back,Vacant/Unoccupied','Appraisal District','1','Ranch','N/A','','','Public Sewer,Public Water','1960','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216154886','1675105678','216154886','2023-01-06T17:06:47.257','58541978','Emily Wang','Intown Homes','','','29.816086','-95.507832','9','77080','8','750000.00','Active','Oak Kolbe','8720','Lane','Houston','4','1','4','3298','Single-Family','ELEVATOR LAKEVIEW 4 BEDROOM HOME w/ FANTASTIC VIEWS and OUTDOOR AREAS!!! THIS is the LAST CHANCE to get a NEW CONSTRUCTION home on the SOUTHSIDE of the LAKE in KOLBE FARMS. FENCED-IN FRONT YARD opens to TRAILS AROUND the 3 ACRE LAKE/PARK AREA! YOU get TWO sets of the MAGNIFICENT TRI-PANELD GLASS DOORS: 1) LAKESIDE LIVING ROOM BALCONY 2) LAKESIDE COVERED TERRACE off from GAMEROOM. 8720 OAK KOLBE is DECKED OUT: 48 INCH Gas Range, INSET+SOFT CLOSING CABINETRY, 12 FT Living Room Ceilings, SOPHISTICAED ELECTRIC FIREPLACE - You can change the FLAME COLOR, WIDE PLANK WOOD Flooring - Living Area, Stairs, First Floor Bedroom & Primary Bedroom, FREE STANDING TUB, DOUBLE SEATED SHOWER + so MUCH MORE! YOU NEED TO SEE KOLBE FARMS -40 ACRE COMMUNITY; ANTI- COOKIE CUTTER - 100 FLOOR PLANS built so far. KOLBE has Lake, Trails, Two Pools, Dog Park, Courtyards, Galvanized Bridge, Gated, Gate Station is Manned at Night! 8720 is estimated to be finished in SPRING 2023. REMEMBER LAST CHANCE!','','24','InTown Homes','','','','No Disclosures','1','','1','Spring Branch','Central Gas','1','LT 27 BLK 4 KOLBE FARMS','Water View','1950','Appraisal District','','2554','1','To Be Built/Under Construction','2','Freestanding Oven','0','','','Gas Range','','Other','49 - Spring Branch','EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Builder','4','Other Style,Traditional','Kolbe Farms','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216156364','1675105678','216156364','2023-01-06T18:52:56.817','62795283','Ryan Moody','RE/MAX Leading Edge','','','29.270373','-94.879589','50','77554','7','815000.00','Active','103rd','1220','Street','Galveston','2','0','3','2519','Single-Family','Incredible paradise home situated in the Crash Boat Basin showcasing STUNNING views of Galveston Bay and gorgeous sunsets. This entertainer\'s dream home offers many features including: hardi siding, updated bathrooms, elevator/lift to all floors, woodburning fireplace, Hunter plantation interior blinds, plenty of garage space, laundry room on ground floor as well as upstairs. Open living & dining areas look out to the sweeping Bay views from several windows. Large Master retreat with oversized vanity and double sinks. Beautiful subway tiled shower. Screened in porch with catwalk to the deck above the boat house. Outdoor shower. Spacious ground floor bedroom, half bath, and washer and dryer complete this lovely bay home. Your guests will wake up to amazing views and never want to leave ??. Schedule your showing today!!!','0.0976','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Near West End','Central Electric','0','ABST 121 HALL & JONES SUR LOT 28 AIRPORT HOMESITES SEC 4','In Golf Course Community,Water View,Waterfront','4250','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','2','Traditional','Airport Homesites 4','7500','2.0161','Public Sewer,Public Water','1989','Appraisal District'); --> New record created successfully